www.lesmahagow.com
Lesmahagow Mailing List
Join our mailing list and we will give updates.
"putting Lesmahagow on the Map !"
| Lesmahagow Telephone and Business Directory Listings & Search | |||||||||||||||||||||||||
| Directory Home | Directory Statistics | Advanced Search | Submit/Update URL |
Script Features - v2.0:
- Many resources categories and descriptions for those categories
- Advance search capabilities with highlighting the search keyword
- Some resources related statistics (hits, new added, new updated, hot)
- Many resources sorting options
- Evaluation sites by visitors; one evaluation per one email
- Reporting Broken Links
- Ability to determine whether the submitted site is an update or a new adding; and leaving the final decision for you
- Ability to mark some resources as special ones
- Mass mails for web site submitters
- Available Advices for using MSSQL or MS Access inside codes; and for better performance
For Previous Version Users:
Most files has been changed (hopefully for better). So the old files should be replaced by the new one. You might lose then any modifications you did in design. As for database, we did the following changes:
- We added a new table: TD_EvalSUsers for evaluation matter
- TD_CategoryTbl table: We added a new memo (ntext) field "EnglishDetails" to work as a description for the category
- TD_SourcesTbl table: We added the following fields:
|
Field Name |
MS Access Data Type |
MS SQL Data Type |
|
VotesNumber |
Number |
int |
|
VotesValue |
Number |
int |
|
EditPrev |
Yes/No |
bit |
|
Special |
Yes/No |
bit |
|
BrokenLink |
Yes/No |
bit |
So for upgrading from previous version to the new one, you have to do the changes mentioned above. If you're using MS Access, you have to do the changes manually. If you're using MS SQL, we provided a script to do the changes (and as usual, we recommend you keep backup before doing any changes). Unfortunately, we didn't get the chance to test this Upgrade SQL Script....
| Directory Home | Directory Statistics | Advanced Search | Submit/Update URL |