Ip Tracking in ACP

[.QUACK.Major.Pain]

I must be missing it. I don't see ip tracking anywhere.
I can click on the online users ip and see their info.

[MWE_001]

I suspect that it is the all languages version only then. I have the english only version and it does NOT have IP Tracking in the ACP anywhere at all.

[Dioncecht]

I'm getting this error as well. I know part fo it is that it is missing the table in the databases. I can't try the fix because I can't see any snippets of code posted on this site anymore.

I get this:

[djcasper]

I have fixed the problem with this tracker.
You can download the missing file + file edits and sql code from the link below.

Your tracker will then log your actions. To test it login to admin and goto your tracker and you will see your login data.

Regards
DJ Casper

[.QUACK.Major.Pain]

djcasper that edit didn't work here.

Causes this error on portal page:

Warning: main() [function.main]: Unable to access ./includes/functions_ip_track.php in /home4/stuffupf/public_html/bindepot/forum/includes/page_header.php on line 1416

Warning: main(./includes/functions_ip_track.php) [function.main]: failed to open stream: No such file or directory in /home4/stuffupf/public_html/bindepot/forum/includes/page_header.php on line 1416

Warning: main() [function.include]: Failed opening './includes/functions_ip_track.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home4/stuffupf/public_html/bindepot/forum/includes/page_header.php on line 1416


I just did a new install and the file doesn't exist.
I downloaded integramod files again and checked, but the file functions_ip_track.php doesn't exist in the download.

[.QUACK.Major.Pain]

Nevermind. LOL

Just got out of bed and still half asleep.

Found the file in your download and everything working great now.

Great job.

Thanks

[dungeon]

Hai


I have this error

Configuration = Oke


Ip: Admin Hits error =

Error Getting IP Count.

DEBUG MODE

SQL Error : 1146 Table 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.phpbb_ip_tracking' doesn't exist

SELECT COUNT(*) AS total FROM phpbb_ip_tracking WHERE located LIKE '%admin%' GROUP BY time

Line : 679
File : admin_ip_tracking.php

Ip: Logs error =

Error Getting IP Count.

DEBUG MODE

SQL Error : 1146 Table 'xxxxxxxxxxxxxxxxx.phpbb_ip_tracking' doesn't exist

SELECT COUNT(ip) AS total FROM phpbb_ip_tracking GROUP BY username

Line : 470
File : admin_ip_tracking.php

Ip: Multi Users error =

Error Getting IP Count.

DEBUG MODE

SQL Error : 1146 Table 'xxxxxxxxxxxx.phpbb_ip_tracking' doesn't exist

SELECT COUNT(ip) AS total FROM phpbb_ip_tracking GROUP BY ip

Line : 798
File : admin_ip_tracking.php

Ip: Search = oke


When i do the querry from this topic from JWI

Than i have this

[img=left:2geqc4jq]http://www.spuwjegalonline.nl/test/database.jpg[/img]


Greetz Dungeon

[Okki]

Maybe you can try the solution from djcasper.

I suppose this solution can go in the package, maybe also as an update package for the current version!!??

[dungeon]

I have don that but a can do this in Query

Code: Select all

SQL FIX  CREATE TABLE phpbb_ip_tracking_config (    max INT(15) NOT NULL DEFAULT '0'    );                CREATE TABLE phpbb_ip_tracking (    ip varchar(15) NOT NULL DEFAULT '',    time int(11) NOT NULL DEFAULT '0',    located varchar(255) NOT NULL DEFAULT '',    referer varchar(255) NOT NULL,    username varchar(50) NOT NULL DEFAULT ''    );    INSERT INTO phpbb_ip_tracking_config VALUES (25000);  

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE phpbb_ip_tracking ( ip varchar(15) NOT NULL default '', tim' at line 5






Dungeon

[.QUACK.Major.Pain]

You must be doing something wrong.
I just created a test database and did the above, and all was successful.

First, you mention query. You don't do query, you use the "SQL" tab and enter this in the box:

Code: Select all

CREATE TABLE phpbb_ip_tracking_config (    max INT(15) NOT NULL DEFAULT '0'    );                CREATE TABLE phpbb_ip_tracking (    ip varchar(15) NOT NULL DEFAULT '',    time int(11) NOT NULL DEFAULT '0',    located varchar(255) NOT NULL DEFAULT '',    referer varchar(255) NOT NULL,    username varchar(50) NOT NULL DEFAULT ''    );    INSERT INTO phpbb_ip_tracking_config VALUES (25000);

Then click "GO"

You should get the following when done]Your SQL query has been executed successfully[/code]

[code=sql]SQL query]

[code=sql]Run SQL query/queries ON DATABASE aaquac5_test]

[Helter]

mysql5 / mysqli

Code: Select all

 CREATE TABLE IF NOT EXISTS `phpbb_ip_tracking` (   `ip` varchar(15) NOT NULL DEFAULT '',   `time` int(11) NOT NULL DEFAULT '0',   `located` varchar(255) NOT NULL DEFAULT '',   `referer` varchar(255) NOT NULL DEFAULT '',   `username` varchar(50) NOT NULL DEFAULT '') ENGINE=MyISAM DEFAULT CHARSET=latin1;    CREATE TABLE IF NOT EXISTS `phpbb_ip_tracking_config` (   `max` varchar(15) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=latin1;  INSERT INTO `phpbb_ip_tracking_config` (`max`) VALUES('25000');  

mysql4

Code: Select all

 CREATE TABLE IF NOT EXISTS `phpbb_ip_tracking` (   `ip` varchar(15) NOT NULL DEFAULT '',   `time` int(11) NOT NULL DEFAULT '0',   `located` varchar(255) NOT NULL DEFAULT '',   `referer` varchar(255) NOT NULL DEFAULT '',   `username` varchar(50) NOT NULL DEFAULT '') TYPE=MyISAM;    CREATE TABLE IF NOT EXISTS `phpbb_ip_tracking_config` (   `max` varchar(15) NOT NULL DEFAULT '0') TYPE=MyISAM;  INSERT INTO `phpbb_ip_tracking_config` (`max`) VALUES('25000');  

[dungeon]

I whas in the rong box lol now i have don this and it works

Code: Select all

 DROP TABLE IF EXISTS phpbb_ip_tracking_config;  DROP TABLE IF EXISTS phpbb_ip_tracking;  CREATE TABLE `phpbb_ip_tracking_config` ( `max` varchar(15) NOT NULL DEFAULT ''  ) TYPE=MyISAM;  INSERT INTO `phpbb_ip_tracking_config` VALUES ('25000');  CREATE TABLE `phpbb_ip_tracking` ( `ip` varchar(15) NOT NULL DEFAULT '', `time` int(11) NOT NULL DEFAULT '0', `located` varchar(255) NOT NULL DEFAULT '', `username` varchar(50) NOT NULL DEFAULT ''  ) TYPE=MyISAM;    

[dungeon]

i have fix the error but Tracking is not tracking anything


Dungeon

[Moander]

The djcasper fix worked perfectly, no errors, no issues, and I got tracking.

Thank you djcasper.

[Moander]

Only issue remaining, as I spoke too early <img>

I get no guest IP tracking. When I look at the Config screen, I can delete the registered member logs, but the Guest log shows 0 entries all the time.....

Ideas?