Location: PHPKode > scripts > OekakiPoteto > oekakipoteto/delcomments.php
<?
include('dbconn.php');
include('flagchk.php');
$result = mysql_query("SELECT usrname, usrflags, usrpass FROM ".$OekakiPoteto_MemberPrefix."oekaki WHERE usrname='$OekakiU'");
extract(mysql_fetch_array($result));

if($OekakiPass != $usrpass){
header('Location: index.php');
exit;
}
if ((!check_flag('O')) && (!check_flag('S')) && (!check_flag('A'))) {
	header('Location: error.php?error='.urlencode("You do not have the credentials to access flag modification."));
exit;
}
mysql_close($dbconn);
?>
<html>
<?
include('header.php');
$result5 = mysql_query("SELECT count(postdate) as rowno FROM ".$OekakiPoteto_Prefix."oekakicmt");
$rownum2 = mysql_result($result5, 0, 'rowno');
$pages = intval($rownum2/10) + 1;
$rsql = "SELECT postdate as rowno FROM ".$OekakiPoteto_Prefix."oekakicmt LIMIT ".($pageno*10).", 10";
$result5 = mysql_query($rsql);
$rownum = mysql_numrows($result5);
$rsql2 = "SELECT * FROM ".$OekakiPoteto_Prefix."oekakicmt order by postdate DESC LIMIT ".($pageno*10).", 10";
$result2 = mysql_query($rsql2);
$i = 0;
?>
<p></p>
<br>
<br>
<table width="<?=$hWidth?>" cellpadding="<?=$hCellPadding?>" align="center" cellspacing="2" class="infotable">
  <tr> 
    <td> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td class="infotable"> <b><font size="-2"><?=$langop_common_moveto?>: 
            <? WHILE ($i4 < $pages):?>
            [ <a href="delcomments.php?pageno=<?=$i4?>"> 
            <?=$i4+1?></a> ]
            <? 
$i4++;
endwhile;?>
            </font></b><br>
            <table width="100%" border="0" cellspacing="1" cellpadding="3">
              <tr> 
                <td colspan="6" class="header"><?=$langop_comment_database?> </td>
              </tr>
              <? 
WHILE ($i < $rownum):
?>
              <tr> 
                <td width="7%"> 
                  <div align="center">
                    <?=mysql_result($result2,$i,"PIC_ID");?>
                  </div>
                </td>
                <td width="7%"> 
                  <div align="center">
                    <? if (mysql_result($result2,$i,"usrname") =="Guest") { ?>
                    <?=mysql_result($result2,$i,"postname");?>
                    (<?=$langop_word_guest?>) 
                    <?} else { ?>
                    <?=mysql_result($result2,$i,"usrname");?>
                    <? }?>
                  </div>
                </td>
                <td width="14%"> 
                  <div align="center">
                    <?=mysql_result($result2,$i,"IP");?>
                    / 
                    <?=mysql_result($result2,$i,"hostname");?>
                    </div>
                </td>
                <td width="19%"> 
                  <div align="center">
                    <?=mysql_result($result2,$i,"postdate");?>
                  </div>
                </td>
                <td width="28%"> 
                  <div align="center">
                    <?=nifty2_convert(mysql_result($result2,$i,"comment"));?>
                    </div>
                </td>
                <td width="12%"> 
                  <div align="center"><a href="functions.php?mode=delcmt&cmtno=<?=mysql_result($result2,$i,"ID_3");?>"><?=$langop_word_delete?></a></div>
                </td>
              </tr>
              <?
$i++; 
endwhile; 
mysql_close($dbconn);
?>
            </table>
            <p align="center">&nbsp;</p>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<br>
<br>
<? include('footer.php'); ?>
</body>
Return current item: OekakiPoteto