PimpYourKiT

PHP-Quelltext

<?php

###### Configeinstellungen ################################
$loeschtime = '1095'; # Gib hier die Anzahl der Tage ein
###########################################################

####### Ab hier nichts mehr ändern !!! ####################
        $loeschDeak = $loeschtime*86400;
        $fourteenday = (pkTIME-$loeschDeak);
        

      if (isset($_POST['action'])) $ACTION = $_POST['action'];
      else $ACTION = 'non';
      if (isset($_POST['save']) && $ACTION == $_POST['save']){
      
$getforumpostcroninfo = $SQL->query("SELECT * FROM ".pkSQLTAB_FORUM_POST." WHERE forumpost_time <= '".$fourteenday."'");
      while ($forumpostcroninfo = $SQL->fetch_array($getforumpostcroninfo))
{
    $SQL->query("DELETE FROM 
    ".pkSQLTAB_FORUM_POST." 
    WHERE forumpost_id='".$SQL->i($forumpostcroninfo['forumpost_id'])."'");


$threadinfo = $SQL->fetch_array($SQL->query("SELECT * FROM ".pkSQLTAB_FORUM_THREAD." WHERE forumthread_lastreply_time <= '".$fourteenday."'"));
$threadid = $SQL->i($threadinfo['forumthread_id']);
$countforumposts2 = $SQL->fetch_array($SQL->query("SELECT COUNT(forumpost_id) FROM ".pkSQLTAB_FORUM_POST." WHERE forumpost_threadid = '".$threadid."'"));
$forumposts2 = $countforumposts2[0];
if($forumposts2 == 0)
    {
    $SQL->query("DELETE FROM 
    ".pkSQLTAB_FORUM_THREAD." 
    WHERE forumthread_id='".$SQL->i($threadinfo['forumthread_id'])."'");
    }


}
        header ("location: ?path=forumpostdel"); exit();
    } else {

$formdisable='';
$countforumposts = $SQL->fetch_array($SQL->query("SELECT COUNT(forumpost_id) FROM ".pkSQLTAB_FORUM_POST." WHERE forumpost_time <= '".$fourteenday."'"));
    if ($countforumposts[0] == 0){$anzahlforenposts ='0';$formdisable='disabled="disabled"';}else{$anzahlforenposts = $countforumposts[0];}

if(getrights('admin')){
   $site_body='
<form method="post" action="?path=forumpostdel">
<table class="standard" border="0" cellspacing="1" cellpadding="3" width="100%">
<tr>
  <td class="heads" colspan="2">
        <table border="0" cellspacing="0" cellpadding="0" width="100%">
      <tr>
          <td width="100%"><font class="heads"><b>alte Forumposts l&ouml;schen</b></font></td>
      </tr>
        </table>
  </td>
 </tr>

 <tr>
  <td class="left" width="30%"><b>Anzahl der Posts</b><br />
        <span class="small">Hier wird dir die Anzahl der Forenposts angezeigt, die gel&ouml;scht werden.</span></td>
  <td class="right" width="45%">
        '.$anzahlforenposts.'
        </td>
 </tr>
 <tr>
  <td colspan="2" class="heads" align="center">
        <input type="submit" name="action" value="'.$lang['save'].'" '.$formdisable.' />
        <input type="hidden" name="save" value="'.$lang['save'].'" />
  </td>
 </tr>
</table>
</form>
';
}else{
        header ("location: ?path=start"); exit();
}

}



?>