Vbjokes

Downloads for this modification have been removed according to Official Policy: When Security Vulnerabilities in Hacks are Found

VBjokes what is it.

Well vbjokes is a jokes database system for holding all your jokes in one place.

with vbjokes the user can search for a joke or just look around in the categorys.

All members of the site will be able to add a joke to the database but the admin will have to approve the joke before anyone on your site can see it.

The user has the option to view the jokes in a popup and by clicking the image if the joke has one to see the larger picture.

The users can now rate a joke out of 5 this now uses images to show the rating.

The admin can do

The admin can add new categorys edit or delete them.

View edit delete jokes.

Approve new jokes.

Turn vbjokes on or off.


Phrases Fixed

Have fixed the phrases and added a rate system for the jokes.

Fixed the upgrade xml file as you can see there is a product-vbjokes-upgrade.xml file
This is to upgrade all versions of vbjokes to 1.0.3
When you view this in the manage products it will say version 1.0.2
but if you click edit it will show that 1.0.3 has been installed.

Also fixed when viewing whos online it will say viewing vbjokes with a link to the jokes.

some template changes too where it only showed the newest jokes it now shows newest top hit and top rated jokes at the bottom of every page.

Install notes

Installation
1. Upload files as-is to board but not the product-vbjokes.xml file.

2. Log into admincp, Goto Plugin System then manage pruducts click [Add/Import Product]
then inport the product-vbjokes.xml file.

3. navigate back into admincp, (might need a refresh to get nav options)

4. click vbjokes, then vbjokes settings, activate vbjokes

5. Edit navbar in navigation / breadcrumb templates
************************************************** ************
Find
************************************************** ************
<td class="vbmenu_control"><a href="memberlist.php$session[sessionurl_q]">$vbphrase[members_list]</a></td>
************************************************** ************
Add under
************************************************** ************
<td class="vbmenu_control"><a href="vbjokes.php">VBjokes</a></td>
************************************************** ************

6. login to admincp
goto Plugin System
Manage Products
[Add/Import Product]
EITHER upload the XML file from your computer product-vbjokes-upgrade.xml
Allow Overwrite yes
click inport

7. All done enjoy your vbjokes hack.

Please donate to my work Click Here

[Lee Wisener]

Thanks.

[DementedMindz]

i just tried to install this but i got this error anyone know why?

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;

[micheal332001]

Originally Posted by DementedMindz

i just tried to install this but i got this error anyone know why?

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;

Did you do the install as the read me files says if not that is why.

[DementedMindz]

yes i did i even went back to double check but when i goto vbjokes.php thats when i get the error??

[imranbaig]

I just baught VBjokes Pro, but the layout is same as it is for a free version?
meaning it does not show like it shows on your site?
categories on left and then latest,popular and etc on right and jokes on middle? why? I uninstalled the free version and then installed 1.05.
But the templates were still the same?
any idea why?

[micheal332001]

Originally Posted by DementedMindz

yes i did i even went back to double check but when i goto vbjokes.php thats when i get the error??

Hi there

If you can give me the URL to your site i will have alook for you.
If you want PM me with admin rights and i will look into this more for you.

[micheal332001]

Originally Posted by imranbaig

I just baught VBjokes Pro, but the layout is same as it is for a free version?
meaning it does not show like it shows on your site?
categories on left and then latest,popular and etc on right and jokes on middle? why? I uninstalled the free version and then installed 1.05.
But the templates were still the same?
any idea why?

Did you read all the read me files for installing the vbjokes pro version.
If you have installed this over the free version you will need to read the upgrade info in the read me file.
This will tell you what database tables to backup and then go back to your admincp and products and uninstall vbjokes then install it again and all should be fine.

If you have any other problems or still having problems please PM me and i will help you that way.

[imranbaig]

Sent you PM last night,..

[micheal332001]

Originally Posted by imranbaig

Sent you PM last night,..

Hi m8

I have sorted it out and sent you a PM

[bashy]

Hi Micheal

Just installed and got this error when i went to vbjokes.php
Any ideas please

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;

MySQL Error  : Unknown column 'rating' in 'order clause'
Error Number : 1054
Date         : Sunday, March 19th 2006 @ 02:16:58 PM
Script       : http://www.bashys-place.com/forums/vbjokes.php
Referrer     :

Yes i have followed the instructions
When the product imported i saw it modify the DB on 3 occasions, is this correct?