x-MU.net форум

<?
?>
<?

if(!defined('DEW_Engine')) {
Exit;
}

/*   Deathless Engine Web © 2010   */

?>

<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0">
<?   if($Imperials['enable'] == 1) { ?>
<tr>
<td valign='top' class='yarr' align='center'><img alt='Credits' src='Images/Misc/Credits.png' width='10'> <font color="#669933"><?php echo phrase_your_mucash;?> <?php echo $Imperials['name'];?>: <?php echo $credits[0];?></font></td>
</tr>
<? } ?>

<?   if($Currency['enable'] == 1) {
if ($Currency['ByCharOrAcc'] == 1)   {   $mucashq = $username;   }
if ($Currency['ByCharOrAcc'] == 0)   {   $mucashq = $char_name;   }
?>
<tr>
<td valign='top' class='yarr' align='center'><img alt='Coins' src='Images/Misc/Coins.png' width='10'> <font color="#b05800"><?php echo phrase_your_mucash;?> <?php echo $Currency['name']; ?>: <?php echo GetCashPoints($mucashq,$Extra['reedlan']); ?></font></td>
</tr>
<? } ?>

<tr>
<td valign='top' class='yarr' align='center'><img alt='Profile' src='Images/Misc/Profile.png' width='10'> <a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Profile/'.$nick_name);?>');"><b><? echo "<font color='#2d87b3'>".phrase_profile."</font> ".$new_events; ?></b></a></td>
</tr>
<tr>
<td valign='top' class='yarr' align='center'><hr noshade align="center" color="#101519" size="1" width="50%"></td>
</tr>
<tr>
<td>
<table align="center">
<tr>
<td>
<ul id="sddm">
<?php if ($Module['Reset'] == 0 && $Module['PKClear'] == 0 && $Module['AddStats'] == 0 && $Module['PassChange'] == 0 && $Module['Teleport'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m1')" onmouseout="mclosetime()"><?php echo phrase_usermenu1;?></a>
<div id="m1" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['Reset'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Reset');?>');"><?php echo phrase_menu_reset;?></a><? } ?>
<? if($Module['PKClear'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('PKClear');?>');"><?php echo phrase_pkclear;?></a><? } ?>
<? if($Module['AddStats'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AddStats');?>');"><?php echo phrase_addstats;?></a><? } ?>
<? if($Module['Teleport'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Teleport');?>');"><?php echo phrase_teleport;?></a><? } ?>
<? if($Module['PassChange'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('PassChange');?>');"><?php echo phrase_passchng;?></a><? } ?>
</div>
</li>
<? } if ($Module['Warehouse'] == 0 && $Module['History'] == 0 && $Module['ZenTransfer'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m2')" onmouseout="mclosetime()"><?php echo phrase_usermenu2;?></a>
<div id="m2" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['Warehouse'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Warehouse');?>');"><?php echo phrase_menu_game_bank;?></a><? } ?>
<? if($Module['Warehouse'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Warehouse/Web');?>');"><?php echo phrase_menu_web_bank;?></a><? } ?>
<? if($Module['History'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('History');?>');"><?php echo phrase_menu_m_history;?></a><? } ?>
<? if($Module['Smithy'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('SmithyHistory');?>');"><?php echo phrase_smithy_history;?></a><? } ?>
<? if($Module['ZenTransfer'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('ZenTransfer');?>');"><?php echo phrase_zentrans;?></a><? } ?>
</div>
</li>
<? } if ($Module['ChangeClass'] == 0 && $Module['NameChange'] == 0 && $Module['HideInfo'] == 0 && $Module['GrandReset'] == 0 && $Module['BuyVIP'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m3')" onmouseout="mclosetime()"><?php echo phrase_usermenu3;?></a>
<div id="m3" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['ChangeClass'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('ChangeClass');?>');"><?php echo phrase_changecl;?></a><? } ?>
<? if($Module['NameChange'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('NameChange');?>');"><?php echo phrase_namechng;?></a><? } ?>
<? if($Module['HideInfo'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('HideInfo');?>');"><?php echo phrase_hideinfo;?></a><? } ?>
<? if($Module['GrandReset'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('GrandReset');?>');"><?php echo phrase_greset;?></a><? } ?>
<? if($Module['BuyVIP'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('BuyVIP');?>');">VIP Status</a><? } ?>
</div>
</li>
<? } if ($Module['VoteReward'] == 0 && $Module['OnlineTime'] == 0 && $Module['Smithy'] == 0 && $Module['Imperials'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m4')" onmouseout="mclosetime()"><?php echo phrase_usermenu4;?></a>
<div id="m4" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['VoteReward'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('VoteReward');?>');"><?php echo phrase_voterew;?></a><? } ?>
<? if($Module['VoteReward'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('MMOTOP');?>');">MMOTOP</a><? } ?>
<? if($Module['OnlineTime'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('OnlineTime');?>');"><?php echo phrase_otime;?></a><? } ?>
<? if($Module['Smithy'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Smithy');?>');"><?php echo phrase_smithy;?></a><? } ?>
<? if($Module['Imperials'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Imperials');?>');"><font color="#d03131"><?php echo phrase_buy_credits;?></font></a><? } ?>
</div>
</li>
<? } ?>
<? if($IsAdmin == 'true' OR $IsGm == 'true') { ?>
<li>
<a href="#" onmouseover="mopen('m5')" onmouseout="mclosetime()">AdminPanel</a>
<div id="m5" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<a href="java script:void(0);"  onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/BanAcc');?>');">BanAcc</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Search');?>');">Search IP</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Downloads');?>');">Downloads</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Vote');?>');">Vote Reward</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Item');?>');">Item Manager</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Imperials');?>');">Add <?php echo $Imperials['name'];?></a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Currency');?>');">Add <? echo $Currency['name'] ?></a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Pages');?>');">Page Manager</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Forum');?>');">Forum Manager</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Marry');?>');">Marry Manager</a>
<a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AdminPanel/Database');?>');">Database Manager</a>
</div>
</li>
<? } ?>
</ul>
</td>
</tr>
</table>
</td>
</tr>
</table>

<?
################################################
#                                              #
#          Deathless Engine Web                #
#                                              #
#          Copyright: Deathless                #
#          Skype: MuAntrum                     #
#          E-Mail: MuAntrum@GMail.com          #
#                                              #
################################################
?>
<?

if(!defined('DEW_Engine')) {
Exit;
}

/*   Deathless Engine Web © 2010   */

?>

<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0">
<?   if($Imperials['enable'] == 1) { ?>
<tr>
<td valign='top' class='yarr' align='center'><img alt='Credits' src='Images/Misc/Credits.png' width='10'> <font color="#669933"><?php echo phrase_your_mucash;?> <?php echo $Imperials['name'];?>: <?php echo $credits[0];?></font></td>
</tr>
<? } ?>

<?   if($Currency['enable'] == 1) {
if ($Currency['ByCharOrAcc'] == 1)   {   $mucashq = $username;   }
if ($Currency['ByCharOrAcc'] == 0)   {   $mucashq = $char_name;   }
?>
<tr>
<td valign='top' class='yarr' align='center'><img alt='Coins' src='Images/Misc/Coins.png' width='10'> <font color="#b05800"><?php echo phrase_your_mucash;?> <?php echo $Currency['name']; ?>: <?php echo GetCashPoints($mucashq,$Extra['reedlan']); ?></font></td>
</tr>
<? } ?>

<tr>
<td valign='top' class='yarr' align='center'><img alt='Profile' src='Images/Misc/Profile.png' width='10'> <a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Profile/'.$nick_name);?>');"><b><? echo "<font color='#2d87b3'>".phrase_profile."</font> ".$new_events; ?></b></a></td>
</tr>
<tr>
<td valign='top' class='yarr' align='center'><hr noshade align="center" color="#101519" size="1" width="50%"></td>
</tr>
<tr>
<td>
<table align="center">
<tr>
<td>
<ul id="sddm">
<?php if ($Module['Reset'] == 0 && $Module['PKClear'] == 0 && $Module['AddStats'] == 0 && $Module['PassChange'] == 0 && $Module['Teleport'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m1')" onmouseout="mclosetime()"><?php echo phrase_usermenu1;?></a>
<div id="m1" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['Reset'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Reset');?>');"><?php echo phrase_menu_reset;?></a><? } ?>
<? if($Module['PKClear'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('PKClear');?>');"><?php echo phrase_pkclear;?></a><? } ?>
<? if($Module['AddStats'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('AddStats');?>');"><?php echo phrase_addstats;?></a><? } ?>
<? if($Module['Teleport'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Teleport');?>');"><?php echo phrase_teleport;?></a><? } ?>
<? if($Module['PassChange'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('PassChange');?>');"><?php echo phrase_passchng;?></a><? } ?>
</div>
</li>
<? } if ($Module['Warehouse'] == 0 && $Module['History'] == 0 && $Module['ZenTransfer'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m2')" onmouseout="mclosetime()"><?php echo phrase_usermenu2;?></a>
<div id="m2" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['Warehouse'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Warehouse');?>');"><?php echo phrase_menu_game_bank;?></a><? } ?>
<? if($Module['Warehouse'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Warehouse/Web');?>');"><?php echo phrase_menu_web_bank;?></a><? } ?>
<? if($Module['History'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('History');?>');"><?php echo phrase_menu_m_history;?></a><? } ?>
<? if($Module['Smithy'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('SmithyHistory');?>');"><?php echo phrase_smithy_history;?></a><? } ?>
<? if($Module['ZenTransfer'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('ZenTransfer');?>');"><?php echo phrase_zentrans;?></a><? } ?>
</div>
</li>
<? } if ($Module['ChangeClass'] == 0 && $Module['NameChange'] == 0 && $Module['HideInfo'] == 0 && $Module['GrandReset'] == 0 && $Module['BuyVIP'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m3')" onmouseout="mclosetime()"><?php echo phrase_usermenu3;?></a>
<div id="m3" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['ChangeClass'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('ChangeClass');?>');"><?php echo phrase_changecl;?></a><? } ?>
<? if($Module['NameChange'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('NameChange');?>');"><?php echo phrase_namechng;?></a><? } ?>
<? if($Module['HideInfo'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('HideInfo');?>');"><?php echo phrase_hideinfo;?></a><? } ?>
<? if($Module['GrandReset'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('GrandReset');?>');"><?php echo phrase_greset;?></a><? } ?>
<? if($Module['BuyVIP'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('BuyVIP');?>');">VIP Status</a><? } ?>
</div>
</li>
<? } if ($Module['VoteReward'] == 0 && $Module['OnlineTime'] == 0 && $Module['Smithy'] == 0 && $Module['Imperials'] == 0) { } else { ?>
<li>
<a href="#" onmouseover="mopen('m4')" onmouseout="mclosetime()"><?php echo phrase_usermenu4;?></a>
<div id="m4" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<? if($Module['VoteReward'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('VoteReward');?>');"><?php echo phrase_voterew;?></a><? } ?>
<? if($Module['VoteReward'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('MMOTOP');?>');">MMOTOP</a><? } ?>
<? if($Module['OnlineTime'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('OnlineTime');?>');"><?php echo phrase_otime;?></a><? } ?>
<? if($Module['Smithy'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Smithy');?>');"><?php echo phrase_smithy;?></a><? } ?>
<? if($Module['Imperials'] == 1) { ?><a href="java script:void(0);" onClick="dew_link('<?=$URL_class->DEW_Crypt('Imperials');?>');"><font color="#d03131"><?php echo phrase_buy_credits;?></font></a><? } ?>
</div>
</li>
<? } ?>
<? if($IsAdmin == 'true' OR $IsGm == 'true') { ?>
<li>
<a href="#" onmouseover="mopen('m5')" onmouseout="mclosetime()">AdminPanel</a>
<div id="m5" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Ban');?>">Ban Manager</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Search');?>">Search IP</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Downloads');?>">Downloads</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Vote');?>');?>">Vote Reward</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Item');?>');?>">Item Manager</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Imperials');?>">Add <?php echo $Imperials['name'];?></a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Currency');?>">Add <? echo $Currency['name'] ?></a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Pages');?>');?>">Page Manager</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Forum');?>');?>">Forum Manager</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Marry');?>');?>">Marry Manager</a>
<a href="<?=$URL_class->DEW_Crypt('AdminPanel/Database');?>">Database Manager</a>
</div>
</li>
<? } ?>
</ul>
</td>
</tr>
</table>
</td>
</tr>
</table>

<?
################################################
#                                              #
#          Deathless Engine Web                #
#                                              #
#          Copyright: Deathless                #
#          Skype: MuAntrum                     #
#          E-Mail: MuAntrum@GMail.com          #
#                                              #
################################################
?>
<?php

if(!defined('DEW_Engine')) {
Exit;
}

if($IsAdmin == 'true' OR $IsGm == 'true') {

/*#########################   BAN IP MODULE START   #########################*/

if ($gmpanel_a == 'true') {
if($Web_URL[1] == 'Ban'){
if (isset($_POST['blockacc_s'])) {
$accountname      = $Security->CheckWord($_POST['acc']);
$block_term         = $_POST['term'];
$block_time_type   = $_POST['time_type'];
$block_reason      = $Security->CheckWord($_POST['reason']);
$sql_username_check   = $DB->Query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$accountname'");
$username_check    = $DB->NumRows($sql_username_check);
if ($block_time_type == 'hour')   {   $block_time = $block_term * 3600;   }
if ($block_time_type == 'day')   {   $block_time = $block_term * 86400;   }
if ($block_time_type == 'week')   {   $block_time = $block_term * 604800;   }
if ($block_time_type == 'permanent')   {   $unblock_time   = "Permanent";               }
else                           {   $unblock_time   = $Current_Time + $block_time;   }

if(empty($accountname)) {
$blockmsge   = 'Empty!';
}
elseif($username_check == 0) {
$blockmsge   = 'Dont exists!';
}
else {
$DB->Query("
UPDATE dbo.MEMB_INFO SET bloc_code = '1', unblock_time = '$unblock_time', block_reason = '$block_reason', blocked_by = '$char_name' WHERE memb___id = '$accountname';
INSERT INTO DEW_ban_log (memb___id,blocked_by,block_time,unblock_time,block_reason) VALUES ('$accountname','$char_name','$Current_Time','$unblock_time','$block_reason')
");
$blockmsgo = 'Account Blocked!';
}
}
echo   DEW_Message('error',$blockmsge);
echo   DEW_Message('ok',$blockmsgo);

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>BAN ACCOUNT!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>Account:</b></td>
<td colspan="2"><input type="text" class="txt-simple" size="20" maxlength="10" name="acc" value=""></td>
</tr>
<tr>
<td class="text_default"><b>Term:</b></td>
<td><input type="text" class="txt-simple" size="5" maxlength="11" name="term" value="0"></td>
<td>
<script type="text/javascript">
var smsend = new selectInput("smsend", "time_type", "HOUR", "hour", "", "74");
smsend.add("HOUR", "hour");
smsend.add("DAY", "day");
smsend.add("WEEK", "week");
smsend.add("PERMANENT", "permanent");
smsend.construct();
</script>
</td>
</tr>
<tr>
<td class="text_default"><b>Reason:</b></td>
<td colspan="2"><input type="text" class="txt-simple" size="20" maxlength="50" name="reason" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="bt1" name="blockacc_s" value="Block Account!"></td>
</tr>
</table>
</form>
</div>
<br>

<?php

if(isset($_POST['ban_ip_s'])) {
$banip_f      = $Security->CheckWord($_POST['ip']);
$block_reason   = $Security->CheckWord($_POST['reason']);
if(empty($banip_f)) {
$blockmsgoka   = 'Empty!';
}
else {
$DB->Query("INSERT INTO DEW_ban_ip (ip,blocked_by,block_time,block_reason) VALUES ('$banip_f','$char_name','$Current_Time','$block_reason')");
$blockmsgoka   = 'IP Banned!';
}
}
echo   DEW_Message('ok',$blockmsgoka);

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>BAN IP!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>User IP:</b></td>
<td colspan="2"><input type="text" class="text-form" size="20" maxlength="15" name="ip" value=""></td>
</tr>
<tr>
<td class="text_default"><b>Reason:</b></td>
<td colspan="2"><input type="text" class="text-form" size="20" maxlength="50" name="reason" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="ban_ip_s" value="Block IP!"></td>
</tr>
</table>
</form>
</div>
<br>

<?php

if(isset($_POST['unblockacc_s'])){
$accountname   = $Security->CheckWord($_POST['acc']);
$block_reason   = $Security->CheckWord($_POST['reason']);
$DB->Query("UPDATE dbo.MEMB_INFO SET bloc_code = '0' WHERE memb___id='$accountname'");
$unblockmsgoka   = 'Account Unblocked';
}
echo   DEW_Message('ok',$unblockmsgoka);

?>

<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>UNBAN ACCOUNT!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>Account:</b></td>
<td><input type="text" class="text-form" size="20" maxlength="10" name="acc" value=""></td>
</tr>
<tr>
<td class="text_default"><b>Reason:</b></td>
<td><input type="text" class="text-form" size="20" maxlength="50" name="reason" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="unblockacc_s" value="Unblock Account!"></td>
</tr>
</table>
</form>
</div>
<br>

<?php

if(isset($_POST['unblockip_s'])){
$ip            = $Security->CheckWord($_POST['IP']);
$unset_block   = $DB->Query("DELETE FROM DEW_ban_ip WHERE ip = '$ip'");
$unblockmsgokb   = 'IP Unblocked';
}
echo   DEW_Message('ok',$unblockmsgokb);

?>

<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>UNBAN IP!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>IP:</b></td>
<td><input type="text" class="text-form" size="20" maxlength="15" name="IP" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="unblockip_s" value="Unblock IP!"></td>
</tr>
</table>
</form>
</div>
</div>

<?

}
}

/*#########################   SEARCH IP MODULE START   #########################*/

if ($gmpanel_b == 'true') {
if($Web_URL[1] == 'Search') {
if(isset($_POST['get_login_s'])){
$char_nick   = $Security->CheckWord($_POST['char']);
$get_login    = $DB->FetchArray($DB->Query("select * from Character WHERE Name ='$char_nick'"));
echo   DEW_Message('ok',"Character's $char_nick login is: ".$get_login['AccountID']);
}

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>GET LOGIN!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>CharNick:</b></td>
<td><input type="text" class="text-form" size="20" maxlength="10" name="char" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="get_login_s" value="Get Login!"></td>
</tr>
</table>
</form>
</div>
<br>

<?

if(isset($_POST['search_ip_s'])) {
$accountname   = $Security->CheckWord($_POST['acc']);
$get_acc_info    = $DB->FetchArray($DB->Query("select * from MEMB_STAT WHERE memb___id='$accountname'"));
echo   DEW_Message('ok',"Account's $accountname IP is: ".$get_acc_info['IP']);
}

?>

<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>IP SEARCH!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>Account:</b></td>
<td><input type="text" class="text-form" size="10" maxlength="10" name="acc" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="search_ip_s" value="Search Ip"></td>
</tr>
</table>
</form>
</div>
<br>

<?

if(isset($_POST['search_acc_s'])) {
$find_ip      = $Security->CheckWord($_POST['ip']);
$get_acc_info_   = $DB->Query("select * from MEMB_STAT WHERE IP='$find_ip'");
for($i = 0; $i < $DB->NumRows($get_acc_info_); ++$i) {
$get_acc_info   = $DB->FetchArray($get_acc_info_);
echo   DEW_Message('ok',"IP's $find_ip acc is: ".$get_acc_info['memb___id']);
}
}

?>

<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>SEARCH ACC!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>IP:</b></td>
<td><input type="text" class="text-form" size="10" maxlength="15" name="ip" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="search_acc_s" value="Search Acc"></td>
</tr>
</table>
</form>
</div>
</div>

<?

}
}

/*#########################   DOWNLOADS MANAGER MODULE START   #########################*/

if ($gmpanel_c == 'true') {
if($Web_URL[1] == 'Downloads') {
if($_POST['linkedit']) {
$link_array_key = array_keys($_POST['linkedit']);
$link_array = explode(";",$link_array_key[0]);
$link_id = $link_array[1];
$link_edit_action = $link_array[0];
$link_found = 0;
$dlink_db = file("Includes/DEW_DB/DownloadLinks.DEW");
foreach($dlink_db as $link_db_line) {
if(!eregi("#",$link_db_line)) {
$link_db = explode("|",$link_db_line);
if($link_db[0] == $link_id) {
$link_found=1;
break;
}
}
}
if($link_found != 1 AND $link_id != 'n/a') { }
else {
switch($link_edit_action) {
case 2:
$delete_link = 1;
$link_manager_msg = 'Link successfully deleted';
break;
case 3:
$add_link=1;
$do_not_edit = 1;
$link_manager_msg = 'Link successfully added';
break;
default:
die("ERROR");
break;
}
$dlink_db = file("Includes/DEW_DB/DownloadLinks.DEW");
$dlink_db_new = fopen("Includes/DEW_DB/DownloadLinks.DEW", "w");
foreach($dlink_db as $link_db_line) {
if(!eregi("#",$link_db_line)) {
$link_db = explode("|",$link_db_line);
if($link_db[0] == $link_id) {
if($do_not_edit == 1){ }
elseif($delete_link == 1) {
fwrite($dlink_db_new,"");
}
}
else {
fwrite($dlink_db_new,"$link_db_line");
}
}
else {
fwrite($dlink_db_new,"$link_db_line");
}
}
if($add_link == 1) {
$new_id = time();
$new_link_img = $_POST['new_link_img'];
$new_link_name = $_POST['new_link_name'];
$new_link_desc = $_POST['new_link_desc'];
$new_link_url = $_POST['new_link_url'];
fwrite($dlink_db_new,"$new_id|$new_link_img|$new_link_name|$new_link_desc|$new_link_url|n");
}
fclose($dlink_db_new);
echo   DEW_Message('ok',$link_manager_msg);
}
}

?>

<form method="post" action="">
<table border="0" width="100%" cellspacing="1" cellpadding="0" class="tdef">
<tr align="center">
<td>Type</td>
<td>Name</td>
<td>Size</td>
<td>Link</td>
<td>Control</td>
</tr>

<?php

$dlink_db = file("Includes/DEW_DB/DownloadLinks.DEW");
foreach($dlink_db as $link_db_line) {
if(!eregi("#",$link_db_line)) {
$link_db = explode("|",$link_db_line);
echo "
<tr align=center>
<td>".$link_db[1]."</td>
<td>".$link_db[2]."</td>
<td>".$link_db[3]."</td>
<td>".substr($link_db[4], 0, 20)."</td>
<td><input class="button-gray" style="color:red" name="linkedit[2;$link_db[0]]" value="Delete" type="submit"></td>
</tr>";
}
}

?>

<tr align="center">
<td>
<script type="text/javascript">
var mtispd = new selectInput("mtispd", "new_link_img", "Client", "Client", "", "70");
mtispd.add("Client", "Client");
mtispd.add("Patch", "Patch");
mtispd.add("Music", "Music");
mtispd.add("Misc", "Misc");
mtispd.construct();
</script>
</td>
<td><input class="text-form" type="text" name="new_link_name" value="" maxlength="45" size="10"></td>
<td><input class="text-form" type="text" name="new_link_desc" value="" maxlength="6" size="10"></td>
<td><input class="text-form" type="text" name="new_link_url" value="" maxlength="150" size="10"></td>
<td><input class="submit-form" style="color:red" name="linkedit[3;n/a]" value="Add Link" type="submit"></td>
</tr>
</table>
</form>

<?

}
}

/*#########################   VOTE & REWARD MODULE START   #########################*/

if ($gmpanel_d == 'true') {
if($Web_URL[1] == 'Vote') {
if(isset($_POST['add_link'])) {
$link       = $Security->CheckWord($_POST['link']);
$desc       = $Security->CheckWord($_POST['desc']);
$credits   = $Security->CheckWord($_POST['credits']);

if (empty($link) ||  empty($desc) || empty($credits)) {
$error   = "Please Fill All Fields";
}
else {
$add_link   = $DB->Query("INSERT INTO DEW_votereward (votelink,votedesc,give_credits) VALUES ('".$link."','".$desc."','".$credits."')");
$success   = 'Link successfully added.';
}
}
if($Web_URL[2] == 'Delete') {
$id = $Web_URL[3];
if(!$id) {
$error   = 'Vote Id Doesnt Exist';
}
else {
$delete_link    = $DB->Query("DELETE FROM DEW_votereward WHERE id = '$id'");
$success      = 'Link sucessfully deleted.';
}
}
echo   DEW_Message('error',$error);
echo   DEW_Message('ok',$success);

?>

<div style="border:1px dashed #40576a; padding:5px;">
<form method="POST" action="">
<table align="center">
<tr>
<td><div align="right"><b>Vote Link:</b> </div></td>
<td><div align="left"><input type="text" name="link" type="text" size="12" class="text-form"></div></td>
</tr>
<tr>
<td><div align="right"><b>Vote Image:</b> </div></td>
<td><div align="left"><input type="text" name="desc" type="text" size="12" class="text-form"></div></td>
</tr>
<tr>
<td valign="top"><div align="right"><b>Credits For Vote:</b> </div></td>
<td><div align="left"><input type="text" name="credits" type="text" size="12" class="text-form"></div>
</td>
</tr>
</table>
<table align="center">
<tr>
<td><input name="add_link" type="hidden"><input type="Submit" name="Submit" class="submit-form" value="Add Link"></td>
</tr>
</table>
</form>
</div>
<br>

<table class="tdef">
<thead>
<tr>
<td align="center" class="title"><b>#</b></td>
<td align="center" class="title"><b>Image</b></td>
<td align="center" class="title"><b>Link</b></td>
<td align="center" class="title"><b>Credits</b></td>
<td align="center" class="title"><b>DELETE</b></td>
</tr>
</thead>
<tbody>

<?php

$get_vote = $DB->Query("SELECT * FROM DEW_votereward");
while($row = $DB->FetchArray($get_vote)) {
++$count;

echo "
<tr>
<td align="center" width="20"><B>".$count."</B></td>
<td align="center"><img src='".$row[2]."' alt='' width='66'></td>
<td align="center">".$row[1]."</td>
<td align="center">".$row[3]."</td>
<td align="center" width="55"><a href="".$URL_class->DEW_Crypt('AdminPanel/Vote/Delete/'.$row[0])."" title="Delete Link"><img src="Images/Misc/delete.png" border="0"></a></td>
</tr>";
}
echo "</tbody></table>";

}
}

/*#########################   ADD IMPERIALS MODULE START   #########################*/

if ($gmpanel_e == 'true') {
if($Web_URL[1] == $Imperials['name']) {
if(isset($_POST['add_credits'])) {
$accountname   = $Security->CheckWord($_POST['acc']);
$credits       = $Security->CheckWord($_POST['cred_add']);
$DB->Query("
UPDATE dbo.MEMB_CREDITS SET Credits = Credits + '$credits' WHERE memb___id='$accountname';
INSERT INTO credits_log (memb___id,credits) VALUES ('$accountname','$credits')");
$credmsgok   = $Imperials['name']." added!";
}
DEW_Message('ok',$credmsgok);

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>ADD <?php echo $Imperials['name'];?>!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>Account:</b></td>
<td><input type="text" class="text-form" size="10" maxlength="10" name="acc" value=""></td>
</tr>
<tr>
<td class="text_default"><b><?php echo $Imperials['name'];?>:</b></td>
<td><input name="cred_add" type="text" id="cred_add" size="10" maxlength="10"></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="add_credits" value="Add <?php echo $Imperials['name'];?>!"></td>
</tr>
</table>
</form>
</div>
</div>

<?

}
}

/*#########################   ADD CURRENCY MODULE START   #########################*/

if ($gmpanel_f == 'true') {
if($Web_URL[1] == 'Currency') {
if(isset($_POST['add_credits'])) {
$accountname   = $Security->CheckWord($_POST['acc']);
$credits      = $Security->CheckWord($_POST['cred_add']);

if ($Extra['reedlan'] == 1) {
$cash_   = $DB->FetchRow($DB->Query("SELECT memb_guid FROM MEMB_INFO WHERE memb___id = '".$accountname."'"));
$DB->Query("UPDATE MuCashShop_DATA SET CashPoint = CashPoint + '".$credits."' WHERE memb_guid = '".$cash_[0]."'");
}
else {
$DB->Query("UPDATE ".$Currency['table']." SET ".$Currency['column']." = ".$Currency[column]." + '".$credits."'WHERE ".$Currency[player]." = '".$accountname."'");
}
$credmsgok      = ''.$Currency['name'].' added!';
}
DEW_Message('ok',$credmsgok);

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="post" action="">
<table><tr><td class="title"><b>ADD <? echo $Currency['name'] ?>!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b>Account:</b></td>
<td><input type="text" class="text-form" size="10" maxlength="10" name="acc" value=""></td>
</tr>
<tr>
<td class="text_default"><b><? echo $Currency['name'] ?>:</b></td>
<td><input name="cred_add" type="text" id="cred_add" size="10" maxlength="10"></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" name="add_credits" value="Add <? echo $Currency['name'] ?>!"></td>
</tr>
</table>
</form>
</div>
</div>
<?

}
}

/*#########################   PAGE MANAGER MODULE START   #########################*/

if ($gmpanel_g == 'true') {
if($Web_URL[1] == 'Pages'){
if($_POST['pgedit']) {

$page_array_key = array_keys($_POST['pgedit']);
$page_array = explode(";",$page_array_key[0]);
$page_name = $page_array[1];
$page_edit_action = $page_array[0];

$page_found = 0;
$sub_page_db = file("./Includes/DEW_DB/Pages.DEW");

foreach($sub_page_db as $page_db_line) {
if(!eregi("#",$page_db_line)) {
$page_db = explode("|",$page_db_line);
if($page_db[0] == $page_name) {
$page_found = 1;
break;
}
}
}

if($page_found != 1 AND $page_name != 'n/a') { }
else {
switch($page_edit_action) {
case 0:
$new_enabled_or_disabled = 0;
$page_manager_msg = 'Module successfully disabled';
break;
case 1:
$new_enabled_or_disabled = 1;
$page_manager_msg = 'Module successfully enabled';
break;
case 2:
$delete_module = 1;
$page_manager_msg = 'Module successfully deleted';
break;
case 3:
$add_module = 1;
$do_not_edit = 1;
$page_manager_msg = 'Module successfully added';
break;
default:
die("ERROR");
break;
}

$sub_page_db = file("./Includes/DEW_DB/Pages.DEW");
$sub_page_db_new = fopen("Includes/DEW_DB/Pages.DEW", "w");

foreach($sub_page_db as $page_db_line) {
if(!eregi("#",$page_db_line)) {
$page_db = explode("|",$page_db_line);
if($page_db[0] == $page_name) {
if($do_not_edit == 1) { }
elseif($delete_module == 1) {
fwrite($sub_page_db_new,"");
}
else {
fwrite($sub_page_db_new,"$page_name|$page_db[1]|$new_enabled_or_disabled|n");
}
}
else {
fwrite($sub_page_db_new,"$page_db_line");
}
}
else {
fwrite($sub_page_db_new,"$page_db_line");
}
}

if($add_module == 1) {
$new_module_name = $_POST['new_module_name'];
$new_module_php_file = $_POST['new_module_php_file'];
fwrite($sub_page_db_new,"$new_module_name|$new_module_php_file|1|n");
}
fclose($sub_page_db_new);
echo   DEW_Message('ok',$page_manager_msg);
}
}

?>

<form method="post" action="">
<table class="tdef" width="100%">
<tr class="colhead" align=center>
<td class="title" align="center"><b>Page</b></td>
<td class="title" align="center"><b>Php File</b></td>
<td class="title" align="center"><b>Status</b></td>
<td colspan="2" class="title" align="center"><b>Control</b></td>
</tr>

<?php

$sub_page_db = file("./Includes/DEW_DB/Pages.DEW");

foreach($sub_page_db as $page_db_line) {
if(!eregi("#",$page_db_line)) {
$page_db = explode("|",$page_db_line);
switch($page_db[2]) {
case 0:
$page_status='<font color="red">Disabled</font>';
break;
case 1:
$page_status='<font color="green">Enabled</font>';
break;
}
echo "
<tr align=center>
<td>".$page_db[0]."</td>
<td>".$page_db[1]."</td>
<td>".$page_status."</td>
<td>";
if($page_db[2] == 0) {
echo "<input class="submit-form" style="color:red" name="pgedit[1;$page_db[0]]" value="Enable" type="submit">";
}
if($page_db[2] == 1) {
echo "<input class="submit-form" style="color:red" name="pgedit[0;$page_db[0]]" value="Disable" type="submit">";
}
echo "
</td>
<td><input class="submit-form" style="color:red" name="pgedit[2;$page_db[0]]" value="Delete" type="submit"></td>
</tr>";
}
}

?>

<tr align=center>
<td><input type="text" name="new_module_name" value="" type="submit" maxlength="15" size="10"></td>
<td><input type="text" name="new_module_php_file" value="" type="submit" maxlength="15" size="10"></td>
<td colspan="3"><input class="submit-form" style="color:red" name="pgedit[3;n/a]" value="Add Module" type="submit"></td>
</tr>
</table>
</form>

<?

}
}

/*#########################   FORUM MANAGER MODULE START   #########################*/

if ($gmpanel_h == 'true') {
if($Web_URL[1] == 'Forum'){
if ($_POST['edit_forum']) {
$forum_id = $Security->CheckWord($_POST['edit_forum']);
$forum_info = "SELECT * FROM [DEW_forum] where id = '".$forum_id."'";
$forum_info = $DB->Query($forum_info);
$forum_info = $DB->FetchArray($forum_info);

if ($_POST['edit_f_s']) {
$new_forum_name = $_POST['forum_name'];
$is_announce = $_POST['is_announce'];

switch ($is_announce) {
case 'yes':
$is_announce = 1;
break;
case 'no':
$is_announce = 0;
break;
}

$update_forum = $DB->Query("UPDATE DEW_forum set forum_name = '$new_forum_name',is_announce='$is_announce' where id = '$forum_id'");

header( 'Location: ./'.$URL_class->DEW_Crypt('AdminPanel/Forum') );
}

switch ($forum_info['is_announce']) {
case 1:
$announce = "yes";
$announce_l = phrase_forum_yes_l;
break;
case 0:
$announce = "no";
$announce_l = phrase_forum_no_l;
break;
}

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:250px;">
<form method="post" action="">
<table><tr><td class="title"><b>TOPIC EDIT!</b></td></tr></table>
<table>
<tr>
<td class="text_default" align="right"><b><?php echo phrase_forum_id;?>:</b></td>
<td class="text_default"><?php echo $forum_id;?></td>
</tr>
<tr>
<td align="right" class="text_default"><b><?php echo phrase_forum_name;?>:</b></td>
<td><input name="forum_name" type="text" class="text-form" size="15" maxLength="15" value = "<?php echo $forum_info['forum_name'];?>"></td>
</tr>
<tr>
<td align="right" class="text_default"><b><?php echo phrase_forum_is_announce;?>:</b></td>
<td>
<script type="text/javascript">
var is_announce = new selectInput("is_announce", "is_announce", "<?php echo $announce_l;?>", "<?php echo $announce;?>", "", "114");
is_announce.add("<?php echo phrase_forum_no_l;?>", "no");
is_announce.add("<?php echo phrase_forum_yes_l;?>", "yes");
is_announce.construct();
</script>
</td>
</tr>
<tr>
<td align="center" colspan="2" class="text_default">
<input type="hidden" name="edit_f_s" value="1">
<input type="hidden" name="edit_forum" value="<?php echo $forum_id;?>">
<input type="submit" class="submit-form" value="<?php echo phrase_forum_edit;?>">
</td>
</tr>
</table>
</form>
</div>
</div>

<?

}

else {

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:300px;">
<form method="POST" action="">
<table><tr><td class="title"><b>FORUM MANAGER!</b></td></tr></table>
<table>
<tr>
<td class="text_default"><b><?php echo phrase_forum_id;?>:</b></td>
<td><input type="text" class="text-form" size="5" maxlength="2" name="edit_forum" value=""></td>
</tr>
</table>
<table align="center">
<tr>
<td><input type="submit" class="submit-form" value="Forum <?php echo phrase_forum_edit;?>!"></td>
</tr>
</table>
</form>
</div>
</div>

<?

}
}
}

/*#########################   MARKET MANAGER MODULE START   #########################*/

if ($gmpanel_i == 'true') {
if($Web_URL[1] == 'Market') {
include_once   "Includes/Warehouse.php";
if($Web_URL[2] == 'Edit') {
$serial = $Security->CheckWord($Web_URL[3]);
if (strlen($serial)!=8) {
$errormsg="Wrong Item!";
}
if ($serial == '00000000') {
$errormsg="Wrong Item!";
}

if(isset($_POST['edit_item_s'])) {
$item_serial = $_POST['item_serial'];
$is_change_end_date = $_POST['change_end_date'];
$is_set_spec_offer = $_POST['is_spec_offer'];
$set_new_price = $_POST['price'];
$set_new_pay_type = $_POST['price_type'];
$is_delete_this_item = $_POST['delete_item'];

$m_item_info= $DB->Query("SELECT * from [DEW_market] where [serial] = '".$serial."'");
$m_item_info=$DB->FetchArray($m_item_info);

switch($is_change_end_date) {
case 'not':
$add_term = 0;
break;
case '1':
$add_term=3600 * 24;
break;
case '3':
$add_term=3600 * 24 * 3;
break;
case '5':
$add_term=3600 * 24 * 5;
break;
case '7':
$add_term=3600 * 24 * 7;
break;
case '14':
$add_term=3600 * 24 * 14;
break;
case '30':
$add_term=3600 * 24 * 30;
break;
}

$new_end_date =$m_item_info['end_date'] + $add_term;

switch($is_set_spec_offer) {
case 'no':
$new_spec_offer='0';
break;
case 'yes':
$new_spec_offer='1';
break;
}

switch($is_delete_this_item) {
case 'no':
$update_DEW_market = "UPDATE [DEW_market] set [price] = '$set_new_price',[pay_type] = '$set_new_pay_type',[end_date] = '$new_end_date',[is_spec_offer] = '$new_spec_offer' where [serial] = '$item_serial'";
$update_DEW_market_history = "UPDATE [DEW_market_history] set [price] = '$set_new_price',[pay_type] = '$set_new_pay_type',[end_date] = '$new_end_date' where [serial] = '$item_serial'";
break;
case 'yes':
$update_DEW_market = "DELETE [DEW_market] where [serial] = '$item_serial'";
$update_DEW_market_history = "DELETE [DEW_market_history] where [serial] = '$item_serial'";
break;
}

$do_update_DEW_makret=$DB->Query($update_DEW_market);
$do_update_DEW_market_history=$DB->Query($update_DEW_market_history);

echo   DEW_Message('ok',"Item Info Updated");
}

$sqll= $DB->Query("SELECT item from [DEW_market] where [serial] = '".$serial."'");
$sqll=$DB->FetchArray($sqll);
$sqll=$sqll['item'];

if(!$sqll) {
$errormsg="Item Not Found!";
}

$i = -1;
while($i<119) {
$i++;
$item    = ItemInfo($sqll);
if($item['sn'] == $Web_URL[3]) {
$item_code= substr($sqll,(32*$i), 32);
$i=150;
$item_sn=$item['sn'];
}
}

$secure_img_url = "Secure-Image-".md5(substr(str_shuffle($alphanum), 0, 5)).".jpg";

$market_item_info= $DB->Query("SELECT * from [DEW_market] where [serial] = '".$serial."'");
$market_item_info=$DB->FetchArray($market_item_info);

if(!$errormsg) {
switch ($market_item_info['pay_type']) {
case 'zen':
$market_item_info['pay_type_l']='ZEN';
break;
case $Imperials[name]:
$market_item_info['pay_type_l']=$Imperials[name];
break;
case $Currency[name]:
$market_item_info['pay_type_l']= $Currency[name];
break;
}

$market_item_info['end_date']=date($Time['format'], $market_item_info['end_date']);
$tax="1.".$Market['tax_percent']."";

$market_item_info['price_with_tax'] = $market_item_info['price'] * $tax;
$market_item_info['price_with_tax'] = round($market_item_info['price_with_tax']);

switch($market_item_info['is_spec_offer']) {
case 0:
$market_item_info['is_spec_offer']='no';
$market_item_info['is_spec_offer_l']='NO';
break;
case 1:
$market_item_info['is_spec_offer']='yes';
$market_item_info['is_spec_offer_l']='YES';
break;
}

$sockets = '';
if($item['sockets']) {
$sockets = '<br><br><font color=#FF19FF>Socket item option info</font>';
foreach($item['sockets'] as $v) {
if($v) $sockets.='<br><font color=#60A0FF>'.$v.'</font>';
}
}

if($item['exl']) {
$item['exl']='<br><font color=#8CB0EA>'.str_replace('^^','<br>', $item['exl']).'</font>';
}

if ($item['opt']) {
$item['opt']='<br><font color=#9aadd5>'.$item['opt'].'</font>';
}

if ($item['luck']) {
$item['luck']='<br><font color=#9aadd5>'.$item['luck'].'</font>';
}

if ($item['skill']) {
$item['skill']='<br><font color=#9aadd5>'.$item['skill'].'</font>';
}

if($item['level']) {
$item['level']=" +".$item['level'];
}
else {
$item['level']=NULL;
}

if(!$item['level']) {
if($item['opt']) {
$item['level']="";
}
}

$edit_cont = "<div style=color:".$item['color'].";><b>".$item['name'].$item['level']."</b></div><br>Durability: [".$item['dur']."/255]".$item['skill'].$item['luck'].$item['exl'].$item['opt'].$sockets.$item['ref'].$item['Harmony']."";

?>

<div align="center">
<div style="border:1px dashed #40576a; padding:5px; width:320px;">
<form method="post" action="">
<table border="0" cellspacing="0" cellpadding="3" width="300" align="center">
<tr>
<td align="center" colspan="2">
<img src="<?php echo $item['thumb'];?>"><br><br>
<a onmouseover="Tip('<? echo $edit_cont; ?>');" onmouseout="UnTip();"><span style=color:<?php echo $item['color']; ?>;>&nbsp;<?php echo $item['name'].$item['level']; ?>&nbsp;</span></a><br><br>
</td>
</tr>
<tr>
<td align="right"><b>End Date:</b></td>
<td><?php print $market_item_info['end_date'];?></td>
</tr>
<tr>
<td align="right"><b>Change End Date:</b></td>
<td><script type="text/javascript">var mtispd = new selectInput("mtispd", "change_end_date", "Dont Change", "not", "", "114");mtispd.add("Dont Change", "not");mtispd.add("+1 day", "1");mtispd.add("+3 days", "3");mtispd.add("+5 days", "5");mtispd.add("+7 days", "7");mtispd.add("+14 days", "14");mtispd.add("+30 days", "30");mtispd.construct();</script></td>
</tr>
<tr>
<td align="right"><b>Is Special Offer:</b></td>
<td><script type="text/javascript">var mtisspecoffer = new selectInput("mtisspecoffer", "is_spec_offer", "<?php print $market_item_info['is_spec_offer_l'];?>", "<?php print $market_item_info['is_spec_offer'];?>", "", "114");mtisspecoffer.add("NO", "no");mtisspecoffer.add("YES", "yes");mtisspecoffer.construct();</script></td>
</tr>
<tr>
<td align="right"><b>Price:</b></td>
<td>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><input name="price" type="text" class="text-form" size="19" maxLength="11" value="<?php print $market_item_info['price'];?>" onchange="mt_nalog(this.value);" onkeyup="mt_nalog(this.value);"></td>
<td><img width="2" src="index/spacer.gif"></td>
<td><script type="text/javascript">var mtispt = new selectInput("mtispt", "price_type", "<?php print $market_item_info['pay_type_l'];?>", "<?php print $market_item_info['pay_type'];?>", "", "70");mtispt.add("ZEN", "zen");<? if($Imperials['enable'] == 1) { ?>mtispt.add("<? echo $Imperials['name'];?>", "<? echo $Imperials['name'];?>");<? } if($Currency['enable'] == 1) { ?>mtispt.add("<? echo $Currency['name'];?>", "<? echo $Currency['name'];?>");<? } ?>mtispt.construct();</script></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="right"><b>DELETE ITEM:</b></td>
<td><script type="text/javascript">var delete_item = new selectInput("delete_item", "delete_item", "NO", "no", "", "114");delete_item.add("NO", "no");delete_item.add("YES", "yes");delete_item.construct();</script></td>
</tr>
<tr>
<td align="center" colspan="2">
<input type="hidden" name="edit_item_s" value="1">
<input type="hidden" name="item_serial" value="<?php print $serial;?>">
<input type="submit" class="submit-form" value="Edit Item!">
</td>
</tr>
</table>
</form>
</div>
</div>

<?
}

else {
echo   DEW_Message('error',$errormsg);
}
}
}
}

/*#########################   MARRY MANAGER MODULE START   #########################*/

if ($gmpanel_j == 'true') {
if($Web_URL[1] == 'Marry'){
if($_POST['marryedit']) {

$marry_array_key = array_keys($_POST['marryedit']);
$marry_array = explode(";",$marry_array_key[0]);
$marry_name = $marry_array[1];
$marry_edit_action = $marry_array[0];

$marry_found = 0;
$sub_marry_db = file("./Includes/DEW_DB/Marry.DEW");

foreach($sub_marry_db as $marry_db_line) {
if(!eregi("#",$marry_db_line)) {
$marry_db = explode("|",$marry_db_line);
if($marry_db[0] == $marry_name) {
$marry_found = 1;
break;
}
}
}

if($marry_found != 1 AND $marry_name != 'n/a') { }
else {
switch($marry_edit_action) {
case 0:
$new_enabled_or_disabled = 0;
$marry_manager_msg = 'Successfully divorced!';
break;
case 1:
$new_enabled_or_disabled = 1;
$marry_manager_msg = 'Successfully maried!';
break;
case 2:
$delete_module = 1;
$marry_manager_msg = 'Successfully deleted!';
break;
case 3:
$add_module = 1;
$do_not_edit = 1;
$marry_manager_msg = 'Successfully added!';
break;
default:
die("ERROR");
break;
}

$sub_marry_db = file("./Includes/DEW_DB/Marry.DEW");
$sub_marry_db_new = fopen("Includes/DEW_DB/Marry.DEW", "w");

foreach($sub_marry_db as $marry_db_line) {
if(!eregi("#",$marry_db_line)) {
$marry_db = explode("|",$marry_db_line);
if($marry_db[0] == $marry_name) {
if($do_not_edit == 1) { }
elseif($delete_module == 1) {
fwrite($sub_marry_db_new,"");
}
else {
fwrite($sub_marry_db_new,"$marry_name|$marry_db[1]|$new_enabled_or_disabled|$marry_db[3]|n");
}
}
else {
fwrite($sub_marry_db_new,"$marry_db_line");
}
}
else {
fwrite($sub_marry_db_new,"$marry_db_line");
}
}

if($add_module == 1) {
$husband       = $Security->CheckWord($_POST['husband']);
$wife          = $Security->CheckWord($_POST['wife']);

$check_husband_exists   = $DB->NumRows($DB->Query("SELECT Name FROM Character WHERE Name = '".$husband."'"));
$check_wife_exists      = $DB->NumRows($DB->Query("SELECT Name FROM Character WHERE Name = '".$wife."'"));

if($check_husband_exists > 0 && $check_wife_exists > 0) {
if($Marry['forzen'] == 1) {
if ($Marry['purse'] == 1) {
$count_of_zen_h   = $DB->FetchRow($DB->Query("SELECT extMoney FROM warehouse WHERE accountid = '".$husband."'"));
$zen_price_h    = $count_of_zen_h[0]-$Marry['zenprice'];
$zen_price_hq    = "UPDATE dbo.Warehouse SET extMoney = '$zen_price_h' WHERE AccountId = '".$husband."'";
$count_of_zen_w   = $DB->FetchRow($DB->Query("SELECT extMoney FROM warehouse WHERE accountid = '".$wife."'"));
$zen_price_w   = $count_of_zen_w[0]-$Marry['zenprice'];
$zen_price_wq    = "UPDATE dbo.Warehouse SET extMoney = '$zen_price_w' WHERE AccountId = '".$wife."'";
}
if ($Marry['purse'] == 0) {
$count_of_zen_h   = $DB->FetchRow($DB->Query("SELECT Money FROM Character WHERE Name = '".$husband."'"));
$zen_price_h   = $count_of_zen_h[0]-$Marry['zenprice'];
$zen_price_hq    = "UPDATE dbo.Character SET Money = '$zen_price_h' WHERE Name = '".$husband."'";
$count_of_zen_w   = $DB->FetchRow($DB->Query("SELECT Money FROM Character WHERE Name = '".$wife."'"));
$zen_price_w   = $count_of_zen_w[0]-$Marry['zenprice'];
$zen_price_wq    = "UPDATE dbo.Character SET Money = '$zen_price_w' WHERE Name = '".$wife."'";
}
}
else {
$zen_price_hq       = '';
$zen_price_wq       = '';
}
if($Marry['forcur'] == 1) {
if ($Currency['ByCharOrAcc'] == 1) {
$accorchar_h   = "WHERE $Currency[player] = '".$husband."'";
$accorchar_w   = "WHERE $Currency[player] = '".$wife."'";
}
if ($Currency['ByCharOrAcc'] == 0) {
$accorchar_h   = "WHERE $Currency[player] = '".$husband."'";
$accorchar_w   = "WHERE $Currency[player] = '".$wife."'";
}
$count_of_cur_h   = $DB->FetchRow($DB->Query("SELECT $Currency[column] FROM $Currency$accorchar_h"));
$cur_price_h   = $count_of_cur_h[0]-$Marry['curprice'];
$cur_price_hq    = "UPDATE dbo.$CurrencySET $Currency[column] = '$cur_price_h' $accorchar_h";
$count_of_cur_w   = $DB->FetchRow($DB->Query("SELECT $Currency[column] FROM $Currency$accorchar_w"));
$cur_price_w   = $count_of_cur_w[0]-$Marry['curprice'];
$cur_price_wq    = "UPDATE dbo.$CurrencySET $Currency[column] = '$cur_price_w' $accorchar_w";
}
else {
$cur_price_hq    = '';
$cur_price_wq    = '';
}
if($Marry['forimp'] == 1) {
$count_of_imp_h   = $DB->FetchRow($DB->Query("SELECT Credits FROM MEMB_CREDITS WHERE memb___id = '".$husband."'"));
$imp_price_h   = $count_of_imp_h[0]-$Marry['impprice'];
$imp_price_hq    = "UPDATE dbo.MEMB_CREDITS SET Credits = '$imp_price_h' WHERE memb___id = '".$husband."'";
$count_of_imp_w   = $DB->FetchRow($DB->Query("SELECT Credits FROM MEMB_CREDITS WHERE memb___id = '".$wife."'"));
$imp_price_w   = $count_of_imp_w[0]-$Marry['impprice'];
$imp_price_wq    = "UPDATE dbo.MEMB_CREDITS SET Credits = '$imp_price_w' WHERE memb___id = '".$wife."'";
}
else {
$imp_price_hq   = '';
$imp_price_wq   = '';
}

if($zen_price_h < 0 || $cur_price_h < 0 || $imp_price_h < 0) {
$m_error   = DEW_Message('error',"Husband dont have enough money!");
}
elseif($zen_price_w < 0 || $cur_price_w < 0 || $imp_price_w < 0) {
$m_error   = DEW_Message('error',"Wife dont have enough money!");
}
elseif($husband == $wife) {
$m_error   = DEW_Message('error',"Husband = Wife?!");
}
elseif($husband == $marry_db[0] || $husband == $marry_db[1]) {
$m_error   = DEW_Message('error',"Husband already married!");
}
elseif($wife == $marry_db[0] || $wife == $marry_db[1]) {
$m_error   = DEW_Message('error',"Wife already married!");
}
else {
$DB->Query("
$zen_price_hq
$zen_price_wq
$cur_price_hq
$cur_price_wq
$imp_price_hq
$imp_price_wq
");
fwrite($sub_marry_db_new,"$husband|$wife|1|$Current_Time|n");
$m_error   = DEW_Message('ok',"Money ok! Married!");
}
}
else {
$m_error   = DEW_Message('error',"Husband or Wife dont exist!");
}
}
fclose($sub_marry_db_new);
if(!$m_error) {
echo   DEW_Message('ok',$marry_manager_msg);
}
else {
echo $m_error;
}
}
}

?>

<form method="post" action="">
<table border="0" width="100%" class="tdef">
<tr align="center">
<td>Husband</td>
<td>Wife</td>
<td>Status</td>
<td>Control</td>
<td>Delete</td>
</tr>

<?php

$sub_marry_db = file("./Includes/DEW_DB/Marry.DEW");

foreach($sub_marry_db as $marry_db_line) {
if(!eregi("#",$marry_db_line)) {
$marry_db = explode("|",$marry_db_line);
switch($marry_db[2]) {
case 0:
$marry_status='<font color="red">Divorced</font>';
break;
case 1:
$marry_status='<font color="green">Married</font>';
break;
}
echo "
<tr align=center>
<td>".$marry_db[0]."</td>
<td>".$marry_db[1]."</td>
<td>".$marry_status."</td>
<td>";
if($marry_db[2] == 0) {
echo "<input class="submit-form" style="color:red" name="marryedit[1;$marry_db[0]]" value="Marry" type="submit">";
}
if($marry_db[2] == 1) {
echo "<input class="submit-form" style="color:red" name="marryedit[0;$marry_db[0]]" value="Divorce" type="submit">";
}
echo "
</td>
<td><input class="submit-form" style="color:red" name="marryedit[2;$marry_db[0]]" value="Delete" type="submit"></td>
</tr>";
}
}

?>

<tr align="center">
<td><input type="text" name="husband" value="" type="submit" maxlength="15" size="10"></td>
<td><input type="text" name="wife" value="" type="submit" maxlength="15" size="10"></td>
<td colspan="3"><input class="submit-form" style="color:red" name="marryedit[3;n/a]" value="Add Marry" type="submit"></td>
</tr>
</table>
</form>

<?

}
}

/*#########################   DATABASE MANAGER MODULE START   #########################*/

if ($IsAdmin == 'true') {
if($Web_URL[1] == 'Database') {
echo   "<div align='center'>";
/* BACKUP DATABASE */
$BackUp['time']      = date("d.m.y");
$BackUp['location']   = "C:Backup_".$Sql['database']."_".$BackUp['time'].".bak";
if (isset($_POST['back_db'])) {
$DB->Query('BACKUP DATABASE ['.$Sql[database].'] TO DISK = N''.$BackUp['location'].'' WITH INIT, NOUNLOAD, NAME = N'MuOnline backup', NOSKIP, STATS = 10, NOFORMAT');
echo   DEW_Message('ok',$DB->GetLastMessage());
}
echo   "
<div style='border:1px dashed #40576a; padding:5px; width:300px;'>
<form method='post' action=''>
<table><tr><td class='title'><b>BACKUP DATABASE!</b></td></tr></table>
<table>
<tr>
<td align='center'>
<input type='hidden' name='back_db' value='1'>
<input type='submit' class='submit-form' value='Backup DataBase'>
</td>
</tr>
</table>
</form>
</div><br>";

/* QUERY ANALYZER */
if (isset($_POST['exe_query'])) {
$q_in   = $_POST['query_in'];
$exe_q   = $DB->Query($q_in);
if (!$exe_q)   echo   DEW_Message('error','Query Failed!<br>'.$DB->GetLastMessage());
else         echo   DEW_Message('ok','Query Executed!');
}
echo   "
<div style='border:1px dashed #40576a; padding:5px; width:300px;'>
<form method='post' action=''>
<table><tr><td class='title'><b>QUERY ANALYZER!</b></td></tr></table>
<table style='width:100%;'>
<tr>
<td align='center'>
<textarea name='query_in' style='width:98%;' rows='10'></textarea>
</td>
</tr>
<tr>
<td align='center'>
<input type='hidden' name='exe_query' value='1'>
<input type='submit' class='submit-form' value='Execute Query'>
</td>
</tr>
</table>
</form>
</div></div>";
}
}

/*#########################   ITEM MANAGER MODULE START   #########################*/

if ($IsAdmin == 'true') {
if($Web_URL[1] == 'Item') {
if(isset($_POST['gen'])) {
$type   = $_POST['itype'];
$id      = $_POST['iid'];
$level   = $_POST['ilevel'];
$opt   = $_POST['item_option'];
$dur   = $_POST['idur'];
$luck   = $_POST['luck'];
$skill   = $_POST['skill'];
$opt1   = $_POST['xl1'];
$opt2   = $_POST['xl2'];
$opt3   = $_POST['xl3'];
$opt4   = $_POST['xl4'];
$opt5   = $_POST['xl5'];
$opt6   = $_POST['xl6'];
$anc   = $_POST['anc'];
$log   = $_POST['log'];
GenerateAccItem($type,$id,$level,$opt,$dur,$luck,$skill,$opt1,$opt2,$opt3,$opt4,$opt5,$opt6,$anc,$log);
}

?>

<form method="post" action="" name="generate_start">
<table align="center" border="0" cellpadding="2" cellspacing="2" style="border:1px solid #40576a; font-family:Tahoma; color:#9d8666; font-size:11px;">
<tr class="bgcol1">
<td class="text_default" align="right" width="25%"><b>Type:</b></td>
<td width="25%"><input type="text" size="3" name="itype"></td>
<td class="text_default" align="right" width="25%"><b>ID:</b></td>
<td width="25%"><input type="text" size="3" name="iid"></td>
</tr>
<tr>
<td class="text_default" align="right" width="25%"><b>Level(0-13):</b></td>
<td width="25%"><input type="text" size="3" name="ilevel" value="0"></td>
<td class="text_default" align="right" width="25%"><b>Option(0-7):</b></td>
<td width="25%"><input type="text" size="3" name="item_option" value="0"></td>
</tr>
<tr class="bgcol1">
<td class="text_default" align="right" width="25%"><b>Durabilty(0-255):</b></td>
<td width="25%"><input maxlength="3" type="text" size="3" name="idur" value="255"></td>
<td class="text_default" align="right" width="25%"><b>Ancient <font color="darkred">*</font>:</b></td>
<td width="25%"><select name="anc"><option value="0">No</option><option value="4">+5</option><option value="9">+10</option></select></td>
</tr>
<tr>
<td class="text_default" align="right" width="25%"><b>Luck:</b></td>
<td width="25%"><select name="luck"><option value="0">No</option><option value="1">Yes</option></select></td>
<td class="text_default" align="right" width="25%"><b>Skill:</b></td>
<td width="25%"><select name="skill"><option value="0">No</option><option value="1">Yes</option></select></td>
</tr>

<tr class="bgcol1">
<td colspan=4><input type="checkbox" name="xl1" value="1"> Increase Zen After Hunt +40% / Increase MP/kill +8 / Increase HP</td>
</tr>
<tr>
<td colspan=4><input type="checkbox" name="xl2" value="1"> Defense success rate +10% / Increase HP/kill +8 / Increase MP </td>
</tr>
<tr class="bgcol1">
<td colspan=4><input type="checkbox" name="xl3" value="1"> Reflect damage +5% / Increase attacking(wizardly)speed+7 / Ignore defense </td>
</tr>
<tr>
<td colspan=4><input type="checkbox" name="xl4" value="1"> Damage Decrease +4% / Increase wizardly damage +2% /  Increase Stamina</td>
</tr>
<tr class="bgcol1">
<td colspan=4><input type="checkbox" name="xl5" value="1"> Increase MaxMana +4% / Increase Damage +level/20 / Increase attack speed</td>
</tr>
<tr>
<td colspan=4><input type="checkbox" name="xl6" value="1"> Increase MaxHP +4% / Excellent Damage Rate +10%</td>
</tr>
<tr class="bgcol1">
<td colspan=2 width="50%" align="right"><b>Account login:</b></td>
<td colspan=2 width="50%"><input type="text" name="log" value="" maxlength='10' size='10'></td>
</tr>
<tr>
<td align=center colspan=4><font color="darkred">*</font> - <i>Если выбрана эта функция, то Exl. опций не будет!</i></td>
</tr>
</table>
<table align="center">
<tr>
<td>
<input type="hidden" name="gen" value="1">
<input type="button" class="submit-form" onclick="this.disabled=true; this.value='Loading...'; generate_start.submit();" value="Сгенерировать вещь">
</td>
</tr>
</table>
</form>

<?

}
}

/*###############################################################################
*/

}
else {
header( 'Location: ./'.$URL_class->DEW_Crypt('News') ) ;
}

/*   Deathless Engine Web © 2010   */

?>