public function UpdatePurchaseState($purchaseID, $state)
{
if (!isset($_SESSION['account_ID'])) {
return new ExcuteResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1");
}
$account_id = $_SESSION['account_ID'];
$sql = "SELECT account_id,purchase_state FROM bm_purchase_list WHERE purchase_id = " . $purchaseID;
$row = sql_fetch_one($sql);
if ($row == null) {
return new ExcuteResult(ResultStateLevel::ERROR, "订单编号不存在！", "-1");
} else {
if ($row[0] != $account_id and $_SESSION['account_type'] == "1") {
return new ExcuteResult(ResultStateLevel::ERROR, "您没有权限修改该订单状态！", "-1");
} else {
if ($row[1] == "98") {
return new ExcuteResult(ResultStateLevel::ERROR, "订单已关闭不能再修改！", "-1");
}
}
}
$sql = "UPDATE bm_purchase_list SET purchase_state =" . $state . ", return_time = UNIX_TIMESTAMP() WHERE purchase_id = " . $purchaseID;
$r = sql_query($sql);
if ($r != 0) {
return new ExcuteResult(ResultStateLevel::SUCCESS, "", $r[0]);
} else {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "error", $sql);
}
}
public function SearchCardinfo($cardSN, $cardPassword)
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['account_ID'])) {
return new DataResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1", NULL);
}
$where = "";
if (!empty($cardSN)) {
$where .= " AND a.cd_CardSN = '" . $cardSN . "'";
}
if (!empty($cardPassword)) {
$where .= " AND cd_CardPassword = '******'";
}
if (empty($where)) {
return new DataResult(ResultStateLevel::ERROR, "卡信息错误，请重新输入", NULL, NULL);
}
$sql = "SELECT c.cd_CardTypeName,b.cd_GroupState,b.cd_ChargeStartTime,b.cd_ChargeEndTime,a.* ";
$sql .= " FROM cd_card a, cd_cardgroup b, cd_cardtype c ";
$sql .= " WHERE a.cd_CardTypeID = c.cd_CardTypeID AND a.cd_CroupID = b.cd_CroupID " . $where;
$r = sql_fetch_one($sql);
if ($r != "") {
$o = array();
$cardMDL = new CardMDL($r[0], $r[1], $r[2], $r[3], $r[4], $r[5], $r[6], $r[7], $r[8], $r[9], $r[10]);
$o[] = $cardMDL;
return new DataResult(ResultStateLevel::SUCCESS, "", 1, $o);
} else {
return new DataResult(ResultStateLevel::ERROR, "卡不存在", NULL, NULL);
}
}
/**
* 获取指定模块信息
* @param $moduleID
*/
public function GetOneModule($moduleID)
{
$sql = sprintf("SELECT * FROM bm_module where bm_ModuleID = %d ", $moduleID);
$r = sql_fetch_one($sql);
if ($r != "") {
$o = array();
$moduleMDL = new ModuleMDL($r[0], $r[1], $r[2], $r[3], $r[4], $r[5], $r[6], $r[7], $r[8]);
$o[] = $moduleMDL;
return new DataResult(ResultStateLevel::SUCCESS, "1", 1, $o);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", NULL, NULL);
}
}
/**
* 新增邮件申请
* @param unknown_type $serverID
* @param unknown_type $users
* @param unknown_type $title
* @param unknown_type $desc
* @param unknown_type $remark
* @param unknown_type $delTime
* @param unknown_type $ApplyDesc
*/
public function AddMailApplay($gameID, $serverID, $users, $title, $desc, $delTime, $ApplyDesc, $sendType, $attchID, $attNum)
{
if (!isset($_SESSION['account_ID'])) {
return new ExcuteResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1");
}
$sql_check = "SELECT bm_AreaID, bm_ServerConnString, bm_ServerName FROM bm_gameserver WHERE bm_ServerID = " . $serverID;
$r_check = sql_fetch_one($sql_check);
if ($r_check == "") {
return new ExcuteResult(ResultStateLevel::ERROR, "此游戏服务器不存在或已被删除！", NULL);
}
$AreaID = $r_check[0];
$ServerName = $r_check[2];
$AccessoriesFlag = 1;
$GameMailTarget = '全服发送';
$GameMailNickName = '全服发送';
$now = date("Y-m-d H:i:s");
if ($attchID == 0 && $attNum == 0) {
$AccessoriesFlag = 0;
}
$markAry['mailExpired'] = $delTime;
$markAry['attachID'] = $attchID;
$markAry['attachNum'] = $attNum;
$markAry['type'] = $sendType;
$markAry['note'] = $ApplyDesc;
$mailApplyRemark = json_encode($markAry);
$currentUser = $_SESSION['user'];
if (!empty($users)) {
$usernames = str_replace(array("\r", "\n"), array("", ","), trim($users));
if ($sendType == 0) {
//passport
$GameMailTarget = $usernames;
$GameMailNickName = '';
} else {
$GameMailTarget = '';
$GameMailNickName = $usernames;
}
}
$sql = "INSERT INTO bm_gamemail( bm_GameID, bm_AreaID, bm_ServerID, bm_ServerName, bm_GameMailTitle, bm_GameMailDesc,\r\n \t\t\t\tbm_GameMailTarget, bm_GameMailNickName, bm_MailApplyRemark, bm_MailApplyFlag, bm_AccessoriesFlag, \r\n \t\t\t\tbm_GameMailSendState, bm_ApplyState, bm_Account, bm_CreatTime) VALUES( {$gameID}, {$AreaID}, {$serverID}, \r\n \t\t\t\t'{$ServerName}', '{$title}', '{$desc}', '{$GameMailTarget}', '{$GameMailNickName}', \r\n \t\t\t\t'{$mailApplyRemark}', 1, {$AccessoriesFlag}, 0, 0, '{$currentUser}', '{$now}')";
$insertID = sql_insert($sql);
if ($insertID && $attchID != 0 && $attNum != 0) {
$sqladd = "INSERT INTO bm_gamemailaffixitem(bm_GameMailID, bm_ItemID, bm_ItemNum) VALUES({$insertID}, {$attchID},{$attNum})";
$r_add = sql_query($sqladd);
if ($r_add == 0) {
return new ExcuteResult(ResultStateLevel::ERROR, "订单生成，道具信息插入失败！", NULL);
} else {
return new ExcuteResult(ResultStateLevel::SUCCESS, "", NULL);
}
}
return new ExcuteResult(ResultStateLevel::ERROR, "生成订单失败", $sql);
}
/**
* 获取指定卡批次的卡的相关信息
* @param unknown_type $GroupID
*/
public function GetCardGroupInfo($GroupID)
{
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 a.cd_CroupID = " . $GroupID;
$r = sql_fetch_one($sql);
if ($r != "") {
$o = array();
$cardGroupMDL = new CardGroupMDL($r[4], $r[5], $r[6], $r[7], $r[8], $r[9], $r[10], $r[11], $r[12], $r[0], $r[1], $r[2], $r[3], $r[13]);
$o[] = $cardGroupMDL;
return new DataResult(ResultStateLevel::SUCCESS, "1", 1, $o);
} else {
return new DataResult(ResultStateLevel::ERROR, "0", NULL, NULL);
}
}
/**
* 判断账号是否要强制修改密码
*/
public function AccountIsEditPWD()
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['account_ID'])) {
return "1";
}
$accountID = $_SESSION['account_ID'];
$sql = sprintf("SELECT * FROM bm_account WHERE bm_AccountState < 99 AND bm_AccountID = %d ", $accountID);
$r = sql_fetch_one($sql);
if ($r != "") {
$o = array();
$accountMDL = new AccountMDL($r[0], $r[1], $r[2], $r[3], $r[4], $r[5], $r[6], $r[7], $r[8], $r[9], $r[10]);
if ($accountMDL->bm_Password == md5("a00000")) {
return "0";
} else {
return "1";
}
} else {
return "1";
}
}
/**
* 获取一个对象
* @param $table 表名
* @param $id 字段值
* @param $idname 字段
* @return unknown_type 一条记录
*/
function sql_fetch_object($table, $id, $idname = "id")
{
return sql_fetch_one("SELECT * FROM `{$table}` WHERE `{$idname}`={$id}");
}
private static function getServerConnDBLogById($serverID)
{
$sql_check = "SELECT bm_ServerConnString,bm_ServerName FROM bm_gameserver WHERE bm_ServerID = " . $serverID;
$r_check = sql_fetch_one($sql_check);
$returnAry = array();
if ($r_check == "") {
$returnAry = array("ret" => false);
} else {
$servAry = json_decode($r_check[0], true);
$returnAry = array("ret" => true, "IP" => $servAry['log']['logIP'], "user" => $servAry['log']['logUser'], "pwd" => $servAry['log']['logPSW'], "name" => $servAry['log']['logDataName'], "port" => $servAry['log']['port'], "serverName" => $r_check[1]);
}
return $returnAry;
}
/**
* 审核通过
* @param unknown_type $applyItemId
* @param unknown_type $checkRemark
*/
public static function dataMentods_updateApplyItem($applyItemId, $checkRemark)
{
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");
}
$accountID = $_SESSION['user'];
///////////////获取申请单信息
$sql_applyItem = 'SELECT bm_serverID,bm_sendType,bm_sendUser,bm_condition,bm_moneyItem,bm_propItem,bm_applyTitle,bm_applyDesc,bm_applyRemark FROM bm_gameapply WHERE bm_gameApplayId =' . $applyItemId;
$result_sql_applyItem = sql_fetch_one($sql_applyItem);
if ($result_sql_applyItem == "") {
return new ExcuteResult(ResultStateLevel::ERROR, $sql_applyItem, NULL);
}
$serverId = $result_sql_applyItem[0];
$sendUser = $result_sql_applyItem[2];
$sendCondition = $result_sql_applyItem[3];
$sendMoneyItem = $result_sql_applyItem[4];
$sendPropItem = $result_sql_applyItem[5];
$sendTitile = $result_sql_applyItem[6];
$sendDesc = $result_sql_applyItem[7];
// 详情
$sendRemark = $result_sql_applyItem[8];
//发送原因
///////////////获取接口调用信息
$serverAry = self::getServerInfoTOhttprequest("/admin_send_gift", $serverId);
if (count($serverAry) <= 0) {
return new ExcuteResult(ResultStateLevel::ERROR, "获取服务器发送域名信息失败", NULL);
}
/**网关请求发送**/
$request_result = self::mentodsAdminSendGift($sendUser, $sendCondition, $sendMoneyItem, $sendPropItem, $serverAry[0], $sendTitile, $sendDesc, $sendRemark);
if ($request_result != "") {
return new ExcuteResult(ResultStateLevel::ERROR, $request_result, NULL);
} else {
//成功 更新申请表单处理状态
$nowtime = date("Y-m-d H:i:s");
$sql_update = 'UPDATE bm_gameapply SET bm_applyState = 1 ,bm_checkAccount ="' . $accountID . '",bm_checkRemark="' . $checkRemark . '",bm_checkTime="' . $nowtime . '" WHERE bm_gameApplayId = ' . $applyItemId;
$result_update = sql_query($sql_update);
if ($result_update != 0) {
return new ExcuteResult(ResultStateLevel::SUCCESS, "", 1);
} else {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "邮件已成功发放到游戏，后台申请表单状态更新失败，请不要再次审核通过，联系网站管理人员！：）", NULL);
}
}
}
static function sql_date()
{
if (SETUP_DB_TYPE != "sqlite") {
$row = sql_fetch_one("SELECT now()");
} else {
$row = sql_fetch_one("SELECT datetime('now', 'localtime')");
}
return array_shift($row);
}
/**
* 依据卡订单获取卡详情
* @param unknown_type $cardFormID
*/
public function GetCardTypeInfoByCardFormID($cardFormID)
{
$sqlForm = "SELECT * FROM CD_CardApplyForm WHERE cd_CAFormID = " . $cardFormID;
$row = sql_fetch_one($sqlForm);
$returnArry = array();
if ($row != "") {
$o = array();
$cardApplyFormMDL = new CardApplyFormMDL($row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8], $row[9], $row[10]);
$o[] = $cardApplyFormMDL;
$returnArry[] = $o;
} else {
return new DataResult(ResultStateLevel::ERROR, "卡不存在", NULL, NULL);
}
$sql = "SELECT a.*,b.cd_CardTypeName FROM CD_CAFormCardInfo a,CD_CardType b";
$sql .= " WHERE a.cd_CardTypeID = b.cd_CardTypeID AND a.cd_CAFormID = " . $cardFormID;
$r = sql_fetch_rows($sql);
if (!empty($r)) {
$array = array();
for ($i = 0; $i < count($r); $i++) {
$rightsServ = $r[$i];
$rights = array();
$rights[] = $rightsServ[0];
$rights[] = $rightsServ[1];
$rights[] = $rightsServ[2];
$rights[] = $rightsServ[3];
$array[] = $rights;
}
$returnArry[] = $array;
return new DataResult(ResultStateLevel::SUCCESS, "", NULL, $returnArry);
} else {
return new DataResult(ResultStateLevel::ERROR, "", NULL, NULL);
}
}
function sql_genID($table)
{
if (strpos($table, "_nodb_")) {
return 0;
}
$table = "simple_seq_" . $table;
if (SETUP_DB_TYPE == "mysqli") {
$next = sprintf("update %s set id=last_insert_id(id+1)", $table);
if (!sql_query($next)) {
sql_query(sprintf("create table %s (id numeric(10) default 0) ENGINE=MyISAM", $table));
sql_query(sprintf("insert into %s values (0)", $table));
sql_query($next);
}
return mysqli_insert_id(sys::$db);
} else {
if (SETUP_DB_TYPE == "sqlite") {
if (!sql_query(sprintf("insert into %s values (null); delete from %s", $table, $table))) {
sql_query(sprintf("create table %s (id integer primary key)", $table));
sql_query(sprintf("insert into %s values (null)", $table));
}
return sys::$db->lastInsertId();
} else {
if (SETUP_DB_TYPE == "pgsql") {
$next = sprintf("select nextval('%s')", $table);
if (!($id = sql_fetch_one($next))) {
sql_query(sprintf("create sequence %s", $table));
$id = sql_fetch_one($next);
}
return $id["nextval"];
}
}
}
return 1;
}
/**
* 由卡ＩＤ获取卡种类信息(包括卡限制的所有信息)
* @param unknown_type $cardID
*/
public function getCardAllInfoByCardID($cardID)
{
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['account_ID'])) {
return new DataResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1", NULL);
}
$sql = "SELECT * FROM CD_CardType WHERE cd_CardTypeState < 99 AND cd_CardTypeID = " . $cardID;
$r = sql_fetch_one($sql);
if ($r != "") {
$o = array();
$cardTypeMDL = new CardTypeMDL($r[0], $r[1], $r[2], $r[3], $r[4], $r[5], $r[6], $r[7]);
$o[] = $cardTypeMDL;
$sqlLimit = "SELECT * FROM CD_CardGameType WHERE cd_CardTypeID = " . $cardID;
$rLimit = sql_fetch_rows($sqlLimit);
if (!empty($rLimit)) {
$ary = array();
foreach ($rLimit as $k => $v) {
$l_arry = array();
$l_arry[] = $v[0];
$l_arry[] = $v[1];
$l_arry[] = $v[2];
$l_arry[] = $v[3];
$l_arry[] = $v[4];
$ary[] = $l_arry;
}
$o[] = $ary;
}
return new DataResult(ResultStateLevel::SUCCESS, "", NULL, $o);
} else {
return new DataResult(ResultStateLevel::ERROR, "执行出错", NULL, NULL);
}
}
/**
* 合服时 处理被合服服务器数据
* @param unknown_type $serverID
* @param unknown_type $serverInfo1 被合到的目标服的 服务器标记
* @param unknown_type $remark
*/
public function updateGameServerHE($serverID, $serverInfo1, $remark, $gameID)
{
if (empty($serverID)) {
return new ExcuteResult(ResultStateLevel::ERROR, "删除失败，请刷新后再试！", NULL);
}
$sql_areaCheck1 = "SELECT bm_AreaID FROM bm_gameserver WHERE bm_ServerState <99 AND bm_ServerID = " . $serverID . " AND bm_GameID = " . $gameID;
$sql_areaCheck2 = "SELECT bm_AreaID FROM bm_gameserver WHERE bm_ServerState <99 AND bm_ServerPRI = " . $serverInfo1 . " AND bm_GameID = " . $gameID;
$r_areaCheck1 = sql_fetch_one($sql_areaCheck1);
$r_areaCheck2 = sql_fetch_one($sql_areaCheck2);
if ($r_areaCheck1 == "" || $r_areaCheck2 == "" || $r_areaCheck1 != $r_areaCheck2) {
return new ExcuteResult(ResultStateLevel::ERROR, "不存在的服务器 或者 服务器不是同一个区的不能合服！", NULL);
}
$sql_check = "SELECT bm_ServerPRI FROM bm_gameserver WHERE bm_ServerState <99 AND bm_ServerID = " . $serverID;
$r_check = sql_fetch_one($sql_check);
if ($r_check == "") {
return new ExcuteResult(ResultStateLevel::ERROR, "此游戏服务器不存在或已被删除！", NULL);
}
$sql_update = "UPDATE bm_gameserver SET bm_ServerState = 99,bm_ServerInfo1 = " . $serverInfo1 . " , bm_ServerRemark = '" . $remark . "' WHERE bm_ServerID = " . $serverID;
$r_update = sql_query($sql_update);
if ($r_update != 0) {
$sql = "SELECT bm_ServerID,bm_ServerName,bm_ServerPRI,bm_ServerInfo1,bm_ServerInfo2 ";
$sql .= " FROM bm_gameserver ";
$sql .= " WHERE bm_ServerState = 99 AND bm_ServerInfo1 = " . $r_check[0];
$rs = sql_fetch_rows($sql);
if (!empty($rs)) {
$isTrue = true;
$sql_update_server = "";
foreach ($rs as $k => $v) {
$sql_update_server = "UPDATE bm_gameserver SET bm_ServerInfo1 = " . $serverInfo1 . " WHERE bm_ServerID = " . $v[0];
$rs_server = sql_fetch_rows($sql_update_server);
if (empty($rs_server)) {
$isTrue = false;
}
}
return new ExcuteResult(ResultStateLevel::SUCCESS, $sql, $isTrue);
} else {
return new ExcuteResult(ResultStateLevel::SUCCESS, $sql, true);
}
} else {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "执行出错", NULL);
}
}
/**
* 更新卡的道具绑定信息
* @param $cardTypeID
* @param $gameStr
*/
public function UpdateCardItemInfo($cardTypeID, $gameStr)
{
$sqlCheck = "SELECT cd_CardTypeID FROM CD_CardType WHERE cd_CardTypeID = " . $cardTypeID . " AND cd_CardTypeState < 99 ";
$check = sql_fetch_one($sqlCheck);
if ($check == "") {
return new ExcuteResult(ResultStateLevel::EXCEPTION, "卡不存在", $cardTypeID);
}
AddBMAccountEventLog("删除卡种类ID：" . $cardTypeID, EventLogTypeEnum::CARDMANAGE);
if (!isset($_SESSION['account_ID'])) {
return new ExcuteResult(ResultStateLevel::ERROR, "账号已登出，请重新登录", "-1");
}
$sqldel = "delete from cd_cardaffixitem where cd_CardTypeID = " . $cardTypeID;
$rDell = sql_query($sqldel);
if ($rDell == 0) {
return new ExcuteResult(ResultStateLevel::ERROR, "更新卡道具失败");
}
if (empty($gameStr)) {
return new ExcuteResult(ResultStateLevel::SUCCESS, "", NULL);
}
$arr = array("NULL" => $cardTypeID);
$addStr = strtr($gameStr, $arr);
$sqladd = "insert into cd_cardaffixitem (cd_CardTypeID,bm_ItemID,cd_CardItemNum) values " . $addStr;
$add = sql_query($sqladd);
if ($add == 0) {
return new ExcuteResult(ResultStateLevel::ERROR, "非常抱歉，更新卡道具失败,原先的道具绑定已删除！", $sqladd);
} else {
return new ExcuteResult(ResultStateLevel::SUCCESS, "", NULL);
}
}
