View Single Post
  #4  
Old 08-08-2008, 01:53 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Run the following query and copy-paste the output here. Also check the links in the previous post:
Code:
EXPLAIN SELECT id,img,views,url,type,trackviews,trackhits,html,frequency,title,height,width,catid,templatetype
FROM GAB_ads
WHERE isactive = 1 AND (scripts = '||' OR scripts = '' OR scripts LIKE '%|showthread|%')
AND (forums LIKE '%|7|%' OR forums = '' OR forums = '||')  AND (startdate<9000 || startdate<1218144914) AND (enddate<9000 || enddate>1218144914);
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote