Vbjokes

[micheal332001]

Downloads for this modification have been removed according to Official Policy: When Security Vulnerabilities in Hacks are Found (https://vborg.vbsupport.ru/showthread.php?t=83253)

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 (http://www.michealmilton.com/forums/donate.php)

[DS MrSinister]

Just install verynice. Great job m8!..

Keeping them coming.!

:)

:banana:

[micheal332001]

your welcome m8

[Gizmo5h1t3]

getting an error when i try to activate the vb jokes in the admin cp.


"could not find phrase vbjokes_cp_redirect"

any ideas??

installed as instructed
the vbjokes show up when u click in the navbar tho???

also, it says the phrase is missing when u add a category??????

yet the category gets added??

WEIRD!!


EDIT..*YAWN*

MYSQL DB ERROR when adding a joke.....


This hack is very simple to use but i have not added the phrases as i dont know how to do that.

So if someone is willing to update the product_vbjokes.xml file please do as this will help me.

Im a bit new to the use of xml files for installing this is why i have done the easy part.



that might explain why it aint working...:(

[micheal332001]

getting an error when i try to activate the vb jokes in the admin cp.


"could not find phrase vbjokes_cp_redirect"

any ideas??

installed as instructed
the vbjokes show up when u click in the navbar tho???

also, it says the phrase is missing when u add a category??????

yet the category gets added??

WEIRD!!

I put upto the phrases are not working but the vbjokes will work just fine with out the phrases. So your install is all working and install just how the install file should install the vbjokes.
So there is nothing to worry about

[Gizmo5h1t3]

there is mate, i cant add jokes
i get a database error??

[micheal332001]

cab you post the database error and i will tell you why.

[micheal332001]

getting an error when i try to activate the vb jokes in the admin cp.


"could not find phrase vbjokes_cp_redirect"

any ideas??

installed as instructed
the vbjokes show up when u click in the navbar tho???

also, it says the phrase is missing when u add a category??????

yet the category gets added??

WEIRD!!


EDIT..*YAWN*

MYSQL DB ERROR when adding a joke.....





that might explain why it aint working...:(

This is not why its not working when adding a joke to the database you have to put words in like so.

there's needs to be changed to there''s

This might be why you are getting a error
you have to put 2 of ( ' ) in

[Next-Selection]

Wow this one looks awesome !!!

[Gizmo5h1t3]

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO vbjokes_jokes ( `jokename` , `jokediscription` , `jokeimage` , `jokecatid` , `username` , `aprove` ) VALUES ('TO GOD FROM THE DOG.......','TO: GOD
FROM: THE DOG

Dear God: Why do humans smell the flowers, but seldom, if ever, smell one another?

Dear God: When we get to heaven, can we sit on your couch? Or is it still the same old story?

Dear God: Why are there cars named after the jaguar, the cougar, the mustang, the colt, the stingray, and the rabbit, but not ONE named for a dog? How often do you see a cougar riding around? We do love a nice ride! Would it be so hard to rename the "Chrysler Eagle" the "Chrysler Beagle"?

Dear God: If a dog barks his head off in the forest and no human hears him, is he still a bad dog?

Dear God: We dogs can understand human verbal instructions, hand signals, whistles, horns, clickers, beepers, scent IDs, electromagnetic energy fields, and Frisbee flight paths. What do humans understand?

Dear God: More meatballs and less spaghetti, please.

Dear God: Are there mailmen in Heaven? If there are, will I have to apologize?

Dear God: Let me give you a list of just some of the things I must remember to be a good dog.

1. I will not eat the cats food before they eat it or after they throw it up.

2. I will not roll on dead seagulls, fish, crabs, etc., just because I like the way they smell.

3. I will not munch on "leftovers" in the kitty litter box, although they are tasty.

4. The diaper pail is not a cookie jar.

5. The sofa is not a face towel. Neither are Mom and Dad's laps.

6. The garbage collector is not stealing our stuff.

7. My head does not belong in the refrigerator.

8. I will not bite the officer's hand when he reaches in for Mom's driver's license and registration.

9. I will not play tug-of-war with Dads underwear when hes on the toilet.

10. Sticking my nose into someones crotch is an unacceptable way of saying hello.

11. I dont need to suddenly stand straight up when Im under the coffee table.

12. I must shake the rainwater out of my fur before entering the house -- not after.

13. I will not throw up in the car.

14. I will not come in from outside and immediately drag my butt.

15. I will not sit in the middle of the living room and lick my crotch when we have company.

16. The cat is not a squeaky toy -- so when I play with him and he makes that noise, its usually not a good thing.

And, finally, My last two questions... Dear God: Why do humans only have 10 Commandments and dogs have 16?



P.S. Dear God: When I get to Heaven, may I have my testicles back?','','3','Gizmo','0');

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's laps.

6. The garbage collector is not stealing our stuff.
Error Number : 1064
Date : Wednesday, October 12th 2005 @ 11:02:37 PM
Script : http://www.*******.org/board/vbjokes.php?do=addajokeconfirm
Referrer : http://www.*******.org/board/vbjokes.php?do=addjoke
IP Address : **.**.**.***
Username : Gizmo
Classname : vb_database

SO U GET THE IDEA, the DB error has the joke in it as well...lmao

[TygerTyger]

Oh, that's just excellent! There's on thing stopping me using it though....no ability to rate jokes?

[DS MrSinister]

U will get the a error when u aprove the joke when u have one of these in a joke. ' or " one of things i figure out so far.. I just removed them and NO more errror. ONly time i got a error.. the missing Phrases dont bug me too much :)!

[Gizmo5h1t3]

altho its a top hack, big up to ya for that, its a bit of a pain not having any quote marks in jokes aint it????

[micheal332001]

this is the same joke you have posted but look at it closly.

Dear God: Why do humans smell the flowers, but seldom, if ever, smell one another?

Dear God: When we get to heaven, can we sit on your couch? Or is it still the same old story?

Dear God: Why are there cars named after the jaguar, the cougar, the mustang, the colt, the stingray, and the rabbit, but not ONE named for a dog? How often do you see a cougar riding around? We do love a nice ride! Would it be so hard to rename the "Chrysler Eagle" the "Chrysler Beagle"?

Dear God: If a dog barks his head off in the forest and no human hears him, is he still a bad dog?

Dear God: We dogs can understand human verbal instructions, hand signals, whistles, horns, clickers, beepers, scent IDs, electromagnetic energy fields, and Frisbee flight paths. What do humans understand?

Dear God: More meatballs and less spaghetti, please.

Dear God: Are there mailmen in Heaven? If there are, will I have to apologize?

Dear God: Let me give you a list of just some of the things I must remember to be a good dog.

1. I will not eat the cats food before they eat it or after they throw it up.

2. I will not roll on dead seagulls, fish, crabs, etc., just because I like the way they smell.

3. I will not munch on "leftovers" in the kitty litter box, although they are tasty.

4. The diaper pail is not a cookie jar.

5. The sofa is not a face towel. Neither are Mom and Dad''s laps.

6. The garbage collector is not stealing our stuff.

7. My head does not belong in the refrigerator.

8. I will not bite the officer''s hand when he reaches in for Mom''s driver''s license and registration.

9. I will not play tug-of-war with Dads underwear when hes on the toilet.

10. Sticking my nose into someones crotch is an unacceptable way of saying hello.

11. I dont need to suddenly stand straight up when Im under the coffee table.

12. I must shake the rainwater out of my fur before entering the house -- not after.

13. I will not throw up in the car.

14. I will not come in from outside and immediately drag my butt.

15. I will not sit in the middle of the living room and lick my crotch when we have company.

16. The cat is not a squeaky toy -- so when I play with him and he makes that noise, its usually not a good thing.

And, finally, My last two questions... Dear God: Why do humans only have 10 Commandments and dogs have 16?

Try adding this joke now and it will work

[micheal332001]

altho its a top hack, big up to ya for that, its a bit of a pain not having any quote marks in jokes aint it????

you can use the quote marks but you have to put 2 in not 1

you will see in the joke i have just put up

[micheal332001]

look at this

8. I will not bite the officer''s hand when he reaches in for Mom''s driver''s license and registration.

you will see its got 2 quote marks not the one you put in
When this has been added to your database it will only show one when your members view the joke

so that line will look like this to your users

8. I will not bite the officer's hand when he reaches in for Mom's driver's license and registration.

you see what i mean

[micheal332001]

Oh, that's just excellent! There's on thing stopping me using it though....no ability to rate jokes?

i will be adding that in a later version

[Gizmo5h1t3]

worked fine using that method mate...

[micheal332001]

worked fine using that method mate...

Cool glad to have helped you out there.

When on the add a joke screen it does tell you about that and how to put a joke in. Sorry if i did not make it clear on that screen.

[Barakat]

what a great hack for the vbulletin .... i was searching on it all the time....

thanks for sharing it ...

[micheal332001]

what a great hack for the vbulletin .... i was searching on it all the time....

thanks for sharing it ...


Your very welcome glad it can be of use to you all.

[Cyricx]

Isn't there a way to change that to html marks like the & or whatever that the database uses for apostrophes?

Ideas for future versions -

Usergroup permissions to view jokes.

[Blaine0002]

hey you can use this i dunno how but maybe some code in the vbjokes.php file that finds all
'
and replaces it with
&acute;
which looks kinda like an apostraphe :P

[TCM]

So does this allow HTML?

I see abuse possibilities.

[micheal332001]

So does this allow HTML?

I see abuse possibilities.

This can only use limited html like <br> and other tags like that.
All jokes have to be approved be for any joke is viewable by the members.
The joke is only inputted as text to the database.
So you are limited on the tags you can use.

[micheal332001]

hey you can use this i dunno how but maybe some code in the vbjokes.php file that finds all
'
and replaces it with
&acute;
which looks kinda like an apostraphe :P

I like this idea i will have alook round to see if this can be done.

[micheal332001]

Hi all i have found a fix for the inputting of a joke.


Find this in vbjokes.php

$jokename = $_POST['jokename'];
$jokediscription = $_POST['jokediscription'];
$jokeimage = $_POST['jokeimage'];
$jokecatid = $_POST['cid'];
$approve = 0;



Add under

$jokediscription = ereg_replace("'","''",$jokediscription);



I will upload the fixed files in about 10 mins

[micheal332001]

fixed files uploaded

[eXtremeTim]

I would have used the addslashes function myself.


Also what are you doing with this lol.


$areyouamember = $db->query("SELECT userid FROM " . TABLE_PREFIX . "user WHERE userid = '" . $userid . "'");


so we are grabbing into that we already have ;)

Looks to me like its some kind of reminents of the league hack.

Also this allows users to add jokes and then admin approval. Only problem is it looks to me like you let them use html which is a bad thing. I also am not seeing any data validation here.

Meaning I could easily take over any site using this hack. Please use data validation. If you need help with it please contact me. This hack has potential but it needs work. Please contact me so I can help you get this all cleaned up. ;)

[Blaine0002]

its checking to see if the user is logged in / registered :P

[eXtremeTim]

its checking to see if the user is logged in / registered :P

No im afraid its not. Becuase we already have that info without a query. its called $vbulletin->userinfo['userid'] if that is set to 0 they are not a registered member.

So we could use

if(!$vbulletin->userinfo['userid'])
{
//run some error crap here about not being registered or logged in
}

[Blaine0002]

huh well then i dunno (is a programming noob)

[jimmyboy]

dude, i really love it,,,,thx soo much

[jesus likes pie]

This looks awesome.

HOTM!

[jesus likes pie]

Oh wait....does moderation of jokes HAVE to be enabled?

[Blaine0002]

there is probably a way to bypass it, ill make it a setting tomorrow.

[eXtremeTim]

huh well then i dunno (is a programming noob)

Dont worry im not. ;)


I talked with the creator.
We are planning to spend some time any redo this hack and get it all cleaned up. ;)

Fixing the html problem plus adding in security checks and cleaning it up and adding more to it. ;)

