class Shop extends Character
{
function __construct() {
parent::__construct();
}
function GetMaxMailID() {
$db = $this->GetCharDB();
$s_mailid = mysql_fetch_array($this->Query("SELECT MAX(id) FROM `mail` LIMIT 1",$db));
$mailid = $s_mailid['MAX(id)'];
$temp_mid = ($mailid+5);
return $temp_mid;
}
function GetMaxItemID() {
$db = $this->GetCharDB();
$s_itemidarray = mysql_fetch_array($this->Query("SELECT MAX(guid) FROM `item_instance` LIMIT 1",$db));
$temp_itemid = $s_itemidarray['MAX(guid)'];
$itemguid = ($temp_itemid+10);
return $itemguid;
}
function SendItem ($maxitem, $itemid, $db) {
$send_item = "INSERT INTO `item_instance` (`guid`,`itemEntry`) VALUES ('$maxitem','$itemid')";
$this->Query($send_item,$db);
}
function SendMail($maxmail, $maxitem, $itemid, $charguid) {
$db = $this->GetCharDB();
$mail_items = "INSERT INTO `mail_items` VALUES ('$maxmail','$maxitem','$charguid')";
$mail = "INSERT INTO `mail` (`id`,`messageType`,`stationery`,`receiver`,`subject`,`body`,`has_items`) VALUES ('$maxmail',0,61,'$charguid','Donate!','Спасибо за помощь серверу!','1')";
$this->SendItem($maxitem, $itemid,$db);
$this->Query($mail_items,$db);
$this->Query($mail,$db);
}
function BuyItem($itemid,$charguid, $uid) {
if($this->CheckItem($itemid)) {
if($this->ChechCharInAcc($charguid,$uid)) {
$bonuses = $this->GetBonusesCount($uid);
$itemarray = $this->ItemInfo($itemid);
$itemprice = $itemarray['price'];
if($bonuses>$itemprice) {
$maxitem = $this->GetMaxItemID();
$maxmail = $this->GetMaxMailID();
$this->SendMail($maxmail, $maxitem, $itemid, $charguid);
$bon = ($bonuses-$itemprice);
$upd_bonuses = "UPDATE `account` SET `bonuses`='$bon' WHERE `id`='$uid'";
$this->Query($upd_bonuses,"authdb");
echo "<center>Предмет отправлен выбраному персонажу на почту! У вас снято <b>".$itemprice."</b> бонусов!</center>";
} else echo "<center>У вас недостаточно бонусов!</center>";
} else echo "<center><b>Ошибка!</b></center>";
} else echo "<center><b>Этот предмет невозможно купить!</b></center>";
}
function ItemInfo($itemid) {
$q = "SELECT * FROM `item_list` WHERE `item_id`='%d'";
$query = sprintf($q,$itemid);
$iteminfo = $this->Query($query,"cpdb");
$itemarray = mysql_fetch_array($iteminfo);
return $itemarray;
}
function CheckItem($itemid) {
$q = "SELECT 1 FROM `item_list` WHERE `item_id`='%d'";
$query = sprintf($q, $itemid);
$select = $this->Query($query,"cpdb");
$count = mysql_num_rows($select);
if($count==1) return true; else return false;
}
function PrintCharlist($accguid,$itemid) {
$db = $this->GetCharDB();
$q = "SELECT `guid`,`name` FROM `characters` WHERE `account`='$accguid'";
$select = $this->Query($q,$db);
echo "<center>";
echo "Выберите персонажа<br>";
while($chars = mysql_fetch_array($select)) {
echo "<a href=?do=store&item=$itemid&char=".$chars['guid'].">".$chars['name']."</a><br>";
}
mysql_free_result($select);
echo "</center>";
}
}