PHP Code:
public client_putinserver(id)
{
new info[32];new _info=get_user_info(id,"*hwID",info,31)
if((!_info)||(!get_user_flags(id)&&ADMIN_USER))
return PLUGIN_HANDLED
new Handle:query=SQL_PrepareQuery(sqlx,"Select `hwid` from `%s` where `hwid`='%s'",table,info)
SQL_Execute(query)
while(SQL_MoreResults(query)) { //execute code as long as you have a result
//new _col=SQL_FieldNameToNum(query,"hwid") // not needed, _col always 0
new buff[32]
//SQL_ReadResult(query,_col,buff,31)
SQL_ReadResult(query,0,buff,31) // you only select "hwid", _col = 0
//if(equali(buff,""))
//return PLUGIN_HANDLED
server_cmd("kick #%d [*myAC] You have been banned from this server.",get_user_userid(id))
SQL_NextRow(query) //switch to next result
}
SQL_FreeHandle(query)
return PLUGIN_HANDLED
}
__________________