Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Addons and Modifications > Mys v1.3.x Mods

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2012, 03:45 AM
StarGirl's Avatar
StarGirl StarGirl is offline
Member
 
Join Date: Feb 2012
Posts: 45
Gender: Female
Credits: 1,907
StarGirl is on a distinguished road
Default Group sort

This is a group sort mod. Create groups at myadopts.php, move pets in from their management page, navigate through groups through the drop down.

Screenshots: [NOTE: The way that the pets are shown in the screenshots is not how it will look on your site. It is just the way I want them to be displayed on my site.]

Screenshot1
Screenshot2


For a preview, check out my site at http://myxiplanet.x10.mx/stable.php.

1. Create a 'adopts_pet_groups' table
Since I have no idea how to do it with a query, go to PhpMyAdmin then go to your database, select the 'Operations' tab then create a table called adopts_pet_groups with 3 columns, replacing 'adopts_' with your prefix. Then fill in the details like this:


2. Create the group row
Go to the {$prefix}owned_adoptables table.. then select the 'structure' tab. Find this and press go:

Then in 'column', put "group", change "type" to "VARCHAR", set "length/values" to 15, set "Default" to "As defined:", "0", and leave all else.

3. Edits
You can close PhpMyAdmin now. Now it's time to edit the files;

In doadopt.php:
At line 60, find:
PHP Code:
                                        "imageurl" => NULL"usealternates" => $alts"tradestatus" => 'fortrade'"isfrozen" => 'no'"gender" => $genders[$rand], "lastbred" => 0)); 
And replace it with
PHP Code:
                                        "imageurl" => NULL"usealternates" => $alts"tradestatus" => 'fortrade'"isfrozen" => 'no'"gender" => $genders[$rand], "lastbred" => 0"group" => 0)); 
In myadopts.php:
Replace everything with:
PHP Code:
<?php

include("functions/functions.php");
include(
"functions/functions_users.php");
include(
"functions/functions_adopts.php");
include(
"css/pagination.css");
include(
"inc/lang.php");

//***************//
//  START SCRIPT //
//***************//

$id $_GET["id"];
$act $_GET["act"];
$more $_GET["more"];
$page $_GET["page"];
$group $_GET["group"];
$submit $_GET["submit"];
$groupname $_POST["groupname"];

