function getdata(&$tpl) { global $_CONFIG, $_POST, $_GET, $system; require_once './inc/base.inc.php'; if ($_SERVER["REQUEST_METHOD"] == "POST" and isset($_POST) and isset($_POST['c_user']) or isset($_GET['char'])) { if (isset($_GET['char'])) { $_POST['c_user'] = $_GET['char']; } $tpl->setParam('c_user', $_POST['c_user']); if (strlen($_POST['c_user']) < 2) { $tpl->setParam('c_msg', '<center>Error:</center><br />' . 'Account name... INVALID!'); return; } $c_sql_user = mysql_escape_string($_POST['c_user']); $char_link = $system->mysql_connect(); $sq = mysql_query("SELECT `characters`.`acct`, `characters`.`guid`, `characters`.`name` FROM `characters` WHERE `characters`.`name` = '{$c_sql_user}'", $char_link); if (mysql_num_rows($sq) == 0) { $tpl->setParam('c_msg', "<center>Error:</center><br />" . "Char not exist"); mysql_close($char_link); return; } $dr = mysql_fetch_array($sq); $world_link = $system->mysql_world(); $data = array(); $data = $this->build_item_list($dr['guid'], $char_link, $world_link); mysql_close($world_link); mysql_close($char_link); $msg = "Done! for char {$_POST['c_user']}<br/>\n "; foreach ($data as $acc => $itemlist) { $msg .= "<hr/><h2>Char: {$acc}</h2>\n"; foreach ($itemlist as $item) { if ($item['quality'] == 0) { $msg .= "[color=grey]"; } elseif ($item['quality'] == 2) { $msg .= "[color=green]"; } elseif ($item['quality'] == 1) { $msg .= "[color]"; } elseif ($item['quality'] == 3) { $msg .= "[color=blue]"; } elseif ($item['quality'] == 4) { $msg .= "[color=purple]"; } $msg .= "{$item['name1']} ({$item['entry']})[/color]<br/>[url=http://thottbot.com/i{$item['entry']}]thottbot[/url] [url=http://www.wowhead.com/?item={$item['entry']}]wowhead[/url]<br/>\n"; if (!empty($item['description'])) { $msg .= "[color=gold]{$item['description']}[/color]<br/>\n"; } $msg .= "containerslot: {$item['containerslot']}<br/>"; $msg .= "slot: {$item['slot']}<br/>"; $msg .= "Count: {$item['count']}/{$item['maxcount']}<br/>\n"; $msg .= "<br/><br/>\n"; } $options =& PEAR::getStaticProperty('HTML_BBCodeParser', '_options'); $options['filters'] = "Basic,Extended,Images,Links,Lists,Email"; unset($options); //$msg.=nl2br(print_r($_SESSION['item_cache'],1)); } $tpl->setParam('c_msg', HTML_BBCodeParser::staticQparse($msg)); } else { $tpl->setParam('c_msg', ''); $tpl->setParam('c_user', ''); } }
function getdata(&$tpl) { global $_CONFIG, $_POST, $_GET, $system; require_once './inc/base.inc.php'; if ($_SERVER["REQUEST_METHOD"] == "POST" and isset($_POST) and isset($_POST['c_user']) or isset($_GET['char'])) { if (isset($_GET['char'])) { $_POST['c_user'] = $_GET['char']; } $tpl->setParam('c_user', $_POST['c_user']); if (strlen($_POST['c_user']) < 2) { $tpl->setParam('c_msg', '<center>Error:</center><br />' . 'Account name... INVALID!'); return; } $c_sql_user = mysql_escape_string($_POST['c_user']); $login_link = $system->mysql_login(); $char_link = $system->mysql_connect(); $sq2 = array(); if (Net_CheckIP::check_ip($_POST['c_user'])) { $dr1 = array(); $dr1[2] = $_POST['c_user']; $sq2[] = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`lastip` = '{$dr1[2]}'", $login_link); } elseif ($_POST['c_user'] == "/_online") { $acc = array(); $sq1 = NULL; $sq = mysql_query("SELECT `characters`.`acct`, `characters`.`guid`, `characters`.`name` FROM `characters` WHERE `characters`.`online` = 1;", $char_link); while ($dr1 = @mysql_fetch_array($sq)) { $sq2[] = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`acct`={$dr1[0]}", $login_link); } } elseif (substr($_POST['c_user'], 0, 1) == "/") { $acc = substr($_POST['c_user'], 1, strlen($_POST['c_user']) - 1); $sq = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`login` = '" . mysql_escape_string($acc) . "'", $login_link); if (mysql_num_rows($sq) == 0) { $tpl->setParam('c_msg', "<center>Error:</center><br />" . "account not exist"); mysql_close($login_link); mysql_close($char_link); return; } $dr = mysql_fetch_array($sq); $sq2[] = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`lastip` = '{$dr[2]}'", $login_link); } else { $sq = mysql_query("SELECT `characters`.`acct`, `characters`.`guid`, `characters`.`name` FROM `characters` WHERE `characters`.`name` = '{$c_sql_user}'", $char_link); if (mysql_num_rows($sq) == 0) { $tpl->setParam('c_msg', "<center>Error:</center><br />" . "Char not exist"); mysql_close($login_link); return; } elseif (mysql_num_rows($sq) == 1) { $dr = mysql_fetch_array($sq); $sq1 = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`acct` = {$dr[0]}", $login_link); $dr1 = mysql_fetch_array($sq1); $sq2[] = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`lastip` = '{$dr1[2]}'", $login_link); } elseif (mysql_num_rows($sq) > 1) { while ($dr = @mysql_fetch_array($sq)) { $sq1 = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`acct` = {$dr[0]}", $login_link); $dr1 = mysql_fetch_array($sq1); $sq2[] = mysql_query("SELECT `accounts`.`acct`, `accounts`.`login`, `accounts`.`lastip` FROM `accounts` WHERE `accounts`.`lastip` = '{$dr1[2]}'", $login_link); } } } $data = array(); foreach ($sq2 as $sql) { while ($dr2 = @mysql_fetch_array($sql)) { $data["{$dr2['login']} ({$dr2['acct']})"] = array(); $sq3 = mysql_query("SELECT `characters`.`name`, `characters`.`level`, `characters`.`race`, `characters`.`class`, `characters`.`gender`, `characters`.`auras` FROM `characters` WHERE `characters`.`acct` = '{$dr2[0]}' ORDER BY `characters`.`level` DESC", $char_link); while ($dr3 = @mysql_fetch_array($sq3)) { $dr3['isonline'] = $system->is_online($dr3['name']); $data["{$dr2['login']} ({$dr2['acct']})"][] = $dr3; } @mysql_free_result($sq3); } } foreach ($sq2 as $sql) { @mysql_free_result($sql); } @mysql_free_result($sq1); @mysql_free_result($sq); mysql_close($login_link); mysql_close($char_link); if (Net_CheckIP::check_ip($_POST['c_user'])) { $msg = "Done! for ip {$_POST['c_user']}<br/>\n "; } elseif ($_POST['c_user'] == "/_online") { $msg = "Done!<br/>\n"; } elseif (substr($_POST['c_user'], 0, 1) == "/") { $msg = "Done! for ip {$dr[2]} owner (acc {$acc})<br/>\n "; } else { $msg = "Done! for ip {$dr1[2]} owner {$_POST['c_user']} (acc {$dr1[1]})<br/>\n "; } foreach ($data as $acc => $chars) { $msg .= "<hr/><h2>Account: {$acc}</h2>\n"; foreach ($chars as $char) { $msg .= "<img src=\"icon/class/{$char['class']}.gif\" alt=\"{$base_class[$char['class']]}\" /> <img src=\"icon/race/{$char['race']}-{$char['gender']}.gif\" alt=\"{$base_race[$char['race']]}\" /> {$char['name']} ({$char['level']}) "; if ($char['isonline']) { $msg .= "Online"; } else { $msg .= "Offline"; } if (strlen($char['auras']) > 0) { $msg .= "<br/>"; $au = explode(",", $char['auras']); $ii = count($au) - 2; $i = 0; while ($i <= $ii) { switch ($au[$i]) { case 32727: $msg .= "[color=red]ARENA_PREPARATION({$au[$i]})[/color] "; break; case 32725: case 35775: $msg .= "[color=red]ARENA_FLAG_GREEN({$au[$i]})[/color] "; break; case 35774: case 32724: $msg .= "[color=red]ARENA_FLAG_GOLD({$au[$i]})[/color] "; break; default: $msg .= "{$au[$i]} "; } $i = $i + 2; } } $msg .= "<br/><br/>\n"; } } $options =& PEAR::getStaticProperty('HTML_BBCodeParser', '_options'); $options['filters'] = "Basic,Extended,Images,Links,Lists,Email"; unset($options); $tpl->setParam('c_msg', HTML_BBCodeParser::staticQparse($msg)); } else { $tpl->setParam('c_msg', ''); $tpl->setParam('c_user', ''); } }