WSN Links
Featuresspacer Showcasespacer Reviewsspacer Demosspacer Purchasespacer Manualspacer Support

Register | Forgot Password
Advanced SQL Filtering
Advanced SQL Filtering
By Paul

In your admin panel under settings->miscellaneous, there's an option "Only Show Links Where." This is an advanced option intended for use in rare cases by people somewhat familiar with MySQL.<br /><br />In this field you can supply any MySQL condition, and it will be used inside the "where" clause of the queries which select links. Thus for example if you put "recipurl != ''" in the field, it would effectively prevent any links which lack a reciprocal URL from being shown on your site. <br /><br />This sort of method can on occasion be useful when you're doing multiple installs and want to share most of the content. The WSN manuals are constructed in such a way, so that each WSN script has it's manual at its own separate URL, and yet most of the manual content is shared between all the manuals. This is done by editing the config.php files to use the all the same tables except for the settings tables (the settings table is unique for each manual). Then, in the admin panel of each manual, he "only show links where" setting is filled in with "script LIKE '%WSN Links%'" (this example being for the WSN Links manual). "script" is a custom link field, and for every manual entry there are checkboxes to select which scripts the entry applies to. The end result of this is that all entries which don't apply to the particular manual you're viewing are filtered out so that you don't see them, even though they're in the database.

Rating:


2/5 based on 2 votes. The median rating is 2.

Submitted: 03/22/04 (Edited 03/30/04)

Description: Making use of the 'only show links where' setting.

Views: 1538 views. Averaging 1 per day.
In the most recent 30 day period, there've been 4 views.

Previous Article | Next Article

Home    |    Features    |    Showcase    |    Reviews    |    Demos    |    Purchase    |    Manual    |    Support