Currency for leveling up / Adoptable shop (Fixed again)

[kisazeky]

Note with this update! Please, re-run the queries to add the shop adoptables, if you have already installed it. Thanks.

Important!! A way to prevent people stealing shop adoptables!

Open adopt.php and find something like this in the code (it won't be exactly like mine):

PHP Code:

if($newID != $aID){
$stop = 1;
$article_title = "Oops";
$article_date = date('Y-m-d');
$article_content = "This Digimon is not available for adoption.";
} 


below it, insert this:

PHP Code:

if($memberlevel != free){
$stop = 1;
$article_content = "You cannot adopt this pet for free!.";
} 


Earning money on level up

Step 1: Run this here MySQL query to add the money field in your users table:

PHP Code:

ALTER TABLE users
ADD money INT(11) NULL DEFAULT '0' 


Step 2: This is where the magic happens.

Download levelup.php and edit it to suit your site. Replace the number 10 with your desired amount of currency per level up.

Step 3: This is important if you still want people to be able to register.

Edit register2.php and find this line:

PHP Code:

mysql_query("INSERT INTO users VALUES ('', '$username', '$pass1','$email','free',)"); 


Replace it with:

PHP Code:

mysql_query("INSERT INTO users VALUES ('', '$username', '$pass1','$email','free','0')"); 


Show the total amount of money to your users

Add this....

PHP Code:

if ($isloggedin == "yes"){
$query = "SELECT * FROM `users` WHERE `username` = '".$luser."'";
$result = mysql_query($query);
$num = mysql_numrows($result);
$i=0;
    while ($i < 1) {
    
    $money =@mysql_result($result,$i,"money");
    $i++;
            }
$template = replace(':WELCOMEORREGISTER:','',$template);
$template = replace(':LOGINORACCT:', '<p>Hi, '.$username.'
<p>Currency name: '.$money.'
<p><a href="logout.php">Log out</a>' ,$template); 


In between ...

PHP Code:

//$isloggedin = "no"; 


and...

PHP Code:

}
else{

//User is not logged in 


On all of your pages.


Shop to buy adoptables

Step 1:

Download shop.php, buy.php, and buyconfirm.php and upload them to your main folder.

Step 2:

Add adoptables for sale by running a query like this. Do not change the shop part unless you know what you're doing.

PHP Code:

INSERT INTO adoptables VALUES ('', 'name','level 0 image','shop','cost') 


Then add the rank images, too. Put the image urls in place of the numbers. 1 will have its level 1 image, 2 the level 2 image, etc.

PHP Code:

INSERT INTO adoptable_rankimages VALUES ('name','1','2','3','4','5','6','7','8') 


[BMR777]

Well, using your system of altering the users table will break the user registration system.

You would want to also find in register2.php:

PHP Code:

mysql_query("INSERT INTO users VALUES ('', '$username', '$pass1','$email','free')"); 


Replace With:

PHP Code:

mysql_query("INSERT INTO users VALUES ('', '$username', '$pass1','$email','free','0')"); 


You need to add the extra column in there for the user's money. If the columns don't match, MySQL freaks out and new users are not registered correctly.

Also, I would change:

Code:

ALTER TABLE users
ADD money VARCHAR(11) NULL DEFAULT '0'

To:

Code:

ALTER TABLE users
ADD money INT

Use INT when only a number is expected.

Brandon

[Killgore]

So Brandon, would i be able to fuse this with my idea i was working on? If so, how?

[BMR777]

(03-26-2009 08:33 AM)Killgore Wrote:  So Brandon, would i be able to fuse this with my idea i was working on? If so, how?

I would suggest do the same, except add a second column to the database to account for pearls and emeralds.

[Killgore]

Okay. But there's still the dilemma that there's a chance of getting one out of five colors for each pearl or emerald. I'm guessing I'd need to create a field for each color pearl and emerald?

[BMR777]

PHP Code:

$color = "";
$number = rand(1,5); // Get random number between 1 and 5

if($number == 1){
$color = "redpebbleimage.gif";
}
else if($number == 2){
$color = "greenpebbleimage.gif";
}
else if(... and so on 


Just do that to assign a random pebble image and save in the db.

[rosepose]

Does it work right now?

[kisazeky]

Yes rosepose, getting currency for leveling up works. Just make sure to include Brandon's amendment or else people can't register anymore.

What's in progress still is the shop for buying adoptables with the money.

[Ashje]

Could you edit the first post and add Brandon's extra part because I fail at this stuff...Thanks.

[rosepose]

Thanks I'll try to add this to SE if the host decides to work ><