in my cpanel when ppl create ultimate it makes even the +0 weps ultimate's how would i fix that?
in my cpanel when ppl create ultimate it makes even the +0 weps ultimate's how would i fix that?
Make a query to check the refinement and make sure it's +10, else do nothing.
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...
PHP Code: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>";
}
}
}
}
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
And replace for thisPHP Code:$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '0' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";
PHP Code:$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '10' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";
ah kk ty guys
where i put this PHP code ?Originally Posted by blacksmoke12
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...
PHP Code: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>";
}
}
}
}
In the userCP folder of ur game site in the Xampp or wamp which ever you use
![[Help] Creating Ultimate wep](http://ragezone.com/hyper728.png)
