S
Sax
Gamma
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
$newusers = $db->query_first('
SELECT COUNT(*) AS count
FROM ' . TABLE_PREFIX . 'user
WHERE joindate >= "' . strtotime("-1day") . '"
');
$newmembers = number_format($newusers['count']);
$GLOBALS['VARIABLE']
Si deseas que eso funcione, prueba con engancharlo en el global_star y desde ahi ya estará disponible en todas las plantillas, si no lo lees, prueba con este formato
PHP:$GLOBALS['VARIABLE']
$numberguest= $db->query_first('
SELECT COUNT(*) AS count (y esta linea tampoco se que poner)
FROM ' . TABLE_PREFIX . 'user (evidenetemente aqui no es user, no se que iria)
');
$numberguest= number_format($numberguest['count']);
select count(*) from session where userid=0
$newusers = $db->query_first('
SELECT COUNT(*)
from session where userid=0
WHERE "sesiondate"(aqui por ejemplo) >= "' . strtotime("-1day") . '"
');
$newmembers = number_format($newusers['count']);
// ### LOGGED IN USERS #######################
$numberguests = 0;
Verde: Parte que necesito cambiar, debido a que el fake users no le afecta, sin embargo si le afecta al PLUGIN ORIGINAL DE VBULLETIN, los stats del forumhome.<?xml version="1.0" encoding="ISO-8859-1"?>
<plugins>
<plugin active="1" product="vbulletin">
<title>Header Stats</title>
<hookname>global_start</hookname>
<phpcode><![CDATA[// forum stats start
$numbersmembers = $db->query_first("SELECT COUNT(*) AS users,MAX(userid) AS max FROM " . TABLE_PREFIX . "user");
$numbermembers = number_format($numbersmembers['users']);
$counter = $db->query_first("SELECT COUNT(postid) AS posts, COUNT(threadid) AS threads FROM " . TABLE_PREFIX . "post");
$totalposts=number_format($counter['posts']);
$countthreads = $db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread");
$totalthreads=number_format($countthreads['threads']);
// forum stats end
// total online start
$datecut = TIMENOW - $vbulletin->options['cookietimeout'];
$headerguests=$db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "session WHERE userid=0 AND lastactivity>$datecut");
$headerusers=$db->query_first("SELECT COUNT(DISTINCT(userid)) AS count FROM " . TABLE_PREFIX . "session WHERE " . TABLE_PREFIX . "session.userid>0 AND " . TABLE_PREFIX . "session.lastactivity>$datecut");
$headerguests=$headerguests[count];
$headerusers=$headerusers[count];
$totalonline=$headerguests+$headerusers;
// total online end
// get newest member name and userid start
$getnewestmember=$db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE " . TABLE_PREFIX . "userid=$numbersmembers[max]");
$newusername = $getnewestmember['username'];
$newuserid = $getnewestmember['userid'];
// get newest member name and userid end]]></phpcode>
</plugin>
</plugins>
Sabeis como hacer que los fakeusers se muestren tambien en mi header stats?if ($vbulletin->options['xfakeonoff']) {
$numbervisible2 = 0;
if ($vbulletin->options['xfakemn']>0)
{
$xsayi1 = $vbulletin->options['xfakemn'];
$xsayi2 = $vbulletin->options['xfakeug'];
$forumusers = $db->query("SELECT *,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "user WHERE usergroupid = '$xsayi2' ORDER BY RAND() LIMIT $xsayi1");
while ($loggedin = $db->fetch_array($forumusers))
{
$numbervisible2++;
fetch_musername($loggedin);
eval('$activeusers .= "' . fetch_template('forumhome_loggedinuser') . '";');
}
}
$totalonline = $totalonline + $numbervisible2 + $vbulletin->options['xfakemv'];
$numberguest = $numberguest + $vbulletin->options['xfakemv'];
$numberregistered = $numberregistered + $numbervisible2;
unset($forumusers, $loggedin, $numbervisible2, $xsayi1);
$db->free_result($forumusers);
}
$totalonline
$GLOBALS[totalonline]
$totalonline=13;
$totalonline=$headerguests+$headerusers+$vbulletin->options['xfakemv'];
Utilizamos cookies y tecnologías similares para los siguientes fines:
¿Aceptas las cookies y estas tecnologías?
Utilizamos cookies y tecnologías similares para los siguientes fines:
¿Aceptas las cookies y estas tecnologías?