Mysidia Adoptables Support Forum - Currency for leveling up / Adoptable shop (Fixed again)

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Addons/Mods Graveyard (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=41)

- - Currency for leveling up / Adoptable shop (Fixed again) (http://www.mysidiaadoptables.com/forum/showthread.php?t=561)

RE: Currency for leveling up and adoptable shop [Beta]

Im getting the same error as well, It has to be because of the 'egg' part.

RE: Currency for leveling up and adoptable shop [Beta]

i think a "kind" and "cost" row has to be added to the adoptables table......

RE: Currency for leveling up and adoptable shop [Beta]

yeah, i'll try it.

EDIT: YES! I did it! you have to add a 'kind' column to the table 'adoptables'. then when you add the adoptable, you use this query:

Code:

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

then go to the shop.php file, and find this:

Code:

$query = "SELECT * FROM adoptables WHERE kind = 'egg' LIMIT 0,5";

change the 'egg' bit to what ever you put in the 'kind' bit of the query. :)

The adoptable still appears in the adoption page, but i will look and try to fix this.

NEW EDIT: Fixed that too! in the database, go to the 'adoptables' table, and in the adoptables you want in the offcial adoption place, set their kind to something like, 'adoptable'.

then, in adopt.php, find this line:

Code:

$query = "SELECT * FROM adoptables"

and change it to this:

Code:

$query = "SELECT * FROM adoptables WHERE kind = 'adoptable'";

change the 'adoptable' to whatever you set in the 'kind' area for the official adoptables.

:)

RE: Currency for leveling up and adoptable shop [Beta]

Thats what i did too, and changed the "egg" to "shop" and the "full" to "shop2"

The creator of this mod must have forgotten to post the bit about adding the new rows to the adoptables table as well....

RE: Currency for leveling up and adoptable shop [Beta]

Erm... How exactly do you add the column?

RE: Currency for leveling up and adoptable shop [Beta]

@ rosepose:

Click here:
http://i172.photobucket.com/albums/w...hoto/kind1.jpg
Then fill it in like this:
http://i172.photobucket.com/albums/w...hoto/kind2.png
And click Save.

Thanks mattalien, everything works perfectly now. =)

RE: Currency for leveling up and adoptable shop [Updated] [Beta]

Ok, with the update, there is now no need to add new columns. It adds "shop" to the "memberlevel" column and the cost to the "description" table.

Also this is a more secure buying method so people cannot get them for free.

RE: Currency for leveling up and adoptable shop [Updated] [Beta]

I still don't get how to add a pet to the shop :P Heh, i've looked over the files..but I'm not sure what to change or add...

RE: Currency for leveling up and adoptable shop [Updated] [Beta]

we now have the shop.. thanks

visit : fresbopet.netau.net to see

RE: Currency for leveling up and adoptable shop [Updated] [Beta]

Quote:

Originally Posted by densaugeo

I still don't get how to add a pet to the shop :P Heh, i've looked over the files..but I'm not sure what to change or add...

Don't add or change anything. Just run the SQL Queries in Post 43.

Quote:

Originally Posted by kisazeky

How is it safer? It is much easier to add a kind column with the old one. Anyways, thanks for the buyconfirm. =)

