Mini Mods - Guess The Word (Game) [AJAX]

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

[deezelpope]

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

[deezelpope]

Originally Posted by harmor19

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

Resolved

[adwade]

Originally Posted by harmor19

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

PHP Code:

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

Originally Posted by deezelpope

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.