Web Links Problem (v6.5) : Add Link Page

gcheers · **Web Links Problem (v6.5) : Add Link Page -** 05-01-2003, 04:38 AM

Hi there,

I've successfully installed v6.5, all seems to be going very well apart from one very small but annoying problem with Web Links.

If I add a Category called 'Advertising'
then a second Category called 'Marketing'

then a sub category of 'Advertising' called 'Free'

When the pulldown menu on the 'Add link' page populates it populates like so:

<option>Advertising
<option>Marketing
<option>Advertising/Free

How can I tweak this so that the pulldown menu sorts alphabetically and not by the order in which they all went into the database.

virtual beer to all that can offer any help

Thanx

chatserv · 05-01-2003, 09:30 AM

In admin/modules/links change line 157 from:

Code:

        $result2=sql_query("select cid, title, parentid from ".$prefix."_links_categories order by title", $dbi);

to:

Code:

        $result2=sql_query("select cid, title, parentid from ".$prefix."_links_categories order by title ASC", $dbi);

You could also run a search and replace in that file, search for:

Code:

order by title"

replace with:

Code:

order by title ASC"

gcheers · 05-01-2003, 12:11 PM

Won't this only work for the Admin area?
For the front end I have found a line (162) in
/modules/Web_Links/index.php

Code:

    	
$result2=sql_query("select cid, title, parentid from ".$prefix."_links_categories order by parentid,title", $dbi);
    while(list($cid2, $ctitle2, $parentid2) = sql_fetch_row($result2, $dbi)) {
    		if ($parentid2!=0) $ctitle2=getparent($parentid2,$ctitle2);
    	    echo "<option value=\"$cid2\">$ctitle2</option>";

changing

Code:

parentid,title

to

Code:

parentid, title ASC

doesn't appear to work?

chatserv · 05-01-2003, 12:21 PM

Yes it was meant for the admin section, if it's your site (and i assume it is since you're editing files) you would add links through the admin section and not submit them like normal users do so your categories would be listed in alphabetical order like you wanted.

gcheers · 05-01-2003, 12:28 PM

I am providing ALL visitors to the site with the ability to add links to the Web Links directory.

I think I might just stick to several top-level categories rather than sub-categories, might make things easier!

Just looks a bit messy when the pulldown menu populates as:

Affiliate Programs
Marketing
Affiliate Programs/Pay-per-Click
Web Design
Marketing/Site Submission
Affiliate Programs/Pay-per-Sale

etc....