The Arcive of Official vBulletin Modifications Site.

Vbjokes · **Released**: 10-11-2005

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

micheal332001 · #**222** 07-31-2006, 10:40 AM

Quote:

Originally Posted by xspazx

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.

Hiro · #**223** 07-31-2006, 11:41 AM

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

Hiro · #**224** 07-31-2006, 11:55 PM

and yes I did install the xml file.

micheal332001 · #**225** 08-01-2006, 04:40 AM

Quote:

Originally Posted by Hiro

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

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

micheal332001 · #**226** 08-06-2006, 09:55 AM

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

Harley D · #**227** 10-16-2006, 10:44 PM

Quote:

Originally Posted by micheal332001

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

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.

010081 · #**228** 01-04-2007, 07:17 AM

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

Logician · #**229** 02-09-2007, 08:03 AM

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:

PHP Code:


			
SELECT COUNT(*) AS jokecatid
  FROM " . TABLE_PREFIX . "vbjokes_jokes AS vbjokes_jokes
  WHERE jokecatid='{$_GET['cid']}'

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

PHP Code:


			
 $vbulletin->input->clean_array_gpc('r', array(
  'cid' =>TYPE_INT
 ));
 
SELECT COUNT(*) AS jokecatid
  FROM " . TABLE_PREFIX . "vbjokes_jokes AS vbjokes_jokes
  WHERE jokecatid='$vbulletin->GPC[cid]'

in your to avoid some unwanted results..

Marco van Herwaarden · #**230** 02-09-2007, 08:21 AM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07382 seconds Memory Usage 2,307KB Queries Executed 24 (?)
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_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!