02-20-2013, 11:46 PM
Dear All
We made these recent tweaks to our Admin Panel so that recently added members and recently added pages showed first in the dashboard, rather than last. This has greatly speeded up our member/page monitoring and administration, may be useful to other members with busy exchanges.
IMPORTANT
1. Back up the original page first!
2. Use Dreamweaver (better as it has line numbers) or Notepad only for editing, to avoid adding any spurious code - do not use Front Page or WordPad
3. You may have to re-do these tweaks following version updates that replace these pages, but it only takes 5 mins and will save you hours
4. If in doubt - don't do it!
Tweak 1 - Admin Sections - Users
Go to admin-panel/sections/users.php
look for ORDER BY a.id ASC LIMIT around line 433
change to ORDER BY a.id DESC LIMIT
Save file and replace on server
Tweak 2 - Admin Modules
Go to admin-panel/modules/facebook/sites.php
look for ORDER BY `id` ASC LIMIT around line 86
change to ORDER BY `id` DESC LIMIT
Save file and replace on server
Repeat this for other modules sites.php pages as required for your busy exchanges, the line to edit is usually about a quarter way up from the bottom of the page.
PROBLEMS?
Any problems replace the edited file with the original file you backed up earlier.
I hope you find this useful
Steve
We made these recent tweaks to our Admin Panel so that recently added members and recently added pages showed first in the dashboard, rather than last. This has greatly speeded up our member/page monitoring and administration, may be useful to other members with busy exchanges.
IMPORTANT
1. Back up the original page first!
2. Use Dreamweaver (better as it has line numbers) or Notepad only for editing, to avoid adding any spurious code - do not use Front Page or WordPad
3. You may have to re-do these tweaks following version updates that replace these pages, but it only takes 5 mins and will save you hours
4. If in doubt - don't do it!
Tweak 1 - Admin Sections - Users
Go to admin-panel/sections/users.php
look for ORDER BY a.id ASC LIMIT around line 433
change to ORDER BY a.id DESC LIMIT
Save file and replace on server
Tweak 2 - Admin Modules
Go to admin-panel/modules/facebook/sites.php
look for ORDER BY `id` ASC LIMIT around line 86
change to ORDER BY `id` DESC LIMIT
Save file and replace on server
Repeat this for other modules sites.php pages as required for your busy exchanges, the line to edit is usually about a quarter way up from the bottom of the page.
PROBLEMS?
Any problems replace the edited file with the original file you backed up earlier.
I hope you find this useful
Steve