Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBonjour - Portal System Details »»
vBonjour - Portal System
Version: 1.0.3, by peterska2 peterska2 is offline
Developer Last Online: Nov 2013 Show Printable Version Email this Page

Category: Major Additions - Version: 3.6.4 Rating:
Released: 12-10-2006 Last Update: 01-26-2007 Installs: 119
Uses Plugins Template Edits
Additional Files  
No support by the author.

vBonjour

Easy Customizable Portal System

Brought to you by www.peterska2.co.uk

Welcome to the launch of vBonjour. This is the base package which is required for all installations of this system.

What is vBonjour?
vBonjour is an alternative to vBAdvanced. It is an easy to install, modular portal system designed as a gateway to your site.

Why vBonjour?
This is pretty simple really. As the front page is the first thing that your visitors see, it is a welcome page. The first few names that were thought of were either very boring, or far too long winded and not at all catchy.

This is a base package. What is included?
The base package includes a news feature from up to two forums. The news from the first forum will be displayed first, followed by the news from the second forum. It also includes the left and right columns which can be activated or deactivated via some simple settings in the ACP. These columns can be customised without using any of the Add On Modules, or Add On Modules can be installed to expand on the functionality.

Why is it so modular?
vBonjour is extremely modular to allow for maximum customization of the page. The idea is to make it as easy as possible to install the items that you want to have included, and not have anything which you would be simply turning off. By using a modular method it means that every site can easily achieve their own custom portal without having to know any coding.

I want to add something that isn't already included. How do I go about this?
vBonjour makes use of the plugin system and includes it's own hooks. This allows easy devlopment of additional Add Ons and maximum flexability.

What about the ACP? Is it really complicated?
Unlike other systems, almost all the settings for vBonjour are collected in one setting group in the vBOptions. Because you only install what you want to use, you don't need to have lots of settings. Anything which does not use settings in the Portal settings group is highlighted in the documentation for that Add On.

Ok, so where are the screen shots?
Why have screen shots when you can have a live demo?
The demo is available at www.peterska2.co.uk

What versions of vBulletin does vBonjour work with?
vBonjour will work with vBulletin 3.6.0 and above. Support for sites running versions earlier than 3.6.0 will not be given.



Contributers to the base system: [name]christianb[/name]


I hope that you like this system. Please remember to mark it as installed to recieve notification of updates and support. Support will only be provided to those who have clicked install.


Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #142  
Old 01-25-2007, 09:13 AM
Glynn58 Glynn58 is offline
 
Join Date: Jul 2006
Location: Barnsley UK
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by almac View Post
Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
 
		SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview 
		FROM forum f 
		INNER JOIN thread t ON t.forumid = f.forumid
		LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 82 AND visible = 1
		ORDER BY dateline DESC 
		LIMIT 10;

MySQL Error  : Column 'visible' in where clause is ambiguous
Error Number : 1052
Date         : Monday, January 22nd 2007 @ 01:10:59 AM
Referrer     : 
IP Address   : 72.234.55.40
Username     : Jesse
Classname    : vb_database
Running on:
PHP version 4.4.3
MySQL 4.1.21-standard


And its in my root.
MySQL version 4.1.21-standard
I installed today and got the same error.

Looking at portal.php I could see a difference from Getnews 1 & Getnews 2

