PageRenderTime 70ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 1ms

/inc/admin/admin.accounts.php

https://bitbucket.org/wopkevries/blizzlike-313-website
PHP | 2203 lines | 2142 code | 59 blank | 2 comment | 68 complexity | 74915941a4d9746d00eeadc71adc97f8 MD5 | raw file
Possible License(s): LGPL-2.1 
    

  1. <?php
    2. 

  2. 

  3. if (INCLUDED!==true) { include('index.htm'); exit; }
    4. 

  4. 

  5. $USER_LEVEL[4]='Owner'; 
    6. 

  6. $usergmt=verifygmt($_SESSION['userid']);
    7. 

  7. 

  8. switch ($_REQUEST['t']) {
    9. 

  9. 	case "ipban":
    10. 

  10. 

  11. 		if ($_REQUEST['ip']!='' AND $_REQUEST['a']=='remove') {
    12. 

  12. 			if (@mysql_query("DELETE FROM ip_banned WHERE ip = '".$_REQUEST['ip']."'")) {
    13. 

  13. 				goodborder('Successfuly Removed.'); echo '<br>';
    14. 

  14. 			} else {
    15. 

  15. 				errborder('Couldn\'t Remove IP.'); 
    16. 

  16. 			}
    17. 

  17. 		} else if ($_REQUEST['ip']!='' AND $_REQUEST['a']=='add') { 
    18. 

  18. 			if (($binIp = ip2long($_POST['ip'])) !== false) { 
    19. 

  19. 				
    20. 

  20. 				if ($_POST['banfors']>='0') { 
    21. 

  21. 					if (alphanum($_POST['banfori'],true,false)==false OR $_POST['banfori']=='' OR $_POST['banfori']=='0') { $_POST['banfori']='1'; }
    22. 

  22. 					$_POST['banfori'] = '(UNIX_TIMESTAMP(NOW()) + '.($_POST['banfori'] * $_POST['banfors']).')'; } 
    23. 

  23. 				else { $_POST['banfori']='-1'; }
    24. 

  24. 				if (@mysql_query("INSERT INTO `ip_banned`(ip, bandate, unbandate, bannedby, banreason) VALUES('".long2ip(ip2long($_POST['ip']))."', UNIX_TIMESTAMP(NOW()), ".$_POST['banfori'].",'".$_SESSION['userid']."','".$_POST['reason']."')")) { 
    25. 

  25. 					goodborder('Successfuly Added.'); 
    26. 

  26. 					echo '<br>'; 
    27. 

  27. 					unset($_POST['ip']); 
    28. 

  28. 				} else {
    29. 

  29. 					errborder('Couldn\'t Add IP.');
    30. 

  30. 				}
    31. 

  31. 			} else { 
    32. 

  32. 				errborder('Invalid IP.'); 
    33. 

  33. 			} 
    34. 

  34. 		}
    35. 

  35. 

  36. 		?>
    37. 

  37. <form name="siteadmin" method=post action="index.php?n=admin.accounts&t=ipban&a=add">
    38. 

  38. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    39. 

  39. 	<tr>
    40. 

  40. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    41. 

  41. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">Add IP to Ban List:</b></td>
    42. 

  42. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    43. 

  43. 	</tr>
    44. 

  44. 	</table>
    45. 

  45. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    46. 

  46. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    47. 

  47. 

  48. 

  49. 	<table border=0 cellspacing=0 cellpadding=4>
    50. 

  50. 	<tr>
    51. 

  51. 		  <td width=120 align=right>
    52. 

  52. 		  <font face="arial,helvetica" size=-1><span><b>
    53. 

  53. 		  IP:</span></b></font> </td>
    54. 

  54. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    55. 

  55. 		  <input type=text size=20 maxlength=15 name="ip">
    56. 

  56. 		  </td><td valign = "top">
    57. 

  57. 		   </td></tr></table></td>
    58. 

  58. 	</tr>
    59. 

  59. 	<tr>
    60. 

  60. 		  <td  align=right>
    61. 

  61. 		  <font face="arial,helvetica" size=-1><span><b>
    62. 

  62. 		 Ban For:</span></b></font> </td>
    63. 

  63. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    64. 

  64. 			<input name="banfori" type=text style="height:19px; width:20px;" maxlength=2 value="2">
    65. 

  65. 		  </td><td valign = "top" style="font-size: 13px;">
    66. 

  66. 		  <select name="banfors">
    67. 

  67. 			<option value="-1">Permanently
    68. 

  68. 			<option value="60">Minutes
    69. 

  69. 			<option value="3600">Hours
    70. 

  70. 			<option value="86400">Days
    71. 

  71. 			<option value="604888" SELECTED>Weeks
    72. 

  72. 			<option value="2592000">Months
    73. 

  73. 			<option value="31104000.25">Years
    74. 

  74. 		  </select>
    75. 

  75. 		   </td></tr></table></td>
    76. 

  76. 	</tr>
    77. 

  77. 	<tr>
    78. 

  78. 		  <td  align=right>
    79. 

  79. 		  <font face="arial,helvetica" size=-1><span><b>
    80. 

  80. 		  Reason:</span></b></font> </td>
    81. 

  81. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    82. 

  82. 		  <input type=text size=40 maxlength=50 name="reason">
    83. 

  83. 		  </td><td valign = "top">
    84. 

  84. 		   </td></tr></table></td>
    85. 

  85. 	</tr>
    86. 

  86. 	</table>
    87. 

  87. 	</td></tr></table>
    88. 

  88. 	</td></tr></table><br>
    89. 

  89. 		<div align=center>
    90. 

  90. 		<input type=image SRC="shared/wow-com/images/buttons/button-continue.gif">
    91. 

  91. 

  92. 		</div>
    93. 

  93. 		</form><br><br>
    94. 

  94. 		<div style='cursor: auto;' id='dataElement'>
    95. 

  95. 		<span>
    96. 

  96. 		<?php
    97. 

  97. 		subtitle('IP Banned:');
    98. 

  98. 

  99. 		$newquery = @mysql_query("SELECT *, fa.displayname as dn FROM `ip_banned` ib LEFT JOIN forum_accounts fa ON ib.bannedby = fa.id_account ORDER BY ip ASC") or die (mysql_error());
    100. 

  100. 

  101. 		if (@mysql_num_rows($newquery)>0) {
    102. 

  102. 

  103. 		metalborderup();
    104. 

  104. 		?>
    105. 

  105. 					<table cellpadding='3' cellspacing='0' width=420>
    106. 

  106. 						<tbody>
    107. 

  107. 						<tr>
    108. 

  108. 							<td class='rankingHeader' align='left' nowrap='nowrap'>IP</td>
    109. 

  109. 							<td class='rankingHeader' align='left' nowrap='nowrap'>Time</td>
    110. 

  110. 							<td class='rankingHeader' align='left' nowrap='nowrap'>By</td>
    111. 

  111. 							<td class='rankingHeader' align='left' nowrap='nowrap'>Reason</td>
    112. 

  112. 							<td class='rankingHeader' align='center' nowrap='nowrap'>&nbsp;</td>
    113. 

  113. 						</tr>
    114. 

  114. 						<tr>
    115. 

  115. 							<td colspan='8' background='shared/wow-com/images/borders/metalborder/shadow.gif' height=8>
    116. 

  116. 							</td>
    117. 

  117. 						</tr>
    118. 

  118. 		<?php 
    119. 

  119. 

  120. 		$res_color=2;
    121. 

  121. 		$i=0;
    122. 

  122. 		while($rowa = @mysql_fetch_array($newquery)) {
    123. 

  123. 			$i++;
    124. 

  124. 			if($res_color==1) { $res_color=2; } else { $res_color=1; }
    125. 

  125. 				
    126. 

  126. 			echo "<tr>
    127. 

  127. 				<td class='serverStatus".$res_color."' align='left'><span style='color: rgb(102, 13, 2);'>".$rowa['ip']."</td>
    128. 

  128. 				<td class='serverStatus".$res_color."' align='left'><span style='color: rgb(102, 13, 2);'>";
    129. 

  129. 			if ($rowa['unbandate']<0) { echo 'Permanently'; } else { echo 'Until '.date('d-m-Y \a\t h:i:s A', $rowa['unbandate']); }
    130. 

  130. 			echo "</td><td class='serverStatus".$res_color."' align='left'><span style='color: rgb(102, 13, 2);'>".$rowa['dn']."</td>
    131. 

  131. 				<td class='serverStatus".$res_color."' align='left'><span style='color: rgb(102, 13, 2);'>".$rowa['banreason']."&nbsp;</td>
    132. 

  132. 				<td class='serverStatus".$res_color."' align='center'><a onmouseover='ddrivetip(\"Remove\")' onmouseout='hideddrivetip()' href='index.php?n=admin.accounts&t=ipban&a=remove&ip=".$rowa['ip']."'><img src='new-hp/images/v2/remove.gif'></a></td>
    133. 

  133. 			</tr>";
    134. 

  134. 						
    135. 

  135. 		}
    136. 

  136. 		?>
    137. 

  137. 						</tbody>
    138. 

  138. 					</table>
    139. 

  139. 		<?php
    140. 

  140. 		metalborderdown();
    141. 

  141. 		?>
    142. 

  142. 		</span>
    143. 

  143. 		</div>
    144. 

  144. 		<?
    145. 

  145. 		} else {
    146. 

  146. 			goodborder('No IP Banned Exists.');
    147. 

  147. 		}
    148. 

  148. 	break;
    149. 

  149. 	case "settings":
    150. 

  150. 	
    151. 

  151. 			$forceshow=true;
    152. 

  152. 			
    153. 

  153. 			if ($_POST['update']=='settings1') {
    154. 

  154. 			
    155. 

  155. 				$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccreg']."' WHERE setting='user_reg_active'");
    156. 

  156. 				$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccregmail']."' WHERE setting='user_reg_mail'");
    157. 

  157. 			
    158. 

  158. 				if ($query) {
    159. 

  159. 								
    160. 

  160. 					goodborder($_LANG['SUCCESS']['ADMIN_SET']);
    161. 

  161. 					$forceshow=false;
    162. 

  162. 					
    163. 

  163. 				} else {		
    164. 

  164. 					$haserrors .= mysql_error();
    165. 

  165. 				}	
    166. 

  166. 			}
    167. 

  167. 			
    168. 

  168. 	if ($forceshow==true) {
    169. 

  169. 	
    170. 

  170. ?>
    171. 

  171. <form method=post action="index.php?n=admin.accounts&t=settings" name="siteadmin" onsubmit="fas_valid()">
    172. 

  172. <script language="javascript">
    173. 

  173. 

  174. function fas_valid() {
    175. 

  175. 	void(document.siteadmin.update.value="settings1");
    176. 

  176. 	return true;
    177. 

  177. }
    178. 

  178. </script>
    179. 

  179. 	<input type=hidden name="update">
    180. 

  180. <?php if ($haserrors!="") { errborder($haserrors) .'<br>';} ?>
    181. 

  181. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    182. 

  182. 	<tr>
    183. 

  183. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    184. 

  184. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">User Group Settings:</b></td>
    185. 

  185. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    186. 

  186. 	</tr>
    187. 

  187. 	</table>
    188. 

  188. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    189. 

  189. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    190. 

  190. 	<table border=0 cellspacing=0 cellpadding=4>
    191. 

  191. 	<tr>
    192. 

  192. 		  <td  align=right>
    193. 

  193. 		  <font face="arial,helvetica" size=-1><span><b>
    194. 

  194. 		  Account Registrations:<br>
    195. 

  195. 		  </span></b></font>
    196. 

  196. 		  </td>
    197. 

  197. 		  <td 70% align=left>
    198. 

  198. 		  <table border=0 cellspacing=0 cellpadding=0>
    199. 

  199. 			<tr>
    200. 

  200. 				<td><select name="waccreg"><option value="1">Enabled<option value="0">Disabled</select></td>
    201. 

  201. 			</tr>
    202. 

  202. 		  </table>
    203. 

  203. <script>void(document.siteadmin.waccreg.value='<?php echo $SETTING['USER_REG_ACTIVE']; ?>')</script>
    204. 

  204. 		  </td>
    205. 

  205. 	</tr>
    206. 

  206. 	<tr>
    207. 

  207. 		  <td align=right>
    208. 

  208. 		  <font face="arial,helvetica" size=-1><span><b>
    209. 

  209. 		  Account E-Mail Activation:<br>
    210. 

  210. 		  </span></b></font>
    211. 

  211. 		  </td>
    212. 

  212. 		  <td 70% align=left>
    213. 

  213. 		  <table border=0 cellspacing=0 cellpadding=0>
    214. 

  214. 			<tr>
    215. 

  215. 				<td><select name="waccregmail"><optgroup label="Requires?"><option value="1">Yes<option value="0">No</select></td>
    216. 

  216. 			</tr>
    217. 

  217. 		  </table>
    218. 

  218. <script>void(document.siteadmin.waccregmail.value='<?php echo $SETTING['USER_REG_MAIL']; ?>')</script>
    219. 

  219. 		  </td>
    220. 

  220. 	</tr>
    221. 

  221. 	</table>
    222. 

  222. 	</td></tr></table>
    223. 

  223. 	</td></tr></table><br>
    224. 

  224. 		
    225. 

  225. 		<div align=center><input type=image SRC="shared/wow-com/images/buttons/update-button.gif" name="Submit" alt="Update" Width="174" Height="46" Border=0 class="button"  taborder=7 ></div>
    226. 

  226. 

  227. </form>
    228. 

  228. <?php
    229. 

  229. }
    230. 

  230. 	break;
    231. 

  231. 	case "priviledges":
    232. 

  232. 

  233. ?>
    234. 

  234. 			<?php
    235. 

  235. 

  236. 			$forceshow=true;
    237. 

  237. 			
    238. 

  238. 			if ($_POST['update']=='settings') {
    239. 

  239. 			
    240. 

  240. 				$langerrgreed = "You're not allowed to change the Setting %ACCPRIVSET%!<br>";
    241. 

  241. 				if ($SETTING['DB_BACKUP']>$userlevel AND $_POST['wdbback']<$SETTING['DB_BACKUP']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Database: Backup', $langerrgreed); }
    242. 

  242. 				if ($SETTING['DB_RESTORE']>$userlevel AND $_POST['wdbrest']<$SETTING['DB_RESTORE']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Database: Restore', $langerrgreed); }
    243. 

  243. 				
    244. 

  244. 				if ($SETTING['USER_WEB']>$userlevel AND $_POST['waccweb']<$SETTING['USER_WEB']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Website: Manage Settings/Layout', $langerrgreed); }
    245. 

  245. 				if ($SETTING['USER_MISC']>$userlevel AND $_POST['waccmisc']<$SETTING['USER_MISC']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Website: Manage Miscellaneous', $langerrgreed); }
    246. 

  246. 				if ($SETTING['USER_DONATIONS']>$userlevel AND $_POST['waccdonate']<$SETTING['USER_DONATIONS']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Website: Manage Donations', $langerrgreed); }
    247. 

  247. 				if ($SETTING['USER_EMAIL']>$userlevel AND $_POST['waccemail']<$SETTING['USER_EMAIL']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Website:  Manage E-mail Settings', $langerrgreed); }
    248. 

  248. 				
    249. 

  249. 				if ($SETTING['UER_FORUMS']>$userlevel AND $_POST['waccforum']<$SETTING['UER_FORUMS']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Forum: Manage Forums', $langerrgreed); }
    250. 

  250. 				if ($SETTING['USER_POLL']>$userlevel AND $_POST['wuserpoll']<$SETTING['USER_POLL']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Forum: Start New Polls', $langerrgreed); }
    251. 

  251. 				if ($SETTING['USER_ENABLE_SIGNATURE']>$userlevel AND $_POST['wenableusersig']<$SETTING['USER_ENABLE_SIGNATURE']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Forum: Enable Signature', $langerrgreed); }
    252. 

  252. 				
    253. 

  253. 				if ($SETTING['USER_ACCOUNTS']>$userlevel AND $_POST['waccacc']<$SETTING['USER_ACCOUNTS']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Account: Manage Accounts', $langerrgreed); }
    254. 

  254. 				if ($SETTING['USER_ENABLE_PM']>$userlevel AND $_POST['wenablepmsend']<$SETTING['USER_ENABLE_PM']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Account: Enable E-mail Sending', $langerrgreed); }
    255. 

  255. 				if ($SETTING['USER_ENABLE_EMAIL']>$userlevel AND $_POST['wenablemailsend']<$SETTING['USER_ENABLE_EMAIL']) { $haserrors.=str_replace('%ACCPRIVSET%', 'Account: Enable Private Messages Sending', $langerrgreed); }
    256. 

  256. 				
    257. 

  257. 				if ($_POST['wserverown']=='' AND $_SESSION['userid']==$SETTING['SERVER_OWNER']) {
    258. 

  258. 					$haserrors="The Server Owner field cannot be empty.";
    259. 

  259. 				} else if ($_SESSION['userid']!=$SETTING['SERVER_OWNER']) {
    260. 

  260. 					$_POST['wserverown'] = $SETTING['SERVER_OWNER'];
    261. 

  261. 				} else {
    262. 

  262. 					$newquery = "SELECT id, gmlevel FROM account a WHERE LOWER(username)=LOWER('".$_POST['wserverown']."')";
    263. 

  263. 					$newquery = mysql_query($newquery) OR DIE (mysql_error());	
    264. 

  264. 					if (mysql_num_rows($newquery)==1) {
    265. 

  265. 						$newquery = mysql_fetch_array($newquery);
    266. 

  266. 						if ($newquery['gmlevel']<'3') {
    267. 

  267. 							$haserrors="To become an Owner the Account Name Priviledge must be first an Administrator.";
    268. 

  268. 						} else {
    269. 

  269. 							$_POST['wserverown'] = $newquery['id'];
    270. 

  270. 						}
    271. 

  271. 					} else {
    272. 

  272. 						$haserrors="Invalid Account Name.";
    273. 

  273. 					}
    274. 

  274. 				}
    275. 

  275. 					
    276. 

  276. 				if ($haserrors=="") { 
    277. 

  277. 				
    278. 

  278. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['wserverown']."' WHERE setting='server_owner'");
    279. 

  279. 		
    280. 

  280. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['wdbback']."' WHERE setting='db_backup'");
    281. 

  281. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['wdbrest']."' WHERE setting='db_restore'");
    282. 

  282. 		
    283. 

  283. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccweb']."' WHERE setting='user_web'");
    284. 

  284. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccmisc']."' WHERE setting='user_misc'");
    285. 

  285. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccdonate']."' WHERE setting='user_donations'");
    286. 

  286. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccemail']."' WHERE setting='user_email'");
    287. 

  287. 					
    288. 

  288. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccforum']."' WHERE setting='user_forums'");
    289. 

  289. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['wuserpoll']."' WHERE setting='user_poll'");
    290. 

  290. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['wenableusersig']."' WHERE setting='user_enable_signature'");
    291. 

  291. 					
    292. 

  292. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['waccacc']."' WHERE setting='user_accounts'");
    293. 

  293. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['wenablepmsend']."' WHERE setting='user_enable_pm'");
    294. 

  294. 					$query=mysql_query("UPDATE web_settings SET value='".$_POST['wenablemailsend']."' WHERE setting='user_enable_email'");
    295. 

  295. 					
    296. 

  296. 					if ($query) {
    297. 

  297. 									
    298. 

  298. 						goodborder($_LANG['SUCCESS']['ADMIN_SET']);
    299. 

  299. 						$forceshow=false;
    300. 

  300. 						
    301. 

  301. 					} else {		
    302. 

  302. 						$haserrors .= mysql_error();
    303. 

  303. 					}
    304. 

  304. 				}
    305. 

  305. 				
    306. 

  306. 			}
    307. 

  307. 			
    308. 

  308. 	if ($forceshow==true) {
    309. 

  309. 	
    310. 

  310. 			?>
    311. 

  311. <form method=post action="index.php?n=admin.accounts&t=priviledges" name="siteadmin" onsubmit="fas_valid()">
    312. 

  312. <script language="javascript">
    313. 

  313. 

  314. function fas_valid() {
    315. 

  315. 	void(document.siteadmin.update.value="settings");
    316. 

  316. 	return true;
    317. 

  317. }
    318. 

  318. </script>
    319. 

  319. 	<input type=hidden name="update">
    320. 

  320. <?php if ($haserrors!="") { errborder($haserrors) .'<br>';} ?>
    321. 

  321. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    322. 

  322. 	<tr>
    323. 

  323. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    324. 

  324. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">User Group Priviledges:</b></td>
    325. 

  325. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    326. 

  326. 	</tr>
    327. 

  327. 	</table>
    328. 

  328. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    329. 

  329. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    330. 

  330. 	<table border=0 cellspacing=0 cellpadding=4>
    331. 

  331. 	<tr>
    332. 

  332. 		  <td width=250 align=right>
    333. 

  333. 		  <font face="arial,helvetica" size=-1><span><b>
    334. 

  334. 		  Server Owner (Account Name):  </span></b></font> </td>
    335. 

  335. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    336. 

  336. 		  <input <? if ($userlevel!=4) { echo 'readonly'; } ?> type=text name="wserverown" value="">
    337. 

  337. 		  </td><td valign = "top">
    338. 

  338. 		   </td></tr></table></td>
    339. 

  339. 	</tr>
    340. 

  340. 	</table>
    341. 

  341. 	</td></tr></table>
    342. 

  342. 	</td></tr></table><br>
    343. 

  343. 

  344. <?php
    345. 

  345. 

  346. function setminmaxlvl($sett=1, $start=1) {
    347. 

  347. 	if ($GLOBALS['userlevel']<$sett) { 
    348. 

  348. 		echo '<option value='.$sett.'>'.$GLOBALS['USER_LEVEL'][$sett];
    349. 

  349. 	} else {
    350. 

  350. 		for ($i=$start;$i<=$GLOBALS['userlevel'];$i++) {
    351. 

  351. 			echo '<option value='.$i.'>'.$GLOBALS['USER_LEVEL'][$i];
    352. 

  352. 		}
    353. 

  353. 	}
    354. 

  354. }
    355. 

  355. 

  356. ?>
    357. 

  357. 	
    358. 

  358. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    359. 

  359. 	<tr>
    360. 

  360. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    361. 

  361. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">Database:</b></td>
    362. 

  362. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    363. 

  363. 	</tr>
    364. 

  364. 	</table>
    365. 

  365. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    366. 

  366. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    367. 

  367. 	<table border=0 cellspacing=0 cellpadding=4>
    368. 

  368. 	<tr>
    369. 

  369. 		  <td width=250 align=right>
    370. 

  370. 		  <font face="arial,helvetica" size=-1><span><b>
    371. 

  371. 		  Backup:  </span></b></font> </td>
    372. 

  372. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    373. 

  373. 		  <select name="wdbback">
    374. 

  374. 		  <?
    375. 

  375. 		    setminmaxlvl($SETTING['DB_BACKUP']);
    376. 

  376. 		  ?>
    377. 

  377. 		  </select>
    378. 

  378. 		  </td><td valign = "top">
    379. 

  379. 		   </td></tr></table></td>
    380. 

  380. 	</tr>
    381. 

  381. 	<tr>
    382. 

  382. 		  <td  align=right>
    383. 

  383. 		  <font face="arial,helvetica" size=-1><span><b>
    384. 

  384. 		  Restore:  </span></b></font> </td>
    385. 

  385. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    386. 

  386. 		  <select name="wdbrest">
    387. 

  387. 			<?
    388. 

  388. 			setminmaxlvl($SETTING['DB_RESTORE']);
    389. 

  389. 		  ?>
    390. 

  390. 		  </select>
    391. 

  391. 		  </td><td valign = "top">
    392. 

  392. 		   </td></tr></table></td>
    393. 

  393. 	</tr>
    394. 

  394. 	</table>
    395. 

  395. 	</td></tr></table>
    396. 

  396. 	</td></tr></table><br>
    397. 

  397. 		
    398. 

  398. 

  399. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    400. 

  400. 	<tr>
    401. 

  401. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    402. 

  402. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">Website:</b></td>
    403. 

  403. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    404. 

  404. 	</tr>
    405. 

  405. 	</table>
    406. 

  406. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    407. 

  407. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    408. 

  408. 	<table border=0 cellspacing=0 cellpadding=4>
    409. 

  409. 	<tr>
    410. 

  410. 		  <td width=250 align=right>
    411. 

  411. 		  <font face="arial,helvetica" size=-1><span><b>
    412. 

  412. 		  Manage Website Settings/Layout:  </span></b></font> </td>
    413. 

  413. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    414. 

  414. 		  <select name="waccweb">
    415. 

  415. 		  <?
    416. 

  416. 			setminmaxlvl($SETTING['USER_WEB']);
    417. 

  417. 		  ?>
    418. 

  418. 		  </select>
    419. 

  419. 		  </td><td valign = "top">
    420. 

  420. 		   </td></tr></table></td>
    421. 

  421. 	</tr>
    422. 

  422. 	<tr>
    423. 

  423. 		  <td  align=right>
    424. 

  424. 		  <font face="arial,helvetica" size=-1><span><b>
    425. 

  425. 		  Manage Miscellaneous:  </span></b></font> </td>
    426. 

  426. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    427. 

  427. 		  <select name="waccmisc">
    428. 

  428. 			<?
    429. 

  429. 			setminmaxlvl($SETTING['USER_MISC']);
    430. 

  430. 		  ?>
    431. 

  431. 		  </select>
    432. 

  432. 		  </td><td valign = "top">
    433. 

  433. 		   </td></tr></table></td>
    434. 

  434. 	</tr>
    435. 

  435. 	<tr>
    436. 

  436. 		  <td  align=right>
    437. 

  437. 		  <font face="arial,helvetica" size=-1><span><b>
    438. 

  438. 		  Manage Donations:  </span></b></font> </td>
    439. 

  439. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    440. 

  440. 		  <select name="waccdonate">
    441. 

  441. 		  <?
    442. 

  442. 			setminmaxlvl($SETTING['USER_DONATIONS']);
    443. 

  443. 		  ?>
    444. 

  444. 		  </select>
    445. 

  445. 		  </td><td valign = "top">
    446. 

  446. 		   </td></tr></table></td>
    447. 

  447. 	</tr>
    448. 

  448. 	<tr>
    449. 

  449. 		  <td  align=right>
    450. 

  450. 		  <font face="arial,helvetica" size=-1><span><b>
    451. 

  451. 		  Manage E-mail Settings:  </span></b></font> </td>
    452. 

  452. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    453. 

  453. 		  <select name="waccemail">
    454. 

  454. 		  <?
    455. 

  455. 			setminmaxlvl($SETTING['USER_EMAIL']);
    456. 

  456. 		  ?>
    457. 

  457. 		  </select>
    458. 

  458. 		  </td><td valign = "top">
    459. 

  459. 		   </td></tr></table></td>
    460. 

  460. 	</tr>
    461. 

  461. 	</table>
    462. 

  462. 	</td></tr></table>
    463. 

  463. 	</td></tr></table><br>
    464. 

  464. 	
    465. 

  465. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    466. 

  466. 	<tr>
    467. 

  467. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    468. 

  468. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">Forum:</b></td>
    469. 

  469. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    470. 

  470. 	</tr>
    471. 

  471. 	</table>
    472. 

  472. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    473. 

  473. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    474. 

  474. 	<table border=0 cellspacing=0 cellpadding=4>
    475. 

  475. 	<tr>
    476. 

  476. 		  <td  align=right>
    477. 

  477. 		  <font face="arial,helvetica" size=-1><span><b>
    478. 

  478. 		  Manage Forums:  </span></b></font> </td>
    479. 

  479. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    480. 

  480. 		  <select name="waccforum">
    481. 

  481. 		  			<?
    482. 

  482. 			setminmaxlvl($SETTING['USER_FORUMS']);
    483. 

  483. 		  ?>
    484. 

  484. 		  </select>
    485. 

  485. 		  </td><td valign = "top">
    486. 

  486. 		   </td></tr></table></td>
    487. 

  487. 	</tr>
    488. 

  488. 	<tr>
    489. 

  489. 		  <td width=250 align=right>
    490. 

  490. 		  <font face="arial,helvetica" size=-1><span><b>
    491. 

  491. 		  Enable Signature For:  </span></b></font> </td>
    492. 

  492. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    493. 

  493. 		  <select name="wenableusersig">
    494. 

  494. 		  <?
    495. 

  495. 			setminmaxlvl($SETTING['USER_ENABLE_SIGNATURE'], 0);
    496. 

  496. 		  ?>
    497. 

  497. 		  </select>
    498. 

  498. 		  </td><td valign = "top">
    499. 

  499. 		   </td></tr></table></td>
    500. 

  500. 	</tr>
    501. 

  501. 	<tr>
    502. 

  502. 		  <td align=right>
    503. 

  503. 		  <font face="arial,helvetica" size=-1><span><b>
    504. 

  504. 		  Start New Polls:  </span></b></font> </td>
    505. 

  505. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    506. 

  506. 		  <select name="wuserpoll">
    507. 

  507. 		  <?
    508. 

  508. 			setminmaxlvl($SETTING['USER_POLL'], 0);
    509. 

  509. 		  ?>
    510. 

  510. 		  </select>
    511. 

  511. 		  </td><td valign = "top">
    512. 

  512. 		   </td></tr></table></td>
    513. 

  513. 	</tr>
    514. 

  514. 	</table>
    515. 

  515. 	</td></tr></table>
    516. 

  516. 	</td></tr></table><br>
    517. 

  517. 	<table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    518. 

  518. 	<tr>
    519. 

  519. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    520. 

  520. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">Account:</b></td>
    521. 

  521. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    522. 

  522. 	</tr>
    523. 

  523. 	</table>
    524. 

  524. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    525. 

  525. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    526. 

  526. 	<table border=0 cellspacing=0 cellpadding=4>
    527. 

  527. 	<tr>
    528. 

  528. 		  <td  align=right>
    529. 

  529. 		  <font face="arial,helvetica" size=-1><span><b>
    530. 

  530. 		  Manage Accounts:  </span></b></font> </td>
    531. 

  531. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    532. 

  532. 		  <select name="waccacc">
    533. 

  533. 		  <?
    534. 

  534. 			setminmaxlvl($SETTING['USER_ACCOUNTS']);
    535. 

  535. 		  ?>
    536. 

  536. 		  </select>
    537. 

  537. 		  </td><td valign = "top">
    538. 

  538. 		   </td></tr></table></td>
    539. 

  539. 	</tr>
    540. 

  540. 	<tr>
    541. 

  541. 		  <td width=250 align=right>
    542. 

  542. 		  <font face="arial,helvetica" size=-1><span><b>
    543. 

  543. 		  Enable E-mail Sending For:  </span></b></font> </td>
    544. 

  544. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    545. 

  545. 		  <select name="wenablemailsend">
    546. 

  546. 		  <?
    547. 

  547. 			setminmaxlvl($SETTING['USER_ENABLE_PM'],0);
    548. 

  548. 		  ?>
    549. 

  549. 		  </select>
    550. 

  550. 		  </td><td valign = "top">
    551. 

  551. 		   </td></tr></table></td>
    552. 

  552. 	</tr>
    553. 

  553. 	<tr>
    554. 

  554. 		  <td align=right>
    555. 

  555. 		  <font face="arial,helvetica" size=-1><span><b>
    556. 

  556. 		  Enable Private Messages Sending For:  </span></b></font> </td>
    557. 

  557. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    558. 

  558. 		  <select name="wenablepmsend">
    559. 

  559. 		  <?
    560. 

  560. 			setminmaxlvl($SETTING['USER_ENABLE_EMAIL'],0);
    561. 

  561. 		  ?>
    562. 

  562. 		  </select>
    563. 

  563. 		  </td><td valign = "top">
    564. 

  564. 		   </td></tr></table></td>
    565. 

  565. 	</tr>
    566. 

  566. 	</table>
    567. 

  567. 	</td></tr></table>
    568. 

  568. 	</td></tr></table><br>
    569. 

  569. <script language="javascript">
    570. 

  570. void(document.siteadmin.wserverown.value='<?php 
    571. 

  571. 							$newquery = mysql_fetch_array(mysql_query("SELECT username FROM account a WHERE id='".$SETTING['SERVER_OWNER']."'"));
    572. 

  572. 							echo $newquery[0];?>');
    573. 

  573. void(document.siteadmin.wdbback.value='<?php echo $SETTING['DB_BACKUP'];?>');
    574. 

  574. void(document.siteadmin.wdbrest.value='<?php echo $SETTING['DB_RESTORE'];?>');
    575. 

  575. void(document.siteadmin.waccweb.value='<?php echo $SETTING['USER_WEB'];?>');
    576. 

  576. void(document.siteadmin.waccforum.value='<?php echo $SETTING['USER_FORUMS'];?>');
    577. 

  577. void(document.siteadmin.waccacc.value='<?php echo $SETTING['USER_ACCOUNTS'];?>');
    578. 

  578. void(document.siteadmin.waccmisc.value='<?php echo $SETTING['USER_MISC'];?>');
    579. 

  579. void(document.siteadmin.waccdonate.value='<?php echo $SETTING['USER_DONATIONS'];?>');
    580. 

  580. void(document.siteadmin.waccemail.value='<?php echo $SETTING['USER_EMAIL'];?>');
    581. 

  581. void(document.siteadmin.wuserpoll.value='<?php echo $SETTING['USER_POLL'];?>');
    582. 

  582. void(document.siteadmin.wenablepmsend.value='<?php echo $SETTING['USER_ENABLE_EMAIL'];?>');
    583. 

  583. void(document.siteadmin.wenablemailsend.value='<?php echo $SETTING['USER_ENABLE_PM'];?>');
    584. 

  584. void(document.siteadmin.wenableusersig.value='<?php echo $SETTING['USER_ENABLE_SIGNATURE'];?>');
    585. 

  585. </script>
    586. 

  586. 		
    587. 

  587. 		<div align=center><input type=image SRC="shared/wow-com/images/buttons/update-button.gif" name="Submit" alt="Update" Width="174" Height="46" Border=0 class="button"  taborder=7 ></div>
    588. 

  588. 

  589. </form>
    590. 

  590. <?php
    591. 

  591. }
    592. 

  592. 	break;
    593. 

  593. 	case 'cleanup':
    594. 

  594. 	
    595. 

  595. 	$forceshow=true;
    596. 

  596. 	
    597. 

  597. 		if ($_POST['update']=='delete') {
    598. 

  598. 		
    599. 

  599. 			if ($_POST['acctype']=='normal') {
    600. 

  600. 				$newquery = "SELECT a.id as id FROM account a LEFT JOIN (`forum_accounts` fa) ON fa.id_account = a.id WHERE a.id!='".$SETTING['SERVER_OWNER']."' AND a.gmlevel='0' AND
    601. 

  601. 							(DATEDIFF(NOW(), ".$_POST['llogo'].") >=".round($_POST['llogd'] * $_POST['llogt'], 0)." OR ".$_POST['llogo']."='0000-00-00 00:00:00')";
    602. 

  602. 			} else if ($_POST['acctype']=='ghost') {
    603. 

  603. 				$newquery = "SELECT id_account as id FROM forum_accounts WHERE id_account NOT IN (SELECT id FROM account)";
    604. 

  604. 			}
    605. 

  605. 			$newquery = mysql_query($newquery) OR DIE (mysql_error());
    606. 

  606. 				while($rowa = mysql_fetch_array($newquery)) {
    607. 

  607. 					if ($_POST['acctype']=='normal') {
    608. 

  608. 						$queryzed = mysql_query("SELECT name, rs.dbhost as rsdbhost, rs.dbport as rsdbport,rs.dbuser as rsdbuser,
    609. 

  609. 						rs.dbpass as rsdbpass,rs.dbname as rsdbname FROM `realmlist` r LEFT JOIN (realm_settings rs) ON r.id = rs.id_realm 
    610. 

  610. 						GROUP BY r.id ORDER BY r.name", $MySQL_CON) OR DIE(mysql_error());
    611. 

  611. 						while($rowo = mysql_fetch_array($queryzed)) {
    612. 

  612. 							$newconb = mysql_connect($rowo['rsdbhost'].':'.$rowo['rsdbport'], $rowo['rsdbuser'], $rowo['rsdbpass']);
    613. 

  613. 							$newdbb = mysql_select_db ($rowo['rsdbname'], $newconb) OR DIE(mysql_error());
    614. 

  614. 							$cleanacc = mysql_query('DELETE FROM `characters` WHERE `account`="'.$rowa['id'].'"', $newconb);
    615. 

  615. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    616. 

  616. 							$cleanacc = mysql_query('DELETE FROM `character_inventory` WHERE guid NOT IN (SELECT guid FROM `characters`) AND guid!=0', $newconb);
    617. 

  617. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    618. 

  618. 							$cleanacc = mysql_query('DELETE FROM `character_inventory` WHERE item NOT IN (SELECT guid FROM `item_instance`) AND item!=0', $newconb);
    619. 

  619. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    620. 

  620. 							$cleanacc = mysql_query('DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM `character_inventory`) AND guid NOT IN(SELECT id FROM mail) AND guid NOT IN(SELECT itemguid FROM `auctionhouse`)', $newconb);
    621. 

  621. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    622. 

  622. 							$cleanacc = mysql_query('DELETE FROM `mail` WHERE id NOT IN (SELECT guid FROM `item_instance`) AND id!=0', $newconb);
    623. 

  623. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    624. 

  624. 							$cleanacc = mysql_query('DELETE FROM `auctionhouse` WHERE itemguid NOT IN (SELECT guid FROM `item_instance`) AND itemguid!=0;', $newconb);
    625. 

  625. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    626. 

  626. 							if ($haserrors!='') {  break; }
    627. 

  627. 						}
    628. 

  628. 						mysql_select_db ($MySQL_Set['DBREALM'], $MySQL_CON);
    629. 

  629. 					}
    630. 

  630. 					if ($haserrors!='') {  break; }
    631. 

  631. 					$cleanacc = mysql_query('DELETE FROM `forum_accounts` WHERE id_account="'.$rowa['id'].'"', $MySQL_CON);
    632. 

  632. 					if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    633. 

  633. 					if ($_POST['accconv']=='0' OR $_POST['acctype']=='ghost') {
    634. 

  634. 						$cleanacc = mysql_query('UPDATE forum_posts SET id_account_edit=0 WHERE id_account="'.$rowa['id'].'"', $MySQL_CON);
    635. 

  635. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    636. 

  636. 						$cleanacc = mysql_query('DELETE FROM `forum_posts` WHERE `id_account`="'.$rowa['id'].'"', $MySQL_CON);
    637. 

  637. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    638. 

  638. 						$cleanacc = mysql_query('DELETE FROM `forum_topics` WHERE id_topic NOT IN (SELECT id_topic FROM forum_posts)', $MySQL_CON);
    639. 

  639. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    640. 

  640. 						$cleanacc = mysql_query('DELETE FROM `web_donations` WHERE id_account="'.$rowa['id'].'"', $MySQL_CON);
    641. 

  641. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    642. 

  642. 						$cleanacc = mysql_query('DELETE FROM `forum_rel_account_polls` WHERE `id_account`="'.$rowa['id'].'"', $MySQL_CON);
    643. 

  643. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    644. 

  644. 						$cleanacc = mysql_query('DELETE FROM `forum_rel_topics_polls` WHERE id_topic NOT IN (SELECT id_topic FROM forum_topics)', $MySQL_CON);
    645. 

  645. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    646. 

  646. 					} else if ($_POST['accconv']=='1') {
    647. 

  647. 						$cleanacc = mysql_query('INSERT INTO `forum_accounts`(id_account, displayname) VALUES("'.$rowa['id_account'].'", "'.$rowa['displayname'].'")', $MySQL_CON);
    648. 

  648. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    649. 

  649. 					}
    650. 

  650. 					$cleanacc = mysql_query('DELETE FROM `forum_pm` WHERE `id_account_from`="'.$rowa['id'].'" OR `id_account_to`="'.$rowa['id'].'"', $MySQL_CON);
    651. 

  651. 					if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    652. 

  652. 					$cleanacc = mysql_query('DELETE FROM `forum_reports` WHERE `id_account`="'.$rowa['id'].'"', $MySQL_CON);
    653. 

  653. 					if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    654. 

  654. 					$cleanacc = mysql_query('DELETE FROM `forum_views` WHERE `id_account`="'.$rowa['id'].'"', $MySQL_CON);
    655. 

  655. 					if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    656. 

  656. 					$cleanacc = mysql_query('DELETE FROM `web_online` WHERE `id`="'.$rowa['id'].'"', $MySQL_CON);
    657. 

  657. 					if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    658. 

  658. 					$cleanacc = mysql_query('DELETE FROM `account_banned` WHERE id="'.$rowa['id'].'"', $MySQL_CON);
    659. 

  659. 					if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    660. 

  660. 					$cleanacc = mysql_query('DELETE FROM `account` WHERE id="'.$rowa['id'].'"', $MySQL_CON);
    661. 

  661. 					if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    662. 

  662. 					if ($haserrors!='') {  break; }
    663. 

  663. 				}
    664. 

  664. 			if ($haserrors=='') {
    665. 

  665. 				$forceshow=false;
    666. 

  666. 				goodborder('A total of '.mysql_num_rows($newquery).' accounts were successfuly deleted!<META HTTP-EQUIV=REFRESH CONTENT="2; URL=?n=admin.accounts">');
    667. 

  667. 			} else {
    668. 

  668. 				$forceshow=true;
    669. 

  669. 				errborder($haserrors);
    670. 

  670. 			}
    671. 

  671. 

  672. 		}
    673. 

  673. if ($forceshow==true) {
    674. 

  674. ?>
    675. 

  675. <form name="siteadmin" method=post action="index.php?n=admin.accounts&t=cleanup">
    676. 

  676. <input type=hidden name="update">
    677. 

  677. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    678. 

  678. 	<tr>
    679. 

  679. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    680. 

  680. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">Search Normal User Accounts For Clean Up:</b></td>
    681. 

  681. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    682. 

  682. 	</tr>
    683. 

  683. 	</table>
    684. 

  684. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    685. 

  685. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    686. 

  686. 	<table border=0 cellspacing=0 cellpadding=4>
    687. 

  687. 		<tr>
    688. 

  688. 		  <td width=180 align=right>
    689. 

  689. 		  <font face="arial,helvetica" size=-1><span><b>
    690. 

  690. 		  Account Type:</span></b></font></td>
    691. 

  691. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    692. 

  692. 		  <select name="acctype" Onchange="document.siteadmin.submit();">
    693. 

  693. 			<option value="normal">Normal
    694. 

  694. 			<option value="ghost">Ghost
    695. 

  695. 		  </select>
    696. 

  696. 		  </td><td valign = "top">
    697. 

  697. 		   </td></tr></table></td>
    698. 

  698. 		</tr>
    699. 

  699. <?php if ($_POST['acctype']=='normal' OR $_SERVER['REQUEST_METHOD']!='POST') { ?>
    700. 

  700. 	<tr>
    701. 

  701. 		  <td align=right>
    702. 

  702. 		  <font face="arial,helvetica" size=-1><span><b>
    703. 

  703. 		  Last Login On:</span></b></font> </td>
    704. 

  704. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    705. 

  705. 		<select name="llogo">
    706. 

  706. 			<option value="a.last_login">Game Server
    707. 

  707. 			<option value="fa.lastlogin">Website
    708. 

  708. 			</select>
    709. 

  709. 		  </td><td valign = "top" style="font-size: 13px;">
    710. 

  710. 		   </td></tr></table></td>
    711. 

  711. 	</tr>
    712. 

  712. 	<tr>
    713. 

  713. 		  <td align=right>
    714. 

  714. 		  <font face="arial,helvetica" size=-1><span><b>
    715. 

  715. 		  Last Login Was:</span></b></font> </td>
    716. 

  716. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    717. 

  717. 			<input name="llogd" type=text style="height:19px; width:20px;" maxlength=2 value="2">
    718. 

  718. 		  </td><td valign = "top" style="font-size: 13px;">
    719. 

  719. 		  <select name="llogt">
    720. 

  720. 			<option value="1">Days Ago
    721. 

  721. 			<option value="7">Weeks Ago
    722. 

  722. 			<option value="30" SELECTED>Months Ago
    723. 

  723. 			<option value="365.25">Years Ago
    724. 

  724. 		  </select> or higher.
    725. 

  725. 		   </td></tr></table></td>
    726. 

  726. 	</tr>
    727. 

  727. 	<tr>
    728. 

  728. 		  <td align=right>
    729. 

  729. 		  <font face="arial,helvetica" size=-1><span><b>
    730. 

  730. 		  Convert To Ghost Account:</span></b></font> </td>
    731. 

  731. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    732. 

  732. 		   <select name="accconv" onchange="vallog()">
    733. 

  733. 			<option value="1">Yes
    734. 

  734. 			<option value="0" SELECTED>No
    735. 

  735. 		  </select>
    736. 

  736. 		  </td><td valign = "top" style="font-size: 13px;">
    737. 

  737. 		   </td></tr></table></td>
    738. 

  738. 	</tr>
    739. 

  739. <?php } ?>
    740. 

  740. 	</table>
    741. 

  741. 	</td></tr></table>
    742. 

  742. 	</td></tr></table><br>
    743. 

  743. <div align=center><input onclick='javascript:document.siteadmin.update.value="search";' type=image SRC="shared/wow-com/images/buttons/button-continue.gif"></div>
    744. 

  744. </form>
    745. 

  745. <?
    746. 

  746. 

  747. 	if ($_POST['update']=='search') {
    748. 

  748. 

  749. 		if (alphanum($_POST['llogd'],true,false)==false OR $_POST['llogd']=='' OR $_POST['llogd']=='0') { $_POST['llogd']='1'; }
    750. 

  750. 

  751. 		parchdown();
    752. 

  752. 		
    753. 

  753. 		parchup(true);
    754. 

  754. 

  755. 			if ($_POST['acctype']=='normal') {
    756. 

  756. 				$newquery = "SELECT a.id as id FROM account a LEFT JOIN (`forum_accounts` fa) ON fa.id_account = a.id WHERE a.id!='".$SETTING['SERVER_OWNER']."' AND a.gmlevel='0' AND
    757. 

  757. 							(DATEDIFF(NOW(), ".$_POST['llogo'].") >=".round($_POST['llogd'] * $_POST['llogt'], 0)." OR ".$_POST['llogo']."='0000-00-00 00:00:00')";
    758. 

  758. 			} else {
    759. 

  759. 				$newquery = "SELECT id_account FROM forum_accounts WHERE id_account NOT IN (SELECT id FROM account)";
    760. 

  760. 			}
    761. 

  761. 			
    762. 

  762. 			$newquery = mysql_query($newquery) OR DIE (mysql_error());	
    763. 

  763. 			
    764. 

  764. 			if (mysql_num_rows($newquery)>0) {
    765. 

  765. 				echo '<b>Found <font color=green>' . mysql_num_rows($newquery) . '</font> Accounts ready for the Delete Process.</b><br><br>';
    766. 

  766. 		?>
    767. 

  767. 		<font color=red>Before pressing "Continue", make sure all realms databases are On-Line!</font><br><br>
    768. 

  768. 		<div align=center><input onclick='javascript:document.siteadmin.update.value="delete";document.siteadmin.submit();' type=image SRC="shared/wow-com/images/buttons/button-continue.gif"></div>
    769. 

  769. 		<?php
    770. 

  770. 			} else {
    771. 

  771. 				echo '<b>No Accounts were Found with those requirements.</b><br>';
    772. 

  772. 			}
    773. 

  773. 	}
    774. 

  774. ?>
    775. 

  775. <script>
    776. 

  776. 	document.siteadmin.acctype.value='<?php echo $_POST['acctype']; ?>';
    777. 

  777. <?php if ($_POST['acctype']=='normal' OR $_SERVER['REQUEST_METHOD']!='POST') { ?>
    778. 

  778. 	document.siteadmin.llogd.value='<?php echo $_POST['llogd']; ?>';
    779. 

  779. 	document.siteadmin.llogt.value='<?php echo $_POST['llogt']; ?>';
    780. 

  780. 	document.siteadmin.llogo.value='<?php echo $_POST['llogo']; ?>';
    781. 

  781. 	document.siteadmin.accconv.value='<?php echo $_POST['accconv']; ?>';
    782. 

  782. 	document.siteadmin.accact.value='<?php echo $_POST['accact']; ?>';
    783. 

  783. 	document.siteadmin.accban.value='<?php echo $_POST['accban']; ?>';
    784. 

  784. <? } ?>
    785. 

  785. </script>
    786. 

  786. <?php
    787. 

  787. }
    788. 

  788. 

  789. 	break;
    790. 

  790. 	case "manage":
    791. 

  791. 	default:
    792. 

  792. 	if ($_REQUEST['id'] =='') {
    793. 

  793. 	
    794. 

  794. 		if ($_REQUEST['by']=='') { $_REQUEST['by']='a.`username`'; }
    795. 

  795. 

  796. ?>
    797. 

  797. <table cellspacing = "0" cellpadding = "0" border = "0" width = "95%">
    798. 

  798. 	<tr>
    799. 

  799. 		<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    800. 

  800. 		<td width = "100%" bgcolor = "#05374A"><b class = "white">Search For Accounts:</b></td>
    801. 

  801. 		<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    802. 

  802. 	</tr>
    803. 

  803. 	</table>
    804. 

  804. 	<table width = 95% style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    805. 

  805. 	<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    806. 

  806.  <form name="siteadmin" Onsubmit="return false;">
    807. 

  807. 	<table border=0 cellspacing=0 cellpadding=4>
    808. 

  808. 	<tr>
    809. 

  809. 		  <td width=170 align=right>
    810. 

  810. 		 
    811. 

  811. 		  <font face="arial,helvetica" size=-1><span><b>
    812. 

  812. 		  Account <select name="by">
    813. 

  813. 					<option value="fa.`id_account`" SELECTED>ID	
    814. 

  814. 					<option value="a.`username`" SELECTED>Name
    815. 

  815. 					<option value="fa.`displayname`">Display Name
    816. 

  816. 					<option value="a.`email`">E-mail
    817. 

  817. 				</select>:</span></b></font> </td>
    818. 

  818. 		  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    819. 

  819. 		  <input type=text size=20 name="s" value="<? echo $_REQUEST['s']; ?>">
    820. 

  820. 		  </td><td valign = "top">
    821. 

  821. 		   </td></tr></table></td>
    822. 

  822. 	</tr>
    823. 

  823. 	</table>
    824. 

  824. </form>
    825. 

  825. 	</td></tr></table>
    826. 

  826. 	</td></tr></table><br>
    827. 

  827. 		<div align=center>
    828. 

  828. <script language="javascript">
    829. 

  829. document.siteadmin.by.value='<?php echo $_REQUEST['by']; ?>';
    830. 

  830. document.siteadmin.s.value='<?php echo $_REQUEST['s']; ?>';
    831. 

  831. function sorter(vabym, vas) {
    832. 

  832. 	window.location='index.php?n=admin.accounts&t=manage&by=' + vabym + '&s=' + vas;
    833. 

  833. }
    834. 

  834. </script>
    835. 

  835. <a href="javascript:sorter(document.siteadmin.by.value, document.siteadmin.s.value)"><img type=image SRC="shared/wow-com/images/buttons/button-continue.gif"></a>
    836. 

  836. </div>
    837. 

  837. <?
    838. 

  838. 

  839. parchdown();
    840. 

  840. 

  841. parchup(true);
    842. 

  842. 

  843. 	$ppag=50;
    844. 

  844. 	$newquery = "SELECT fa.activation as activation, a.username as username, fa.displayname as dn, fa.id_account as id, a.gmlevel as gmlevel, 
    845. 

  845. 				fa.enableemail as enableemail, fa.location as location, fa.city as city, fa.showlocation as showlocation,
    846. 

  846. 				DATE_FORMAT(CONVERT_TZ(fa.`lastlogin`, '".$GMT[$SETTING['WEB_GMT']][0]."', '".$usergmt."'), '%d-%m-%Y at %h:%i %p') as lastlogin, 
    847. 

  847. 				DATE_FORMAT(CONVERT_TZ(a.`joindate`, '".$GMT[$SETTING['WEB_GMT']][0]."', '".$usergmt."'), '%d-%m-%Y at %h:%i %p') as joindate,  
    848. 

  848. 				DATE_FORMAT(CONVERT_TZ(a.`last_login`, '".$GMT[$SETTING['WEB_GMT']][0]."', '".$usergmt."'), '%d-%m-%Y at %h:%i %p') as last_login
    849. 

  849. 				FROM forum_accounts fa 
    850. 

  850. 				LEFT JOIN (account a) ON fa.id_account = a.id
    851. 

  851. 				WHERE (a.gmlevel < '".$userlevel."' OR a.id = '".$_SESSION['userid']."' OR fa.id_account NOT IN (SELECT id FROM `account`))";
    852. 

  852. 	if ($_REQUEST['s']!='') { $newquery .= " AND ".$_REQUEST['by']." LIKE '%".$_REQUEST['s']."%'"; }
    853. 

  853. 	$newquery .= " GROUP BY a.id ORDER BY ".$_REQUEST['by']." ASC";
    854. 

  854. 	$newquery2 = mysql_query($newquery) or die (mysql_error());
    855. 

  855. 	if (alphanum($_REQUEST['p'],true,false)==false OR $_REQUEST['p']=='') { $_REQUEST['p']=1;}
    856. 

  856. 	$newquery .= " LIMIT ".(($_REQUEST['p'] - 1) * $ppag).",".$ppag."";
    857. 

  857. 	$newquery = mysql_query($newquery) or die (mysql_error());
    858. 

  858. 	$pages = '<div style="width: 400;" align=center><table><tr>'. pages($_REQUEST['p'], mysql_num_rows($newquery2), $ppag, "index.php?n=admin.accounts&t=manage&by=".$_REQUEST['by']."&s=".$_REQUEST['s'], ' | ', true, 0, false).'</tr></table></div>';
    859. 

  859. 	
    860. 

  860. subtitle('User Accounts ('.mysql_num_rows($newquery2).'):');
    861. 

  861. 	
    862. 

  862. 	echo $pages;
    863. 

  863. 	
    864. 

  864. metalborderup();
    865. 

  865. 

  866. ?>
    867. 

  867. 			<table cellpadding='3' cellspacing='0' width=450>
    868. 

  868. 				<tr>
    869. 

  869. 					<td class='rankingHeader' align='left' nowrap='nowrap'>#</td>
    870. 

  870. 					<td class='rankingHeader' align='left' nowrap='nowrap'>Account Name</td>
    871. 

  871. 					<td class='rankingHeader' align='left' nowrap='nowrap'>Characters</td>
    872. 

  872. 					<td class='rankingHeader' align='left' nowrap='nowrap'>Log</td>
    873. 

  873. 				</tr>
    874. 

  874. 				<tr>
    875. 

  875. 					<td colspan='7' background='shared/wow-com/images/borders/metalborder/shadow.gif' height=8>
    876. 

  876. 					</td>
    877. 

  877. 				</tr>
    878. 

  878. 				<style>
    879. 

  879. 					span.white { font-size: 11px; color: white; }
    880. 

  880. 				</style>
    881. 

  881. <?php 
    882. 

  882. 

  883. if (mysql_num_rows($newquery)>0) {
    884. 

  884. $res_color=2;
    885. 

  885. $tt='';
    886. 

  886. $i=0;
    887. 

  887. while($rowa = mysql_fetch_array($newquery)) {
    888. 

  888. 	
    889. 

  889. 	if($res_color==1) { $res_color=2; } else { $res_color=1; }
    890. 

  890. 	
    891. 

  891. 		$queryzed = mysql_query("SELECT name, rs.dbhost as rsdbhost, rs.dbport as rsdbport,rs.dbuser as rsdbuser,
    892. 

  892. 		rs.dbpass as rsdbpass,rs.dbname as rsdbname FROM `realmlist` r LEFT JOIN (realm_settings rs) ON r.id = rs.id_realm 
    893. 

  893. 		GROUP BY r.id ORDER BY r.name", $MySQL_CON) OR DIE(mysql_error());
    894. 

  894. 		while($rowo = @mysql_fetch_array($queryzed)) {
    895. 

  895. 					
    896. 

  896. 			$newconb = mysql_connect($rowo['rsdbhost'].':'.$rowo['rsdbport'], $rowo['rsdbuser'], $rowo['rsdbpass'])OR DIE(mysql_error());
    897. 

  897. 			$newdbb = mysql_select_db ($rowo['rsdbname'], $newconb) OR DIE(mysql_error());
    898. 

  898. 			$newqueryz = mysql_query("SELECT name, race, class, data FROM `characters` WHERE `account`='".$rowa['id']."' ORDER BY name ASC", $newconb);
    899. 

  899. 			
    900. 

  900. 			$tt.='<table><tr><td colspan=4 align=center NOWRAP><span class=white><b>'.$rowo['name'].':</span></td></tr>';
    901. 

  901. 			
    902. 

  902. 			while ($rowz = @mysql_fetch_array($newqueryz)) {
    903. 

  903. 				$i++;
    904. 

  904. 				$rowz['data'] = explode(' ',$rowz['data']);		
    905. 

  905. 				$char_gender = dechex($rowz['data'][36]);
    906. 

  906. 				$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
    907. 

  907. 				$char_gender = $char_gender{3};
    908. 

  908. 				$tt.='<tr><td NOWRAP><span class=white>'.$rowz['name'].'</span><td></td><img src=new-hp/images/picons/'.$rowz['race'].'-'.$char_gender.'.gif><td></td><img src=new-hp/images/picons/'.$rowz['class'].'.gif></td><td NOWRAP><span class=white>Lvl. '.$rowz['data'][34].'</span></td></tr>';
    909. 

  909. 			}
    910. 

  910. 			
    911. 

  911. 			$tt.='</tr></table>';
    912. 

  912. 			
    913. 

  913. 			mysql_select_db ($MySQL_Set['DBREALM'], $MySQL_CON) OR DIE (mysql_error());
    914. 

  914. 

  915. 		}
    916. 

  916. 	
    917. 

  917. 	if ($rowa['id']==$SETTING['SERVER_OWNER']) { $rowa['gmlevel']=4; }
    918. 

  918. 		if ($rowa['username']!='') {
    919. 

  919. 			echo "<tr>
    920. 

  920. 				<td class='serverStatus".$res_color."'><span style='color: rgb(35, 67, 3);'>".$rowa['id']."</td>
    921. 

  921. 				<td class='serverStatus".$res_color."'><span style='color: rgb(35, 67, 3);'><a href='index.php?n=admin.accounts&t=manage&id=".$rowa['id']."'>".
    922. 

  922. 				$rowa['username']."</a>";
    923. 

  923. 			$banquery=mysql_num_rows(mysql_query("SELECT id FROM account_banned WHERE id='".$rowa['id']."' AND active=1", $MySQL_CON));
    924. 

  924. 			if ($rowa['activation']!='' AND $banquery=='1') { echo " <span onmouseover=\"ddrivetip('Status: Not Activated')\" onmouseout=\"hideddrivetip()\" style='-moz-border-radius:10px;background:black; color:orange'><b>&nbsp;@&nbsp;</b></span>"; }
    925. 

  925. 			else if ($banquery=='1') { echo " <span onmouseover=\"ddrivetip('Status: Banned')\" onmouseout=\"hideddrivetip()\" style='-moz-border-radius:10px;background:black; color:red'><b>&nbsp;?&nbsp;</b></span>"; }
    926. 

  926. 			echo "<br>".$rowa['dn']."</span>
    927. 

  927. 				<br><span style='color: rgb(102, 13, 2);'>".$USER_LEVEL[$rowa['gmlevel']]."</span></td>
    928. 

  928. 				<td class='serverStatus".$res_color."' align='center'><span";
    929. 

  929. 			if ($i>0) { echo " onmouseover=\"ddrivetip('".$tt."')\" onmouseout=\"hideddrivetip()\"";  } else { $i = "None"; }
    930. 

  930. 			echo " style='color: rgb(35, 67, 3);'>".$i."</span></td>
    931. 

  931. 				<td class='serverStatus".$res_color."' align='left'><span style='color: rgb(102, 13, 2);'>Created: ".$rowa['joindate']."<br>
    932. 

  932. 				Game Server: ";
    933. 

  933. 			if ($rowa['last_login']=='') { echo 'Never'; } else { echo $rowa['last_login']; }
    934. 

  934. 			echo "<br>Website: ";
    935. 

  935. 			if ($rowa['lastlogin']=='') { echo 'Never'; } else { echo $rowa['lastlogin']; }
    936. 

  936. 			echo "</small></td>
    937. 

  937. 			</tr>";
    938. 

  938. 		} else {
    939. 

  939. 			echo "<tr>
    940. 

  940. 					<td class='serverStatus".$res_color."'><span style='color: rgb(35, 67, 3);'>".$rowa['id']."</td>
    941. 

  941. 					</td>
    942. 

  942. 					<td class='serverStatus".$res_color."'><span style='color: rgb(102, 13, 2);'><a href='index.php?n=admin.accounts&t=manage&id=".$rowa['id']."'>".$rowa['dn']."</a></td>
    943. 

  943. 					</td>
    944. 

  944. 					<td colspan=3 class='serverStatus".$res_color."'><span style='color: rgb(35, 67, 3);'>Ghost Account</td>
    945. 

  945. 					</td>
    946. 

  946. 				</tr>";
    947. 

  947. 		}
    948. 

  948. 		$tt='';
    949. 

  949. 		$i=0;
    950. 

  950. 	}
    951. 

  951. 	
    952. 

  952. } else {
    953. 

  953. 	
    954. 

  954. 	echo "<tr><td colspan=7 align=center><small style='color: rgb(102, 13, 2);'>No Accounts were found!</td></tr>";
    955. 

  955. 

  956. }
    957. 

  957. 

  958. ?>
    959. 

  959. 			</table>
    960. 

  960. 

  961. <?php
    962. 

  962. 

  963. metalborderdown();
    964. 

  964. 

  965. echo $pages;
    966. 

  966. 

  967. if ($_POST['namesel']!='') { echo $pages; }
    968. 

  968. 

  969. 	} else {
    970. 

  970. 		$newquery = mysql_query("SELECT *, DATE_FORMAT(`bday`,'%d/%m/%Y') as `bday`, a.username as username, a.joindate as joindate, a.last_login as last_login, 
    971. 

  971. 				a.gmlevel as gmlevel, a.email as email, a.sha_pass_hash as password FROM forum_accounts fa LEFT JOIN (account a) ON fa.id_account = a.id
    972. 

  972. 				WHERE fa.id_account='".$_REQUEST['id']."' AND (a.gmlevel < '".$userlevel."' OR a.id = '".$_SESSION['userid']."' OR fa.id_account NOT IN (SELECT id FROM `account`))") OR DIE (mysql_error());
    973. 

    974. 

  974. 		if (mysql_num_rows($newquery)==1) {
    975. 

  975. 		
    976. 

  976. 			$getbanned=mysql_fetch_array(mysql_query("SELECT *, fa.displayname as dn FROM account_banned ab LEFT JOIN (forum_accounts fa) ON fa.id_account = ab.bannedby WHERE id='".$_REQUEST['id']."' AND ab.active=1"));
    977. 

  977. 			
    978. 

  978. 			$rowa = mysql_fetch_array($newquery);
    979. 

  979. 			$forceshow=true;
    980. 

  980. 			
    981. 

  981. 			if ($_POST['step']=='save') {
    982. 

  982. 					if ($_POST['deleteacc']>'0') {
    983. 

  983. 					$queryzed = mysql_query("SELECT name, rs.dbhost as rsdbhost, rs.dbport as rsdbport,rs.dbuser as rsdbuser,
    984. 

  984. 					rs.dbpass as rsdbpass,rs.dbname as rsdbname FROM `realmlist` r LEFT JOIN (realm_settings rs) ON r.id = rs.id_realm 
    985. 

  985. 					GROUP BY r.id ORDER BY r.name", $MySQL_CON) OR DIE(mysql_error());
    986. 

  986. 					while($rowo = mysql_fetch_array($queryzed)) {
    987. 

  987. 						$newconb = mysql_connect($rowo['rsdbhost'].':'.$rowo['rsdbport'], $rowo['rsdbuser'], $rowo['rsdbpass']);
    988. 

  988. 						$newdbb = mysql_select_db ($rowo['rsdbname'], $newconb) OR DIE(mysql_error());
    989. 

  989. 						$cleanacc = mysql_query('DELETE FROM `characters` WHERE `account`="'.$rowa['id_account'].'"', $newconb);
    990. 

  990. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    991. 

  991. 						$cleanacc = mysql_query('DELETE FROM `character_inventory` WHERE guid NOT IN (SELECT guid FROM `characters`) AND guid!=0', $newconb);
    992. 

  992. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    993. 

  993. 						$cleanacc = mysql_query('DELETE FROM `character_inventory` WHERE item NOT IN (SELECT guid FROM `item_instance`) AND item!=0', $newconb);
    994. 

  994. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    995. 

  995. 						$cleanacc = mysql_query('DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM `character_inventory`) AND guid NOT IN(SELECT guid FROM mail) AND guid NOT IN(SELECT itemguid FROM `auctionhouse`)', $newconb);
    996. 

  996. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    997. 

  997. 						$cleanacc = mysql_query('DELETE FROM `mail` WHERE guid NOT IN (SELECT guid FROM `item_instance`) AND guid!=0', $newconb);
    998. 

  998. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    999. 

  999. 						$cleanacc = mysql_query('DELETE FROM `auctionhouse` WHERE itemguid NOT IN (SELECT guid FROM `item_instance`) AND itemguid!=0;', $newconb);
    1000. 

  1000. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1001. 

  1001. 						if ($haserrors!='') {  break; }
    1002. 

  1002. 					}
    1003. 

  1003. 					mysql_select_db ($MySQL_Set['DBREALM'], $MySQL_CON);
    1004. 

  1004. 					if ($haserrors=='') {
    1005. 

  1005. 						$cleanacc = mysql_query('DELETE FROM `forum_accounts` WHERE id_account="'.$rowa['id_account'].'"', $MySQL_CON);
    1006. 

  1006. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1007. 

  1007. 						if ($_POST['deleteacc']=='1') {
    1008. 

  1008. 							$cleanacc = mysql_query('UPDATE forum_posts SET id_account_edit=0 WHERE id_account="'.$rowa['id_account'].'"', $MySQL_CON);
    1009. 

  1009. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1010. 

  1010. 							$cleanacc = mysql_query('DELETE FROM `forum_posts` WHERE `id_account`="'.$rowa['id_account'].'"', $MySQL_CON);
    1011. 

  1011. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1012. 

  1012. 							$cleanacc = mysql_query('DELETE FROM `forum_topics` WHERE id_topic NOT IN (SELECT id_topic FROM forum_posts)', $MySQL_CON);
    1013. 

  1013. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1014. 

  1014. 							$cleanacc = mysql_query('DELETE FROM `web_donations` WHERE id_account="'.$rowa['id_account'].'"', $MySQL_CON);
    1015. 

  1015. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1016. 

  1016. 							$cleanacc = mysql_query('DELETE FROM `forum_rel_account_polls` WHERE `id_account`="'.$rowa['id_account'].'"', $MySQL_CON);
    1017. 

  1017. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1018. 

  1018. 							$cleanacc = mysql_query('DELETE FROM `forum_rel_topics_polls` WHERE id_topic NOT IN (SELECT id_topic FROM forum_topics)', $MySQL_CON);
    1019. 

  1019. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1020. 

  1020. 						} else if ($_POST['deleteacc']=='2') {
    1021. 

  1021. 							$cleanacc = mysql_query('INSERT INTO `forum_accounts`(id_account, displayname) VALUES("'.$rowa['id_account'].'", "'.$rowa['displayname'].'")', $MySQL_CON);
    1022. 

  1022. 							if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1023. 

  1023. 						}
    1024. 

  1024. 						$cleanacc = mysql_query('DELETE FROM `forum_pm` WHERE `id_account_from`="'.$rowa['id_account'].'" OR `id_account_to`="'.$rowa['id'].'"', $MySQL_CON);
    1025. 

  1025. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1026. 

  1026. 						$cleanacc = mysql_query('DELETE FROM `forum_reports` WHERE `id_account`="'.$rowa['id_account'].'"', $MySQL_CON);
    1027. 

  1027. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1028. 

  1028. 						$cleanacc = mysql_query('DELETE FROM `forum_views` WHERE `id_account`="'.$rowa['id_account'].'"', $MySQL_CON);
    1029. 

  1029. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1030. 

  1030. 						$cleanacc = mysql_query('DELETE FROM `web_online` WHERE `id`="'.$rowa['id_account'].'"', $MySQL_CON);
    1031. 

  1031. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1032. 

  1032. 						$cleanacc = mysql_query('DELETE FROM `account_banned` WHERE id="'.$rowa['id'].'"', $MySQL_CON);
    1033. 

  1033. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1034. 

  1034. 						$cleanacc = mysql_query('DELETE FROM `account` WHERE id="'.$rowa['id_account'].'"', $MySQL_CON);
    1035. 

  1035. 						if (!$cleanacc) {  $haserrors.=mysql_error().'<br>'; }
    1036. 

  1036. 					}
    1037. 

  1037. 					if ($haserrors=='') {
    1038. 

  1038. 						$forceshow=false;
    1039. 

  1039. 						goodborder('Account Successfuly Removed!<META HTTP-EQUIV=REFRESH CONTENT="2; URL=?n=admin.accounts">');
    1040. 

  1040. 					} else {
    1041. 

  1041. 						$forceshow=true;
    1042. 

  1042. 						errborder($haserrors);
    1043. 

  1043. 					}
    1044. 

  1044. 				} else if ($_POST['update']=='charinfo') {
    1045. 

  1045. 					$queryz = mysql_query('UPDATE forum_accounts SET avatar="'.$_POST['avatar'].'" WHERE id_account="'.$rowa['id_account'].'"');
    1046. 

  1046. 					goodborder('Account Forum Avatar Successfuly Updated.<meta http-equiv="refresh" content="2; ?n=admin.accounts&t=manage&id='.$rowa['id_account'].'">');
    1047. 

  1047. 					$forceshow=false;
    1048. 

  1048. 				} else {
    1049. 

  1049. 					if ($rowa['username']!='') {
    1050. 

  1050. 						if (strlen($_POST['fname'])<1 or strlen($_POST['fname'])>45) {
    1051. 

  1051. 							$haserrors .="Invalid length on First Name field.<br>";		
    1052. 

  1052. 						} else {
    1053. 

  1053. 							if (alphanum($_POST['fname'],false)==false) {
    1054. 

  1054. 								$haserrors .="Invalid chars on First Name field.<br>";		
    1055. 

  1055. 							}
    1056. 

  1056. 						}
    1057. 

  1057. 						if (strlen($_POST['lname'])<1 or strlen($_POST['lname'])>45) {
    1058. 

  1058. 							$haserrors .="Invalid length on Last Name field.<br>";		
    1059. 

  1059. 						} else {
    1060. 

  1060. 							if (alphanum($_POST['lname'],false)==false) {
    1061. 

  1061. 								$haserrors .="Invalid chars on Last Name field.<br>";		
    1062. 

  1062. 							}
    1063. 

  1063. 						}
    1064. 

  1064. 						if (strlen($_POST['city'])<1 or strlen($_POST['city'])>45) {
    1065. 

  1065. 							$haserrors .="Invalid length on City field.<br>";		
    1066. 

  1066. 						}
    1067. 

  1067. 						if (strlen($_POST['lo'])<1) {
    1068. 

  1068. 							$haserrors .="Invalid selected option on Country field.<br>";		
    1069. 

  1069. 						}
    1070. 

  1070. 						if (strlen($_POST['em'])<1 or strlen($_POST['em'])>255) {
    1071. 

  1071. 							$haserrors .="Invalid length on E-mail field.<br>";	
    1072. 

  1072. 						} else {
    1073. 

  1073. 							if (valemail($_POST['em'])==false) {
    1074. 

  1074. 								$haserrors .="Invalid E-mail.<br>";		
    1075. 

  1075. 							} else {
    1076. 

  1076. 								$query=mysql_query("SELECT email FROM account WHERE LOWER(email)=LOWER('".$_POST['em']."') and id!='".$rowa['id_account']."'");
    1077. 

  1077. 								if (mysql_num_rows($query)!=0) {
    1078. 

  1078. 									$haserrors .="E-mail already exists.<br>";
    1079. 

  1079. 								}
    1080. 

  1080. 							}
    1081. 

  1081. 						}
    1082. 

  1082. 						if (strlen($_POST['p'])>0) {
    1083. 

  1083. 							if (strlen($_POST['p'])<6 or strlen($_POST['p'])>16) {
    1084. 

  1084. 								$haserrors .="Invalid length on New Account Password field.<br>";		
    1085. 

  1085. 							} else {
    1086. 

  1086. 								if (alphanum($_POST['p'],true,true,'_')==false) {
    1087. 

  1087. 									$haserrors .="Invalid chars on New Account Password field.<br>";		
    1088. 

  1088. 								} else {
    1089. 

  1089. 									if ($_POST['p']!=$_POST['cp']) {
    1090. 

  1090. 										$haserrors .="New Account and Verification Password fields must match.<br>";		
    1091. 

  1091. 									} else {
    1092. 

  1092. 										if ($row['username']==$_POST['p']) {
    1093. 

  1093. 											$haserrors .="New Account Name and Password fields must differ.<br>";		
    1094. 

  1094. 										}
    1095. 

  1095. 									}
    1096. 

  1096. 								}
    1097. 

  1097. 							}
    1098. 

  1098. 						}
    1099. 

  1099. 						if ($_POST['ask']<1) {
    1100. 

  1100. 							$haserrors .="Invalid selected option on Password Hint field.<br>";		
    1101. 

  1101. 						} else {
    1102. 

  1102. 							if (strlen($_POST['ans'])<1 and strlen($_POST['ans'])>255) {
    1103. 

  1103. 								$haserrors .="Invalid length on Answer field.<br>";		
    1104. 

  1104. 							}
    1105. 

  1105. 						}
    1106. 

  1106. 						if ($_POST['lockacc']=='1' AND ($binIp = ip2long($_POST['lockip'])) !== false) {
    1107. 

  1107. 							$haserrors .="Invalid Locked IP.<br>";
    1108. 

  1108. 						} else {
    1109. 

  1109. 							$_POST['lockip']=$rowa['last_ip'];
    1110. 

  1110. 						}
    1111. 

  1111. 						if ($rowa['id_account']==$SETTING['SERVER_OWNER']) {
    1112. 

  1112. 							$_POST['gmlvl']='3';
    1113. 

  1113. 						} else if ($_POST['gmlvl']>'0') {
    1114. 

  1114. 							$_POST['accmvp']='0';
    1115. 

  1115. 						}
    1116. 

  1116. 						if ($haserrors=='') {
    1117. 

  1117. 							if ($_POST['banfors']>='0') { 
    1118. 

  1118. 								if (alphanum($_POST['banfori'],true,false)==false OR $_POST['banfori']=='' OR $_POST['banfori']=='0') { $_POST['banfori']='1'; }
    1119. 

  1119. 								$_POST['banfori'] = '(UNIX_TIMESTAMP(NOW()) + '.($_POST['banfori'] * $_POST['banfors']).')'; 
    1120. 

  1120. 							} else { 
    1121. 

  1121. 								$_POST['banfori']='-1'; 
    1122. 

  1122. 							}
    1123. 

  1123. 							if ($_POST['accstatus']=='1') {
    1124. 

  1124. 								mysql_query("UPDATE account_banned SET active='0' WHERE id='".$_REQUEST['id']."'");
    1125. 

  1125. 								mysql_query("INSERT INTO account_banned(id, bandate,unbandate,bannedby, banreason) VALUES('".$_REQUEST['id']."', UNIX_TIMESTAMP(NOW()), ".$_POST['banfori'].",'".$_SESSION['userid']."','".$_POST['reason']."')");
    1126. 

  1126. 								$ACC_ACT='';
    1127. 

  1127. 							} else if ($_POST['accstatus']=='2' AND $rowa['activation']=='') {
    1128. 

  1128. 								mysql_query("UPDATE account_banned SET active='0' WHERE id='".$_REQUEST['id']."'");
    1129. 

  1129. 								mysql_query("INSERT INTO account_banned(id, bandate,unbandate,bannedby, banreason) VALUES('".$_REQUEST['id']."', UNIX_TIMESTAMP(NOW()), ".$_POST['banfori'].",'".$_SESSION['userid']."','Waiting for Activation')");
    1130. 

  1130. 								$ACC_ACT=secuimg(32);
    1131. 

  1131. 							} else if ($_POST['accstatus']=='2') {
    1132. 

  1132. 								$ACC_ACT=$rowa['activation'];
    1133. 

  1133. 							} else if ($_POST['accstatus']=='0') {	
    1134. 

  1134. 								mysql_query("UPDATE account_banned SET active='0' WHERE id='".$_REQUEST['id']."'");
    1135. 

  1135. 								$ACC_ACT='';
    1136. 

  1136. 							}
    1137. 

  1137. 						}
    1138. 

  1138. 					}
    1139. 

  1139. 					if (strlen($_POST['nick'])<3 or strlen($_POST['nick'])>16) {
    1140. 

  1140. 						$haserrors .="Invalid length on Display Name field.<br>";		
    1141. 

  1141. 					} else {
    1142. 

  1142. 						if (alphanum($_POST['Display Name'],true,true,'_')==false) {
    1143. 

  1143. 							$haserrors .="Invalid chars on Display Name field.<br>";		
    1144. 

  1144. 						} else {
    1145. 

  1145. 							$query=mysql_query("SELECT displayname FROM forum_accounts WHERE LOWER(displayname)=LOWER('".$_POST['nick']."') and id_account !='".$rowa['id_account']."'");
    1146. 

  1146. 							if (mysql_num_rows($query)!=0) {
    1147. 

  1147. 								$haserrors .="Display Name already exists.<br>";
    1148. 

  1148. 							}
    1149. 

  1149. 						}
    1150. 

  1150. 					}
    1151. 

  1151. 					if ($haserrors=='') {
    1152. 

  1152. 						if ($rowa['username']!='') {
    1153. 

  1153. 							if ($_POST['p']=='') { $_POST['p']=$rowa['password']; } else { $_POST['p']=sha1(strtoupper($rowa['username']).":".strtoupper($_POST['p'])); }
    1154. 

  1154. 							$_POST['bd'] = explode("/",$_POST['bd']);
    1155. 

  1155. 							$_POST['bd'] = $_POST['bd'][2] . "-" . $_POST['bd'][1] . "-" . $_POST['bd'][0];
    1156. 

  1156. 							$savequery=mysql_query("UPDATE account SET gmlevel='".$_POST['gmlvl']."', sha_pass_hash='".$_POST['p']."', expansion='".$_POST['uptbc']."', email='".$_POST['em']."' WHERE id='".$rowa['id_account']."'") or die (mysql_error());
    1157. 

  1157. 							$queryb=mysql_query("UPDATE forum_accounts SET passask='".$_POST['ask']."', passans='".$_POST['ans']."', displayname='".$_POST['nick']."', location='".$_POST['lo']."', showlocation='".$_POST['shlo']."', bday='".$_POST['bd']."', showbday='".$_POST['shbd']."',
    1158. 

  1158. 							signature='".$_POST['sig']."', enableemail='".$_POST['shem']."',gmt='".$_POST['gmt']."',webpage='".$_POST['weburl']."',
    1159. 

  1159. 							fname='".$_POST['fname']."',lname='".$_POST['lname']."',city='".$_POST['city']."',aim='".$_POST['aim']."',msn='".$_POST['msn']."',yahoo='".$_POST['yahoo']."',
    1160. 

  1160. 							skype='".$_POST['skype']."',icq='".$_POST['icq']."', ismvp='".$_POST['accmvp']."', enablepm='".$_POST['shpm']."', template='".$_POST['skin']."', gender='".$_POST['gender']."', activation='".$ACC_ACT."' WHERE id_account='".$rowa['id_account']."'") or die (mysql_error());
    1161. 

  1161. 						} else {
    1162. 

  1162. 							$savequery=mysql_query("UPDATE forum_accounts SET displayname='".$_POST['nick']."' WHERE id_account='".$rowa['id_account']."'") or die (mysql_error());
    1163. 

  1163. 						}
    1164. 

  1164. 						goodborder('Account Successfuly Updated!<meta http-equiv="refresh" content="2; ?n=admin.accounts&t=manage">');
    1165. 

  1165. 						$forceshow=false;
    1166. 

  1166. 					} else {
    1167. 

  1167. 						errborder($haserrors);
    1168. 

  1168. 					}
    1169. 

  1169. 				}
    1170. 

  1170. 			}
    1171. 

  1171. 		
    1172. 

  1172. 		if ($forceshow==true) {
    1173. 

  1173. 			remslashall();
    1174. 

  1174. ?>
    1175. 

  1175. 	<center>
    1176. 

  1176. 	<form method=post name="siteadmin" action="?n=admin.accounts&t=manage&id=<?php echo $rowa['id_account']; ?>">
    1177. 

  1177. 	<input type=hidden name="step">
    1178. 

  1178. 	<input type=hidden name="update">
    1179. 

  1179. 	<input type=hidden name="avatar" value="nochar">
    1180. 

  1180. <?php if ($rowa['username']!='') { ?>
    1181. 

  1181. 		<table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    1182. 

  1182. 			<tr>
    1183. 

  1183. 				<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    1184. 

  1184. 				<td width = 450 bgcolor = "#05374A"><b class = "white">Account Administration:</b></td>
    1185. 

  1185. 				<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    1186. 

  1186. 			</tr>
    1187. 

  1187. 			</table>
    1188. 

  1188. 

  1189. 			<table width = 450 style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    1190. 

  1190. 			<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    1191. 

  1191. 			<table border=0 cellspacing=0 cellpadding=4>
    1192. 

  1192. 			<tr>
    1193. 

  1193. 				  <td align=right NOWRAP><span><b>Account Priviledges:</b></span></td>
    1194. 

  1194. 																		  
    1195. 

  1195. 					  <td align=left NOWRAP>
    1196. 

  1196. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1197. 

  1197. <?php if ($rowa['id_account']!=$SETTING['SERVER_OWNER']) { ?>
    1198. 

  1198. 						 <select name="gmlvl">
    1199. 

  1199. <?php
    1200. 

  1200. 	if ($_SESSION['userid']==$rowa['id_account']) { $userlevel+=1; }
    1201. 

  1201. 	for($i=0;$i<$userlevel;$i++) {
    1202. 

  1202. 		echo '<option value="'.$i.'"';
    1203. 

  1203. 		if ($i==$rowa['gmlevel']) { echo ' SELECTED'; }
    1204. 

  1204. 		echo '>'.$USER_LEVEL[$i].'</option>';
    1205. 

  1205. 	}
    1206. 

  1206. } else {
    1207. 

  1207. 	echo $USER_LEVEL[$userlevel];
    1208. 

  1208. }
    1209. 

  1209. ?>
    1210. 

  1210. 					  </select>
    1211. 

  1211. 					  </td><td valign = "top">
    1212. 

  1212. 				   </td></tr></table>
    1213. 

  1213. 			</tr>
    1214. 

  1214. <?php if (0==$rowa['gmlevel']) { ?>
    1215. 

  1215. 			<tr>
    1216. 

  1216. 				  <td align=right NOWRAP valign=top><span><b>Most Valuable Player:</b></span></td>
    1217. 

  1217. 																		  
    1218. 

  1218. 					  <td align=left NOWRAP>
    1219. 

  1219. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1220. 

  1220. 					  <select name="accmvp">
    1221. 

  1221. 						<option value="1">Yes
    1222. 

  1222. 						<option value="0" SELECTED>No
    1223. 

  1223. 					  </select>
    1224. 

  1224. 

  1225. 					  </td><td valign = "top">
    1226. 

  1226. 					 </td></tr></table>
    1227. 

  1227. 			</tr>
    1228. 

  1228. <?php } ?>
    1229. 

  1229. 			<tr>
    1230. 

  1230. 				  <td align=right NOWRAP valign=top><span><b>Account Created:</b></span></td>
    1231. 

  1231. 																		  
    1232. 

  1232. 					  <td align=left NOWRAP>
    1233. 

  1233. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1234. 

  1234. 					 <?php
    1235. 

  1235. 					 echo 'In '.str_replace(' ', ' at ', $rowa['joindate']);
    1236. 

  1236. 					 ?>
    1237. 

  1237. 					  </td><td valign = "top">
    1238. 

  1238. 					 </td></tr></table>
    1239. 

  1239. 			</tr>
    1240. 

  1240. 			<tr>
    1241. 

  1241. 				  <td align=right NOWRAP valign=top><span><b>Last Login:</b></span></td>
    1242. 

  1242. 																		  
    1243. 

  1243. 					  <td align=left NOWRAP>
    1244. 

  1244. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1245. 

  1245. 					 <?php
    1246. 

  1246. 					 echo 'On Game Server: '.str_replace(' ', ' at ', str_replace('0000-00-00 00:00:00', 'Never', $rowa['last_login']));
    1247. 

  1247. 					 echo '<br>On Website: '.str_replace(' ', ' at ', str_replace('0000-00-00 00:00:00', 'Never', $rowa['lastlogin']));
    1248. 

  1248. 					 ?>
    1249. 

  1249. 					  </td><td valign = "top">
    1250. 

  1250. 				   </td></tr></table>
    1251. 

  1251. 			</tr>
    1252. 

  1252. 			<tr>
    1253. 

  1253. 				  <td align=right NOWRAP valign=top><span><b>Last IP:</b></span></td>
    1254. 

  1254. 																		  
    1255. 

  1255. 					  <td align=left NOWRAP>
    1256. 

  1256. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1257. 

  1257. 					  <?php echo $rowa['last_ip']; ?>
    1258. 

  1258. 					  </td><td valign = "top">
    1259. 

  1259. 				   </td></tr></table>
    1260. 

  1260. 			</tr>
    1261. 

  1261. 			<tr>
    1262. 

  1262. 				  <td align=right NOWRAP><span><b>Account Status:</b></span></td>
    1263. 

  1263. 																		  
    1264. 

  1264. 					  <td align=left NOWRAP>
    1265. 

  1265. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1266. 

  1266. <?php if ($rowa['gmlevel']=='0') { ?>
    1267. 

  1267. 					  <select name="accstatus" onchange='document.siteadmin.submit()'>
    1268. 

  1268. 						<option value="1">Banned
    1269. 

  1269. 						<option value="2">Not Activated
    1270. 

  1270. 						<option value="0">Active
    1271. 

  1271. 					  </select>
    1272. 

  1272. <?php } else {
    1273. 

  1273. 		echo 'Active';
    1274. 

  1274. 	} 
    1275. 

  1275. ?>
    1276. 

  1276. 					  </td><td valign = "top" style="font-size: 13px;">		  
    1277. 

  1277. 				   </td></tr></table>
    1278. 

  1278. 			</tr>
    1279. 

  1279. <?php if(($getbanned['id']=='' AND $_POST['accstatus']=='1') OR ($rowa['activation']!='' AND $_POST['accstatus']=='1')) { ?>
    1280. 

  1280. 			<tr>
    1281. 

  1281. 				  <td  align=right>
    1282. 

  1282. 				  <font face="arial,helvetica" size=-1><span><b>
    1283. 

  1283. 				  Ban For:</span></b></font> </td>
    1284. 

  1284. 				  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    1285. 

  1285. 					<input name="banfori" type=text style="height:19px; width:20px;" maxlength=2 value="2">
    1286. 

  1286. 				  </td><td valign = "top" style="font-size: 13px;">
    1287. 

  1287. 				  <select name="banfors">
    1288. 

  1288. 					<option value="-1">Permanently
    1289. 

  1289. 					<option value="60">Minutes
    1290. 

  1290. 					<option value="3600">Hours
    1291. 

  1291. 					<option value="86400">Days
    1292. 

  1292. 					<option value="604888" SELECTED>Weeks
    1293. 

  1293. 					<option value="2592000">Months
    1294. 

  1294. 					<option value="31104000.25">Years
    1295. 

  1295. 				  </select>
    1296. 

  1296. 				   </td></tr></table></td>
    1297. 

  1297. 			</tr>
    1298. 

  1298. 			<tr>
    1299. 

  1299. 				  <td  align=right>
    1300. 

  1300. 				  <font face="arial,helvetica" size=-1><span><b>
    1301. 

  1301. 				  Reason:</span></b></font> </td>
    1302. 

  1302. 				  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    1303. 

  1303. 				  <input type=text size=40 maxlength=255 name="reason">
    1304. 

  1304. 				  </td><td valign = "top">
    1305. 

  1305. 				   </td></tr></table></td>
    1306. 

  1306. 			</tr>
    1307. 

  1307. <?php } else if(($rowa['activation']!='' AND $_POST['accstatus']=='2') OR ($rowa['activation']!='' AND $_SERVER['REQUEST_METHOD']!='POST')) { ?>	
    1308. 

  1308. 			<tr>
    1309. 

  1309. 				  <td align=right NOWRAP><span><b>Activation Code:</b></span></td>									  
    1310. 

  1310. 					  <td align=left NOWRAP>
    1311. 

  1311. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1312. 

  1312. 			<?php echo $rowa['activation']; ?>
    1313. 

  1313. 					  </td><td valign = "top" style="font-size: 13px;">			  
    1314. 

  1314. 				   </td></tr></table>
    1315. 

  1315. 			</tr>
    1316. 

  1316. <?php } ?>	
    1317. 

  1317. 			<tr>
    1318. 

  1318. 				  <td align=right NOWRAP valign=top><span><b>Ban Log:</b></span></td>
    1319. 

  1319. 																		  
    1320. 

  1320. 					  <td align=left NOWRAP>
    1321. 

  1321. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td style="font-size: 13px;">
    1322. 

  1322. <?
    1323. 

  1323. 

  1324. $banquery = mysql_query("SELECT *, fa.displayname as dn FROM account_banned ab LEFT JOIN (forum_accounts fa) ON fa.id_account=ab.bannedby WHERE id='".$rowa['id']."'") OR DIE (mysql_error());
    1325. 

  1325. $res_color=2;
    1326. 

  1326. if (mysql_num_rows($banquery)>0) {
    1327. 

  1327. 

  1328. 	echo '<table border=0 cellspacing = "0" cellpadding = "2" width=250>';
    1329. 

  1329. 	
    1330. 

  1330. 	while ($rowi=mysql_fetch_array($banquery)) {
    1331. 

  1331. 		if($res_color==1) { $res_color=2; } else { $res_color=1; }
    1332. 

  1332. 		echo '<tr ';
    1333. 

  1333. 		if ($rowa['activation']!='' and $rowi['active']=='1') { echo 'bgcolor=lightyellow'; }
    1334. 

  1334. 		else if ($rowi['active']=='1') { echo 'bgcolor=lightpink'; }
    1335. 

  1335. 		if (is_integer($rowi['dn'])=='') { $rowi['dn'] = $rowi['bannedby']; }
    1336. 

  1336. 		echo ' class="serverStatus'.$res_color.'" style="font-size: 13px;">
    1337. 

  1337. 				<td align=left>'.$rowi['dn'].': '.$rowi['banreason'].'<br>
    1338. 

  1338. 				<span style="font-size: 10px;">';
    1339. 

  1339. 		echo 'Since '.date("Y-m-d \a\\t H:i", $rowi['bandate']);
    1340. 

  1340. 		if ($rowi['unbandate']>'-1') { ' till '.date("Y-m-d \a\\t H:i", $rowi['unbandate']); }
    1341. 

  1341. 		else { echo ', Permanently'; }
    1342. 

  1342. 		echo '</td>
    1343. 

  1343. 			</tr>';
    1344. 

  1344. 	}
    1345. 

  1345. 	
    1346. 

  1346. 	echo '</table>';
    1347. 

  1347. 

  1348. } else {
    1349. 

  1349. 

  1350. 	echo 'No records were found';
    1351. 

  1351. 

  1352. }
    1353. 

  1353. 

  1354. ?>
    1355. 

  1355. 					  </td><td valign = "top" style="font-size: 13px;">		  
    1356. 

  1356. 				   </td></tr></table>
    1357. 

  1357. 			</tr>
    1358. 

  1358. 			<tr>
    1359. 

  1359. 				  <td align=right NOWRAP><span><b>Locked IP:</b></span></td>
    1360. 

  1360. 																		  
    1361. 

  1361. 					  <td align=left NOWRAP>
    1362. 

  1362. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td>
    1363. 

  1363. 					  <select name="lockacc">
    1364. 

  1364. 						<option value="1">Yes
    1365. 

  1365. 						<option value="0" SELECTED>No
    1366. 

  1366. 					  </select>
    1367. 

  1367. 					  </td><td valign = "top">&nbsp;
    1368. 

  1368. 					 <input type=text name="lockip" style="height: 20px; width: 120px;" maxlength=15>
    1369. 

  1369. 				   </td></tr></table>
    1370. 

  1370. 			</tr>
    1371. 

  1371. <?php if ($rowa['id_account']!=$SETTING['SERVER_OWNER']) { ?>
    1372. 

  1372. 			<tr>
    1373. 

  1373. 				  <td align=right NOWRAP><span><b>Delete Account:</b></span></td>
    1374. 

  1374. 																		  
    1375. 

  1375. 					  <td align=left NOWRAP>
    1376. 

  1376. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td>
    1377. 

  1377. 					  <select name="deleteacc">
    1378. 

  1378. 						<option value="1">Yes
    1379. 

  1379. 						<option value="2">Yes, Leaving Ghost
    1380. 

  1380. 						<option value="0" SELECTED>No
    1381. 

  1381. 					  </select>
    1382. 

  1382. 					  </td><td valign = "top">
    1383. 

  1383. 				   </td></tr></table>
    1384. 

  1384. 			</tr>
    1385. 

  1385. <?php } ?>
    1386. 

  1386. 			</table>
    1387. 

  1387. 	</td>
    1388. 

  1388. </tr>
    1389. 

  1389. </table>
    1390. 

  1390. 			</td>
    1391. 

  1391. 		</tr>
    1392. 

  1392. 	</table>
    1393. 

  1393. 	<p>
    1394. 

  1394. 		<table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    1395. 

  1395. 			<tr>
    1396. 

  1396. 				<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    1397. 

  1397. 				<td width = 450 bgcolor = "#05374A"><b class = "white">Account Info:</b></td>
    1398. 

  1398. 				<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    1399. 

  1399. 			</tr>
    1400. 

  1400. 			</table>
    1401. 

  1401. 

  1402. 			<table width = 450 style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    1403. 

  1403. 			<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    1404. 

  1404. 			<table border=0 cellspacing=0 cellpadding=4>
    1405. 

  1405. 

  1406. 			<tr>
    1407. 

  1407. 

  1408. 				  <td align=right width=150 NOWRAP><span><b>Account Name:</b></span></td>
    1409. 

  1409. 				  
    1410. 

  1410. 				  <td align=left NOWRAP>
    1411. 

  1411. 				  <table border=0 cellspacing=0 cellpadding=0><tr><td><?php echo $rowa['username']; ?></td><td valign = "top">
    1412. 

  1412. 

  1413. 

  1414. 				   </td></tr></table>
    1415. 

  1415. 				  </td>
    1416. 

  1416. 				  
    1417. 

  1417. 

  1418. 			</tr>
    1419. 

  1419. 			<tr>
    1420. 

  1420. 				  <td align=right NOWRAP><span><b>Account New Password:</b></span></td>
    1421. 

  1421. 				  
    1422. 

  1422. 				  <td align=left>
    1423. 

  1423. 				  <table border=0 cellspacing=0 cellpadding=0><tr><td><input name="p" MaxLength=16 width=150 type=Password taborder="2" taborder=2 /></td><td valign = "top">
    1424. 

  1424. 

  1425. 				   </td></tr></table>
    1426. 

  1426. 				  </td>
    1427. 

  1427. 				  
    1428. 

  1428. 			</tr>
    1429. 

  1429. 			<tr>
    1430. 

  1430. 				  <td align=right><span><b>Verify New Password:</b></span></td>
    1431. 

  1431. 				  
    1432. 

  1432. 				  <td align=left>
    1433. 

  1433. 				  <table border=0 cellspacing=0 cellpadding=0><tr><td><input name="cp" MaxLength=16 width=150 type=Password taborder="3" /></td><td valign = "top">
    1434. 

  1434. 

  1435. 

  1436. 				   </td></tr></table>
    1437. 

  1437. 				  </td>
    1438. 

  1438. 				  
    1439. 

  1439. 			</tr>
    1440. 

  1440. 			<tr>
    1441. 

  1441. 				  <td align=right NOWRAP><span><b>Password Hint:</b></span><br></td>
    1442. 

  1442. 

  1443. 				  
    1444. 

  1444. 				  <td align=left NOWRAP>
    1445. 

  1445. 					<table border=0 cellspacing=0 cellpadding=0><tr><td>
    1446. 

  1446. 					 <select name="ask" taborder=4>
    1447. 

  1447. 					  <option value="0">Please Select A Secret Question</option>															          
    1448. 

  1448. <?php
    1449. 

  1449. for($i=1;$i<=count($PASSWORD_QUESTION);$i++) {
    1450. 

  1450. echo '<option value="'.$i.'">'.$PASSWORD_QUESTION[$i].'</option>';
    1451. 

  1451. }
    1452. 

  1452. ?>
    1453. 

  1453. 					 </select>
    1454. 

  1454. 

  1455. 					</td><td valign = "top">
    1456. 

  1456. 

  1457. 				   </td></tr></table>
    1458. 

  1458. 

  1459. 				  </td>
    1460. 

  1460. 			</tr>
    1461. 

  1461. 			<tr>
    1462. 

  1462. 				  <td align=right NOWRAP><span><b>Answer:</b></span></td>
    1463. 

  1463. 				  
    1464. 

  1464. 				  <td align=left NOWRAP>
    1465. 

  1465. 				  <table border=0 cellspacing=0 cellpadding=0><tr><td><input name="ans" MaxLength=32 width=150 taborder="5" value="" taborder=5/></td><td valign = "top">
    1466. 

  1466. 				   </td></tr></table>
    1467. 

  1467. 			</tr>
    1468. 

  1468. 			<tr>
    1469. 

  1469. 				  <td align=right NOWRAP><span><b></b></span></td>
    1470. 

  1470. 

  1471. 					  <td align=left NOWRAP>
    1472. 

  1472. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td><label for='upgtbc'><input type=Radio value='0' id="upgtbc" name="uptbc" ><span style="font-size: 13px;">No Expansion</label></td><td valign = "top">
    1473. 

  1473. 				   </td></tr></table>
    1474. 

  1474. 			</tr>
    1475. 

  1475.             <tr>
    1476. 

  1476. 				  <td align=right NOWRAP><span><b>Upgrades:</b></span></td>
    1477. 

  1477. 

  1478. 					  <td align=left NOWRAP>
    1479. 

  1479. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td><label for='upgtbc1'><input type=Radio value='1' id="upgtbc1" name="uptbc" ><span style="font-size: 13px;">The Burning Crusades</label></td><td valign = "top">
    1480. 

  1480. 				   </td></tr></table>
    1481. 

  1481. 			</tr>
    1482. 

  1482.             <tr>
    1483. 

  1483. 				  <td align=right NOWRAP><span><b></b></span></td>
    1484. 

  1484. 

  1485. 					  <td align=left NOWRAP>
    1486. 

  1486. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td><label for='upgtbc2'><input type=Radio value='32' id="upgtbc2" name="uptbc" CHECKED><span style="font-size: 13px;">Wrath of the Lich King</label></td><td valign = "top">
    1487. 

  1487. 				   </td></tr></table>
    1488. 

  1488. 			</tr>
    1489. 

  1489. 			</table>
    1490. 

  1490. 	</td>
    1491. 

  1491. </tr>
    1492. 

  1492. </table>
    1493. 

  1493. 			</td>
    1494. 

  1494. 		</tr>
    1495. 

  1495. 	</table>
    1496. 

  1496. 	<p>
    1497. 

  1497. <table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    1498. 

  1498. 			<tr>
    1499. 

  1499. 				<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    1500. 

  1500. 				<td width = 450 bgcolor = "#05374A"><b class = "white">Characters Info:</b></td>
    1501. 

  1501. 				<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    1502. 

  1502. 			</tr>
    1503. 

  1503. 			</table>
    1504. 

  1504. 

  1505. 			<table width = 450 style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    1506. 

  1506. 			<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    1507. 

  1507. 			<table border=0 cellspacing=0 cellpadding=4>
    1508. 

  1508. 	<?
    1509. 

  1509. 	$qquery = mysql_query("SELECT *, rs.dbhost as rsdbhost, rs.dbport as rsdbport,rs.dbuser as rsdbuser,
    1510. 

  1510. 	rs.dbpass as rsdbpass,rs.dbname as rsdbname FROM `realmlist` r LEFT JOIN (`realm_settings` rs) ON r.id = rs.id_realm 
    1511. 

  1511. 	GROUP BY r.id ORDER BY r.name", $MySQL_CON) OR DIE(mysql_error());
    1512. 

  1512. 	$i=0;
    1513. 

  1513. 	while ($rowx = mysql_fetch_array($qquery)) {
    1514. 

  1514. 		$newcon = @mysql_connect($rowx['rsdbhost'].':'.$rowx['rsdbport'], $rowx['rsdbuser'], $rowx['rsdbpass']);;
    1515. 

  1515. 		$newdb = @mysql_select_db ($rowx['rsdbname'], $newcon);
    1516. 

  1516. 		$newquery = @mysql_query("SELECT name, data, class, race, online FROM `characters` WHERE `account`='".$rowa['id_account']."'", $newcon);
    1517. 

  1517. 		echo "<tr>
    1518. 

  1518. 				  <td align=right valign=top width=150 NOWRAP><span><b>".$rowx['name']."</b></span></td>
    1519. 

  1519. 				  <td align=left NOWRAP>
    1520. 

  1520. 				  <table border=0 cellspacing=0 cellpadding=0>
    1521. 

  1521. 					<tr>
    1522. 

  1522. 						<td>";
    1523. 

  1523. 					while($rowc = @mysql_fetch_array($newquery)) {		
    1524. 

  1524. 						$rowc['data'] = explode(' ',$rowc['data']);		
    1525. 

  1525. 						$char_gender = dechex($rowc['data'][36]);
    1526. 

  1526. 						$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
    1527. 

  1527. 						$char_gender = $char_gender{3};		
    1528. 

  1528. 						echo "<table><tr>
    1529. 

  1529. 								<td width=120 align='left'><span>".$rowc['name']."</span></td>
    1530. 

  1530. 								<td align='left'><img onmouseover='ddrivetip(\"<b>".$CHAR_RACE[$rowc['race']][0]."</b>\")' onmouseout='hideddrivetip()' src='new-hp/images/picons/".$rowc['race']."-".$char_gender.".gif'></td>
    1531. 

  1531. 								<td align='left'><img onmouseover='ddrivetip(\"<b>".$CHAR_CLASS[$rowc['class']]."</b>\")' onmouseout='hideddrivetip()' src='new-hp/images/picons/".$rowc['class'].".gif'></td>
    1532. 

  1532. 								<td align='left' nowrap='nowrap' width=40><small style='color: rgb(102, 13, 2);'>Lvl. ".$rowc['data'][34]."</span></td>
    1533. 

  1533. 								<td width=0% align='left' nowrap='nowrap'><small style='color: rgb(102, 13, 2);'>";
    1534. 

  1534. 						if ($rowc['online']==1) { echo "<img onmouseover='ddrivetip(\"<b>On-Line</b>\")' onmouseout='hideddrivetip()' src='new-hp/images/favicon.ico'>"; } 
    1535. 

  1535. 						else { echo "<a href='#'><img onmouseover='ddrivetip(\"<b>Remove</b>\")' onmouseout='hideddrivetip()' src='new-hp/images/v2/remove.gif'></a>"; }
    1536. 

  1536. 						echo "</td></tr></table>";
    1537. 

  1537. 						$i++;
    1538. 

  1538. 					}
    1539. 

  1539. 					if (!$newcon OR !$newdb OR !$newquery) { echo '<span style="color: red;"><i>Server is Off-Line.</i></span>'; }
    1540. 

  1540. 					else if ($i==0) { echo '<span><i>None</i></span>'; }
    1541. 

  1541. 		echo '		</td></tr></table>
    1542. 

  1542. 				</td>
    1543. 

  1543. 			</tr>';
    1544. 

  1544. 	}
    1545. 

  1545. 	?>
    1546. 

  1546. 				   </table>
    1547. 

  1547. 	 </td></tr></table> 
    1548. 

  1548. 	</td>
    1549. 

  1549. </tr>
    1550. 

  1550. </table>
    1551. 

  1551. 	<p>
    1552. 

  1552. 		<table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    1553. 

  1553. 			<tr>
    1554. 

  1554. 				<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    1555. 

  1555. 				<td width = "100%" bgcolor = "#05374A"><b class = "white">Contact Address:</b></td>
    1556. 

  1556. 				<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    1557. 

  1557. 			</tr>
    1558. 

  1558. 			</table>
    1559. 

  1559. 

  1560. 			<table width = 450 style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    1561. 

  1561. 			<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    1562. 

  1562. 			<table border=0 cellspacing=0 cellpadding=4>
    1563. 

  1563. 

  1564. 			<tr>
    1565. 

  1565. 			      <td width=150 align=right>
    1566. 

  1566. 			      <font face="arial,helvetica" size=-1><span><b>
    1567. 

  1567. 			      <font color="#FF0000">*</font> First Name:
    1568. 

  1568. 			      </span></b></font>
    1569. 

  1569. 			      </td>
    1570. 

  1570. 			      <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td><input name="fname" MaxLength="32" style = "Width:200" taborder=1 /></td><td valign = "top">
    1571. 

  1571. 

  1572. 				   </td></tr></table></td>
    1573. 

  1573. 			</tr>
    1574. 

  1574. 			<tr>
    1575. 

  1575. 			      <td align=right>
    1576. 

  1576. 			      <font face="arial,helvetica" size=-1><span><b>
    1577. 

  1577. 			      <font color="#FF0000">*</font> Last Name:
    1578. 

  1578. 			      </span></b></font>
    1579. 

  1579. 			      </td>
    1580. 

  1580. 

  1581. 			      <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td><input name="lname" MaxLength="32" style = "Width:200" taborder=2 /></td><td valign = "top">
    1582. 

  1582. 

  1583. 				   </td></tr></table></td>
    1584. 

  1584. 			</tr>
    1585. 

  1585. 			<tr>
    1586. 

  1586. 			      <td align=right>
    1587. 

  1587. 			      <font face="arial,helvetica" size=-1><span><b>
    1588. 

  1588. 			      <font color="#FF0000">*</font> City:
    1589. 

  1589. 			      </span></b></font>
    1590. 

  1590. 			      </td>
    1591. 

  1591. 			      <td align=left colspan = "2"><table border=0 cellspacing=0 cellpadding=0><tr><td><input name="city" MaxLength="32" style = "Width:150" taborder=5/ ></td><td valign = "top">
    1592. 

  1592. 

  1593. 				   </td></tr></table></td>
    1594. 

  1594. 			</tr>
    1595. 

  1595. 			<tr>
    1596. 

  1596. 			      <td align=right>
    1597. 

  1597. 			      <font face="arial,helvetica" size=-1><span><b>
    1598. 

  1598. 

  1599. 			      <font color="#FF0000">*</font> Country:
    1600. 

  1600. 				  
    1601. 

  1601. 			      </span></b></font>
    1602. 

  1602. 			      </td>
    1603. 

  1603. 			      <td align=left colspan = "2">
    1604. 

  1604. 				  	<table border=0 cellspacing=0 cellpadding=2><tr>
    1605. 

  1605. 						<td><select name="lo" style="width: 150;" OnChange="javascript:document.siteadmin.cflag.src = 'new-hp/images/flags/' + this.value + '.gif';">
    1606. 

  1606. <?
    1607. 

  1607. foreach ($COUNTRY as $key=>$value) {
    1608. 

  1608. 	echo '<option value="'.$key.'">'.$value.'</option>';
    1609. 

  1609. }
    1610. 

  1610. ?></selected>
    1611. 

  1611. 						</td>
    1612. 

  1612. 						<td><img name="cflag" src="new-hp/images/flags/00.gif"></td>
    1613. 

  1613. 				   </tr></table>
    1614. 

  1614. 			      </td>
    1615. 

  1615. 			</tr>
    1616. 

  1616. 				<tr>
    1617. 

  1617. 				<td align=right>
    1618. 

  1618. 				<font face="arial,helvetica" size=-1><span><b>
    1619. 

  1619. 				Show Location:<br>
    1620. 

  1620. 				</span></b></font>
    1621. 

  1621. 				</td>
    1622. 

  1622. 				<td align=left>
    1623. 

  1623. 				<table border=0 cellspacing=0 cellpadding=0>
    1624. 

  1624. 				<tr>
    1625. 

  1625. 				<td><select name="shlo"><option value=1 SELECTED>To Everyone<option value=0>Only To Administrators</td>
    1626. 

  1626. 				</tr>
    1627. 

  1627. 				</table>
    1628. 

  1628. 				</td>
    1629. 

  1629. 				</tr>
    1630. 

  1630. 			</table>
    1631. 

  1631. 

  1632. 			</td></tr></table>
    1633. 

  1633. 			</td></tr></table>
    1634. 

  1634. 

  1635. 			</center>
    1636. 

  1636. 

  1637. 			<p>
    1638. 

  1638. 

  1639. 			<table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    1640. 

  1640. 			<tr>
    1641. 

  1641. 				<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    1642. 

  1642. 				<td width = "100%" bgcolor = "#05374A"><b class = "white">Email Address:</b></td>
    1643. 

  1643. 				<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    1644. 

  1644. 			</tr>
    1645. 

  1645. 			</table>
    1646. 

  1646. 

  1647. 			<center>
    1648. 

  1648. 			<a name = "phone"></a>
    1649. 

  1649. 			<table width = 450 style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    1650. 

  1650. 			<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    1651. 

  1651. 

  1652. 			<table border=0 cellspacing=0 cellpadding=4 width = "100%">
    1653. 

  1653. 			<tr>
    1654. 

  1654. 			      <td width=150 align=right>
    1655. 

  1655. 			      <font face="arial,helvetica" size=-1><span><b>
    1656. 

  1656. 			      <font color="#FF0000">*</font> Email:<br>
    1657. 

  1657. 			      </span></b></font>
    1658. 

  1658. 			      </td>
    1659. 

  1659. 			      <td align=left>
    1660. 

  1660. 				  <table border=0 cellspacing=0 cellpadding=0>
    1661. 

  1661. 					<tr>
    1662. 

  1662. 						<td><input name="em" MaxLength="250" Width=130 taborder=9 /></td>
    1663. 

  1663. 					</tr>
    1664. 

  1664. 				  </table>
    1665. 

  1665. 				  </td>
    1666. 

  1666. 			</tr>
    1667. 

  1667. 						<tr>
    1668. 

  1668. 				<td align=right>
    1669. 

  1669. 					<font face="arial,helvetica" size=-1><span><b>
    1670. 

  1670. 					Enable Email:<br>
    1671. 

  1671. 					</span></b></font>
    1672. 

  1672. 					</td>
    1673. 

  1673. 					<td align=left>
    1674. 

  1674. 					<table border=0 cellspacing=0 cellpadding=0>
    1675. 

  1675. 						<tr>
    1676. 

  1676. 							<td><select name="shem"><option value=1>For Everyone<option value=0 SELECTED>Only For Administrators</td>
    1677. 

  1677. 						</tr>
    1678. 

  1678. 					</table>
    1679. 

  1679. 				</td>
    1680. 

  1680. 			</tr>
    1681. 

  1681. 			</table>
    1682. 

  1682. 

  1683. 			</td></tr></table>
    1684. 

  1684. 			</td></tr></table>
    1685. 

  1685. 

  1686. 			</center>
    1687. 

  1687. 

  1688. 			<p>
    1689. 

  1689. 

  1690. 			<table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    1691. 

  1691. 			<tr>
    1692. 

  1692. 				<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    1693. 

  1693. 				<td width = "100%" bgcolor = "#05374A"><b class = "white">Forum Settings:</b></td>
    1694. 

  1694. 				<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    1695. 

  1695. 			</tr>
    1696. 

  1696. 			</table>
    1697. 

  1697. 

  1698. 			<center>
    1699. 

  1699. 			<a name = "phone"></a>
    1700. 

  1700. 			<table width = "450" style = "border-width: 1px; border-style: dotted; border-color: #928058;">
    1701. 

  1701. 				<tr>
    1702. 

  1702. 					<td>
    1703. 

  1703. 						<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');">
    1704. 

  1704. 							<tr>
    1705. 

  1705. 								<td>
    1706. 

  1706. 									<table border=0 cellspacing=0 cellpadding=4 width = "100%">
    1707. 

  1707. 										<tr>
    1708. 

  1708. 											<td width=150 align=right>
    1709. 

  1709. 												<font face="arial,helvetica" size=-1><span><b>
    1710. 

  1710. 												 <font color="#FF0000">*</font> Display Name:<br>
    1711. 

  1711. 												</span></b></font>
    1712. 

  1712. 												</td>
    1713. 

  1713. 												<td align=left>
    1714. 

  1714. 												<table border=0 cellspacing=0 cellpadding=0>
    1715. 

  1715. 													<tr>
    1716. 

  1716. 														<td><input type=text name="nick" maxlength="16"></td>
    1717. 

  1717. 													</tr>
    1718. 

  1718. 												</table>
    1719. 

  1719. 											</td>
    1720. 

  1720. 										</tr>
    1721. 

  1721. 										<tr>
    1722. 

  1722. 											<td align=right>
    1723. 

  1723. 												<font face="arial,helvetica" size=-1><span><b>
    1724. 

  1724. 												Birthday:<br>
    1725. 

  1725. 												</span></b></font>
    1726. 

  1726. 												</td>
    1727. 

  1727. 												<td align=left>
    1728. 

  1728. 												<table border=0 cellspacing=0 cellpadding=0>
    1729. 

  1729. 													<tr>
    1730. 

  1730. 														<td><input type=text name="bd" maxlength="10"></td><td>&nbsp;<span>(dd/mm/yyyy)</span></td>
    1731. 

  1731. 													</tr>
    1732. 

  1732. 												</table>
    1733. 

  1733. 											</td>
    1734. 

  1734. 										</tr>
    1735. 

  1735. 										<tr>
    1736. 

  1736. 											<td align=right>
    1737. 

  1737. 												<font face="arial,helvetica" size=-1><span><b>
    1738. 

  1738. 												Show Birthday:<br>
    1739. 

  1739. 												</span></b></font>
    1740. 

  1740. 												</td>
    1741. 

  1741. 												<td align=left>
    1742. 

  1742. 												<table border=0 cellspacing=0 cellpadding=0>
    1743. 

  1743. 													<tr>
    1744. 

  1744. 														<td><select name="shbd"><option value=3>Date (dd/mm/yyyy), Age (X years)<option value=1>Date (dd/mm/yyyy)<option value=2 SELECTED>Age (X years)<option value=0>No</td>
    1745. 

  1745. 													</tr>
    1746. 

  1746. 												</table>
    1747. 

  1747. 											</td>
    1748. 

  1748. 										</tr>
    1749. 

  1749. 										<tr>
    1750. 

  1750. 											<td align=right>
    1751. 

  1751. 												<font face="arial,helvetica" size=-1><span><b>
    1752. 

  1752. 												Gender:<br>
    1753. 

  1753. 												</span></b></font>
    1754. 

  1754. 												</td>
    1755. 

  1755. 												<td align=left>
    1756. 

  1756. 												<table border=0 cellspacing=0 cellpadding=0>
    1757. 

  1757. 													<tr>
    1758. 

  1758. 														<td><select name="gender"><option value=0>Female<option value=1 SELECTED>Male
    1759. 

  1759. 													</tr>
    1760. 

  1760. 												</table>
    1761. 

  1761. 											</td>
    1762. 

  1762. 										</tr>
    1763. 

  1763. 										<tr>
    1764. 

  1764. 											<td align=right>
    1765. 

  1765. 												<font face="arial,helvetica" size=-1><span><b>
    1766. 

  1766. 												Time Zone (GMT):<br>
    1767. 

  1767. 												</span></b></font>
    1768. 

  1768. 												</td>
    1769. 

  1769. 												<td align=left >
    1770. 

  1770. 												<table border=0 cellspacing=0 cellpadding=0>
    1771. 

  1771. 													<tr>
    1772. 

  1772. 														<td><select name="gmt" style="width: 250;"> 
    1773. 

  1773. <?php
    1774. 

  1774. for($i=-12;$i<count($GMT)-12;$i++) {
    1775. 

  1775. 	echo '<option value="'.$i.'">(GMT '.$GMT[$i][0].') '.$GMT[$i][1].'</option>';
    1776. 

  1776. }
    1777. 

  1777. ?>
    1778. 

  1778. 														</select></td>
    1779. 

  1779. 				<script type="text/javascript">
    1780. 

  1780. 						document.siteadmin.gmt.value='<?php echo $SETTING['WEB_GMT']; ?>';
    1781. 

  1781. 				</script>
    1782. 

  1782. 												</selected>
    1783. 

  1783. 													</td>
    1784. 

  1784. 													</tr>
    1785. 

  1785. 												</table>
    1786. 

  1786. 											</td>
    1787. 

  1787. 										</tr>
    1788. 

  1788. 										<tr>
    1789. 

  1789. 											<td align=right>
    1790. 

  1790. 												<font face="arial,helvetica" size=-1><span><b>
    1791. 

  1791. 												Enable Private Messages:<br>
    1792. 

  1792. 												</span></b></font>
    1793. 

  1793. 												</td>
    1794. 

  1794. 												<td align=left>
    1795. 

  1795. 												<table border=0 cellspacing=0 cellpadding=0>
    1796. 

  1796. 													<tr>
    1797. 

  1797. 														<td><select name="shpm"><option value=1 SELECTED>From Everyone<option value=0>Only From Administrators
    1798. 

  1798. 													</tr>
    1799. 

  1799. 												</table>
    1800. 

  1800. 											</td>
    1801. 

  1801. 										</tr>
    1802. 

  1802. 										<tr>
    1803. 

  1803. 											<td align=right>
    1804. 

  1804. 												<font face="arial,helvetica" size=-1><span><b>
    1805. 

  1805. 												MSN:<br>
    1806. 

  1806. 												</span></b></font>
    1807. 

  1807. 												</td>
    1808. 

  1808. 												<td align=left>
    1809. 

  1809. 												<table border=0 cellspacing=0 cellpadding=0>
    1810. 

  1810. 													<tr>
    1811. 

  1811. 														<td><input type=text name="msn"></td><td>&nbsp;<img src="new-hp/images/im/im_msn.gif"></td>
    1812. 

  1812. 													</tr>
    1813. 

  1813. 												</table>
    1814. 

  1814. 											</td>
    1815. 

  1815. 										</tr>
    1816. 

  1816. 										<tr>
    1817. 

  1817. 											<td align=right>
    1818. 

  1818. 												<font face="arial,helvetica" size=-1><span><b>
    1819. 

  1819. 												Skype:<br>
    1820. 

  1820. 												</span></b></font>
    1821. 

  1821. 												</td>
    1822. 

  1822. 												<td align=left>
    1823. 

  1823. 												<table border=0 cellspacing=0 cellpadding=0>
    1824. 

  1824. 													<tr>
    1825. 

  1825. 														<td><input type=text name="skype"></td><td>&nbsp;<img src="new-hp/images/im/im_skype.gif"></td>
    1826. 

  1826. 													</tr>
    1827. 

  1827. 												</table>
    1828. 

  1828. 											</td>
    1829. 

  1829. 										</tr>
    1830. 

  1830. 										<tr>
    1831. 

  1831. 											<td align=right>
    1832. 

  1832. 												<font face="arial,helvetica" size=-1><span><b>
    1833. 

  1833. 												ICQ:<br>
    1834. 

  1834. 												</span></b></font>
    1835. 

  1835. 												</td>
    1836. 

  1836. 												<td align=left>
    1837. 

  1837. 												<table border=0 cellspacing=0 cellpadding=0>
    1838. 

  1838. 													<tr>
    1839. 

  1839. 														<td><input type=text name="icq"></td><td>&nbsp;<img src="new-hp/images/im/im_icq.gif"></td>
    1840. 

  1840. 													</tr>
    1841. 

  1841. 												</table>
    1842. 

  1842. 											</td>
    1843. 

  1843. 										</tr>
    1844. 

  1844. 										<tr>
    1845. 

  1845. 											<td align=right>
    1846. 

  1846. 												<font face="arial,helvetica" size=-1><span><b>
    1847. 

  1847. 												AIM:<br>
    1848. 

  1848. 												</span></b></font>
    1849. 

  1849. 												</td>
    1850. 

  1850. 												<td align=left>
    1851. 

  1851. 												<table border=0 cellspacing=0 cellpadding=0>
    1852. 

  1852. 													<tr>
    1853. 

  1853. 														<td><input type=text name="aim"></td><td>&nbsp;<img src="new-hp/images/im/im_aim.gif"></td>
    1854. 

  1854. 													</tr>
    1855. 

  1855. 												</table>
    1856. 

  1856. 											</td>
    1857. 

  1857. 										</tr>
    1858. 

  1858. 										<tr>
    1859. 

  1859. 											<td align=right>
    1860. 

  1860. 												<font face="arial,helvetica" size=-1><span><b>
    1861. 

  1861. 												Yahoo:<br>
    1862. 

  1862. 												</span></b></font>
    1863. 

  1863. 												</td>
    1864. 

  1864. 												<td align=left >
    1865. 

  1865. 												<table border=0 cellspacing=0 cellpadding=0>
    1866. 

  1866. 													<tr>
    1867. 

  1867. 														<td><input type=text name="yahoo"></td><td>&nbsp;<img src="new-hp/images/im/im_yahoo.gif"></td>
    1868. 

  1868. 													</tr>
    1869. 

  1869. 												</table>
    1870. 

  1870. 											</td>
    1871. 

  1871. 										</tr>
    1872. 

  1872. 										<tr>
    1873. 

  1873. 											  <td align=left>
    1874. 

  1874. 											  <font face="arial,helvetica" size=-1><span><b>
    1875. 

  1875. 											  </span></b></font> </td>
    1876. 

  1876. 											  <td align=left><table border=0 cellspacing=0 cellpadding=0><tr><td>
    1877. 

  1877. 											  <?php bbcode_toolbar('siteadmin.sig'); ?>
    1878. 

  1878. 											  </td><td valign = "top">
    1879. 

  1879. 											   </td></tr></table></td>
    1880. 

  1880. 										</tr>
    1881. 

  1881. 										<tr>
    1882. 

  1882. 											<td align=right valign=top >
    1883. 

  1883. 												<font face="arial,helvetica" size=-1><span><b>
    1884. 

  1884. 												Signature:<br>
    1885. 

  1885. 												</span></b></font>
    1886. 

  1886. 												</td>
    1887. 

  1887. 												<td align=left >
    1888. 

  1888. 												<table border=0 cellspacing=0 cellpadding=0>
    1889. 

  1889. 													<tr>
    1890. 

  1890. 														<td><textarea rows=4 name="sig" cols=40><?php if ($haserrors!='') { echo $_POST['sig']; } else { echo $rowa['signature']; } ?></textarea></td>
    1891. 

  1891. 													</tr>
    1892. 

  1892. 												</table>
    1893. 

  1893. 											</td>
    1894. 

  1894. 										</tr>
    1895. 

  1895. 										<tr>
    1896. 

  1896. 											<td align=right >
    1897. 

  1897. 												<font face="arial,helvetica" size=-1><span><b>
    1898. 

  1898. 												Home Page URL:<br>
    1899. 

  1899. 												</span></b></font>
    1900. 

  1900. 												</td>
    1901. 

  1901. 												<td align=left >
    1902. 

  1902. 												<table border=0 cellspacing=0 cellpadding=0>
    1903. 

  1903. 													<tr>
    1904. 

  1904. 														<td><input type=text size=40 name="weburl"></td>
    1905. 

  1905. 													</tr>
    1906. 

  1906. 												</table>
    1907. 

  1907. 											</td>
    1908. 

  1908. 										</tr>
    1909. 

  1909. 										<tr>
    1910. 

  1910. 										  <td  align=right>
    1911. 

  1911. 										  <font face="arial,helvetica" size=-1><span><b>
    1912. 

  1912. 										  Skin:<br>
    1913. 

  1913. 										  </span></b></font>
    1914. 

  1914. 										  </td>
    1915. 

  1915. 										  <td 60% align=left>
    1916. 

  1916. 										  <table border=0 cellspacing=0 cellpadding=0>
    1917. 

  1917. 											<tr>
    1918. 

  1918. 												<td><select name="skin" OnChange="javascript:changelayout(this.value);">
    1919. 

  1919. 												<option value="" SELECTED>Default
    1920. 

  1920. 												<?php
    1921. 

  1921. 													foreach (glob('new-hp/templates/*', GLOB_ONLYDIR) as $tempname) {
    1922. 

  1922. 														if (file_exists($tempname.'/layout.css') and (stristr($tempname, 'forum')==false)) {
    1923. 

  1923. 															$tempname = str_replace(dirname($tempname).'/','',$tempname);
    1924. 

  1924. 															echo '<option value="'.$tempname.'">'.$tempname;
    1925. 

  1925. 														}
    1926. 

  1926. 													}
    1927. 

  1927. 												?>
    1928. 

  1928. 												</select>
    1929. 

  1929. 													
    1930. 

  1930. 														</td>
    1931. 

  1931. 													</tr>
    1932. 

  1932. 												  </table>
    1933. 

  1933. 											  </td>
    1934. 

  1934. 										</tr>
    1935. 

  1935. 									</table>
    1936. 

  1936. 								</td>
    1937. 

  1937. 							</tr>
    1938. 

  1938. 						</table>
    1939. 

  1939. 					</td>
    1940. 

  1940. 				</tr>
    1941. 

  1941. 			</table>
    1942. 

  1942. 	<p>
    1943. 

  1943. 	<input onclick="javascript:document.siteadmin.step.value='save';" type=image SRC="shared/wow-com/images/buttons/update-button.gif" name="Submit" alt="Update" Width="174" Height="46" Border=0 class="button"  taborder=7 >
    1944. 

  1944. 	<p>
    1945. 

  1945. <style type="text/css">
    1946. 

  1946. #character-post-info { display: table; padding: 10px; border: 1px dashed #252525; text-align: center; background: url('new-hp/images/forum/back.png') repeat 0 0; margin: 0 auto; width: 567px; }
    1947. 

  1947. #talent-input { display: table; width: 400px; padding: 0; margin: 0; text-align: left; }
    1948. 

  1948. table#dlcharacters { border: 1px solid black; border-collapse: collapse; }
    1949. 

  1949. small.smallBold { color: #fff; font-size: 8pt; font-weight: bold; }
    1950. 

  1950. .avatarselect { margin: 0; width: 82px; }
    1951. 

  1951. .avatarselect .shell { position: relative; margin: 10px auto; width: 64px; height: 64px; }
    1952. 

  1952. .avatarselect .frame  { position: absolute; background: url('new-hp/images/forum/portrait-frame.gif') no-repeat; width: 82px; height: 83px; top: -8px; left: -8px; z-index: 200; }
    1953. 

  1953. .avatarselect .iconPosition { position: absolute; top: -22px; right: 2px; width: 24px; text-align: center; color: #FFD823; z-index: 300; }
    1954. 

  1954. table.charselectborder { border: 1px solid #4C4C4C; }
    1955. 

  1955. span.mine { color: #a0a1a3; }
    1956. 

  1956. a:link.mine, a:hover.mine, a:visited.mine, a.mine { color: orange; font-weight: bold; }
    1957. 

  1957. small.mine { color: white; }
    1958. 

  1958. div.framenochar { position: absolute; background: url('new-hp/images/forum/portraits/no-character-icon.gif') no-repeat; width: 82px; height: 83px; top: -8px; left: -8px; z-index: 200; }
    1959. 

  1959. div.framenocharblizz { position: absolute; background: url('new-hp/images/forum/portraits/no-character-icon-blizz.gif') no-repeat; width: 82px; height: 83px; top: -8px; left: -8px; z-index: 200; }
    1960. 

  1960. </style>
    1961. 

  1961. <!--[if lte IE 6]>
    1962. 

  1962. <style type="text/css">
    1963. 

  1963. .avatarselect .shell { left: 10px; }
    1964. 

  1964. </style>
    1965. 

  1965. <![endif]-->
    1966. 

  1966. 			<table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    1967. 

  1967. 			<tr>
    1968. 

  1968. 				<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    1969. 

  1969. 				<td width = "100%" bgcolor = "#05374A"><b class = "white">Forum Avatar:</b></td>
    1970. 

  1970. 				<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    1971. 

  1971. 			</tr>
    1972. 

  1972. 			</table>
    1973. 

  1973. 			<table width = "450" style = "border-width: 1px; border-style: dotted; border-color: #928058;">
    1974. 

  1974. 				<tr>
    1975. 

  1975. 					<td>
    1976. 

  1976. 						<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');">
    1977. 

  1977. 							<tr>
    1978. 

  1978. 								<td>
    1979. 

  1979. 									<table border=0 cellspacing=0 cellpadding=4 width = "100%">
    1980. 

  1980. 										<tr>
    1981. 

  1981. 											<td width=50% align=left>
    1982. 

  1982. 		<?php
    1983. 

  1983. 			$splitline=2;
    1984. 

  1984. 			$charset[0]=$rowa['displayname'];
    1985. 

  1985. 			$upname[0] = 'siteadmin';
    1986. 

  1986. 			$imgset[0] = 'nochar';
    1987. 

  1987. 			if ($rowa['id_account']==$SETTING['SERVER_OWNER']) { $rowa['gmlevel']=4; }
    1988. 

  1988. 			if ($rowa['gmlevel']>0) { $imgset[1] = $rowa['gmlevel']; } else if ($rowa['ismvp']=='1') { $imgset[1] = 'mvp'; }
    1989. 

  1989. 			
    1990. 

  1990. 			$upname[1] = 'nochar';
    1991. 

  1991. 			if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }
    1992. 

  1992. 		    charavatar($charset, $imgset, $upname);
    1993. 

  1993. 			echo '</td>';
    1994. 

  1994. 			
    1995. 

  1995. 			mysql_select_db ($MySQL_Set['DBREALM'], $MySQL_CON);
    1996. 

  1996. 			$qquery = mysql_query("SELECT *, rs.dbhost as rsdbhost, rs.dbport as rsdbport,rs.dbuser as rsdbuser,
    1997. 

  1997. 			rs.dbpass as rsdbpass,rs.dbname as rsdbname FROM `realmlist` r LEFT JOIN (`realm_settings` rs) ON r.id = rs.id_realm 
    1998. 

  1998. 			GROUP BY r.id ORDER BY r.name", $MySQL_CON) OR DIE(mysql_error());
    1999. 

  1999. 			$i=1;
    2000. 

  2000. 			while ($rowx = mysql_fetch_array($qquery)) {
    2001. 

  2001. 				$newcon = @mysql_connect($rowx['rsdbhost'].':'.$rowx['rsdbport'], $rowx['rsdbuser'], $rowx['rsdbpass']);;
    2002. 

  2002. 				$newdb = @mysql_select_db ($rowx['rsdbname'], $newcon);
    2003. 

  2003. 				$newquery = @mysql_query("SELECT guid, name, data, class, race FROM `characters` WHERE `account`='".$rowa['id_account']."'", $newcon);
    2004. 

  2004. 					while($rowc = @mysql_fetch_array($newquery)) {
    2005. 

  2005. 						if (is_int($i/$splitline)) { echo '</tr><tr>'; }
    2006. 

  2006. 						echo '<td align=left>';
    2007. 

  2007. 						$rowc['data'] = explode(' ',$rowc['data']);		
    2008. 

  2008. 						$char_gender = str_pad(dechex($rowc['data'][36]),8, 0, STR_PAD_LEFT);
    2009. 

  2009. 						$char_gender = $char_gender{3};		
    2010. 

  2010. 						$charset[0]=$rowc['name'];
    2011. 

  2011. 						$charset[1]=$rowc['data'][34];
    2012. 

  2012. 						$charset[2]=$rowc['race'];
    2013. 

  2013. 						$charset[3]=$char_gender;
    2014. 

  2014. 						$charset[4]=$rowc['class'];
    2015. 

  2015. 						$charset[5]=$rowx['name'];
    2016. 

  2016. 						$upname[1] = $rowc['guid'].'/'.$rowx['id'];
    2017. 

  2017. 						if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }
    2018. 

  2018. 						charavatar($charset, '', $upname);
    2019. 

  2019. 						echo '</td>';
    2020. 

  2020. 						$i++;
    2021. 

  2021. 					}
    2022. 

  2022. 			}
    2023. 

  2023. 			if ($rowa['gmlevel']>0) {
    2024. 

  2024. 				foreach (glob('new-hp/images/forum/portraits/gm/*.gif') as $tempname) {
    2025. 

  2025. 					if (is_int($i/$splitline)) { echo '</tr><tr>'; }
    2026. 

  2026. 					echo '<td align=left>';
    2027. 

  2027. 					$charset[0]=$rowa['displayname'];
    2028. 

  2028. 					$imgset[0] = str_replace('new-hp/images/forum/portraits/', '', $tempname);
    2029. 

  2029. 					$upname[1] = $imgset[0];
    2030. 

  2030. 					if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }
    2031. 

  2031. 					charavatar($charset, $imgset, $upname);
    2032. 

  2032. 					echo '</td>';
    2033. 

  2033. 					$i++;
    2034. 

  2034. 				}
    2035. 

  2035. 			}
    2036. 

  2036. 			if ($rowa['ismvp']=='1') { 
    2037. 

  2037. 				foreach (glob('new-hp/images/forum/portraits/mvp/*.gif') as $tempname) {
    2038. 

  2038. 					if (is_int($i/$splitline)) { echo '</tr><tr>'; }
    2039. 

  2039. 					echo '<td align=left>';
    2040. 

  2040. 					$charset[0]=$rowa['displayname'];
    2041. 

  2041. 					$imgset[0] = str_replace('new-hp/images/forum/portraits/', '', $tempname);
    2042. 

  2042. 					$upname[1] = $imgset[0];
    2043. 

  2043. 					if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }
    2044. 

  2044. 					charavatar($charset, $imgset, $upname);
    2045. 

  2045. 					echo '</td>';
    2046. 

  2046. 					$i++;
    2047. 

  2047. 				}
    2048. 

  2048. 			}
    2049. 

  2049. 		?>
    2050. 

  2050. 													</tr>
    2051. 

  2051. 												  </table>
    2052. 

  2052. 											  </td>
    2053. 

  2053. 										</tr>
    2054. 

  2054. 									</table>
    2055. 

  2055. 								</td>
    2056. 

  2056. 							</tr>
    2057. 

  2057. 						</table>
    2058. 

  2058. 			
    2059. 

  2059. 		<?php if ($_SERVER['REQUEST_METHOD']!='POST') { ?>
    2060. 

  2060. 			<script>
    2061. 

  2061. 			document.siteadmin.ask.value='<?php echo $rowa['passask']; ?>';
    2062. 

  2062. 			document.siteadmin.ans.value='<?php echo $rowa['passans']; ?>';
    2063. 

  2063. 			document.siteadmin.uptbc.checked=<?php echo $rowa['expansion']; ?>;
    2064. 

  2064. 			void(document.siteadmin.fname.value='<?php echo $rowa['fname']; ?>');
    2065. 

  2065. 			void(document.siteadmin.lname.value='<?php echo $rowa['lname']; ?>');
    2066. 

  2066. 			void(document.siteadmin.city.value='<?php echo $rowa['city']; ?>');
    2067. 

  2067. 			void(document.siteadmin.lo.value='<?php echo $rowa['location']; ?>');
    2068. 

  2068. 			<?php if ($rowa['bday']!='00/00/0000') { ?>void(document.siteadmin.bd.value='<?php echo $rowa['bday']; ?>'); <? } 
    2069. 

  2069. 			if ($getbanned['id']!='' AND $rowa['gmlevel']==0) { 
    2070. 

  2070. 				if ($rowa['activation']!='') { 
    2071. 

  2071. 					echo "document.siteadmin.accstatus.value='2';"; 
    2072. 

  2072. 				} else { 
    2073. 

  2073. 					echo "document.siteadmin.accstatus.value='1';"; 
    2074. 

  2074. 				} 
    2075. 

  2075. 			} else if ($rowa['id_account']!=$_SESSION['userid'] AND $rowa['gmlevel']==0) { 
    2076. 

  2076. 				echo "document.siteadmin.accstatus.value='0';"; 
    2077. 

  2077. 			} ?>
    2078. 

  2078. 			void(document.siteadmin.shbd.value='<?php echo $rowa['showbday']; ?>');
    2079. 

  2079. 			void(document.siteadmin.cflag.src = 'new-hp/images/flags/' + document.siteadmin.lo.value + '.gif');
    2080. 

  2080. 			void(document.siteadmin.gmt.value='<?php echo $rowa['gmt']; ?>');
    2081. 

  2081. 			void(document.siteadmin.shlo.value='<?php echo $rowa['showlocation']; ?>');
    2082. 

  2082. 			void(document.siteadmin.shem.value='<?php echo $rowa['enableemail']; ?>');
    2083. 

  2083. 			void(document.siteadmin.em.value='<?php echo $rowa['email']; ?>');
    2084. 

  2084. 			void(document.siteadmin.shpm.value='<?php echo $rowa['enablepm']; ?>');
    2085. 

  2085. 			void(document.siteadmin.msn.value='<?php echo $rowa['msn']; ?>');
    2086. 

  2086. 			void(document.siteadmin.skype.value='<?php echo $rowa['skype']; ?>');
    2087. 

  2087. 			void(document.siteadmin.aim.value='<?php echo $rowa['aim']; ?>');
    2088. 

  2088. 			void(document.siteadmin.icq.value='<?php echo $rowa['icq']; ?>');
    2089. 

  2089. 			void(document.siteadmin.yahoo.value='<?php echo $rowa['yahoo']; ?>');
    2090. 

  2090. 			void(document.siteadmin.weburl.value='<?php echo $rowa['weburl']; ?>');
    2091. 

  2091. 			void(document.siteadmin.skin.value='<?php echo $rowa['template']; ?>');
    2092. 

  2092. 			void(document.siteadmin.nick.value='<?php echo $rowa['displayname']; ?>');
    2093. 

  2093. 			void(document.siteadmin.gender.value='<?php echo $rowa['gender']; ?>');
    2094. 

  2094. 			void(document.siteadmin.lockacc.value='<?php echo $rowa['locked']; ?>');
    2095. 

  2095. 			void(document.siteadmin.lockip.value='<?php echo $rowa['last_ip']; ?>');
    2096. 

  2096. 			<?php if ($rowa['gmlevel']==0) { ?>void(document.siteadmin.accmvp.value='<?php echo $rowa['ismvp']; ?>'); <? } ?>
    2097. 

  2097. 			</script>
    2098. 

  2098. 		<?php
    2099. 

  2099. 		} else {
    2100. 

  2100. 		?>
    2101. 

  2101. 			<script>
    2102. 

  2102. 			document.siteadmin.ask.value='<?php echo $_POST['ask']; ?>';
    2103. 

  2103. 			document.siteadmin.ans.value='<?php echo $_POST['ans']; ?>';
    2104. 

  2104. 			document.siteadmin.uptbc.checked=<?php echo $_POST['uptbc']; ?>;
    2105. 

  2105. 			document.siteadmin.lname.value='<?php echo $_POST['lname']; ?>';
    2106. 

  2106. 			document.siteadmin.fname.value='<?php echo $_POST['fname']; ?>';
    2107. 

  2107. 			document.siteadmin.city.value='<?php echo $_POST['city']; ?>';
    2108. 

  2108. 			document.siteadmin.lo.value='<?php echo $_POST['lo']; ?>';
    2109. 

  2109. 			document.siteadmin.shbd.value='<?php echo $_POST['shbd']; ?>';
    2110. 

  2110. 			document.siteadmin.cflag.src = 'new-hp/images/flags/' + document.siteadmin.lo.value + '.gif';
    2111. 

  2111. 			document.siteadmin.gmt.value='<?php echo $_POST['gmt']; ?>';
    2112. 

  2112. 			document.siteadmin.shlo.value='<?php echo $_POST['shlo']; ?>';
    2113. 

  2113. 			document.siteadmin.em.value='<?php echo $_POST['em']; ?>';
    2114. 

  2114. 			document.siteadmin.shem.value='<?php echo $_POST['shem']; ?>';
    2115. 

  2115. 			document.siteadmin.shpm.value='<?php echo $_POST['shpm']; ?>';
    2116. 

  2116. 			document.siteadmin.nick.value='<?php echo $_POST['nick']; ?>';
    2117. 

  2117. 			document.siteadmin.bd.value='<?php echo $_POST['bd']; ?>';
    2118. 

  2118. 			document.siteadmin.msn.value='<?php echo $_POST['msn']; ?>';
    2119. 

  2119. 			document.siteadmin.skype.value='<?php echo $_POST['skype']; ?>';
    2120. 

  2120. 			document.siteadmin.aim.value='<?php echo $_POST['aim']; ?>';
    2121. 

  2121. 			document.siteadmin.icq.value='<?php echo $_POST['icq']; ?>';
    2122. 

  2122. 			document.siteadmin.yahoo.value='<?php echo $_POST['yahoo']; ?>';
    2123. 

  2123. 			document.siteadmin.weburl.value='<?php echo $_POST['weburl']; ?>';
    2124. 

  2124. 			document.siteadmin.skin.value='<?php echo $_POST['skin']; ?>';
    2125. 

  2125. 			<?php if ($rowa['gmlevel']=='0') { ?>document.siteadmin.accstatus.value='<?php echo $_POST['accstatus']; ?>';<?php } ?>
    2126. 

  2126. 			void(document.siteadmin.gender.value='<?php echo $_POST['gender']; ?>');
    2127. 

  2127. 			void(document.siteadmin.lockacc.value='<?php echo $_POST['lockacc']; ?>');
    2128. 

  2128. 			void(document.siteadmin.lockip.value='<?php echo $_POST['lockip']; ?>');
    2129. 

  2129. 			<?php if ($rowa['gmlevel']==0) { ?>document.siteadmin.accmvp.value='<?php echo $_POST['accmvp']; ?>';<? } ?>
    2130. 

  2130. 			</script>
    2131. 

  2131. 			<?php
    2132. 

  2132. 			}
    2133. 

  2133. 		} else {
    2134. 

  2134. 		?>
    2135. 

  2135. 		<table cellspacing = "0" cellpadding = "0" border = "0" width = 450>
    2136. 

  2136. 				<tr>
    2137. 

  2137. 					<td width = "24"><img src = "shared/wow-com/images/headers/subheader/subheader-left-sword.gif" width = "24" height = "20"></td>
    2138. 

  2138. 					<td width = 450 bgcolor = "#05374A"><b class = "white">Ghost Account Info:</b></td>
    2139. 

  2139. 					<td width = "10"><img src = "shared/wow-com/images/headers/subheader/subheader-right.gif" width = "10" height = "20"></td>
    2140. 

  2140. 				</tr>
    2141. 

  2141. 				</table>
    2142. 

  2142. 				<table width = 450 style = "border-width: 1px; border-style: dotted; border-color: #928058;"><tr><td>
    2143. 

  2143. 				<table width = 100% style = "border-width: 1px; border-style: solid; border-color: black; background-image: url('new-hp/images/layout/parch-light2.jpg');"><tr><td>
    2144. 

  2144. 				<table border=0 cellspacing=0 cellpadding=4>
    2145. 

  2145. 					<tr>
    2146. 

  2146. 						<td width=150 align=right>
    2147. 

  2147. 							<font face="arial,helvetica" size=-1><span><b>
    2148. 

  2148. 							 <font color="#FF0000">*</font> Display Name:<br>
    2149. 

  2149. 							</span></b></font>
    2150. 

  2150. 							</td>
    2151. 

  2151. 							<td align=left>
    2152. 

  2152. 							<table border=0 cellspacing=0 cellpadding=0>
    2153. 

  2153. 								<tr>
    2154. 

  2154. 									<td><input type=text name="nick" maxlength="16"></td>
    2155. 

  2155. 								</tr>
    2156. 

  2156. 							</table>
    2157. 

  2157. 						</td>
    2158. 

  2158. 					</tr>
    2159. 

  2159. 					<tr>
    2160. 

  2160. 				  <td align=right NOWRAP><span><b>Delete Account:</b></span></td>
    2161. 

  2161. 																		  
    2162. 

  2162. 					  <td align=left NOWRAP>
    2163. 

  2163. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td>
    2164. 

  2164. 					  <select name="deleteacc">
    2165. 

  2165. 						<option value="1">Yes
    2166. 

  2166. 						<option value="0" SELECTED>No
    2167. 

  2167. 					  </select>
    2168. 

  2168. 					  </td><td valign = "top">
    2169. 

  2169. 				   </td></tr></table>
    2170. 

  2170. 			</tr>
    2171. 

  2171. 				</table>
    2172. 

  2172. 		</td></tr></table></td></tr></table>	
    2173. 

  2173. 	<p>
    2174. 

  2174. 	<input onclick="javascript:document.siteadmin.step.value='save';" type=image SRC="shared/wow-com/images/buttons/update-button.gif" name="Submit" alt="Update" Width="174" Height="46" Border=0 class="button"  taborder=7 >
    2175. 

  2175. 	<p>
    2176. 

  2176. 		<?php if ($haserrors=="") { ?>
    2177. 

  2177. 			<script>
    2178. 

  2178. 			void(document.siteadmin.nick.value='<?php echo $rowa['displayname']; ?>');
    2179. 

  2179. 			</script>
    2180. 

  2180. 			<?php
    2181. 

  2181. 			} else {
    2182. 

  2182. 			?>
    2183. 

  2183. 			<script>
    2184. 

  2184. 			document.siteadmin.nick.value='<?php echo $_POST['nick']; ?>';
    2185. 

  2185. 			</script>
    2186. 

  2186. 			<?php
    2187. 

  2187. 			}
    2188. 

  2188. 		} ?>
    2189. 

  2189. 			</center>
    2190. 

  2190. 	</form>
    2191. 

  2191. <?php
    2192. 

  2192. 			}
    2193. 

  2193. 		} else {
    2194. 

  2194. 			errborder('Account do NOT exists.');
    2195. 

  2195. 		}
    2196. 

  2196. 

  2197. 	}
    2198. 

  2198. 	
    2199. 

  2199. }
    2200. 

  2200. 

  2201. 

  2202. 

  2203. ?>
    2204.