<?php


if (!defined('MODULE_FILE')) die('You can\'t access this file directly...'); 


require_once('mainfile.php'); 


require_once('../LootWhore/Connections/LWC.php');


$module_name = basename(dirname(__FILE__)); 


get_lang($module_name); 


$pagetitle = '- You Module Name'; // If you need this to be multi-lingual then you will have to use language defines 


include_once 'header.php';  





$currentPage = $_SERVER["PHP_SELF"];


$maxRows_Cards = 10;


$pageNum_Cards = 0;


if (isset($_GET['pageNum_Cards'])) {


  $pageNum_Cards = $_GET['pageNum_Cards'];


}


$startRow_Cards = $pageNum_Cards * $maxRows_Cards;





$name = $_POST['select'];


mysql_select_db($database_LWC, $LWC);


$query_Cards = "SELECT Name, `Class`, Drops, Details FROM skill_cards WHERE skill_cards.`Class` REGEXP '$name' ORDER BY Name ASC";


$query_limit_Cards = sprintf("%s LIMIT %d, %d", $query_Cards, $startRow_Cards, $maxRows_Cards);


$Cards = mysql_query($query_limit_Cards, $LWC) or die(mysql_error());


$row_Cards = mysql_fetch_assoc($Cards);





if (isset($_GET['totalRows_Cards'])) {


  $totalRows_Cards = $_GET['totalRows_Cards'];


} else {


  $all_Cards = mysql_query($query_Cards);


  $totalRows_Cards = mysql_num_rows($all_Cards);


}


$totalPages_Cards = ceil($totalRows_Cards/$maxRows_Cards)-1;





$queryString_Cards = "";


if (!empty($_SERVER['QUERY_STRING'])) {


  $params = explode("&", $_SERVER['QUERY_STRING']);


  $newParams = array();


  foreach ($params as $param) {


    if (stristr($param, "pageNum_Cards") == false && 


        stristr($param, "totalRows_Cards") == false) {


      array_push($newParams, $param);


    }


  }


  if (count($newParams) != 0) {


    $queryString_Cards = "&" . htmlentities(implode("&", $newParams));


  }


}


$queryString_Cards = sprintf("&totalRows_Cards=%d%s", $totalRows_Cards, $queryString_Cards);








// Cut a bunch of code here, for table format and display.





        <table border="0" width="50%" align="center">


          <tr>


            <td width="23%" align="center"><?php if ($pageNum_Cards > 0) { // Show if not first page ?>


                  <a href="<?php printf("%s?pageNum_Cards=%d%s", $currentPage, 0, $queryString_Cards); ?>"><img src="First.gif" border=0></a>


                  <?php } // Show if not first page ?>


            </td>


            <td width="31%" align="center"><?php if ($pageNum_Cards > 0) { // Show if not first page ?>


                  <a href="<?php printf("%s?pageNum_Cards=%d%s", $currentPage, max(0, $pageNum_Cards - 1), $queryString_Cards); ?>"><img src="Previous.gif" border=0></a>


                  <?php } // Show if not first page ?>


            </td>


            <td width="23%" align="center"><?php if ($pageNum_Cards < $totalPages_Cards) { // Show if not last page ?>


                  <a href="<?php printf("%s?pageNum_Cards=%d%s", $currentPage, min($totalPages_Cards, $pageNum_Cards + 1), $queryString_Cards); ?>"><img src="Next.gif" border=0></a>


                  <?php } // Show if not last page ?>


            </td>


            <td width="23%" align="center"><?php if ($pageNum_Cards < $totalPages_Cards) { // Show if not last page ?>


                  <a href="<?php printf("%s?pageNum_Cards=%d%s", $currentPage, $totalPages_Cards, $queryString_Cards); ?>"><img src="Last.gif" border=0></a>


                  <?php } // Show if not last page ?>