Hopefully this works for you. Here's the code:
Code:
admin/new.php
-add form variable
line 33: add $catsort = $_REQUEST['catsort'];
-change sql insert to include catsort
line 71: change $database->setQuery("INSERT INTO mos_zoom (catname,catdescr,catdir,catpassword,catkeywords,subcat_id,pos,hideMsg,shared,published,uid,catmembe rs,catsort) VALUES ('".mysql_escape_string($catname)."','".mysql_escape_string($catdescr)."','".mysql_escape_string($mkdir)."','".mysql_escape_string($catpass)."','".mysql_escape_string($keywords)."','$after','$pos', '$hidemsg','$shared','$published','$uid','$selections','$catsort')");
-update the form to include catsort (where ever you want to appear)
<tr>
<td>Sort Order:</td><td><input class="inputbox" type="text" name="catsort" value="" size="3"></td>
</tr>
admin/editcat.php
-add form variable
line 32: $catsort = $_REQUEST['catsort'];
-change sql update to include catsort
line 49: $database->setQuery("UPDATE mos_zoom SET catname='".mysql_escape_string($newname)."', catdescr='".mysql_escape_string($newdescr)."', catpassword='".mysql_escape_string($catpass)."', catkeywords='".mysql_escape_string($keywords)."', hideMsg='$hidemsg', shared = '$shared', published='$published', catmembers='$selections', catsort='$catsort' WHERE catid=".mysql_escape_string($catid));
-update form to include catsort
<tr>
<td align="left">Sort Order:</td><td><input class="inputbox" type="text" name="catsort" value="<? echo $zoom->_gallery->_catsort;?>" size="3"></td>
</tr>
classes/gallery.class.php
-add between lines 25 & 43
var $_catsort = null;
-updated function getInfo
global $database;
$database->setQuery("SELECT catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, hideMsg, shared, published, uid, catmembers, catsort FROM mos_zoom WHERE catid=".mysql_escape_string($this->_id)." LIMIT 1");
$this->_result = $database->query();
while($row = mysql_fetch_object($this->_result)){
$this->_name = stripslashes($row->catname);
$this->_descr = stripslashes($row->catdescr);
$this->_dir = $row->catdir;
$this->_cat_img = $row->catimg;
$this->_subcat_id = $row->subcat_id;
$this->_password = $row->catpassword;
$this->_pos = $row->pos;
$this->_hideMsg = $row->hideMsg;
$this->_shared = $row->shared;
$this->_published = $row->published;
$this->_uid = $row->uid;
$this->_catsort = $row->catsort;
$members = explode(",", $row->catmembers);
// gallery-members of type 1 are of access-level 'public'
// and members of type 2 are 'registered'.
if(in_array("1", $members))
$this->_members[0] = 1;
elseif(in_array("2", $members))
$this->_members[0] = 2;
else
&nb sp;$this->_members = $members;
}
-update function getSubCats, add ORDER BY for sort
$database->setQuery("SELECT catid FROM mos_zoom WHERE subcat_id=".mysql_escape_string($this->_id)." ORDER BY catsort ASC");
/galleryshow.php
-update select
line 62:
if($zoom->_isAdmin)
$database->setQuery("SELECT catid FROM mos_zoom WHERE subcat_id=0 AND pos=0 ORDER BY catsort");
else
&n bsp; $database->setQuery("SELECT catid FROM mos_zoom WHERE subcat_id=0 AND pos=0 AND published=1 ORDER BY catsort");
Lesezeichen