[micheal332001]

we will be adding alot more to this and like eXtremeTim said he is going to help me work on this and make it a lot better.
So watch this space for new updates.
eXtremeTim its very nice of you to help as i do need it to better understand the coding involved in vb.
With the info he will be teaching me we weill come out with better hacks for you to use.

Many thanks eXtremeTim

[eXtremeTim]

No problem. :)

[MissKalunji]

I love this hack i gotta give it up to you!

now 2 things

when i add a joke do i HAVE to put <br> for it to appear normaly? lemme show u
a screen shot

and

2. i still get a database error when i have " or ' how can i fix that?

Thanks in advance!

[micheal332001]

Yes you will need to put the <br> in to put text on a new line.

The problem with the quotes should all be fixed now in the new files.

[Gizmo5h1t3]

updated the product with the fdixed file, and its working great...
now all we need to do is get it to seperate the lines instead of putting a break into it, and itll be the dogs wobblies...

nice one

/me clicks install

[MissKalunji]

Yes you will need to put the <br> in to put text on a new line.

The problem with the quotes should all be fixed now in the new files.


thanks cant wait til it seperates the line by itself caz not everyone knows about <br>

[micheal332001]

I will see if i can sort it out to put the <br> in automaticly.

[MissKalunji]

I will see if i can sort it out to put the <br> in automaticly.


