[OXYD]

Hello, does anyone knows what could cause this?


It should be just one for each player

[CrazyHackGUT]

This can be an issue in your plugin, not driver.

[OXYD]

void WatchDog_User(int Data)
{
	static int Time, Team;

	Time = GetTime();
	Team = GetClientTeam(Data);

	if (Team == CS_TEAM_T || Team == CS_TEAM_CT)
	{
		GeoR_Code(g_Ip[Data], g_Code, sizeof(g_Code));
		GeoR_Country(g_Ip[Data], g_Country, sizeof(g_Country));
		FormatEx(g_Buffer, sizeof(g_Buffer), "INSERT IGNORE INTO watchdog_admins VALUES ('%s', '%s', '%s', %d, %d, %d, '%s', '%s');", \
			g_Steam[Data], g_Ip[Data], g_Name[Data], 2, 0, Time, g_Code, g_Country);
		SQL_TQuery(g_pConnection, EmptyFn, g_Buffer);
		FormatEx(g_Buffer, sizeof(g_Buffer), "UPDATE watchdog_admins SET lastSeen = %d, minutesOnline = minutesOnline + 2 WHERE adminSteam = '%s';", \
			Time, g_Steam[Data]);
		SQL_TQuery(g_pConnection, EmptyFn, g_Buffer);
	}

	else if (Team == CS_TEAM_SPECTATOR)
	{
		GeoR_Code(g_Ip[Data], g_Code, sizeof(g_Code));
		GeoR_Country(g_Ip[Data], g_Country, sizeof(g_Country));
		FormatEx(g_Buffer, sizeof(g_Buffer), "INSERT IGNORE INTO watchdog_admins VALUES ('%s', '%s', '%s', %d, %d, %d, '%s', '%s');", \
			g_Steam[Data], g_Ip[Data], g_Name[Data], 0, 2, Time, g_Code, g_Country);
		SQL_TQuery(g_pConnection, EmptyFn, g_Buffer);
		FormatEx(g_Buffer, sizeof(g_Buffer), "UPDATE watchdog_admins SET lastSeen = %d, minutesSpecOnline = minutesSpecOnline + 2 WHERE adminSteam = '%s';", \
			Time, g_Steam[Data]);
		SQL_TQuery(g_pConnection, EmptyFn, g_Buffer);
	}
}

Maybe u can find the problem? xD

[asherkin]

Your queries are relying on there being a UNIQUE index for the `adminSteam` column, what is your database structure and keys?

[OXYD]

U mean this?

CREATE TABLE `watchdog_admins` (
  `adminSteam` varchar(64) NOT NULL,
  `adminIp` varchar(64) DEFAULT NULL,
  `adminName` varchar(128) DEFAULT NULL,
  `minutesOnline` int(11) DEFAULT NULL,
  `minutesSpecOnline` int(11) DEFAULT NULL,
  `lastSeen` int(11) DEFAULT NULL,
  `countryCode` varchar(8) DEFAULT NULL,
  `Country` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;