function allianz($aid) { global $db, $n; $result = $db->query("SELECT name,aid FROM cc" . $n . "_allianz WHERE aid='{$aid}'"); $row = $db->fetch_array($result); return $row['aid'] != $aid ? 0 : c_trim($row['name']); }
$my_ip = ""; if ($ft_titel_new == "") { show_error('ln_error_8', $modul_name); header("LOCATION: forum.php?action=new_threadid&ft_id={$ft_id}"); exit; } if ($ft_titel_text == "") { show_error('ln_error_9', $modul_name); header("LOCATION: forum.php?action=new_threadid&ft_id={$ft_id}"); exit; } if ($uid <= 0) { show_error('ln_error_10', $modul_name); exit; } $ft_titel_text = c_trim($ft_titel_text); $db->query("INSERT INTO cc" . $n . "_forum_topics (si_topic_title,si_topic_create_uid ,si_topic_create_uname ,si_topic_create_time,si_forum_id,si_topic_last_post_time,si_topic_last_post_name,si_topic_last_post_uid) VALUES ('" . $ft_titel_new . "','" . $uid . "','" . $uname . "','" . $date . "','" . $ft_id . "','" . $date . "','" . $uname . "','" . $uid . "')"); $ulast_id = $db->insert_id(); $db->query("INSERT INTO cc" . $n . "_forum_posts (si_forum_id ,si_topic_id ,si_poster_id,si_poster_name,si_post_text ,si_post_time,si_poster_ip ) VALUES ('" . $f_id . "','" . $ulast_id . "','" . $uid . "','" . $uname . "','." . $ft_titel_text . "','" . $date . "','" . $my_ip . "')"); $db->unbuffered_query("UPDATE cc" . $n . "_forum SET si_count_topic =si_count_topic +1 ,si_count_post=si_count_post+1 WHERE si_forum_id ='" . $ft_id . "' "); header("LOCATION: forum.php?action=show_forum&f_id={$ft_id}"); exit; } if ($action == "show_post") { $ft_id = intval($_GET['ft_id']); $f_id = intval($_GET['f_id']); if ($ft_id <= 0) { header("LOCATION: forum.php"); exit; } if ($f_id <= 0) {
$result_users = $db->query($sql); $como = "<select class=\"combo\" name=\"selkat\">"; while ($row_g = $db->fetch_array($result_users)) { $como .= "<option value=\"" . $row_g['admin_sub_id'] . "\">" . $row_g['admin_sub_name'] . "</option>"; } $como .= "</select>"; $tpl->assign('menu_name', $menu_name); $tpl->assign('var_count', $variablen_count); $tpl->assign('combo_cat', $como); template_out('gameoptions.html', $modul_name); exit; } if ($action == "new_save") { $new_var_name = c_trim($_POST['varname']); $new_var_titel = c_trim($_POST['vartitel']); $new_var_type = c_trim($_POST['select_type']); $new_var_kat = intval($_POST['selkat']); $first_char = substr($new_var_name, 0, 3); if ($first_char != "op_") { error_msg("Es ist ein Fehler aufgetrten.<br>Bitte darauf achten, das alle Variablen mit 'op_' beginnen !!! "); exit; } if ($new_var_name == "" or $new_var_titel == "" or $new_var_type == "" or $new_var_kat <= 0) { error_msg("Es ist ein Fehler aufgetrten."); exit; } $db->unbuffered_query("INSERT INTO cc" . $n . "_menu_admin_opt SET varname='{$new_var_name}' , title='{$new_var_titel}',type='{$new_var_type}', admin_sub_id='{$new_var_kat}', \tsave='1'"); template_out('gameoptions.html', $modul_name); exit; } if ($action == "sel_cat") {
$userid_r = $db->insert_id(); $db->query("INSERT INTO cc" . $n . "_countries (res1,res2,res3,res4,userid,lastressources,picid,x,y,size) VALUES ('{$op_reg_res1}','{$op_reg_res2}','{$op_reg_res3}','{$op_reg_res4}','{$userid_r}','" . time() . "','1','{$x_pos}','{$y_pos}','" . rand($op_min_c_size, $op_max_c_size) . "')"); $islandid_r = $db->insert_id(); $db->query("UPDATE cc" . $n . "_crand SET used='1' WHERE x='" . $x_pos . "' AND y='" . $y_pos . "'"); $db->query("UPDATE cc" . $n . "_users SET activeid='{$islandid_r}' WHERE userid='{$userid_r}'"); send_register_mail($email, "mail_register.html", $modul_name, $username, $password, $x_pos, $y_pos); show_error("REGISTER_SUBMIT_OK", $modul_name); exit; } if ($action == "forgott") { template_out('register_forgott.html', $modul_name); exit; } if ($action == "submit_forgott") { $username = c_trim(strtolower($_POST['username'])); $email = c_trim(strtolower($_POST['email'])); if ($username == "") { show_error("REGISTER_ERROR_2", $modul_name); exit; } if (!preg_match("/^[0-9a-z_-]{3,15}\$/i", $username)) { show_error("REGISTER_ERROR_4", $modul_name); exit; } if ($email == "") { show_error("REGISTER_ERROR_2", $modul_name); exit; } $result = $db->query("SELECT username,email,password FROM cc" . $n . "_users WHERE username='******'"); $row = $db->fetch_array($result); if ($row['username'] != $username) {
function get_rang_name_from_allianz_rang($allianz_rang_id, $alli_id) { global $db, $n, $userdata; $name = ""; $result_s = $db->query("SELECT rangname FROM cc" . $n . "_allianz_rang WHERE allianz_rang_id ='{$allianz_rang_id}' and allianz_id ='{$alli_id}'"); while ($row_s = $db->fetch_array($result_s)) { $name = c_trim($row_s['rangname']); } return $name; }
global $tpl; $modul_name = "acp_login"; $tpl->assign('if_disable_menu', 1); $tpl->assign('LITO_ERROR_MSG', $error_msg); $tpl->assign('if_login_error', 1); template_out('login.html', $modul_name); } if ($action == "main") { //$tpl ->display("login/login.html"); $tpl->assign('if_disable_menu', 1); template_out('login.html', $modul_name); exit; } if ($action == "submit") { $username = strtolower($_POST['username']); $password = c_trim($_POST['password']); if (!$username || !$password) { login_error($ln_login_e_1); exit; } $result = $db->query("SELECT * FROM cc" . $n . "_users WHERE username='******'"); $row = $db->fetch_array($result); if (strtolower($row['username']) != $username) { trace_msg("login ERROR '{$username}' wrong username", 2); login_error($ln_login_e_2); exit; } if ($row['password'] != md5($password)) { trace_msg("login ERROR '{$username}' wrong password", 2); login_error($ln_login_e_2); exit;
$action = "main"; } if (!isset($_SESSION['userid'])) { show_error('LOGIN_ERROR', 'core'); exit; } if (is_modul_name_aktive($modul_name) == 0) { show_error('MODUL_LOAD_ERROR', 'core'); exit; } if ($action == "main") { template_out('search.html', $modul_name); exit; } if ($action == "user") { $user = c_trim($_POST['user']); if (strlen($user) <= 1) { show_error('SEARCH_ERROR_1', $modul_name); exit; } $result = $db->query("SELECT userid FROM cc" . $n . "_users"); $numOfUsers = $db->num_rows($result); $daten = ""; $result = $db->query("SELECT userid,username,points,allianzid,lastlogin,lastpoints,lastactive,status,umod,userpic FROM cc" . $n . "_users WHERE username LIKE '%{$user}%' ORDER BY points DESC "); $i = 0; while ($row = $db->fetch_array($result)) { $username = $row['username']; $userpoints = $row['points']; if ($row['lastactive'] > time() - 3600) { $online = "<span class=\"green\"> (Online)</span>"; } else {
if ($pmid == true) { $xyz = $xyz + 1; settype($pmid, integer); $db->unbuffered_query("UPDATE cc" . $n . "_messages SET archive='1', inbox='0' WHERE pmid='" . $pmid . "' AND touserid='" . $userdata['userid'] . "'"); $update = mysql_query($change); } } header("LOCATION: message.php"); exit; } elseif ($todo == "3") { $sql = "DELETE FROM cc" . $n . "_messages WHERE touserid='" . $userdata['userid'] . "'"; $db->unbuffered_query("DELETE FROM cc" . $n . "_messages WHERE touserid='" . $userdata['userid'] . "' AND archive='0'"); header("LOCATION: message.php"); exit; } header("LOCATION: message.php"); exit; } if ($action == "move") { $pmid = intval($_GET['pmid']); $to = c_trim($_GET['to']); if (!$to || !$pmid) { show_error('ln_system_error_m', $modul_name); exit; } if ($to == "archive") { $db->unbuffered_query("UPDATE cc" . $n . "_messages SET archive='1', inbox='0' WHERE pmid='" . $pmid . "' AND touserid='" . $userdata[userid] . "'"); header("LOCATION: message.php{$SID_1}"); } exit; }
} else { $modules_game_counter_new++; } } } } closedir($scandir); $tpl->assign('modules', $new_found); $tpl->assign('modul_acp_count', $modules_acp_counter); $tpl->assign('modul_acp_count_new', $modules_acp_counter_new); $tpl->assign('modul_game_count_new', $modules_game_counter_new); template_out('modulmgrscan.html', $modul_name); exit; } if ($action == "install") { $m_name = c_trim($_GET['id']); $setup_filename = LITO_ROOT_PATH . "acp/tmp/" . $m_name . "/setup.php"; if (is_file($setup_filename)) { include LITO_ROOT_PATH . "acp/includes/ftp_class.php"; include LITO_ROOT_PATH . "acp/includes/package_class.php"; if (!isset($ftp) || !is_a($ftp, 'ftp')) { $ftp = new ftp($ftphost, $ftpuser, $ftppassword, $ftproot, $ftpport); } $pm = new package($m_name, $ftp); if (!$pm->initialized) { die('Schwerer Fehler!'); } $pm->install(); $tpl->assign('debug', $pm->debug()); template_out('action.html', $modul_name); } else {
$tpl->assign('USER_ICQ', $userdata['icq']); $tpl->assign('USER_USERMAILS', $userdata['email']); $tpl->assign('USER_USERIMAGE', $userpic); $tpl->assign('USER_USERNAME', $userdata['username']); template_out('members_userdata.html', $modul_name); exit; } if ($action == "saveuserdata") { $umod1 = intval($_POST['urlaub']); $email = c_trim($_POST['email']); $password_old = c_trim($_POST['password_old']); $password_new_first = c_trim($_POST['password_new_first']); $password_new_second = c_trim($_POST['password_new_second']); $newsletter = intval($_POST['newsletter']); $icq = c_trim($_POST['icq']); $msn = c_trim($_POST['msn']); $description = $_POST['description']; $design_id = intval($_POST['coose_design']); if ($design_id <= 0) { $design_id = 1; } $db->unbuffered_query("UPDATE cc" . $n . "_users SET design_id = '" . $design_id . "', umod ='" . $umod1 . "',msn='" . $msn . "',icq='" . $icq . "',description='" . $description . "',email='" . $email . "', newsletter='" . $newsletter . "', grafik='" . $grafik . "' WHERE userid='" . $userdata['userid'] . "'"); if ($password_old != "" and $password_new_first != "" and $password_new_first != "") { $result = $db->query("SELECT password FROM cc" . $n . "_users WHERE userid='{$userdata['userid']}'"); $row = $db->fetch_array($result); if ($row['password'] == md5($password_old)) { if ($password_new_first == $password_new_second) { $md5_pw = md5($password_new_first); $db->query("UPDATE cc" . $n . "_users SET password='******' WHERE userid='" . $userdata['userid'] . "'"); } else { show_error("ln_members_e_2", $modul_name);
$name = c_trim($row_s['name']); $tabless_name = $row_s['tabless']; $out_buildings .= $name . " [" . $row2[$tabless_name] . "]\n"; } $explore_infos = ""; $result_s = $db->query("SELECT * FROM cc" . $n . "_explore WHERE race='{$target_race}'"); while ($row_s = $db->fetch_array($result_s)) { $name = c_trim($row_s['name']); $tabless_name = $row_s['tabless']; $explore_infos .= $name . " [" . $row2[$tabless_name] . "]\n"; } $sol_infos = ""; $name = ""; $result_ss = $db->query("SELECT * FROM cc" . $n . "_soldiers WHERE race='{$target_race}'"); while ($row_ss = $db->fetch_array($result_ss)) { $name = c_trim($row_ss['name']); $tabless_name = $row_ss['tabless']; $sol_infos .= $name . " [" . $row2[$tabless_name] . "]\n"; } $tpl->assign('out_buildings', $out_buildings); $tpl->assign('explore_infos', $explore_infos); $tpl->assign('sol_infos', $sol_infos); $tpl->assign('spioland', $spioland); $spion_message = $tpl->fetch(LITO_THEMES_PATH . $modul_name . '/spion_message_ok.html'); } else { $tpl->assign('spioland', $spioland); $spion_message = $tpl->fetch(LITO_THEMES_PATH . $modul_name . '/spion_message_nok.html'); } $db->query("DELETE FROM cc" . $n . "_spions WHERE spionid='{$spion_id}'"); make_ingamemail(0, $userdata['userid'], "Spionage auf " . $spioland, $spion_message); }