vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Mini Mods - Guess The Word (Game) [AJAX] (https://vborg.vbsupport.ru/showthread.php?t=137915)

deezelpope 03-12-2007 02:38 PM

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

deezelpope 03-15-2007 02:09 PM

Quote:

Originally Posted by harmor19 (Post 1170410)
This was a quick hack. If you have any suggestions I'd appreciate it.

Resolved

adwade 03-16-2007 12:36 PM

Quote:

Originally Posted by harmor19 (Post 1170410)
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 03-20-2007 04:21 AM

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 03-21-2007 05:03 AM

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 03-21-2007 05:46 AM

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 03-21-2007 06:05 AM

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 03-21-2007 07:33 AM

The error has been fixed.

deezelpope 03-21-2007 02:22 PM

Fixed

harmor19 03-21-2007 05:41 PM

Quote:

Originally Posted by deezelpope (Post 1208829)
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
Code:

$db->query_write("DROP TABLE `" . TABLE_PREFIX . "guessword`;");
After that is deleted upload the attached file then you can uninstall both products.


All times are GMT. The time now is 02:00 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01300 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete