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
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
Just installed and got this error when i went to vbjokes.php
Any ideas please
Code:
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?
I know what the problem is and here is what you can do.
Goto your sql in cpanel and look for your TABLE_PREFIX I.E.( vb3_ )vbjokes_jokes
And see if you have these 2 sql feilds there
rating and numberOfVotes
If these are not there you can run this in your sql to add them
PHP Code:
ALTER TABLE `vbjokes_jokes` ADD `rating` FLOAT( 10, 2 ) DEFAULT '0.00' NOT NULL ;
ALTER TABLE `vbjokes_jokes` ADD `numberOfVotes` INT( 20 ) DEFAULT '0' NOT NULL ;
And this will fix your problem
But dont forget to put your sql's table prefix before vbjokes_jokes
Can you remember me asking you if you can sort it so that my mods/smods
can have the control panel for your vBCheats?
Well i dont think ya got round to doing it yet
When you do can you do the same for this one as well please?
Vbjokes Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
03-19-2006, 03:08 PM
