Guess The Word (Game) [AJAX]

[harmor19]

I created this hack mainly for a contest I'm planning on having. It works similar to "hangman" but the user has to make a number of posts to display a letter.

If the word is "Andrew" and the number of posts is "5" the user will see a letter of the word for each 5 posts they make.

Here are the settings for "Guess the Word"
http://xenweb.net/options.png

[harmor19]

This was a quick hack. If you have any suggestions I'd appreciate it.

[Veer]

Nice Idea :up:

Some suggestions:

Its hard to change words again n again via admincp, Is it possible to add / edit words in threads?
More then One Word, when user get the word, the next word comes to game automatically.Thanks anyway. :)

[Staxed]

haven't installed yet, few questions:

can I do phrases instead of single words?

do the letters show randomly or is it just from front to back that they appear?

[trd167]

i like the concept, it should keep the members entertained

[trd167]

installed!

[trd167]

wait, it doesnt work?

Number of posts : 1

Number of Characters: 0

Everytime, I make a post the letter doesnt show?

[harmor19]

I fixed the "post" bug.

[harmor19]

haven't installed yet, few questions:

can I do phrases instead of single words?

do the letters show randomly or is it just from front to back that they appear?

Right now you can only do single words because if you had "Iris Fire" would would show the underscores as "_ _ _ _ _ _ _ _" instead of "_ _ _ _ _ _ _ _"

I'm working on a way to have the letters show randomly but for now they only show from left to right.

[abweb]

At first: Sorry for my bad english :-)

I have installed this Hack.
And now? I must open a thread for this hack? And in this thread i can post my solution?

How does this Hack run?

thank you!

[Eddie.67]

I've got the same question.
What I do have to do after getting the complete solution?
I think starting a new thread does not make sense... because nothing happens!
And if I start a new "hangman" (write a new word into "Word to Guess") the old entries in the database still exist.

[wolfyman]

sounds interesting, an upgrade to this hack is a worthy endeavor if someone has the time!

[kersti]

A great concept, my points on this

- would be good to have a list of words so that when you get one you can start on the next
- would like to see phrases
- random letter reveals would be good
- would like a "prize" for being first to reveal the word - say extra reputation points or something

[Mum]

A great concept, my points on this

- would be good to have a list of words so that when you get one you can start on the next
- would like to see phrases
- random letter reveals would be good
- would like a "prize" for being first to reveal the word - say extra reputation points or somethingI love all these suggestions too!!

[feverwilly]

it messed my site up when I installed it (SQL Errors) I tried to uninstall it and it didnt work so I just disabled it. Sites fine now.

360leagues.com

[deezelpope]

Fixed

[deezelpope]

Trying again...:confused:

[deezelpope]

Fixed

[deezelpope]

it messed my site up when I installed it (SQL Errors) I tried to uninstall it and it didnt work so I just disabled it. Sites fine now.

360leagues.com
Fixed

[deezelpope]

Quick question...could it be messing up cuz of the spaces in the string?:confused: Right before the $ and right after the 'd' in guessword.

<br />Word: $guessword <br /><br />

[deezelpope]

Nope, that's not it either...I give up!:down:

[deezelpope]

This was a quick hack. If you have any suggestions I'd appreciate it.
Resolved

[adwade]

This was a quick hack. If you have any suggestions I'd appreciate it.

Along the lines of something like Random User of the Day, would be nice if the first person to guess the word or phrase of the day was somehow publicized. Maybe a banner, or an ad, or a block in vBadvanced's CMPS somewhere with their avatar or picture in it exclaiming so???

Seems like this idea has a lot of potential. Good work so far harmor19! :up:

[harmor19]

I'm sorry for the errors and the lack of support. Right now I'm upgrading the hack to use ajax.
It will also recognize spaces in the word.

[harmor19]

I have upgraded this hack to use ajax. If you or any of your users thinks they know the word they can click on it, type in their guess. If their guess is right it'll echo back the correct word. If they are wring it'll output "You are incorrect".

The option "New Game?" when set to 'Yes' will delete all the entries made by your users which will start a new game.

[ChurchMedia]

