$isAdmin = false; } $smarty->assign('name', $conf['title']); $smarty->assign("userId", $userId); $smarty->assign("userData", $userData); $smarty->assign("userName", $startUp->session_username); $smarty->assign("Admin", $isAdmin); $smarty->assign('userUpload', $userData->upload); $smarty->assign('userDownload', $userData->download); if (!isset($_GET["catid"])) { $_GET["catid"] = 'NULL'; } $cat_id = $_GET["catid"]; $smarty->assign('getCategoriescollapsed', $startUp->Categories('getlistcollapsed', $cat_id)); $smarty->assign('setError', 'false'); $sql = "SELECT filename FROM plugins WHERE action = '" . $db->escape(1) . "'"; $items = $db->get_results($sql, ARRAY_A); if ($items) { foreach ($items as $result_rows) { $plugins[] = $result_rows['filename']; } } else { $plugins = ''; } $hook->active_plugins = $plugins; $hook->set_hooks(array('install', 'action', 'home_page', 'new_page', 'upload_page', 'torrents_page', 'detail_page', 'registration_page', 'login_page', 'account_page', 'edit_account_page', 'user_page', 'admin_action', 'new_admin_page', 'admin_settings_page')); $hook->load_plugins(); function add_hook($tag, $function, $priority = 10) { global $hook; $hook->add_hook($tag, $function, $priority);
$page = 0; } } else { if ($page == 2 or $page == 3) { if ($param_x == '0') { $page = 0; } } else { $page = 0; } } } // Cool, validated parameters exist, this doesn't mean they are truly valid however if ($page == 1) { // Start search query page $playername = $db->escape($param_x); $sql = "SELECT * FROM " . $config->my_war3source_table . " WHERE lower(concat(name)) like lower('%" . $playername . "%') LIMIT 20"; $result = $db->get_results($sql); $sql = "SELECT shortname,name FROM " . $config->my_war3sourceraces_table; $races = $db->get_results($sql); //$db->debug(); ?> <table class="players_table"> <a href="index.php"><p style="text-align:center">Back to War3 Stats Main Page</p></a> <br /> <tr class="player_row"> <td class="td_name">Name</td>
<?php define('DB_USER', ''); define('DB_PASSWORD', ''); define('DB_NAME', ''); define('DB_HOST', 'localhost'); define('PLAYERS_TABLE', 'sauer_players'); require_once 'ez_sql_core.php'; require_once 'ez_sql_mysql.php'; $db = new ezSQL_mysql(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); $name = $db->escape($_GET['name']); $ip = $db->escape($_GET['ip']); $row = $db->get_row("SELECT * FROM `" . PLAYERS_TABLE . "` WHERE `name` = '{$name}' AND `ip` = '{$ip}'"); if ($row) { $db->query("UPDATE `" . PLAYERS_TABLE . "` SET `last_connect` = NOW(), `connects` = '" . ($row->connects + 1) . "' WHERE `id` = '{$row->id}'"); } else { $db->query("INSERT INTO `" . PLAYERS_TABLE . "` (`name`, `ip`, `first_connect`, `last_connect`, `connects`) VALUES('{$name}', '{$ip}', NOW(), NOW(), 1)"); } echo "Done.";