[Help] Creating Ultimate wep

Re: Creating Ultimate wep

Make a query to check the refinement and make sure it's +10, else do nothing.
 
Re: Creating Ultimate wep

hey shadow,remember me??

try this php code,making ultimate in my server is working... but be sure that the +10 green weapon is in the first slot of their inventory...

Hope it will help you... :laugh::thumbup:

PHP:
if ($act == 'ulti')
	{
			{
				$id = $_GET["charid"];
				$query = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = '$user'") or die(mysql_error());
				$checkrows = mysql_num_rows($query);
				if ($checkrows != 0)
				{
					$ccQuery = mysql_query("SELECT * FROM `inventory` WHERE `charid` = '$id' AND `refine`='10' AND inventoryslot = 0");
					$char = mysql_fetch_assoc($ccQuery);
					$itemid = $char['itemid'];
					$ultiid = NULL;
					
					//Guardian Ambidextrous Axe
					if($itemid == '22038')
					{
					$ultiid = '22383';
					}
					//Guardian Axe
					if($itemid == '22034')
					{
					$ultiid = '20378';
					}
					//Guardian Big Sword
					if($itemid == '22030')
					{
					$ultiid = '22373';
					}
					//Guardian Bow
					if($itemid == '22050')
					{
					$ultiid = '22398';
					}
					//Guardian Knuckle
					if($itemid == '22042')
					{
					$ultiid = '22388';
					}
					//Guardian Staff
					if($itemid == '22062')
					{
					$ultiid = '22413';
					}
					//Guardian Stick
					if($itemid == '22046')
					{
					$ultiid = '22393';
					}
					//Guardian Sword 
					if($itemid == '22026')
					{
					$ultiid = '22368';
					}
					//Guardian Wand
					if($itemid == '22058')
					{
					$ultiid = '22408';
					}
					//Guardian Yo-Yo
					if($itemid == '22054')
					{
					$ultiid = '22403';
					}
					
					//Historic Ambidextrous Axe
					if($itemid == '22039')
					{
					$ultiid = '22384';
					}
					//Historic Axe 
					if($itemid == '22035')
					{
					$ultiid = '22379';
					}
					//Historic Big Sword
					if($itemid == '22031')
					{
					$ultiid = '22374';
					}
					//Historic Bow
					if($itemid == '22051')
					{
					$ultiid = '22399';
					}
					//Historic Knuckle
					if($itemid == '22043')
					{
					$ultiid = '22389';
					}
					//Historic Staff
					if($itemid == '22063')
					{
					$ultiid = '22414';
					}
					//Historic Stick
					if($itemid == '22047')
					{
					$ultiid = '22394';
					}
					//Historic Sword
					if($itemid == '22027')
					{
					$ultiid = '22369';
					}
					//Historic Wand
					if($itemid == '22059')
					{
					$ultiid = '22409';
					}
					//Historic Yo-Yo
					if($itemid == '22055')
					{
					$ultiid = '22404';
					}
					
					//Angel Axe
					if($itemid == '22036')
					{
					$ultiid = '22380';
					}
					//Angel Big Sword
					if($itemid == '22032')
					{
					$ultiid = '22375';
					}
					//Angel Bow
					if($itemid == '22052')
					{
					$ultiid = '22400';
					}
					//Angel Glove
					if($itemid == '22044')
					{
					$ultiid = '22390';
					}
					//Angel Staff
					if($itemid == '22064')
					{
					$ultiid = '22415';
					}
					//Angel Stick
					if($itemid == '22048')
					{
					$ultiid = '22395';
					}
					//Angel Sword
					if($itemid == '22028')
					{
					$ultiid = '22370';
					}
					//Angel Wand
					if($itemid == '22060')
					{
					$ultiid = '22410';
					}
					//Angel Yo-Yo
					if($itemid == '22056')
					{
					$ultiid = '22405';
					}
					
					//Legendary Big Golden Axe
					if($itemid == '22041')
					{
					$ultiid = '22386';
					}
					//Legendary Golden Axe
					if($itemid == '22037')
					{
					$ultiid = '22381';
					}
					//Legendary Golden Big Sword
					if($itemid == '22033')
					{
					$ultiid = '22376';
					}
					//Legendary Golden Bow
					if($itemid == '22053')
					{
					$ultiid = '22401';
					}
					//Legendary Golden Gloves 
					if($itemid == '22045')
					{
					$ultiid = '22391';
					}
					//Legendary Golden Staff
					if($itemid == '22065')
					{
					$ultiid = '22416';
					}
					//Legendary Golden Stick
					if($itemid == '22049')
					{
					$ultiid = '22396';
					}
					//Legendary Golden Sword
					if($itemid == '22029')
					{
					$ultiid = '22371';
					}
					//Legendary Golden Wand
					if($itemid == '22061')
					{
					$ultiid = '22411';
					}
					//Legendary Golden Yo-Yo
					if($itemid == '22057')
					{
					$ultiid = '22406';
					}
					
					//Bloody Axe
					if($itemid == '22356')
					{
					$ultiid = '22382';
					}
					//Bloody Two-Handed Axe
					if($itemid == '22357')
					{
					$ultiid = '22387';
					}
					//Bloody Bow
					if($itemid == '22363')
					{
					$ultiid = '22402';
					}
					//Bloody Knuckle
					if($itemid == '22358')
					{
					$ultiid = '22392';
					}
					//Bloody Staff
					if($itemid == '22361')
					{
					$ultiid = '22417';
					}
					//Bloody Stick
					if($itemid == '22359')
					{
					$ultiid = '22397';
					}
					//Bloody Sword
					if($itemid == '22354')
					{
					$ultiid = '22372';
					}
					//Bloody Wand
					if($itemid == '22360')
					{
					$ultiid = '22412';
					}
					//Bloody Yo-Yo
					if($itemid == '22362')
					{
					$ultiid = '22407';
					}
					//Bloody Slayer
					if($itemid == '22355')
					{
					$ultiid = '22377';
					}
					if ($ultiid != NULL)
					{
					
						$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '0' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";
						
					
						if(mysql_query($sql)){
						
							echo "<h3><center>Have fun with your new Ultimate Weapon!</center></h3>";
							
						}else{
						
						
							echo "Mistake";
						
						
						}	
					}
					else
					{
						echo "<h3><center>You don't have any green weapon +10 in your inventary!</center></h3>";
					}
				}
			}
			}
 
