function ViewUserInfo(&$db, $memb___id) { require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/SQL.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/VIP_.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Manager.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Manager/Language/{$MainLanguage}/Users.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Character.class.php"; $ch = new Character(); require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Manager/System/Manager.class.php"; $mn = new Manager(); $db->Query("SELECT memb__pwd, fpas_ques, fpas_answ, sno__numb, mail_addr, bloc_code, mail_chek, appl_days, memb_name FROM MEMB_INFO WHERE memb___id = '{$memb___id}'"); $membData = $db->GetRow(); require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php"; $this->acc = new Account($db); $credits = $this->acc->GetCreditAmount($memb___id, 0, $db); $dateClass = new Date(); $membData['bloc_code'] == 1 ? $blockStatus1 = "selected=\"selected\"" : ($blockStatus0 = "selected=\"selected\""); $membData['mail_chek'] == 1 ? $mailStatus1 = "selected=\"selected\"" : ($mailStatus0 = "selected=\"selected\""); $return = ""; $return .= "<hr />\n\t\t<fieldset>\n\t\t<legend>{$UsersMessage028}</legend>\n\t\t<table class=\"UserInfoTable\">\n\t\t <tr>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage051}</th>\n\t\t\t<td><input type=\"text\" name=\"memb_name\" id=\"memb_name\" size=\"10\" value=\"" . $membData['memb_name'] . "\" /></td>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">Status:</th>\n\t\t\t<td>"; if ($this->acc->CheckConnectStatus($memb___id, $db)) { $return .= "<span style=\"color:#006600\">ONLINE</span> <a href=\"javascript:;\" onclick=\"DisconnectFromGame('{$memb___id}')\">[DC]</a>"; } else { $return .= "<span style=\"color:#990000\">OFFLINE</span>"; } $return .= "\n\t\t\t</td>\n\t\t </tr>\n\t\t <tr>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage001}</th>\n\t\t\t<td>{$memb___id}</td>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage002}</th>\n\t\t\t<td>"; if ($mn->GetUserLevel($_SESSION['ManagerId'], $db) < $ManagerPasswViewLevel) { $return .= "************"; } else { $return .= "<input type=\"text\" name=\"memb__pwd\" id=\"memb__pwd\" size=\"10\" maxlength=\"10\" value=\"" . $membData['memb__pwd'] . "\" /></td>"; } $return .= "\n\t\t </tr>\n\t\t <tr>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage006}</th>\n\t\t\t<td><input type=\"text\" name=\"fpas_ques\" id=\"fpas_ques\" size=\"15\" value=\"" . $membData['fpas_ques'] . "\" /></td>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage008}</th>\n\t\t\t<td><input type=\"text\" name=\"mail_addr\" id=\"mail_addr\" size=\"20\" value=\"" . $membData['mail_addr'] . "\" /></td>\n\t\t </tr>\n\t\t <tr>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage007}</th>\n\t\t\t<td><input type=\"text\" name=\"fpas_answ\" id=\"fpas_answ\" size=\"15\" value=\"" . $membData['fpas_answ'] . "\" /></td>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage004}</th>\n\t\t\t<td>\n\t\t\t<select name=\"bloc_code\" id=\"bloc_code\">\n\t\t\t\t<option value=\"1\" {$blockStatus1}>{$UsersMessage024}</option>\n\t\t\t\t<option value=\"0\" {$blockStatus0}>{$UsersMessage025}</option>\n\t\t\t</select>\n\t\t\t</td>\n\t\t </tr>\n\t\t <tr>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage003}</th>\n\t\t\t<td><input type=\"text\" name=\"sno__numb\" id=\"sno__numb\" size=\"7\" value=\""; $return .= str_replace("000000", "", $membData['sno__numb']); $return .= "\" /></td>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage036}</th><td>" . $dateClass->DateFormat($membData['appl_days']) . "</td>\n\t\t </tr>\n\t\t <tr>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage009}</th>\n\t\t\t<td>\n\t\t\t<select name=\"mail_chek\" id=\"mail_chek\">\n\t\t\t\t<option value=\"1\" {$mailStatus1}>{$UsersMessage026}</option>\n\t\t\t\t<option value=\"0\" {$mailStatus0}>{$UsersMessage027}</option>\n\t\t\t</select>\n\t\t\t</td>\n\t\t\t<th nowrap=\"nowrap\" align=\"right\">{$UsersMessage005}</th>\n\t\t\t<td>{$UsersMessage022}<input type=\"text\" name=\"credits\" id=\"credits\" size=\"1\" value=\"{$credits}\" />{$UsersMessage023}</td>\n\t\t\t<td></td>\n\t\t </tr>\n\t\t <tr>\n\t\t \t<td colspan=\"4\" align=\"center\"><input type=\"Button\" value=\"{$UsersMessage072}\" onclick=\"UsersOpenDeleteForm('{$memb___id}')\" style=\"background-color: #F00 !important; background-image: none !important; color: #FFF !important;\" /> | <input type=\"Button\" value=\"{$UsersMessage053}\" onclick=\"UsersOpenMessageForm('{$memb___id}')\" style=\"background-color: #CCC !important; background-image: none !important; color: #000 !important;\" /> | <input type=\"Button\" value=\"{$UsersMessage039}\" onclick=\"SaveUserData('{$memb___id}')\" style=\"background-color: #0F0 !important; background-image: none !important; color: #000 !important;\" /></td>\n\t\t </tr>\n\t\t</table>\n\t\t</fieldset><hr />"; $return .= "<fieldset>\n\t\t<legend>{$UsersMessage028}</legend>\t\t\n\t\t<table class=\"UserInfoServersTable\"><tr>"; $db->Query("SELECT * FROM Z_Currencies"); $NumCurrencies = $db->NumRows(); $Currencies = array(); for ($i = 0; $i < $NumCurrencies; $i++) { $Currencies[$i] = $db->GetRow(); } foreach ($Currencies as $Key1 => $Value1) { $CurrencyAmount = $this->acc->GetCreditAmount($memb___id, $Value1['idx'], $db); $CreditsArray[$Value1['idx']]['value'] = $CurrencyAmount; $CreditsArray[$Value1['idx']]['name'] = $Value1['name']; $CreditsArray[$Value1['idx']]['id'] = $Value1['idx']; } $db->Query("SELECT * FROM Z_GameCurrencies"); $NumGameCurrencies = $db->NumRows(); $GameCurrencies = array(); for ($i = 0; $i < $NumGameCurrencies; $i++) { $GameCurrencies[$i] = $db->GetRow(); } foreach ($GameCurrencies as $Key1 => $Value1) { $CurrencyAmount = $this->acc->GetGameCreditAmount($memb___id, $Value1['idx'], $db); $GameCreditsArray[$Value1['idx']]['value'] = $CurrencyAmount; $GameCreditsArray[$Value1['idx']]['name'] = $Value1['name']; $GameCreditsArray[$Value1['idx']]['id'] = $Value1['idx']; } $db->Query("SELECT {$SQLVIPDateColumn} FROM MEMB_INFO WHERE memb___id = '{$memb___id}'"); $thisMembData = $db->GetRow(); $return .= "\n\t\t<td valign=\"top\">\n\t\t\t<table class=\"UserInfoServerTable\">\n\t\t\t<tr>\n\t\t\t <td align=\"right\" valign=\"top\">{$UsersMessage010}</td><td>"; $VipId = $this->acc->GetVip($memb___id, $db); $vip0 = $vip1 = $vip2 = $vip3 = ""; switch ($VipId) { case "0": $vip0 = " selected=\"selected\" "; break; case "1": $vip1 = " selected=\"selected\" "; break; case "2": $vip2 = " selected=\"selected\" "; break; case "3": $vip3 = " selected=\"selected\" "; break; } $return .= "\n\t\t\t <select name=\"VipLevel\" id=\"VipLevel\">\n\t\t\t\t<option value=\"0\" {$vip0}>{$VIP_0_Name}</option>\n\t\t\t\t<option value=\"1\" {$vip1}>{$VIP_1_Name}</option>\n\t\t\t\t<option value=\"2\" {$vip2}>{$VIP_2_Name}</option>\n\t\t\t\t<option value=\"3\" {$vip3}>{$VIP_3_Name}</option>\n\t\t\t </select>\n\t\t\t </td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t <td align=\"right\" valign=\"top\">{$UsersMessage011}</td><td nowrap=\"nowrap\">"; if (empty($thisMembData[$SQLVIPDateColumn])) { $DueDay = date("d"); $DueMonth = date("m"); $DueYear = date("Y"); } else { $format = strtotime(substr($thisMembData[$SQLVIPDateColumn], 0, 20)); $DueDay = date("d", $format); $DueMonth = date("m", $format); $DueYear = date("Y", $format); } $return .= "<input name=\"DueDay\" type=\"text\" id=\"DueDay\" size=\"1\" maxlength=\"2\" value=\"{$DueDay}\">/<input name=\"DueMonth\" type=\"text\" id=\"DueMonth\" size=\"1\" maxlength=\"2\" value=\"{$DueMonth}\">/<input name=\"DueYear\" type=\"text\" id=\"DueYear\" size=\"2\" maxlength=\"4\" value=\"{$DueYear}\"></td>\n\t\t\t</tr>"; $return .= "<tr><td align=\"center\" colspan=\"2\"> <hr /> </td></tr>"; //VIP ITEMS $return .= "\n\t\t\t<tr>\n\t\t\t <td align=\"right\" valign=\"top\">{$UsersMessage064}</td><td>"; $VipItem = $this->acc->GetVipItem($memb___id, $db); $vip0 = $vip1 = ""; switch ($VipItem) { case "0": $vip0 = " selected=\"selected\" "; break; case "1": $vip1 = " selected=\"selected\" "; break; } $return .= "\n\t\t\t <select name=\"VipItem\" id=\"VipItem\">\n\t\t\t\t<option value=\"0\" {$vip0}>{$UsersMessage063}</option>\n\t\t\t\t<option value=\"1\" {$vip1}>{$UsersMessage062}</option>\n\t\t\t </select>\n\t\t\t </td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t <td align=\"right\" valign=\"top\">{$UsersMessage011}</td><td nowrap=\"nowrap\">"; $VipItemsDueDate = $this->acc->GetVipItemDueDate($memb___id, $db); if (empty($VipItemsDueDate)) { $DueDay = date("d"); $DueMonth = date("m"); $DueYear = date("Y"); } else { $format = strtotime($VipItemsDueDate); $DueDay = date("d", $format); $DueMonth = date("m", $format); $DueYear = date("Y", $format); } $return .= "<input name=\"ItemDueDay\" type=\"text\" id=\"ItemDueDay\" size=\"1\" maxlength=\"2\" value=\"{$DueDay}\">/<input name=\"ItemDueMonth\" type=\"text\" id=\"ItemDueMonth\" size=\"1\" maxlength=\"2\" value=\"{$DueMonth}\">/<input name=\"ItemDueYear\" type=\"text\" id=\"ItemDueYear\" size=\"2\" maxlength=\"4\" value=\"{$DueYear}\"></td>\n\t\t\t</tr>"; $return .= "<tr><td align=\"center\" colspan=\"2\"> <hr /> </td></tr>"; $return .= "\n\t\t\t<tr><td colspan=\"2\">\n\t\t\t\n\t\t\t<fieldset>\n\t\t\t\t<legend>{$UsersMessage012}</legend>\n\t\t\t\t<table class=\"UserInfoCharsTable\" align=\"center\">\n\t\t\t\t <tr>\n\t\t\t\t\t<th align=\"center\" valign=\"middle\">{$UsersMessage013}</th>\n\t\t\t\t\t<th align=\"center\" valign=\"middle\">{$UsersMessage014}</th>\n\t\t\t\t\t<th align=\"center\" valign=\"middle\">{$UsersMessage015}</th>\n\t\t\t\t\t<th align=\"center\" valign=\"middle\">{$UsersMessage016}</th>\n\t\t\t\t </tr>\n\t\t\t\t\t"; $Characters = $this->acc->GetCharacters($memb___id, $db); foreach ($Characters as $Key2 => $Value2) { $return .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t <td align=\"center\" valign=\"middle\">"; if ($mn->GetUserLevel($_SESSION['ManagerId'], $db) < $ManagerCharEditLevel) { $return .= $Value2['Name']; } else { $return .= "<a href=\"javascript:;\" onclick=\"CharInfo('" . $Value2['Name'] . "')\">" . $Value2['Name'] . "</a>"; } $return .= "\n\t\t\t\t\t\t </td>\n\t\t\t\t\t\t <td align=\"center\" valign=\"middle\">" . $Value2['cLevel'] . "</td>\n\t\t\t\t\t\t <td align=\"center\" valign=\"middle\">" . $Value2[$SQLResetsColumn] . "</td>\n\t\t\t\t\t\t <td align=\"center\" valign=\"middle\">" . $ch->GetClassName($Value2['Class'], "tiny") . "</td>\n\t\t\t\t\t\t</tr>"; } $return .= "\n\t\t\t\t</table>\n\t\t\t</fieldset>\n\t\t\t</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</td>\n\t\t\n\t\t<td valign=\"top\">\n\t\t\t<fieldset>\n\t\t\t<legend>{$UsersMessage145}</legend>\n\t\t\t<table class=\"UserInfoServerTable\" align=\"center\">"; foreach ($Currencies as $Key1 => $Value1) { $FieldName = "Credit_" . $CreditsArray[$Value1['idx']]['id']; $return .= "\n\t\t\t\t<tr>\n\t\t\t\t <td align=\"right\" valign=\"top\">" . $CreditsArray[$Value1['idx']]['name'] . ":</td>\n\t\t\t\t <td align=\"left\">\n\t\t\t\t\t<input type=\"text\" name=\"{$FieldName}\" id=\"{$FieldName}\" value=\"" . $CreditsArray[$Value1['idx']]['value'] . "\" size=\"4\" />\n\t\t\t\t </td>\t\t\t\t \n\t\t\t\t</tr>\n\t\t\t\t"; } $return .= "<tr><td align=\"center\" colspan=\"2\"> <hr /> </td></tr>"; foreach ($GameCurrencies as $Key1 => $Value1) { $FieldName = "GameCredit_" . $GameCreditsArray[$Value1['idx']]['id']; $return .= "\n\t\t\t\t<tr>\n\t\t\t\t <td align=\"right\" valign=\"top\">" . $GameCreditsArray[$Value1['idx']]['name'] . ":</td>\n\t\t\t\t <td align=\"left\">\n\t\t\t\t\t<input type=\"text\" name=\"{$FieldName}\" id=\"{$FieldName}\" value=\"" . $GameCreditsArray[$Value1['idx']]['value'] . "\" size=\"4\" />\n\t\t\t\t </td>\t\t\t\t \n\t\t\t\t</tr>\n\t\t\t\t"; } $return .= "\n\t\t\t<tr><td align=\"center\" colspan=\"2\"> <hr /> </td></tr>\n\t\t\t</table>\n\t\t\t</fieldset>\n\t\t\t\n\t\t\t<table align=\"center\">\n\t\t\t<br />\n\t\t\t<tr>\n\t\t\t\t<td colspan=\"2\" align=\"center\"><input type=\"button\" value=\"Gravar\" onclick=\"SaveServerData('{$memb___id}')\" /></td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</td>"; $return .= "</tr></table></fieldset><hr>"; $return .= "<fieldset><legend>{$UsersMessage031}</legend>\n\t\t<table class=\"UserInfoDonationsTable\">\n\t\t <tr>\n\t\t\t<th align=\"center\">{$UsersMessage032}</th>\n\t\t\t<th align=\"center\">{$UsersMessage033}</th>\n\t\t\t<th align=\"center\">{$UsersMessage034}</th>\n\t\t\t<th align=\"center\">{$UsersMessage035}</th>\n\t\t </tr>"; $db->Query("SELECT * FROM Z_Income WHERE memb___id = '{$memb___id}' AND status = '1' ORDER BY date_confirm DESC"); $NumDon = $db->NumRows(); for ($i = 0; $i < $NumDon; $i++) { $data = $db->GetRow(); $return .= "\n\t\t\t <tr>\n\t\t\t <td align=\"center\">" . $dateClass->DateFormat($data['date_confirm']) . "</td>\n\t\t\t\t<td align=\"center\">{$UsersMessage022}" . $data['amount'] . "{$UsersMessage023}</td>\n\t\t\t\t<td>" . $data['bank'] . "</td>\n\t\t\t\t<td>" . $data['data'] . "</td>\n\t\t\t </tr>"; } $return .= "</table></fieldset><hr />"; return $return; }
function DrawTopOnlineTable($param1) { require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/SQL.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/VIP_.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/TopReset.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/TopOnline.php"; require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/Rankings.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php"; $acc = new Account($this->db); $rows = $param1; if ($TopOnlineMaxResults > 0 && $rows > $TopOnlineMaxResults) { return ""; } $return = "\n\t\t<table class=\"RankingOnlineTable\">\n\t\t\t<tr>\n\t\t\t\t<th id=\"Position\">{$RankingMessage008}</th>\n\t\t\t\t<th id=\"Name\">{$RankingMessage009}</th>\n\t\t\t\t<th id=\"OnlineTime\">{$RankingMessage069}</th>\n\t\t\t\t<th id=\"Resets\">{$RankingMessage011}</th>\n\t\t\t\t"; if ($TopOnlineShowClass) { $return .= "<th id=\"Class\">{$RankingMessage012}</th>"; } if ($TopOnlineShowGuild) { require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Guild.class.php"; $gd = new Guild(); $guild = $gd->GetGuildMemberArray($this->db); $return .= "<th id=\"Guild\">{$RankingMessage013}</th>"; } if ($TopOnlineShowStatus) { $OnlineCharacters = $acc->GetConnectedCharacters($this->db); $return .= "<th id=\"Status\">{$RankingMessage014}</th>"; } if ($TopOnlineShowVip) { $return .= "<th id=\"Vip\">{$RankingMessage016}</th>"; } $return .= "\n\t\t\t</tr>"; if (!is_numeric($rows) && $rows != "*") { die; } if ($rows == "*") { $rows = ""; } else { $rows = "TOP {$rows}"; } $query = "\n\t\t\tSELECT {$rows} i.{$SQLVIPColumn} as Vip, c.Name, c.{$SQLResetsColumn} as Resets, c.Class, c.{$SQLOnlineTimeColumn} as Online, RANK() OVER(ORDER BY c.{$SQLOnlineTimeColumn} DESC) as Rank\n\t\t\tFROM Character as c, MEMB_INFO as i\n\t\t\tWHERE c.CtlCode < 8 AND c.AccountID = i.memb___id\n\t\t\tORDER BY c.{$SQLOnlineTimeColumn} DESC\n\t\t\t"; $this->db->Query($query); $NumRows = $this->db->NumRows(); for ($i = 0; $i < $NumRows; $i++) { $CharData[$i] = $this->db->GetRow(); } for ($i = 0; $i < $NumRows; $i++) { $num = $i % 2 + 1; $data = $CharData[$i]; if ($SQLOnlineTimeDivisor > 0) { $onlineTime = number_format($data['Online'] / $SQLOnlineTimeDivisor, 0, "", ".") . $SQLOnlineTimeSufix; } else { $onlineTime = number_format($data['Online'], 0, "", ".") . $SQLOnlineTimeSufix; } $return .= "\n\t\t\t\t<tr class=\"RankingOnlineTableRow{$num}\">\n\t\t\t\t<td id=\"Position\">" . $data['Rank'] . "{$RankingMessage017}</td>\n\t\t\t\t<td id=\"Name\"><a href=\"/" . $_SESSION['SiteFolder'] . "?c=CharInfo/" . $data['Name'] . "\">" . $data['Name'] . "</a></td>\n\t\t\t\t<td id=\"OnlineTime\">" . $onlineTime . "</td>\n\t\t\t\t<td id=\"Resets\">" . $data['Resets'] . "</td>\n\t\t\t\t"; if ($TopOnlineShowClass) { require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Character.class.php"; $ch = new Character(); $class = $ch->GetClassName($data['Class'], $TopOnlineShowClassMode); $return .= "<td id=\"Class\">" . $class . "</td>"; } if ($TopOnlineShowGuild) { if (!empty($guild[$data['Name']])) { $guildName = $guild[$data['Name']]; } else { $guildName = "-"; } $return .= "<td id=\"Guild\">" . $guildName . "</td>"; } if ($TopOnlineShowStatus) { $status = in_array($data['Name'], $OnlineCharacters) ? $RankingMessage018 : $RankingMessage019; $return .= "<td id=\"Status\">" . $status . "</td>"; } if ($TopOnlineShowVip) { $vip = $data['Vip']; $vip = $acc->GetVipName($vip); $return .= "<td id=\"Vip\">{$vip}</td>"; } $return .= "\n\t\t\t</tr>"; } $return .= "</table>"; return $return; }