Location: PHPKode > scripts > OekakiPoteto > oekakipoteto/recover.php
<html>
<?
include('header.php');
$result5 = mysql_query("SELECT count(ID_2) as rowno FROM ".$OekakiPoteto_Prefix."oekakidta where postlock='0' and usrname='$OekakiU'");
$rownum2 = mysql_result($result5, 0, 'rowno');
$pages = intval($rownum2/$ppage) + 1;
$rsql = "SELECT ID_2 as rowno FROM ".$OekakiPoteto_Prefix."oekakidta where postlock='0' and usrname='$OekakiU' LIMIT ".($pageno*$ppage).", $ppage";
$result5 = mysql_query($rsql);
$rownum = mysql_numrows($result5);
$rsql2 = "SELECT * FROM ".$OekakiPoteto_Prefix."oekakidta where postlock='0' and usrname='$OekakiU' 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>
      <form name="form1" method="post" action="functions.php">
        <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="ldelpics.php?pageno=<?=$i4?>"> 
                    <?=$i4+1?>
                    </a> ] 
                    <? 
$i4++;
endwhile;?>
                    </font></b><br> 
                    <table width="100%" border="0" cellspacing="1" cellpadding="4" class="infotable">
                      <tr> 
                        <td colspan="4" class="header"><?=$langop_picrecover_title?></td>
                      </tr>
                      <? 
WHILE ($i < $rownum):
?>
                      <tr> 
                        <td width="7%"> <div align="center"> 
                            <?=mysql_result($result2,$i,"PIC_ID");?>
                          </div></td>
                        <td width="16%" ><a href="<?=$OPpics?>/<?=mysql_result($result2,$i,"PIC_ID");?>.png" target="okpic"> 
                          <img src="<?=$OPpics?>/<?=mysql_result($result2,$i,"PIC_ID");?>.png" width="25%"></a> 
                        </td>
                        <td width="16%" > <div align="center"> 
                            <?=mysql_result($result2,$i,"postdate");?>
                          </div></td>
                        <td width="12%"> <div align="center"><a href="editpic.php?picno=<?=mysql_result($result2,$i,"PIC_ID");?>"><?=$langop_word_recover?></a></div></td>
                      </tr>
                      <?
$i++; 
endwhile; 
mysql_close($dbconn);
?>
                    </table></td>
                </tr>
              </table></td>
          </tr>
        </table>
      </form></td>
  </tr>
</table>
<br>
<br>
<? include('footer.php'); ?>
</body>
Return current item: OekakiPoteto