Raised This Month: $12 Target: $400
 3% 

[Any] Paranoia IP Tracker


Post New Thread Reply   
 
Thread Tools Display Modes
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 08-15-2015 , 10:48   Re: [Any] Paranoia IP Tracker
Reply With Quote #91

Quote:
Originally Posted by ahmaden View Post
will this plugin work for csgo ?
Most of the things on SourceMod are cross-game compatible.

So I suggest that you try it out and let us know the final results.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].
DarkDeviL is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 08-15-2015 , 15:38   Re: [Any] Paranoia IP Tracker
Reply With Quote #92

No reason why it wouldn't.
__________________
DarthNinja is offline
ahmaden
Member
Join Date: Mar 2014
Old 08-16-2015 , 20:32   Re: [Any] Paranoia IP Tracker
Reply With Quote #93

Quote:
Originally Posted by arne1288 View Post
Most of the things on SourceMod are cross-game compatible.

So I suggest that you try it out and let us know the final results.
Quote:
Originally Posted by DarthNinja View Post
No reason why it wouldn't.
unfortunately it didnt work !



error logs :
L 08/17/2015 - 087:56: SourceMod error session started
L 08/17/2015 - 087:56: [SM] Native "SetFailState" reported: Can't find 'paranoiaip' entry in sourcemod/configs/databases.cfg!
L 08/17/2015 - 087:56: [SM] Displaying call stack trace for plugin "ParanoiaIPTracker.smx":
Attached Thumbnails
Click image for larger version

Name:	plugin error Capture.PNG
Views:	174
Size:	21.1 KB
ID:	147499  

Last edited by ahmaden; 08-28-2015 at 21:55.
ahmaden is offline
jpwanabe
Veteran Member
Join Date: Mar 2010
Old 09-20-2015 , 22:45   Re: [Any] Paranoia IP Tracker
Reply With Quote #94

So, how does this plugin handle players that have joined under more then 10 IPs? As in what does it do in the Paranoia_IPTracker table? Does it delete old ones and replace them? And if I add rows IP11-IP15 will it use those?
__________________
My Steam TF2APP
My sig changes with each load! Refresh to see my other servers!
jpwanabe is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 09-21-2015 , 10:47   Re: [Any] Paranoia IP Tracker
Reply With Quote #95

Quote:
Originally Posted by jpwanabe View Post
So, how does this plugin handle players that have joined under more then 10 IPs? As in what does it do in the Paranoia_IPTracker table? Does it delete old ones and replace them? And if I add rows IP11-IP15 will it use those?
It removes older ones, and only remember the last 10 addresses.

You could add IP11-15 and so on, but you would also need to adjust the SQL query in the source code for it to use those fields as well.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].
DarkDeviL is offline
Miggy
Member
Join Date: Mar 2015
Old 11-09-2015 , 00:35   Re: [Any] Paranoia IP Tracker
Reply With Quote #96

Quote:
Originally Posted by Wolfseye View Post
After restarting the Server this morning I got the following in the error log.
Code:
L 05/10/2014 - 07:578: SourceMod error session started
L 05/10/2014 - 07:578: Info (map "nightfall_coop_beta1") (file "errors_20140510.log")
L 05/10/2014 - 07:578: [ParanoiaIPTracker.smx] SQL Error: Field 'IP1' doesn't have a default value
L 05/10/2014 - 08:00:29: Error log file session closed.

Whats that supposed to mean ? The tables are created as far as I can see, so whats the problem ?
Any help is appreciated.

Thanks in advance.

Wolfseye

P.S: The Database is UTF-8. Do I need to create it with different setting, is that maybe the issue here ?
I am getting this same issue; I don't fully understand what you posted for your fix.
Could you elaborate?

My VPS hosting my DB is running Windows 2008 R2, my gameserver is running off of Linux.
Not sure if that matters but thought I should make note of that...

Last edited by Miggy; 11-09-2015 at 00:41.
Miggy is offline
mlov420
Senior Member
Join Date: May 2013
Old 07-10-2018 , 11:45   Re: [Any] Paranoia IP Tracker
Reply With Quote #97

It seems that there are again issues with this error happening:

Code:
L 07/10/2018 - 11:05:14: [paranoiaiptracker.smx] SQL Error: Field 'IP1' doesn't have a default value
This plugin worked for me for a while until about February of this year, then it just started putting off this error out of nowhere and hasn't worked since.

I have tried applying the "fixes" listed in this post, with no luck, just the same error: https://forums.alliedmods.net/showpo...0&postcount=20

As mentioned, it used to work fine and I have thousands of entries in my DB, but it stopped for no apparent reason on all of my servers (linux and windows). I'm running the latest stable branch (1.9 6241). Any ideas or help would be appreciated, thank you in advance.
mlov420 is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 07-23-2018 , 10:00   Re: [Any] Paranoia IP Tracker
Reply With Quote #98

