Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <amxmodx>
- #include <amxmisc>
- #include <sqlx>
- new Handle:g_SqlTuple
- new g_Error[512],Sserver;
- new Host[64],User[64],Pass[64],Db[64]
- public plugin_init()
- {
- register_plugin("SQl monitor","1.0","Kulers")
- register_clcmd("amx_upserver","update_server");
- get_cvar_string("amx_sql_host",Host,63)
- get_cvar_string("amx_sql_user",User,63)
- get_cvar_string("amx_sql_pass",Pass,63)
- get_cvar_string("amx_sql_db",Db,63)
- Sserver = register_cvar("monitor_server","1") //server id
- sup();
- }
- public sup()
- {
- update_server()
- set_task(30.0,"sup");
- }
- public client_connect(id)
- {
- update_server()
- }
- public client_disconnect(id)
- {
- update_server()
- }
- public update_server()
- {
- client_print(0,print_console,"[Start][Serveris]: %i",get_pcvar_num(Sserver))
- g_SqlTuple = SQL_MakeDbTuple(Host,User,Pass,Db)
- // ok, we're ready to connect
- new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511)
- new Handle:Queries[33]
- new dest[1255]
- format(dest,1254,"DELETE FROM cs_players WHERE cserver='%i'",get_pcvar_num(Sserver))
- Queries[0] = SQL_PrepareQuery(SqlConnection,dest)
- if(!SQL_Execute(Queries[0]))
- {
- SQL_QueryError(Queries[0],g_Error,511)
- client_print(0,print_chat,"[ERROR]: %s",g_Error)
- }
- SQL_FreeHandle(Queries[0])
- for(new i = 1;i <= 32;i++)
- {
- new team[32],name[32]
- new dest[1255]
- new killss = get_user_frags(i)
- new deathss = get_user_deaths(i)
- get_user_team(i, team, 31)
- get_user_name(i, name, 31)
- format(dest,1254,"INSERT INTO cs_players (name,team,frags,death,cserver) VALUES('%s','%s','%i','%i','%i')",name,team,killss,deathss,get_pcvar_num(Sserver))
- Queries[i] = SQL_PrepareQuery(SqlConnection,dest)
- if(!SQL_Execute(Queries[i]))
- {
- SQL_QueryError(Queries[i],g_Error,511)
- client_print(0,print_chat,"[ERROR]: %s",g_Error)
- }
- SQL_FreeHandle(Queries[i])
- }
- // you free everything with SQL_FreeHandle
- SQL_FreeHandle(SqlConnection)
- }
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement