Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
pe5pvb
New Member
New Member


Joined: Oct 16, 2007
Posts: 19

PostPosted: Wed Feb 13, 2008 3:39 pm Reply with quote

Add these lines in the adminblock function in mainfile.php

Code:
   $num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_gcal_event WHERE approved='0'"));

   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=gcalendar\">"._UCALENDAR."</a>: $num<br>";
 
View user's profile Send private message
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Wed Feb 13, 2008 4:12 pm Reply with quote

Well there is actually a slightly more efficient SQL query to make to do that. See the docs in the AddOnFiles/GCalendar area. We were going to add this ourselves but ran out of time.

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Wed Feb 13, 2008 6:11 pm Reply with quote

What we really should do to that waiting content area is stand the logic on it's head. We ought to do all the SQL reads first and see if there is any waiting content, then skip the so-called block if there is not and only present items where there is something waiting if there is. Left block space is precious and having stuff there that never has any data in it is a waste (IMHO). Like on my site there never has been a review and probably never will be so why take up the space. Anybody want to hack at that?
 
View user's profile Send private message Visit poster's website
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Wed Feb 13, 2008 8:46 pm Reply with quote

Not me... I kind of like wasted space... lol...

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©