1
fo-fo
users visiting a page
  • 2005/5/3 14:34

  • fo-fo

  • Just popping in

  • Posts: 34

  • Since: 2005/4/13


is there a way to record the ID (+time) of users visiting a particular page (guestbook module?)

2
bluenova
Re: users visiting a page


3
fo-fo
Re: users visiting a page
  • 2005/5/3 14:51

  • fo-fo

  • Just popping in

  • Posts: 34

  • Since: 2005/4/13


hell. where's been this one hiding? :)

thanks.

4
bluenova
Re: users visiting a page

make sure you're using version 2.2

I Just updated in module rep.

5
fo-fo
Re: users visiting a page
  • 2005/5/3 15:06

  • fo-fo

  • Just popping in

  • Posts: 34

  • Since: 2005/4/13


In the readme.txt E-Xoops is mentioned...

I guess I downloaded UserVisit 2.2. In the zip file I couldn't find the number of the version mentioned.

6
fo-fo
Re: users visiting a page
  • 2005/5/3 15:21

  • fo-fo

  • Just popping in

  • Posts: 34

  • Since: 2005/4/13


I didn't :). I got it before you changed it.

7
fo-fo
Re: users visiting a page
  • 2005/5/3 15:56

  • fo-fo

  • Just popping in

  • Posts: 34

  • Since: 2005/4/13


I installed it. It's working, but in the PagesView section only shows index.php and any other pages stats look like this:

Pages........View
/..............4
/index.php...1

So I have two questions:
1. why these other pages are not displayed? [these are in a XOOPS subfolder]

2. could be the code customized so it would display it like:

page: ....php
viewed: username, username2, username3...

8
bluenova
Re: users visiting a page

1) Did you add the code to footer.php? and always setup preferences¦general¦update themes and templates to yes when using a new module. You could also try deleting all the files in templates_c apart from index.htm

2) You would need to go to the module developer (website is in the module rep)

9
fo-fo
Re: users visiting a page
  • 2005/5/3 16:52

  • fo-fo

  • Just popping in

  • Posts: 34

  • Since: 2005/4/13


the preferences update worked. thanks again.

10
fo-fo
Re: users visiting a page
  • 2005/5/4 13:10

  • fo-fo

  • Just popping in

  • Posts: 34

  • Since: 2005/4/13


maybe someone can help... Pascal could drop in too :)

here's the details--

DATABASE:

1. xoops_visit_user_page table

INSERT INTO `xoops_visit_user_page` VALUES ('6', 'username', '/page.php', ... );
INSERT INTO `xoops_visit_user_page` VALUES ('7', 'username2', '/page.php', ... );

xoops_visit_user_page structure:
(`id` int(11) NOT NULL auto_increment,
`nom` varchar(100) NOT NULL,
`page` varchar(200) NOT NULL,
`nav` varchar(150) NOT NULL,
`langue` varchar(20) NOT NULL,
`enregis` varchar(20) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;


2. xoops_visit_user table

INSERT INTO `xoops_visit_user` VALUES ('1', 'username', '4', '00.00.00.000', '1115132593', '1115132654');
INSERT INTO `xoops_visit_user` VALUES ('2', 'username2', '2',

(`id` int(11) NOT NULL auto_increment,
`visitname` text,
`nvisit` int(7) NOT NULL default '0',
`ip` varchar(16) NOT NULL,
`temps` varchar(30) NOT NULL,
`tempsf` varchar(30) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
____________________________________



VISIT DETAILS [xoops module admin]:

user-visit.php?vm=username


user-visit.php MySQL queries:

$visit= mysql_query("SELECT * FROM ".$xoopsDB->prefix("visit_user")." WHERE visitname = '$vm' ORDER BY temps");
$visi=mysql_NumRows($visit);


$visit = mysql_query("SELECT distinct page, count(page) as cpage FROM ".$xoopsDB->prefix("visit_user_page")." WHERE nom = '$vm' GROUP BY page ORDER BY page ASC");
$visi=mysql_NumRows($visit);

...

$visit2 = mysql_query("SELECT distinct nav, count(nav) as cnav, langue FROM ".$xoopsDB->prefix("visit_user_page")." WHERE nom = '$vm' GROUP BY nav ORDER BY cnav DESC");
$visi2=mysql_NumRows($visit2);

_________________________________________________________________________

should I try something like

$visit = mysql_query("SELECT /page.php FROM ".$xoopsDB->prefix("visit_user_page")." WHERE nom = '$vm' GROUP BY username ORDER BY username ASC");
$visi=mysql_NumRows($visit);

Login

Who's Online

240 user(s) are online (122 user(s) are browsing Support Forums)


Members: 0


Guests: 240


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits