Would be handy if USERVISIT/SQL/mysql.sql was rewritten to one table

CREATE TABLE visit_user (
id int(11) NOT NULL auto_increment,
visitname text,
nom varchar(100) NOT NULL,
page varchar(200) NOT NULL,
nvisit int(7) DEFAULT '0' NOT NULL,
temps varchar(30) NOT NULL,
tempsf varchar(30) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

but then probably would need to rewrite the whole code...

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);

I just installed noah.0.8.7. It's crazy!

NoAhWiki docs deal with 0.9 and it's got a whole another structure so I probably have to wait til it's released as a XOOPS module.

It's like a new operating system working besides xoops. And it looks like it has its way with the database entries. Really looking forward to dive into and getting the most out of it.

the preferences update worked. thanks again.

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...

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

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.

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

thanks.

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

I'm guessing I might need to do an 'include' within a template to achieve this.

e.g. userpoint module's totalpoints in a XOOPS core module