create table Accounts(Name text not null, Password text not null, Money text not null, xp text not null, Creation text not null, LastUsed text not null) 
create table Accounts(Name text not null, Password text not null, Money text not null, xp text not null, Creation text not null, LastUsed text not null) INTEGER for Money and XP, and DATETIME for LastUsed and Creation ?
1 
create table Accounts(Name text not null, Password text not null, Money text not null, xp text not null, Creation text not null, LastUsed text not null) 
INTEGER for Money and XP, and DATETIME for LastUsed and Creation ? 
1
20 years ETA? letsgo!
2
2
1 
now it works properly
char aBuf[2400];
str_format(aBuf, sizeof(aBuf),
"SELECT l.ID, Name, Time, Ranking, PercentRank "
"FROM (" // teamrank score board
" SELECT RANK() OVER w AS Ranking, PERCENT_RANK() OVER w AS PercentRank, ID "
" FROM %s_teamrace "
" WHERE Map = ? "
" GROUP BY ID "
" WINDOW w AS (ORDER BY Min(Time))"
") AS TeamRank INNER JOIN (" // select rank with Name in team
" SELECT ID "
" FROM %s_teamrace "
" WHERE Map = ? AND Name = ? "
" ORDER BY Time "
" LIMIT 1"
") AS l ON TeamRank.ID = l.ID "
"INNER JOIN %s_teamrace AS r ON l.ID = r.ID ",
pSqlServer->GetPrefix(), pSqlServer->GetPrefix(), pSqlServer->GetPrefix());
if(pSqlServer->PrepareStatement(aBuf, pError, ErrorSize))
{
return true;
}
pSqlServer->BindString(1, pData->m_aMap);
pSqlServer->BindString(2, pData->m_aMap);
pSqlServer->BindString(3, pData->m_aName); Bindstring prevents SQL injection.
1 1char aBuf[2400];
str_format(aBuf, sizeof(aBuf),
"SELECT l.ID, Name, Time, Ranking, PercentRank "
"FROM (" // teamrank score board
" SELECT RANK() OVER w AS Ranking, PERCENT_RANK() OVER w AS PercentRank, ID "
" FROM %s_teamrace "
" WHERE Map = ? "
" GROUP BY ID "
" WINDOW w AS (ORDER BY Min(Time))"
") AS TeamRank INNER JOIN (" // select rank with Name in team
" SELECT ID "
" FROM %s_teamrace "
" WHERE Map = ? AND Name = ? "
" ORDER BY Time "
" LIMIT 1"
") AS l ON TeamRank.ID = l.ID "
"INNER JOIN %s_teamrace AS r ON l.ID = r.ID ",
pSqlServer->GetPrefix(), pSqlServer->GetPrefix(), pSqlServer->GetPrefix());
if(pSqlServer->PrepareStatement(aBuf, pError, ErrorSize))
{
return true;
}
pSqlServer->BindString(1, pData->m_aMap);
pSqlServer->BindString(2, pData->m_aMap);
pSqlServer->BindString(3, pData->m_aName); 
str_format, you would run into problems if the input data contains characters used for the SQL syntax, e.g. '. Let's say some guys player name is hi', you would get an invalid query because you have an unmatched quotation mark. 1str_format, you would run into problems if the input data contains characters used for the SQL syntax, e.g. '. Let's say some guys player name is hi', you would get an invalid query because you have an unmatched quotation mark. 
2024-03-03 23:38:09 I client: connecting to '37.230.210.231:8320'
2024-03-03 23:38:09 I host_lookup: host='37.230.210.231' port=8320 3
2024-03-03 23:38:09 I client: connected, sending info
2024-03-03 23:38:09 I datafile: could not open 'maps/Vacando.map'
2024-03-03 23:38:09 I serverbrowse_http: found master, url='https://master2.ddnet.org/ddnet/15/servers.json' time=2273ms
2024-03-03 23:38:09 I chat: *** '(3)Matodor' entered and joined the game
2024-03-03 23:38:09 I chat: *** DDraceNetwork Mod. Version: 0.6.4, 18.0.3
2024-03-03 23:38:09 I chat: *** please visit DDNet.org or say /info and make sure to read our /rules
2024-03-03 23:38:09 I chat: *** Welcome to DDraceNetwork!
2024-03-03 23:38:09 I chat: *** You are now in a solo part
2024-03-03 23:38:10 I assert: /home/deen/isos/ddnet/ddnet-source/src/base/system.cpp(4587): Invalid UTF-8 passed to windows_utf8_to_wide 
2024-03-03 23:38:09 I client: connecting to '37.230.210.231:8320'
2024-03-03 23:38:09 I host_lookup: host='37.230.210.231' port=8320 3
2024-03-03 23:38:09 I client: connected, sending info
2024-03-03 23:38:09 I datafile: could not open 'maps/Vacando.map'
2024-03-03 23:38:09 I serverbrowse_http: found master, url='https://master2.ddnet.org/ddnet/15/servers.json' time=2273ms
2024-03-03 23:38:09 I chat: *** '(3)Matodor' entered and joined the game
2024-03-03 23:38:09 I chat: *** DDraceNetwork Mod. Version: 0.6.4, 18.0.3
2024-03-03 23:38:09 I chat: *** please visit DDNet.org or say /info and make sure to read our /rules
2024-03-03 23:38:09 I chat: *** Welcome to DDraceNetwork!
2024-03-03 23:38:09 I chat: *** You are now in a solo part
2024-03-03 23:38:10 I assert: /home/deen/isos/ddnet/ddnet-source/src/base/system.cpp(4587): Invalid UTF-8 passed to windows_utf8_to_wide 2024-03-03 23:40:51 I chat: *** '(1)Tas' entered and joined the game
2024-03-03 23:40:53 I chat: *** '(1)Tas' has left the game (Timeout Protection used)
2024-03-03 23:40:54 I chat: *** '(1)dr3aM' has left the game (Too weak connection (not acked for 100 seconds))
2024-03-03 23:40:54 I chat: *** '(1)Rayyan_78' has left the game (Too weak connection (not acked for 100 seconds))
2024-03-03 23:40:54 I chat: *** '(1)Matodor' has left the game (Too weak connection (not acked for 100 seconds))
2024-03-03 23:40:55 I chat: Xteriche²: BRONIVIK: жив?
2024-03-03 23:40:56 I chat: *** '(1)-Cuck?♥' has left the game (Too weak connection (not acked for 100 seconds))2024-03-03 23:40:51 I chat: *** '(1)Tas' entered and joined the game
2024-03-03 23:40:53 I chat: *** '(1)Tas' has left the game (Timeout Protection used)
2024-03-03 23:40:54 I chat: *** '(1)dr3aM' has left the game (Too weak connection (not acked for 100 seconds))
2024-03-03 23:40:54 I chat: *** '(1)Rayyan_78' has left the game (Too weak connection (not acked for 100 seconds))
2024-03-03 23:40:54 I chat: *** '(1)Matodor' has left the game (Too weak connection (not acked for 100 seconds))
2024-03-03 23:40:55 I chat: Xteriche²: BRONIVIK: жив?
2024-03-03 23:40:56 I chat: *** '(1)-Cuck?♥' has left the game (Too weak connection (not acked for 100 seconds)) 