Quote:
Originally Posted by mlov420 View Post
It seems that there are again issues with this error happening:

Code:
L 07/10/2018 - 11:05:14: [paranoiaiptracker.smx] SQL Error: Field 'IP1' doesn't have a default value
Set a default value for the column IP1 in your database.
__________________
DarthNinja is offline
canadianjeff
BANNED
Join Date: Sep 2016
Old 10-13-2020 , 06:45   Re: [Any] Paranoia IP Tracker
Reply With Quote #99

Fixed This Plugin By Adding Default Into The Create Table Section......

len += Format(query[len], sizeof(query)-len, " `IP1` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP2` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP3` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP4` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP5` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP6` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP7` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP8` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP9` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");
len += Format(query[len], sizeof(query)-len, " `IP10` varchar(64) COLLATE utf8_unicode_ci DEFAULT '' NOT NULL,");

Last edited by canadianjeff; 03-07-2022 at 01:48.
canadianjeff is offline
canadianjeff
BANNED
Join Date: Sep 2016
Old 11-01-2020 , 15:51  
Reply With Quote #100

this plugin has a HUGE gaping security flaw if someone has a ' char in the name anything after the ' will not be shown..... will post a screenshot soon



Code:
Client "God Engine☂" connected (<HIDDEN>:27005).
String Table dictionary for downloadables should be rebuilt, only found 68 of 94 strings in dictionary
String Table dictionary for modelprecache should be rebuilt, only found 704 of 795 strings in dictionary
String Table dictionary for soundprecache should be rebuilt, only found 16298 of 19273 strings in dictionary
String Table dictionary for Scenes should be rebuilt, only found 13167 of 15998 strings in dictionary
Paranoia IP Tracker Client Authorized!
[Paranoia IP] Name: God Engine☂ | IP: <HIDDEN>
SQL Query: INSERT INTO `Paranoia_IPTracker` (`SteamID`, `Name`, `LastConnected`) VALUES ('STEAM_1:1:<HIDDEN>', 'God Engine☂', '1604264027') ON DUPLICATE KEY UPDATE `LastConnected` = '1604264027', `Name` = 'God Engine☂';
SQL Query: UPDATE `Paranoia_IPTracker` SET `IP10` = `IP9`, `IP9` = `IP8`, `IP8` = `IP7`, `IP7` = `IP6`, `IP6` = `IP5`, `IP5` = `IP4`, `IP4` = `IP3`, `IP3` = `IP2`, `IP2` = `IP1`, `IP1` = '<HIDDEN>' WHERE `SteamID` = 'STEAM_1:1:<HIDDEN>' AND `IP1` != '<HIDDEN>';
Dropped God Engine☂ from server (Disconnect by user.)
Client "Bug's Bunny Birthday Bash" connected (<HIDDEN>:27005).
String Table dictionary for downloadables should be rebuilt, only found 68 of 94 strings in dictionary
String Table dictionary for modelprecache should be rebuilt, only found 704 of 795 strings in dictionary
String Table dictionary for soundprecache should be rebuilt, only found 16298 of 19273 strings in dictionary
String Table dictionary for Scenes should be rebuilt, only found 13167 of 15998 strings in dictionary
Paranoia IP Tracker Client Authorized!
[Paranoia IP] Name: Bug's Bunny Birthday Bash | IP: <HIDDEN>
SQL Query: INSERT INTO `Paranoia_IPTracker` (`SteamID`, `Name`, `LastConnected`) VALUES ('STEAM_1:1:<HIDDEN>', 'Bug\'\'\\\'\\\\\\\'\\\\\\\\\\\\\\\'\\\\\\\\\\\\', '1604264100') ON DUPLICATE KEY UPDATE `LastConnected` = '1604264100', `Name` = 'Bug\'\'\\\'\\\\\\\'\\\\\\\\\\\\\\\'\\\\\\\\\\\\';
SQL Query: UPDATE `Paranoia_IPTracker` SET `IP10` = `IP9`, `IP9` = `IP8`, `IP8` = `IP7`, `IP7` = `IP6`, `IP6` = `IP5`, `IP5` = `IP4`, `IP4` = `IP3`, `IP3` = `IP2`, `IP2` = `IP1`, `IP1` = '<HIDDEN>' WHERE `SteamID` = 'STEAM_1:1:<HIDDEN>' AND `IP1` != '<HIDDEN>';
Dropped Bug's Bunny Birthday Bash from server (Disconnect by user.)


someone who did not even escape mysql query (Darth Ninja) is a plugin approver my jaw just dropped to the floor

Last edited by asherkin; 11-01-2020 at 16:58.
canadianjeff is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 13:33.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode