function pointConversion($conn, $total, $id) { $before = getPoints($conn, $id); $points = 0; if ($total >= 49000 && $total <= 69999) { $points = 10; } else { if ($total >= 70000 && $total <= 90999) { $points = 15; } else { if ($total >= 91000 && $total <= 111999) { $points = 20; } else { if ($total >= 112000 && $total <= 132999) { $points = 25; } else { if ($total >= 133000) { $points = 30; } } } } } $after = $before + $points; setPoints($conn, $id, $after); }
<?php require_once './www.playconquest.com/db_connect.php'; //require_once('./db_connect.php'); $servercount = getServerNumber(); for ($x = 1; $x < $servercount + 1; $x++) { $query = "SELECT researchmod,ownerid FROM planets{$x} WHERE researchmod>0"; $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { $points = getPoints($x, $row[ownerid]); $points += $row[researchmod]; setPoints($points, $x, $row[ownerid]); } }
function addResearch($rid, $sid, $id) { //Get the points $points = getPoints($sid, $id); //Get the cost and check that the user has enough points $points -= getResearchStat(points, $rid); if ($points < 0) { return false; } //Add the research $type = getResearchStat(type, $rid); $query = "INSERT INTO tech{$sid}(ownerid,techid,type) VALUES({$id},{$rid},{$type})"; $result = @mysql_query($query); if ($result) { //Take the points setPoints($points, $sid, $id); return true; } else { return false; } }