- Joined
- May 3, 2009
- Messages
- 63
- Reaction score
- 0
in my cpanel when ppl create ultimate it makes even the +0 weps ultimate's how would i fix that?

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>";
}
}
}
}
$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '0' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";
$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '10' WHERE `itemid` = '".$itemid."' AND `charid` = '".$id."'";
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: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>"; } } } }