That would be great!

[micheal332001]

I might have it sorted im just testing it out now and hope to have a new set of files to upload there will be no need to upgread just reupload the files

[micheal332001]

i will let you know when the new files are uploaded

[micheal332001]

Files all updated

This is not a upgrade you can just reupload the files and all will be fine.

[micheal332001]

Hi all

Another update for you all

I have the html check so you cannot add html into a joke now.
You can use bbcode smiles if you wish to do so.

This is not a upgrade install all you have to do it reupload the files and all will be fine.

[Gizmo5h1t3]

top post whoring there m8...lmao

[micheal332001]

hehehe

Yep all sorted no html and it will put the <br> in auto so no need to worry now.
You can also use the bbcode smilles in this too.

This has been updated with the help from eXtremeTim as he knows alot more than me lol

[micheal332001]

There will be a new version coming out soon.
This new version will let you upload a image and place the image where you want.
You will also be able to rate each joke and i might put in a coment in so you can leave a coment to a joke.

Also the layout of all the jokes and the categorys will also be better.
Me and extremtim will be working on this to make it alot better.

[MissKalunji]

There will be a new version coming out soon.
This new version will let you upload a image and place the image where you want.
You will also be able to rate each joke and i might put in a coment in so you can leave a coment to a joke.

Also the layout of all the jokes and the categorys will also be better.
Me and extremtim will be working on this to make it alot better.

hurray!!!!

[Gizmo5h1t3]

small bug noticed...

wqhile it now inserts the breaks in lines, when its putting quote mmarks in, this happens..
TEXAN: &quot;OK - where are you from, jackass?&quot;

[micheal332001]

small bug noticed...

wqhile it now inserts the breaks in lines, when its putting quote mmarks in, this happens..

Ill have alook into that m8

[Madmp3zz]

small bug noticed...

while it now inserts the breaks in lines, when its putting quote marks in, this happens..

Any update tothis one yet?

Has anybody fixed this error ass of yet?
I love the hack idea. Couple issues tho...

1. Just can't enable it until you figure out the above error.

2. Would also like to disable the approve needed for each joke. This could take up a lot of time.

3. Would like to get rid of the "no Image" area. Don't really see a need.

4. Any idea when we can get the phase error fixed?

[micheal332001]

Any update tothis one yet?

Has anybody fixed this error ass of yet?
I love the hack idea. Couple issues tho...

1. Just can't enable it until you figure out the above error.

2. Would also like to disable the approve needed for each joke. This could take up a lot of time.

3. Would like to get rid of the "no Image" area. Don't really see a need.

4. Any idea when we can get the phase error fixed?
Originally Posted by Gizmo5h1t3
small bug noticed...

while it now inserts the breaks in lines, when its putting quote marks in, this happens..

The reason its putting in the quotes if you look its where if someone is saying some thing that why the quote is there.

to change the approve to approved look for this
$approve = 0;
require_once(DIR . '/includes/class_bbcode.php');
$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
and change
$approve = 0; to $approve = 1;

this will disable the approving of the jokes.

The images is if you find a funny picture you can put the image in but if there is no image it has to show some thing or you get a red cross in a bux coz there is no image.
I could redo the joke one so there is no images for it and release it with this one.
As for the phrases im working on the fix for that now and iv also added a rank system for the jokes but have not released that yet.

[Madmp3zz]

I'm sorry I didn't copy the whole error,
When I enter quotes I get this now &quot;
at the open quote and close quote...

Quote:
TEXAN: &quot;OK - where are you from, jackass?&quot;


I looked at your site and it looks like it does the same exact thing.

[micheal332001]

I'm sorry I didn't copy the whole error,
When I enter quotes I get this now &quot;
at the open quote and close quote...

Quote:
TEXAN: &quot;OK - where are you from, jackass?&quot;


I looked at your site and it looks like it does the same exact thing.

I will look into it for the next release and fix this.
Thanks for letting me know

[GrendelKhan{TSU]

still keeping fingers crossed for phrases (have multi-language forum).

:)

<< finger poised to install. ;) :p

[micheal332001]

Im working on the fix for the phrases getting there.
Im also working on some other scripts as well so i have alot on at the moment.

[Madmp3zz]

With the new updated 1.01 it won't list the jokes...
Says I have 1 joke, but dosn't list it..

BTW, followed the install.txt and it deleted all my old jokes.. WTF..

and my server is running ALOT slower......

and I guess the quotations still haven't been fixed yet?

I think I'll have to de-activate this one until ALL the bugs are fixed....

[micheal332001]

With the new updated 1.01 it won't list the jokes...
Says I have 1 joke, but dosn't list it..

BTW, followed the install.txt and it deleted all my old jokes.. WTF..

and my server is running ALOT slower......

and I guess the quotations still haven't been fixed yet?

I think I'll have to de-activate this one until ALL the bugs are fixed....

How many jokes did you have in your vbjokes before you tryed the upgrade.
I have tested the script and it did not delete my jokes as all the upgrade does is add to more table to your vbjokes table for the rating of the jokes.
As to the quotes i have not fixed that yet but im getting there.
All the hacks i do are only done by me so i have alot of work on at this time.
Im working on a new league system vbcheats and helping on some other peoples hacks.
So please bear with me im getting there.

[Tracer Gun Kata]

Good Stuff :devious:

*installed*

[Gizmo5h1t3]

Phrases Fixed

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

theres no rating system showing on mine after the upgrade m8....u upped the correct file?

(i clicked the overwrite btw)

[micheal332001]

Oh sorry you will have to update 1 template and add another.


New template to add

Product vbjokes

Style your style

Title jokes_rating_options

html code
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>

Template to change jokes_view_joke

<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr class="tcat" >
<td width="20%" align="center">Joke Name</td>
<td width="10%" align="center">Submiter</td>
<td width="10%" align="center">Hits</td>
<td width="10%" align="center">Rating</td>
</tr>
<td width="20%" align="center">$jokes[jokename]</td>
<td width="10%" align="center">$jokes[username]
<td width="10%" align="center">$jokes[hits]</td>
<td width="10%" align="center">$jokes[voteavg]<br /><form method="post" action="vbjokes.php?do=addratingconfirm">
<input type="hidden" name="jokerankid" value="$jokes[jokeid]">
<select name="rating">
$showratebits
</select><br />
<input type="submit" name="submit" value="Rate Joke">
</td>
</tr>
</table>
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr class="tcat">
<td width="15%" align="center">Joke Image</td>
<td width="85%" align="center">Joke Discription</td>
</tr>
<tr class="alt1">
<td width="15%" align="center"><a href="?do=viewlargeimage&jokeid={$jokes[jokeid]}"><img src="$jokes[jokeimage]" width="200" height="200" border="0"></a></td>
<td width="85%" align="center" colspan="2">$jokes[jokediscription]</td>
</tr>
</table>

