| Backstabnoob |
06-03-2010 13:04 |
Wrong reading from SQL
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".
|