ok i expanded my plugin to this....
Code:
public jobchange(id,newjob[],sal[]){
new authid[32],query[256],numoldbal[32];
get_user_authid(id,authid,31);
format(query,255,"SELECT balance FROM money WHERE steamid='%s'",authid);
mysql_query(mysql,query);
mysql_getfield(mysql,1,"numoldbal",31);
oldbal = str_to_num(numoldbal);
if(oldbal > 250) {
format(query,255,"UPDATE money SET balance=balance-250 WHERE steamid='%s'",authid);
mysql_query(mysql,query);
client_print(id,print_chat,"[-Snort-] You Have Been Charged a $250 Employment Fee.");
format(query,255,"UPDATE money SET job='%s', salary='%s' WHERE steamid='%s'",newjob,sal,authid);
mysql_query(mysql,query);
client_print(id,print_chat,"Your Job Has Been Changed",authid);
return PLUGIN_HANDLED;
} else {
client_print(id,print_chat,"[-Snort-] You Don't Have The Money To Pay The $250 Employment Fee");
return PLUGIN_HANDLED;
}
}
someone plz help! plz plz plz plz plz plz plz plz plz plz