thepurge.php

   1 <?php include "config.php";
   2 function updatelevel($userid, $newlev)
   3 {
   4         $sql = "UPDATE users SET level='$newlev' WHERE userid='$userid'";
   5         $result = mysql_query($sql);
   6 }
   7 function updateposts($userid)
   8 {
   9         $sql = "UPDATE users SET poststoday='0' WHERE userid='$userid'";
  10         $result = mysql_query($sql);
  11         $sql = "UPDATE users SET topicstoday='0' WHERE userid='$userid'";
  12         $result = mysql_query($sql);
  13 }
  14 $sql = "SELECT * FROM users WHERE userid>0";
  15 $result = mysql_query($sql);
  16 echo mysql_error();
  17 while ($myrow = mysql_fetch_array($result))
  18 {
  19         if ($myrow["cookies"] <= -20)
  20         {
  21                 $theuserid = $myrow["userid"];
  22                 $sql = "UPDATE users SET cookies=0 WHERE userid='$theuserid'";
  23                 $result = mysql_query($sql);
  24                 $sql = "UPDATE users SET faction=0 WHERE userid='$theuserid'";
  25                 $result = mysql_query($sql);
  26                 $sql = "UPDATE users SET level=5 WHERE userid='$theuserid'";
  27                 $result = mysql_query($sql);
  28                 $sql = "UPDATE users SET attack=0 WHERE userid='$theuserid'";
  29                 $result = mysql_query($sql);
  30                 $sql = "UPDATE users SET money=0 WHERE userid='$theuserid'";
  31                 $result = mysql_query($sql);
  32                 $sql = "UPDATE users SET turns=0 WHERE userid='$theuserid'";
  33                 $result = mysql_query($sql);
  34                 $sql = "UPDATE users SET attackout=0 WHERE userid='$theuserid'";
  35                 $result = mysql_query($sql);
  36                 $sql = "UPDATE users SET attacked=0 WHERE userid='$theuserid'";
  37                 $result = mysql_query($sql);
  38         }
  39         if ($myrow["level"] == 15 AND $myrow["cookies"] >= 20)
  40         {
  41                 updatelevel($myrow["userid"], 30);
  42         }
  43         if ($myrow["level"] == 30 AND $myrow["cookies"] >= 50)
  44         {
  45                 updatelevel($myrow["userid"], 31);
  46         }
  47         if ($myrow["level"] == 31 AND $myrow["cookies"] >= 500)
  48         {
  49                 updatelevel($myrow["userid"], 32);
  50         }
  51         $time = time() - 172800;
  52         if ($myrow["level"] == 0 AND $myrow["regsec"] < $time)
  53         {
  54                 $theuserid = $myrow["userid"];
  55                 $sql = "DELETE FROM users WHERE userid='$theuserid'";
  56                 $result = mysql_query($sql);
  57         }
  58 }
  59 $sql = "SELECT * FROM topics ORDER BY topicid DESC";
  60 $ressult = mysql_query($sql);
  61 echo mysql_error();
  62 $timetime = time() - 1209600;
  63 while ($myrow = mysql_fetch_array($ressult))
  64 {
  65         if ($myrow["timesec"] < $timetime)
  66         {
  67                 $topic = $myrow["topicid"];
  68                 $sql = "DELETE FROM topics WHERE topicid='$topic'";
  69                 $result = mysql_query($sql);
  70                 $sql = "DELETE FROM messages WHERE topic='$topic'";
  71                 $result = mysql_query($sql);
  72         }
  73 }
  74 // updateposts($myrow["userid"]);
  75 echo "go purge!";
  76 ?>