minor php adjustment

Discussion in 'PHP' started by demons-halo, Sep 24, 2009.

  1. #1
    I want to take away the 'brave' in this script, i dont want it updating every 5 mins? i think thats what it does, how can i take this out??

    This is a file run on a cron job that gets executed every 5 mins

    <?php
    include "config.php";
    global $_CONFIG;
    if($_GET['code'] != $_CONFIG['code']) { die(""); }
    define("MONO_ON", 1);
    require "class/class_db_{$_CONFIG['driver']}.php";
    $db=new database;
    $db->configure($_CONFIG['hostname'],
     $_CONFIG['username'],
     $_CONFIG['password'],
     $_CONFIG['database'],
     $_CONFIG['persistent']);
    $db->connect();
    $c=$db->connection_id;
    $set=array();
    $settq=$db->query("SELECT * FROM settings");
    while($r=$db->fetch_row($settq))
    {
    $set[$r['conf_name']]=$r['conf_value'];
    }
    //brave update
    $query="UPDATE users SET brave=brave+((maxbrave/10)+0.5) WHERE brave<maxbrave ";
    $query2="UPDATE users SET brave=maxbrave WHERE brave>maxbrave";
    $query3="UPDATE users SET hp=hp+(maxhp/3) WHERE hp<maxhp";
    $query4="UPDATE users SET hp=maxhp WHERE hp>maxhp";
    $db->query($query);
    $db->query($query2);
    $db->query($query3);
    $db->query($query4);
    //enerwill update
    $query="UPDATE users SET energy=energy+(maxenergy/(12.5)) WHERE energy<maxenergy AND donatordays=0";
    $query5="UPDATE users SET energy=energy+(maxenergy/(6)) WHERE energy<maxenergy AND donatordays>0";
    $query2="UPDATE users SET energy=maxenergy WHERE energy>maxenergy";
    $query3="UPDATE users SET will=will+10 WHERE will<maxwill";
    $query4="UPDATE users SET will=maxwill WHERE will>maxwill";
    $db->query($query);
    $db->query($query5);
    $db->query($query2);
    $db->query($query3);
    $db->query($query4);
    if($set['validate_period'] == 5 && $set['validate_on'])
    {
    $db->query("UPDATE users SET verified=0");
    }
    if($set['validate_period'] == 15 && $set['validate_on'] && in_array(date('i'),array("00", "15", "30", "45")))
    {
    $db->query("UPDATE users SET verified=0");
    }
    ?>
    
    PHP:
    I want to put the 'brave' into a this cron job file which gets executed every 24 hours

    <?php
    include "config.php";
    global $_CONFIG;
    if($_GET['code'] != $_CONFIG['code']) { die(""); }
    define("MONO_ON", 1);
    require "class/class_db_{$_CONFIG['driver']}.php";
    $db=new database;
    $db->configure($_CONFIG['hostname'],
     $_CONFIG['username'],
     $_CONFIG['password'],
     $_CONFIG['database'],
     $_CONFIG['persistent']);
    $db->connect();
    $c=$db->connection_id;
    $db->query("UPDATE fedjail set fed_days=fed_days-1");
    $q=$db->query("SELECT * FROM fedjail WHERE fed_days=0");
    $ids=array();
    while($r=$db->fetch_row($q))
    {
    $ids[]=$r['fed_userid'];
    }
    if(count($ids) > 0)
    {
    $db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")");
    }
    $db->query("DELETE FROM fedjail WHERE fed_days=0");
    $db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0");
    $db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0");
    $db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
    $db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
    $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
    $db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0");
    $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0");
    $q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0");
    while($r=$db->fetch_row($q))
    {
    $cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}");
    $coud=$db->fetch_row($cd);
    $userid=$r['userid'];
    $db->query("INSERT INTO coursesdone VALUES({$r['userid']},{$r['course']})");
    $upd="";
    $ev="";
    if($coud['crSTR'] > 0)
    {
    $upd.=",us.strength=us.strength+{$coud['crSTR']}";
    $ev.=", {$coud['crSTR']} strength";
    }
    if($coud['crGUARD'] > 0)
    {
    $upd.=",us.guard=us.guard+{$coud['crGUARD']}";
    $ev.=", {$coud['crGUARD']} guard";
    }
    if($coud['crLABOUR'] > 0)
    {
    $upd.=",us.labour=us.labour+{$coud['crLABOUR']}";
    $ev.=", {$coud['crLABOUR']} labour";
    }
    if($coud['crAGIL'] > 0)
    {
    $upd.=",us.agility=us.agility+{$coud['crAGIL']}";
    $ev.=", {$coud['crAGIL']} agility";
    }
    if($coud['crIQ'] > 0)
    {
    $upd.=",us.IQ=us.IQ+{$coud['crIQ']}";
    $ev.=", {$coud['crIQ']} IQ";
    }
    $ev=substr($ev,1);
    if ($upd) {
    $db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid SET us.userid=us.userid $upd WHERE u.userid=$userid");
    }
    $db->query("INSERT INTO events VALUES('',$userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')");
    }
    $db->query("UPDATE users SET course=0 WHERE cdays=0");
    $db->query("TRUNCATE TABLE votes;");
    ?>
    
    PHP:
     
    demons-halo, Sep 24, 2009 IP
  2. dweebsonduty

    dweebsonduty Active Member

    Messages:
    131
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    71
    Digital Goods:
    1
    #2
    This is the code that does the Brave Stuff.

    
    $query="UPDATE users SET brave=brave+((maxbrave/10)+0.5) WHERE brave<maxbrave ";
    
    $query2="UPDATE users SET brave=maxbrave WHERE brave>maxbrave";
    
    $db->query($query);
    $db->query($query2);
    
    PHP:
    Take it out and add this to the other file

    
    $db->query("UPDATE users SET brave=brave+((maxbrave/10)+0.5) WHERE brave<maxbrave ");
    $db->query("UPDATE users SET brave=maxbrave WHERE brave>maxbrave");
    
    PHP:
     
    dweebsonduty, Sep 24, 2009 IP