Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   Okay One more question XD (http://www.mysidiaadoptables.com/forum/showthread.php?t=4011)

Infernette 02-12-2013 09:50 PM

I was adding a description column to the myadopts page's table to display the description of the stage to show the basic description of the stage the creature is at.

Hall of Famer 02-12-2013 10:57 PM

I see, this sounds like a big change to the core script, you will have quite a bit of work to get it done.

Kamalya 02-12-2013 11:43 PM

Ill edit this in a second with my code and SS of my database, its not a big change to the core script at all.

Okay first in your MYSQL make sure you create a new table in your adopts_levels I called mine Descriptions: http://i46.tinypic.com/25zph1h.png

Then you will be able to add descriptions to the inside of the table like this:http://i49.tinypic.com/nvaxkp.png

After that you want to make sure your myadopts.php and levelup.php have the right fields in them so it can insert it into the table:
myadopts.php should look like this:

Code:

                                // Determine what to show for next level:

                                if($nextlevelexists == "true" and $nextlevel != ""){
                                        // See how many more clicks to go
                                        $ctg = $requiredclicks - $row->totalclicks;
                                        $nloutput = "{$nextlevel}<br /><b>Clicks Till Next Level:</b> {$ctg}";
                                }
                                else $nloutput = "Max Level";

                                $article_title = "<center>{$row->name}</center>";
                                $article_content = "<center><img src='{$image}'></center><br /><br />
                                                                        <font size='2px'><u><a href='myadopts.php?act=manage&id={$row->aid}'>Actions</a></u>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='myadopts.php?act=bbcode&id={$row->aid}'><u>Show HTML/BBCode Links</u></a><br />
                                                                        <b>Name:</b> {$row->name} &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>Owner:</b> {$owned_adoptables->owner}<br />
                                                                        <b>Race:</b> {$row->type}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>Total Clicks:</b> {$row->totalclicks}<br />
                                                                        <b>Gender:</b> <img src='picuploads/{$row->gender}.png'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>Current Level:</b> {$row->currentlevel}<br />
                                                                        <b>Trade Status:</b> {$row->tradestatus}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <b>Next Level:</b> {$nloutput}<br /><br /></font>";


//Description
$article_content .= "<center><font size='2px'>{$levels->descriptions}<br /><br />Terran Dragons are much the same as the dragons of legend on Earth, except for the fact Terran Dragons did not go extinct. It is not uncommon for them to be bred for transportation and farm usage. Dragons are large serpentine or reptilian creatures. There are several types of dragons ranging from the smaller drake to the large Western Dragon. When it is time for dragons to be bred they are led by their handler to the Breeding Grounds where the eggs are left for other Terran's to raise and take care of them, these eggs range from the most common pest to the rarest ones owned by the leaders of Terra.</font></center>";

The {$levels->descriptions} is all you need for it to insert it into your page.

For yours I took a look and I think this is the problem :
Code:

$table->buildtable(array("<img src='picuploads/{$adopt->gender}.png'>", "<em>{$adopt->name}</em> the {$adopt->type}", "<a href='myadopts.php?action=manage&id={$adopt->aid}'><img src='{$image}'></a>", $adopt->totalclicks, $level->description),
should be :
Code:

$table->buildtable(array("<img src='picuploads/{$adopt->gender}.png'>", "<em>{$adopt->name}</em> the {$adopt->type}", "<a href='myadopts.php?action=manage&id={$adopt->aid}'><img src='{$image}'></a>", $adopt->totalclicks,"{$levels->description}"),

SilverDragonTears 02-13-2013 07:21 AM

1 Attachment(s)
You need to make a filed in the adopts_adoptables table and then just call it where you want to show the description. I've done this with both my sites and it's not too hard if you know what you're doing. It looks really nice too.

I don't think attachments are working but I tried to attach one to show you an example.

Kamalya 02-13-2013 02:51 PM

I forgot to tell you to add this:
So instead of this: (it occurs at least twice in the file)
Code:

$stmt = $adopts->query("SELECT * FROM {$prefix}owned_adoptables WHERE owner='{$loggedinname}' and aid='{$id}'");
you can use this:

Code:

$stmt = $adopts->query("SELECT * FROM {$prefix}owned_adoptables, {$prefix}levels WHERE owner='{$loggedinname}' and aid='{$id}' and type=adoptiename and currentlevel=thisislevel");
It makes it go with the current level, otherwise w/e your last level is will not have the description and it will be a little messed up :D

Infernette 02-13-2013 05:20 PM

I got it to work awhile ago, thanks though for the help ;)

Hall of Famer 02-15-2013 09:46 AM

Well the syntax from Kamalya is for mys v1.3.1, it won't work with mys v1.3.2. Be careful if you use it.

Kamalya 02-15-2013 10:26 AM

Its 1.3.0 I use, I can't get anything higher to work.


All times are GMT -5. The time now is 04:16 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.