Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-18-2012, 04:42 PM
!Alive !Alive is offline
Member
 
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,071
!Alive is on a distinguished road
Default Sorting Columns of Adoptables

So I am working on having several columns of adoptables shown on the myadopts page instead of just one. And have them be sortable. I have successfully installed the sortable mod. It worked fine with the single row of adoptables. But when I implemented the columns the sorting quit working. I have scanned over the code and believe that the problem stems from having a table inside of the sorting table. Though I haven't the slightest how to go about changing what I have to make it work the way I want. I've tried a few things but they only result in one or the other of the two things(columns and sortablitiy) actually working.

With the below code the columns work but the sorting doesn't.
Here is the code:
PHP Code:
$article_content "<p id='activate_sort' style='cursor: pointer'>
        <img src='templates/icons/movepkmbtn.png' />
                                 
                            </p>
                            <table>
                                <tr>
                                    <strong>Your Pokemon</strong></br></br>
                                </tr>
                            </table>
                            <table id='sortable_adoptables'>"

        
        
                    
        
$query "    SELECT * 
                    FROM 
{$prefix}owned_adoptables 
                    LEFT JOIN 
{$prefix}sort_adoptables 
                        ON 
{$prefix}owned_adoptables.aid = {$prefix}sort_adoptables.adoptable_id
                    INNER JOIN 
{$prefix}levels 
                        ON 
{$prefix}levels.thisislevel = {$prefix}owned_adoptables.currentlevel
                    INNER JOIN 
{$prefix}adoptables
                        ON 
{$prefix}owned_adoptables.type = {$prefix}adoptables.type
                    WHERE 
{$prefix}owned_adoptables.owner = '{$loggedinname}
                    AND 
{$prefix}levels.adoptiename = {$prefix}adoptables.type
                    ORDER BY 
{$prefix}sort_adoptables.sorting_id";  
                                                        
        
$result runquery($query);
        
        
$cols 3;

        do{
        
$article_content .= "<tr>";
        for(
$i=1;$i<=$cols;$i++){  // All the rows will have $cols columns even if the records are less than $cols
        
        
$row mysql_fetch_array($result);
        if(
$row
        {
            if(
$row['usealternates'] =='yes')
            { 
                
$image $row['alternateimage']; 
            }
            else
            { 
                
$image $row['primaryimage']; 
            }
            if(
$row['currentlevel'] == 0)
            { 
                
$image $row['eggimage']; 
            }
            if(
$image=='')
            { 
                
$image $row['primaryimage']; 
            }
            
$article_content .= "
                        <td>
                        <table><tr id='orderaid_
{$row['aid']}'>
                                <td><a href='myadopts.php?act=manage&id=
{$row['aid']}'><img src='{$image}'></a></td>
                                <td><strong>
{$row['name']}</strong> the {$row['type']} Pokemon</br>
                                    Gender:<img src='picuploads/
{$row['gender']}.png'></br>
                                    Nature:
{$row['temperment']}</br>
                                    OT:
{$row['ot']}</br>
                                    EXP:
{$row['totalclicks']}</br></td>
                                <td width=50%>&nbsp;</td>    <!-- Create gap between columns -->
                            </tr></table></td>"
;
                                
        }
        
        else{
            
$article_content .= "<td>&nbsp;</td>";    //If there are no more records at the end, add a blank column
            
}
        }
    } while(
$row);
        
$article_content .= "</table>";
        
        
    } 
Thanks in advance for any help. <3
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a "Faction" for adoptables/owned adoptables Vaporman87 Questions and Supports 1 03-04-2014 03:38 PM
Columns after upgrade draugluin Questions and Supports 4 10-22-2012 04:49 AM
Sorting request.... Again. SilverDragonTears Questions and Supports 3 09-16-2012 03:02 AM
Sorting adoptables? (PHP code) Aasixx Questions and Supports 6 03-27-2012 06:10 PM
Choosing Adoptables Type [EASY ADOPTABLES SCRIPT ONLY] Ashje Addons/Mods Graveyard 2 05-24-2009 03:17 AM


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

Currently Active Users: 9766 (0 members and 9766 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636