Indie-Resource.com

Code: Select all

 //get playerid
$playerid = $_SESSION['playerid'];
 //pick the initial rarity tier
$tier = rand(1, 100);

if ($tier < 40) {
     //find the actual item to reward
    $item = rand(200, 220)
     //pull the item from the master item db table
    $hItem = mysqli_fetch_assoc(mysqli_query($db, "SELECT itemid FROM masteritem WHERE itemID = '$item'")); 
     //store item ID obtained in a variable
    $rewardItem = $hitem['itemid'];
     //give the item to the player, using the playerInventory table, which stores the player's ID as a foreign key
    $result = mysqli_query($db, "INSERT INTO playerInventory (playerid, itemid) VALUES ('$playerid', '$rewardItem');
     //make sure the query succeeded
    if (!($result)) { 
        echo "Could not reward item<br />";
        exit();
     }
} else if ($tier < 75) {
    $item = rand(221, 250)
    $hItem = mysqli_fetch_assoc(mysqli_query($db, "SELECT itemid FROM masteritem WHERE itemID = '$item'")); 
    $rewardItem = $hitem['itemid'];
    $result = mysqli_query($db, "INSERT INTO playerInventory (playerid, itemid) VALUES ('$playerid', '$rewardItem');
    if (!($result)) { 
        echo "Could not reward item<br />";
        exit();
     }
} else if ($tier < 95) {
    $item = rand(251, 275)
    $hItem = mysqli_fetch_assoc(mysqli_query($db, "SELECT itemid FROM masteritem WHERE itemID = '$item'")); 
    $rewardItem = $hitem['itemid'];
    $result = mysqli_query($db, "INSERT INTO playerInventory (playerid, itemid) VALUES ('$playerid', '$rewardItem');
    if (!($result)) { 
        echo "Could not reward item<br />";
        exit();
     }
} else if ($tier < 101) {
    $item = rand(276, 300)
    $hItem = mysqli_fetch_assoc(mysqli_query($db, "SELECT itemid FROM masteritem WHERE itemID = '$item'")); 
    $rewardItem = $hitem['itemid'];
    $result = mysqli_query($db, "INSERT INTO playerInventory (playerid, itemid) VALUES ('$playerid', '$rewardItem');
    if (!($result)) { 
        echo "Could not reward item<br />";
        exit();
     }
}