vba CMPS GARS block - Page 3

05-10-2006, 07:00 PM

The Geek

Senior Member

Join Date: Aug 2005

Posts: 6,717

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...

Click here to read the entire release

Last edited by The Geek; 04-14-2007 at 11:53 AM..

#20

By gothic on 05-12-2006, 08:26 AM

tgreer, thanks for the input. I ended up reducing the spanned columns to two which corrected the display problem I had within IE.

#21

By Lygren on 05-12-2006, 08:02 PM

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?

#22

By Lygren on 05-12-2006, 08:18 PM

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?

#23

By Lygren on 05-12-2006, 08:48 PM

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.

#24

By gothic on 05-12-2006, 08:50 PM

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.

#25

By Lygren on 05-12-2006, 09:06 PM

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

#26

By smo on 05-12-2006, 10:14 PM

Quote:

Originally Posted by Lygren

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

I was getting a white page of death before.

#27

By The Geek on 05-13-2006, 07:54 AM

DO you guys have vbacmps running on all pages?

#28

By Lygren on 05-13-2006, 05:20 PM

Yes, I believe vba is used as a frame on all our pages, including the forum.

#29

By gothic on 05-13-2006, 06:34 PM

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

Page 3 of 47

Last »

« Previous Release | Next Release »

Release Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 Rules

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 01:44 AM.