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)
