bruleo
11-12-2010, 02:40 AM
Mod Title: [MOD] Directory Report
Last Updated: 12 November 2010
Supported by Mod Developer: Yes
Where to Download: PM Me
Support Via This Thread or Download Site: At bruleo.com/forum
Compatible With: 3.2 / 3.3 / 3.4 / 4.0 / 4.1 / 4.2
DESCRIPTION:
Generates a directory report contain information relating to directory settings, statistics and problems. The following information is currently reported (where available):
Active Links.
Inactive Links
Pending Links
Featured Links
Unconfirmed Links **
Active Articles *
Inactive Articles *
Pending Articles *
Featured Articles *
Unconfirmed Articles * **
Active Main Categories
Active Sub-categories
Pending Categories
Symbolic Categories
Inactive Categories
Registered Members
Confirmed Members **
Unconfirmed members **
Recorded Payment Totals for various Periods.
Links about to expire (Requested Frequently!)
Duplicate link listings by URL
Duplicate link listings by TITLE
Articles about to expire
Banned IP Addresses
Banned Email Addresses
Banned Domains
Banned Words
Link Sequence Table Status
Article Sequence table Status
Category Sequence Table Status
User Sequence Table Status
Payment Sequence Table Status
Tables with over 10% OverHead
HIT Table size report.
Database Uptime Report
Total DB Queries Since uptime report.
Datavase table error status.
Locked Tables report.
Report creation time.
* Not available below 3.3
** Not available below 3.4
All report items can be switched on or off in admin. Other configuration options availavle.
Option to send automaticall generated reports to two recipients.
Job can be run manually or set up by CRON to run at regular times.
Settings enable you to set recipient and copy recipients name and email address, as well as turn individual reporting items on or off, as well as set a duration to report on expiring listings.
BENEFITS OF USE:
> Can help prevent data loss with the regular reporting of sequence tables
> Can help prevent slow database / website response with the reporting of HITS table size and Table Overhead.
COMPATIBILITY:
phpLD versions 3.2 / 3.3 / 3.4 / 4.0 / 4.1 / 4.2
PRICE:
Self Install : $8.00
Fully installed including CRON setup : $20.00
Report items will hopefully be added on a regular basis, so if you have any suggestions as to what you like to see added, let me know.
NOTES ABOUT VARIOUS REPORTS:
If your report states messages about your database, then you may need to consider the following:
a) HITS_TABLE size: Consider emptying that table. It is perfectly safe to to so, as long as you empty ONLY that table. It only effectively stores temporary HITS data to prevent multiple tracking of visits from the same IP in any 24 hour period. When that table gets to big, it can slow your database down significantly, especially on shared and budget hosting accounts.
b) SEQUENCE WARNINGS: If you get this error, it can be very serious for your data. This will usually occur if you have imported listings and/or made manual changes to your database. If your sequence table value is lower than the value of your highest link ID, you could be losing data everytime a new listing is submitted. To prevent further data loss, you should ensure that your sequence table value is set higher than or equal to the highest value in the equeivelent data table. For example: (PLD_LINK_SEQ value should be equal or higher than the highest ID in PLD_LINK). You can do this manually in your database, or check in the phpLD forums for a query to run.
c) OVERHEAD: This is effectively fragmented space in your database that in itself is not a major issue, but when it gets to large, it can slow database processing. If the report warns you of this, it means the listed tables are over 10% fragmented and is advisable that you log into your database via phpMyAdmin and optimize those tables.
d) CRASHED TABLES: Depending on your hosting, this can either result on some of your site not working, or the whole of site being made unavailable. A crashed table is often not as serious as it sounds and can usually be corrected by selecting the table in phpMyAdmin and choosing the 'repair' option.
Last Updated: 12 November 2010
Supported by Mod Developer: Yes
Where to Download: PM Me
Support Via This Thread or Download Site: At bruleo.com/forum
Compatible With: 3.2 / 3.3 / 3.4 / 4.0 / 4.1 / 4.2
DESCRIPTION:
Generates a directory report contain information relating to directory settings, statistics and problems. The following information is currently reported (where available):
Active Links.
Inactive Links
Pending Links
Featured Links
Unconfirmed Links **
Active Articles *
Inactive Articles *
Pending Articles *
Featured Articles *
Unconfirmed Articles * **
Active Main Categories
Active Sub-categories
Pending Categories
Symbolic Categories
Inactive Categories
Registered Members
Confirmed Members **
Unconfirmed members **
Recorded Payment Totals for various Periods.
Links about to expire (Requested Frequently!)
Duplicate link listings by URL
Duplicate link listings by TITLE
Articles about to expire
Banned IP Addresses
Banned Email Addresses
Banned Domains
Banned Words
Link Sequence Table Status
Article Sequence table Status
Category Sequence Table Status
User Sequence Table Status
Payment Sequence Table Status
Tables with over 10% OverHead
HIT Table size report.
Database Uptime Report
Total DB Queries Since uptime report.
Datavase table error status.
Locked Tables report.
Report creation time.
* Not available below 3.3
** Not available below 3.4
All report items can be switched on or off in admin. Other configuration options availavle.
Option to send automaticall generated reports to two recipients.
Job can be run manually or set up by CRON to run at regular times.
Settings enable you to set recipient and copy recipients name and email address, as well as turn individual reporting items on or off, as well as set a duration to report on expiring listings.
BENEFITS OF USE:
> Can help prevent data loss with the regular reporting of sequence tables
> Can help prevent slow database / website response with the reporting of HITS table size and Table Overhead.
COMPATIBILITY:
phpLD versions 3.2 / 3.3 / 3.4 / 4.0 / 4.1 / 4.2
PRICE:
Self Install : $8.00
Fully installed including CRON setup : $20.00
Report items will hopefully be added on a regular basis, so if you have any suggestions as to what you like to see added, let me know.
NOTES ABOUT VARIOUS REPORTS:
If your report states messages about your database, then you may need to consider the following:
a) HITS_TABLE size: Consider emptying that table. It is perfectly safe to to so, as long as you empty ONLY that table. It only effectively stores temporary HITS data to prevent multiple tracking of visits from the same IP in any 24 hour period. When that table gets to big, it can slow your database down significantly, especially on shared and budget hosting accounts.
b) SEQUENCE WARNINGS: If you get this error, it can be very serious for your data. This will usually occur if you have imported listings and/or made manual changes to your database. If your sequence table value is lower than the value of your highest link ID, you could be losing data everytime a new listing is submitted. To prevent further data loss, you should ensure that your sequence table value is set higher than or equal to the highest value in the equeivelent data table. For example: (PLD_LINK_SEQ value should be equal or higher than the highest ID in PLD_LINK). You can do this manually in your database, or check in the phpLD forums for a query to run.
c) OVERHEAD: This is effectively fragmented space in your database that in itself is not a major issue, but when it gets to large, it can slow database processing. If the report warns you of this, it means the listed tables are over 10% fragmented and is advisable that you log into your database via phpMyAdmin and optimize those tables.
d) CRASHED TABLES: Depending on your hosting, this can either result on some of your site not working, or the whole of site being made unavailable. A crashed table is often not as serious as it sounds and can usually be corrected by selecting the table in phpMyAdmin and choosing the 'repair' option.