EDIT:
buyconfirm doesn't work, the new shop file doesn't work (it screws up the template and when you buy something, nothing appears on the page...

RE: Currency for leveling up and adoptable shop [Updated] [Beta]

Can i just ask, how can I add a new section to the shop?

e.g. I have the one heading that says "Gold Coin Frames", and I would like another one saying "Platinum Coin Frames" underneath.

How do I do this?

RE: Currency for leveling up and adoptable shop [Updated] [Beta]

Easy, mattalien.

First of all, insert the adoptables you want in this section using this query. Replace shop with something different like shop_platinum.

PHP Code:


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

Don't forget to add the rank images.

Then edit shop.php and find this line:

PHP Code:


		
			
$article_content = stripslashes($article_content);

Right below it, put this in:

PHP Code:


		
			
$article_content=$article_content."<p>Platinum Coin Frames";

$query = "SELECT * FROM adoptables WHERE memberlevel = 'shop_platinum'";
$result = mysql_query($query);
$num = mysql_numrows($result);

//Loop out code
$i=0;
while ($i < $num) {

$aID=@mysql_result($result,$i,"uid");
$name=@mysql_result($result,$i,"name");
$imageurl=@mysql_result($result,$i,"imageurl");
$cost=@mysql_result($result,$i,"description");

//Begin our content output...
$article_content=$article_content."<p>".$name."<p><img src='".$imageurl."' /><p>".$cost." <p><a href='buy.php?aID=".$aID."'>Buy ".$name."</a>";


$i++;
}

RE: Currency for leveling up and adoptable shop [Updated] [Beta]

I ended up having to add a kind row anyway :P With the memberlevel one, no matter what i put the adoptable's level at, anyone could still get it. and that was the problem i was having XD but i fixed it with adding a 'kind' to it. so it's all good now :D Thank you!

RE: Currency for leveling up / Adoptable shop (NEW: Prevent stealing!)

Densaugeo, I've added an anti-theft code to the adopt page, so no one can adopt these shop creatures through the adopt page. :)

RE: Currency for leveling up / Adoptable shop (NEW: Prevent stealing!)

Quote:

Originally Posted by kisazeky

Easy, mattalien.

First of all, insert the adoptables you want in this section using this query. Replace shop with something different like shop_platinum.

PHP Code:


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

Don't forget to add the rank images.

Then edit shop.php and find this line:

PHP Code:


		
			
$article_content = stripslashes($article_content);

Right below it, put this in:

PHP Code:


		
			
$article_content=$article_content."<p>Platinum Coin Frames";

$query = "SELECT * FROM adoptables WHERE memberlevel = 'shop_platinum'";
$result = mysql_query($query);
$num = mysql_numrows($result);

//Loop out code
$i=0;
while ($i < $num) {

$aID=@mysql_result($result,$i,"uid");
$name=@mysql_result($result,$i,"name");
$imageurl=@mysql_result($result,$i,"imageurl");
$cost=@mysql_result($result,$i,"description");

//Begin our content output...
$article_content=$article_content."<p>".$name."<p><img src='".$imageurl."' /><p>".$cost." <p><a href='buy.php?aID=".$aID."'>Buy ".$name."</a>";


$i++;
}

Thanks! You are the best, apart from BMR77!

:)

RE: Currency for leveling up / Adoptable shop (NEW: Prevent stealing!)

Quote:

Originally Posted by Ashje

Quote:

Originally Posted by densaugeo

I still don't get how to add a pet to the shop :P Heh, i've looked over the files..but I'm not sure what to change or add...

Don't add or change anything. Just run the SQL Queries in Post 43.

Quote:

Originally Posted by kisazeky

EDIT: The stealing thing doesn't work either, it just prevents any user adopting the main adoptables, not in the shop.

RE: Currency for leveling up / Adoptable shop (NEW: Prevent stealing!)

Is there any way i could set the adoptables in a table that would look like this:

Code:

<center><table border='2' bordercolor='#3d3d3d' cellpadding='5' cellspacing='1'>

<tr>

<td bgcolor='#575757'><p><font face='Verdana' size='1' color='ffffff'><center>".$name."<p><img src='".$imageurl."' /><p>".$cost."<p><a href='buy.php?aID=".aID."'>Buy a ".$name."!</a></td>

<td bgcolor='#575757'><p><font face='Verdana' size='1' color='ffffff'><center>".$name."<p><img src='".$imageurl."' /><p>".$cost."<p><a href='buy.php?aID=".aID."'>Buy a ".$name."!</a></td>

<td bgcolor='#575757'><p><font face='Verdana' size='1' color='ffffff'><center>".$name."<p><img src='".$imageurl."' /><p>".$cost."<p><a href='buy.php?aID=".aID."'>Buy a ".$name."!</a></td>

</tr>

<tr>

<td bgcolor='#575757'><p><font face='Verdana' size='1' color='ffffff'><center>".$name."<p><img src='".$imageurl."' /><p>".$cost."<p><a href='buy.php?aID=".aID."'>Buy a ".$name."!</a></td>

<td></td>

<td bgcolor='#575757'><p><font face='Verdana' size='1' color='ffffff'><center>".$name."<p><img src='".$imageurl."' /><p>".$cost."<p><a href='buy.php?aID=".aID."'>Buy a ".$name."!</a></td>

