Currency for leveling up / Adoptable shop (Fixed again)

[kisazeky]

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

[size=large]Important!! A way to prevent people stealing shop adoptables![/size]

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!.";
} 


[size=large]Earning money on level up
[/size]
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. :P

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')"); 


[size=large]Show the total amount of money to your users[/size]

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.

[size=large]
Shop to buy adoptables[/size]

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. :P

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:

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

To:

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]

Originally Posted by Killgore

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. :P

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 ><