Ibwf_online

[adex3g]

Please can anybody give the original ibwf_online, i rewrite mine lol.

[subzero]

you mean you broke it right?? lol

[adex3g]

I am using lava by my table is rewrite by me and is working fine. And i dont want to use lava anymore, i want to rewrite all the table back and post my lavascript here. Before i clean my server for my new script.

[subzero]

else if($action=="online")
{

  addonline(getuid_sid($sid),"Online List","");
    echo "<card id=\"main\" title=\"ONLINE\">";


  //////ALL LISTS SCRIPT <<

    if($page=="" || $page<=0)$page=1;
    $num_items = getnumonline(); //changable
    $items_per_page= 10;
    $num_pages = ceil($num_items/$items_per_page);
    if($page>$num_pages)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;
    
    //changable sql
    $sql = "SELECT
            a.name, b.place, b.userid FROM ibwf_users a
            INNER JOIN ibwf_online b ON a.id = b.userid
            GROUP BY 1,2
            LIMIT $limit_start, $items_per_page
    ";
     echo "<p align=\"center\">";
  		$timeout = 180;
  		$timeon = time()-$timeout;
  		$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE perm>'0' AND lastact>'".$timeon."'"));
  		echo "Staff Online: <a href=\"index.php?action=stfol&amp;sid=$sid\">".$noi[0]."</a>";
      	echo "<br/></p>";

    echo "<p><small>";
    $items = mysql_query($sql);
    echo mysql_error();
    while ($item = mysql_fetch_array($items))
    {
	$getsex = mysql_fetch_array(mysql_query("SELECT sex FROM ibwf_users WHERE id='".$item[2]."'"));
	if($getsex[0]=="M")
	{
		$sexicon = "<img src=\"images/male.gif\" alt=\"M\"/>";
	}else if($getsex[0]=="F")
	{
		$sexicon = "<img src=\"images/female.gif\" alt=\"F\"/>";
	}else{
		$sexicon = "";
	}

      $lnk = "".$sexicon."<a href=\"index.php?action=viewuser&amp;who=$item[2]&amp;sid=$sid\">$item[0]</a>";
      echo "$lnk - $item[1] <br/>";
    }
    echo "</small></p>";
    echo "<p align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"index.php?action=online&amp;page=$ppage&amp;sid=$sid\">&#171;PREV</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"index.php?action=online&amp;page=$npage&amp;sid=$sid\">Next&#187;</a>";
    }
    echo "<br/>$page/$num_pages<br/>";
    if($num_pages>2)
    {
      echo getjumper($action, $sid,"index");
    }
    echo "</p>";
  ////// UNTILL HERE >>

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

[adex3g]

That why i like u and rider, you guyz ready to help people, God help u too. Thanks, i will write the sql from that lol.

[subzero]

thats our jobs help and keep things clean. lol

[amylee]

original ibwf_online

-- --------------------------------------------------------

--
-- Table structure for table 'ibwf_online'
--

DROP TABLE IF EXISTS ibwf_online;
CREATE TABLE IF NOT EXISTS ibwf_online (
  id int(10) NOT NULL auto_increment,
  userid int(100) NOT NULL default '0',
  actvtime int(100) NOT NULL default '0',
  place varchar(50) NOT NULL default '',
  placedet varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY userid (userid)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

[adex3g]

Thanks @amylee