if(
$isloggedin == "yes"){
    if(
$act == "" and $groupname == ""){         
        
$article_title "Your Adoptables";
if(!
$group == ""){
        if(!
is_numeric($group)){
            
$article_title "No group";
            
$article_content "Group does not exist.";
        }
        else{
            
$row $adopts->select("pet_groups", array(), "user='{$loggedinname}' and id='{$group}'")->fetchObject();    
            if(
$row->id == $group and $row->user == $loggedinname){
            
$groupquery "AND
"
.constant("PREFIX")."owned_adoptables.group = {$group}";
            }
            else{
            
// Invalid group
            
$article_title "No group";
            
$article_content "Group does not exist.";
            }

        }
}
else{
$groupquery "AND
"
.constant("PREFIX")."owned_adoptables.group = 0";
$selected "selected";
}

        
// We need to get all of the user's adoptables from the database and display them...
         
$query "SELECT * FROM ".constant("PREFIX")."owned_adoptables, 
                                "
.constant("PREFIX")."adoptables, 
                                "
.constant("PREFIX")."levels WHERE     ".constant("PREFIX")."owned_adoptables.owner = '{$loggedinname}
                                                        AND "
.constant("PREFIX")."adoptables.type = ".constant("PREFIX")."owned_adoptables.type 
                                                        AND "
.constant("PREFIX")."levels.thisislevel = ".constant("PREFIX")."owned_adoptables.currentlevel 
                                                        AND "
.constant("PREFIX")."levels.adoptiename = ".constant("PREFIX")."adoptables.type 
                                                        AND "
.constant("PREFIX")."levels.adoptiename = ".constant("PREFIX")."adoptables.type 
                                                        
{$groupquery}

                                                        ORDER BY "
.constant("PREFIX")."owned_adoptables.totalclicks";
        
$rowsperpage 10;
        
$pagination = new Pagination($adopts$query$rowsperpage"http://".constant("DOMAIN").constant("SCRIPTPATH")."/stable.php?group={$group}");
        
$pagination->setPage($_GET[page]);
        
$query "SELECT * FROM ".constant("PREFIX")."owned_adoptables, 
                                "
.constant("PREFIX")."adoptables, 
                                "
.constant("PREFIX")."levels WHERE     ".constant("PREFIX")."owned_adoptables.owner = '{$loggedinname}
                                                        AND "
.constant("PREFIX")."adoptables.type = ".constant("PREFIX")."owned_adoptables.type 
                                                        AND "
.constant("PREFIX")."levels.thisislevel = ".constant("PREFIX")."owned_adoptables.currentlevel 
                                                        AND "
.constant("PREFIX")."levels.adoptiename = ".constant("PREFIX")."adoptables.type 
                                                        
{$groupquery}                                                
                                                        ORDER BY "
.constant("PREFIX")."owned_adoptables.totalclicks LIMIT {$pagination->getLimit()},{$rowsperpage}";
        
$stmt $adopts->query($query);
$groups ""// Get groups
$stmt2 $adopts->select("pet_groups", array(), "user='{$loggedinname}'");
while(
$row $stmt2->fetchObject()) {
  
$id=$row->id;
  
$name=$row->name;
  if(
$id == $group){
  
$groups .= "<option value='{$id}' selected>{$name}</option>";
  
$selected "";
  }
  else{
  
$groups .= "<option value='{$id}'>{$name}</option>";
  }
}
        
$article_content "
        <b>Group:</b><br>
    <form method='get' action='myadopts.php'>
    <select name='group' id='group'>
<option value='0' 
{$selected}>Ungrouped</option>
{$groups}
    </select><br><input type='submit' value='Go'></form>
    <a href='stable.php?act=creategroup'>Create a new group</a>
        <br><br><table>
                                <tr>
                                    <th></th><th>Name and Type</th><th>Image</th><th>Clicks</th>
                                </tr>"
;
        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>
                                    <td><center><img src='picuploads/
{$row->gender}.png'></center></td>
                                    <td><center><em>
{$row->name}</em> the {$row->type}</center></td>
                                    <td><center><a href='myadopts.php?act=manage&id=
{$row->aid}'><img src='{$image}'></a></center></td>
                                    <td><center>
{$row->totalclicks}</center></td>
                                </tr>"
;
        }
        
$article_content .= "</table><br /><br />{$pagination->showPage()}";
    }
    elseif(
$act == "manage"){
    
        
// We are managing a specific adoptable        
        
if(!is_numeric($id)){
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
        else{
            
// See if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    

            
// Check that the adoptable exists for real, or show an error...
            
if($row->aid == $id){
            
                
// The adoptable does exist, so we show the image and junk to the user...
                
$image getcurrentimage($id);
                
$article_title "Managing {$row->name}";
                
$article_content "<img src='{$image}'><br /><br />This page allows you to manage {$row->name}.  Click on an option below to change settings.<br /><br />
                                    <b><a href='levelup.php?id=
{$id}'><img src='templates/icons/add.gif' border=0> Level Up {$row->name}</a><br />
                                    <a href='myadopts.php?act=stats&id=
{$id}'><img src='templates/icons/stats.gif' border=0> Get Stats for {$row->name}</a><br />
                                    <a href='myadopts.php?act=bbcode&id=
{$id}'><img src='templates/icons/bbcodes.gif' border=0> Get BBCodes / HTML Codes for {$row->name}</a><br />
                                    <a href='myadopts.php?act=rename&id=
{$id}'><img src='templates/icons/title.gif' border=0> Rename {$row->name}</a><br />
                                    <a href='myadopts.php?act=trade&id=
{$id}'><img src='templates/icons/trade.gif' border=0> Change Trade Status {$row->name}</a><br />
                                    <a href='myadopts.php?act=freeze&id=
{$id}'><img src='templates/icons/freeze.gif' border=0> Freeze or Unfreeze {$row->name}</a><br />
                                                            <a href='myadopts.php?act=group&id=
{$id}'> Group {$row->name}</a><br />                          
                                    <a href='myadopts.php?act=pound&id=
{$id}'><img src='templates/icons/delete.gif' border=0> Pound {$row->name}</a></b>";
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist_text;
            }
        }
    } 
// End the MANAGE action code
    
elseif($act == "stats"){
        
// We are getting the stats for the adoptable
        // Check that an ID was submitted...
        
if(is_numeric($id)){
            
// Now we see if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();                
            if(
$row->aid == $id){
                
// The adoptable exists, so we show the stats for it...

                
$image getcurrentimage($id);
                
$nextlevelexists getnextlevelexists($row->type$row->currentlevel);

                
// If a higher level exists, get that level's information...

                
if($nextlevelexists == TRUE){
                    
$nextlevel $row->currentlevel 1;

                    
$levels $adopts->select("levels", array(), "adoptiename='{$row->type}' and thisislevel='{$nextlevel}'")->fetchObject();    
                    
$requiredclicks$levels->requiredclicks//The adoptable's ID

                
// End grab next level info...

                // 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 />Clicks Required for Level Increase: {$ctg}";
                }
                else 
$nloutput "This adoptable is at its maximum level";

                
$article_title "{$row->name}'s Statistics:";
                
$article_content "<img src='{$image}'><br /><br />
                                    <b>Total Clicks: 
{$row->totalclicks}<br />
                                    Gender: <img src='picuploads/
{$row->gender}.png'><br />
                                    Trade Status: 
{$row->tradestatus}<br />
                                    Current Level: 
{$row->currentlevel}<br />
                                    Next Level: 
{$nloutput}<br /></b>";

                
// Voters Information...

                
$article_content .= "<h2>{$row->name}'s Voters:</h2><br />
                                    
{$lang_voters_explain}<br /><br />
                                    <table width='450' border='1'>
                                        <tr>
                                            <td width='129'><strong>Username:</strong></td>
                                            <td width='156'><strong>Date Voted: </strong></td>
                                            <td width='82'><strong>Profile:</strong></td>
                                            <td width='55'><strong>PM:</strong></td>
                                        </tr>"
;

                
// Select the voters from the DB

                
$stmt $adopts->select("vote_voters", array(), "adoptableid='{$id}' ORDER BY date DESC LIMIT 10");
                while(
$row $stmt->fetchObject()) {
                    if(
$row->username == ""$row->username "Guest";
                    if(
$row->username == "Guest"){
                        
$article_content .= "<tr>
                                            <td><div align='left'>Guest</div></td>
                                            <td><div align='left'>
{$row->date}</div></td>
                                            <td><div align='center'></div></td>
                                            <td><div align='center'></div></td>
                                        </tr>"
;
                    }
                    else{
                        
$article_content .= "<tr>
                                            <td><div align='left'>
{$row->username}</div></td>
                                            <td><div align='left'>
{$row->date}</div></td>
                                            <td><div align='center'><a href='profile.php?user=
{$row->username}' target='_blank'><img src='templates/buttons/profile.gif' border=0></a></div></td>
                                            <td><div align='center'><a href='messages.php?act=newpm&user=
{$row->username}' target='_blank'><img src='templates/buttons/pm.gif' border=0></a></div></td>
                                        </tr>"
;
                    }
                }
                
$article_content .= "</table><br />";
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist_text;
            }
        }
        else
        {
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
    } 
// End the STATS code
    
elseif($act == "bbcode"){
        if(
is_numeric($id)){
            
// Now we see if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();                
            if(
$row->aid == $id){
                
$altbb grabanysetting("usealtbbcode");

                
// Adoptable exists, so show the BBCode:
                
$article_title "Codes for {$row->name}";
                
$article_content "{$lang_bbcode_explain}<br />
                                    <p><u>Forum Codes / BBCode: </u></p>
                                    <p>
                                        <textarea name='textarea' cols='50' rows='4'>
                                            [url=http://www."
.constant("DOMAIN").constant("SCRIPTPATH")."/levelup.php?id={$row->aid}][img]http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/siggy.php?id={$row->aid}[/img][/url]
                                        </textarea>
                                    </p>"
;

                if(
$altbb == "yes"){
                
                    
// Use the seo friendly alternate bbcodes...
                    
$article_content .= "
                                    <p><u>Alternate BBCodes (Use if the above do not work on a forum): </u></p>
                                    <p>
                                        <textarea name='textarea' cols='50' rows='4'>
                                            [url=http://www."
.constant("DOMAIN").constant("SCRIPTPATH")."/levelup.php?id={$row->aid}][img]http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/get/{$row->aid}.gif\"[/img][/url]
                                        </textarea>
                                    </p>"
;
                }                
                
$article_content .= "<p><u>HTML Code</u>:</p>
                                    <p>
                                        <textarea name='textarea' cols='50' rows='4'>
                                            <a href=\"http://www."
.constant("DOMAIN").constant("SCRIPTPATH")."/levelup.php?id={$row->aid}\" target=\"_blank\">
                                                <img src=\"http://www."
.constant("DOMAIN").constant("SCRIPTPATH")."/siggy.php?id={$row->aid}\" border=0>
                                            </a>
                                        </textarea>  
                                    </p>"
;
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist_text;
            }
        }
        else{
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
    } 
// End the BBCODE generation for the adoptable...
    
elseif($act == "rename"){
        
// We are renaming an adoptable

        
if(is_numeric($id)){
        
            
// Now we see if the adoptable actually exists...
            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    

            if(
$row->aid == $id){
            
                
$image getcurrentimage($id);
                if(
$row->isfrozen != "yes"){
                    if(
$more == ""){
                        
$article_title "Rename {$row->name}";
                        
$article_content "<img src='{$image}'><br />{$lang_rename}{$row->name}{$lang_rename2}<br />
                                            <form name='form1' method='get' action='stable.php'>
                                                <p>Adoptable Name: 
                                                    <input name='more' type='text' id='more'>
                                                    <input name='id' type='hidden' id='id' value='
{$id}'>
                                                    <input name='act' type='hidden' id='act' value='rename'>
                                                </p>
                                                <p>
                                                    <input type='submit' name='Submit' value='Rename Adoptable'>
                                                </p>
                                            </form>"
;
                    }
                    else{
                        
// We are renaming the adoptable, lets first check if the user is its original owner.
                        
$row $adopts->select("pounds", array(), "aid='{$id}'")->fetchObject();
                        if(!empty(
$row->firstowner) and $loggedinname != $row->firstowner){
                            
$article_title "Cannot rename";
                            
$article_content "The site admin has specified that only original owners can rename their adoptables.";                     
                        }
                        else{                        
                               
$adopts->update("owned_adoptables", array("name" => $more), "aid='{$id}' and owner='{$loggedinname}'");
                            
$article_title $lang_rename_success_title;
                            
$article_content "<img src='{$image}'><br />{$lang_rename_success}{$more}
                                               You can now manage 
{$more} in your <a href='myadopts.php?act=manage&id={$id}'>My Adopts</a> page";
                        }
                    }
                }
                else{
                    
// We cannot rename a frozen adoptable...

                    
$article_title $lang_frozen_title;
                    
$article_content "{$lang_frozen}<a href='myadopts.php?act=freeze&id={$id}&more=unfreeze'>unfreeze</a> {$lang_frozen2}";
                }
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist_text;
            }
        }
        else{
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
    }
    elseif(
$act == "trade"){
        
// We are setting the trade status for an adoptable...

        
if(is_numeric($id)){
            
// Now we see if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            if(
$row->aid == $id){
                
$image getcurrentimage($id); // Get the image for the adopt...

                
if($more == ""){
                    
$article_title "Setting trade status for {$row->name}";
                    
$article_content "Are you sure you wish to change the trade status of this adoptable?
                                        <center><b><a href='stable.php?act=trade&id=
{$id}&more=confirm'>Yes I'd like to change its trade status</a></b><br /><br />
                                        <b><a href='stable.php'>Nope I change my mind! Go back to the previous page.</a></b></center><br />"
;
                }
                elseif(
$more == "confirm"){             
                    
$article_title "Change trade status successfully";
                    if(
$row->tradestatus == "fortrade"){
                        
$adopts->update("owned_adoptables", array("tradestatus" => 'notfortrade'), "aid='{$id}' and owner='{$loggedinname}'");
                        
$article_content "The adoptable's trade status is now Not for Trade";
                    }                
                    elseif(
$row->tradestatus == "notfortrade"){
                        
$adopts->update("owned_adoptables", array("tradestatus" => 'fortrade'), "aid='{$id}' and owner='{$loggedinname}'");
                        
$article_content "The adoptable's trade status is now For Trade";
                    }
                    else{
                        
$article_title "Something is very very wrong";
                        
$article_content "Please check phpmyadmin to see if the settings are correct, or report your issue to Mysidia Adoptables support forum";
                    }
                }
                else{
                    
$article_title "Invalid Action";
                    
$article_content "Invalid Action Specified";
                }
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist;
            }
        }
        else{
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
    }
    elseif(
$act == "freeze"){
        
// We are freezing an adoptable here...

        
if(is_numeric($id)){
            
// Now we see if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            if(
$row->aid == $id){
            
                
$image getcurrentimage($id); // Get the image for the adopt...
                
if($more == ""){
                    if(
$row->isfrozen == "yes"){
                        
$status "<img src='templates/icons/freeze.gif'> Frozen<br />";
                        
$go "<a href='stable.php?act=freeze&id={$id}&more=unfreeze'><img src='templates/icons/unfreeze.gif' border=0> Unfreeze This Adoptable</a>";
                    }
                    else{
                        
$status "<img src='templates/icons/unfreeze.gif'> Not Frozen<br />";
                        
$go "<a href='stable.php?act=freeze&id={$id}&more=freeze'><img src='templates/icons/freeze.gif' border=0> Freeze This Adoptable</a>";
                    }

                    
$article_title $lang_freeze_title;
                    
$article_content "<img src='{$image}'><br /><b>{$row->name}'s Current Status: {$status}</b><br />
                                        
{$lang_freeze}<br /><br /><b>{$go}</b><br /><br />
                                        
{$lang_freeze_warning}";
                }
                else{
                    
// We are actually freezing or unfreezing the adopt...

                    
if($more == "freeze"){
                        
$frz "yes";
                        
$article_title "{$row->name} Frozen Successfully";
                    }
                    elseif(
$more == "unfreeze"){
                        
$frz "no";
                        
$article_title "{$row->name} Unfrozen Successfully";
                    }

                    
$adopts->update("owned_adoptables", array("isfrozen" => $frz), "aid='{$id}' and owner='{$loggedinname}'");
                    
$article_content "Action Complete. You may now manage {$row->name} on the <a href='myadopts.php?act=manage&id={$id}'>My Adopts</a> page";
                }
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist_text;
            }
        }
        else
        {
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
    }
    elseif(
$act == "pound"){
        if(
is_numeric($id)){
        
            
// Now we see if the adoptable actually exists...
            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            if(
$row->aid == $id){
                
$image getcurrentimage($id); // Get the image for the adopt...
                
if($more == ""){
                    
$article_title "Pound {$row->name}";
                    
$article_content "<img src='{$image}'><br />{$lang_pound}<br /><br />{$lang_pound_warning}<br /><br />
                                        <center><b><a href='stable.php?act=pound&id=
{$id}&more=confirm'>
                                        <img src='templates/icons/delete.gif' border=0> Pound 
{$row->name} - I dont want it anymore! 
                                        <img src='templates/icons/delete.gif' border=0></a></b><br /><br />
                                        <b><a href='myadopts.php'><img src='templates/icons/yes.gif' border=0> 
                                        DO NOT Pound 
{$row->name}! <img src='templates/icons/yes.gif' border=0></a></b></center><br />";
                }
                elseif(
$more == "confirm"){
                    
// Validate the pet can be pounded
                    
$adopt = new Pound($row->aid"pound");
                    if(
$adopt->settings->system->active == "no"){
                          
$article_title "Invalid Action";
                       
$article_content "The admin has turned off pound feature, please contact him/her for further explanation.";                    
                    }
                    elseif(
$adopt->validate() == TRUE){
                       
$adopt->dopound();
                       
$article_title $lang_pound_title_complete;
                       
$article_content $adopt->message;
                    }
                    else{
                       
$article_title "An error has occurred";
                       
$article_content $adopt->message;     
                    }
                }
                else{
                    
$article_title "Invalid Action";
                    
$article_content "Invalid Action Specified";
                }
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist_text;
            }
        }
        else{
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
    }
    elseif(
$act == "group"){ 
            if(
is_numeric($id)){ 
            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();     
            
$petname $row->name
            if(
$row->aid == $id){ 
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject(); 
        
$article_title "Group {$row->name}"
         if(
$row->group == 0){ 
        
$article_content "{$row->name} is not in a group. "
         } 
         else{ 
         
$groupname $row->group
         
$row $adopts->select("pet_groups", array(), "user='{$loggedinname}' and id='{$groupname}'")->fetchObject(); 
         
$groupname $row->name
         
$article_content "{$petname} is in the group '{$groupname}'."
         } 
      
$article_content .= "Select a group to move {$petname} into:<br><br>"
$stmt $adopts->select("pet_groups", array(), "user='{$loggedinname}'"); 
while(
$row $stmt->fetchObject()) { 
  
$groupid=$row->id
  
$name=$row->name
  
$groups .= "<option value='{$groupid}'>{$name}</option>"


$article_content .= "  <form name='form' method='get' action='myadopts.php?'> 
<input name='id' type='hidden' id='id' value='
{$id}'> 
<input name='act' type='hidden' id='act' value='changegroup'> 
    <select name='group' id='group'> 
      <option value='none' selected> </option> 
    
{$groups}
    </select><br> 
 <input type='submit' name='submit' value='Move'> 
    </form>"

           } 
     } 

elseif(
$act == "changegroup"){ 
  if(
$submit == "Move"){ 
        
$row $adopts->select("pet_groups", array(), "user='{$loggedinname}' and id='{$group}'")->fetchObject();     
    if(
$row->id == $group and $row->user == $loggedinname){ 
        
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();     
        if(
$row->aid == $id){ 
         
$adopts->update("owned_adoptables", array("group" => $group), "aid='{$id}' and owner='{$loggedinname}'"); 
            
$article_title "Moved {$row->name}"
                        
$article_content "{$row->name} was moved to a new group.<br><br> 
                        <a href='myadopts.php?group=
{$group}'>Check out the new group</a>"
        } 
        else{ 
        
$article_title "No pet"
                
$article_content "This pet doesn't exist."
        } 
    } 
    else{ 
    
$article_title "No group"
        
$article_content "This group doesn't exist."
    } 
  } 
  else{ 
  
$article_title ""
  
$article_content ""
  } 

elseif(
$act == "creategroup"){
 if(
$groupname == ""){
          
$count $GLOBALS['adopts']->select("pet_groups", array(), "user='{$loggedinname}'")->fetchAll();
        if(
count($count) > 4) {
        
$article_title "Sorry";
        
$article_content "You can only have 5 groups. <br><br>
        <a href='myadopts.php'>Go back</a>"
;
        }
else{
 
$article_title "Create a new group";
 
$article_content "
 <form name='form1' method='post' action='myadopts.php?act=creategroup'>
<b>Group Name:</b> <br>
Max length is 15.<br>
<input name='groupname' type='text' id='groupname' maxlength='15' /><br>
<input type='submit' name='submit' value='Create'>
</form>"
;
}
 }
 else{
         
$count $GLOBALS['adopts']->select("pet_groups", array(), "user='{$loggedinname}'")->fetchAll();
        if(
count($count) > 4) {
        
$article_title "Sorry";
        
$article_content "You can only have 5 groups. <br><br>
        <a href='stable.php'>Go back to your stable</a>"
;
        }
        else{
$adopts->insert("pet_groups", array("id" => NULL"user" => $loggedinname"name" => $groupname));
$group $adopts->select("pet_groups", array(), "name='{$groupname}' and user='{$loggedinname}'")->fetchObject();    
$id $group->id;
$article_title "Created group '{$groupname}'";
$article_content "You created a new group called '{$groupname}'.<br><br>
<a href='myadopts.php?group=
{$id}'>Visit it now</a><br><br>
<a href='myadopts.php'>Go back</a>"
;
        }
 }
}
    else{ 
        
// No valid action specified :: show an error 

        
$article_title $lang_invalid_action_title
        
$article_content $lang_invalid_action
    } 

else 


    
$article_title $accden
    
$article_content $reqlogin

// End is logged in check else 


//***************// 
//  OUTPUT PAGE  // 
//***************// 

echo showpage($article_title$article_content$date); 

?>
4. Done
That is it! :) I hope it works for you.

Last edited by StarGirl; 06-08-2012 at 03:18 PM.
Reply With Quote
  #2  
Old 05-05-2012, 07:36 AM
MaximumRide's Avatar
MaximumRide MaximumRide is offline
THROW THE CHEESE!!
 
Join Date: Apr 2012
Location: Somewhere far away
Posts: 181
Gender: Female
Credits: 4,724
MaximumRide is on a distinguished road
Default

Well when I make the group in php my admin, it wants me fill out....

Field Type Length/Values1 Collation Attributes Null Default2 Extra --- Comments
__________________
Please click these :3
Reply With Quote
  #3  
Old 05-05-2012, 08:48 AM
StarGirl's Avatar
StarGirl StarGirl is offline
Member
 
Join Date: Feb 2012
Posts: 45
Gender: Female
Credits: 1,907
StarGirl is on a distinguished road
Default

Quote:
Originally Posted by MaximumRide View Post
Well when I make the group in php my admin, it wants me fill out....

Field Type Length/Values1 Collation Attributes Null Default2 Extra --- Comments
That should be right. (Did you remember to type in 3 columns, not 1?) Then just copy everything from the screenshot.
Reply With Quote
  #4  
Old 05-05-2012, 09:04 AM
MaximumRide's Avatar
MaximumRide MaximumRide is offline
THROW THE CHEESE!!
 
Join Date: Apr 2012
Location: Somewhere far away
Posts: 181
Gender: Female
Credits: 4,724
MaximumRide is on a distinguished road
Default

Oh ok is "File Type" like "Column?"
__________________
Please click these :3
Reply With Quote
  #5  
Old 05-05-2012, 09:12 AM
Aasixx's Avatar
Aasixx Aasixx is offline
.. your friendly geek. c:
 
Join Date: Nov 2011
Location: somewhere ur not.
Posts: 191
Gender: Female
Credits: 12,080
Aasixx is on a distinguished road
Default

Okay, when I'm at the "owned_adoptables" table and I'm trying to click "At End of Table" then go search for id, but when I click the dropdown menu, it for some reason goes back to "After".. plus, id isn't even on the dropdown menu. Did I do something wrong? Also, another thing, id isn't even listed in Structure on my "owned_adoptables"

And where do I go to edit files? Sorry, this is my first time installing a mod. :T
__________________

Last edited by Aasixx; 05-05-2012 at 09:27 AM.
Reply With Quote
  #6  
Old 05-05-2012, 09:56 AM
StarGirl's Avatar
StarGirl StarGirl is offline
Member
 
Join Date: Feb 2012
Posts: 45
Gender: Female
Credits: 1,907
StarGirl is on a distinguished road
Default

Quote:
Originally Posted by Aasixx View Post
Okay, when I'm at the "owned_adoptables" table and I'm trying to click "At End of Table" then go search for id, but when I click the dropdown menu, it for some reason goes back to "After".. plus, id isn't even on the dropdown menu. Did I do something wrong? Also, another thing, id isn't even listed in Structure on my "owned_adoptables"

And where do I go to edit files? Sorry, this is my first time installing a mod. :T
I don't know.. you should be at the "owned_adoptables" table, at the structure tab, and near the bottom should be what you're looking for. And I don't think it matters if you put it at the end of the table or not - I'd prefer it there though. Just simply press the go button, you don't need to change any details until the new window pops up. :3

And you go to file manager to edit files. Then navigate to public_html if not already, and find the files you need to edit. :3
Reply With Quote
  #7  
Old 05-05-2012, 10:10 AM
Aasixx's Avatar
Aasixx Aasixx is offline
.. your friendly geek. c:
 
Join Date: Nov 2011
Location: somewhere ur not.
Posts: 191
Gender: Female
Credits: 12,080
Aasixx is on a distinguished road
Default

One more question and then I'll leave you alone. :3
Where do I need to put the attached files after downloading them?
__________________
Reply With Quote
  #8  
Old 05-05-2012, 10:10 AM
StarGirl's Avatar
StarGirl StarGirl is offline
Member
 
Join Date: Feb 2012
Posts: 45
Gender: Female
Credits: 1,907
StarGirl is on a distinguished road
Default

Quote:
Originally Posted by MaximumRide View Post
Oh ok is "File Type" like "Column?"
I don't know what you mean, but I don't think so :P Here are more detailed instructions. Open PhpMyAdmin, it should look something like:

Now find and click on your database. Mine is called 'myxiplan_database', yours will be something different. It should bring you to a list of your tables..

My prefix is myxipets_. :P Now open the operations tab, and follow these directions:

Now fill in the details with what is shown in the screenshot and press go.

There you go. :P Now you go from step 2.
Reply With Quote
  #9  
Old 05-05-2012, 10:11 AM
StarGirl's Avatar
StarGirl StarGirl is offline
Member
 
Join Date: Feb 2012
Posts: 45
Gender: Female
Credits: 1,907
StarGirl is on a distinguished road
Default

Quote:
Originally Posted by Aasixx View Post
One more question and then I'll leave you alone. :3
Where do I need to put the attached files after downloading them?
Just leave them in public_html, where the rest of the files are. :)
Reply With Quote
  #10  
Old 05-05-2012, 10:15 AM
Aasixx's Avatar
Aasixx Aasixx is offline
.. your friendly geek. c:
 
Join Date: Nov 2011
Location: somewhere ur not.
Posts: 191
Gender: Female
Credits: 12,080
Aasixx is on a distinguished road
Default

When you say "leave them in public_html" do you mean create a new file for each one? So, like for "creategroup" after I downloaded and opened it, it gave me this code:

Code:
<?php

include("functions/functions.php");
include("functions/functions_users.php");
include("functions/functions_adopts.php");
include("inc/lang.php");

//***************//
//  START SCRIPT //
//***************//

$name = $_GET["name"];
$submit = $_GET["submit"];

if($isloggedin == "yes"){
if($submit == "Create"){
		$count = $GLOBALS['adopts']->select("pet_groups", array(), "user='{$loggedinname}'")->fetchAll();
		if(count($count) > 4) {
		$article_title = "Sorry";
		$article_content = "You have too many groups. <br><br>
		<a href='mygroups.php'>Go back to the group center</a>";
		}
		else{
		// Create group!
                $adopts->insert("pet_groups", array("id" => NULL, "user" => $loggedinname, "name" => $name));
                $group = $adopts->select("pet_groups", array(), "name='{$name}' and user='{$loggedinname}'")->fetchObject();	
                $id = $group->id;
        $article_title = "New Group!";
	$article_content = "You have just created a new group - {$name}!<br><br>
	<a href='groups.php?id={$id}'>Click here to see it.</a>";
		}
}
		else{
	$article_title = "";
	$article_content = "";
		}
} // End the log in check IF
else {
	$article_title = "Login";
	$article_content = "You must login to create a group.";
} // End the log in check ELSE 

//***************//
//  OUTPUT PAGE  //
//***************//

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

?>
Would I need to create a new file and put that code in it for creategroup?
__________________
Reply With Quote
Reply

Thread Tools
Display Modes

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
What age group do you belong to? Hall of Famer Other Chat 19 09-28-2017 08:37 AM
1.3.4 - group sort draugluin Questions and Supports 6 01-16-2017 01:02 PM
sort adoptables Blackmagic Questions and Supports 3 12-01-2009 04:05 PM
group zhiichiro Questions and Supports 7 05-30-2009 07:21 PM
Adding new user group mugwumpr Questions and Supports 2 04-19-2009 07:02 PM


All times are GMT -5. The time now is 02:03 AM.

Currently Active Users: 194 (2 members and 192 guests)
Threads: 3,931, Posts: 31,325, Members: 15,516
Welcome to our newest members, Nicholas Adam.
BER





What's New?

What's Hot?

What's Popular?


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