Code:
new authid[32], vaultstring[256];
new query[256]
get_user_authid(id,authid,31)
if (mySql == SQL_OK) {
new savewages, savemoney, savebank, savepayroll
new savejob[32]
savewages = employedwages[id]
savemoney = usermoney[id]
savebank = userbank[id]
savepayroll = employedpayroll[id]
format(savejob,31,"%s",employedjob[id])
format(query,255,"UPDATE economy SET wages=%i WHERE steamid = %s",savewages,authid);
result = dbi_query(mySql,query);
dbi_free_result ( result )
format(query,255,"UPDATE economy SET money=%i WHERE steamid = %s",savemoney,authid);
result = dbi_query(mySql,query);
dbi_free_result ( result )
format(query,255,"UPDATE economy SET bank=%i WHERE steamid = %s",savebank,authid);
result = dbi_query(mySql,query);
dbi_free_result ( result )
format(query,255,"UPDATE economy SET job='%s' WHERE steamid = %s",savejob,authid);
result = dbi_query(mySql,query);
dbi_free_result ( result )
format(query,255,"UPDATE economy SET companyroll=%i WHERE steamid = %s",savepayroll,authid);
result = dbi_query(mySql,query);
dbi_free_result ( result )
anyone see wtf is wrong with this? its like, not makign changes to the mysql database.