public function dbAddArtefact($artefact_id) { $dbh = new DBL(); $strSQL = "INSERT INTO player_artefact (player_id, artefact_id, player_artefact_date) VALUES (" . $this->getId() . ", " . $artefact_id . ", " . time() . ")"; $dbh->query($strSQL); return true; }
public static function dbGet($id = NULL) { $dbh = new DBL(); $strSQL = "SELECT * FROM alliance WHERE alliance.alliance_id=" . $id; $result = $dbh->query($strSQL); while ($record = $result->fetch_array()) { $newAlliance = new Alliance(); $newAlliance->setName($record["alliance_name"]); $newAlliance->setCode($record["alliance_code"]); $newAlliance->setDescription($record["alliance_description"]); $buffer[] = $newAlliance; } $result->free(); if (isset($id)) { return $buffer[0]; } return $buffer; }
<?php require_once "lib/Player.class.php"; $dblink = new DBL(); $strSQL = "SELECT player.*, race.race_name FROM player, race\n\t\t\tWHERE player.race_id = race.race_id\n\t\t\tAND player_name='" . $_POST["logon"]["name"] . "'\n\t\t\tAND player_password='******'"; $result = $dblink->query($strSQL); if ($player = $result->fetch_array()) { $player = new Player($player["player_id"], $player["player_name"], $player["alliance_id"], $player["race_name"]); session_start(); if (isset($_SESSION["player"])) { unset($_SESSION["player"]); } $_SESSION["player"] = serialize($player); header("Location: home.php"); } else { header("Location: index.html"); }
$imgDir = "img/"; $newImg = $imgDir . substr($img1, 0, strlen($img1) - 4) . "_" . substr($img2, 0, strlen($img2) - 4) . ".gif"; list($img1width, $img1height) = getimagesize($imgDir . $img1); // Size of source photo for resizing list($img2width, $img2height) = getimagesize($imgDir . $img2); // Size of source photo for resizing $imgFile1 = imagecreatefromgif($imgDir . $img1); $imgFile2 = imagecreatefromgif($imgDir . $img2); imagecopymerge($imgFile1, $imgFile2, 5, 5, 0, 0, $img2width, $img2height, 100); imagegif($imgFile1, $newImg) or die('Could not save picture! Please check permissions.'); imagedestroy($imgFile1); imagedestroy($imgFile2); } $dblink = new DBL(); $strSQL = "SELECT resource.resource_name, resource.resource_img, tbl1.*, tbl2.aa_bonus_1m, tbl2.aa_count_1m,\r\ntbl3.aa_bonus_3m, tbl3.aa_count_3m, tbl4.aa_bonus_6m, tbl4.aa_count_6m FROM\r\n(SELECT artefact.resource_id, ROUND(SUM(artefact.artefact_bonus), 3) AS aa_bonus,\r\nCOUNT(player_artefact.artefact_id) AS aa_count\r\nFROM artefact, player_artefact\r\nWHERE player_artefact.artefact_id = artefact.artefact_id\r\nGROUP BY artefact.resource_id) AS tbl1 LEFT JOIN\r\n(SELECT artefact.resource_id, ROUND(SUM(artefact.artefact_bonus), 3) AS aa_bonus_1m,\r\nCOUNT(player_artefact.artefact_id) AS aa_count_1m\r\nFROM artefact, player_artefact\r\nWHERE player_artefact.artefact_id = artefact.artefact_id\r\nAND player_artefact.player_artefact_date<=UNIX_TIMESTAMP(CURRENT_DATE - INTERVAL 1 MONTH)\r\nGROUP BY artefact.resource_id) AS tbl2\r\nON tbl1.resource_id = tbl2.resource_id\r\nLEFT JOIN\r\n(SELECT artefact.resource_id, ROUND(SUM(artefact.artefact_bonus), 3) AS aa_bonus_3m,\r\nCOUNT(player_artefact.artefact_id) AS aa_count_3m\r\nFROM artefact, player_artefact\r\nWHERE player_artefact.artefact_id = artefact.artefact_id\r\nAND player_artefact.player_artefact_date<=UNIX_TIMESTAMP(CURRENT_DATE - INTERVAL 3 MONTH)\r\nGROUP BY artefact.resource_id) AS tbl3\r\nON tbl1.resource_id = tbl3.resource_id\r\nLEFT JOIN\r\n(SELECT artefact.resource_id, ROUND(SUM(artefact.artefact_bonus), 3) AS aa_bonus_6m,\r\nCOUNT(player_artefact.artefact_id) AS aa_count_6m\r\nFROM artefact, player_artefact\r\nWHERE player_artefact.artefact_id = artefact.artefact_id\r\nAND player_artefact.player_artefact_date<=UNIX_TIMESTAMP(CURRENT_DATE - INTERVAL 3 MONTH)\r\nGROUP BY artefact.resource_id) AS tbl4\r\nON tbl1.resource_id = tbl4.resource_id\r\nINNER JOIN resource ON tbl1.resource_id = resource.resource_id\r\nORDER BY tbl1.resource_id"; $rsAllianceBonus = $dblink->query($strSQL); $strSQL = "SELECT artefact.*, artefact_size.artefact_size_name, artefact_size.artefact_size_img,\r\n\t\t\tartefact_type.artefact_type_name, artefact_type.artefact_type_img,\r\n\t\t\tplayer_artefact.player_artefact_id, resource.resource_name, resource.resource_img\r\n\t\t\tFROM player_artefact, artefact, artefact_size, artefact_type, resource\r\n\t\t\tWHERE player_artefact.artefact_id=artefact.artefact_id AND\r\n\t\t\tartefact.artefact_size_id=artefact_size.artefact_size_id AND\r\n\t\t\tartefact.artefact_type_id=artefact_type.artefact_type_id AND\r\n\t\t\tartefact_type.resource_id=resource.resource_id AND\r\n\t\t\tplayer_artefact.player_id=1\r\n\t\t\tORDER BY artefact_type.resource_id, artefact.artefact_size_id DESC"; $rsMyArtefacts = $dblink->query($strSQL); ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Реестр Альянсовых Артефактов</title> <link rel="stylesheet" href="templates/style.css" type="text/css"> <style> .dialogBox { background-color: #FFFFFF; border: 2px #006699 solid; filter:progid:DXImageTransform.Microsoft.Shadow(color=#707070, direction=135, strength=5)