View file wapirate/xhtml/slchests.php

World Fastest and Cheapest Hosting
File size: 1.82Kb
<html>

<head>

<title>SecondLife $L Helper</title>

<link rel="stylesheet" type="text/css" href="style.css">

<style type="text/css" media="screen">

.chat_time {

font-style: italic;

font-size: 9px;

}

</style>

</head>

<div class="header" align="center">SecondLife $L Helper</div>

<center>

<?php

include("slconfig.php");

$bcon = connectdb();

$page = $_GET["n"];

$r = $_GET["r"];

if(!$bcon){

echo "Sorry Backing Up Database Back Online Soon!<br/>";

}else{

if($page=="" || $page<=0)$page=1;

    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM scramble"));

    $num_items = $noi[0]; //changable

    $items_per_page= 50;

    $num_pages = ceil($num_items/$items_per_page);

    if(($page>$num_pages)&&$page!=1)$page= $num_pages;

    $limit_start = ($page-1)*$items_per_page;

$sql = "SELECT id, word FROM scramble ORDER BY id DESC LIMIT $limit_start, $items_per_page";

$items = mysql_query($sql);

if(mysql_num_rows($items)>0)

    {

while ($item = mysql_fetch_array($items))

   {



echo "<a href=\"$item[1]\">$item[2] </a> <a href=\"slchests.php?r=$item[0]\">Report Broke </a><br/>";

    }

    }

if($page>1)

    {

      $ppage = $page-1;

      echo "<a href=\"slchests.php?n=$ppage\">&#171;PREV</a> ";

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

      echo "<a href=\"slchests.php?n=$npage\">Next&#187;</a>";

    }

    echo "<br/>$page/$num_pages<br/>";



    if($num_pages>2)

    {

        $rets = "<form action=\"slchests.php\" method=\"get\">";

        $rets .= "<input name=\"n\" size=\"2\"/>";

        $rets .= "<input type=\"submit\" value=\"Go To Page\"/>";

        $rets .= "</form>";

        echo $rets;

    }





}



?>

</center><br/>

<div class="header" align="center">SecondLife $L Helper</div>

</body>

	

</html>