</tr>

</table></center>

Unfortunately, it repeats, and makes 5 tables all in the order i want, but all 5 cells have the same adoptable and each table displays a different adoptable. In case I'm talking gibberish, here's what i mean: http://sylonia.comyr.com/adoptables/shop.php

RE: Currency for leveling up / Adoptable shop (NEW: Prevent stealing!)

Quote:

Originally Posted by Ashje

Quote:

Originally Posted by Ashje

Quote:

Originally Posted by densaugeo

I still don't get how to add a pet to the shop :P Heh, i've looked over the files..but I'm not sure what to change or add...

Don't add or change anything. Just run the SQL Queries in Post 43.

Quote:

Originally Posted by kisazeky

EDIT: The stealing thing doesn't work either, it just prevents any user adopting the main adoptables, not in the shop.

Your shop adoptables need to have something other than free in their memberlevel column. Put shop in memberlevel.

RE: Currency for leveling up / Adoptable shop (NEW: Prevent stealing!)

OMG this is going to be so helpful on my site! *squeals!*

Thank you sooooooooo much for making this!!! :D

RE: Currency for leveling up / Adoptable shop (Updated levelup.php with generic message)

Got it. You forgot to add this:

PHP Code:


		
			
$memberlevel=@mysql_result($result,$i,"memberlevel");

to the mysql results.

RE: Currency for leveling up / Adoptable shop (Fixed again)

Just went to buy an adoptable from the shop. I clicked it, it all worked fine 'till I clicked adopt. Then it wouldn't let me adopt, even when I legitimately adopted it. I had to take that part out of adopt.php for it to work. Help?

RE: Currency for leveling up / Adoptable shop (Fixed again)

Now that I got the one issue taken care of, I want to submit this information to see if you'd know how to help me convert from adoptables to items.

shop.php code:

PHP Code:


		
			
<?php

// Easy Adoptables Script by Brandon Rusnak
// Get our includes out of the way

include("inc/functions.php");
include("inc/config.php");
include("inc/settings.php");
include("inc/nbbc.php");  // BBCODE Parser
$bbcode = new BBCode;

$stop = 0;

// Connect to our database

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql database!');
mysql_select_db($dbname);


//Set up our login info...
$username = "";
$password = "";

//Check for cookie

if (isset($_COOKIE['adoptu']) and isset($_COOKIE['adoptp'])){

$username = $_COOKIE['adoptu'];
$password = $_COOKIE['adoptp'];

$username = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $username);
$password = preg_replace("/[^a-zA-Z0-9s]/", "", $password);

//Run login operation
$query = "SELECT * FROM users WHERE username = '$username'";
$result = mysql_query($query);
$num = mysql_numrows($result);

//Loop out code
$i=0;
while ($i < 1) {

$luser=@mysql_result($result,$i,"username");
$lpass=@mysql_result($result,$i,"password");

$i++;
}

    if($username == $luser and $password == $lpass){
        $isloggedin = "yes";
    }
    else{
    if (isset($_COOKIE['adoptu'])){
    $past = time() - 10; 
    setcookie("adoptu",$username,$past);
    }

    if (isset($_COOKIE['adoptp'])){
    $past = time() - 10; 
    setcookie("adoptp",$password,$past);
    }
    $isloggedin = "no";
    }

}
else
{
//User is not logged in
$isloggedin = "no";

} 


// Define our Template File

$file = $current_theme;



// Get our content for the items page
if($isloggedin == "yes" and $ID == ""){

$article_title = "Market Place";
$article_content = "Shop description goes here.";

$query = "SELECT * FROM items WHERE memberlevel = 'shop'";
$result = mysql_query($query);
$num = mysql_numrows($result);

//Loop out code
$i=0;
while ($i < $num) {

$iID=@mysql_result($result,$i,"uid");
$name=@mysql_result($result,$i,"name");
$imageurl=@mysql_result($result,$i,"imageurl");
$memberlevel=@mysql_result($result,$i,"memberlevel"); 
$cost=@mysql_result($result,$i,"description");

//Begin our content output...
$article_content=$article_content."<p>".$name."<p><img src='".$imageurl."' /><p>".$cost." <p><a href='buy.php?ID=".$ID."'>Buy ".$name."</a></td>";


$i++;
}

$article_title = stripslashes($article_title);
$article_content = stripslashes($article_content);



}
else if ($isloggedin == "no" and $iID == ""){
// Guest is viewing the available items

$article_title = "Shop";
$article_date = date('Y-m-d');
$article_content = "Please log in to buy items.";


$article_title = stripslashes($article_title);
$article_content = stripslashes($article_content);

}
else if ($isloggedin == "no" and $aID != ""){
// Guest is trying to adopt an adoptable -- not allowed for tracking purposes

$article_title = "Error";
$article_date = date('Y-m-d');
$article_content = "You must <a href='register.php'>register</a> an account before you can buy adoptables.";

$article_title = stripslashes($article_title);
$article_content = stripslashes($article_content);

}



