DaniDin
06-20-2010, 17:42
hi some 1 can help me i it's not working ?
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
#include <file>
#define PLUGIN "My Plug"
#define VERSION "1.0"
#define AUTHOR "DaniDin"
new Handle:g_SqlTuple ,sql[512]
public plugin_init()
{
register_plugin(PLUGIN,VERSION,AUTHOR)
g_SqlTuple = SQL_MakeDbTuple("localhost","amx","amxpass","amx")
}
// Say Hello To The User
public HelloMSG(id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
server_cmd("say ^"Hi, %s Your SteamID is: %s^"",plName,AuthID);
return PLUGIN_CONTINUE
}
//
// "client_connect(id)" there SteamID might not be valid
public client_authorized(id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
set_task(20.0,"HelloMSG",id);
formatex(sql,511,"SELECT guser FROM users WHERE id='1'");
SQL_ThreadQuery(g_SqlTuple,"SelectHandle",sql);
//SQL_ThreadQuery(g_SqlTuple,"SelectHandle","SELECT guser FROM users WHERE steamid='%d'",AuthID)
}
//
public kickpl(whotokick,whykick[],id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
if(whotokick == plName[31])
server_cmd("amx_tsay red yes %s = %s and ris is : %s",whotokick,plName,whykick)
else
server_cmd("amx_tsay red no %s != %s and ris is : %s",whotokick,plName,whykick)
//server_cmd("amx_kick ^"%d %d^"",whotokick,whykick)
}
//scan if user loged
public SelectHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize,id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
new txthim[101]
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("Could not connect to SQL database.")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("Query failed.")
if(Errcode)
return log_amx("Error on query: %s",Error)
new str[33]
while(SQL_MoreResults(Query))
{
new DataNum
DataNum = SQL_ReadResult(Query,0,str,33)
//go and check if user name vaild
txthim = "Change To Real Nick Name !";
kickpl(DataNum,txthim,id)
SQL_NextRow(Query)
}
return PLUGIN_CONTINUE
}
//
public plugin_end()
// free the tuple - note that this does not close the connection,
// since it wasn't connected in the first place
SQL_FreeHandle(g_SqlTuple)
i the sql i have
id =1 guser = loli steamid = 123123
i want to do if player connect but not with his real nick so he get kick
in the log i get this
L 06/21/2010 - 02:27:39: -------- Mapchange to de_dust2 --------
L 06/21/2010 - 02:28:07: [admin.amxx] Login: "dvd<1><STEAM_0:1:11111111><>" became an admin (account "STEAM_0:1:11111111") (access "abcdefghijklmnopqrstu") (address "11.11.11.11")
L 06/21/2010 - 02:28:07: [adminchat.amxx] Chat: "demo- CS Server<0><><>" tsay "no `€loli != demo- CS Server and ris is : Change To Real Nick Name !^"
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
#include <file>
#define PLUGIN "My Plug"
#define VERSION "1.0"
#define AUTHOR "DaniDin"
new Handle:g_SqlTuple ,sql[512]
public plugin_init()
{
register_plugin(PLUGIN,VERSION,AUTHOR)
g_SqlTuple = SQL_MakeDbTuple("localhost","amx","amxpass","amx")
}
// Say Hello To The User
public HelloMSG(id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
server_cmd("say ^"Hi, %s Your SteamID is: %s^"",plName,AuthID);
return PLUGIN_CONTINUE
}
//
// "client_connect(id)" there SteamID might not be valid
public client_authorized(id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
set_task(20.0,"HelloMSG",id);
formatex(sql,511,"SELECT guser FROM users WHERE id='1'");
SQL_ThreadQuery(g_SqlTuple,"SelectHandle",sql);
//SQL_ThreadQuery(g_SqlTuple,"SelectHandle","SELECT guser FROM users WHERE steamid='%d'",AuthID)
}
//
public kickpl(whotokick,whykick[],id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
if(whotokick == plName[31])
server_cmd("amx_tsay red yes %s = %s and ris is : %s",whotokick,plName,whykick)
else
server_cmd("amx_tsay red no %s != %s and ris is : %s",whotokick,plName,whykick)
//server_cmd("amx_kick ^"%d %d^"",whotokick,whykick)
}
//scan if user loged
public SelectHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize,id)
{
new AuthID[32],plName[32]
get_user_authid(id,AuthID,32);
get_user_name(id,plName,32);
new txthim[101]
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("Could not connect to SQL database.")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("Query failed.")
if(Errcode)
return log_amx("Error on query: %s",Error)
new str[33]
while(SQL_MoreResults(Query))
{
new DataNum
DataNum = SQL_ReadResult(Query,0,str,33)
//go and check if user name vaild
txthim = "Change To Real Nick Name !";
kickpl(DataNum,txthim,id)
SQL_NextRow(Query)
}
return PLUGIN_CONTINUE
}
//
public plugin_end()
// free the tuple - note that this does not close the connection,
// since it wasn't connected in the first place
SQL_FreeHandle(g_SqlTuple)
i the sql i have
id =1 guser = loli steamid = 123123
i want to do if player connect but not with his real nick so he get kick
in the log i get this
L 06/21/2010 - 02:27:39: -------- Mapchange to de_dust2 --------
L 06/21/2010 - 02:28:07: [admin.amxx] Login: "dvd<1><STEAM_0:1:11111111><>" became an admin (account "STEAM_0:1:11111111") (access "abcdefghijklmnopqrstu") (address "11.11.11.11")
L 06/21/2010 - 02:28:07: [adminchat.amxx] Chat: "demo- CS Server<0><><>" tsay "no `€loli != demo- CS Server and ris is : Change To Real Nick Name !^"