That should sort it

[yahoooh]

is there copy of this script for 3.07 ? i do not wanna update to 3.5
could u make version to 3.07

[tortoise]

Having a problem importing it, all the files except product-vbjokes.xml were uploaded to the server, when i try to import here is the error i get:

Database error in vBulletin 3.5.0:
Invalid SQL:
ALTER TABLE vbjokes_jokes ADD rating float(10,2) default '0.00' NOT NULL;



any help would be appreciated. thanks

[micheal332001]

Having a problem importing it, all the files except product-vbjokes.xml were uploaded to the server, when i try to import here is the error i get:

Database error in vBulletin 3.5.0:
Invalid SQL:
ALTER TABLE vbjokes_jokes ADD rating float(10,2) default '0.00' NOT NULL;



any help would be appreciated. thanks


When you do the inport od the product you need to do this
where is says

Allow Overwrite
If you wish to upgrade a product, you must set this to yes.

click yes

[micheal332001]

is there copy of this script for 3.07 ? i do not wanna update to 3.5
could u make version to 3.07

I do have a copy already for 3.0.7 but have not finished it yet.
When i have i will post it

[tortoise]

When you do the inport od the product you need to do this
where is says

Allow Overwrite
If you wish to upgrade a product, you must set this to yes.

click yes

the first time i tried it i got the same error, than i did it again (without removing the first) and it worked, but when i tried to navigate to the "vb jokes settings" it gave me this error: Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM vbjokes_settins;

[soniceffect]

