The vB Geek

Go Back   The vB Geek > vB Geek Modifications > Add-ons

Add-ons Modifications and add-ons for vB Geek stuff.

Advertisement
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Comment
 
Release Tools Display Modes
 
Old 05-10-2006, 07:00 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
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 vba CMPS GARS block

This is just a quick vba Module I threw together to try and please the 'Damnit - come up with vba support' people.

This will create 3 different layouts depending on the modules...

Last edited by The Geek; 04-14-2007 at 11:53 AM..
Reply With Quote
  #20  
By gothic on 05-12-2006, 08:26 AM
Default

tgreer, thanks for the input. I ended up reducing the spanned columns to two which corrected the display problem I had within IE.
Reply With Quote
  #21  
By Lygren on 05-12-2006, 08:02 PM
Default

I ended up un-installing the Beta 2.0, it simply didn't work.

I am therefore using the 1.01 version.

Now the display is excellent on the frontpage, but I currently have an issue, though;

Unable to add cookies, header already sent.
File: /var/www/htdocs/avforum.com/forum/modules/gars.php
Line: 113

Is appearing each time I open a forum with GARS activated.

Any ideas?
Reply With Quote
  #22  
By Lygren on 05-12-2006, 08:18 PM
Default

OK, when choosing "YES" to cleaning file output the above error is gone, but no articles are appearing on the front-page...

In addition, I get an error when choosing any other order than random...

Anyone?
Reply With Quote
  #23  
By Lygren on 05-12-2006, 08:48 PM
Default

The problem seems to be that this module is not restricted to only the vBa front-page, but also the forum... In addition to the error message: Unable to add cookies, header already sent.
File: /var/www/htdocs/avforum.com/forum/modules/gars.php
Line: 113

...the rest of the layout is identical to the frontpage, or the settings applied on the gars.php file.
Reply With Quote
  #24  
By gothic on 05-12-2006, 08:50 PM
Default

Quote:
Originally Posted by Lygren

In addition, I get an error when choosing any other order than random...

Anyone?
I used THIS from above to sort the sorting, worked for me.
Find the code in the gars.php file.
Reply With Quote
  #25  
By Lygren on 05-12-2006, 09:06 PM
Default

Well, changing this get me:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT g.threadid,g.header_image image, p.title, g.byline, IF(g.synopsis, g.synopsis, p.pagetext) synopsis ,round((g.overall_rating/10),0) author_rating, g.overall_rating author_rating_percent,round((g.avg_rating/10),0) member_rating, g.avg_rating member_rating_percent ,g.pagecount, g.custom2 FROM
bb_gars g

INNER JOIN bb_thread t ON g.threadid = t.threadid
INNER JOIN bb_post p ON t.firstpostid = p.postid
WHERE t.visible = 1 AND t.open != 10
AND t.forumid in (67,68,69)

ORDER BY g.threadid RAND() LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RAND() LIMIT 5' at line 9
Error Number : 1064
Date : Friday, May 12th 2006 @ 11:06:58 PM
Script : http://avforum.com/
Referrer :
IP Address : 85.166.26.160
Username : lygren
Classname : vb_database
Reply With Quote
  #26  
By smo on 05-12-2006, 10:14 PM
Default

Quote:
Originally Posted by Lygren
OK, when choosing "YES" to cleaning file output the above error is gone, but no articles are appearing on the front-page...

In addition, I get an error when choosing any other order than random...

Anyone?
I did what you did and I too have no article.

I was getting a white page of death before.
Reply With Quote
  #27  
By The Geek on 05-13-2006, 07:54 AM
Default

DO you guys have vbacmps running on all pages?
Reply With Quote
  #28  
By Lygren on 05-13-2006, 05:20 PM
Default

Yes, I believe vba is used as a frame on all our pages, including the forum.
Reply With Quote
  #29  
By gothic on 05-13-2006, 06:34 PM
Default

Quote:
Originally Posted by Lygren
Yes, I believe vba is used as a frame on all our pages, including the forum.
Only if you install THIS hack
Reply With Quote
Comment

Release Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Release Release Starter Category Comments Last Post
Who wants a GARS module for vBa CMPS? (vB 3.7+) daisukem Geek Article and Review System 4 08-21-2009 09:37 AM
how to make Top 5 Articles block show up on frontpage (vbA CMPS) beowulf68 Geek Article and Review System 1 02-23-2008 10:29 AM
GARS / Links vBA block gothic Geek Article and Review System 1 09-24-2006 10:07 AM
GARS + vBA CMPS SoloX Geek Article and Review System 9 07-15-2006 04:51 AM
Yet Another GARS and vBA CMPS thread... tgreer Geek Article and Review System 20 04-27-2006 07:17 PM


All times are GMT. The time now is 05:13 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

Release powered by GARS 2.1.9 ©2005-2006