Here is what I posted in another thread. If you are working on managing links from a database, the following feature list can be useful. (remember, all links and pages created are static)
To handle the problem of link management, we search and send out emails to webmasters of prospect reciprocal link sites and invite them to fill up a form on our (client) site in order to offer them a reciprocal link. Further, we have developed an online application in-house, which is installed on the client server and it does the following –
1. It has an admin control panel to check all new link requests. The admin can review the link requests data and details.
2. The link request comes in 2 types – people who have made a reciprocal link active before applying (as detailed in the form) or they can choose to activate their link once our side of the link is active.
3. The admin can select the request and ‘Activate’ it or ‘Decline’ it.
4. If the admin selects to activate the link, the application automatically creates a link for the requested party and sends out an email to the partner.
5. If the admin selects to ‘decline’ the request, an email is automatically sent to the link requestor detailing the ‘selected’ reason for decline.
6. The application checks for the live link on the partner site at a frequency set by the admin in the control panel.
7. If the link scan module of the application reports an inactive link on partner site, the application sends an email alert to the admin and the partner requesting the link restoration.
8. If the link is detected to be inactive for consecutive 10 days, the application automatically deletes the partner link from the site and informs the partner.
9. The admin can create multiple template pages and categories from the control panel so that links per page can be limited to desired numbers (this is set from admin control panel) to avoid spammy looking link pages. Each of these categories also automatically appear in the link request submit form.
10. Email alerts and triggers are set on almost all possible events to keep the admin and the partner informed. The system generates periodic reports for admin to give details of new link requests, total live links, total inactive links, category wise listing etc.
11. The admin also has an emailing interface to send customized email to the active or inactive partner members or on partial list selection basis.
Overall, this makes the life of the admin (webmaster) much easier for link management. The major difference of this application with some offline software is that offline software are ‘reactive’ in nature – you need to operate and baby-site them to use them. Whereas, our application is ‘proactive’ which means it does its task 24 hours a day without any ‘running’ required – all from the client server and also keeps the webmaster up to date with the status. He does not need to be online on limited bandwidth to make this work. Also, the features of application are much more powerful than offline software.
We have currently developed this in Windows-ASP-Flat-file system so that it can work even on servers not having SQL2000. Other versions on Linux-PHP-MySQL and ASP-MSSQL are under development.
The above can be a good guide of features for someone who wants to develop this application in-house.