SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | session_start(); | |
| 3 | include 'db.php'; | |
| 4 | $resourceLumberHouse = array('35','100','250','400','650','800','1050','1300','1600','2000','2500','3000','3750','4600','5250','6000','7000','8500','10000','11750','13000');
| |
| 5 | $resourceClayPit = array('35','100','250','400','650','800','1050','1300','1600','2000','2500','3000','3750','4600','5250','6000','7000','8500','10000','11750','13000');
| |
| 6 | $resourceMine = array('35','100','250','400','650','800','1050','1300','1600','2000','2500','3000','3750','4600','5250','6000','7000','8500','10000','11750','13000');
| |
| 7 | $warehouseStorage = array('250','1000','2000','3500','6000','9000','15000','20000','27500','37500','50000','65000','80000','100000','130000','175000','225000','300000','400000','550000','725000');
| |
| 8 | ||
| 9 | $ir = $db->prepare('SELECT RESOURCEtimestamp,LUMBERHOUSElevel,CLAYPITlevel,MINElevel,WAREHOUSElevel,logs,clay,metal FROM villages WHERE owner = ? AND id = ?');
| |
| 10 | $array = array($_SESSION['id'], $_SESSION['viewing']); | |
| 11 | $ir->execute($array); | |
| 12 | $r = $ir->fetch(); | |
| 13 | ||
| 14 | $lasttime = $r['RESOURCEtimestamp']; | |
| 15 | ||
| 16 | $now = date_timestamp_get(date_create()); | |
| 17 | ||
| 18 | $difference = $now - $lasttime; | |
| 19 | ||
| 20 | $logsPerSec = $resourceLumberHouse[$r['LUMBERHOUSElevel']] / 60; | |
| 21 | $clayPerSec = $resourceClayPit[$r['CLAYPITlevel']] / 60; | |
| 22 | $metalPerSec = $resourceMine[$r['MINElevel']] / 60; | |
| 23 | ||
| 24 | $logsMade = $difference * $logsPerSec; | |
| 25 | $clayMade = $difference * $clayPerSec; | |
| 26 | $metalMade = $difference * $metalPerSec; | |
| 27 | ||
| 28 | $max = $warehouseStorage[$r['WAREHOUSElevel']]; | |
| 29 | ||
| 30 | $qr = $db->prepare("UPDATE villages SET logs = logs + ? WHERE owner = ? AND id = ? AND logs < ?");
| |
| 31 | $array = array($logsMade,$_SESSION['id'], $_SESSION['viewing'], $max); | |
| 32 | $qr->execute($array); | |
| 33 | $qr = $db->prepare("UPDATE villages SET clay = clay + ? WHERE owner = ? AND id = ? AND clay < ?");
| |
| 34 | $array = array($metalMade,$_SESSION['id'], $_SESSION['viewing'], $max); | |
| 35 | $qr->execute($array); | |
| 36 | $qr = $db->prepare("UPDATE villages SET metal = metal + ? WHERE owner = ? AND id = ? AND clay < ?");
| |
| 37 | $array = array($clayMade,$_SESSION['id'], $_SESSION['viewing'], $max); | |
| 38 | $qr->execute($array); | |
| 39 | ||
| 40 | $qr = $db->prepare("UPDATE villages SET logs = ? WHERE owner = ? AND id = ? AND logs > ?");
| |
| 41 | $array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max); | |
| 42 | $qr->execute($array); | |
| 43 | - | $qr = $db->prepare("UPDATE villages SET clay = ? WHERE owner = ? AND id = ? AND logs > ?");
|
| 43 | + | $qr = $db->prepare("UPDATE villages SET clay = ? WHERE owner = ? AND id = ? AND clay > ?");
|
| 44 | $array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max); | |
| 45 | $qr->execute($array); | |
| 46 | - | $qr = $db->prepare("UPDATE villages SET metal = ? WHERE owner = ? AND id = ? AND logs > ?");
|
| 46 | + | $qr = $db->prepare("UPDATE villages SET metal = ? WHERE owner = ? AND id = ? AND metal > ?");
|
| 47 | $array = array($max, $_SESSION['id'], $_SESSION['viewing'], $max); | |
| 48 | $qr->execute($array); | |
| 49 | ||
| 50 | $ir = $db->prepare("UPDATE villages SET RESOURCEtimestamp = {$now} WHERE owner = ? AND id = ?");
| |
| 51 | $array = array($_SESSION['id'], $_SESSION['viewing']); | |
| 52 | $ir->execute($array); | |
| 53 | ||
| 54 | ?> |
