Add-On Releases - -:[GAME]:- Sudoku 2009

What is it ?
It's another game for your vBulletin called Sudoku. You don't know what a Sudoku is ? try GOOGLE.

Does it works with vBcredits / vBbux ?
Yes of course. The game will automatically detect if one of those mods are installed (see image no.4).

How does it works ?
You can choose between 4 different levels (easy, middle, hard and evil). For each sudoku, you will get a time (those are also the points) - see image no. 4. Each seconds the score will decrase by 1.
Each mistake will cost you 100 points (default setting).
The goal is to finish the sudoku as fast as you can. A started Sudoku MUST be finished !

This game used 3rd party routines from:

 * Copyright by Frieder Kesch
 * http://sudokucheater.ikesch.de
 * 
 * License:   GNU General Public License 2 (GPL 2) or later

Support is given for anyone who clicked "installed"

Cheers
Coroner

[Hornstar]

I have PHP unlimited showing up, and under that I have only Sudoku 2009. I click on that, but it only shows me the settings and nothing for the vbplaza credits which it should be detecting automatically since I have vbplaza installed.

2nd. I have memebrs saying the look is weird and confusing. It needs to be made more square they say, as it is too rectangle and confusing.

[Coroner]

For the "rectagle" you can change the template "sudoku_play"

search for:

$sudokufield

and change it into:

      <table cellpadding="0" cellspacing="0" border="0" style="width:600px">
       <tr>
        <td class="alt2">$sudokufield</td>
       </tr>
      </table>

I don't know, why no "credit settings" avaible - I have only vbplaza installed and it works

[ArnyVee]

I can't wait for this one and for the Wordfinder to be working great!

They should be really fun games to add to my site

[RichieBoy67]

Great mod! Nice and easy install and seems to work flawlessly so far...

Nice addition to any website!

Thanks

[forum4]

OK, had to install this one to. Never played this game till now. Love it! The above code works great to and makes it much easier to play.

Well, if I had to create this in German, I'd sure have a lot of spelling and grammar issues to.

Ich spreche Deutsch aber nicht so gut!

Thank you!

[djilou]

there are no query to create tables guthaben and guthaben_shop_preise

<installcode><![CDATA[
				$db->hide_errors();

				$db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `sudokupermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");
				$db->query("ALTER TABLE `" . TABLE_PREFIX . "administrator` ADD `customsudokupermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");

				$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku` INT(11) NOT NULL DEFAULT '0'");
				$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku_pay` INT(11) NOT NULL DEFAULT '0'");
				$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku_get` INT(11) NOT NULL DEFAULT '0'");
				$db->query("INSERT INTO `" . TABLE_PREFIX . "guthaben_shop_preise` (`name`,`pvar1`,`pvar2`) VALUES ('guthaben_shop_sudoku_pay','\$guthaben[sudoku_pay]','\$guthaben[sudoku]')");
				$db->query("INSERT INTO `" . TABLE_PREFIX . "guthaben_shop_preise` (`name`,`pvar1`,`pvar2`) VALUES ('guthaben_shop_sudoku_get','\$guthaben[sudoku_get]','\$guthaben[sudoku]')");

				$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_config;");
				$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_config (
			  	subsend  int(11) NOT NULL default '100',
				  plevel1  int(11) NOT NULL default '2000',
				  plevel2  int(11) NOT NULL default '3500',
				  plevel3  int(11) NOT NULL default '5000',
				  plevel4  int(11) NOT NULL default '8000',
		  		postings int(4) NOT NULL default '0',
				  guthaben int(11) NOT NULL default '0',
				  month    int(11) NOT NULL default '30',
			  	pay      int(4) NOT NULL default '0',
			  	betrag   int(4) NOT NULL default '0'
				) TYPE=MyISAM;");
				$db->query("INSERT INTO " . TABLE_PREFIX . "sudoku_config (betrag) VALUES (0)");

				$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_user;");
				$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_user (
				  userid   int(11) NOT NULL default '0',
				  ingame   int(2) NOT NULL default '0',
		  		level    int(2) NOT NULL default '0',
					pgame    text NOT NULL,
					ogame    text NOT NULL,
			  	score    int(11) NOT NULL default '0',
			  	time     int(11) NOT NULL default '0',
				  endtime  int(11) NOT NULL default '0',
				  mistakes int(4) NOT NULL default '0'
				) TYPE=MyISAM;");

				$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_highscore;");
				$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_highscore (
				  userid   int(11) NOT NULL default '0',
			  	level    int(2) NOT NULL default '0',
				  score    int(11) NOT NULL default '0',
			  	playtime int(11) NOT NULL default '0',
				  mistakes int(4) NOT NULL default '0'
				) TYPE=MyISAM;");

				$db->show_errors();
			]]></installcode>

[Coroner]

I know it, but it's needed for the german ones (me, too)

[djilou]

But we need guthaben_shop_preise table to see the "Credit Settings" In AdminCP, no?

[Coroner]

No. "Shop Preise" eng. Shop Prices is needed for the german Mod, to see what cost how much.

For vBCredits or vBplaza there are two (hidden) options.

1st.) is this mod installed and not disabled
2nd.) is it enabled

[skol]

Nice game,one problem when i complete a game on the hard level,it wont submit to highscore.
I have to press cancel..as it does nothing.