PDA

View Full Version : Forum information displayed in Joomla/Mambo module


stonyarc
04-16-2006, 10:00 PM
Forum information displayed in Joomla/Mambo module

Function
This will display the members and basic information of the Bulletin Board in a Joomla/mambo CMS module.

Don't forget to hit install !!!!!!!

https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=113227)

Version

v1.0.0
Initial version

v2.0.0
Fixed the prefix issue
Simplified the module config (less fields)


Demo
http://www.xboxusersgroup.com right column

Installation of the module in Joomla

Upload Package File:
Providing you have GZip support with PHP, you will be able to upload a zipped package file that will be automatically installed to your server. 'Browse' to the location of the element on your computer. Then click the 'Upload File & Install' icon.

To install from directory:
If you don't have GZip support then you may upload an unpacked Archive to your host's server. Type the location of this file (it must be the absolute location) then click the 'Install' icon.

Configuration of the module in Joomla

Go to the module manager and click on the new module.
Fill in the required fields (database, username and that kind of things)
Set it to the zone and order you want to display it
Enjoy

Planned features

To be defined

Feel free to support this mod and make a donation to admin@stonyarc.com

https://vborg.vbsupport.ru/external/2007/08/10.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=admin%40stonyarc%2ecom&no_shipping=0&no_note=1&tax=0&currency_code=EUR&bn=PP%2dDonationsBF&charset=UTF%2d8)

(c) 2006 Stonyarc and Xboxusersgroup.com

stonyarc
04-17-2006, 11:33 AM
Version

v1.0.0
Initial version

v2.0.0
Fixed the prefix issue
Simplified the module config (less fields)

Screenshots from v1.0.0

jellybaby
04-17-2006, 11:55 AM
Thanks have been waiting for this for ages...off to test.

Edited to say its great and very easy to install. Thanks very much.

stonyarc
04-17-2006, 11:57 AM
Thanks have been waiting for this for ages...off to test.

I've had it for ages:D

don't forget to click install if you keep it active

jellybaby
04-17-2006, 12:07 PM
Oops sorry, done.

forumthemes
04-17-2006, 01:16 PM
Great mod! Clicked install

stonyarc
04-17-2006, 05:50 PM
Great mod! Clicked install

Thanks

Anybody any problems with this one?

I think it should work nicely. I had it operational for almost a year.

It's tested on mambo 4.5.2.3 and Joomla 1.0.X

Ramsesx
04-17-2006, 09:00 PM
Thanks for this, but it is showing the online users but get this error: Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/www/web153/html/cms/modules/mod_vbonlineusers.php on line 60
registered users

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/www/web153/html/cms/modules/mod_vbonlineusers.php on line 63

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/www/web153/html/cms/modules/mod_vbonlineusers.php on line 63
threads with posts.
Click here to go to the forums.

The Forum link is pointing to cms/forum instead only /forum
I have VB 3.5 and Joomla 1.08
Joomla in html/cms and vb in html/forum and each in a different database.

stonyarc
04-17-2006, 09:22 PM
Thanks for this, but it is showing the online users but get this error: Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/www/web153/html/cms/modules/mod_vbonlineusers.php on line 60
registered users

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/www/web153/html/cms/modules/mod_vbonlineusers.php on line 63

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/www/web153/html/cms/modules/mod_vbonlineusers.php on line 63
threads with posts.
Click here to go to the forums.

The Forum link is pointing to cms/forum instead only /forum
I have VB 3.5 and Joomla 1.08
Joomla in html/cms and vb in html/forum and each in a different database.

This sounds like a configuration error.

Please make sure that all fields are correct.

If you have a table prefix you also need to change the user and session field.

don't use absolute paths. http://gggsfmldksqmfks/forum should work fine.

Hope this helps

Ramsesx
04-17-2006, 09:49 PM
Thank you stonyarc, but I used the prefix already:
VB3usertable = vb3_user
VB3sessiontable = vb3_session
url to your vb3 = http://www.mydomain.de/forum
second url = http://www.mydomain.de/forum/member.php
The database user/pw are correct.

stonyarc
04-17-2006, 09:57 PM
Thank you stonyarc, but I used the prefix already:
VB3usertable = vb3_user
VB3sessiontable = vb3_session
url to your vb3 = http://www.mydomain.de/forum
second url = http://www.mydomain.de/forum/member.php
The database user/pw are correct.

I think you may have to change something in the php file for your setup

The table prefix is needed for some other queries to.
I'll change to mod so it will take on the prefix as a setting for all tables

quick fix for you

open mod_vbonlineusers.php

look for
$my_posts = mysql_query("SELECT COUNT(*) as PTOTALFOUND from post");
$my_threads = mysql_query("SELECT COUNT(*) as TTOTALFOUND from thread");
$my_users = mysql_query("SELECT COUNT(*) as UTOTALFOUND from user");

change to

$my_posts = mysql_query("SELECT COUNT(*) as PTOTALFOUND from vb3_post");
$my_threads = mysql_query("SELECT COUNT(*) as TTOTALFOUND from vb3_thread");
$my_users = mysql_query("SELECT COUNT(*) as UTOTALFOUND from $VB3_USERS_TABLE");

Save and upload

That should help you out till I make the update

Ramsesx
04-18-2006, 12:04 AM
Now it's fine, only the path to the forum is still pointing to http://www.mydomain.de/cms/forums instead http://www.mydomain.de/forum.
Btw. where can I change the phrases?
Thank you very much for your quick support :)

topsoftware
04-18-2006, 06:50 AM
thanks
do tou have same dis hack for Movable Type and anader cms

gameslover
04-18-2006, 09:36 AM
Hello,

First thanks for this great hack :banana:

However I have a little problem. I have my website under Joomla on a server A and my forum under Vb on a server B. Is there a way to use your hack with that configuration or joomla and vb have to be on the same server ?

Thanks you for your answer :)

imported_predatorkill
04-18-2006, 09:43 AM
stony,again is one year ahead!!!

I like it being in the screenshot as a logged in member :D

great work stony!

**installed**

stonyarc
04-18-2006, 06:07 PM
Hello,

First thanks for this great hack :banana:

However I have a little problem. I have my website under Joomla on a server A and my forum under Vb on a server B. Is there a way to use your hack with that configuration or joomla and vb have to be on the same server ?

Thanks you for your answer :)

If your mysql server vb is setup to accept remote connections and the host from joomla is in the "allowed" IP it should work.

stonyarc
04-19-2006, 06:34 PM
Don't forget to update to the latest version.

It's a bit easier to work with

Ramsesx
04-19-2006, 08:57 PM
If a user have choosen to be invisible, this module is still showing them.

stonyarc
04-19-2006, 11:13 PM
If a user have choosen to be invisible, this module is still showing them.

The query can be modified to exclude them

anstosser
09-20-2007, 10:56 PM
Works fine!!! Thanks!!!

santopia
12-17-2008, 02:24 PM
I installed the mod and get this error:

Fatal error: Call to undefined method stdClass::get() in /home/astro/public_html/templates/system/html/modules.php on line 68