W tabeli zrób także nick
+ zmienna test[3][33]
public sql_load(id)
{
new szTemp[512]
new data[1]
data[0] = id
formatex(szTemp,charsmax(szTemp),"SELECT * FROM `x` WHERE `name` = '%s'",nick_gracza[id])
SQL_ThreadQuery(g_SqlTuple,"add_client",szTemp, data, sizeof(data))
}
public add_client(failstate, Handle:query, error[],errcode, data[], datasize)
{
if(failstate != TQUERY_SUCCESS){
log_amx("<Query> Error: %s", error);
return;
}
new id = data[0];
if(!is_user_connected(id) && !is_user_connecting(id))
return;
if(SQL_NumRows(query))
{
test[0][id] = SQL_ReadResult(query, SQL_FieldNameToNum(query,"zloto"))
test[1][id] = SQL_ReadResult(query, SQL_FieldNameToNum(query,"srebro"))
test[2][id] = SQL_ReadResult(query, SQL_FieldNameToNum(query,"braz"))
WczytaneDane[id] = true
}
else
{
new szTemp[512], data[1]
data[0] = id
formatex(szTemp,charsmax(szTemp),"INSERT INTO `x` (`name`,`test`,`test1`,`test2`) VALUES ('%s','%d','%d','%d')", nick_gracza[id], test[0][id],test[1][id],test[2][id])
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandleInsert",szTemp,data, 1)
}
}
Użytkownik speedkill edytował ten post 10.03.2012 19:30