Top Online..

[WhiteWarrior]

sql?[/b]

tottimeonl int(100) default '0' NOT NULL

[busterkeaton10]

Im gonna try to see if i can fix the error and let yall know...[/b]

how about giving some plusses automatically when one memberr reached ex. 5 hrs...

[Dj-marc]

Thats a great idea......

[Dj-marc]

Thats a great idea......

[learner]

the code from hypeype only stay in zero why? i even make row in ibwf_users

[learner]

any idea why my total online not work in rw?

[Guest]

any idea why my total online not work in rw?[/b]

put your code here...i have that code if you need ;)

[wapmaster2]

yep its not working , database always showing 0 online time.

[friend]

<div class='quotetop'>QUOTE (hypetype @ Mar 20 2008, 06:03 PM) <{POST_SNAPBACK}></div>

this is my version

if($action=="onmembers")
{
    addonline(getuid_sid($sid),"Longest Online Members List","");
    $view = $_GET["view"];
    if($view=="")$view="date";
    echo "<card id=\"main\" title=\"Longest Online Members List\">";
    echo "<p align=\"center\">";
    echo "<img src=\"images/bdy.gif\" alt=\"*\"/>
";

    echo "</p>";
    //////ALL LISTS SCRIPT <<

    if($page=="" || $page<=0)$page=1;
    $num_items = regmemcount(); //changable
    $items_per_page= 10;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;

    //changable sql
    if($view=="name")
    {
        $sql = "SELECT id, name, regdate FROM ibwf_users ORDER BY name LIMIT $limit_start, $items_per_page";
    }else if ($view=="date"){
        $sql = "SELECT id, name, tottimeonl FROM ibwf_users ORDER BY tottimeonl DESC LIMIT $limit_start, $items_per_page";
    }else{
        $sql = "SELECT id, name, proviews FROM ibwf_users ORDER BY regdate DESC LIMIT $limit_start, $items_per_page";
    }

    echo "

";
    $items = mysql_query($sql);
    
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
      $jdt = date("d-m-y", $item[2]);

      $lnk = "<a href=\"index.php?action=viewuser&amp;who=$item[0]&amp;sid=$sid\">$item[1]</a> - ";
      echo "$lnk
";

//Add this where ever you want to show the total time online:
$totaltimeonline = mysql_fetch_array(mysql_query("SELECT tottimeonl FROM ibwf_users WHERE id=&#39;".$item[0]."&#39;"));
$num = $totaltimeonline[0]/86400;
$days = intval($num);
$num2 = ($num - $days)*24;
$hours = intval($num2);
$num3 = ($num2 - $hours)*60;
$mins = intval($num3);
$num4 = ($num3 - $mins)*60;
$secs = intval($num4);

echo "Total Time Online: 
";
if(($days==0) and ($hours==0) and ($mins==0)){
echo "[b]$secs[/b] seconds
";
}else
if(($days==0) and ($hours==0)){
echo "[b]$mins[/b] mins, ";
echo "[b]$secs[/b] seconds
";
}else
if(($days==0)){
echo "[b]$hours[/b] hours, ";
echo "[b]$mins[/b] mins, ";
echo "[b]$secs[/b] seconds
";
}else{
echo "[b]$days[/b] days, ";
echo "[b]$hours[/b] hours, ";
echo "[b]$mins[/b] mins, ";
echo "[b]$secs[/b] seconds
";
}



    }
    }
    echo "</p>";
    echo "<p align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"lists.php?action=onmembers&amp;page=$ppage&amp;sid=$sid&amp;view=$view\">«PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"lists.php?action=onmembers&amp;page=$npage&amp;sid=$sid&amp;view=$view\">Next»</a>";
    }
    echo "
$page/$num_pages
";
    if($num_pages>2)
    {
      $rets = "Jump to page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
        $rets .= "<anchor>[GO]";
        $rets .= "<go href=\"lists.php\" method=\"get\">";
        $rets .= "<postfield name=\"action\" value=\"$action\"/>";
        $rets .= "<postfield name=\"sid\" value=\"$sid\"/>";
        $rets .= "<postfield name=\"page\" value=\"$(pg)\"/>";
        $rets .= "<postfield name=\"view\" value=\"$view\"/>";
        $rets .= "</go></anchor>";

        echo $rets;
    }
    echo "</p>";
  ////// UNTILL HERE >>
    echo "<p align=\"center\">";
    echo "<a href=\"index.php?action=stats&amp;sid=$sid\"><img src=\"images/stat.gif\" alt=\"*\"/>";
echo "Site Stats</a>
";
    echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
  echo "</p>";
    echo "</card>";
}

[/b]

There is error in sql querry
mysql_num_rows doent exist

[wackywizards]

how can you claim to fix errors without having basic knowledge about php and mysql where you are just copier and paster?
add a new row in ibwf_users sql table

tottimeonl int(100) default'0' NOT NULL

link to be used for code supplied by powered

echo "<a href=\"lists.php?action=longon&amp;sid=$sid\">TopOnline<a/>";

keep getting a white page i got the coding right and sql right but still white page any one got this to work if so plz share thanks

[brand]

keep getting a white page i got the coding right and sql right but still white page any one got this to work if so plz share thanks

has any one got this working please

[wapmaster2]

everything is right but why not tottimeonl moving from 0 in database ??
plzz help !

[subzero]

that mite be sever error

[wapmaster2]

Thanks sub bro to come here ........
what should i request to serverman because i have register global ON