[Guide] Как да си направим депосити на камъни в сайта

Dude · Mar 7, 2015

Сега ще ви покажа как да си сложите депозити в сайта и как да ги теглите !

Първо ще ви трябват тези таблици:

PHP:

CREATE TABLE Jewels ([acc] [varchar] (10)  NOT NULL ,[Soul] [bigint] NOT NULL default (0),[Bless] [bigint] NOT NULL default (0)) ON [PRIMARY];

Правите си файл да кажем soul.php и слагате това:

PHP:

<table align="center" width="400" id="main">
<form method="POST" action="">
<tr><td><b>Account:</b></td><td><input type="text" name="acc" size="25"/></td></tr>
<tr><td><b>Password:</b></td><td><input type="password" name="pass" size="25"/></td></tr>
<tr><td></td><td><input type="submit" name="submit" value="Deposit" /></td></tr>
</form>
</table>
<?
if (isset($_POST['submit'])) {
$host = "127.0.0.1";
$database = "MuOnline";
$user = "sa";
$password = "SQL PAROLA";
if (extension_loaded('gd')){echo("");}
else{Die("<center>Loading php_gd2.dll Failed!<br>Please Enable php_gd2.dll In Your Php.ini</center>");}

$connect = mssql_connect($host,$user,$password);
$db = mssql_select_db($database,$connect);
if(!$db) die('<center>Connection with SQL Server failed!</center>');

$account = htmlspecialchars(addslashes($_POST['acc']));
$pass= htmlspecialchars(addslashes($_POST['pass']));

$querya = mssql_query("SELECT * From MEMB_STAT where memb___id='$account' and ConnectStat='1'");
$rowa = mssql_num_rows($querya);

$queryacc = mssql_query("SELECT * From MEMB_INFO where memb___id='$account' and memb__pwd='$pass'");
$rowacc = mssql_num_rows($queryacc);

if($rowa>0){ echo "Your Account is Online"; $err=1;}
elseif($rowacc<=0){ echo "Wrong Password or Account"; $err=1;}
if ($err!=1) {
function soul($account){
$query= mssql_query("declare @it varbinary(1200); 
set @it=(select [Items] from [warehouse] where [AccountID]='$account'); 
print @it");
$items = substr(mssql_get_last_message(),2);

$br=0;
for($i=0;$i<120;$i++){
if(substr($items,$i*20,4)=="CE00"){$br++;$items=substr_replace($items,"FFFFFFFFFFFFFFFFFFFF",$i*20,20);}
}
$new_warehouse=mssql_query("update [warehouse] set [Items]=0x$items where [AccountID]='$account'");
return $br;
}  

$querych = mssql_query("SELECT * From Jewels where acc='$account'");
$rowch = mssql_num_rows($querych);  
$souls= soul($account);
if($rowch<=0){ 
$a = mssql_query("INSERT INTO Jewels (acc, soul) VALUES('$account', '$souls')");
echo "You Deposited $souls Soul ";
 }
 else {
$a= mssql_query("update Jewels set soul=soul+$souls where [acc]='$account'");  
echo "You Deposited $souls Soul ";
}
return $br; 
}
}
?>

Правите си файл да кажем bless.php и слагате това:

PHP:

<table align="center" width="400" id="main">
<form method="POST" action="">
<tr><td><b>acc:</b></td><td><input type="text" name="acc" size="25"/></td></tr>
<tr><td><b>Password:</b></td><td><input type="password" name="pass" size="25"/></td></tr>
<tr><td></td><td><input type="submit" name="submit" value="Register" /></td></tr>
</form>
</table>
<?
if (isset($_POST['submit'])) {
$host = "127.0.0.1";
$database = "MuOnline";
$user = "sa";
$password = "SQL PAROLA";
if (extension_loaded('gd')){echo("");}
else{Die("<center>Loading php_gd2.dll Failed!<br>Please Enable php_gd2.dll In Your Php.ini</center>");}

$connect = mssql_connect($host,$user,$password);
$db = mssql_select_db($database,$connect);
if(!$db) die('<center>Connection with SQL Server failed!</center>');

$account = stripslashes($_POST['acc']);
$pass= stripslashes($_POST['pass']);

$querya = mssql_query("SELECT * From MEMB_STAT where memb___id='$account' and ConnectStat='1'");
$rowa = mssql_num_rows($querya);

$queryacc = mssql_query("SELECT * From MEMB_INFO where memb___id='$account' and memb__pwd='$pass'");
$rowacc = mssql_num_rows($queryacc);

if($rowa>0){ echo "Your Account is Online"; $err=1;}
elseif($rowacc<=0){ echo "Wrong Password or Account"; $err=1;}
if ($err!=1) {
function bless($account){
$query= mssql_query("declare @it varbinary(1200); 
set @it=(select [Items] from [warehouse] where [AccountID]='$account'); 
print @it");
$items = substr(mssql_get_last_message(),2);

$br=0;
for($i=0;$i<120;$i++){
if(substr($items,$i*20,4)=="CD00"){$br++;$items=substr_replace($items,"FFFFFFFFFFFFFFFFFFFF",$i*20,20);}
}
$new_warehouse=mssql_query("update [warehouse] set [Items]=0x$items where [AccountID]='$account'");
return $br;
}  

$querych = mssql_query("SELECT * From Jewels where acc='$account'");
$rowch = mssql_num_rows($querych);  
$bless= bless($account);
if($rowch<=0){ 
$a = mssql_query("INSERT INTO Jewels (acc, bless) VALUES('$account', '$bless')");
echo "You Deposited $bless Bless ";
 }
 else {
$a= mssql_query("update Jewels set Bless=Bless+$bless where [acc]='$account'");  
echo "You Deposited $bless Bless ";
}
return $br; 
}
}
?>

JEWELS WITHDRAW

QUERY CODE

PHP:

drop table allitems_soul 
CREATE TABLE [allitems_soul] ( 
[type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
[x] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
[y] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] 
GO 

DELETE FROM allitems_soul 
INSERT INTO allitems_soul VALUES ('0','0','Kris','1','2')
INSERT INTO allitems_soul VALUES ('0','1','Short Sword','1','3')
INSERT INTO allitems_soul VALUES ('0','2','Rapier','1','3')
INSERT INTO allitems_soul VALUES ('0','3','Katana','1','3')
INSERT INTO allitems_soul VALUES ('0','4','Sword of Assassain','1','3')
INSERT INTO allitems_soul VALUES ('0','5','Blade','1','3')
INSERT INTO allitems_soul VALUES ('0','6','Gladius','1','3')
INSERT INTO allitems_soul VALUES ('0','7','Falchion','1','3')
INSERT INTO allitems_soul VALUES ('0','8','Serpent Sword','1','3')
INSERT INTO allitems_soul VALUES ('0','9','Sword of Salamander','2','3')
INSERT INTO allitems_soul VALUES ('0','10','Light Saber','2','4')
INSERT INTO allitems_soul VALUES ('0','11','Legendary Sword','2','3')
INSERT INTO allitems_soul VALUES ('0','12','Helical Sword','2','3')
INSERT INTO allitems_soul VALUES ('0','13','Double Blade','1','3')
INSERT INTO allitems_soul VALUES ('0','14','Lighting Sword','1','3')
INSERT INTO allitems_soul VALUES ('0','15','Giant Sword','2','3')
INSERT INTO allitems_soul VALUES ('0','16','Sword of Destruction','1','4')
INSERT INTO allitems_soul VALUES ('0','17','Dark Breaker','2','4')
INSERT INTO allitems_soul VALUES ('0','18','Thunder Blade','2','3')
INSERT INTO allitems_soul VALUES ('0','19','Sword of Archangel','1','4')
INSERT INTO allitems_soul VALUES ('0','20','Knight Blade','1','4')
INSERT INTO allitems_soul VALUES ('0','21','Dark Reign Blade','2','4')
INSERT INTO allitems_soul VALUES ('0','22','Bone Blade','1','4')
INSERT INTO allitems_soul VALUES ('0','23','Explosion Blade','2','4')
INSERT INTO allitems_soul VALUES ('0','24','Daybreak','2','4')
INSERT INTO allitems_soul VALUES ('0','25','Sword of Dancer','2','4')
INSERT INTO allitems_soul VALUES ('0','31','Rune Blade','2','4')
INSERT INTO allitems_soul VALUES ('1','0','Small Axe','1','3')
INSERT INTO allitems_soul VALUES ('1','1','Hand Axe','1','3')
INSERT INTO allitems_soul VALUES ('1','2','Double Axe','1','3')
INSERT INTO allitems_soul VALUES ('1','3','Tomahawk','1','3')
INSERT INTO allitems_soul VALUES ('1','4','Elven Axe','1','3')
INSERT INTO allitems_soul VALUES ('1','5','Battle Axe','2','3')
INSERT INTO allitems_soul VALUES ('1','6','Nikkea Axe','2','3')
INSERT INTO allitems_soul VALUES ('1','7','Larkan Axe','2','3')
INSERT INTO allitems_soul VALUES ('1','8','Crescent Axe','2','3')
INSERT INTO allitems_soul VALUES ('2','0','Mace','1','3')
INSERT INTO allitems_soul VALUES ('2','1','Morning Star','1','3')
INSERT INTO allitems_soul VALUES ('2','2','Flail','1','3')
INSERT INTO allitems_soul VALUES ('2','3','Great Hammer','2','3')
INSERT INTO allitems_soul VALUES ('2','4','Crystal Morning Star','2','3')
INSERT INTO allitems_soul VALUES ('2','5','Crystal Sword','2','4')
INSERT INTO allitems_soul VALUES ('2','6','soul Dragon Axe','2','4')
INSERT INTO allitems_soul VALUES ('2','7','Elemental Mace','1','3')
INSERT INTO allitems_soul VALUES ('2','8','Battle Scepter','1','3')
INSERT INTO allitems_soul VALUES ('2','9','Master Scepter','1','3')
INSERT INTO allitems_soul VALUES ('2','10','Great Scepter','1','4')
INSERT INTO allitems_soul VALUES ('2','11','Lord Scepter','1','4')
INSERT INTO allitems_soul VALUES ('2','12','Great Lord Scepter','1','4')
INSERT INTO allitems_soul VALUES ('2','13','Scepter of Archangel','1','4')
INSERT INTO allitems_soul VALUES ('2','14','Solay Scepter','1','4')
INSERT INTO allitems_soul VALUES ('2','15','Shining Scepter','1','4')
INSERT INTO allitems_soul VALUES ('3','0','Light Spear','2','4')
INSERT INTO allitems_soul VALUES ('3','1','Spear','2','4')
INSERT INTO allitems_soul VALUES ('3','2','Dragon Lance','2','4')
INSERT INTO allitems_soul VALUES ('3','3','Giant Trident','2','4')
INSERT INTO allitems_soul VALUES ('3','4','Serpent Spear','2','4')
INSERT INTO allitems_soul VALUES ('3','5','Double Poleaxe','2','4')
INSERT INTO allitems_soul VALUES ('3','6','Halberd','2','4')
INSERT INTO allitems_soul VALUES ('3','7','Berdysh','2','4')
INSERT INTO allitems_soul VALUES ('3','8','Great Scythe','2','4')
INSERT INTO allitems_soul VALUES ('3','9','Bill of Balrog','2','4')
INSERT INTO allitems_soul VALUES ('3','10','Dragon Spear','2','4')
INSERT INTO allitems_soul VALUES ('4','0','Short Bow','2','3')
INSERT INTO allitems_soul VALUES ('4','1','Bow','2','3')
INSERT INTO allitems_soul VALUES ('4','2','Elven Bow','2','3')
INSERT INTO allitems_soul VALUES ('4','3','Battle Bow','2','3')
INSERT INTO allitems_soul VALUES ('4','4','Tiger Bow','2','4')
INSERT INTO allitems_soul VALUES ('4','5','Silver Bow','2','4')
INSERT INTO allitems_soul VALUES ('4','6','soul Nature Bow','2','4')
INSERT INTO allitems_soul VALUES ('4','7','Bolt','1','1')
INSERT INTO allitems_soul VALUES ('4','8','Crossbow','2','2')
INSERT INTO allitems_soul VALUES ('4','9','Golden Crossbow','2','2')
INSERT INTO allitems_soul VALUES ('4','10','Arquebus','2','2')
INSERT INTO allitems_soul VALUES ('4','11','Light Crossbow','2','3')
INSERT INTO allitems_soul VALUES ('4','12','Serpent Crossbow','2','3')
INSERT INTO allitems_soul VALUES ('4','13','Bluewing Crossbow','2','3')
INSERT INTO allitems_soul VALUES ('4','14','Aquagold Crossbow','2','3')
INSERT INTO allitems_soul VALUES ('4','15','Arrows','1','1')
INSERT INTO allitems_soul VALUES ('4','16','Saint Crossbow','2','4')
INSERT INTO allitems_soul VALUES ('4','17','Celestial Bow','2','4')
INSERT INTO allitems_soul VALUES ('4','18','Divine Crossbow of Archangel','2','3')
INSERT INTO allitems_soul VALUES ('4','19','Great Reign Crossbow','2','3')
INSERT INTO allitems_soul VALUES ('4','20','Arrow Viper Bow','2','4')
INSERT INTO allitems_soul VALUES ('4','21','Sylph Wind Bow','2','4')
INSERT INTO allitems_soul VALUES ('4','22','Albatross Bow','2','4')
INSERT INTO allitems_soul VALUES ('5','0','Skull Staff','1','3')
INSERT INTO allitems_soul VALUES ('5','1','Angelic Staff','2','3')
INSERT INTO allitems_soul VALUES ('5','2','Serpent Staff','2','3')
INSERT INTO allitems_soul VALUES ('5','3','Thunder Staff','2','4')
INSERT INTO allitems_soul VALUES ('5','4','Gorgon Staff','2','4')
INSERT INTO allitems_soul VALUES ('5','5','Legendary Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','6','Staff of Resurrection','1','4')
INSERT INTO allitems_soul VALUES ('5','7','soul Lighting Staff','2','4')
INSERT INTO allitems_soul VALUES ('5','8','Staff of Destruction','2','4')
INSERT INTO allitems_soul VALUES ('5','9','Grand soul Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','10','Staff of Archangel','1','4')
INSERT INTO allitems_soul VALUES ('5','11','Kundun Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','12','Grand Viper Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','13','Platina Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','14','Mistery Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','15','Violent Wind Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','16','Red Wing Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','17','Ancient Staff','1','4')
INSERT INTO allitems_soul VALUES ('5','21','Book of Sahamutt','1','2')
INSERT INTO allitems_soul VALUES ('5','22','Book of Neil','1','2')
INSERT INTO allitems_soul VALUES ('6','0','Small Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','1','Horn Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','2','Kite Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','3','Elven Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','4','Buckler','2','2')
INSERT INTO allitems_soul VALUES ('6','5','Dragon Slayer Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','6','Skull Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','7','Spiked Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','8','Tower Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','9','Plate Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','10','Large Round Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','11','Serpent Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','12','Bronze Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','13','Dragon Shield','2','2')
INSERT INTO allitems_soul VALUES ('6','14','Legendary Shield','2','3')
INSERT INTO allitems_soul VALUES ('6','15','Grand soul Shield','2','3')
INSERT INTO allitems_soul VALUES ('6','16','Elemental Shield','2','2')
INSERT INTO allitems_soul VALUES ('7','0','Bronze Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','1','Dragon Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','2','Pad Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','3','Legendary Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','4','Bone Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','5','Leather Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','6','Scale Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','7','Sphinx Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','8','Brass Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','9','Plate Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','10','Vine Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','11','Silk Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','12','Wind Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','13','Spirit Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','14','Guardian Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','16','Black Dragon Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','17','Dark Phoenix Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','18','Grand soul Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','19','Divine Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','21','Great Dragon Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','22','Dark soul Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','24','Red Spirit Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','25','Light Plate Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','26','Adamantine Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','27','Dark Steel Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','28','Dark Master Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','29','Dragon Knight Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','30','Venom Mist Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','31','Sylphid Ray Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','33','Sunlight Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','34','Ashcrow Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','35','Eclipse Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','36','Iris Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','38','Glorious Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','39','Mistery Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','40','Red Wing Helm','2','2')
INSERT INTO allitems_soul VALUES ('7','41','Ancient Helm','2','2')
INSERT INTO allitems_soul VALUES ('8','0','Bronze Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','1','Dragon Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','2','Pad Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','3','Legendary Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','4','Bone Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','5','Leather Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','6','Scale Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','7','Sphinx Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','8','Brass Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','9','Plate Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','10','Vine Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','11','Silk Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','12','Wind Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','13','Spirit Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','14','Guardian Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','15','Storm Crow Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','16','Black Dragon Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','17','Dark Phoenix Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','18','Grand soul Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','19','Divine Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','20','Thunder Hawk Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','21','Great Dragon Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','22','Dark soul Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','23','Hurricane Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','24','Red Sprit Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','25','Light Plate Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','26','Adamantine Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','27','Dark Steel Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','28','Dark Master Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','29','Dragon Knight Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','30','Venom Mist Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','31','Sylphid Ray Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','32','Volcano Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','33','Sunlight Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','34','Ashcrow Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','35','Eclipse Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','36','Iris Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','37','Valiant Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','38','Glorious Armor','2','3')
INSERT INTO allitems_soul VALUES ('8','39','Mistery Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','40','Red Wing Armor','2','2')
INSERT INTO allitems_soul VALUES ('8','41','Ancient Armor','2','2')
INSERT INTO allitems_soul VALUES ('9','0','Bronze Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','1','Dragon Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','2','Pad Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','3','Legendary Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','4','Bone Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','5','Leather Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','6','Scale Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','7','Sphinx Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','8','Brass Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','9','Plate Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','10','Vine Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','11','Silk Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','12','Wind Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','13','Spirit Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','14','Guardian Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','15','Storm Crow Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','16','Black Dragon Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','17','Dark Phoenix Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','18','Grand soul Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','19','Divine Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','20','Thunder Hawk Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','21','Great Dragon Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','22','Dark soul Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','23','Hurricane Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','24','Red Spirit Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','25','Light Plate Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','26','Adamantine Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','27','Dark Steel Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','28','Dark Master Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','29','Dragon Knight Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','30','Venom Mist Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','31','Sylphid Ray Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','32','Volcano Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','33','Sunlight Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','34','Ashcrow Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','35','Eclipse Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','36','Iris Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','37','Valiant Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','38','Glorious Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','39','Mistery Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','40','Red Wing Pants','2','2')
INSERT INTO allitems_soul VALUES ('9','41','Ancient Pants','2','2')
INSERT INTO allitems_soul VALUES ('10','0','Bronze Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','1','Dragon Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','2','Pad Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','3','Legendary Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','4','Bone Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','5','Leather Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','6','Scale Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','7','Sphinx Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','8','Brass Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','9','Plate Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','10','Vine Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','11','Silk Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','12','Wind Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','13','Spirit Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','14','Guardian Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','15','Storm Crow Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','16','Black Dragon Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','17','Dark Phoenix Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','18','Grand soul Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','19','Divine Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','20','Thunder Hawk Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','21','Great Dragon Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','22','Dark soul Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','23','Hurricane Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','24','Red Spirit Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','25','Light Plate Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','26','Adamantine Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','27','Dark Steel Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','28','Dark Master Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','29','Dragon Knight Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','30','Venom Mist Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','31','Sylphid Ray Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','32','Volcano Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','33','Sunlight Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','34','Ashcrow Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','35','Eclipse Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','36','Iris Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','37','Valiant Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','38','Glorious Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','39','Mistery Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','40','Red Wing Gloves','2','2')
INSERT INTO allitems_soul VALUES ('10','41','Ancient Gloves','2','2')
INSERT INTO allitems_soul VALUES ('11','0','Bronze Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','1','Dragon Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','2','Pad Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','3','Legendary Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','4','Bone Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','5','Leather Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','6','Scale Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','7','Sphinx Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','8','Brass Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','9','Plate Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','10','Vine Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','11','Silk Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','12','Wind Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','13','Spirit Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','14','Guardian Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','15','Storm Crow Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','16','Black Dragon Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','17','Dark Phoenix Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','18','Grand soul Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','19','Divine Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','20','Thunder Hawk Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','21','Great Dragon Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','22','Dark soul Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','23','Hurricane Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','24','Red Spirit Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','25','Light Plate Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','26','Adamantine Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','27','Dark Steel Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','28','Dark Master Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','29','Dragon Knight Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','30','Venom Mist Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','31','Sylphid Ray Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','32','Volcano Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','33','Sunlight Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','34','Ashcrow Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','35','Eclipse Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','36','Iris Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','37','Valiant Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','38','Glorious Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','39','Mistery Boots','2','2')
INSERT INTO allitems_soul VALUES ('11','40','Red Wing Boots','2','2')
INSERT INTO allitems_soul VALUES ('12','0','Wings of Fairy','3','2')
INSERT INTO allitems_soul VALUES ('12','1','Wings of Angel','5','3')
INSERT INTO allitems_soul VALUES ('12','2','Wings of Satan','5','2')
INSERT INTO allitems_soul VALUES ('12','3','Wings of Spirit','5','3')
INSERT INTO allitems_soul VALUES ('12','4','Wings of soul','5','3')
INSERT INTO allitems_soul VALUES ('12','5','Wings of Dragon','3','3')
INSERT INTO allitems_soul VALUES ('12','6','Wings of Darkness','4','2')
INSERT INTO allitems_soul VALUES ('12','7','Orb of Twisting Slash','1','1')
INSERT INTO allitems_soul VALUES ('12','8','Orb of Healing','1','1')
INSERT INTO allitems_soul VALUES ('12','9','Orb of Greater Defense','1','1')
INSERT INTO allitems_soul VALUES ('12','10','Orb of Greater Damage','1','1')
INSERT INTO allitems_soul VALUES ('12','11','Orb of Summoning','1','1')
INSERT INTO allitems_soul VALUES ('12','12','Orb of Rageful Blow','1','1')
INSERT INTO allitems_soul VALUES ('12','13','Orb of Impale','1','1')
INSERT INTO allitems_soul VALUES ('12','14','Orb of Greater Fortitude','1','1')
INSERT INTO allitems_soul VALUES ('12','15','Jewel of soul','1','1')
INSERT INTO allitems_soul VALUES ('12','16','Orb of Fire Slash','1','1')
INSERT INTO allitems_soul VALUES ('12','17','Orb of Penetration','1','1')
INSERT INTO allitems_soul VALUES ('12','18','Orb of Ice Arrow','1','1')
INSERT INTO allitems_soul VALUES ('12','19','Orb of Death Stab','1','1')
INSERT INTO allitems_soul VALUES ('12','21','Scroll of Fire Burst','1','2')
INSERT INTO allitems_soul VALUES ('12','22','Scroll of Summon','1','2')
INSERT INTO allitems_soul VALUES ('12','23','Scroll of Critical Damage','1','2')
INSERT INTO allitems_soul VALUES ('12','24','Scroll of Electric Spark','1','2')
INSERT INTO allitems_soul VALUES ('12','26','Gem of Secret','1','1')
INSERT INTO allitems_soul VALUES ('12','30','Jewel of soul Compressed','1','1')
INSERT INTO allitems_soul VALUES ('12','31','Jewel of soul Compressed','1','1')
INSERT INTO allitems_soul VALUES ('12','32','Red Ribbon Box','1','1')
INSERT INTO allitems_soul VALUES ('12','33','Green Ribbon Box','1','1')
INSERT INTO allitems_soul VALUES ('12','34','Blue Ribbon Box','1','1')
INSERT INTO allitems_soul VALUES ('12','35','Scroll of Fire Scream','1','2')
INSERT INTO allitems_soul VALUES ('12','36','Wing of Storm','4','3')
INSERT INTO allitems_soul VALUES ('12','37','Wing of Space Time','4','3')
INSERT INTO allitems_soul VALUES ('12','38','Wing of Illusion','4','3')
INSERT INTO allitems_soul VALUES ('12','39','Wings of Hurricane','4','3')
INSERT INTO allitems_soul VALUES ('12','40','Mantle of Monarch','2','3')
INSERT INTO allitems_soul VALUES ('12','41','Wing of Mistery','4','2')
INSERT INTO allitems_soul VALUES ('12','42','Wing of Despair','4','3')
INSERT INTO allitems_soul VALUES ('12','43','Wings of Violent Wind','4','3')
INSERT INTO allitems_soul VALUES ('13','0','Guardian Angel','1','1')
INSERT INTO allitems_soul VALUES ('13','1','Satan','1','1')
INSERT INTO allitems_soul VALUES ('13','2','Horn of Unicorn','1','1')
INSERT INTO allitems_soul VALUES ('13','3','Horn of Dinorant','1','1')
INSERT INTO allitems_soul VALUES ('13','4','Dark Horse','1','1')
INSERT INTO allitems_soul VALUES ('13','5','Dark Raven','1','1')
INSERT INTO allitems_soul VALUES ('13','7','Contract ','1','1')
INSERT INTO allitems_soul VALUES ('13','8','Ring of Ice','1','1')
INSERT INTO allitems_soul VALUES ('13','9','Ring of Poison','1','1')
INSERT INTO allitems_soul VALUES ('13','10','Ring of Transformation','1','1')
INSERT INTO allitems_soul VALUES ('13','11','Order ','1','1')
INSERT INTO allitems_soul VALUES ('13','12','Pendant of Lightning','1','1')
INSERT INTO allitems_soul VALUES ('13','13','Pendant of Fire','1','1')
INSERT INTO allitems_soul VALUES ('13','14','Loch','1','2')
INSERT INTO allitems_soul VALUES ('13','15','Fruit','1','1')
INSERT INTO allitems_soul VALUES ('13','16','Scroll of Archangel','1','2')
INSERT INTO allitems_soul VALUES ('13','17','Blood Bone','1','2')
INSERT INTO allitems_soul VALUES ('13','18','Invisibility Cloak','2','2')
INSERT INTO allitems_soul VALUES ('13','19','Weapon of Archangel','1','2')
INSERT INTO allitems_soul VALUES ('13','20','Ring of Wizard','1','1')
INSERT INTO allitems_soul VALUES ('13','21','Ring of Fire','1','1')
INSERT INTO allitems_soul VALUES ('13','22','Ring of Earth','1','1')
INSERT INTO allitems_soul VALUES ('13','23','Ring of Wind','1','1')
INSERT INTO allitems_soul VALUES ('13','24','Ring of Magic','1','1')
INSERT INTO allitems_soul VALUES ('13','25','Pendant of Ice','1','1')
INSERT INTO allitems_soul VALUES ('13','26','Pendant of Wind','1','1')
INSERT INTO allitems_soul VALUES ('13','27','Pendant of Water','1','1')
INSERT INTO allitems_soul VALUES ('13','28','Pendant of Ability','1','1')
INSERT INTO allitems_soul VALUES ('13','29','Armor of Guardman','2','2')
INSERT INTO allitems_soul VALUES ('13','30','Cape of Lord','2','3')
INSERT INTO allitems_soul VALUES ('13','31','Spirit','1','1')
INSERT INTO allitems_soul VALUES ('13','32','Splinter of Armor','1','1')
INSERT INTO allitems_soul VALUES ('13','33','soul of Guardian','1','1')
INSERT INTO allitems_soul VALUES ('13','34','Claw of Beast','1','1')
INSERT INTO allitems_soul VALUES ('13','35','Piece of Horn','1','1')
INSERT INTO allitems_soul VALUES ('13','36','Broken Horn','2','2')
INSERT INTO allitems_soul VALUES ('13','37','Horn of Fenrir','2','2')
INSERT INTO allitems_soul VALUES ('13','38','Moon soul Ring','1','1')
INSERT INTO allitems_soul VALUES ('13','39','Elite Skeleton Warrior Ring','1','1')
INSERT INTO allitems_soul VALUES ('13','40','Jack O','1','1')
INSERT INTO allitems_soul VALUES ('13','41','Christmas Ring','1','1')
INSERT INTO allitems_soul VALUES ('13','42','Gm Ring','1','1')
INSERT INTO allitems_soul VALUES ('13','43','Tensile of Increase','1','1')
INSERT INTO allitems_soul VALUES ('13','44','Tensile of Abundance','1','1')
INSERT INTO allitems_soul VALUES ('13','45','Tensile of Maintenance','1','1')
INSERT INTO allitems_soul VALUES ('13','46','Devil Square Ticket','1','1')
INSERT INTO allitems_soul VALUES ('13','47','Blood Castle Ticket','1','1')
INSERT INTO allitems_soul VALUES ('13','48','Kalima Ticket','1','1')
INSERT INTO allitems_soul VALUES ('13','49','Scroll of Illusion','1','1')
INSERT INTO allitems_soul VALUES ('13','50','Potion of Illusion','1','2')
INSERT INTO allitems_soul VALUES ('13','51','Illusion Platform','2','2')
INSERT INTO allitems_soul VALUES ('13','52','Flame of Condor','1','2')
INSERT INTO allitems_soul VALUES ('13','53','Feather of Condor','1','2')
INSERT INTO allitems_soul VALUES ('13','54','Reset Fruit soul','1','1')
INSERT INTO allitems_soul VALUES ('13','55','Reset Fruit Strength','1','1')
INSERT INTO allitems_soul VALUES ('13','56','Reset Fruit Agility','1','1')
INSERT INTO allitems_soul VALUES ('13','57','Reset Fruit Energy','1','1')
INSERT INTO allitems_soul VALUES ('13','58','Reset Fruit Command','1','1')
INSERT INTO allitems_soul VALUES ('13','59','Tensile of Mobility','1','1')
INSERT INTO allitems_soul VALUES ('13','60','Indulgence','1','2')
INSERT INTO allitems_soul VALUES ('13','61','Illusion Temple Ticket','1','1')
INSERT INTO allitems_soul VALUES ('13','62','Tensile of Recovering','1','1')
INSERT INTO allitems_soul VALUES ('13','63','Tensile of Healing','1','1')
INSERT INTO allitems_soul VALUES ('13','64','Daemon','1','1')
INSERT INTO allitems_soul VALUES ('13','65','Spirit of Guardian','1','1')
INSERT INTO allitems_soul VALUES ('14','0','Apple','1','1')
INSERT INTO allitems_soul VALUES ('14','1','Small Healing Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','2','Healing Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','3','Large Healing Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','4','Small Mana Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','5','Mana Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','6','Large Mana Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','7','Siege Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','8','Antidote','1','1')
INSERT INTO allitems_soul VALUES ('14','9','Alcohol','1','2')
INSERT INTO allitems_soul VALUES ('14','10','Town Portal','1','2')
INSERT INTO allitems_soul VALUES ('14','11','Box of Luck','1','1')
INSERT INTO allitems_soul VALUES ('14','12','Heart','1','1')
INSERT INTO allitems_soul VALUES ('14','13','Jewel of soul','1','1')
INSERT INTO allitems_soul VALUES ('14','14','Jewel of soul','1','1')
INSERT INTO allitems_soul VALUES ('14','15','Zen','1','1')
INSERT INTO allitems_soul VALUES ('14','16','Jewel of soul','1','1')
INSERT INTO allitems_soul VALUES ('14','17','Devil Eye','1','1')
INSERT INTO allitems_soul VALUES ('14','18','Devil Key','1','1')
INSERT INTO allitems_soul VALUES ('14','19','Invitation of Devil Square','1','1')
INSERT INTO allitems_soul VALUES ('14','20','Remedy of Love','1','1')
INSERT INTO allitems_soul VALUES ('14','21','Rena','1','1')
INSERT INTO allitems_soul VALUES ('14','22','Jewel of soul','1','1')
INSERT INTO allitems_soul VALUES ('14','23','Scroll of the Emperor','1','1')
INSERT INTO allitems_soul VALUES ('14','24','Broken Sword','1','2')
INSERT INTO allitems_soul VALUES ('14','25','Tear of Elf','1','1')
INSERT INTO allitems_soul VALUES ('14','26','soul of Wizard','1','1')
INSERT INTO allitems_soul VALUES ('14','28','Lost Map','1','1')
INSERT INTO allitems_soul VALUES ('14','29','Symbol of Kundun','1','1')
INSERT INTO allitems_soul VALUES ('14','31','Jewel of Guardian','1','1')
INSERT INTO allitems_soul VALUES ('14','32','Pink Chocolate Box','1','1')
INSERT INTO allitems_soul VALUES ('14','33','Red Chocolate Box','1','1')
INSERT INTO allitems_soul VALUES ('14','34','Blue Chocolate Box','1','1')
INSERT INTO allitems_soul VALUES ('14','35','Small SD Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','36','SD Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','37','Large SD Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','38','Small Complex Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','39','Complex Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','40','Large Complex Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','41','Gemsoul','1','1')
INSERT INTO allitems_soul VALUES ('14','42','Jewel of Harmony','1','1')
INSERT INTO allitems_soul VALUES ('14','43','Lower Refining soul','1','1')
INSERT INTO allitems_soul VALUES ('14','44','Higher Refining soul','1','1')
INSERT INTO allitems_soul VALUES ('14','45','Haloween Pumpkin','1','1')
INSERT INTO allitems_soul VALUES ('14','46','Jack O','1','2')
INSERT INTO allitems_soul VALUES ('14','47','Jack O','1','2')
INSERT INTO allitems_soul VALUES ('14','48','Jack O','1','2')
INSERT INTO allitems_soul VALUES ('14','49','Jack O','1','1')
INSERT INTO allitems_soul VALUES ('14','50','Jack O','1','1')
INSERT INTO allitems_soul VALUES ('14','51','Star of Fireworks','1','1')
INSERT INTO allitems_soul VALUES ('14','52','Game Master Box','1','1')
INSERT INTO allitems_soul VALUES ('14','53','Talisman of Luck','1','1')
INSERT INTO allitems_soul VALUES ('14','54','soul Card','1','1')
INSERT INTO allitems_soul VALUES ('14','55','Green soul Box','1','1')
INSERT INTO allitems_soul VALUES ('14','56','Red soul Box','1','1')
INSERT INTO allitems_soul VALUES ('14','57','Purple soul Box','1','1')
INSERT INTO allitems_soul VALUES ('14','58','Rare Item Ticket 1','1','1')
INSERT INTO allitems_soul VALUES ('14','59','Rare Item Ticket 2','1','1')
INSERT INTO allitems_soul VALUES ('14','60','Rare Item Ticket 3','1','1')
INSERT INTO allitems_soul VALUES ('14','61','Rare Item Ticket 4','1','1')
INSERT INTO allitems_soul VALUES ('14','62','Rare Item Ticket 5','1','1')
INSERT INTO allitems_soul VALUES ('14','63','Firecracker','1','1')
INSERT INTO allitems_soul VALUES ('14','64','Cursed Castle Water','1','1')
INSERT INTO allitems_soul VALUES ('14','65','Flame of Death Beam Knight','1','1')
INSERT INTO allitems_soul VALUES ('14','66','Horn of Hell Maine','1','2')
INSERT INTO allitems_soul VALUES ('14','67','Feather of Darkness Phoenix','1','2')
INSERT INTO allitems_soul VALUES ('14','68','Eye of the Abyss','1','2')
INSERT INTO allitems_soul VALUES ('14','70','Elite Healing Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','71','Elite Mana Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','72','Scroll of Agility','2','2')
INSERT INTO allitems_soul VALUES ('14','73','Scroll of Protection','2','2')
INSERT INTO allitems_soul VALUES ('14','74','Scroll of Wrath','2','2')
INSERT INTO allitems_soul VALUES ('14','75','Scroll of Wizardry','2','2')
INSERT INTO allitems_soul VALUES ('14','76','Scroll of Health','2','2')
INSERT INTO allitems_soul VALUES ('14','77','Scroll of Mana','2','2')
INSERT INTO allitems_soul VALUES ('14','78','Leap of Strength','1','2')
INSERT INTO allitems_soul VALUES ('14','79','Leap of Agility','1','2')
INSERT INTO allitems_soul VALUES ('14','80','Leap of Vitality','1','2')
INSERT INTO allitems_soul VALUES ('14','81','Leap of Energy','1','2')
INSERT INTO allitems_soul VALUES ('14','82','Leap of Command','1','2')
INSERT INTO allitems_soul VALUES ('14','83','Rare Item Ticket 6','1','1')
INSERT INTO allitems_soul VALUES ('14','84','Cherry Blossom Box','1','1')
INSERT INTO allitems_soul VALUES ('14','85','Cherry Blossom Wine','1','2')
INSERT INTO allitems_soul VALUES ('14','86','Cherry Blossom Rice Cake','1','1')
INSERT INTO allitems_soul VALUES ('14','87','Cherry Blossom Flower Petal','1','1')
INSERT INTO allitems_soul VALUES ('14','88','White Cherry Blossom Branch','1','2')
INSERT INTO allitems_soul VALUES ('14','89','Red Cherry Blossom Branch','1','2')
INSERT INTO allitems_soul VALUES ('14','90','Golden Cherry Blossom Branch','1','2')
INSERT INTO allitems_soul VALUES ('14','91','Summoner Character Card','1','1')
INSERT INTO allitems_soul VALUES ('14','92','soul Card Gold','1','1')
INSERT INTO allitems_soul VALUES ('14','93','soul Card Rare','1','1')
INSERT INTO allitems_soul VALUES ('14','94','Medium Elite Healing Potion','1','1')
INSERT INTO allitems_soul VALUES ('14','95','soul Card Mini','1','1')
INSERT INTO allitems_soul VALUES ('14','96','Talisman of soul Assembly','1','1')
INSERT INTO allitems_soul VALUES ('14','97','Scroll of Battle','2','2')
INSERT INTO allitems_soul VALUES ('14','98','Scroll of Strengthener','2','2')
INSERT INTO allitems_soul VALUES ('15','0','Scroll of Poison','1','2')
INSERT INTO allitems_soul VALUES ('15','1','Scroll of Meteorite','1','2')
INSERT INTO allitems_soul VALUES ('15','2','Scroll of Lighting','1','2')
INSERT INTO allitems_soul VALUES ('15','3','Scroll of Fire Ball','1','2')
INSERT INTO allitems_soul VALUES ('15','4','Scroll of Flame','1','2')
INSERT INTO allitems_soul VALUES ('15','5','Scroll of Teleport','1','2')
INSERT INTO allitems_soul VALUES ('15','6','Scroll of Ice','1','2')
INSERT INTO allitems_soul VALUES ('15','7','Scroll of Twister','1','2')
INSERT INTO allitems_soul VALUES ('15','8','Scroll of Evil Spirit','1','2')
INSERT INTO allitems_soul VALUES ('15','9','Scroll of Hellfire','1','2')
INSERT INTO allitems_soul VALUES ('15','10','Scroll of Power Wave','1','2')
INSERT INTO allitems_soul VALUES ('15','11','Scroll of Aqua Beam','1','2')
INSERT INTO allitems_soul VALUES ('15','12','Scroll of Cometfall','1','2')
INSERT INTO allitems_soul VALUES ('15','13','Scroll of Inferno','1','2')
INSERT INTO allitems_soul VALUES ('15','14','Scroll of Mass Teleport','1','2')
INSERT INTO allitems_soul VALUES ('15','15','Scroll of Mana Shield','1','2')
INSERT INTO allitems_soul VALUES ('15','16','Scroll of Decay','1','2')
INSERT INTO allitems_soul VALUES ('15','17','Scroll of Ice Storm','1','2')
INSERT INTO allitems_soul VALUES ('15','18','Scroll of Nova','1','2')
INSERT INTO allitems_soul VALUES ('15','19','Scroll of Drain soul','1','2')
INSERT INTO allitems_soul VALUES ('15','20','Scroll of Chain Lighting','1','2')
INSERT INTO allitems_soul VALUES ('15','22','Scroll of Reflex','1','2')
INSERT INTO allitems_soul VALUES ('15','24','Scroll of Sleep','1','2')
INSERT INTO allitems_soul VALUES ('15','26','Scroll of Magic Defense Up','1','2')
INSERT INTO allitems_soul VALUES ('15','27','Scroll of Red Storm','1','2')

Правите си файл да кажем getsoul.php и слагате това:

PHP:

  <?php
 /*=====================================================
 Database Settings
  ====================================================*/
 $host='127.0.0.1'; //DATABASE HOSTNAME
 $user='sa'; //DATABASE USER
 $sqlpass='SQL PAROLA'; //DATABASE PASSWORD
 $dbname='MuOnline'; //DATABASE NAME
 $jewels = 'Soul'; //Soul
  /*=====================================================
 Item settings
 Item Durability 0-255
 Item Level 0-11-15
 Item Skill (0-OFF/1-ON)
 Item Luck (0-OFF/1-ON)
 Item AD/ADD OPTIONS (1=4/2=8/3=12 etc)
 Item EXL OPTIONS DOWN
 Item EXL OPTIONS (0-OFF/1-ON)
  ====================================================*/
 $itemtype = '14'; //Item Type
 $itemid = '14'; //Item ID
 $itemdur = '0'; //Item Durability
 $itemlvl = '0'; //Item Level
 $itemskill = '0'; //Item Skill
 $itemluck = '0'; //Item Luck
 $itemop = '0';	 //Item AD/ADD OPTIONS
 $itemexop1 = '0'; //Item EXL OPTIONS
 $itemexop2 = '0'; //Item EXL OPTIONS
 $itemexop3 = '0'; //Item EXL OPTIONS
 $itemexop4 = '0'; //Item EXL OPTIONS
 $itemexop5 = '0'; //Item EXL OPTIONS
 $itemexop6 = '0'; //Item EXL OPTIONS
 /*=====================================================
	0 = No Option
	
	Weapon and Pendant Excellent Option:
	$itemexop1 = Increase Mana/kill +8
	$itemexop2 = Increase HP/kill +8
	$itemexop3 = Increase attacking(wizardly)speed+7
	$itemexop4 = Increase wizardly damage +2%
	$itemexop5 = Increase wizardly damage +level/20
	$itemexop6 = Excellent Damage Rate +10%

	Sets/Shield/Ring Excellent Option
	$itemexop1 = Increase Zen After Hunt +40%
	$itemexop2 = Defense Succes Rate 10%
	$itemexop3 = Reflect Damage 5%
	$itemexop4 = Damage Decrease 4%
	$itemexop5 = Increase MaxMana +4%
	$itemexop6 = Increase MaxHP +4%
 ====================================================*/
 
//DB Connection
$connect=mssql_connect($host, $user, $sqlpass);
$select_db=mssql_select_db($dbname);

If(!$connect  or !$select_db) die("<img src=images/warning.gif> Connection with SQL Server failed!");
//End of DB connection


//Functions for add_item by Damian
function free_slots($x,$y,$zaeti_slotove){
for($i=1;$i<=120;$i++){
$svobodni=0;
for($k=0;$k<$x;$k++){if((!in_array($i+$k,$zaeti_slotove) && $x==1) || (!in_array($i+$k,$zaeti_slotove) && $x>1 && $i%8!=0 && $i%8+$k<=8))++$svobodni;
for($l=1;$l<$y;$l++)if(!in_array($i+$k+$l*8,$zaeti_slotove) && (int)(($i+$k+$l*8)/8) <=15 )++$svobodni;
if($svobodni==$x*$y)return $i-1;}}
return 1993;
}

function generate_item_hex($item_type,$item_id,$item_durability,$item_level,$item_option,$item_skill,$item_luck,$ex1,$ex2,$ex3,$ex4,$ex5,$ex6){
$serial    = mssql_fetch_row(mssql_query("exec WZ_GetItemSerial"));
$BB        = 0;
$CC        = $item_durability;
$DDEE    = sprintf("%08X", $serial[0],00000000);
$HH        = 0;
if($item_level>0)$BB+=$item_level*8;
if($item_option>0 && $item_option<=7)
if($item_option>=4){$BB+=$item_option-4;$HH+=64;} else $BB+=$item_option;
if($item_skill==1)$BB+=128;
if($item_luck==1)$BB+=4;
if($BB<0)$BB=0;
if($ex1)$HH+=1;if($ex2)$HH+=2;if($ex3)$HH+=4;if($ex4)$HH+=8;if($ex5)$HH+=16;if($ex6)$HH+=32;


if($item_type*2 >= 16)$HH+=128;

$names = ($item_type*32)+$item_id;

$AA = sprintf("%02X",$names,00);
if($names >=255)$AA = substr($AA,1,2);

$item_hex = sprintf("%02s%02X%02X%08s%02X%04s",$AA,$BB,$CC,$DDEE,$HH,0000);
return $item_hex;
}


function add_item($account,$item_type,$item_id,$item_durability,$item_level,$item_option,$item_skill,$item_luck,$ex1,$ex2,$ex3,$ex4,$ex5,$ex6){
$query= mssql_query("declare @it varbinary(1200); 
set @it=(select [Items] from [warehouse] where [AccountID]='$account'); 
print @it");
$items = substr(mssql_get_last_message(),2);

$br=0;
for($i=1;$i<=120;$i++){
$code=substr($items,($i-1)*20,2);
if($code!="FF"){
$id            = substr($code,1,1);             
$itemtype     = hexdec(substr($code,0,1));

$ioo = hexdec(substr($items,($i-1)*20+14,2));

if(($itemtype % 2) != 0){$id = '1'.$id.'';$itemtype--; }
if($ioo >= 128){$itemtype += 16;}

$itemtype /= 2;    
$id=hexdec($id);

$item_info=mssql_fetch_row(mssql_query("select x,y from allitems_soul where type='$itemtype' and id='$id'"));
for($k=0;$k<$item_info[0];$k++){$zaeti_slotove[]=$i+$k;
for($l=1;$l<$item_info[1];$l++)$zaeti_slotove[]=$i+$k+$l*8;}
}

else $br++;

}
$item_info=mssql_fetch_row(mssql_query("select x,y from allitems_soul where type='$item_type' and id='$item_id'"));
if($br==120)$svoboden_slot=0;
else $svoboden_slot=free_slots($item_info[0],$item_info[1],$zaeti_slotove);
if($svoboden_slot !=1993){
$new_items=substr_replace($items, generate_item_hex($item_type,$item_id,$item_durability,$item_level,$item_option,$item_skill,$item_luck,$ex1,$ex2,$ex3,$ex4,$ex5,$ex6), $svoboden_slot*20, 20);
mssql_query("update warehouse set items=0x$new_items where accountid='$account'");
return 1;
}
return 0;

}
//End Of Functions for add_item

if(isset($_POST['submit'])){
$souls=(int)htmlspecialchars(addslashes($_POST['int']));
$account=htmlspecialchars(addslashes($_POST['acc']));
$pass=htmlspecialchars(addslashes($_POST['pass']));

$checkonline = mssql_query("SELECT * From MEMB_STAT where memb___id='$account' and ConnectStat='1'");
$checkedonline = mssql_num_rows($checkonline);

$checkpass = mssql_query("SELECT * From MEMB_INFO where memb___id='$account' and memb__pwd='$pass'");
$checkedpass = mssql_num_rows($checkpass);

$checksoul = mssql_query("SELECT $jewels From Jewels where Acc='$account'");
$checkedsoul = mssql_fetch_row($checksoul);
$err=0;
if($checkedonline>0){ echo "Your Account is Online<br />"; $err=1;}
if($checkedpass<=0){ echo "Wrong Password or Account <br />"; $err=1;}
if($checkedsoul['0']<$souls){ echo "Don't have enought $jewels"; $err=1;}
if ($err != 1){
$real_added_souls=0;
for($i=1;$i<=$souls;$i++){
if(add_item("$account","$itemtype","$itemid","$itemdur","$itemlvl","$itemop","$itemskill","$itemluck","$itemexop1","$itemexop2","$itemexop3","$itemexop4","$itemexop5","$itemexop6"))$real_added_souls++;
else break;
}
mssql_query("update Jewels set $jewels=$jewels-$real_added_souls where acc='$account'");
echo"Uspeshno si vzehte $real_added_souls Jewel Of Soul.";
}
}
?> <table align="center" width="400" id="main">
<form method="POST" action="">
<tr><td><b>Account:</b></td><td><input type="text" name="acc" size="25"/></td></tr>
<tr><td><b>Password:</b></td><td><input type="password" name="pass" size="25"/></td></tr>
<tr><td><b><?=$jewels;?>:</b></td><td><input type="text" name="int" size="25"/></td></tr>
<tr><td></td><td><input type="submit" name="submit" value="Get Soul" /></td></tr>
</form>
</table>

Не забравяйте да си нагласите данните в php файла!

Credits:Ivowe3,Damian,Dude <3

Wikko0 · Mar 8, 2015

С кое си допринесъл за този код и какво е различното от на ivowe3 темата.

П.П Поне да му беше написал името правилно ;= )

dota-sdso · Mar 8, 2015

Да.. брутално

Deadman · Mar 8, 2015

Стига с тия депоСити ,withdraw няма момче. Ще взема тия дни да кача една deposit - withdraw система за Jewels ,от къв зор да си качвам jewel-ите ако не мога да ги тегля. За да работи с други камани просто слагаш 1 chaos примерно от муедитор и долу ти показва сериала на итема ,първите 4 знака са сериала и подменяш примерно това CE00 със сериала на чаоса и си бог.
ама нз може с троянец да го кача тай ,че ще помисля. -.-

Dude · Mar 8, 2015

Wikko0 said:
С кое си допринесъл за този код и какво е различното от на ivowe3 темата.

П.П Поне да му беше написал името правилно ;= )

Различното е че не всеки може да си го направи да е с камъни вместо стоун и рена, и не съм сложил себе си в кредитите да се надувам, но поне за занимавката мисля че не е лошо и мен да ме има... а ако някой от тях възразява само да каже

:*

Dude · Mar 8, 2015

DeadmanWonderland said:
Стига с тия депоСити ,withdraw няма момче. Ще взема тия дни да кача една deposit - withdraw система за Jewels ,от къв зор да си качвам jewel-ите ако не мога да ги тегля. За да работи с други камани просто слагаш 1 chaos примерно от муедитор и долу ти показва сериала на итема ,първите 4 знака са сериала и подменяш примерно това CE00 със сериала на чаоса и си бог.
ама нз може с троянец да го кача тай ,че ще помисля. -.-

И него ще сложа бе ей сега, даже ще едитна темата :*

Dude · Mar 8, 2015

Ето ти Withdraw

Deadman · Mar 8, 2015

Браво бе ,най-накрая някой и това да качи тука. :Д

Dude · Mar 18, 2015

Понеже съм написал само за два камъка таблицата можете да си добавяте камъни в таблицата по ваш избор.
Пример:

alter table Jewels add Soul bigint not null default 0

RaFa · Mar 19, 2015

Искате ли една "умна" Deposit-Withdraw Jewels система?

За старите версии, но може да се направи за новите за отрицателно време.

Dude · Mar 19, 2015

RaFa said:
Искате ли една "умна" Deposit-Withdraw Jewels система?
За старите версии, но може да се направи за новите за отрицателно време.

Споделяй тук даже и не питай.. не е ли тва целта?

RaFa · Mar 19, 2015

Dude said:
Споделяй тук даже и не питай.. не е ли тва целта?

Спокойно, споделял съм доста

Въпросът беше риторичен, също така. Когато имам време ще пусна рилийза

Dude · Mar 20, 2015

RaFa said:
Спокойно, споделял съм доста
Въпросът беше риторичен, също така. Когато имам време ще пусна рилийза

Дообрем чакаме го :*

satanism · Apr 26, 2015

Браво

Dude · Oct 19, 2020

Този гайд е много стар има много по добри из новите сайтове постнати от топ потребителите на форума!
Не препоръчвам да се ползва този гайд.

Search

Search

[Guide] Как да си направим депосити на камъни в сайта

Dude

Active Member

Wikko0

Well-Known Member

dota-sdso

Well-Known Member

Deadman

Banned

Dude

Active Member

Dude

Active Member

Dude

Active Member

Deadman

Banned

Dude

Active Member

RaFa

Team Member

Dude

Active Member

RaFa

Team Member

Dude

Active Member

satanism

New Member

Dude

Active Member

Similar threads