function __construct()
{
//Obtendo configurações básicas
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/GenericMessages.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php";
$db = new MuDatabase(0, false);
if (isset($_SESSION['ManagerLogin']) && isset($_SESSION['ManagerPassword'])) {
$ManagerLogin = $_SESSION['ManagerLogin'];
$ManagerPassword = $_SESSION['ManagerPassword'];
$db->Query("SELECT password FROM Z_Users WHERE username = '******'", false);
$data = $db->GetRow();
if (md5(md5(md5($data[0]))) == $ManagerPassword) {
$NumRows = 1;
} else {
$NumRows = 0;
}
if ($NumRows == 0) {
$db->Disconnect();
session_destroy();
die("<script>alert('Access denied!'); window.location.href='/{$MainSiteFolderManager}';</script>");
}
} else {
$db->Disconnect();
die("<script>alert('Access denied!'); window.location.href='/{$MainSiteFolderManager}';</script>");
}
$db->Disconnect();
}
function GetUserLevel($id, &$db)
{
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php";
$db->Disconnect();
$db = new MuDatabase(0, false);
$db->Query("SELECT userlevel FROM Z_Users WHERE id = '{$id}'", false);
$data = $db->GetRow();
$db->Disconnect();
$db = new MuDatabase();
return $data[0];
}
function __construct()
{
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/SQL.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/GenericMessages.php";
if (isset($_SESSION['memb___id']) && isset($_SESSION['memb__pwd'])) {
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php";
$db = new MuDatabase();
$memb___id = $_SESSION['memb___id'];
$memb__pwd = $_SESSION['memb__pwd'];
$NumRows = 0;
if ($SQLMD5Password) {
$db->Query("SELECT COUNT(memb_guid) FROM MEMB_INFO WHERE memb___id = '{$memb___id}' AND memb__pwd = [{$MainSQLDBName}].[dbo].[DT_GenHash](memb___id,'{$memb__pwd}')");
$data = $db->GetRow();
$NumRows = $data[0];
} else {
$db->Query("SELECT memb__pwd FROM MEMB_INFO WHERE memb___id = '{$memb___id}'");
$data = $db->GetRow();
if (md5(md5(md5($data[0]))) == $memb__pwd) {
$NumRows = 1;
}
}
if ($NumRows <= 0) {
$error = $GenericMessage06;
session_destroy();
$db->Disconnect();
die($error);
return false;
}
} else {
echo "<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"0; URL=/" . $MainSiteFolder . "?c=LoggedOnly\">";
die;
return false;
}
return true;
}
for ($i = 0; $i < $NumAllies; $i++) {
$result = $db->GetRow();
if ($result[0] != $CSOwner) {
$CSAllies[$i] = $result[0];
}
$CSMembers += $result[1];
}
} else {
$CSOwner = "-";
$CSKing = "-";
$CSMark = "";
$CSWins = "-";
$CSAllies = array();
$CSMembers = "-";
}
$db->Disconnect();
?>
<style>
.CSOwnersTable
{
font-family:Verdana, Geneva, sans-serif !important;
font-weight:bold !important;
color: #FFF !important;
}
.CSOwners
{
font-size:12px !important;
letter-spacing:5px !important;
text-align:center !important;
color: #FFF !important;
function DownloadAndInstall($version)
{
$url = "http://www.leoferrarezi.com/muweb/updates/{$version}.zip";
$this->StaticFileData = NULL;
$this->StaticProgress = (int) (0 + ($this->StaticUpdateCount - $this->StaticRemainingUpdates) * 100 / $this->StaticUpdateCount);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, FALSE);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch, CURLOPT_AUTOREFERER, TRUE);
curl_setopt($ch, CURLOPT_BINARYTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_FAILONERROR, TRUE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_NOPROGRESS, FALSE);
curl_setopt($ch, CURLOPT_BUFFERSIZE, 256);
curl_setopt($ch, CURLOPT_WRITEFUNCTION, array($this, "DownloadProgress"));
$updateFile = curl_exec($ch);
if (!$updateFile) {
$error = "<script>UpdateError('Error: " . curl_error($ch) . " for {$version}')</script>";
curl_close($ch);
echo $error;
exit;
}
curl_close($ch);
if (!file_put_contents($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "{$version}.zip", $this->StaticFileData)) {
echo "<script>UpdateError('Error: could not save the update file {$version}.zip')</script>";
exit;
}
$zip = new ZipArchive();
$res = $zip->open($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "{$version}.zip");
if ($res === true) {
if (!$zip->extractTo($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'])) {
echo "<script>UpdateError('Error: unable to extract the zip file {$version}.zip')</script>";
$zip->close();
@unlink($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "{$version}.zip");
exit;
}
} else {
echo "<script>UpdateError('Error: unable to open the zip file {$version}.zip')</script>";
$zip->close();
@unlink($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "{$version}.zip");
exit;
}
$zip->close();
@unlink($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "{$version}.zip");
if (file_exists($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "query.sql")) {
$handle = fopen($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "query.sql", "r");
$query = fread($handle, filesize($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "query.sql"));
fclose($handle);
@unlink($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "query.sql");
$db = new MuDatabase();
$db->Query($query);
$db->Disconnect();
}
if (file_exists($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "exec.php")) {
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "exec.php";
ExecUpdateScript();
@unlink($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "exec.php");
}
}
function ViewTicket($ticketId)
{
//print_r($_SERVER);
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/HelpDesk.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/HelpDesk.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/GenericMessages.php";
$db = $this->db;
$db2 = new MuDatabase();
$return = "";
$db->Query("SELECT idx FROM Z_HelpDeskTickets WHERE idx = '{$ticketId}' AND memb___id = '" . $this->acc->memb___id . "'");
if ($db->NumRows() <= 0) {
return $GenericMessage03;
}
$db->Query("SELECT * FROM Z_HelpDeskMessages WHERE ticket_idx = '{$ticketId}' ORDER BY date");
$return .= "<p class=\"HelpDeskBackLink\"><a href='?c=HelpDesk/'>{$HelpDeskMessage14}</a></p>";
$return .= "<p class=\"HelpDeskViewTitle\">{$HelpDeskMessage12}" . $ticketId . "</p>";
$return .= "<table class=\"HelpDeskMessagesTable\">";
$numrows = $db->NumRows();
for ($i = 0; $i < $numrows; $i++) {
$data = $db->GetRow();
if ($data['by'] == $this->acc->memb___id) {
$trClass = "HelpDeskUserMessage";
} else {
$trClass = "HelpDeskSupporterMessage";
}
$db2->Query("SELECT * FROM Z_HelpDeskAttach WHERE msg_idx = '" . $data['idx'] . "'");
$attachsNum = $db2->NumRows();
$attachs = "";
if ($attachsNum > 0) {
$attachs = "<p><span style=\"float: right\">{$HelpDeskMessage25}<br />";
for ($j = 0; $j < $attachsNum; $j++) {
$attachData = $db2->GetRow();
$attachs .= "<a href=\"/" . $_SESSION['SiteFolder'] . "{$HelpDeskUploadDir}/" . $attachData['file'] . "\" target=\"_blank\">[" . $attachData['orig_name'] . "]</a> ";
}
$attachs .= "</span></p>";
}
$return .= "\n\t\t\t<tr align=\"left\" class=\"{$trClass}\">\n\t\t\t <td valign=\"top\" class=\"HelpDeskUserTd\" nowrap=\"nowrap\">" . $data['by'] . "<br />" . $this->theDate->DateFormat($data['date']) . "<br />" . $this->theDate->TimeFormat($data['date'], "h") . "</td>\n\t\t\t <td valign=\"top\" class=\"HelpDeskMessageTd\">" . $data['message'] . "{$attachs}</td>\n\t\t\t</tr>";
}
$return .= "</table>";
$db2->Disconnect();
$db->Query("SELECT status FROM Z_HelpDeskTickets WHERE idx = '{$ticketId}'");
$ticketStatus = $db->GetRow();
if ($ticketStatus[0] > 1) {
$return .= "<p style=\"font-weight:bold\">{$HelpDeskMessage16}</p>";
} else {
if ($this->GetBlockStatus($this->acc->memb___id) == 1) {
$return .= $HelpDeskMessage07;
} else {
$return .= "<p align=\"left\" class=\"HelpDeskGenericTitle\">{$HelpDeskMessage15}</p>";
$return .= "<form action=\"?c=HelpDesk/{$ticketId}\" method=\"post\" name=\"HelpDeskPost\" enctype=\"multipart/form-data\">";
$return .= "<textarea class=\"HelpDeskMessageBox\" name=\"message\" id=\"message\"></textarea>";
$return .= "<p align=\"left\">{$HelpDeskMessage17}</p>";
for ($i = 0; $i < $HelpDeskMaxFiles; $i++) {
$return .= "<input name=\"file[]\" type=\"file\" class=\"HelpDeskFileBox\"><br />";
}
$return .= "<br /><p><input name=\"submitCall\" type=\"submit\" class=\"HelpDeskSubmitButton\" id=\"submitCall\" value=\"{$HelpDeskMessage18}\"></p>";
$return .= "</form>";
}
}
$return .= "<p> </p><p align=\"center\"><a href='?c=HelpDesk/'>{$HelpDeskMessage14}</a></p>";
return $return;
}
