Code:
new Result:res = dbi_query(mysql, "SELECT `nick` FROM `medlemar` WHERE `steamid`='%s'", steamuserid)
server_cmd("echo 4. res fetched (%s)",res)
res will return the
steamid NOT
`nick` for the "medlemar" table.
Why? and how do I get it to work?
Code:
public client_putinserver(id)
{
server_cmd("echo 1. client_putinserver(%d) worked", id)
new steamuserid[32]
get_user_authid(id,steamuserid,31)
server_cmd("echo 2. authid (%s) taken",steamuserid)
if (equal(steamuserid,"STEAM_ID_PENDING")) return PLUGIN_CONTINUE
server_cmd("echo 3. steamid is not Steam_id_pending")
new Result:res = dbi_query(mysql, "SELECT `nick` FROM `medlemar` WHERE `steamid`='%s'", steamuserid)
if (res <= RESULT_NONE) {
server_cmd("echo 4. res fetched faild (%s)",res)
server_cmd("kick #%d ^"You have to register to play on this server. (<a href="http://www.warserver.se" target="_blank" rel="nofollow noopener">www.warserver.se</a>)^"", get_user_userid(id))
server_cmd("banid %d ^"%s^"", 5, steamuserid)
return PLUGIN_CONTINUE
}
server_cmd("echo 4. res fetched (%s)",res)
client_cmd(id,"name %s",res)
return PLUGIN_CONTINUE
}