Advanced search FAQ
Register

stats php !

Post a reply

stats php !

Post by welde 26 Jul 2006 11:32
Hope this work !

<?php

$conn = mysql_connect('localhost:3306', 'verlihub', 'password');
if (!$conn) {
   die('Could not connect: ' . mysql_error());
}
mysql_select_db('verlihub');
$result = mysql_query('SELECT * FROM pi_stats`');
if (!$result) {
   die('Query failed: ' . mysql_error());
}

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   foreach ($line as $col_value) {
       echo $col_value . '<body bgcolor="#83c0ff" text="#000000";> 
';
   }
}
echo date("l dS of F Y h:i:s A");
?> 
welde

Posts: 1
Joined: 08 Jul 2006 03:23

no title

Post by netcelli 26 Jul 2006 12:44
Stat plugin is included in VHCP; now u can see only users stat but in the next version I want to add more graphs ( for ex. about uptime, freq for actrive/passive search, freq for login or logout, etc) ;)
User avatar
netcelli

Posts: 1217
Joined: 07 Jul 2006 10:48
Location: Italy
Verlihub version: trunk
MySQL version: 5.1.x
Lua version: 5.1.x

no title

Post by marbles1704 12 Mar 2007 09:00
i just installed stats plugin, it`s loaded ok by verlihub but in vhcp i get this error:

Error
Table 'verlihub.pi_iplog' doesn't exist
marbles1704

Posts: 15
Joined: 15 Oct 2006 08:42

no title

Post by underlig 14 Jul 2007 16:40
marbles1704;2896 wrote:i just installed stats plugin, it`s loaded ok by verlihub but in vhcp i get this error:

Error
Table 'verlihub.pi_iplog' doesn't exist


i have the same error, if i have to add the table myself, what should it contain?
underlig

Posts: 3
Joined: 18 Mar 2007 06:36

no title

Post by netcelli 15 Jul 2007 08:13
Frist of all let me say iplog and stats are 2 different plugins ;) Iplog logs all ip of users and stats does some statistics about frequency, maxshare, maxusers, current users every hour.
If a table is empty, VHCP stops the execution of the page with that error :) If you install the plug and then load it from verlihub, it creates the table :)
User avatar
netcelli

Posts: 1217
Joined: 07 Jul 2006 10:48
Location: Italy
Verlihub version: trunk
MySQL version: 5.1.x
Lua version: 5.1.x

Re: stats php !

Post by ValSiN 18 Feb 2010 11:44
http://www.besthub.eu/

Left panel stats hub db php script
ValSiN

Posts: 1
Joined: 18 Feb 2010 11:43
Verlihub version: 0.9.8e-r1
MySQL version: 5.1.x
Lua version: 5.1.x
LuaSocket version: 2.0.2

Return to Stats

Who is online

Users browsing this forum: No registered users and 1 guest