Re: Creating Ultimate wep

When I do the cp, I put for make to 0, so you upgrade to +6 or more and you get the ultimate slot for pierce. If want to be +10 change this line

Search this line
PHP:
$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '0' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";

And replace for this
PHP:
$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '10' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";
 
Re: Creating Ultimate wep

hey shadow,remember me??

try this php code,making ultimate in my server is working... but be sure that the +10 green weapon is in the first slot of their inventory...

Hope it will help you... :laugh::thumbup:

PHP:
if ($act == 'ulti')
	{
			{
				$id = $_GET["charid"];
				$query = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = '$user'") or die(mysql_error());
				$checkrows = mysql_num_rows($query);
				if ($checkrows != 0)
				{
					$ccQuery = mysql_query("SELECT * FROM `inventory` WHERE `charid` = '$id' AND `refine`='10' AND inventoryslot = 0");
					$char = mysql_fetch_assoc($ccQuery);
					$itemid = $char['itemid'];
					$ultiid = NULL;
					
					//Guardian Ambidextrous Axe
					if($itemid == '22038')
					{
					$ultiid = '22383';
					}
					//Guardian Axe
					if($itemid == '22034')
					{
					$ultiid = '20378';
					}
					//Guardian Big Sword
					if($itemid == '22030')
					{
					$ultiid = '22373';
					}
					//Guardian Bow
					if($itemid == '22050')
					{
					$ultiid = '22398';
					}
					//Guardian Knuckle
					if($itemid == '22042')
					{
					$ultiid = '22388';
					}
					//Guardian Staff
					if($itemid == '22062')
					{
					$ultiid = '22413';
					}
					//Guardian Stick
					if($itemid == '22046')
					{
					$ultiid = '22393';
					}
					//Guardian Sword 
					if($itemid == '22026')
					{
					$ultiid = '22368';
					}
					//Guardian Wand
					if($itemid == '22058')
					{
					$ultiid = '22408';
					}
					//Guardian Yo-Yo
					if($itemid == '22054')
					{
					$ultiid = '22403';
					}
					
					//Historic Ambidextrous Axe
					if($itemid == '22039')
					{
					$ultiid = '22384';
					}
					//Historic Axe 
					if($itemid == '22035')
					{
					$ultiid = '22379';
					}
					//Historic Big Sword
					if($itemid == '22031')
					{
					$ultiid = '22374';
					}
					//Historic Bow
					if($itemid == '22051')
					{
					$ultiid = '22399';
					}
					//Historic Knuckle
					if($itemid == '22043')
					{
					$ultiid = '22389';
					}
					//Historic Staff
					if($itemid == '22063')
					{
					$ultiid = '22414';
					}
					//Historic Stick
					if($itemid == '22047')
					{
					$ultiid = '22394';
					}
					//Historic Sword
					if($itemid == '22027')
					{
					$ultiid = '22369';
					}
					//Historic Wand
					if($itemid == '22059')
					{
					$ultiid = '22409';
					}
					//Historic Yo-Yo
					if($itemid == '22055')
					{
					$ultiid = '22404';
					}
					
					//Angel Axe
					if($itemid == '22036')
					{
					$ultiid = '22380';
					}
					//Angel Big Sword
					if($itemid == '22032')
					{
					$ultiid = '22375';
					}
					//Angel Bow
					if($itemid == '22052')
					{
					$ultiid = '22400';
					}
					//Angel Glove
					if($itemid == '22044')
					{
					$ultiid = '22390';
					}
					//Angel Staff
					if($itemid == '22064')
					{
					$ultiid = '22415';
					}
					//Angel Stick
					if($itemid == '22048')
					{
					$ultiid = '22395';
					}
					//Angel Sword
					if($itemid == '22028')
					{
					$ultiid = '22370';
					}
					//Angel Wand
					if($itemid == '22060')
					{
					$ultiid = '22410';
					}
					//Angel Yo-Yo
					if($itemid == '22056')
					{
					$ultiid = '22405';
					}
					
					//Legendary Big Golden Axe
					if($itemid == '22041')
					{
					$ultiid = '22386';
					}
					//Legendary Golden Axe
					if($itemid == '22037')
					{
					$ultiid = '22381';
					}
					//Legendary Golden Big Sword
					if($itemid == '22033')
					{
					$ultiid = '22376';
					}
					//Legendary Golden Bow
					if($itemid == '22053')
					{
					$ultiid = '22401';
					}
					//Legendary Golden Gloves 
					if($itemid == '22045')
					{
					$ultiid = '22391';
					}
					//Legendary Golden Staff
					if($itemid == '22065')
					{
					$ultiid = '22416';
					}
					//Legendary Golden Stick
					if($itemid == '22049')
					{
					$ultiid = '22396';
					}
					//Legendary Golden Sword
					if($itemid == '22029')
					{
					$ultiid = '22371';
					}
					//Legendary Golden Wand
					if($itemid == '22061')
					{
					$ultiid = '22411';
					}
					//Legendary Golden Yo-Yo
					if($itemid == '22057')
					{
					$ultiid = '22406';
					}
					
					//Bloody Axe
					if($itemid == '22356')
					{
					$ultiid = '22382';
					}
					//Bloody Two-Handed Axe
					if($itemid == '22357')
					{
					$ultiid = '22387';
					}
					//Bloody Bow
					if($itemid == '22363')
					{
					$ultiid = '22402';
					}
					//Bloody Knuckle
					if($itemid == '22358')
					{
					$ultiid = '22392';
					}
					//Bloody Staff
					if($itemid == '22361')
					{
					$ultiid = '22417';
					}
					//Bloody Stick
					if($itemid == '22359')
					{
					$ultiid = '22397';
					}
					//Bloody Sword
					if($itemid == '22354')
					{
					$ultiid = '22372';
					}
					//Bloody Wand
					if($itemid == '22360')
					{
					$ultiid = '22412';
					}
					//Bloody Yo-Yo
					if($itemid == '22362')
					{
					$ultiid = '22407';
					}
					//Bloody Slayer
					if($itemid == '22355')
					{
					$ultiid = '22377';
					}
					if ($ultiid != NULL)
					{
					
						$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '0' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";
						
					
						if(mysql_query($sql)){
						
							echo "<h3><center>Have fun with your new Ultimate Weapon!</center></h3>";
							
						}else{
						
						
							echo "Mistake";
						
						
						}	
					}
					else
					{
						echo "<h3><center>You don't have any green weapon +10 in your inventary!</center></h3>";
					}
				}
			}
			}

where i put this PHP code ?
 
Back