예제 #1
0
            $start_map_x = $row["map_x"];
            $start_map_y = $row["map_y"];
            $avatar = $avatar . '_' . $sex . '.gif';
            $result = myquery("\n\t\t\tINSERT game_users SET\n\t\t\tuser_name='{$user_name}',\n\t\t\tuser_pass='******',\n\t\t\tname='{$name}',\n\t\t\tHP='{$hp1}',\n\t\t\tHP_MAX='{$hp_max1}',\n\t\t\tMP='{$mp1}',\n\t\t\tMP_MAX='{$mp_max1}',\n\t\t\tSTM='{$stm1}',\n\t\t\tSTM_MAX='{$stm_max1}',\n\t\t\tEXP='{$exp1}',\n\t\t\tGP='{$gp1}',\n\t\t\tSTR='{$str1}',\n\t\t\tNTL='{$ntl1}',\n\t\t\tPIE='{$pie1}',\n\t\t\tVIT='{$vit1}',\n\t\t\tDEX='{$dex1}',\n\t\t\tSPD='{$spd1}',\n\t\t\tSTR_MAX='{$str1}',\n\t\t\tNTL_MAX='{$ntl1}',\n\t\t\tPIE_MAX='{$pie1}',\n\t\t\tVIT_MAX='{$vit1}',\n\t\t\tDEX_MAX='{$dex1}',\n\t\t\tSPD_MAX='{$spd1}',\n\t\t\tCW='" . $gp1 * money_weight . "',\n\t\t\tCC=40,\n\t\t\trace='" . $row['id'] . "',\n\t\t\tavatar='{$avatar}'\n\t\t\t") or die('Database Error: ' . mysql_error() . '<br>');
            //lucky='$lucky1',
            //lucky_max='$lucky1',
            //vospr='$vospr1',
            //vospr_max='$vospr1',
            //magic_res='$magic_res1',
            //magic_res_max='$magic_res1',
            $result = myquery("DELETE FROM game_users_reg WHERE user_name = '{$user_name}'");
            list($uid) = mysql_fetch_array(myquery("SELECT user_id FROM game_users WHERE user_name='{$user_name}'"));
            $result = myquery("\n\t\t\tINSERT game_users_map SET\n\t\t\tuser_id='{$uid}',\n\t\t\tmap_name='{$start_map_name}',\n\t\t\tmap_xpos='{$start_map_x}',\n\t\t\tmap_ypos='{$start_map_y}'\n\t\t\t") or die('Database Error: ' . mysql_error() . '<br>');
            $result = myquery("\n\t\t\tINSERT game_users_data SET\n\t\t\tuser_id='{$uid}',\n\t\t\temail='{$email}',\n\t\t\tstatus='{$STATUS}',\n\t\t\tgorod='{$gorod}',\n\t\t\thobbi='{$hobbi}',\n\t\t\tinfo='{$info}',\n\t\t\tdr_date='{$dr_date}',\n\t\t\tdr_month='{$dr_month}',\n\t\t\tdr_year='{$dr_year}',\n\t\t\tsex='{$sex}',\n\t\t\trego_time='{$rego_time}'\n\t\t\t") or die('Database Error: ' . mysql_error() . '<br>');
            myquery("INSERT INTO game_users_active (user_id,host,last_active) VALUES ('{$uid}','" . HostIdentify() . "','')");
            myquery("INSERT INTO game_users_active (user_id,host_more) VALUES ('{$uid}','" . HostIdentifyMore() . "')");
            myquery("INSERT INTO game_chat_option (user_id,ref,size,frame) VALUES ('{$uid}','1','10','220')");
            $da = getdate();
            $log = myquery("INSERT INTO game_log_adm (adm,dei,cur_time,day,month,year) \n\t\t\t VALUES (\n\t\t\t '" . $char['name'] . "',\n\t\t     'Активировал регистрацию игрока: <b>" . $name . "</b>',\n\t\t\t '" . time() . "',\n\t\t\t '" . $da['mday'] . "',\n\t\t\t '" . $da['mon'] . "',\n\t\t\t '" . $da['year'] . "')") or die(mysql_error());
        }
        echo '<meta http-equiv="refresh" content="1;url=?opt=main&option=activate">';
    }
    if (isset($delete)) {
        echo 'Регистрация удалена';
        $nazv = mysql_result(myquery("SELECT name FROM game_users_reg where id='{$delete}'"), 0, 0);
        $da = getdate();
        $log = myquery("INSERT INTO game_log_adm (adm,dei,cur_time,day,month,year) \n\t\t VALUES (\n\t\t '" . $char['name'] . "',\n\t\t 'Удалил регистрацию игрока: <b>" . $nazv . "</b>',\n\t\t '" . time() . "',\n\t\t '" . $da['mday'] . "',\n\t\t '" . $da['mon'] . "',\n\t\t '" . $da['year'] . "')") or die(mysql_error());
        $up = myquery("delete from game_users_reg where id='{$delete}'");
        echo '<meta http-equiv="refresh" content="1;url=?opt=main&option=activate">';
    }
}
예제 #2
0
         $up = myquery("INSERT INTO game_users SELECT * FROM game_users_archive WHERE user_name='{$user_name}' LIMIT 1");
         $up = myquery("DELETE FROM game_users_archive WHERE user_name='{$user_name}'");
     }
 }
 $sel = myquery("SELECT * FROM game_users WHERE name='{$user_name}'");
 if (!mysql_num_rows($sel)) {
     echo 'Игрок не найден!';
 } else {
     $user = mysql_fetch_array($sel);
     if ($user['clan_id'] == 1) {
         echo 'Нельзя заходить за Создателей';
     } else {
         $user_id = $user['user_id'];
         $_SESSION['user_id'] = $user['user_id'];
         $user_host = HostIdentify();
         $user_host_more = HostIdentifyMore();
         //$_SESSION['user_host_ip'] = $user_host;
         $user_time = time();
         myquery("INSERT INTO game_users_active SET last_active='{$user_time}', host='{$user_host}', user_id='{$user_id}' ON DUPLICATE KEY UPDATE last_active='{$user_time}',host='{$user_host}'");
         myquery("INSERT INTO game_users_active_host SET host_more='{$user_host_more}', user_id='{$user_id}' ON DUPLICATE KEY UPDATE host_more='{$user_host_more}'");
         myquery("INSERT INTO game_users_active_delay SET delay_reason='0', user_id='{$user_id}' ON DUPLICATE KEY UPDATE delay_reason='0'");
         myquery("INSERT IGNORE INTO game_users_func (`user_id`,`func_id`) VALUES ('" . $user_id . "','5')");
         myquery("INSERT IGNORE INTO game_users_data SET user_id='{$user_id}'");
         /*
         ?>
         <script type="text/javascript" language="JavaScript">
         setCookie("rpgsu_login", "<?=$user['user_name'];?>", , "/");
         setCookie("rpgsu_pass", "<?=md5($user['user_pass']);?>", , "/");
         setCookie("rpgsu_sess", "<?=$_COOKIE['rpgsu_sess'];?>", , "/");
         </script>
         Выполнено!
예제 #3
0
function Activate()
{
    global $_GET;
    echo '<center>';
    echo '<table border="0" cellspacing="0" cellpadding="0" align=center>
	<tr>
	<td width="15"><img src="http://' . img_domain . '/nav/1_01.jpg" width="15" height="33"></td>
	<td width="23" background="http://' . img_domain . '/nav/1_03.jpg"><img src="http://' . img_domain . '/nav/1_04_1.jpg" width="70" height="33"></td>
	<td width="879" background="http://' . img_domain . '/nav/1_03.jpg"><div align="center"><br>Средиземье :: Активация</div></td>
	<td width="70" background="http://' . img_domain . '/nav/1_03.jpg"><img src="http://' . img_domain . '/nav/1_04.jpg" width="70" height="33"></td>
	<td width="10"><img src="http://' . img_domain . '/nav/1_05.jpg" width="15" height="33"></td>
	</tr>
	<tr>
	<td width="15" height="90" background="http://' . img_domain . '/nav/1_16.jpg"></td>
	<td colspan="3"><div align="center">
	<table width="100%" height="50"  border="0" align="right" cellpadding="0" cellspacing="0">
	<tr>
	<td width="5"><img src="http://' . img_domain . '/nav/1_07.jpg" width="5" height="6"></td>
	<td background="http://' . img_domain . '/nav/1_09.jpg"></td>
	<td width="5"><img src="http://' . img_domain . '/nav/1_10.jpg" width="7" height="6"></td>
	</tr>
	<tr>
	<td width="5" height="100" background="http://' . img_domain . '/nav/1_17.jpg"></td>
	<td height="50" bgcolor="313131" align="center" valign="center">';
    @($user_name = $_GET['user_name']);
    @($validate = $_GET['validate']);
    if (isset($user_name) && isset($validate)) {
        $result = myquery("SELECT user_name, user_pass, name, email, race, STATUS, gorod, hobbi, info, uid, validate, rego_time, dr_date, dr_month, dr_year, sex FROM game_users_reg WHERE user_name='{$user_name}' AND validate='{$validate}' LIMIT 1");
        if (mysql_num_rows($result) != 0) {
            list($user_name, $user_pass, $name, $email, $race, $STATUS, $gorod, $hobbi, $info, $uid, $validate, $rego_time, $dr_date, $dr_month, $dr_year, $sex) = mysql_fetch_row($result);
            $result = myquery("SELECT * FROM game_har WHERE name='{$race}' and disable=0");
            if (mysql_num_rows($result) == 0) {
                echo 'Ошибка активации [Неправильная Раса]';
            } else {
                $row = mysql_fetch_array($result);
                $hp1 = $row["hp"];
                $hp_max1 = $row["hp_max"];
                $mp1 = $row["mp"];
                $mp_max1 = $row["mp_max"];
                $stm1 = $row["stm"];
                $stm_max1 = $row["stm_max"];
                $exp1 = $row["exp"];
                if ($uid != '') {
                    $uid = (int) $uid;
                    $u = myquery("SELECT name FROM game_users WHERE user_id='{$uid}'");
                    if (!mysql_num_rows($u)) {
                        $u = myquery("SELECT name FROM game_users_archive WHERE user_id='{$uid}'");
                    }
                    $host_p = mysql_result(myquery("SELECT host FROM game_users_active WHERE user_id='{$uid}'"), 0, 0);
                    list($name_p) = mysql_fetch_array($u);
                    $user_host_p = HostIdentify();
                    if (isset($uid) and $user_host_p != $host_p) {
                        $gp1 = '150';
                        $up = myquery("update game_users SET GP=GP+50,CW=CW+'" . 50 * money_weight . "' WHERE user_id='{$uid}'");
                        setGP($uid, 50, 3);
                        $up = myquery("update game_users_archive SET GP=GP+50,CW=CW+'" . 50 * money_weight . "' WHERE user_id='{$uid}'");
                    } else {
                        $gp1 = $row["gp"];
                    }
                } else {
                    $gp1 = $row["gp"];
                }
                $str1 = $row["str"];
                $ntl1 = $row["ntl"];
                $pie1 = $row["pie"];
                $vit1 = $row["vit"];
                $dex1 = $row["dex"];
                $spd1 = $row["spd"];
                //$lucky1=$row["lucky"];
                //$vospr1=$row["vospr"];
                //$magic_res1=$row["magic_res"];
                $avatar = $row["race"];
                $start_map_name = $row["map_name"];
                $start_map_x = $row["map_x"];
                $start_map_y = $row["map_y"];
                $avatar = $avatar . '_' . $sex . '.gif';
                $result = myquery("\n\t\t\t\tINSERT game_users SET\n\t\t\t\tuser_name='{$user_name}',\n\t\t\t\tuser_pass='******',\n\t\t\t\tname='{$name}',\n\t\t\t\tHP='{$hp1}',\n\t\t\t\tHP_MAX='{$hp_max1}',\n\t\t\t\tHP_MAXX='{$hp_max1}',\n\t\t\t\tMP='{$mp1}',\n\t\t\t\tMP_MAX='{$mp_max1}',\n\t\t\t\tSTM='{$stm1}',\n\t\t\t\tSTM_MAX='{$stm_max1}',\n\t\t\t\tEXP='{$exp1}',\n\t\t\t\tGP='{$gp1}',\n\t\t\t\tSTR='{$str1}',\n\t\t\t\tNTL='{$ntl1}',\n\t\t\t\tPIE='{$pie1}',\n\t\t\t\tVIT='{$vit1}',\n\t\t\t\tDEX='{$dex1}',\n\t\t\t\tSPD='{$spd1}',\n\t\t\t\tSTR_MAX='{$str1}',\n\t\t\t\tNTL_MAX='{$ntl1}',\n\t\t\t\tPIE_MAX='{$pie1}',\n\t\t\t\tVIT_MAX='{$vit1}',\n\t\t\t\tDEX_MAX='{$dex1}',\n\t\t\t\tSPD_MAX='{$spd1}',\n\t\t\t\tCW='" . $gp1 * money_weight . "',\n\t\t\t\tCC=40,\n\t\t\t\trace='" . $row['id'] . "',\n\t\t\t\tavatar='{$avatar}'\n\t\t\t\t") or die('Database Error: ' . mysql_error() . '<br>');
                //lucky='$lucky1',
                //lucky_max='$lucky1',
                //vospr='$vospr1',
                //vospr_max='$vospr1',
                //magic_res='$magic_res1',
                //magic_res_max='$magic_res1',
                $result = myquery("DELETE FROM game_users_reg WHERE user_name = '{$user_name}'");
                list($uid) = mysql_fetch_array(myquery("SELECT user_id FROM game_users WHERE user_name='{$user_name}'"));
                $result = myquery("\n\t\t\t\tINSERT game_users_map SET\n\t\t\t\tuser_id='{$uid}',\n\t\t\t\tmap_name='{$start_map_name}',\n\t\t\t\tmap_xpos='{$start_map_x}',\n\t\t\t\tmap_ypos='{$start_map_y}'\n\t\t\t\t") or die('Database Error: ' . mysql_error() . '<br>');
                $result = myquery("\n\t\t\t\tINSERT game_users_data SET\n\t\t\t\tuser_id='{$uid}',\n\t\t\t\temail='{$email}',\n\t\t\t\tstatus='{$STATUS}',\n\t\t\t\tgorod='{$gorod}',\n\t\t\t\thobbi='{$hobbi}',\n\t\t\t\tinfo='{$info}',\n\t\t\t\tdr_date='{$dr_date}',\n\t\t\t\tdr_month='{$dr_month}',\n\t\t\t\tdr_year='{$dr_year}',\n\t\t\t\tsex='{$sex}',\n\t\t\t\trego_time='{$rego_time}'\n\t\t\t\t") or die('Database Error: ' . mysql_error() . '<br>');
                myquery("INSERT INTO game_users_active (user_id,host,last_active) VALUES ('{$uid}','" . HostIdentify() . "','')");
                myquery("INSERT INTO game_users_active_host (user_id,host_more) VALUES ('{$uid}','" . HostIdentifyMore() . "')");
                myquery("INSERT INTO game_chat_option (user_id,ref,size,frame) VALUES ('{$uid}','1','13','220')");
                echo 'Спасибо <b>' . $name . '</b>, вы активированы! <br>';
                if ($uid != '' and $gp1 == 150) {
                    echo '<br>Вы пришли по сcылке игрока ' . $name_p . '. У вас 150 монет на начало игры!';
                }
                echo '<br><br><a href="' . $_SERVER['PHP_SELF'] . '">Вернуться на главную</a>';
            }
        } else {
            echo '<center>Ошибка активации [Неправильный код]</center>';
        }
    } else {
        echo '<center>Ошибка активации</center>';
    }
    echo '</td>
	<td  width="5" height="50" background="http://' . img_domain . '/nav/1_15.jpg"></td>
	</tr>
	<tr>
	<td width="5"><img src="http://' . img_domain . '/nav/1_19.jpg" width="5" height="8"></td>
	<td background="http://' . img_domain . '/nav/1_20.jpg"></td>
	<td><img src="http://' . img_domain . '/nav/1_22.jpg" width="7" height="8"></td>
	</tr>
	</table>
	</div>
	</td>
	<td width="15" background="http://' . img_domain . '/nav/333_17.jpg">&nbsp;</td>
	</tr>
	<tr>
	<td width="15"><img src="http://' . img_domain . '/nav/1_23.jpg" width="15" height="14"></td>
	<td colspan="3" background="http://' . img_domain . '/nav/1_25.jpg"></td>
	<td><img src="http://' . img_domain . '/nav/1_26.jpg" width="15" height="14"></td>
	</tr></table>';
}