[DarthNinja]

PiwneBractwo:
Change it?

monomizer:
Using SQLite isn't going to work.

[PiwneBractwo]

Originally Posted by DarthNinja PiwneBractwo: Change it?

I don't know how to change it. DarthNinja you can change this? Or, write how I can do it.

Sorry for my english
Regards

[DarthNinja]

Originally Posted by PiwneBractwo I don't know how to change it. DarthNinja you can change this? Or, write how I can do it. Sorry for my english Regards

I don't know what you mean by "change it".
What do you want to change it to?

[MaloModo]

Installed....sounds sweet

[Peace-Maker]

That update query pushing a new ip into the list is nice. I didn't think of that

[DarthNinja]

Originally Posted by Peace-Maker That update query pushing a new ip into the list is nice. I didn't think of that

Yeah, I should probably check the new IP against all the 10 stored IPs, not just the first one though.

[Dr. McKay]

Originally Posted by PiwneBractwo Nice plugin You can change the date in Paranoia_IPTrackerLogs / ConnectTime ? In this table I see date for example 1330774025. Sorry for my english Regards

That's a UNIX timestamp. Convert it here -> http://www.unixtimestamp.com

Paste the number into the Timestamp box and hit Convert.

TIME STAMP: 1330774025

DATE (M/D/Y @ h:m:s): 03 / 03 / 12 @ 5:27:05am EST

[TnTSCS]

Unix time stamp is the number of seconds since Jan 01 1970

In case anyone was wondering - like I was

[togie6]

I am having trouble adding the required line to configs/database.cfg to make this plugin work.
Could you please paste it here D=
Ive added a entry for paranoiaip but the plugin still fails to load

[GameRover]

I tried "sm_paranoia_ip_verbose 1;" in this plugin and it work fine for log at "paranoia_iptrackerlogs". But this plugin cant work for "paranoia_iptracker" because this msg from my MySQL(v5.5.22):

[ParanoiaIPTracker.smx] SQL Error: Field 'IP1' doesn't have a default value

I looked at this plugin's script and see that "IP1"~"IP10" defined as "NOT NULL" in creating table...
How did you setup the database or table so get this SQL script "INSERT INTO..." work?

P.s. Sorry first for my bad English and bad SQL.



Plus:

Because my MySQL don't do "UPDATE" for "NOT NULL" and when "IP1" is "NULL" (i have no idea why can't "WHERE `IP1` != '%s'" be satisfied with "IP1 := NULL".).
So I modified part of plugin's script @[SQL_CreateTables()]:

//...
    len += Format(query[len], sizeof(query)-len, "  `Name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,");
    len += Format(query[len], sizeof(query)-len, "  `LastConnected` int(12) NOT NULL,");
    len += Format(query[len], sizeof(query)-len, "  `IP1` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP2` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP3` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP4` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP5` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP6` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP7` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP8` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP9` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  `IP10` varchar(64) COLLATE utf8_unicode_ci DEFAULT '0.0.0.0',");
    len += Format(query[len], sizeof(query)-len, "  PRIMARY KEY (`id`),");
    len += Format(query[len], sizeof(query)-len, "  UNIQUE KEY `SteamID` (`SteamID`)");
//...

And now this plugin work fine. thanks for DarthNinja's work.