Code:
public hrp_is_job_higher(id,authid[],jobid[]) {
new data[2];
format(data,1,"%d",id);
static query[256];
format(query, 255, "SELECT job>%s FROM users WHERE steamid='%s'",jobid,authid);
SQL_ThreadQuery(sql_get_handle(),"QueryHandle", query,data,1)
}
public hrp_is_job_smaller(id,authid[],jobid[]) {
new data[2];
format(data,1,"%d",id);
static query[256];
format(query, 255, "SELECT job<%s FROM users WHERE steamid='%s'",jobid,authid);
SQL_ThreadQuery(sql_get_handle(),"QueryHandle", query,data,1)
}
public QueryHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { //Thanks Hawk552 <3
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("[HRPi]SQL Connection Failed.")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("[HRPi]Query failed.")
if(Errcode)
return log_amx("[HRPi]Error on query: %s",Error)
server_print("[HRPi] SQL Query Executed Successfully!")
if(SQL_NumResults(Query)) {
new id = str_to_num(data)
StoreSomeWhere[id] = SQL_ReadResult(Query, 0);
}
return Handle:Query
}
Code:
if(!hrp_is_job_higher(id,pid,2) && !hrp_is_job_smaller(id,<,pid,11))