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

Dude

Active Member
Joined
Feb 9, 2015
Messages
151
Reaction score
66
Сега ще ви покажа как да си сложите депозити в сайта и как да ги теглите !
Първо ще ви трябват тези таблици:

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
 
Last edited:

Wikko0

Well-Known Member
Joined
Oct 17, 2012
Messages
659
Reaction score
261
С кое си допринесъл за този код и какво е различното от на ivowe3 темата.

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

Deadman

Banned
Joined
Mar 17, 2014
Messages
323
Reaction score
281
Стига с тия депоСити ,withdraw няма момче. Ще взема тия дни да кача една deposit - withdraw система за Jewels ,от къв зор да си качвам jewel-ите ако не мога да ги тегля. За да работи с други камани просто слагаш 1 chaos примерно от муедитор и долу ти показва сериала на итема ,първите 4 знака са сериала и подменяш примерно това CE00 със сериала на чаоса и си бог.
ама нз може с троянец да го кача тай ,че ще помисля. -.- :D :D
 
  • Like
Reactions: getrekt

Dude

Active Member
Joined
Feb 9, 2015
Messages
151
Reaction score
66
С кое си допринесъл за този код и какво е различното от на ivowe3 темата.

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

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

Dude

Active Member
Joined
Feb 9, 2015
Messages
151
Reaction score
66
Стига с тия депоСити ,withdraw няма момче. Ще взема тия дни да кача една deposit - withdraw система за Jewels ,от къв зор да си качвам jewel-ите ако не мога да ги тегля. За да работи с други камани просто слагаш 1 chaos примерно от муедитор и долу ти показва сериала на итема ,първите 4 знака са сериала и подменяш примерно това CE00 със сериала на чаоса и си бог.
ама нз може с троянец да го кача тай ,че ще помисля. -.- :D :D

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

Deadman

Banned
Joined
Mar 17, 2014
Messages
323
Reaction score
281
Браво бе ,най-накрая някой и това да качи тука. :Д
 
  • Like
Reactions: getrekt

Dude

Active Member
Joined
Feb 9, 2015
Messages
151
Reaction score
66
Понеже съм написал само за два камъка таблицата можете да си добавяте камъни в таблицата по ваш избор.
Пример:


alter table Jewels add Soul bigint not null default 0
 
Last edited:

RaFa

Team Member
Joined
Jan 24, 2009
Messages
783
Reaction score
472
Искате ли една "умна" Deposit-Withdraw Jewels система? :D
За старите версии, но може да се направи за новите за отрицателно време.
 

Dude

Active Member
Joined
Feb 9, 2015
Messages
151
Reaction score
66
Искате ли една "умна" Deposit-Withdraw Jewels система? :D
За старите версии, но може да се направи за новите за отрицателно време.

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

RaFa

Team Member
Joined
Jan 24, 2009
Messages
783
Reaction score
472
Споделяй тук даже и не питай.. не е ли тва целта?

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

Dude

Active Member
Joined
Feb 9, 2015
Messages
151
Reaction score
66
Спокойно, споделял съм доста :)
Въпросът беше риторичен, също така. Когато имам време ще пусна рилийза ;)


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

Dude

Active Member
Joined
Feb 9, 2015
Messages
151
Reaction score
66
Този гайд е много стар има много по добри из новите сайтове постнати от топ потребителите на форума!
Не препоръчвам да се ползва този гайд.