I'm getting this error when trying to install:

Invalid SQL:
CREATE TABLE `vb_guessword` (
`guesswordid` INT( 50 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 50 ) UNSIGNED NOT NULL DEFAULT '0',
`chars` SMALLINT( 6 ) UNSIGNED NOT NULL DEFAULT '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 ')' at line 5

[ChurchMedia]

Found it. Should be --

<installcode><![CDATA[$db->query_write("CREATE TABLE `" . TABLE_PREFIX . "guessword` (
`guesswordid` INT( 50 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 50 ) UNSIGNED NOT NULL DEFAULT '0',
`chars` SMALLINT( 6 ) UNSIGNED NOT NULL DEFAULT '0',
)";]]></installcode>

Also, you should keep a copy of your older version of Guess the Word posted since you have an "alter table" query in there. I had to dig mine up, which I had not installed. By installing the old version, fixing your new version and installing it -- everything is great!

So you should instruct people to install the old version first or make a new install that doesn't require the old version.

My members will love this. Thanks and great work! :)

[harmor19]

The error has been fixed.

[deezelpope]

Fixed

[harmor19]

Trying again...

Is there supposed to be a box like in your screenshot? Cuz there isn't.:(

EDIT: Got the same error message...

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * FROM guessword WHERE userid='2';

MySQL Error : Table 'forum.guessword' doesn't exist
Error Number : 1146
Date : Wednesday, March 21st 2007 @ 03:29:01 PM

Got this one when I tried to un=install


Database error in vBulletin 3.6.4:

Invalid SQL:
DROP TABLE `guessword`;;

MySQL Error : Unknown table 'guessword'
Error Number : 1051
Date : Wednesday, March 21st 2007 @ 03:56:14 PM
Script :

In the last version I made the mistake of dropping the same table twice.
Go to your Product Manager and click "Go" to the right of 'Edit'.
Remove the uninstall code in 1.0.1
$db->query_write("DROP TABLE `" . TABLE_PREFIX . "guessword`;");
After that is deleted upload the attached file then you can uninstall both products.

[deezelpope]

Oh, thank you! Do you think I should try installing your game again? I really want this...my friends just LOVE hangman-type games?:D :up:

[deezelpope]

Andrew, all is forgiven!! It works!!! Yaaaaay!!!! You've just made this little girl VERY happy!!! Thank you, thank you!!!:up: :up: :up: :D

[harmor19]

Andrew, all is forgiven!! It works!!! Yaaaaay!!!! You've just made this little girl VERY happy!!! Thank you, thank you!!!:up: :up: :up: :D

If you haven't found out you have to click on the area where the word appears to bring up the input box.

[deezelpope]

Yes, I tried it!! Was kinda nervous after everything, ya know. The green box showed up!! I'm so relieved!! Thank you again!!:up: :D

[deezelpope]

Do permissions need to be changed or anything? Cuz all we get is 'that is incorrect'...*scratches head*

[harmor19]

Make sure there are no spaces between the letters and all the letters capitalize any letters you made capitalized in the admincp --> Guess The Word settings

What is your site and the word?

[deezelpope]

I'll PM you that info, if it's ok with you.;)

[deezelpope]

Thank you for all your help, Harmor19! Coming over to my site to check out the game was very thoughtful and kind! Much appreciated!:up:

[FreshFroot]

might try this.. looks kinda fun :D

[Carlos2]

Friend, can you make working Hangman with 3.6.6? I liked it a lot, but i cant.

[yourhome]

it caused errors on our forum as well..had to remove it..got any ideas what is wrong?

[almightyone]

it caused errors on our forum as well..had to remove it..got any ideas what is wrong?

you need to post the errors so someone can help you out if noone knows your error how can they help?

[mmmender]

I installed this but when I click on the word area I don't get the green input box.

Any suggestions?

[TheBlackPoet]

looks fun.. installed

[mmmender]

I installed this but when I click on the word area I don't get the green input box.

Any suggestions?
UNINSTALLED

[anama]

I really like this game, and my users too , but only worked for 2 days, I do not know what happen but now is dead , the letters do not show up after you post.

Any help, please?