Mysidia Adoptables Support Forum - A silly little question

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

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - A silly little question (http://www.mysidiaadoptables.com/forum/showthread.php?t=3521)

A silly little question

When I'm trying to show the adopts in a table... how can I make it so there is a break say every 6 adopts or so?

If your adopts are in a table you should just be able to insert a blank row/cell to create a break in the adoptables.

I could give you better example/code if I had your code snipit.
Though I'm still pretty new to this, so I'm not sure how much help I can be.

I'm trying to get just a certain number of adopt images per row for the sort thing so that people can sort easier with smaller images.

So your wanting columns of adoptables so that you have more than one on each row?

Yep that is what I need :)

In that case I should be able to help you, since I just reccently added columns adoptables to my site. Though you'll have to convert it to fit the new 1.3 version cause I haven't touched that yet.

Have you made any changes to the original code? Like adding the ajax sortable feature or anything?

Yea I have the sort completing working... Just need to make it so I have rows of adopts instead of one on top of the other.

Alright then. Your going to need to change both the javascript in the HTML and the formatting in the myadopts.php. Do you mind showing me your code. It will make it easier for me to tell you what and where to put the code. If not I can just pull/edit my code.

K Here is my sort script. I have it separate from the my adopts

Code:

<?php



include("functions/functions.php");

include("functions/functions_users.php");

include("functions/functions_adopts.php");

include("classes/class_pagination.php");

include("css/pagination.css");

include("inc/lang.php");



//***************//

//  START SCRIPT //

//***************//

$id = $_GET["id"];

$act = $_GET["act"];

$more = $_GET["more"];

$page = $_GET["page"];









if($isloggedin == "yes")

{

$article_content = "<p id='activate_sort'>

                                 Click here to sort your adoptables

                            </p>

                            <table>

                                <tr>

                                    <th></th><th>Name and Type</th><th>Image</th><th>Clicks</th>

                                </tr>

                            </table>

                            <table id='sortable_adoptables'>";



                // We need to get all of the user's adoptables from the database and display them...

                 $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";

                $stmt = $adopts->query($query);

        



                while($row = $stmt->fetchObject()){

                        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 .= "<tr id='orderaid_{$row->aid}'><td><img src='{$image}' width='20px' height='20px'></td>

                           </tr> ";   

        }

        $article_content .= "</table>"; 

         

      }  

        

//***************//

//  OUTPUT PAGE  //

//***************//



echo showpage($article_title, $article_content, $date);



?>

and this one?

Code:

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js"></script>

<script type="text/javascript">

    $(document).ready(function(){

        

        $('body').undelegate('click').delegate('p#activate_sort', 'click', function(){

            var realBg = $('table#sortable_adoptables').css('background-color');

            var submitForm = '<form name="submit_order" id="submit_order" action="" method="post"><fieldset><label for="submit">Submit Changes</label><input type="submit" id="submit" value="Submit"></fieldset></form>';

            $('table#sortable_adoptables').css('background-color', '#FFFF66').animate({ backgroundColor: realBg },  'slow' ).find('tbody').sortable({ cursor: 'pointer' });

            $(submitForm).insertAfter('p#activate_sort').hide().slideDown();

            $('p#activate_sort').attr('id', 'deactivate_sort');

        });

        

        $('body').undelegate('submit').delegate('form#submit_order', 'submit', function(event){

            event.preventDefault();

            var data = $('table#sortable_adoptables tbody').sortable('serialize');

            $.post('ajax_sort.php', data, function(result){

                $('form#submit_order').html(result).delay(5000).fadeOut('slow', function(){

                    $(this).remove();                    

                });

            });

            $('table#sortable_adoptables tbody').sortable('destroy');

            $('p#deactivate_sort').attr('id', 'activate_sort');

        });

});

</script>

I made the chages to your php and the javascript. This should work. You might also want to change or remove the table that has the text for name, type, ect.
Let me know how it goes. ;3

PHP Code:


		
			
<?php



include("functions/functions.php");

include("functions/functions_users.php");

include("functions/functions_adopts.php");

include("classes/class_pagination.php");

include("css/pagination.css");

include("inc/lang.php");



//***************//

//  START SCRIPT //

//***************//

$id = $_GET["id"];

$act = $_GET["act"];

$more = $_GET["more"];

$page = $_GET["page"];









if($isloggedin == "yes")

{

$article_content = "<p id='activate_sort'>

                                 Click here to sort your adoptables

                            </p>

                            <table>

                                <tr>

                                    <th></th><th>Name and Type</th><th>Image</th><th>Clicks</th>

                                </tr>

                            </table>

                            <table>";



        // We need to get all of the user's adoptables from the database and display them...

         $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";

        $stmt = $adopts->query($query);

        



$cols = 3; //the number of columns



        do{

        $article_content .= "<tr>";

        for($i=1;$i<=$cols;$i++){ 

        



        while($row = $stmt->fetchObject()){

            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 .= "tent .= "

                        <td class='sortable_adoptables'>

                        <table id='orderaid_{$row['aid']}'><tr>

<td><img src='{$image}' width='20px' height='20px'></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>"; 

         

      }  

        

//***************//

//  OUTPUT PAGE  //

//***************//



echo showpage($article_title, $article_content, $date);



?>

HTML Code:

<script type="text/javascript">

        $(document).ready(function(){

            $('body').undelegate('click').delegate('p#activate_sort', 'click', function(){

                var realBg = $('table#sortable_adoptables').css('background-color');

                var submitForm = '<form name="submit_order" id="submit_order" action="" method="post"><fieldset><label for="submit">Click and drag a Pokemon to switch it with  another Pokemon.</br></br></label><input type="submit" id="submit" value="Save Changes"></fieldset></form>';

                $('.sortable_adoptables')

                    .css('background-color', '#FFFF66')

                    .animate({ backgroundColor: realBg },  'slow' )

                    .sortable({ 

                        cursor: 'pointer', connectWith: ".sortable_adoptables", receive: function(event, ui) {

                            var $this = $(this);

                            if ($this.children('table').length > 1) {

                                     $this.children('table').not(ui.item).appendTo(ui.sender);

                                }

                        }

                    });

                $(submitForm).insertAfter('p#activate_sort').hide().slideDown();

                $('p#activate_sort').attr('id', 'deactivate_sort');

            });

            

            $('body').undelegate('submit').delegate('form#submit_order', 'submit', function(event){

                event.preventDefault();

                var data = $.map($('.sortable_adoptables'), function(v, i){

                           return $(v).sortable('serialize');

                });

                data = data.join("&");

                $.post('ajax_sort.php', data, function(result){

                    $('form#submit_order').html(result).delay(5000).fadeOut('slow', function(){

                        $(this).remove();                    

                    });

                });

                $('.sortable_adoptables').sortable('destroy');

                $('p#deactivate_sort').attr('id', 'activate_sort');

            });

        });

    </script>