$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.";
