public function AddPurchase($storeID, $remark, $ary = array())
{
if (!isset($_SESSION['account_ID'])) {
return new ExcuteResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1");
}
$account_id = $_SESSION['account_ID'];
$purchaseID = sql_fetch_one_cell("SELECT IFNULL(MAX(purchase_id), 0) + 1 FROM bm_purchase_list;");
$sql = "INSERT INTO bm_purchase_list(purchase_id,account_id,shop_id,add_time,purchase_state,return_time,purchase_price,purchase_remark)" . " VALUES ('{$purchaseID}','{$account_id}','{$storeID}',UNIX_TIMESTAMP(),0,0,0,'{$remark}')";
$r = sql_query($sql);
if ($r != 0) {
return self::AddPurchaseInfo($purchaseID, $ary);
} else {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "执行出错" . $r, $sql);
}
}
/**
* 获取受到服务器特殊限制的功能模块
*/
public function ListServerMoudule($offer, $pageSize)
{
$sql = sprintf("SELECT * FROM bm_module where bm_ModuleState = 3 ORDER BY bm_ModuleID DESC LIMIT {$offer}, {$pageSize}");
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$o = array();
for ($i = 0; $i < $count; $i++) {
$moduleMDL = $r[$i];
$moduleMDL = new ModuleMDL($moduleMDL[0], $moduleMDL[1], $moduleMDL[2], $moduleMDL[3], $moduleMDL[4], $moduleMDL[5], $moduleMDL[6], $moduleMDL[7], $moduleMDL[8]);
$o[] = $moduleMDL;
}
$count = sql_fetch_one_cell("SELECT COUNT(*) as num FROM bm_module where bm_ModuleState = 3 ");
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $ary);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", $sql, NULL);
}
}
public function ListGoods($lv, $type3_id, $brand_id, $offer, $pageSize)
{
$brand_id = intval($brand_id);
if ($brand_id > 0) {
$where = sprintf(" a.brand_id = %d and ", $brand_id);
} else {
$where = "";
}
if ($lv == "1") {
$from = " bm_goods a, bm_goods_type3 b, bm_goods_type2 c ";
$where = $where . "c.type1_id = " . $type3_id . " and c.type2_id = b.type2_id and b.type3_id = a.type3_id and goods_state < 99 ";
} else {
if ($lv == "2") {
$from = " bm_goods a, bm_goods_type3 b";
$where = $where . "b.type2_id = " . $type3_id . " and b.type3_id = a.type3_id and goods_state < 99 ";
} else {
if ($lv == "3") {
$from = " bm_goods a";
$where = $where . " a.type3_id = " . $type3_id . " and goods_state < 99 ";
} else {
$from = " bm_goods a";
$where = $where . "goods_state < 99 ";
}
}
}
$sql = "SELECT a.* FROM" . $from . " where " . $where . "ORDER BY goods_id DESC LIMIT " . $offer . "," . $pageSize;
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$o = array();
$count = count($r);
for ($i = 0; $i < $count; $i++) {
$goodsMDL = $r[$i];
$goodsMDL = new GoodsMDL($goodsMDL[0], $goodsMDL[1], $goodsMDL[2], $goodsMDL[3], $goodsMDL[4], $goodsMDL[5], $goodsMDL[6], $goodsMDL[7], $goodsMDL[8], $goodsMDL[9], $goodsMDL[10], $goodsMDL[11], $goodsMDL[12], $goodsMDL[13], $goodsMDL[14], $goodsMDL[15]);
$o[] = $goodsMDL;
}
$count = sql_fetch_one_cell("SELECT count() FROM " . $from . " where " . $where . ";");
//return new DataResult(ResultStateLevel::ERROR,"0",$sql,NULL);
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $o);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", $sql, NULL);
}
}
/**
* 获取卡批次列表
* @param unknown_type $FormName 卡申请单名称
* @param unknown_type $offer
* @param unknown_type $pageSize
*/
public function ListCardGroup($FormName, $offer, $pageSize)
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['account_ID'])) {
return new DataResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1", NULL);
}
$sql = "SELECT b.cd_CAFormName,b.cd_CardApplyer,b.cd_CAFormChecker,b.cd_CardPicker,a.*,c.cd_CardTypeName";
$sql .= " FROM CD_CardGroup a,CD_CardApplyForm b,CD_CardType c";
$sql .= " WHERE a.cd_CAFormID = b.cd_CAFormID AND a.cd_CardTypeID = c.cd_CardTypeID AND b.cd_CAFormName like '%" . $FormName . "%' ORDER BY cd_Createtime DESC LIMIT {$offer}, {$pageSize}";
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$ary = array();
foreach ($r as $k => $v) {
$cardGroupMDL = new CardGroupMDL($v[4], $v[5], $v[6], $v[7], $v[8], $v[9], $v[10], $v[11], $v[12], $v[0], $v[1], $v[2], $v[3], $v[13]);
$ary[] = $cardGroupMDL;
}
$count = sql_fetch_one_cell("SELECT COUNT(1) AS num FROM CD_CardGroup a,CD_CardApplyForm b WHERE a.cd_CAFormID = b.cd_CAFormID AND b.cd_CAFormName like '%" . $FormName . "%'");
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $ary);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", $sql, NULL);
}
}
/**
* 游龙意见收集 暂时放在这里
* @param $offer
* @param $pageSize
* @param $start
* @param $end
*/
public function youlongLog($offer, $pageSize, $start, $end)
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['account_ID'])) {
return new DataResult(ResultStateLevel::ERROR, "The accounts have been logged out, please re-login account", "-1", NULL);
}
$where = "";
if (!empty($start) || !empty($end)) {
$where = " where log_date >= '" . $start . "' AND log_date <='" . $end . "'";
}
$sql = "SELECT log_date,log_title,log_remark FROM log_youlong " . $where . " ORDER BY log_date DESC LIMIT {$offer}, {$pageSize}";
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$count = sql_fetch_one_cell("SELECT COUNT(*) as num FROM log_youlong " . $where);
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $r);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", $sql, NULL);
}
}
/**
* 插入数据
* @param $sql
* @return unknown_type
*/
function sql_insert($sql)
{
$stime = my_microtime_float();
sql_query($sql);
loginfo($stime, $sql);
return sql_fetch_one_cell('select last_insert_id()');
}
/**
* 获取申请单列表信息
* @param unknown_type $areaId
* @param unknown_type $serverId
* @param unknown_type $state
* @param unknown_type $offer
* @param unknown_type $pageSize
* 申请单编号=0，服务器ID=1，服务器名称=2，标题=3，详情=4，
* 发送类型=5 账号=6，账号条件=7，货币=8，道具=9，申请原因=10，申请状态=11
* 申请时间=12，申请账号=13，审核账号=14，审核说明=15，审核时间=16
*/
public static function dataMentods_ListApplyItem($areaId, $serverId, $state, $offer, $pageSize)
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['user'])) {
return new ExcuteResult(ResultStateLevel::ERROR, "The accounts have been logged out, please re-login account", "-1");
}
$accountName = $_SESSION['user'];
$accountId = $_SESSION['account_ID'];
$sql = 'SELECT bm_gameApplayId,a.bm_serverID,bm_serverName,bm_applyTitle,bm_applyDesc,';
$sql .= ' bm_sendType,bm_sendUser,bm_condition,bm_moneyItem,bm_propItem,bm_applyRemark,bm_applyState,';
$sql .= ' bm_applyTime,bm_applyAccount,bm_checkAccount,bm_checkRemark,bm_checkTime ';
$sqlWhere = ' FROM bm_gameapply a,bm_accountgameserver b';
if ($state == 0) {
$sqlWhere .= ' WHERE a.bm_serverID = b.bm_ServerID AND b.bm_AccountID = ' . $accountId . ' AND bm_applyState = ' . $state;
} else {
$sqlWhere .= ' WHERE a.bm_serverID = b.bm_ServerID AND b.bm_AccountID = ' . $accountId . ' AND bm_applyState >= ' . $state;
}
if ($areaId != "") {
$sqlWhere .= ' AND b.bm_AreaID = ' . $areaId;
}
if ($serverId != "") {
$sqlWhere .= ' AND b.bm_ServerID IN (' . $serverId . ')';
}
$sql .= $sqlWhere . " ORDER BY bm_applyTime DESC LIMIT {$offer}, {$pageSize}";
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$count = sql_fetch_one_cell("SELECT COUNT(*) as num " . $sqlWhere);
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $r);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", $sql, NULL);
}
}
/**
* 道具卡审核（通过）
* @param unknown_type $FromCardID
* @param unknown_type $Reamrk
*/
public function DoPassCardInfo($FromCardID, $Reamrk)
{
AddBMAccountEventLog("道具卡申请审核通过订单号：" . $FromCardID . ",审核备注：" . $Reamrk, EventLogTypeEnum::CARDMANAGE);
if (!isset($_SESSION['account_ID']) || !isset($_SESSION['user'])) {
return new ExcuteResult(ResultStateLevel::ERROR, "账号已登出,请重新登陆！", "-1");
}
$Account = $_SESSION['user'];
$sql = sprintf("CALL CreateCardGroup(%d,'%s','%s');", $FromCardID, $Account, $Reamrk);
$r = sql_fetch_one_cell($sql);
if ($r == 1) {
return new ExcuteResult(ResultStateLevel::SUCCESS, "", NULL);
} else {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "", NULL);
}
}
/**
* 获取卡种类列表 分页
* @param unknown_type $offer
* @param unknown_type $pageSize
* @param unknown_type $cardName
*/
public function ListCardType($offer, $pageSize, $cardName)
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['account_ID'])) {
return new DataResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1", NULL);
}
$where = "";
if (!empty($cardName)) {
$where = " AND cd_CardTypeName like '%" . $cardName . "%'";
}
$sql = "SELECT * FROM CD_CardType WHERE cd_CardTypeState < 99" . $where . " ORDER BY cd_CardTypeID DESC LIMIT {$offer}, {$pageSize}";
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$ary = array();
foreach ($r as $k => $v) {
$cardTypeMDL = new CardTypeMDL($v[0], $v[1], $v[2], $v[3], $v[4], $v[5], $v[6], $v[7]);
$ary[] = $cardTypeMDL;
}
$count = sql_fetch_one_cell("SELECT COUNT(*) as num FROM CD_CardType WHERE cd_CardTypeState < 99 ");
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $ary);
} else {
return new DataResult(ResultStateLevel::ERROR, "执行出错", NULL, NULL);
}
}
/**
* 根据条件获取物品列表。物品名称满足模糊查询，物品ID是精确查找
* @param $offer
* @param $pageSize
* @param $GameID
* @param $itemName
* @param $type
*/
public function GetAllGameItemByGameIDUpdate($offer, $pageSize, $GameID, $itemName, $type)
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['account_ID'])) {
return new DataResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1", NULL);
}
if ($type == "1") {
$sql = "SELECT * FROM bm_item WHERE bm_GameID = " . $GameID . " AND bm_ItemGID > 100 AND bm_ItemName like '%" . $itemName . "%' ORDER BY bm_ItemID DESC LIMIT {$offer}, {$pageSize}";
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$ary = array();
foreach ($r as $k => $v) {
$gameItemMDL = new GameItemMDL($v[0], $v[1], $v[2], $v[3], $v[4], $v[5]);
$ary[] = $gameItemMDL;
}
$count = sql_fetch_one_cell("SELECT COUNT(*) as num FROM bm_item WHERE bm_GameID = " . $GameID . " AND bm_ItemName like '%" . $itemName . "%'");
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $ary);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", $sql, NULL);
}
} else {
$sql_ = "SELECT * FROM bm_item WHERE bm_GameID = " . $GameID . " AND bm_ItemGID = '" . $itemName . "' ORDER BY bm_ItemID DESC LIMIT {$offer}, {$pageSize}";
$r_ = sql_fetch_rows($sql_);
if (!empty($r_)) {
$ary_ = array();
foreach ($r_ as $k => $v) {
$gameItemMDL_ = new GameItemMDL($v[0], $v[1], $v[2], $v[3], $v[4], $v[5]);
$ary_[] = $gameItemMDL_;
}
$count_ = sql_fetch_one_cell("SELECT COUNT(*) as num FROM bm_item WHERE bm_GameID = " . $GameID . " AND bm_ItemGID = '" . $itemName . "'");
return new DataResult(ResultStateLevel::SUCCESS, "1", $count_, $ary_);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", $sql, NULL);
}
}
}
/**
* 服务器列表
* @param unknown_type $offer
* @param unknown_type $pageSize
* @param unknown_type $bm_GameID
* @param unknown_type $bm_AreaID
*/
public function gameServList($offer, $pageSize, $bm_GameID = -1, $bm_AreaID = -1)
{
$where = "";
if ($bm_GameID != -1) {
$where = " AND g.bm_GameID = {$bm_GameID} ";
}
if ($bm_AreaID != -1) {
$where .= " AND a.bm_AreaID = {$bm_AreaID} ";
}
$sql = "SELECT s.*, g.bm_GameName, a.bm_AreaName FROM bm_gameserver s LEFT JOIN bm_game g ";
$sql .= " ON s.bm_GameID = g.bm_GameID LEFT JOIN bm_gamearea a ON a.bm_AreaID = s.bm_AreaID WHERE bm_ServerState != 99 " . $where;
$sql .= " ORDER BY bm_ServerPRI LIMIT {$offer}, {$pageSize}";
$rs = sql_fetch_rows($sql);
if (!empty($rs)) {
$ary = array();
foreach ($rs as $k => $v) {
$bm_Server = new GameServerMDL($v[0], $v[1], $v[2], $v[3], $v[4], json_decode($v[5]), $v[6], $v[7], $v[8], $v[9], $v[10], $v[11], $v[12]);
$ary[] = $bm_Server;
}
$count = sql_fetch_one_cell("SELECT COUNT(*) AS num FROM bm_gameserver WHERE bm_ServerState < 99 " . $where);
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $ary);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", NULL, NULL);
}
}
/**
* 插入数据
* @param $sql
* @return unknown_type
*/
function sql_insert($sql)
{
sql_query($sql);
return sql_fetch_one_cell('select last_insert_id()');
}
/**
* 修改密码
* @param unknown_type $accountID
* @param unknown_type $oldPwd
* @param unknown_type $newPwd
*/
public function EditPassWord($oldPwd, $newPwd)
{
AddBMAccountEventLog("修改账号密码，原先密码：" . $oldPwd, EventLogTypeEnum::BASEMANGE);
if ($newPwd == "a00000") {
return new ExcuteResult(ResultStateLevel::ERROR, "密码不能修改成初始化密码", NULL);
}
if (!isset($_SESSION['account_ID'])) {
return new ExcuteResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1");
}
$accountID = $_SESSION['account_ID'];
$sqlCheck = "SELECT bm_AccountID FROM bm_account WHERE account_id = " . $accountID . " AND account_pasword = '" . md5($oldPwd) . "'";
$check = sql_fetch_one_cell($sqlCheck);
if ($check == "") {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "原密码不正确", NULL);
}
$password = md5($newPwd);
$sql = "UPDATE bm_account SET account_pasword = '" . $password . "' WHERE account_id = {$accountID}";
$r = sql_query($sql);
if ($r != 0) {
$tag = $oldPwd == "a00000" ? true : false;
return new ExcuteResult(ResultStateLevel::SUCCESS, "", $tag);
} else {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "执行出错", NULL);
}
}
require_once DATACONTROL . '/BMAccount/EventLog.php';
require_once 'UtilsProvider.php';
$cardSN = '';
$userName = '';
$ip = '';
$serverId = 0;
if (isset($_GET['cardSN']) && isset($_GET['userName']) && isset($_GET['ip']) && isset($_GET['serverId'])) {
$cardSN = $_GET['cardSN'];
$userName = $_GET['userName'];
$ip = $_GET['ip'];
$serverId = $_GET['serverId'];
$sql = sprintf("CALL CheckCard('%s','%s','%s',%d);", $cardSN, $userName, $ip, $serverId);
$r = sql_fetch_one_cell($sql);
} else {
$r = 0;
}
if ($r > 0) {
$result = UtilsProvider::dataMentods_sendCardItem($r, $userName, $serverId);
if ($result->Success) {
$sql = sprintf("CALL ChargeCard('%s','%s','%s',%d);", $cardSN, $userName, $ip, $serverId);
$r = sql_fetch_one_cell($sql);
echo 1;
} else {
$sql = sprintf("CALL BreakCard('%s','%s',%d);", $cardSN, $userName, $serverId);
$r = sql_fetch_one_cell($sql);
echo 0;
//echo json_encode($result);
}
} else {
echo 0;
}
