function deleteAlly($id) { $galas = selectsql("select gala from galaxy where aid = {$id}"); if ($galas) { #Galaxien löschen deleteGalaxy(getArrayFromList($galas, "gala")); } return query("delete from alliance where aid = {$id}"); }
function listLogfile($filter, $pages, $page = 1, $rows = 10) { if ($page < 0 || $rows < 0 || !is_numeric($page) || !is_numeric($rows)) { return; } #username if ($filter['username']) { if ($where) { $where .= " and "; } $where .= " u.nick LIKE '" . $filter['username'] . "%'"; } #koords if ($filter['gala']) { if ($where) { $where .= " and "; } $where .= " u.gala = " . $filter['gala'] . " "; } #category if ($filter['cat']) { if ($where) { $where .= " and "; } $where .= " l.cat = '" . $filter['cat'] . "'"; } if ($where) { $where = " where " . $where; } #order by if ($filter['order'] == "asc") { $order = " ASC "; } else { $order = " DESC "; } if ($filter['sort'] == "username") { $sort = " u.nick "; } elseif ($filter['sort'] == "cat") { $sort = " l.cat "; } elseif ($filter['sort'] == "date") { $sort = " l.time "; } else { $sort = " l.time "; } $count = selectsqlLine("select count(*) as count from actionlog l left join user u using(uid)\n\t\t\t\t\t\t\t\t" . $where); #Seitenamzahl berechnen $pages = ceil($count['count'] / $rows); #Seite checken if ($pages < $page && $pages != 0) { $page = $pages; } $return = selectsql("select * from actionlog l left join user u using(uid)\n\t\t\t\t\t\t\t\t" . $where . "\n\t\t\t\t\t\t\t\torder by " . $sort . " " . $order . "\n\t\t\t\t\t\t\tLIMIT " . $rows * ($page - 1) . ",{$rows}"); return $return; }
function listNewsComments($nid, $pages, $page = 1, $rows = 10) { if (!is_numeric($nid)) { return; } if ($page < 0 || $rows < 0 || !is_numeric($page) || !is_numeric($rows)) { return; } $pages = getNewsCommentsPages($nid, $rows); #Seite checken if ($pages < $page && $pages != 0) { $page = $pages; } $return = selectsql("select c.*,u.*,g.usertitle,DATE_FORMAT(c.time, '%d.%m.%y') as cdate,\n\t\t\t\t\t\t\tDATE_FORMAT(c.time, '%H:%i') as ctime, cn.nid \n\t\t\t\t\t\t\t\tfrom com_news cn\n\t\t\t\t\t\t\t\tleft join comments c on(c.cid = cn.cid)\n\t\t\t\t\t\t\t\tleft join user u on (u.uid = c.uid)\n\t\t\t\t\t\t\t\tleft join groups g on (g.gid = u.gid)\n\t\t\t\t\t\t\t\twhere cn.nid = {$nid} \n\t\t\t\t\t\t\t\torder by time asc \n\t\t\t\t\t\t\t\tLIMIT " . $rows * ($page - 1) . ",{$rows}"); return $return; }
function deleteGalaxy($id) { if (is_array($id)) { $sql = "(" . join(",", $id) . ")"; if (!$sql) { return; } $user = selectsql("select uid from user where gala IN " . $sql); } else { $user = selectsql("select uid from user where gala = {$id}"); } if ($user) { #delete user from galaxy deleteUser(getArrayFromList($user, "uid")); } #delete galaxys if (is_array($id)) { $user = query("delete from galaxy where gala IN " . $sql); } else { $user = query("delete from galaxy where gala = {$id}"); } return 1; }
function highscore_list($filter, $pages, $page = 1, $rows = 50) { Assert::isId($page); Assert::isId($rows); if ($filter['hours'] || $filter['days']) { if ($filter['hours']) { Assert::isNumeric($filter['hours']); $timeout = date("Y-m-d H:m:s", time() - (int) $filter['hours'] * 60 * 60); } else { Assert::isNumeric($filter['days']); $timeout = date("Y-m-d H:m:s", time() - (int) $filter['days'] * 24 * 60 * 60); } $count = selectsql("\n select count(*) as count\n from user u\n left join activity a on (a.uid = u.uid)\n where a.stamp > '{$timeout}'\n group by u.uid\n "); $count = count($count); #Seitenamzahl berechnen $pages = ceil($count / $rows); #Seite checken if ($pages < $page && $pages != 0) { $page = $pages; } $result = selectsql("\n select u.*,ga.*,a.*,sum(ac.bonus) as activity_points\n from user u\n left join activity ac on (ac.uid = u.uid)\n left join galaxy ga on (ga.gala = u.gala)\n left join alliance a on(a.aid = ga.aid)\n where ac.stamp > '{$timeout}'\n group by u.uid\n order by activity_points desc, u.nick asc\n LIMIT " . $rows * ($page - 1) . ",{$rows}\n "); } else { $count = selectsqlLine("\n select count(*) as count\n from user u\n "); #Seitenamzahl berechnen $pages = ceil($count['count'] / $rows); #Seite checken if ($pages < $page && $pages != 0) { $page = $pages; } $result = selectsql("\n select * from user u\n left join galaxy ga on (ga.gala = u.gala)\n left join alliance a on(a.aid = ga.aid)\n order by u.activity_points desc, u.nick asc\n LIMIT " . $rows * ($page - 1) . ",{$rows}\n "); } for ($i = 0; $i < count($result); $i++) { $result[$i]['place'] = $rows * ($page - 1) + $i + 1; } return $result; }
function listGroupsByRank($rank) { if (!isset($rank) || !is_numeric($rank)) { echo "db.group:listGroupByRank Ungültiger Parameter!"; return; } $list = selectsql("\n SELECT * , max(rank) as maxrank, min(rank) as minrank FROM groups g, group_rights gr\n WHERE gr.gid = g.gid\n AND gr.rank <= {$rank}\n group by g.gid\n order by g.gid asc\n "); for ($i = 0; $i < count($list); $i++) { if ($list[$i]['maxrank'] == $rank) { $list[$i]['changed'] = 1; } } return $list; }
function fleetstatus_refresh() { $ids = selectsql("\n select fs.fsid,fid from fleet_status fs\n left join user u on (u.gala = fs.gala and u.pos = fs.pos)\n where fs.arrival+(fs.orbittime*60)-unix_timestamp() < 0 and fs.arrival is not null and u.uid is null\n "); if (count($ids)) { // addToLogFile("<b>System:</b> ".count($ids)." Deffer recallt","Incomings"); $fids = array(); $fsids = array(); for ($i = 0; $i < count($ids); $i++) { if ($ids[$i]['fid']) { $fids[] = $ids[$i]['fid']; } $fsids[] = $ids[$i]['fsid']; } if ($fids) { query("delete from fleet where fid IN (" . join(",", $fids) . ")"); } query("delete from fleet_status where fsid IN (" . join(",", $fsids) . ")"); } query("\n update fleet_status set return_flight = 1,\n arrival = returntime*60+arrival+orbittime*60,\n returntime = NULL, orbittime = NULL\n where return_flight = 0 AND arrival+orbittime*60-unix_timestamp() < 0 and arrival is not null"); query("\n delete from fleet_status \n where return_flight = 1 AND arrival-unix_timestamp() < 0 and arrival is not null"); }
function attack_delete($id) { if (!is_numeric($id)) { return; } query("delete from attack where attid = {$id}"); query("delete from attack_target where attid = {$id}"); $atter = selectsql("\n select aa.sid from attack_atter aa\n left join attack_target at on (at.sid = aa.sid)\n where at.sid is null\n ", "sid"); if ($atter) { query("delete from attack_atter where sid IN (" . join(",", $atter) . ")"); } }
function bot_list() { return selectsql("select * from ircbots order by name asc"); }
function updateScan($scan) { $logger =& LoggerManager::getLogger("db.scans"); $logger->debug(array("function" => "updateScan", "scan" => $scan)); if (!is_numeric($scan['gala']) || !is_numeric($scan['pos'])) { return; } #scan exists $dbscan = existScan($scan['gala'], $scan['pos']); if (!$dbscan) { $sid = insertsql(" insert into scans (gala,pos,nick) values (" . $scan['gala'] . "," . $scan['pos'] . ",'" . addslashes($scan['nick']) . "')"); if (!$sid) { return; } $dbscan = array("sid" => $sid, "gala" => $scan['gala'], "pos" => $scan['pos']); } #sektorscan if ($scan['type'] == "sector") { #existiert schon -> update $val = array("sector_punkte" => $scan['punkte'], "sector_kristall" => $scan['kristall'], "sector_metall" => $scan['metall'], "sector_roids" => $scan['roids'], "sector_ships" => $scan['ships'], "sector_deff" => $scan['deff'], "sector_prec" => $scan['prec'], "sector_svs" => $scan['svs'], "sector_scanner" => $scan['scanner'], "sector_time" => time()); } if ($scan['type'] == "unit") { if ($dbscan['hasunit'] && $dbscan['unit_fid']) { updateFleet($dbscan['unit_fid'], $scan['kleptoren'], $scan['cancris'], $scan['fregatten'], $scan['zerstoerer'], $scan['kreuzer'], $scan['schlachter'], $scan['traeger'], $scan['jaeger'], $scan['bomber']); $fid = $dbscan['unit_fid']; } else { $fid = addFleet($scan['kleptoren'], $scan['cancris'], $scan['fregatten'], $scan['zerstoerer'], $scan['kreuzer'], $scan['schlachter'], $scan['traeger'], $scan['jaeger'], $scan['bomber']); if (!$fid) { return; } } $val = array("unit_prec" => $scan['prec'], "unit_svs" => $scan['svs'], "unit_scanner" => $scan['scanner'], "unit_fid" => $fid, "unit_time" => time()); } if ($scan['type'] == "gscan") { $val = array("gscan_prec" => $scan['prec'], "gscan_svs" => $scan['svs'], "gscan_scanner" => $scan['scanner'], "gscan_horus" => $scan['horus'], "gscan_rubium" => $scan['rubium'], "gscan_coon" => $scan['coon'], "gscan_pulsar" => $scan['pulsar'], "gscan_centurion" => $scan['centurion'], "gscan_time" => time()); } // miliscan updaten if ($scan['type'] == "mili") { if (miliscan_fleet_get($dbscan['sid'])) { $fleetlist = selectsql("select * from scanmili_fleet where sid = " . $dbscan['sid'] . " order by num ASC"); for ($i = 0; $i < 3; $i++) { miliscan_fleet_update($fleetlist[$i]['fid'], $scan['fleets'][$i]); } } else { for ($i = 0; $i < 3; $i++) { miliscan_fleet_add($dbscan['sid'], $i, $scan['fleets'][$i]); } } // 100% scan und user ist tic member // if($scan['prec'] == "100" && ($user = user_get_bypos($scan['gala'],$scan['pos']))) { // // } $val = array("mili_prec" => $scan['prec'], "mili_svs" => $scan['svs'], "mili_scanner" => $scan['scanner'], "mili_time" => time()); $logger->debug(array("message" => "mili update done", "vals" => $val)); } if ($scan['type'] == "news") { $val = array("news_prec" => $scan['prec'], "news_svs" => $scan['svs'], "news_scanner" => $scan['scanner'], "news_newsdata" => $scan['newsdata'], "news_time" => time()); } if (!$dbscan['nick'] || strtolower($dbscan['nick']) != strtolower($scan['nick'])) { $val['nick'] = $scan['nick']; } if (strtolower($dbscan['nick']) != strtolower($scan['nick'])) { query("update scans set nick = null where lower(nick) = lower('" . mysql_escape_string($scan['nick']) . "')"); } if (count($val)) { $updates = array(); foreach ($val as $key => $value) { if (!isset($value)) { $value = "NULL"; } else { if (!is_numeric($value)) { $value = "'" . mysql_escape_string($value) . "'"; } } $updates[] = "{$key} = {$value}"; } $logger->debug(array("function" => "updateScan", "message" => "before update scans", "vals" => $vals, "updates" => $updates)); query("update scans set " . join(",", $updates) . " where sid = " . $dbscan['sid']); } $logger->debug("update scan done"); return $dbscan['sid']; }