| spamipolito |
07-01-2020 15:17 |
Re: loop sql select
PHP Code:
#define MAX_SKINS 4
public LoadSkins(const id) { static szQuery[256], szData[1]
new iLen = 0;
iLen += formatex( szQuery[ iLen ], charsmax( szQuery ) - iLen, "SELECT ")
for(new i=0; i <= MAX_SKINS;i++) iLen += formatex( szQuery[ iLen ], charsmax( szQuery ) - iLen, "`F%d`%s ", i, i == MAX_SKINS ? "" : ",")
iLen += formatex( szQuery[ iLen ], charsmax( szQuery ) - iLen, "FROM `accounts` WHERE `PlayerID`='%d'", get_user_authid(id) )
szData[0] = id;
SQL_ThreadQuery(g_SqlTuple,"sql_piece_of_skins_thread", szQuery, szData, 1); }
public sql_piece_of_skins_thread(FailState,Handle:Query,Error[],Errcode,szData[],DataSize) { if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED) { log_amx("%s", szError) return } else { new id = iData[0]
for(new i=0;i <= MAX_SKINS;i++) DB_skins[i][id] = SQL_ReadResult(Query, i /*Colum Num*/); inventory(id); } }
public TestConsult(const id) { // Use register_clcmd to testing consult. Return console print new iLen = 0 new szQuery[256]
iLen += formatex( szQuery[ iLen ], charsmax( szQuery ) - iLen, "SELECT ")
for(new i=0; i <= MAX_SKINS;i++) iLen += formatex( szQuery[ iLen ], charsmax( szQuery ) - iLen, "`F%d`%s ", i, i == MAX_SKINS ? "" : ",")
iLen += formatex( szQuery[ iLen ], charsmax( szQuery ) - iLen, "FROM `accounts` WHERE `PlayerID`='%d'", 3 )
console_print(id, "%s", szQuery)
}
Share the structure of the database "accounts"
|