How to use usercounter?
Do I need to ceate a database so that it works?
if yes, is it pcounter_save ( user_ip, save_name, save_value, day_time)?
I followed the instructions but allways getting -1 as online users
How to use usercounter?
Do I need to ceate a database so that it works?
if yes, is it pcounter_save ( user_ip, save_name, save_value, day_time)?
I followed the instructions but allways getting -1 as online users
check the comments on the extension page… there is the table schemas in the comments
Thanks! I saw it:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS pcounter_save ( save_name varchar(10) NOT NULL, save_value int(10) unsigned NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO pcounter_save (save_name, save_value) VALUES ('day_time', 2455527), ('max_count', 0), ('counter', 0), ('yesterday', 0);
CREATE TABLE IF NOT EXISTS pcounter_users ( user_ip varchar(39) NOT NULL, user_time int(10) unsigned NOT NULL, UNIQUE KEY user_ip (user_ip) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO pcounter_users (user_ip, user_time) VALUES ('''127.0.0.1''', 1290821670);
Seems working but still having -1 as online users
Working now… !
How it is working i still getting one user online. I have hosted my application on my local machine.