PageRenderTime 77ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 1ms

/inc/admin/admin.accounts.php

https://bitbucket.org/celtus/webow-oc
PHP | 2189 lines | 2128 code | 59 blank | 2 comment | 68 complexity | 016c75559a8a8ed51d34c59b4e71b6d5 MD5 | raw file
    

  1. <?php

    2. 

  2. 

    3. 

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

    4. 

  4. 

    5. 

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

    6. 

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

    7. 

  7. 

    8. 

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

    9. 

  9. 	case "ipban":

    10. 

  10. 	

    11. 

  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. 

  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. 

  48. 

    49. 

  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. 

  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. 

  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. 

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

    102. 

  102. 

    103. 

  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. 

  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. 

  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. 

  227. </form>

    228. 

  228. <?php

    229. 

  229. }

    230. 

  230. 	break;

    231. 

  231. 	case "priviledges":

    232. 

  232. 

    233. 

  233. ?>

    234. 

  234. 			<?php

    235. 

  235. 

    236. 

  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. 

  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. 

  344. <?php

    345. 

  345. 

    346. 

  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. 

  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. 

  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. 

  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 `character` 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 `character`) 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 item_guid 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 item_guid NOT IN (SELECT guid FROM `item_instance`) AND item_guid!=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. 

  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. 

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

    748. 

  748. 

    749. 

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

    750. 

  750. 

    751. 

  751. 		parchdown();

    752. 

  752. 		

    753. 

  753. 		parchup(true);

    754. 

  754. 

    755. 

  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. 

  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. 

  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. 

  839. parchdown();

    840. 

  840. 

    841. 

  841. parchup(true);

    842. 

  842. 

    843. 

  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. 

  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. 

  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 `character` 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. 

  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. 

  956. }

    957. 

  957. 

    958. 

  958. ?>

    959. 

  959. 			</table>

    960. 

  960. 

    961. 

  961. <?php

    962. 

  962. 

    963. 

  963. metalborderdown();

    964. 

  964. 

    965. 

  965. echo $pages;

    966. 

  966. 

    967. 

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

    968. 

  968. 

    969. 

  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.I 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. 

  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 `character` 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 `character`) 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 item_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 item_guid NOT IN (SELECT guid FROM `item_instance`) AND item_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']."', I='".$_POST['p']."', tbc='".$_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. 

  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. 

  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. 

  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. 

  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. 

  1348. } else {

    1349. 

  1349. 

    1350. 

  1350. 	echo 'No records were found';

    1351. 

  1351. 

    1352. 

  1352. }

    1353. 

  1353. 

    1354. 

  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. 

  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. 

  1406. 			<tr>

    1407. 

  1407. 

    1408. 

  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. 

  1413. 

    1414. 

  1414. 				   </td></tr></table>

    1415. 

  1415. 				  </td>

    1416. 

  1416. 				  

    1417. 

  1417. 

    1418. 

  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. 

  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. 

  1435. 

    1436. 

  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. 

  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. 

  1455. 					</td><td valign = "top">

    1456. 

  1456. 

    1457. 

  1457. 				   </td></tr></table>

    1458. 

  1458. 

    1459. 

  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>Upgrades:</b></span></td>

    1470. 

  1470. 																		  

    1471. 

  1471. 					  <td align=left NOWRAP>

    1472. 

  1472. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td><label for='upgtbc'><input type=checkbox value='1' id="upgtbc" name="uptbc" CHECKED><span style="font-size: 13px;">The Burning Crusade</label></td><td valign = "top">

    1473. 

  1473. 				   </td></tr></table>

    1474. 

  1474. 			</tr>

    1475. 

  1475. 			</table>

    1476. 

  1476. 	</td>

    1477. 

  1477. </tr>

    1478. 

  1478. </table>

    1479. 

  1479. 			</td>

    1480. 

  1480. 		</tr>

    1481. 

  1481. 	</table>

    1482. 

  1482. 	<p>

    1483. 

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

    1484. 

  1484. 			<tr>

    1485. 

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

    1486. 

  1486. 				<td width = 450 bgcolor = "#05374A"><b class = "white">Characters Info:</b></td>

    1487. 

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

    1488. 

  1488. 			</tr>

    1489. 

  1489. 			</table>

    1490. 

  1490. 

    1491. 

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

    1492. 

  1492. 			<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>

    1493. 

  1493. 			<table border=0 cellspacing=0 cellpadding=4>

    1494. 

  1494. 	<?

    1495. 

  1495. 	$qquery = mysql_query("SELECT *, rs.dbhost as rsdbhost, rs.dbport as rsdbport,rs.dbuser as rsdbuser,

    1496. 

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

    1497. 

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

    1498. 

  1498. 	$i=0;

    1499. 

  1499. 	while ($rowx = mysql_fetch_array($qquery)) {

    1500. 

  1500. 		$newcon = @mysql_connect($rowx['rsdbhost'].':'.$rowx['rsdbport'], $rowx['rsdbuser'], $rowx['rsdbpass']);;

    1501. 

  1501. 		$newdb = @mysql_select_db ($rowx['rsdbname'], $newcon);

    1502. 

  1502. 		$newquery = @mysql_query("SELECT name, data, class, race, online FROM `character` WHERE `account`='".$rowa['id_account']."'", $newcon);

    1503. 

  1503. 		echo "<tr>

    1504. 

  1504. 				  <td align=right valign=top width=150 NOWRAP><span><b>".$rowx['name']."</b></span></td>

    1505. 

  1505. 				  <td align=left NOWRAP>

    1506. 

  1506. 				  <table border=0 cellspacing=0 cellpadding=0>

    1507. 

  1507. 					<tr>

    1508. 

  1508. 						<td>";

    1509. 

  1509. 					while($rowc = @mysql_fetch_array($newquery)) {		

    1510. 

  1510. 						$rowc['data'] = explode(' ',$rowc['data']);		

    1511. 

  1511. 						$char_gender = dechex($rowc['data'][36]);

    1512. 

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

    1513. 

  1513. 						$char_gender = $char_gender{3};		

    1514. 

  1514. 						echo "<table><tr>

    1515. 

  1515. 								<td width=120 align='left'><span>".$rowc['name']."</span></td>

    1516. 

  1516. 								<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>

    1517. 

  1517. 								<td align='left'><img onmouseover='ddrivetip(\"<b>".$CHAR_CLASS[$rowc['class']]."</b>\")' onmouseout='hideddrivetip()' src='new-hp/images/picons/".$rowc['class'].".gif'></td>

    1518. 

  1518. 								<td align='left' nowrap='nowrap' width=40><small style='color: rgb(102, 13, 2);'>Lvl. ".$rowc['data'][34]."</span></td>

    1519. 

  1519. 								<td width=0% align='left' nowrap='nowrap'><small style='color: rgb(102, 13, 2);'>";

    1520. 

  1520. 						if ($rowc['online']==1) { echo "<img onmouseover='ddrivetip(\"<b>On-Line</b>\")' onmouseout='hideddrivetip()' src='new-hp/images/favicon.ico'>"; } 

    1521. 

  1521. 						else { echo "<a href='#'><img onmouseover='ddrivetip(\"<b>Remove</b>\")' onmouseout='hideddrivetip()' src='new-hp/images/v2/remove.gif'></a>"; }

    1522. 

  1522. 						echo "</td></tr></table>";

    1523. 

  1523. 						$i++;

    1524. 

  1524. 					}

    1525. 

  1525. 					if (!$newcon OR !$newdb OR !$newquery) { echo '<span style="color: red;"><i>Server is Off-Line.</i></span>'; }

    1526. 

  1526. 					else if ($i==0) { echo '<span><i>None</i></span>'; }

    1527. 

  1527. 		echo '		</td></tr></table>

    1528. 

  1528. 				</td>

    1529. 

  1529. 			</tr>';

    1530. 

  1530. 	}

    1531. 

  1531. 	?>

    1532. 

  1532. 				   </table>

    1533. 

  1533. 	 </td></tr></table> 

    1534. 

  1534. 	</td>

    1535. 

  1535. </tr>

    1536. 

  1536. </table>

    1537. 

  1537. 	<p>

    1538. 

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

    1539. 

  1539. 			<tr>

    1540. 

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

    1541. 

  1541. 				<td width = "100%" bgcolor = "#05374A"><b class = "white">Contact Address:</b></td>

    1542. 

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

    1543. 

  1543. 			</tr>

    1544. 

  1544. 			</table>

    1545. 

  1545. 

    1546. 

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

    1547. 

  1547. 			<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>

    1548. 

  1548. 			<table border=0 cellspacing=0 cellpadding=4>

    1549. 

  1549. 

    1550. 

  1550. 			<tr>

    1551. 

  1551. 			      <td width=150 align=right>

    1552. 

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

    1553. 

  1553. 			      <font color="#FF0000">*</font> First Name:

    1554. 

  1554. 			      </span></b></font>

    1555. 

  1555. 			      </td>

    1556. 

  1556. 			      <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">

    1557. 

  1557. 

    1558. 

  1558. 				   </td></tr></table></td>

    1559. 

  1559. 			</tr>

    1560. 

  1560. 			<tr>

    1561. 

  1561. 			      <td align=right>

    1562. 

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

    1563. 

  1563. 			      <font color="#FF0000">*</font> Last Name:

    1564. 

  1564. 			      </span></b></font>

    1565. 

  1565. 			      </td>

    1566. 

  1566. 

    1567. 

  1567. 			      <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">

    1568. 

  1568. 

    1569. 

  1569. 				   </td></tr></table></td>

    1570. 

  1570. 			</tr>

    1571. 

  1571. 			<tr>

    1572. 

  1572. 			      <td align=right>

    1573. 

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

    1574. 

  1574. 			      <font color="#FF0000">*</font> City:

    1575. 

  1575. 			      </span></b></font>

    1576. 

  1576. 			      </td>

    1577. 

  1577. 			      <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">

    1578. 

  1578. 

    1579. 

  1579. 				   </td></tr></table></td>

    1580. 

  1580. 			</tr>

    1581. 

  1581. 			<tr>

    1582. 

  1582. 			      <td align=right>

    1583. 

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

    1584. 

  1584. 

    1585. 

  1585. 			      <font color="#FF0000">*</font> Country:

    1586. 

  1586. 				  

    1587. 

  1587. 			      </span></b></font>

    1588. 

  1588. 			      </td>

    1589. 

  1589. 			      <td align=left colspan = "2">

    1590. 

  1590. 				  	<table border=0 cellspacing=0 cellpadding=2><tr>

    1591. 

  1591. 						<td><select name="lo" style="width: 150;" OnChange="javascript:document.siteadmin.cflag.src = 'new-hp/images/flags/' + this.value + '.gif';">

    1592. 

  1592. <?

    1593. 

  1593. foreach ($COUNTRY as $key=>$value) {

    1594. 

  1594. 	echo '<option value="'.$key.'">'.$value.'</option>';

    1595. 

  1595. }

    1596. 

  1596. ?></selected>

    1597. 

  1597. 						</td>

    1598. 

  1598. 						<td><img name="cflag" src="new-hp/images/flags/00.gif"></td>

    1599. 

  1599. 				   </tr></table>

    1600. 

  1600. 			      </td>

    1601. 

  1601. 			</tr>

    1602. 

  1602. 				<tr>

    1603. 

  1603. 				<td align=right>

    1604. 

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

    1605. 

  1605. 				Show Location:<br>

    1606. 

  1606. 				</span></b></font>

    1607. 

  1607. 				</td>

    1608. 

  1608. 				<td align=left>

    1609. 

  1609. 				<table border=0 cellspacing=0 cellpadding=0>

    1610. 

  1610. 				<tr>

    1611. 

  1611. 				<td><select name="shlo"><option value=1 SELECTED>To Everyone<option value=0>Only To Administrators</td>

    1612. 

  1612. 				</tr>

    1613. 

  1613. 				</table>

    1614. 

  1614. 				</td>

    1615. 

  1615. 				</tr>

    1616. 

  1616. 			</table>

    1617. 

  1617. 

    1618. 

  1618. 			</td></tr></table>

    1619. 

  1619. 			</td></tr></table>

    1620. 

  1620. 

    1621. 

  1621. 			</center>

    1622. 

  1622. 

    1623. 

  1623. 			<p>

    1624. 

  1624. 

    1625. 

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

    1626. 

  1626. 			<tr>

    1627. 

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

    1628. 

  1628. 				<td width = "100%" bgcolor = "#05374A"><b class = "white">Email Address:</b></td>

    1629. 

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

    1630. 

  1630. 			</tr>

    1631. 

  1631. 			</table>

    1632. 

  1632. 

    1633. 

  1633. 			<center>

    1634. 

  1634. 			<a name = "phone"></a>

    1635. 

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

    1636. 

  1636. 			<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>

    1637. 

  1637. 

    1638. 

  1638. 			<table border=0 cellspacing=0 cellpadding=4 width = "100%">

    1639. 

  1639. 			<tr>

    1640. 

  1640. 			      <td width=150 align=right>

    1641. 

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

    1642. 

  1642. 			      <font color="#FF0000">*</font> Email:<br>

    1643. 

  1643. 			      </span></b></font>

    1644. 

  1644. 			      </td>

    1645. 

  1645. 			      <td align=left>

    1646. 

  1646. 				  <table border=0 cellspacing=0 cellpadding=0>

    1647. 

  1647. 					<tr>

    1648. 

  1648. 						<td><input name="em" MaxLength="250" Width=130 taborder=9 /></td>

    1649. 

  1649. 					</tr>

    1650. 

  1650. 				  </table>

    1651. 

  1651. 				  </td>

    1652. 

  1652. 			</tr>

    1653. 

  1653. 						<tr>

    1654. 

  1654. 				<td align=right>

    1655. 

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

    1656. 

  1656. 					Enable 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><select name="shem"><option value=1>For Everyone<option value=0 SELECTED>Only For Administrators</td>

    1663. 

  1663. 						</tr>

    1664. 

  1664. 					</table>

    1665. 

  1665. 				</td>

    1666. 

  1666. 			</tr>

    1667. 

  1667. 			</table>

    1668. 

  1668. 

    1669. 

  1669. 			</td></tr></table>

    1670. 

  1670. 			</td></tr></table>

    1671. 

  1671. 

    1672. 

  1672. 			</center>

    1673. 

  1673. 

    1674. 

  1674. 			<p>

    1675. 

  1675. 

    1676. 

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

    1677. 

  1677. 			<tr>

    1678. 

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

    1679. 

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

    1680. 

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

    1681. 

  1681. 			</tr>

    1682. 

  1682. 			</table>

    1683. 

  1683. 

    1684. 

  1684. 			<center>

    1685. 

  1685. 			<a name = "phone"></a>

    1686. 

  1686. 			<table width = "450" style = "border-width: 1px; border-style: dotted; border-color: #928058;">

    1687. 

  1687. 				<tr>

    1688. 

  1688. 					<td>

    1689. 

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

    1690. 

  1690. 							<tr>

    1691. 

  1691. 								<td>

    1692. 

  1692. 									<table border=0 cellspacing=0 cellpadding=4 width = "100%">

    1693. 

  1693. 										<tr>

    1694. 

  1694. 											<td width=150 align=right>

    1695. 

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

    1696. 

  1696. 												 <font color="#FF0000">*</font> Display Name:<br>

    1697. 

  1697. 												</span></b></font>

    1698. 

  1698. 												</td>

    1699. 

  1699. 												<td align=left>

    1700. 

  1700. 												<table border=0 cellspacing=0 cellpadding=0>

    1701. 

  1701. 													<tr>

    1702. 

  1702. 														<td><input type=text name="nick" maxlength="16"></td>

    1703. 

  1703. 													</tr>

    1704. 

  1704. 												</table>

    1705. 

  1705. 											</td>

    1706. 

  1706. 										</tr>

    1707. 

  1707. 										<tr>

    1708. 

  1708. 											<td align=right>

    1709. 

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

    1710. 

  1710. 												Birthday:<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="bd" maxlength="10"></td><td>&nbsp;<span>(dd/mm/yyyy)</span></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. 												Show 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><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>

    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. 												Gender:<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="gender"><option value=0>Female<option value=1 SELECTED>Male

    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. 												Time Zone (GMT):<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="gmt" style="width: 250;"> 

    1759. 

  1759. <?php

    1760. 

  1760. for($i=-12;$i<count($GMT)-12;$i++) {

    1761. 

  1761. 	echo '<option value="'.$i.'">(GMT '.$GMT[$i][0].') '.$GMT[$i][1].'</option>';

    1762. 

  1762. }

    1763. 

  1763. ?>

    1764. 

  1764. 														</select></td>

    1765. 

  1765. 				<script type="text/javascript">

    1766. 

  1766. 						document.siteadmin.gmt.value='<?php echo $SETTING['WEB_GMT']; ?>';

    1767. 

  1767. 				</script>

    1768. 

  1768. 												</selected>

    1769. 

  1769. 													</td>

    1770. 

  1770. 													</tr>

    1771. 

  1771. 												</table>

    1772. 

  1772. 											</td>

    1773. 

  1773. 										</tr>

    1774. 

  1774. 										<tr>

    1775. 

  1775. 											<td align=right>

    1776. 

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

    1777. 

  1777. 												Enable Private Messages:<br>

    1778. 

  1778. 												</span></b></font>

    1779. 

  1779. 												</td>

    1780. 

  1780. 												<td align=left>

    1781. 

  1781. 												<table border=0 cellspacing=0 cellpadding=0>

    1782. 

  1782. 													<tr>

    1783. 

  1783. 														<td><select name="shpm"><option value=1 SELECTED>From Everyone<option value=0>Only From Administrators

    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. 												MSN:<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><input type=text name="msn"></td><td>&nbsp;<img src="new-hp/images/im/im_msn.gif"></td>

    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. 												Skype:<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="skype"></td><td>&nbsp;<img src="new-hp/images/im/im_skype.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. 												ICQ:<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="icq"></td><td>&nbsp;<img src="new-hp/images/im/im_icq.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. 												AIM:<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="aim"></td><td>&nbsp;<img src="new-hp/images/im/im_aim.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. 												Yahoo:<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="yahoo"></td><td>&nbsp;<img src="new-hp/images/im/im_yahoo.gif"></td>

    1854. 

  1854. 													</tr>

    1855. 

  1855. 												</table>

    1856. 

  1856. 											</td>

    1857. 

  1857. 										</tr>

    1858. 

  1858. 										<tr>

    1859. 

  1859. 											  <td align=left>

    1860. 

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

    1861. 

  1861. 											  </span></b></font> </td>

    1862. 

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

    1863. 

  1863. 											  <?php bbcode_toolbar('siteadmin.sig'); ?>

    1864. 

  1864. 											  </td><td valign = "top">

    1865. 

  1865. 											   </td></tr></table></td>

    1866. 

  1866. 										</tr>

    1867. 

  1867. 										<tr>

    1868. 

  1868. 											<td align=right valign=top >

    1869. 

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

    1870. 

  1870. 												Signature:<br>

    1871. 

  1871. 												</span></b></font>

    1872. 

  1872. 												</td>

    1873. 

  1873. 												<td align=left >

    1874. 

  1874. 												<table border=0 cellspacing=0 cellpadding=0>

    1875. 

  1875. 													<tr>

    1876. 

  1876. 														<td><textarea rows=4 name="sig" cols=40><?php if ($haserrors!='') { echo $_POST['sig']; } else { echo $rowa['signature']; } ?></textarea></td>

    1877. 

  1877. 													</tr>

    1878. 

  1878. 												</table>

    1879. 

  1879. 											</td>

    1880. 

  1880. 										</tr>

    1881. 

  1881. 										<tr>

    1882. 

  1882. 											<td align=right >

    1883. 

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

    1884. 

  1884. 												Home Page URL:<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><input type=text size=40 name="weburl"></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. 										  Skin:<br>

    1899. 

  1899. 										  </span></b></font>

    1900. 

  1900. 										  </td>

    1901. 

  1901. 										  <td 60% align=left>

    1902. 

  1902. 										  <table border=0 cellspacing=0 cellpadding=0>

    1903. 

  1903. 											<tr>

    1904. 

  1904. 												<td><select name="skin" OnChange="javascript:changelayout(this.value);">

    1905. 

  1905. 												<option value="" SELECTED>Default

    1906. 

  1906. 												<?php

    1907. 

  1907. 													foreach (glob('new-hp/templates/*', GLOB_ONLYDIR) as $tempname) {

    1908. 

  1908. 														if (file_exists($tempname.'/layout.css') and (stristr($tempname, 'forum')==false)) {

    1909. 

  1909. 															$tempname = str_replace(dirname($tempname).'/','',$tempname);

    1910. 

  1910. 															echo '<option value="'.$tempname.'">'.$tempname;

    1911. 

  1911. 														}

    1912. 

  1912. 													}

    1913. 

  1913. 												?>

    1914. 

  1914. 												</select>

    1915. 

  1915. 													

    1916. 

  1916. 														</td>

    1917. 

  1917. 													</tr>

    1918. 

  1918. 												  </table>

    1919. 

  1919. 											  </td>

    1920. 

  1920. 										</tr>

    1921. 

  1921. 									</table>

    1922. 

  1922. 								</td>

    1923. 

  1923. 							</tr>

    1924. 

  1924. 						</table>

    1925. 

  1925. 					</td>

    1926. 

  1926. 				</tr>

    1927. 

  1927. 			</table>

    1928. 

  1928. 	<p>

    1929. 

  1929. 	<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 >

    1930. 

  1930. 	<p>

    1931. 

  1931. <style type="text/css">

    1932. 

  1932. #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; }

    1933. 

  1933. #talent-input { display: table; width: 400px; padding: 0; margin: 0; text-align: left; }

    1934. 

  1934. table#dlcharacters { border: 1px solid black; border-collapse: collapse; }

    1935. 

  1935. small.smallBold { color: #fff; font-size: 8pt; font-weight: bold; }

    1936. 

  1936. .avatarselect { margin: 0; width: 82px; }

    1937. 

  1937. .avatarselect .shell { position: relative; margin: 10px auto; width: 64px; height: 64px; }

    1938. 

  1938. .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; }

    1939. 

  1939. .avatarselect .iconPosition { position: absolute; top: -22px; right: 2px; width: 24px; text-align: center; color: #FFD823; z-index: 300; }

    1940. 

  1940. table.charselectborder { border: 1px solid #4C4C4C; }

    1941. 

  1941. span.mine { color: #a0a1a3; }

    1942. 

  1942. a:link.mine, a:hover.mine, a:visited.mine, a.mine { color: orange; font-weight: bold; }

    1943. 

  1943. small.mine { color: white; }

    1944. 

  1944. 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; }

    1945. 

  1945. 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; }

    1946. 

  1946. </style>

    1947. 

  1947. <!--[if lte IE 6]>

    1948. 

  1948. <style type="text/css">

    1949. 

  1949. .avatarselect .shell { left: 10px; }

    1950. 

  1950. </style>

    1951. 

  1951. <![endif]-->

    1952. 

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

    1953. 

  1953. 			<tr>

    1954. 

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

    1955. 

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

    1956. 

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

    1957. 

  1957. 			</tr>

    1958. 

  1958. 			</table>

    1959. 

  1959. 			<table width = "450" style = "border-width: 1px; border-style: dotted; border-color: #928058;">

    1960. 

  1960. 				<tr>

    1961. 

  1961. 					<td>

    1962. 

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

    1963. 

  1963. 							<tr>

    1964. 

  1964. 								<td>

    1965. 

  1965. 									<table border=0 cellspacing=0 cellpadding=4 width = "100%">

    1966. 

  1966. 										<tr>

    1967. 

  1967. 											<td width=50% align=left>

    1968. 

  1968. 		<?php

    1969. 

  1969. 			$splitline=2;

    1970. 

  1970. 			$charset[0]=$rowa['displayname'];

    1971. 

  1971. 			$upname[0] = 'siteadmin';

    1972. 

  1972. 			$imgset[0] = 'nochar';

    1973. 

  1973. 			if ($rowa['id_account']==$SETTING['SERVER_OWNER']) { $rowa['gmlevel']=4; }

    1974. 

  1974. 			if ($rowa['gmlevel']>0) { $imgset[1] = $rowa['gmlevel']; } else if ($rowa['ismvp']=='1') { $imgset[1] = 'mvp'; }

    1975. 

  1975. 			

    1976. 

  1976. 			$upname[1] = 'nochar';

    1977. 

  1977. 			if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }

    1978. 

  1978. 		    charavatar($charset, $imgset, $upname);

    1979. 

  1979. 			echo '</td>';

    1980. 

  1980. 			

    1981. 

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

    1982. 

  1982. 			$qquery = mysql_query("SELECT *, rs.dbhost as rsdbhost, rs.dbport as rsdbport,rs.dbuser as rsdbuser,

    1983. 

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

    1984. 

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

    1985. 

  1985. 			$i=1;

    1986. 

  1986. 			while ($rowx = mysql_fetch_array($qquery)) {

    1987. 

  1987. 				$newcon = @mysql_connect($rowx['rsdbhost'].':'.$rowx['rsdbport'], $rowx['rsdbuser'], $rowx['rsdbpass']);;

    1988. 

  1988. 				$newdb = @mysql_select_db ($rowx['rsdbname'], $newcon);

    1989. 

  1989. 				$newquery = @mysql_query("SELECT guid, name, data, class, race FROM `character` WHERE `account`='".$rowa['id_account']."'", $newcon);

    1990. 

  1990. 					while($rowc = @mysql_fetch_array($newquery)) {

    1991. 

  1991. 						if (is_int($i/$splitline)) { echo '</tr><tr>'; }

    1992. 

  1992. 						echo '<td align=left>';

    1993. 

  1993. 						$rowc['data'] = explode(' ',$rowc['data']);		

    1994. 

  1994. 						$char_gender = str_pad(dechex($rowc['data'][36]),8, 0, STR_PAD_LEFT);

    1995. 

  1995. 						$char_gender = $char_gender{3};		

    1996. 

  1996. 						$charset[0]=$rowc['name'];

    1997. 

  1997. 						$charset[1]=$rowc['data'][34];

    1998. 

  1998. 						$charset[2]=$rowc['race'];

    1999. 

  1999. 						$charset[3]=$char_gender;

    2000. 

  2000. 						$charset[4]=$rowc['class'];

    2001. 

  2001. 						$charset[5]=$rowx['name'];

    2002. 

  2002. 						$upname[1] = $rowc['guid'].'/'.$rowx['id'];

    2003. 

  2003. 						if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }

    2004. 

  2004. 						charavatar($charset, '', $upname);

    2005. 

  2005. 						echo '</td>';

    2006. 

  2006. 						$i++;

    2007. 

  2007. 					}

    2008. 

  2008. 			}

    2009. 

  2009. 			if ($rowa['gmlevel']>0) {

    2010. 

  2010. 				foreach (glob('new-hp/images/forum/portraits/gm/*.gif') as $tempname) {

    2011. 

  2011. 					if (is_int($i/$splitline)) { echo '</tr><tr>'; }

    2012. 

  2012. 					echo '<td align=left>';

    2013. 

  2013. 					$charset[0]=$rowa['displayname'];

    2014. 

  2014. 					$imgset[0] = str_replace('new-hp/images/forum/portraits/', '', $tempname);

    2015. 

  2015. 					$upname[1] = $imgset[0];

    2016. 

  2016. 					if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }

    2017. 

  2017. 					charavatar($charset, $imgset, $upname);

    2018. 

  2018. 					echo '</td>';

    2019. 

  2019. 					$i++;

    2020. 

  2020. 				}

    2021. 

  2021. 			}

    2022. 

  2022. 			if ($rowa['ismvp']=='1') { 

    2023. 

  2023. 				foreach (glob('new-hp/images/forum/portraits/mvp/*.gif') as $tempname) {

    2024. 

  2024. 					if (is_int($i/$splitline)) { echo '</tr><tr>'; }

    2025. 

  2025. 					echo '<td align=left>';

    2026. 

  2026. 					$charset[0]=$rowa['displayname'];

    2027. 

  2027. 					$imgset[0] = str_replace('new-hp/images/forum/portraits/', '', $tempname);

    2028. 

  2028. 					$upname[1] = $imgset[0];

    2029. 

  2029. 					if ($upname[1]==$rowa['avatar']) { $upname[2]='sel'; } else { $upname[2]=''; }

    2030. 

  2030. 					charavatar($charset, $imgset, $upname);

    2031. 

  2031. 					echo '</td>';

    2032. 

  2032. 					$i++;

    2033. 

  2033. 				}

    2034. 

  2034. 			}

    2035. 

  2035. 		?>

    2036. 

  2036. 													</tr>

    2037. 

  2037. 												  </table>

    2038. 

  2038. 											  </td>

    2039. 

  2039. 										</tr>

    2040. 

  2040. 									</table>

    2041. 

  2041. 								</td>

    2042. 

  2042. 							</tr>

    2043. 

  2043. 						</table>

    2044. 

  2044. 			

    2045. 

  2045. 		<?php if ($_SERVER['REQUEST_METHOD']!='POST') { ?>

    2046. 

  2046. 			<script>

    2047. 

  2047. 			document.siteadmin.ask.value='<?php echo $rowa['passask']; ?>';

    2048. 

  2048. 			document.siteadmin.ans.value='<?php echo $rowa['passans']; ?>';

    2049. 

  2049. 			document.siteadmin.uptbc.checked=<?php echo $rowa['tbc']; ?>;

    2050. 

  2050. 			void(document.siteadmin.fname.value='<?php echo $rowa['fname']; ?>');

    2051. 

  2051. 			void(document.siteadmin.lname.value='<?php echo $rowa['lname']; ?>');

    2052. 

  2052. 			void(document.siteadmin.city.value='<?php echo $rowa['city']; ?>');

    2053. 

  2053. 			void(document.siteadmin.lo.value='<?php echo $rowa['location']; ?>');

    2054. 

  2054. 			<?php if ($rowa['bday']!='00/00/0000') { ?>void(document.siteadmin.bd.value='<?php echo $rowa['bday']; ?>'); <? } 

    2055. 

  2055. 			if ($getbanned['id']!='' AND $rowa['gmlevel']==0) { 

    2056. 

  2056. 				if ($rowa['activation']!='') { 

    2057. 

  2057. 					echo "document.siteadmin.accstatus.value='2';"; 

    2058. 

  2058. 				} else { 

    2059. 

  2059. 					echo "document.siteadmin.accstatus.value='1';"; 

    2060. 

  2060. 				} 

    2061. 

  2061. 			} else if ($rowa['id_account']!=$_SESSION['userid'] AND $rowa['gmlevel']==0) { 

    2062. 

  2062. 				echo "document.siteadmin.accstatus.value='0';"; 

    2063. 

  2063. 			} ?>

    2064. 

  2064. 			void(document.siteadmin.shbd.value='<?php echo $rowa['showbday']; ?>');

    2065. 

  2065. 			void(document.siteadmin.cflag.src = 'new-hp/images/flags/' + document.siteadmin.lo.value + '.gif');

    2066. 

  2066. 			void(document.siteadmin.gmt.value='<?php echo $rowa['gmt']; ?>');

    2067. 

  2067. 			void(document.siteadmin.shlo.value='<?php echo $rowa['showlocation']; ?>');

    2068. 

  2068. 			void(document.siteadmin.shem.value='<?php echo $rowa['enableemail']; ?>');

    2069. 

  2069. 			void(document.siteadmin.em.value='<?php echo $rowa['email']; ?>');

    2070. 

  2070. 			void(document.siteadmin.shpm.value='<?php echo $rowa['enablepm']; ?>');

    2071. 

  2071. 			void(document.siteadmin.msn.value='<?php echo $rowa['msn']; ?>');

    2072. 

  2072. 			void(document.siteadmin.skype.value='<?php echo $rowa['skype']; ?>');

    2073. 

  2073. 			void(document.siteadmin.aim.value='<?php echo $rowa['aim']; ?>');

    2074. 

  2074. 			void(document.siteadmin.icq.value='<?php echo $rowa['icq']; ?>');

    2075. 

  2075. 			void(document.siteadmin.yahoo.value='<?php echo $rowa['yahoo']; ?>');

    2076. 

  2076. 			void(document.siteadmin.weburl.value='<?php echo $rowa['weburl']; ?>');

    2077. 

  2077. 			void(document.siteadmin.skin.value='<?php echo $rowa['template']; ?>');

    2078. 

  2078. 			void(document.siteadmin.nick.value='<?php echo $rowa['displayname']; ?>');

    2079. 

  2079. 			void(document.siteadmin.gender.value='<?php echo $rowa['gender']; ?>');

    2080. 

  2080. 			void(document.siteadmin.lockacc.value='<?php echo $rowa['locked']; ?>');

    2081. 

  2081. 			void(document.siteadmin.lockip.value='<?php echo $rowa['last_ip']; ?>');

    2082. 

  2082. 			<?php if ($rowa['gmlevel']==0) { ?>void(document.siteadmin.accmvp.value='<?php echo $rowa['ismvp']; ?>'); <? } ?>

    2083. 

  2083. 			</script>

    2084. 

  2084. 		<?php

    2085. 

  2085. 		} else {

    2086. 

  2086. 		?>

    2087. 

  2087. 			<script>

    2088. 

  2088. 			document.siteadmin.ask.value='<?php echo $_POST['ask']; ?>';

    2089. 

  2089. 			document.siteadmin.ans.value='<?php echo $_POST['ans']; ?>';

    2090. 

  2090. 			document.siteadmin.uptbc.checked=<?php echo $_POST['uptbc']; ?>;

    2091. 

  2091. 			document.siteadmin.lname.value='<?php echo $_POST['lname']; ?>';

    2092. 

  2092. 			document.siteadmin.fname.value='<?php echo $_POST['fname']; ?>';

    2093. 

  2093. 			document.siteadmin.city.value='<?php echo $_POST['city']; ?>';

    2094. 

  2094. 			document.siteadmin.lo.value='<?php echo $_POST['lo']; ?>';

    2095. 

  2095. 			document.siteadmin.shbd.value='<?php echo $_POST['shbd']; ?>';

    2096. 

  2096. 			document.siteadmin.cflag.src = 'new-hp/images/flags/' + document.siteadmin.lo.value + '.gif';

    2097. 

  2097. 			document.siteadmin.gmt.value='<?php echo $_POST['gmt']; ?>';

    2098. 

  2098. 			document.siteadmin.shlo.value='<?php echo $_POST['shlo']; ?>';

    2099. 

  2099. 			document.siteadmin.em.value='<?php echo $_POST['em']; ?>';

    2100. 

  2100. 			document.siteadmin.shem.value='<?php echo $_POST['shem']; ?>';

    2101. 

  2101. 			document.siteadmin.shpm.value='<?php echo $_POST['shpm']; ?>';

    2102. 

  2102. 			document.siteadmin.nick.value='<?php echo $_POST['nick']; ?>';

    2103. 

  2103. 			document.siteadmin.bd.value='<?php echo $_POST['bd']; ?>';

    2104. 

  2104. 			document.siteadmin.msn.value='<?php echo $_POST['msn']; ?>';

    2105. 

  2105. 			document.siteadmin.skype.value='<?php echo $_POST['skype']; ?>';

    2106. 

  2106. 			document.siteadmin.aim.value='<?php echo $_POST['aim']; ?>';

    2107. 

  2107. 			document.siteadmin.icq.value='<?php echo $_POST['icq']; ?>';

    2108. 

  2108. 			document.siteadmin.yahoo.value='<?php echo $_POST['yahoo']; ?>';

    2109. 

  2109. 			document.siteadmin.weburl.value='<?php echo $_POST['weburl']; ?>';

    2110. 

  2110. 			document.siteadmin.skin.value='<?php echo $_POST['skin']; ?>';

    2111. 

  2111. 			<?php if ($rowa['gmlevel']=='0') { ?>document.siteadmin.accstatus.value='<?php echo $_POST['accstatus']; ?>';<?php } ?>

    2112. 

  2112. 			void(document.siteadmin.gender.value='<?php echo $_POST['gender']; ?>');

    2113. 

  2113. 			void(document.siteadmin.lockacc.value='<?php echo $_POST['lockacc']; ?>');

    2114. 

  2114. 			void(document.siteadmin.lockip.value='<?php echo $_POST['lockip']; ?>');

    2115. 

  2115. 			<?php if ($rowa['gmlevel']==0) { ?>document.siteadmin.accmvp.value='<?php echo $_POST['accmvp']; ?>';<? } ?>

    2116. 

  2116. 			</script>

    2117. 

  2117. 			<?php

    2118. 

  2118. 			}

    2119. 

  2119. 		} else {

    2120. 

  2120. 		?>

    2121. 

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

    2122. 

  2122. 				<tr>

    2123. 

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

    2124. 

  2124. 					<td width = 450 bgcolor = "#05374A"><b class = "white">Ghost Account Info:</b></td>

    2125. 

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

    2126. 

  2126. 				</tr>

    2127. 

  2127. 				</table>

    2128. 

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

    2129. 

  2129. 				<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>

    2130. 

  2130. 				<table border=0 cellspacing=0 cellpadding=4>

    2131. 

  2131. 					<tr>

    2132. 

  2132. 						<td width=150 align=right>

    2133. 

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

    2134. 

  2134. 							 <font color="#FF0000">*</font> Display Name:<br>

    2135. 

  2135. 							</span></b></font>

    2136. 

  2136. 							</td>

    2137. 

  2137. 							<td align=left>

    2138. 

  2138. 							<table border=0 cellspacing=0 cellpadding=0>

    2139. 

  2139. 								<tr>

    2140. 

  2140. 									<td><input type=text name="nick" maxlength="16"></td>

    2141. 

  2141. 								</tr>

    2142. 

  2142. 							</table>

    2143. 

  2143. 						</td>

    2144. 

  2144. 					</tr>

    2145. 

  2145. 					<tr>

    2146. 

  2146. 				  <td align=right NOWRAP><span><b>Delete Account:</b></span></td>

    2147. 

  2147. 																		  

    2148. 

  2148. 					  <td align=left NOWRAP>

    2149. 

  2149. 					  <table border=0 cellspacing=0 cellpadding=0><tr><td>

    2150. 

  2150. 					  <select name="deleteacc">

    2151. 

  2151. 						<option value="1">Yes

    2152. 

  2152. 						<option value="0" SELECTED>No

    2153. 

  2153. 					  </select>

    2154. 

  2154. 					  </td><td valign = "top">

    2155. 

  2155. 				   </td></tr></table>

    2156. 

  2156. 			</tr>

    2157. 

  2157. 				</table>

    2158. 

  2158. 		</td></tr></table></td></tr></table>	

    2159. 

  2159. 	<p>

    2160. 

  2160. 	<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 >

    2161. 

  2161. 	<p>

    2162. 

  2162. 		<?php if ($haserrors=="") { ?>

    2163. 

  2163. 			<script>

    2164. 

  2164. 			void(document.siteadmin.nick.value='<?php echo $rowa['displayname']; ?>');

    2165. 

  2165. 			</script>

    2166. 

  2166. 			<?php

    2167. 

  2167. 			} else {

    2168. 

  2168. 			?>

    2169. 

  2169. 			<script>

    2170. 

  2170. 			document.siteadmin.nick.value='<?php echo $_POST['nick']; ?>';

    2171. 

  2171. 			</script>

    2172. 

  2172. 			<?php

    2173. 

  2173. 			}

    2174. 

  2174. 		} ?>

    2175. 

  2175. 			</center>

    2176. 

  2176. 	</form>

    2177. 

  2177. <?php

    2178. 

  2178. 			}

    2179. 

  2179. 		} else {

    2180. 

  2180. 			errborder('Account do NOT exists.');

    2181. 

  2181. 		}

    2182. 

  2182. 

    2183. 

  2183. 	}

    2184. 

  2184. 	

    2185. 

  2185. }

    2186. 

  2186. 

    2187. 

  2187. 

    2188. 

  2188. 

    2189. 

  2189. ?>
    2190.