that not supposed to be vbjokes_settings? .... Only guessing by the way so don`t quote me LOL

[micheal332001]

the first time i tried it i got the same error, than i did it again (without removing the first) and it worked, but when i tried to navigate to the "vb jokes settings" it gave me this error: Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM vbjokes_settins;

Only click the yes box if its a upgrade if its a new install you dont click it

[mfizzel]

This is awesome. Thanks.

[yahoooh]

I do have a copy already for 3.0.7 but have not finished it yet.
When i have i will post it

thanx , i will wait for vbjoke for 3.0.7

[micheal332001]

thanx , i will wait for vbjoke for 3.0.7

I hope to have this ready for 3.0.7 in the next day or 2

[Madmp3zz]

How many jokes did you have in your vbjokes before you tryed the upgrade.
I have tested the script and it did not delete my jokes as all the upgrade does is add to more table to your vbjokes table for the rating of the jokes.
As to the quotes i have not fixed that yet but im getting there.
All the hacks i do are only done by me so i have alot of work on at this time.
Im working on a new league system vbcheats and helping on some other peoples hacks.
So please bear with me im getting there.


I had over 500.. I did everything as discribed in the install and it seems to have erased them all... :(
The worst part of it all is I added most of them myself. Lot of work shot to crap.. O well, I'll survive.

Just have to wait on the quotation fix and the on/off image area.

Why is it that my jokes are being seperated by a bar instead if a line?

Also when the approval is changed to 1 instead of 0, why is it that when u add a joke the user still gets this message? "Your joke has beed added to the database and is waiting to be approved! "

[micheal332001]

I had over 500.. I did everything as discribed in the install and it seems to have erased them all... :(
The worst part of it all is I added most of them myself. Lot of work shot to crap.. O well, I'll survive.

Just have to wait on the quotation fix and the on/off image area.

Why is it that my jokes are being seperated by a bar instead if a line?

Also when the approval is changed to 1 instead of 0, why is it that when u add a joke the user still gets this message? "Your joke has beed added to the database and is waiting to be approved! "

Hi there m8

I know what the problem is with the joke being seperated by a bar.

edit the template jokes_view_jokesinthiscat

and change the hole content to this

<!-- comment submission -->
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr class="$class" >
<td width="5%" align="center">$jokesbycat[jokeid]</td>
<td width="20%" align="center"><a href="?do=viewjokeid&jokeid={$jokesbycat['jokeid']}">$jokesbycat[jokename]</a></td>
<td width="15%" align="center"><img src="$jokesbycat[jokeimage]" width="80" height="25"></td>
<td width="10%" align="center">$jokesbycat[username]</td>
<td width="10%" align="center">$jokesbycat[hits]</td>
<td width="10%" align="center"><a href="javascript:NewWindow=window.open('?do=viewjokepopu p&jokeid={$jokesbycat['jokeid']}','newWin','width=650,height=600,left=0,top=0,
toolbar=No,location=No,scrollbars=1,status=No,resi zable=No,fullscreen=No');
NewWindow.focus(); void(0);">View Popup</a></td>
</tr>
</table>

As for your members still getting the

Your joke has beed added to the database and is waiting to be approved!

Needs to be changed in the template called

jokes_madeconfirm

And find

Your joke has beed added to the database and is waiting to be approved!

Replace it with what you want init

[Madmp3zz]

Thanks for the quick reply.
This is starting to look Wicked Awesome.
My members are already asking me to turn it back on.
With these two issues fixed, all I'm missing is the quotation mark fix and I'll be off and running with this one.

GREAT HACK!!!

How soon before the quotation issue is fixed?

[micheal332001]

Thanks for the quick reply.
This is starting to look Wicked Awesome.
My members are already asking me to turn it back on.
With these two issues fixed, all I'm missing is the quotation mark fix and I'll be off and running with this one.

GREAT HACK!!!

How soon before the quotation issue is fixed?

Hi there m8

Im working on that now and hope to have a fix soon

[Madmp3zz]

Hi there m8

Im working on that now and hope to have a fix soon


BTW...
Have you thought about a STAR rating system that is listed between the joke ID and the joke name when listing the jokes..
And also have the rating system not allow the user to vote more than once on the same joke.

Doing a great job bro !!

[Bounce]

Only click the yes box if its a upgrade if its a new install you dont click it

DB error when set to no

Invalid SQL:
ALTER TABLE vbjokes_jokes ADD rating float(10,2) default '0.00' NOT NULL;

MySQL Error : Table 'mydbr_vb.vbjokes_jokes' doesn't exist
Error Number : 1146




clicked yes and it installed , well never coz getting Invalid SQL:
SELECT * FROM vbjokes_settins;

MySQL Error : Table 'mydb_vb.vbjokes_settins' doesn't exist
Error Number : 1146 db error on /vbjokes.php

[tortoise]

DB error when set to no

Invalid SQL:
ALTER TABLE vbjokes_jokes ADD rating float(10,2) default '0.00' NOT NULL;

MySQL Error : Table 'mydbr_vb.vbjokes_jokes' doesn't exist
Error Number : 1146




clicked yes and it installed , well never coz getting Invalid SQL:
SELECT * FROM vbjokes_settins;

MySQL Error : Table 'mydb_vb.vbjokes_settins' doesn't exist
Error Number : 1146 db error on /vbjokes.php


thats the same problem i had...exactly and i havent found out what was wrong yet :(

[micheal332001]

thats the same problem i had...exactly and i havent found out what was wrong yet :(

I have updated the products-vbjokes.xml file as there was a error in there.
This can only be installed as a new install.
So if you want to upgrade to this version you will need to remove the old version and reinstall vbjokes.
This means if you have jokes already there you will lose them sorry for this but im working on a fix to this and some other things too.

[micheal332001]

BTW...
Have you thought about a STAR rating system that is listed between the joke ID and the joke name when listing the jokes..
And also have the rating system not allow the user to vote more than once on the same joke.

Doing a great job bro !!

Fixed the quote's that was being put in when adding a joke.
Also added a stars raking insted of just the numbers.

This will have to be installed as a new install not a upgrade.

[Bounce]

I have updated the products-vbjokes.xml file as there was a error in there.
This can only be installed as a new install.
So if you want to upgrade to this version you will need to remove the old version and reinstall vbjokes.
This means if you have jokes already there you will lose them sorry for this but im working on a fix to this and some other things too.

thank you,working now

* Bounce clicks install :nervous:

tortoise uninstall the version you had and install the new one,it then adds the tables :)

[micheal332001]

thank you,working now

* hIBEES clicks install :nervous:


tortoise uninstall the version you had and install the new one,it then adds the tables :)

Glad its all working for you now :rolleyes: :banana: :cool:

[Madmp3zz]

So the new install removes the quotation marks all together now?

I had added the rating system from earlier.

Do I need to remove any templates or the rating system I added earlier.
The ratings is still coming up as the number system and I can still vote more than once.

[micheal332001]

So the new install removes the quotation marks all together now?

I had added the rating system from earlier.

Do I need to remove any templates or the rating system I added earlier.
The ratings is still coming up as the number system and I can still vote more than once.

Sorry m8 you will have to uninstall the vbjokes all together and reinstall.
Then you will have all the updates in this version.
You will not need to put any templates in as the install file for this new version will do it all for you.

[DS MrSinister]

How can I add Top Viewed Jokes and Top Rated Jokes to the main template?

[micheal332001]

How can I add Top Viewed Jokes and Top Rated Jokes to the main template?

Hiya m8

Im working on that now and will have a how to ready tomoz for this

[DS MrSinister]

Hiya m8

Im working on that now and will have a how to ready tomoz for this

sweet thxs m8!

[micheal332001]

you want some thing like this added to it.

[tortoise]

thank you,working now

* hIBEES clicks install :nervous:


tortoise uninstall the version you had and install the new one,it then adds the tables :)


I have updated the products-vbjokes.xml file as there was a error in there.
This can only be installed as a new install.
So if you want to upgrade to this version you will need to remove the old version and reinstall vbjokes.
This means if you have jokes already there you will lose them sorry for this but im working on a fix to this and some other things too.


works now *clicks install* thanks for the help :)

[DS MrSinister]

you want some thing like this added to it.


yes sir.. i saw that on your site and thiought it was in this update lmao..

[Madmp3zz]

you want some thing like this added to it.

Thats another great addition..

Luv it,

[Gizmo5h1t3]

christ, how many more updates?...lmao.

wouldnt mind, but im losing all the jokes ppl put in, with every update?!?!?

[DS MrSinister]

christ, how many more updates?...lmao.

wouldnt mind, but im losing all the jokes ppl put in, with every update?!?!?


thats odd i never lost one yet with all these updates.

[micheal332001]

the updata.xml is a new update script and you should not lose any thing now

[mfizzel]

I've installed it and activated but when I goto vbjokes.php I get this error:

Database error in vBulletin 3.5.0:

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

MySQL Error : Unknown column 'rating' in 'order clause'
Error Number : 1054

[Gizmo5h1t3]

thats odd i never lost one yet with all these updates.

Originally Posted by micheal332001
I have updated the products-vbjokes.xml file as there was a error in there.
This can only be installed as a new install.
So if you want to upgrade to this version you will need to remove the old version and reinstall vbjokes.
This means if you have jokes already there you will lose them sorry for this but im working on a fix to this and some other things too.
well i lost mine...and wait for it...THERS ANOTHER UPDATE TODAY?!?!?!?

[micheal332001]

I've installed it and activated but when I goto vbjokes.php I get this error:

If you read up top and look at the install notes it will tell you how to install vbjokes with out any problems.

[micheal332001]

im working on putting user group promissions in so you can stop unwanted people adding new jokes.
This will not be a upgrade just upload a new file and replace a file.

[mfizzel]

If you read up top and look at the install notes it will tell you how to install vbjokes with out any problems.

Ah, I see...I thought step #6 was only for upgrading from a previous version and since this was my first install of it I didn't import the ugprade...anyway, it's working now, thanks for your help :)

[Madmp3zz]

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE vbjokes_jokes ADD rating float(10,2) default '0.00' NOT NULL;

MySQL Error : Duplicate column name 'rating'
Error Number : 1060

I did all the steps including step 6......
Still getting this error..

What to do, what to do......

[mfizzel]

micheal, how can I remove the 'vbjokes main' box with the simpsons animation? I couldn't find the code...

[mfizzel]

nevermind, I emptied the jokes_home template and that did the trick

[micheal332001]

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE vbjokes_jokes ADD rating float(10,2) default '0.00' NOT NULL;

MySQL Error : Duplicate column name 'rating'
Error Number : 1060

I did all the steps including step 6......
Still getting this error..

What to do, what to do......

If you have these installed already you dont need to use the upgrade script.
But if you look in the upgrade script you will need to change 2 templates to get the pages to look like what i have.

The templates to look for are jokes

jokes_view_joke update this one
JOKES update this one

see if you have these 2 templates installed

jokes_toprating_jokes
jokes_top_jokes

If they are not in your templates look in the upgrade.xml file for these and add them to your templates like so

add new template
Product ---- vbjokes
Title ------- the one you are adding
enter the html code
save

If you want me to put the code up i will do so

[mfizzel]

The templates aren't getting cached for me : Uncached templates: jokes_top_jokes (3)
Uncached templates: jokes_toprating_jokes (3)

btw, we really need the quotation fix, 98% of my jokes have quotations and it can be confusing with them missing.

[micheal332001]

The templates aren't getting cached for me : Uncached templates: jokes_top_jokes (3)
Uncached templates: jokes_toprating_jokes (3)


btw, we really need the quotation fix, 98% of my jokes have quotations and it can be confusing with them missing.

Hi there m8

To fix this you need to edit the vbjokes.php file

find
'jokes_view_jokesinthiscat',
'jokes_categorys',
'jokes_categorys_bit',
'jokes_home'

replace with
'jokes_view_jokesinthiscat',
'jokes_categorys',
'jokes_categorys_bit',
'jokes_home',
'jokes_toprating_jokes',
'jokes_top_jokes'

That will fix that problem

[micheal332001]

btw, we really need the quotation fix, 98% of my jokes have quotations and it can be confusing with them missing.

I have fixed the quotes out but it will only work on new jokes that are added.
You will have to go and edit the old jokes you have and take them out.

[mfizzel]

Thanks for the fix for the uncached templates!

About the quotations, I don't mind adding the jokes again, when do you plan on releasing the fix?

Also, I changed the name of the script to 'jokes' from 'vbjokes' , but then these functions don't work : Jokes Main | Categories | Search Joke | Add A Joke , because it still calls 'vbjokes.....' and doesn't update the name of the script.

Great support Micheal, thanks for the help!

[mfizzel]

1 more issue I've come across, when you turn the jokes system off and click the jokes link it just reloads the index instead of taking you to an offline message.

[micheal332001]

1 more issue I've come across, when you turn the jokes system off and click the jokes link it just reloads the index instead of taking you to an offline message.

Ill look into that m8

[Madmp3zz]

A Few issues...

1. How can I l set the jokes to be alligned to the left instead of centered...
They get all jumbled when they are centerd, and looks awful..

2. When someone links an image, the image gets all streched out, can U make it viewable as the original size..

3. and....


As for your members still getting the



Your joke has beed added to the database and is waiting to be approved!

Needs to be changed in the template called

jokes_madeconfirm

And find

Your joke has beed added to the database and is waiting to be approved!

Replace it with what you want init


Since I did the update there is no Your joke has beed added to the database and is waiting to be approved! in the template anymore.
How do I change it now?

[micheal332001]

A Few issues...

1. How can I l set the jokes to be alligned to the left instead of centered...
They get all jumbled when they are centerd, and looks awful..

2. When someone links an image, the image gets all streched out, can U make it viewable as the original size..

3. and....




Since I did the update there is no Your joke has beed added to the database and is waiting to be approved! in the template anymore.
How do I change it now?

All the text is in the phrases now so you need to look there.
Goto your phases and do a search for vbjokes that will list all the vbjokes phrases.
Then edit the one you want to change

[Extreme John]

Just installed, install went nice and easy but Im getting the following error message when I click VbJokes from the Navbar.

Database error in vBulletin 3.5.0:

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, November 3rd 2005 @ 08:36:24 PM
Script : http://www.thetanforum.com/vbjokes.php
Referrer : http://www.thetanforum.com/forumdisplay.php?f=3
IP Address : 65.32.128.150
Username : Extreme John
Classname : vb_database

[ronoxQ]

Do you have a version for 3.0? Inquiring minds want to know...

[micheal332001]

Just installed, install went nice and easy but Im getting the following error message when I click VbJokes from the Navbar.

Database error in vBulletin 3.5.0:

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, November 3rd 2005 @ 08:36:24 PM
Script : http://www.thetanforum.com/vbjokes.php
Referrer : http://www.thetanforum.com/forumdisplay.php?f=3
IP Address : 65.32.128.150
Username : Extreme John
Classname : vb_database

Hi there m8

Have you run the upgrade.xml file as well like this

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

[micheal332001]

Do you have a version for 3.0? Inquiring minds want to know...

There is a version for vb 3.0.7 i have not tryed it on older versions

[lanc3lot]

Hope we can have soon comments for the jokes:D

[micheal332001]

Hope we can have soon comments for the jokes:D

Hi there m8

I will be working on the vbjokes again soon, But im having a few problems with web hosts at the moment.
As soon as i sort out my hosting i will be adding some more things to the vbjokes hack.

[lanc3lot]

Okz, thnx again mate:D

[mfizzel]

Hope we can have soon comments for the jokes:D

definitely! That would be sweet :D


Micheal, any chance you could give us the code that fixes the quotations issue?

[micheal332001]

definitely! That would be sweet :D


Micheal, any chance you could give us the code that fixes the quotations issue?

Thats in the zip file in the vbjokes.php script and will only work with new jokes added not jokes you had before the upgrade.

[mfizzel]

hmmm, according to my plugin manager I have 1.0.2 installed but quotations don't show up...is there something I need to do?

[Cedric_FP]

hmm getting this error when trying to add categories:

Database error in vBulletin 3.5.1:

Invalid SQL:
insert into vb3_vbjokes_categorys values(
'',
'Yo' Mamma Jokes'
);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Mamma Jokes'
)' at line 3
Error Number : 1064
Date : Monday, November 7th 2005 @ 08:22:47 PM
Script : http://www.fictionpost.com/forums/admincp/vbjokes_admin.php
Referrer : http://www.fictionpost.com/forums/admincp/vbjokes_admin.php?do=addcategorys
IP Address : 219.78.87.103
Username : Cedric
Classname : vb_database

[Cedric_FP]

NVM.. I had to remove the apostrophie. Great Hack, btw.

[micheal332001]

NVM.. I had to remove the apostrophie. Great Hack, btw.

Thanks m8

I will be fixing that problem too as its a easy fix to do.

[micheal332001]

hmmm, according to my plugin manager I have 1.0.2 installed but quotations don't show up...is there something I need to do?

The version has not gone up but if you look at the products manager and click edit on vbjokes you will see there is extra database entrys there and the versions.

[eXtremeTim]

hmm getting this error when trying to add categories:

no whats needed is the category title needs to have addslashes added to it so that ' gets a backslash before it.

[micheal332001]

The new version of the vbjokes will have all fixes and some new things.
The fixes will fix the ' in the admincp and the editing of jokes in admincp.

New to vbjokes will be comments.

New layouts

Will show some screen shots when i have done the layout.

Sadly this will have to be a complete new install of the vjokes but
You can make a copy of the vbjokes categories and the vbjokes jokes sql to reput in after
the new install.
Also added usergroup permisstions so you can stop none members from adding viewing or leaving a comment.

[micheal332001]

Hi all

Here are some screen shots of the new vbjokes hack.
You will see that comments and the layout has changed.
I have also added the usergroup permissions too.
You can choose if a usergroup can view the joke or if they can
add new jokes and you can also say what usergroups can add comment.

This version has not been release yet will be soon.

Here are the screen shots

[MissKalunji]

Hi all

Here are some screen shots of the new vbjokes hack.
You will see that comments and the layout has changed.
I have also added the usergroup permissions too.
You can choose if a usergroup can view the joke or if they can
add new jokes and you can also say what usergroups can add comment.

This version has not been release yet will be soon.

Here are the screen shots


Very nice!!

[mfizzel]

very cool! :D

can't wait :D

[micheal332001]

Hi all

Another update for you on the new version
I have added a pm system to tell the admin he/she has a new joke waiting to be approved.
And you are able to send a thank you to the user for adding there joke to your database.

[Feckie (Roger)]

Hi all

Another update for you on the new version
I have added a pm system to tell the admin he/she has a new joke waiting to be approved.
And you are able to send a thank you to the user for adding there joke to your database.

Starting to sound really good...

[micheal332001]

With the PM system you can add the admin that is approving the jokes.
Add a custum message for the admin and a custum message to send to the user.
The pm to the user is a thankyou PM for adding a joke the PM to the admin is a pm to let him/she know there is a new joke waiting approval.
Comments have been added now and you have usergroup permissions to say if that group can add comments or not.
All phrases fixed
All quots fixed
All ' fixed
New layout

Just finishing some things of before the pro version release.

If you think there should be some thing else added post it here.

[mfizzel]

Those new features sound great :D

[micheal332001]

Saddly this is a pro release and will be avalible only on my site

[MissKalunji]

Saddly this is a pro release and will be avalible only on my site

we have to pay for that one?

[micheal332001]

I would like to give it away free and have people donate but that does not happen as everyone wants every thing for free these days.
I have given you a good hack to start with but to have the pro version i would like to make some thing out of it as i have worked hard on this.
I have added alot to it and changed alot to it, to give you the best jokes addon there is.
All bugs have been fixed with quotes and phrases new template layouts and added a comment system and a pm system.

If you think this is unfair please let me know

[mfizzel]

I think it's fair for you to charge for something you've worked very hard on, but I do think you should release the update here with the bug fixes and what-not, that's only fair - and keep the improved features and what not for the pro version

[MissKalunji]

I would like to give it away free and have people donate but that does not happen as everyone wants every thing for free these days.
I have given you a good hack to start with but to have the pro version i would like to make some thing out of it as i have worked hard on this.
I have added alot to it and changed alot to it, to give you the best jokes addon there is.
All bugs have been fixed with quotes and phrases new template layouts and added a comment system and a pm system.

If you think this is unfair please let me know

i pay for what i want :) as long as you dont ask 70 us (espacially that i live in canada) count me in the buyers list ;)

[micheal332001]

I will only be asking for a small fee of about £10 uk pounds thats about $17 usd

[MissKalunji]

I will only be asking for a small fee of about ?10 uk pounds thats about $17 usd

then you can count me in ;)

[lanc3lot]

So when it will be up?:)
$17 is little money, although ok everyone would prefer it to have it free:)

[micheal332001]

Yes this is ready now and im glad you are happy with this.
I will be making the bug fixes for this version within the next few days.
The pro version is ready now

[MissKalunji]

Yes this is ready now and im glad you are happy with this.
I will be making the bug fixes for this version within the next few days.
The pro version is ready now



where can i buy?

[micheal332001]

Hi there

Click on buy vbjokes pro signup to my site
Goto usercp
Payed subscriptions
Choose vbjokes addon download subscription
this will give you the user rights to the vbjokes download forum.

[micheal332001]

if you need more help or find a problem please post it here http://www.michealmilton.com/forums/vbugs.php as i will be able to track all the bugs in this easyer.
Many thanks

[VaaKo]

can't users comment on the jokes?

[micheal332001]

Hi there m8

In the pro version yes they can.
The pro version also has usergroup permissions too.

[VaaKo]

where can I find the pro version?

[MissKalunji]

where can I find the pro version?

http://www.michealmilton.com/forums/members.php

[micheal332001]

http://www.michealmilton.com/forums/members.php

Yes thats right from there

[seany1]

Hi i bought the pro version but not to sure where i goto if im getting an error, This is what i am getting at the moment when trying to add a new joke

Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_pm in /includes/class_dm.php on line 758

please can you help.

thanks

[micheal332001]

Hi i bought the pro version but not to sure where i goto if im getting an error, This is what i am getting at the moment when trying to add a new joke

Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_pm in /includes/class_dm.php on line 758

please can you help.

thanks

Hi there m8

Can you give me the link to your site and maybe PM me with admin rights so i can have alook for you.

[seany1]

pm sent if you need anything else just pm me on msn.

thanks

[micheal332001]

pm sent if you need anything else just pm me on msn.

thanks

Fixed m8

[seany1]

Cheers mate :D

[micheal332001]

Cheers mate :D

your most welcome m8

[micheal332001]

Vbjokes pro christmas special.
There is a special on vbjokes pro at the moment click on buy vbjokes pro to find out more.

Merry christmas and a happy new year to you all.

[DS MrSinister]

Vbjokes pro christmas special.
There is a special on vbjokes pro at the moment click on buy vbjokes pro to find out more.

Merry christmas and a happy new year to you all.

THis is very nice of you.. Thxs m8.

[micheal332001]

your very welcome also the people that have payed for it already have been given 2 years free upgrades, as they have payed for it at the full price.
The price will be back to the full price on the 1st jan 2006 so get in quick.

[Jaynesh]

How do i put the categorys on the main page?

[micheal332001]

How do i put the categorys on the main page?

if you want to do that you will have to change the code in the vbjokes.php file to call the categorie template.

[steadicamop]

I tried installing the version here, and has a DB error, tried to fix, but seems too far gone, pretty bad that you're selling it, and leaving a fooked copy here.

[Jaynesh]

if you want to do that you will have to change the code in the vbjokes.php file to call the categorie template.

Could you please tell me how to do that?

[amykhar]

I tried installing the version here, and has a DB error, tried to fix, but seems too far gone, pretty bad that you're selling it, and leaving a fooked copy here.

The database error went away for me when I installed the upgrade product. Did you try that?

[steadicamop]

Hmmm didn't try that, just installed it, thought the upgrade would only be needed if you were upgrading, will have a look into the XML file and see if it adds that table.

Thanks :)

[micheal332001]

I tried installing the version here, and has a DB error, tried to fix, but seems too far gone, pretty bad that you're selling it, and leaving a fooked copy here.

Please reframe from swearing this version works just fine and has been tested.
Before you install any hack always read the read me files or the info on this thread for the hack.

I will help anyone that has problems but if they swear at me i will not give any help at all.

[steadicamop]

Please reframe from swearing this version works just fine and has been tested.
Before you install any hack always read the read me files or the info on this thread for the hack.

I will help anyone that has problems but if they swear at me i will not give any help at all.

My apologies, I'd had a beer (a large one too), and was a little gutted it didn't work - will try it again with the upgrade part extra, I'm very well just missing that part.

Thanks

[Jaynesh]

How do i put the categorys on the main page?

Anyone know the code to do this?

[micheal332001]

My apologies, I'd had a beer (a large one too), and was a little gutted it didn't work - will try it again with the upgrade part extra, I'm very well just missing that part.

Thanks

Thats ok m8

Hope you had a very good christmas.

[micheal332001]

Anyone know the code to do this?

I will have alook for you some time soon but i have alot on at the moment.

[Jaynesh]

I will have alook for you some time soon but i have alot on at the moment.

Ive done it ive done it :d

hmm i might purchase the pro version...

[Jaynesh]

How do i disable approval i want jokes to be up as soon as they are posted i dont want them to be approved...

[micheal332001]

How do i disable approval i want jokes to be up as soon as they are posted i dont want them to be approved...

This has been posted on here how to do that but here it is again for you.

Open the vbjokes.php file and

Find

if($_REQUEST['do']=="addajokeconfirm"){

In the code for that look for

$approve = 0;

and change it to

$approve = 1;

Hope that helps you out

[Jaynesh]

Okay thanx il give it a try :D

How about adding a WYSIWYG interface? how will i do that?

[micheal332001]

Okay thanx il give it a try :D

How about adding a WYSIWYG interface? how will i do that?

this is being done for a new pro release

[micheal332001]

Hi all

Vbjokes pro has been updated and now has WYSIWYG editor for adding new jokes,
And also a image upload so your members that can add new jokes can use the uploading of a image for there jokes insted of a url to the image.
This stops hotlinking to other sites.

[micheal332001]

vbjokes pro and this version has been tested on vbulletin 3.5.3 and works fine.

This free version will be updated soon to use the WYSIWYG editor will let you know when.

Mike

[icare]

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 : Tuesday, January 31st 2006 @ 01:52:33 AM
Script : http://www.example.com/vbjokes.php
Referrer : http://www.example.com/vbjokes.php
IP Address : xx.xxx.xxxx.xxxx
Username : Administrator
Classname : vb_database


:cry: :cry:

I am getting this error. somebody please help.

thanks in advance.

[icare]

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 : Tuesday, January 31st 2006 @ 01:52:33 AM
Script : http://www.example.com/vbjokes.php
Referrer : http://www.example.com/vbjokes.php
IP Address : xx.xxx.xxxx.xxxx
Username : Administrator
Classname : vb_database


:cry: :cry:

I am getting this error. somebody please help.

thanks in advance.

never mind. Fixed!!! thanks its a nice hack


But I have a question. Can v change the name in nav bare i.e from "vbjokes" to some thing else?

[icare]

never mind. Fixed!!! thanks its a nice hack


But I have a question. Can v change the name in nav bare i.e from "vbjokes" to some thing else?


Never mind again.....

Done it. Now I have last question..... can we change the text in jokes home page?

[micheal332001]

Never mind again.....

Done it. Now I have last question..... can we change the text in jokes home page?

Yes you can change the text in the jokes home page.
Go to the admincp and click on styles manager
edit template VBJOKES

you should see the text there.

Hope that helps m8

[amykhar]

I have found a bug in the editing of jokes. Editing the username of the submitter doesn't stick. I looked at the source code and in the do_edit_joke function, there is no code to process the submitter from the form. I'm fixing it in mine as follows:

Find:

$jokeimage = $_POST['jokeimage'];


Add After:

$submitter = $_POST['username'];


Find:

jokeimage='" . addslashes("$jokeimage") . "',


Add After:

username='" . addslashes("$submitter") . "',


Amy

[Lee Wisener]

I am getting template errors, can anyone help?

This is how it look on the main page.

http://www.ww2talk.com/forum/vbjokes.php?do=main

This is how it looks viewing categories.

http://www.ww2talk.com/forum/vbjokes.php?do=category

As you can see the bar down the right is missing.

But all other pages seem to be fine.

[micheal332001]

I am getting template errors, can anyone help?

This is how it look on the main page.

http://www.ww2talk.com/forum/vbjokes.php?do=main

This is how it looks viewing categories.

http://www.ww2talk.com/forum/vbjokes.php?do=category

As you can see the bar down the right is missing.

But all other pages seem to be fine.

Hi there

I see what you mean i will have alook at this and change the code to make this work right.
Will let you know when its sorted.

[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]

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]

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]

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]

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?

[micheal332001]

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?

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


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

[bashy]

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?

[Drago912]

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

[micheal332001]

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

Hi there

This has been answered in these posts

[xspazx]

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

[xspazx]

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

[bashy]

Hi...

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

[fosman]

Does this work with vbulletin 3.5.4 ?

[xspazx]

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

[micheal332001]

Hi...

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

This has been answered in a few threads back

[micheal332001]

Does this work with vbulletin 3.5.4 ?

Yes this does work with 3.5.4

[micheal332001]

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

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.

[xspazx]

oh okay thanks man great job

[xspazx]

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

[micheal332001]

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.

[xspazx]

2 months and a few days later..

[micheal332001]

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

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">
<span class="smallfont">$vbphrase[vbjokes_newest_jokes]</span>

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

[Distance]

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

[micheal332001]

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.

[xspazx]

Still messed up severely.

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

i give up

[micheal332001]

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]

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]

and yes I did install the xml file.

[micheal332001]

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]

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]

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]

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]

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:


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

$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]

Serious vulnerabilities have been found in this modification. Files have been removed according to Official Policy: When Security Vulnerabilities in Hacks are Found (https://vborg.vbsupport.ru/showthread.php?t=83253)

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