Location: PHPKode > scripts > OekakiPoteto > oekakipoteto/delpics.php
<?
include('dbconn.php');
include('flagchk.php');
include('config.php');
$result = mysql_query("SELECT usrname, usrpass, usrflags 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(ID_2) as rowno FROM ".$OekakiPoteto_Prefix."oekakidta where postlock='1'");
$rownum2 = mysql_result($result5, 0, 'rowno');
$pages = intval($rownum2/$ppage) + 1;
$rsql = "SELECT ID_2 as rowno FROM ".$OekakiPoteto_Prefix."oekakidta where postlock='1' LIMIT ".($pageno*$ppage).", $ppage";
$result5 = mysql_query($rsql);
$rownum = mysql_numrows($result5);
$rsql2 = "SELECT * FROM ".$OekakiPoteto_Prefix."oekakidta where postlock='1' order by ID_2 DESC LIMIT ".($pageno*$ppage).", $ppage";
$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> <b><font size="-2"><?=$langop_common_moveto?>: 
            <? WHILE ($i4 < $pages):?>
            [ <a href="delpics.php?pageno=<?=$i4?>">
            <?=$i4+1?></a> ]
            <? 
$i4++;
endwhile;?>
            </font></b><br>
            <table width="100%" border="0" cellspacing="1" cellpadding="3" class="infotable">
              <tr> 
                <td colspan="7" class="header"><?=$langop_gpicdb_title?></td>
              </tr>
        <? 
WHILE ($i < $rownum):
?>
        <tr> 
          <td width="7%"> 
            <div align="center">
              
              <?=mysql_result($result2,$i,"PIC_ID");?>
           </div>
          </td>
          <td width="13%"> 
            <div align="center">
              <?=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="16%" > 
            <div align="center">
              <?=mysql_result($result2,$i,"postdate");?>
           </div>
          </td>
                <td width="16%"> 
                  <div align="center">
<a href="<?=$OPpics?>/<?=mysql_result($result2,$i,"PIC_ID");?>.png" target="okpic">
<img src="<?=$OPpics?>/<?=mysql_result($result2,$i,"PIC_ID");?>.png" width="25%"><br><?=nifty2_convert(mysql_result($result2,$i,"title"));?>
</a>

              </div>
          </td>
                <td width="22%"> 
                  <div align="center">
              <?=nifty2_convert(mysql_result($result2,$i,"comment"));?>
              </div>
          </td>
                <td width="12%"> 
                  <div align="center"><a href="delconf.php?mode=dela&picno=<?=mysql_result($result2,$i,"PIC_ID");?>"><?=$langop_word_delete?></a></div>
          </td>
        </tr>
        <?
$i++; 
endwhile; 
mysql_close($dbconn);
?>
      </table>
      
    </td>
  </tr>
</table>
</td>
  </tr>
</table>
<br>
<br>
<? include('footer.php'); ?>
</body>
Return current item: OekakiPoteto