[dmustanger]

Originally Posted by TheBigD Getting this repeated. L 07/22/2010 - 19:58:48: [watchlist.smx] Query Failed T_generic: no such column: CURDATEDEF

ahh ok I see whats wrong there, I should have a fix soon for this.

[dmustanger]

I have uploaded a new version. I took the date out of the database for now. Will readd it once i add a convar to delete players out of the database after x amount of days.

[EvilLinux]

Hi, can you explain why I might be getting this error:

[Watchlist] Unable to add STEAM_0:1:19064409 to the Watchlist.

I tired enabling logging 1 and 2, and nothing logged so out of options in debugging on my side. Any help would be great, the database connects fine as far as I can see.

Thanks,
EvilLinux
N00bSalad

[dmustanger]

The only reason you would get that error is if there was a database error. But you should have gotten something in the logs even if it was set to 1, with at least the same message.

Is that the only steamid that its not taking or is it not accepting any?
Just to make sure, did you look in the right logfile? sourcemod/logs/watchlist.log

[DontWannaName]

What if we only want it to notify admins when an admin joins and there is already someone on there so it notifies the joining admin only when they get into the game. Also, when a person on the watchlist joins and it notifies all of the admins on that server. I dont like the idea of spamming my admins...

[dmustanger]

Originally Posted by DontWannaName What if we only want it to notify admins when an admin joins and there is already someone on there so it notifies the joining admin only when they get into the game. Also, when a person on the watchlist joins and it notifies all of the admins on that server. I dont like the idea of spamming my admins...

I can make this happen. It already announces when a watchlisted player joins. wouldn't be hard to make so it only annouces then or when an admin joins. Added it to my todo list.

[JasonGauthierDK]

Why not do so admins can type !watchlist (or sm_printwatchlist maybe) to see a list with all the online players that are on the watch list?

[violentcrimes]

L 08/28/2010 - 17:58:40: [watchlist.smx] [Watchlist] Unable to add STEAM_0:1:524981 to the Watchlist.
L 08/28/2010 - 17:58:40: [watchlist.smx] Query Failed T_WatchlistAdd: Column count doesn't match value count at row 1
L 08/28/2010 - 17:58:59: [watchlist.smx] [Watchlist] Unable to add STEAM_0:1:524981 to the Watchlist.

[em-eukal]

L 01/13/2011 - 00:56:40: [watchlist.smx] [Watchlist] Unable to add STEAM_0:1:43356 to the Watchlist.
L 01/13/2011 - 00:56:40: [watchlist.smx] Query Failed T_WatchlistAdd: 6 values for 7 columns
L 01/13/2011 - 00:57:02: [watchlist.smx] [Watchlist] Unable to add STEAM_0:1:29188796 to the Watchlist.
L 01/13/2011 - 00:57:02: [watchlist.smx] Query Failed T_WatchlistAdd: 6 values for 7 columns
L 01/13/2011 - 00:570: [watchlist.smx] [Watchlist] Unable to add STEAM_0:1:43356 to the Watchlist.
L 01/13/2011 - 00:570: [watchlist.smx] Query Failed T_WatchlistAdd: 6 values for 7 columns

[em-eukal]

watchlist_add:
Fix line 692 and 697...

Format(query, sizeof(query), "INSERT INTO watchlist (ingame, steamid, serverip, serverport, reason, name, date) VALUES...

should be

Format(query, sizeof(query), "INSERT INTO watchlist (ingame, steamid, serverip, serverport, reason, name) VALUES...

watchlist_query
Fix line 926 to:

PrintToConsole(data, "%s, %s, %s", steamid, name, reason);

Announcing doesn't work at all, but I did not found the error yet :/
And I don't even get an error log entry...