// Should we show the extra pages in the nav bar?

$link1 = "";
if($show_extra_page1 == "yes"){
$link1 = "<li><a href='$extra_page1_link'>$extra_page1_name<span class='tab-l'></span><span class='tab-r'></span></a></li>"; 
}

$link2 = "";
if($show_extra_page2 == "yes"){
$link2 = "<li><a href='$extra_page2_link'>$extra_page2_name<span class='tab-l'></span><span class='tab-r'></span></a></li>"; 
}


// Do the template changes and echo the ready template

$template = file_get_contents($file);
$template = replace(':SITETITLE:',$site_title,$template);
$template = replace(':SITENAME:',$site_name,$template);
$template = replace(':ARTICLETITLE:',$article_title,$template);
$template = replace(':ARTICLEDATE:',$article_date,$template);
$template = replace(':ARTICLECONTENT:',$article_content,$template);
$template = replace(':LINK1:',$link1,$template);
$template = replace(':LINK2:',$link2,$template);
$template = replace(':LINK3:',$link3,$template);

//Get the featured adoptable...
$featured = getfeatured();
$template = replace(':FEATURED:',$featured,$template);

//Ad Management
$header = @file_get_contents("ads/header.txt");
$footer = @file_get_contents("ads/footer.txt");
$tower = @file_get_contents("ads/tower.txt");

$header = stripslashes($header);
$footer = stripslashes($footer);
$tower = stripslashes($tower);

$template = replace(':HEADERAD:',$header,$template);
$template = replace(':FOOTERAD:',$footer,$template);
$template = replace(':TOWERAD:',$tower,$template);


