I tried to compile your code and it crashed. I removed the extra stuff and it compiles now if this helps any.
Code:
#include <amxmodx>
#include <dbi>
new Sql:mysql
//----------------------------------------------------------------------------------------------
public plugin_init() {
register_plugin("ws.se medlemskoll","1.00","andrz")
set_task(1.0,"mysql_init")
}
//----------------------------------------------------------------------------------------------
public mysql_init()
{
mysql = dbi_connect("localhost", "root", "", "n3xin_WS")
if (mysql < SQL_OK) {
new err[255]
new errNum = dbi_error(mysql, err, 254)
server_print("error1: %s|%d", err, errNum)
return 1
}
server_print("Connection handle: %d", mysql)
return PLUGIN_CONTINUE
}
//----------------------------------------------------------------------------------------------
public client_putinserver(id)
{
server_cmd("echo 1. client_putinserver (%d) worked",id)
// Get user steamid
new steamuserid[32]
get_user_authid(id,steamuserid,31)
server_cmd("echo 2. authid (%s) taken",steamuserid)
// Get nick from medlemar where steamid is the same as steamuserid
new Result:res = dbi_query(mysql, "SELECT * FROM medlemar WHERE steamid='%s'", steamuserid)
// Check if user is registerd
if (dbi_num_rows(res) < 1) {
// tempBan user because he/she's not registerd
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)
server_cmd("echo 4. res fetched faild (%s)",res)
}else{
new regnick[32]
dbi_nextrow(res)
dbi_result(res, "nick", regnick, 31)
server_cmd("echo 4. res fetched (%s)",regnick)
// change usernick to the registerd nick
client_cmd(id,"name %s",regnick)
}
dbi_free_result(res)
return PLUGIN_CONTINUE
}