PHP Code:
new Data[1]
Data[0] = id
format(g_Query, 4095, "SELECT * from arp_familybank WHERE Familyname='%s'", g_FamilyName[id])
SQL_ThreadQuery(g_SqlHandle,"LoadBank",g_Query,Data,1)
PHP Code:
public LoadBank(FailState, Handle:Query, Error[], Errcode, Data[], Datasize, id)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("Could not connect to SQL database.")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("Internal error: consult developer.")
if(Errcode)
return log_amx("Error on query: %s",Error)
id = Data[0]
new Plat, Bankmoney
while(SQL_MoreResults(Query))
{
SQL_ReadResult(Query, 1, Bankmoney)
SQL_ReadResult(Query, 2, Plat)
g_BankMoney[id] = Bankmoney
g_BankPlat[id] = Plat
SQL_NextRow(Query)
}
for(new x; x<33; x++)
if(g_IsInFamily[x] && equali(g_FamilyName[id], g_FamilyName[x]))
{
g_BankPlat[x] = Plat
g_BankMoney[x] = Bankmoney
}
return PLUGIN_CONTINUE
}
This somehow reads the result badly. Plat and Bankmoney are like 12561268646, but it has to be for example 1000. In table it's okay, but, as I said, it reads it badly. I don't know why, at first I thought it takes the result as a string, but it doesn't from what I've read. str_to_num() doesn't work.
Edit:
The table structure is like this:
CREATE TABLE IF NOT EXISTS arp_familybank (Familyname VARCHAR(36), Stav VARCHAR(10), Plat VARCHAR(10), PRIMARY KEY (Familyname))
I want to return second column into "Bankmoney" and third one into "Plat".