<?PHP
if (!IsSet($mainfile)) { include ('mainfile.php'); }
include("header.php");
require_once("mainfile.php"); 
$module_name = basename(dirname(__FILE__)); 
require_once("modules/$module_name/config.php"); 
OpenTable();
include("menu.htm");
CloseTable();
global $prefix, $nameclan, $centercolor, $footercolor, $headercolor, $db;
$sql = "select pid, clan, email, icq, datetime, starttime, endtime, message from ".$prefix."_request ORDER BY poziciu";
$res = $db->sql_query($sql);
$pid = $row[pid];
OpenTable();
echo "<table width=100% border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#000000\">";
 echo" <!--DWLayoutTable-->";
 echo"  <tr>";
 echo"  <td height=\"15\" colspan=\"2\" valign=\"middle\" bgcolor=\"$headercolor\"><div align=\"center\">Êëàíû</div></td>";
 echo"  <td width=\"49\" valign=\"middle\"  bgcolor=\"$headercolor\"><div align=\"center\">e-mail</div></td>";
 echo"  <td width=\"37\" valign=\"middle\"  bgcolor=\"$headercolor\"><div align=\"center\">ICQ</div></td>";
 echo"  <td width=\"148\" valign=\"middle\" bgcolor=\"$headercolor\"><div align=\"center\">Âðåìÿ</div></td>";
 echo"  <td width=\"150\" valign=\"middle\" bgcolor=\"$headercolor\"><div align=\"center\">Êîììåíòàðèé</div></td>";
 echo"  </tr>";
while ($row = mysql_fetch_assoc($res))
{
$pid = $row[pid];
$clan = $row[clan];
$email = $row[email];
$icq = $row[icq];
$datetime = $row[datetime];
$starttime = $row[starttime];
$endtime = $row[endtime];
$message = $row[message];

echo "<tr>";
 echo" <td width=\"20\" height=\"20\" valign=\"middle\" bgcolor=\"$centercolor\"><div align=\"center\">";
 if (cs!= "")
 {
 echo "<img src=\"modules/server/images/game/cs.gif\" alt=\"CounterStrike\" width=\"12\" height=\"12\">";

 } else {
 echo"N/A";
 }
 echo" </div></td>";
 echo" <td width=\"221\" valign=\"middle\" bgcolor=\"$centercolor\"><u><b><left>$clan</center></b></u></td>";
 echo" <td width=\"221\" valign=\"middle\" bgcolor=\"$centercolor\"> &nbsp;$email</a></td>";
 echo" <td valign=\"middle\" bgcolor=\"$centercolor\"><div align=\"center\"> ";
 if ($email!= "")
 {
 echo" <a href=\"mailto:$email\"><img src=\"modules/server/images/mail.gif\" alt=\"Написать письмо $email \" border=\"0\">";
 } else {
 echo"N/A";
 }
 echo"</a></div></td>";
 echo"  <td valign=\"middle\" bgcolor=\"$centercolor\"><div align=\"center\">";
 if ($icq!= "")
 {
 echo "<a href=\"http://wwp.icq.com/scripts/search.dll?to=$icq\"><img src=\"http://web.icq.com/whitepages/online?icq=$icq&img=5\" alt=\"$icq\" width=\"20\" height=\"20\" border=\"0\"></a>";

 } else {
 echo "N/A";
 }
 echo "</div></td>";
 echo" <td valign=\"middle\" bgcolor=\"$centercolor\"><div align=\"center\">";
 if ($datetime!= "")
 {
 echo "$datetime";
 } else {
 echo "N/A";
 }
 echo "</div></td>";
 echo" <td valign=\"middle\" bgcolor=\"$centercolor\"><div align=\"center\">";
 if ($starttime!= "")
 {
 echo " $starttime - $endtime";
 }
 else
 {
 echo "N/A";
 }
 echo "</div></td>";
  echo" <td valign=\"middle\" bgcolor=\"$centercolor\"><div align=\"center\">";
 if ($message!= "")
 {
 echo " $message";
 }
 else
 {
 echo "N/A";
 }
 echo "</div></td>";
 echo" </tr>";
}
echo "<tr bgcolor=\"$footercolor\">";
 echo"   <td height=\"8\" colspan=\"6\" valign=\"top\">&nbsp;</td>";
 echo"  </tr>";
 echo"  </table>";
 echo"$copy";  
CloseTable();
echo "$copy";
CloseTable();
include("footer.php");
?>

 
select pid, clan, email, icq, datetime, starttime, endtime, message from ".$prefix."_request ORDER BY poziciu