//Is the user logged in?
//$isloggedin = "no";
if ($isloggedin == "yes"){
$template = replace(':WELCOMEORREGISTER:','',$template);
$template = replace(':LOGINORACCT:', '<p>Hi, <a href="profile.php?owner='.$username.'">'.$username.'</a>
<p><a href="logout.php">Log out</a>' ,$template);
}
else{

//User is not logged in
$template = replace(':WELCOMEORREGISTER:','Hi there, please login or register',$template);
$loginform = "<form name='form1' method='post' action='login.php'>
  <p><font size=1>Username 
    <input name='username' type='text' id='username' size=10>
</p>
  <p><font size=1>Password</font>
    <input name='password' type='password' id='password' size=10>
</p>
  <p>
    <input type='submit' name='submit' value='Let`s Go!'>
  </p>
</form>
";
$template = replace(':LOGINORACCT:', $loginform ,$template);
}

echo $template;
?>

MySQL Code

PHP Code:


		
			
CREATE TABLE items VALUES('uid', 'name', 'image', 'shop', 'cost')

So far it only gives a blank page with an error (http://familiarelements.info/shop.php):

Code:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/enddayne/public_html/shop.php on line 88

RE: Currency for leveling up / Adoptable shop (Fixed again)

^
Sounds like there's an error here:

PHP Code:


		
			
$iID=@mysql_result($result,$i,"uid");
$name=@mysql_result($result,$i,"name");
$imageurl=@mysql_result($result,$i,"imageurl");
$memberlevel=@mysql_result($result,$i,"memberlevel"); 
$cost=@mysql_result($result,$i,"description");

Quote:

Originally Posted by Ashje

RE: Currency for leveling up / Adoptable shop (Fixed again)

When I put the anti-theft thingamajig in it gives me an error (I'm still using the Kind column)

RE: Currency for leveling up / Adoptable shop (Fixed again)

Don't use the kind column, rose.

Use memberlevel. You are to put shop in memberlevel and make sure all of your free adoptables do in fact say free in their memberlevel for the anti-theft to work.

Quote:

Originally Posted by Ashje

It sounds like you are still using the old version of shop.php. Please download shop.php again from my post as well as buy.php and buyconfirm.php if you have not already.

RE: Currency for leveling up / Adoptable shop (Fixed again)

The new shop has errors. When I click buy, the page comes up completely blank. Just a white screen.

RE: Currency for leveling up / Adoptable shop (Fixed again)

Slight issue: the money portion of the script stops working after a bit. I'll get som, then it won't show that i got some, as well as how much i currently have.

RE: Currency for leveling up / Adoptable shop (Fixed again)

Hi! what do you mean by "running queries"? do you mean in the mySQL text document? if so do you think you could make a mod to let me add adopts to the shop directly from the admin part? because my friend controlls the mySQL parts of the site and he's not on a lot

RE: Currency for leveling up / Adoptable shop (Fixed again)

^
You can't do that, you have to have access to MySQL.

RE: Currency for leveling up / Adoptable shop (Fixed again)

Okay, dumb question time..... Are all the fixes discussed in the 8 pages of this thread included in the first post, or do I have to go through and do a bunch of edits? I know, lame question.... it's late.... brain no workee. Humour the crazy lady, 'k?

:P

RE: Currency for leveling up / Adoptable shop (Fixed again)

you may want to see if there are any errors the creator of this forum didn't see but once you get past his last post it should be on the first page (i hope)

RE: Currency for leveling up / Adoptable shop (Fixed again)

Quote:

Originally Posted by mugwumpr

There seems to be one rampant issue, which I am trying to fix. Kisazeky isn't responding though.

EDIT:
If you re-install everything on the front page and re-run the queries, it all works fine.

RE: Currency for leveling up / Adoptable shop (Fixed again)

Quote:

Originally Posted by Ashje

EDIT: If you re-install everything on the front page and re-run the queries, it all works fine.

Excellent, thank you! I'll give that a whirl tomorrow. The brain doesn't work very well after a heavy load of Easter ham....

:rolleyes: ;)

RE: Currency for leveling up / Adoptable shop (Fixed again)

Oh, very yum yum!! I still haven't fully recovered.

:o9

RE: Currency for leveling up / Adoptable shop (Fixed again)

OK, seriously. How do I add an adoptable to the shop? And how do I make it so that it says something like this:
"You have earned 20 bucks for leveling up this pet." because it just says: You have earned (number) (currency name) for leveling up this pet.

RE: Currency for leveling up / Adoptable shop (Fixed again)

^
Easy.

1 (Adding Adoptables to the shop). Go to MySQL and open the queries. Copy-Paste this:

Code:

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

This is how it works:

'' - Leave this blank

'name' - Replace name with the Adoptable Name but keep the ''.

'level 0 image' - Replace level 0 image with the default image for your adoptable but keep the ''.

'shop' - Leave this as it is.

'cost' - Replace cost with how much the adoptable is going to cost but keep the ''.

Run that query. Now copy-paste this new query into the box:

Code:

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

Again:

'name' - Replace name with the same name you did in the last one. It has to be the same name or your adoptable won't evolve. Keep the ''.

'1' - Replace 1 with the first adoptable image but keep the ''.

and so on and so on. When that is done, run the query and check that your adoptable appears in the shop.

2 (changing Money Message). Go to levelup.php and search for

Code:

$article_content=$article_content. "

                        <p>You have earned (number) (currency name) for leveling up this pet.

                        <br>You now have  ".$newbalance." (currency name)";

        

                        }

Change the "You have earned (number) (currency name) for leveling up this pet, etc."...

RE: Currency for leveling up / Adoptable shop (Fixed again)

Hm, well... I don't know how to change the (number) because my users get a random amount from 10-25 "Emeralds". Does the command $money work? Or does anything else so? Maybe I can add something new to the MySQL, like $Money_Get or something, and I do it like this:
$Money_Get = rand(10,25)?
But I seriously don't think that will work.

Can anyone here help me to get the money to show? Please? I enter the code where it should be. And I get THIS error:
"Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/a8498929/public_html/index.php on line 62"
Or anything similar. How do I solve this?