Sms War3 Addxp

php><php · October 28, 2009

Sveiki !

Sēžu ilgi un netieku skaidrībā ar sekojošu scriptu war3 addxp

Lieta tāda ievadu parametrus a man met ārā

1. Kļūda. Lai pievienotu XP tev vajag vismaz vienu reizi paspēlēt ar to rasi 
2. Vai nu tu neizvelējies Cik XP pievienot

php kods kas izpilda funkciju

<html xmlns="[url="http://www.w3.org/1999/xhtml"]http://www.w3.org/1999/xhtml[/url]">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>War3 EXP</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<style type="text/css">
</style>
</head>
<body>
<div id="container">
<div id="header"><img src="logo.png" alt=""></div>
<div id="menu">
</div>
<p> </p>
<p align="center"> </p>
<p align="center">
  <?
include('config.php');

$code = $_POST['smscode'];
$price = $_POST['cena'];
$uid = 99; // Sms Klienta ID
mysql_connect ($host, $mysql_user, $mysql_pw)or die("neizdevās piekonektēties: ".mysql_error());
mysql_select_db($db);

$check = mysql_query("SELECT `player_id` FROM `wc3_player` WHERE `player_name`='".$nick."'");
$exist = mysql_num_rows($check);
if($exist > 0)
{
$result = join('', file("http://sms.sniedzejs.lv/confirm.php?id=$uid&code=$code&price=$price"));
if ($result == "key_ok") {

$nick = addslashes($_POST['nick']);
$race_id = addslashes($_POST['race_id']);
$new = mysql_result(mysql_query("SELECT `player_id` FROM `wc3_player` WHERE `player_name`='".$nick."'"), 0, 0);

$race_xp_before = mysql_result(mysql_query("SELECT `race_xp` FROM `wc3_player_race` WHERE `player_id`='".$new."' AND `race_id`='".$race_id."'"), 0, 0);

if ($price == 15 ) {
$cik_exp_pievienot = $xp15;
}
elseif ($price == 35 ) {
$cik_exp_pievienot = $xp35;
}
elseif ($price == 95 ) {
$cik_exp_pievienot = $xp95;
}
elseif ($price == 200 ) {
$cik_exp_pievienot = $xp200;
}
elseif ($price == 300 ) {
$cik_exp_pievienot = $xp300;
}

else {
die("Tu kaut kur kļūdies<p> <p> <p> <script>alert('Atgriezties atpakaļ');window.back()</script>");
}

$race_xp = $race_xp_before + $cik_exp_pievienot;
mysql_query(" REPLACE INTO `wc3_player_race` SET `player_id`='".$new."', `race_id` ='".$race_id."', `race_xp`='".$race_xp."' ");
echo "<b>Exp Pievienots. </b>
";

}  
    elseif ($result == 'key_bad1') {
      echo "Ievadītais kods ir nepareizs vai nederīgs. Mēģini vēlreiz.";
   echo "<p> ";
   echo "<p> ";
   echo "<script>alert('Atgriezties atpakaļ');window.back()</script>";
}
    else {
  echo "Kļūda. Lūdzu mēģini vēlreiz.";
  echo "<p> ";
  echo "<p> ";
  echo "<script>alert('Atgriezties atpakaļ');window.back()</script>";
}
}
    else {
               echo "<p>1. Kļūda. Lai pievienotu XP tev vajag vismaz vienu reizi paspēlēt ar to rasi";
               echo "<p>2. Vai nu tu neizvelējies Cik XP pievienot";
      echo "<p> ";
      echo "<p> ";
            echo "<script>alert('Atgriezties atpakaļ');window.back()</script>";
               exit();
}




?>
</p>
<p align="center"> </p>
<p align="center"> </p>
<p align="center"> </p>

</body>
</html>

Mysql Bāze

wc3_config:

CREATE TABLE IF NOT EXISTS `wc3_config` (

`config_id` varchar(50) NOT NULL,

`config_value` varchar(255) NOT NULL,

PRIMARY KEY (`config_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dati tabulai `wc3_config`

--

INSERT INTO `wc3_config` (`config_id`, `config_value`) VALUES

('level0_xp', '0'),

('level1_xp', '400'),

('level2_xp', '800'),

('level3_xp', '1600'),

('level4_xp', '3200'),

('level5_xp', '6400'),

('level6_xp', '12800'),

('level7_xp', '25600'),

('level8_xp', '51200'),

('level9_xp', '102400'),

('level10_xp', '204800'),

('version', '3.0 RC13'),

('sql_conversion', '1');

wc3_player

CREATE TABLE IF NOT EXISTS `wc3_player` (
  `player_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `player_steamid` varchar(25) NOT NULL DEFAULT '',
  `player_ip` varchar(20) NOT NULL DEFAULT '',
  `player_name` varchar(35) NOT NULL DEFAULT '',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`player_id`),
  KEY `player_name` (`player_name`),
  KEY `player_ip` (`player_ip`),
  KEY `player_steamid` (`player_steamid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5430;

--
-- Dati tabulai `wc3_player`
--

INSERT INTO `wc3_player` (`player_id`, `player_steamid`, `player_ip`, `player_name`, `time`) VALUES
(3, '', '', 'Karote', '2009-10-27 23:12:45');

wc3_player_race:

CREATE TABLE IF NOT EXISTS `wc3_player_race` (
  `player_id` int(8) unsigned NOT NULL DEFAULT '0',
  `race_id` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `race_xp` int(8) DEFAULT NULL,
  PRIMARY KEY (`player_id`,`race_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dati tabulai `wc3_player_race`
--

INSERT INTO `wc3_player_race` (`player_id`, `race_id`, `race_xp`) VALUES
(3, 4, 215),

Kur varētu būt tā kļūda ?

Edited October 28, 2009 by php><php

spyseed · October 29, 2009

Man ir tieši tāda pati problēma.

Gudrie GIGNIEŠI varbūt palīdzēsiet?

X ID · October 29, 2009

Mainīgais $nick, kas tiek izmantots pārbaudes kverijā (kurš ir ideoloģiski stulbs), tiek definēts tikai pēc kverija sastādīšanas. Tālāk domā pats.

P.S. Kodu parasti debugo, izveidojot mysql_query($sql)or die(); un izvada arī $sql, lai apskatītos kā vispār izskatās sastādītais pieprasījums.

Sign In

Sms War3 Addxp

Recommended Posts

php><php

Link to comment

Share on other sites

spyseed

Link to comment

Share on other sites

X ID

Link to comment

Share on other sites

Please sign in to comment

GIGN Forums

Activity