Guestbook Backend Question

[andyeswecan]

Hey guys....

In the guestbook module, is there any way to limit the amount of entries which appear in the admin area page?

For example, If I could only show 'non-approved' entries in the admin?

I have over 1,000 entries and it makes loading the admin page impossible, as it tries to load every entry into that one area

thanks in advance


Andrew

[deb01]

Hello,

I have checked this in options of guestbook and could not find any option. I think there is no such possibility except fiddling around in PHP code of guestbook module.

[andyeswecan]

Hi thanks for the reply.... I've actually figured it out by changing the SQL query in the modify.php to only display unapproved items...

$query_entries = $database->query("SELECT *, INET_NTOA(`ip_addr`) AS `user_ip` FROM `".TABLE_PREFIX."mod_guestbook` WHERE `section_id` = '$section_id' AND `approved` = '0' ORDER BY position $order ");