With Links SQL 1, I used a mod to flag sites as featured (via a value in a Priority field) and then a Featured Sites page was built (like cool sites, but not based on hits). How would I go about doing this for Links SQL 2?

Also, using similar methods, I previously had in my category template the ability to see if a site was featured (<%if featured%>) and then put that site at the top of ever spanned page in the category. Thus, when building, a site would be checked if featured (i.e. is Priorty > 0?) and then I could call those sites via a <%featured%> tag in my category template. Can anyone lend any insight on how to get this working with Links SQL 2?

Thanks!

Hi,

I'm not on a good machine at the moment, so I'll have to add more later -- but you'd want to add a field to your database, and then create the tag in the globals.txt file (on the build menu).

I'm working on a more robust (slightly) featured site mod to upgrade a couple of sites I had set up under 1.1x.

PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum

Okay, I have the field in the DB... creating the global is all I will need to do... I can see how that might work for featuring sites within categories, but how would I be able to build a separate page that lists all prioritized sites?

Oh yeah, how do I go about creating a global var? I have a field in my Links table that is "Priority." ANything with a value over 1 I want to be featured in categories using an <%if featured%> or something along those lines, and anything greater than 10 should be built to a special "Featued Sites" page, similar to "Cool Sites."

Briefly, you would create a global that was a sub {....} where the sub did a select, and call to display::Link and create the <%featured_category%> tag. You could then insert this.

I don't know enough about performance tuning with this program yet to do it efficiently. This really only needs to be done once per category/subcategory, and not once per template loaded.

Several suggestions have been offered by different people for similar situations.

This is still a realm where Alex reigns king :)

PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum