can any one tell me the bug(s) of my noob script. It suppose to change the varaibles you see then in a mysql database. The function is called by a menu with jobchange(id,"Bellboy", "6");. the mysql database has a job column that corresponds with an authid colum.
Code:
public jobchange(id,newjob[],sal[]){
new authid[32],query[256];
get_user_authid(id,authid,31);
format(query,255,"UPDATE money SET job=%s,WHERE steamid='%s'",newjob,authid);
mysql_query(mysql,query);
format(query,255,"UPDATE money SET salary=%s,WHERE steamid='%s'",sal,authid);
mysql_query(mysql,query);
server_cmd("amx_csay User %s's job info has been changed",authid);
return PLUGIN_HANDLED;
}