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"