Get News 2 looks like this
PHP Code:
if (forumid2) {
    
$getnews2 $db->query_read(
        SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview 
        FROM " 
TABLE_PREFIX "forum f 
        INNER JOIN " 
TABLE_PREFIX "thread t ON t.forumid = f.forumid
        LEFT OUTER JOIN " 
TABLE_PREFIX "post AS post ON post.postid = t.firstpostid WHERE t.forumid = " $forumid2 " AND visible = 1 



the very last bit is the problem
change it to
PHP Code:
t.visible 
That cured this error for me.

However I now have the left sidebox displaying full page width. Then the news items and then the right side box all full width.
Any ideas?
Reply With Quote
  #143  
Old 01-25-2007, 09:44 AM
Glynn58 Glynn58 is offline
 
Join Date: Jul 2006
Location: Barnsley UK
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In the news posts the formatting tags are showing in the posts on the portal page.

http://www.touring-camping.co.uk/forum/portal.php

index.php is still the forum home page at the moment as we don't want it going live until we fix these issues.
Reply With Quote
  #144  
Old 01-25-2007, 02:19 PM
Forza Forza is offline
 
Join Date: Aug 2006
Location: The Netherlands
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have my forum in a subdomain and I want to use this portal for my main root. But i keep getting the 'Invalid forum path specified' error.

This is the line i used in the index.php:

Code:
$forumpath = '/var/www/vhosts/musicinjection.net/subdomains/forum/httpdocs';

any suggestions?
Reply With Quote
  #145  
Old 01-25-2007, 02:56 PM
osso12 osso12 is offline
 
Join Date: Feb 2006
Posts: 77
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by hIBEES View Post
Sort off worked lol

As soon as I change the forum ID and have a forum ID in the " Forum ID
Specify the second (optional) forum id where you want your news to come from. " section I get the error again...

Working just now thou so thanks :up:
I am having this same exact problem.
Every time I add a forum to the second forum ID I get the SQL error.
If I remove the second forum ID, the problem goes away...
I did the fix on line 62 and 116 that was recommended, but that still did not solve the issue.
Anyone?
Thanks!
Great Mod BTW!
Reply With Quote
  #146  
Old 01-25-2007, 06:59 PM
captainslater's Avatar
captainslater captainslater is offline
 
Join Date: Dec 2005
Location: Austria
Posts: 260
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 5 AND visible = 1
ORDER BY dateline DESC
LIMIT 3;

MySQL-Fehler : Column 'visible' in where clause is ambiguous
Fehler-Nr. : 1052
OS: Linux
PHP: 5.0.4
MySQL 4.1.4

Installed in forum root
Reply With Quote
  #147  
Old 01-25-2007, 09:30 PM
Glynn58 Glynn58 is offline
 
Join Date: Jul 2006
Location: Barnsley UK
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by captainslater View Post
Quote:
Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 5 AND visible = 1
ORDER BY dateline DESC
LIMIT 3;

MySQL-Fehler : Column 'visible' in where clause is ambiguous
Fehler-Nr. : 1052
OS: Linux
PHP: 5.0.4
MySQL 4.1.4

Installed in forum root
Change the bit in red to t.visible = 1 in portal.php

Worked for us
Reply With Quote
  #148  
Old 01-27-2007, 11:21 AM
goodguy goodguy is offline
 
Join Date: Jul 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fist time trying to install anything like this so I might just be missing something out, I'm gretting this error.

Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 0 AND visible = 1
ORDER BY dateline DESC
LIMIT 3;

MySQL Error : Column 'visible' in where clause is ambiguous
Error Number : 1052
Can anyone help me? T.I.A.
Reply With Quote
  #149  
Old 01-27-2007, 12:41 PM
peterska2 peterska2 is offline
 
Join Date: Oct 2003
Location: Manchester, UK
Posts: 6,504
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm releasing an update later today which will address the database error (and maybe a couple of other minor things if I get time to code them in).
Reply With Quote
  #150  
Old 01-27-2007, 01:31 PM
goodguy goodguy is offline
 
Join Date: Jul 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Kerry-Anne View Post
I'm releasing an update later today which will address the database error (and maybe a couple of other minor things if I get time to code them in).
Thanks, I thought I had broke it.
Reply With Quote
  #151  
Old 01-27-2007, 03:52 PM
peterska2 peterska2 is offline
 
Join Date: Oct 2003
Location: Manchester, UK
Posts: 6,504
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Update

vBonjour version 1.0.3 has been released which fixes the bugs in 1.0.2 which were causing database errors.
Reply With Quote
Reply


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


All times are GMT. The time now is 03:45 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04958 seconds
  • Memory Usage 2,329KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (2)bbcode_php
  • (7)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete