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

And this will fix your problem

But dont forget to put your sql's table prefix before vbjokes_jokes

Cheers m8...this appeared to sort it :)

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?

any way to turn the approval off so peeps can upload jokes without waiting?

Hi there

This has been answered in these posts

looks like an all around great hack! i love hacks where members can give content.

any idea why when i click a joke i get a popup of my index? :(

Hi...

How can i set this so that we dont have to approve the jokes and they go straight through the system please?

Does this work with vbulletin 3.5.4 ?

http://chewonthat.net/vbjokes.php?do=category

is there a way I can fix this so it doesn't stretch the entire page like shown ^

great hack by the way keep up the good work man! :D

This has been answered in a few threads back

Yes this does work with 3.5.4

Im working on this within the next few days so it will not be like that.
When i have sorted it i will post it here the template fix.

oh okay thanks man great job

Hey, it's been 6 days..do you have a fix yet

Sorry i have not been back on about this i have just moved to a new house.
And have been very buzy working on the pro league system and other things that have not been finished yet.
I will have a fix for this as soon as i can as its only one themplate that needs changing as far as i can see.

2 months and a few days later..

Sorry for the wait i had a big op on my arm and could not use it for some time.
Iv been trying to catch up on all the questions people have been asking on all my hacks and have just got to this one.

Right look in the template

JOKES

find this

and change the table with from 100% to 80% or till you have got it to the right size for your site.

Sorry again for the long wait

Database error in vBulletin 3.5.4:

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 : Monday, July 24th 2006 @ 07:48:30 AM
Script : http://www.hullchat.co.uk/vbjokes.php
Referrer : http://www.hullchat.co.uk/index.php?
IP Address : **
Username : **
Classname : vb_database

You have not done this step thats why.



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.

Still messed up severely.

http://chewonthat.net/vbjokes.php?do=category

i give up

I will be sorting this out today and will post the templat edit here.
Sorry for the wait been very buzy.

Database error in vBulletin 3.5.4:

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

MySQL Error : Unknown column 'numberOfVotes' in 'order clause'
Error Number : 1054
Date : Monday, July 31st 2006 @ 10:40:05 PM
Script : http://www.eliteneo.com/vbjokes.php
Referrer : http://www.eliteneo.com/
IP Address :
Username : Zeus
Classname : vb_database

and yes I did install the xml file.

But did you do this last bit


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


As this installs them sql tables

I have not tested this on 3.6 yet but i will be very soon.
If there is a problem with this being installed on 3.6 i will make a fix and re-release it in the 3.6 add-ons

Same database error as the others on 3.54, and yes l followed the instructions to the "T" I would really like to use this, if you need to see my database, Admincp or anything else to figure out the problem, Please just let me know.

Database error in vBulletin 3.6.4:

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 : Thursday, January 4th 2007 @ 03:15:30 AM
Script : http://www.zonemedicine.com/forums/vbjokes.php
Username : zonemedicine
Classname : vb_database

anything i can do to getr working for 6.4

I'm sorry to say this but you should really stop using $_GET variables in the SQL queries without properly cleaning them up in the code.

In your code, you have many SQL queries like:

and I couldn't find any attempt to clean incoming $_GET['cid'] variable before directly using in the query. I don't want to mention the problems it can cause, I'm sure you are well aware of them.

Please clean them up like
in your to avoid some unwanted results..

Serious vulnerabilities have been found in this modification. Files have been removed according to Official Policy: When Security Vulnerabilities in Hacks are Found

Author will be contacted to address these vulnerabilities. Thread closed until update provided by author.