[gjedde]

Hey guys i could need some help with some code to put in my plugin

First i need a 5 min timer like you see on faceit were people got 5 min to join or they will be issued a ban after that i need to get the players steamid 64 into mysql so he can get a timeout on the website,

Its for alittle experiment im doing, nothing that will ever see the light of day i think but its still pretty fun to work with

i got the main plugin, where i need the timer on, and then i got the mysql plugin next to it where i need that to read what player didnt join

[sdz]

for your timer: Unix Time
for your database woes: https://wiki.alliedmods.net/SQL_(Sou...ing)#Threading

[gjedde]

Thank you, not exactly what i was expecting but it can diffently help alittle, but i again, how can i make the server tell if the client dropped connection and isnt back in the next 5 min, and then register him in mysql, i need that too, and if he doesnt join before the warmup ends thats what i am going for.

[CliptonHeist]

I'd use a datapack to pass player steamids through to a 5 min timer when they disconnect, which will then check if that steamid is on the server after 5mins and if not ban them.

[gjedde]

Originally Posted by CliptonHeist I'd use a datapack to pass player steamids through to a 5 min timer when they disconnect, which will then check if that steamid is on the server after 5mins and if not ban them.

that is accutaly not a bad idea, how would you set it up tho?

[adma]

I was bored so here is an example for you. In theory this should work but it is untested.
This adds a 5min timer against someones steamid when they disconnect and if they reconnect while timer is still going it will stop. If the timer fires it will ban them then insert/update a row in a table which has columns steamid and ban_expiry. On your website you can check if their steamid exists in this table, and see if their ban_expiry has been reached yet.

PHP Code:

#include <sourcemod>

StringMap g_hTimers = new StringMap();
Database g_hDatabase;

public void OnPluginStart() {
  static char szError[512];
  g_hDatabase = SQL_Connect("db_name", false, szError, sizeof(szError));
  if (g_hDatabase == INVALID_HANDLE) SetFailState(szError);
}

public void OnClientAuthorized(int iClient, char[] szSteamID) {
  Handle hTimer;
  if (g_hTimers.GetValue(szSteamID, hTimer)) {
    KillTimer(hTimer);
    g_hTimers.Remove(szSteamID);
  }
}

public void OnClientDisconnect(int iClient) {
  static char szSteamID[32];
  if (GetClientAuthId(iClient, AuthId_Steam2, szSteamID, sizeof(szSteamID))) {
    DataPack hPack = new DataPack();
    hPack.WriteString(szSteamID);
    Handle hTimer = CreateTimer(300.0, Timer_Ban, hPack, TIMER_HNDL_CLOSE);
    g_hTimers.SetValue(szSteamID, hTimer);
  }
}

public Action Timer_Ban(Handle hTimer, DataPack hPack) {
  static char szSteamID[32];
  static char szQuery[512];

  int iBanExpiry = GetTime() + (69*60);

  hPack.Reset()
  hPack.ReadString(szSteamID, sizeof(szSteamID));

  g_hTimers.Remove(szSteamID);
  
  BanIdentity(szSteamID, 69, BANFLAG_AUTHID, "You were banned for being naughty", "automatic_timer_ban", 0);

  g_hDatabase.Format(szQuery, sizeof(szQuery), "INSERT INTO `table_name` (`steamid`, `ban_expiry`) VALUES (\'%s\', %i) ON DUPLICATE KEY UPDATE `ban_expiry` = %i", szSteamID, iBanExpiry, iBanExpiry);

  g_hDatabase.Query(QueryCallback_InsertBan, szQuery);

  return Plugin_Handled;
}

public void QueryCallback_InsertBan(Database hDatabase, DBResultSet hResults, const char[] szError, any data) {
  delete hDatabase; // this is a cloned Handle of g_hDatabase
  if (strlen(szError) > 0) PrintToServer("Failed to insert ban");
} 


[gjedde]

Originally Posted by adma I was bored so here is an example for you. In theory this should work but it is untested. This adds a 5min timer against someones steamid when they disconnect and if they reconnect while timer is still going it will stop. If the timer fires it will ban them then insert/update a row in a table which has columns steamid and ban_expiry. On your website you can check if their steamid exists in this table, and see if their ban_expiry has been reached yet. PHP Code: #include <sourcemod> StringMap g_hTimers = new StringMap(); Database g_hDatabase; public void OnPluginStart() {   static char szError[512];   g_hDatabase = SQL_Connect("db_name", false, szError, sizeof(szError));   if (g_hDatabase == INVALID_HANDLE) SetFailState(szError); } public void OnClientAuthorized(int iClient, char[] szSteamID) {   Handle hTimer;   if (g_hTimers.GetValue(szSteamID, hTimer)) {     KillTimer(hTimer);     g_hTimers.Remove(szSteamID);   } } public void OnClientDisconnect(int iClient) {   static char szSteamID[32];   if (GetClientAuthId(iClient, AuthId_Steam2, szSteamID, sizeof(szSteamID))) {     DataPack hPack = new DataPack();     hPack.WriteString(szSteamID);     Handle hTimer = CreateTimer(300.0, Timer_Ban, hPack, TIMER_HNDL_CLOSE);     g_hTimers.SetValue(szSteamID, hTimer);   } } public Action Timer_Ban(Handle hTimer, DataPack hPack) {   static char szSteamID[32];   static char szQuery[512];   int iBanExpiry = GetTime() + (69*60);   hPack.Reset()   hPack.ReadString(szSteamID, sizeof(szSteamID));   g_hTimers.Remove(szSteamID);      BanIdentity(szSteamID, 69, BANFLAG_AUTHID, "You were banned for being naughty", "automatic_timer_ban", 0);   g_hDatabase.Format(szQuery, sizeof(szQuery), "INSERT INTO `table_name` (`steamid`, `ban_expiry`) VALUES (\'%s\', %i)", szSteamID, iBanExpiry);   g_hDatabase.Query(QueryCallback_InsertBan, szQuery);   return Plugin_Handled; } public void QueryCallback_InsertBan(Database hDatabase, DBResultSet hResults, const char[] szError, any data) {   delete hDatabase; // this is a cloned Handle of g_hDatabase   if (strlen(szError) > 0) PrintToServer("Failed to insert ban"); }

You are amazing, Thank you so much i will look trough this and see if it can work out with my little project i will come with some feedback when im done thank you so much thats more then i hoped for

[adma]

No problem, I updated my original post changing the INSERT statement so it updates the ban_expiry if the steamid already exists in the database.

[backwards]

The above method wouldn't give the correct logic like MM. This method can be exploited easily if the player leaves for 4 minutes and 50 seconds, then rejoins, then leaves again. He will have a reset timer of 5 minutes to be disconnected again and not be limited to 10 more seconds. You want to create a timer that ticks every second and while a players not connected, you increment the value until it reaches the 300 ticks for 5 minutes or (60*5)

[gjedde]

Yeah i noticed that too but its still a good start. still trying to figure out how i can check if a steamid doesnt connect to the game before warmupends the steamids are stored in a json file before they can join the server and the match, its just tricky