-:[GAME]:- Battleships

[Coroner]

What is it ?
Another game for your vBulletin. I wrote it in 2004 for vB2.x,3.0 - 3.5 and also for all wBB versions (not wBB 3.0). Now in 2011 it's also availiable for vBulletin 4.

Play against other User or against the computer. Animated graphix (gif) and sounds (work best on IE).

Attention:
This Mod uses my new Stylebridge ! All templates in this Mod are vB3.8 templates.

It's not allowed to remove the Copyright !!!

And sorry ... I haven't time for support at the moment

[Coroner]

Installation:
- Upload all files to you forum-root
- Install the product
- set the Userrights

You will find all settings under "Options" in the AdminCP

[starman?]

Any instructions Coroner please?

[WEBDosser]

works great.. intro a bit long but thanks :)

[loovie]

it works perfect....:up:

[Krusty1231]

Nifty - thanks.

[Emeralda]

That was awkward. First I had to manually enter the adress, because no link was to be found anywhere. Then I'm getting this message:

http://img215.imageshack.us/img215/9404/85320c8802da4de4a142f46.png

[Merjawy]

That was awkward. First I had to manually enter the adress, because no link was to be found anywhere. Then I'm getting this message:



Go to your usergroup and give your self permission.. I had to find out the hard way

[sadaar]

I altered all the TYPE= to ENGINE= to fix the depreciated syntax but still get the following error any assistance would be appreciated:

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT * FROM battleships_user WHERE userid=1;

MySQL Error : Table 'ttnb_production.battleships_user' doesn't exist
Error Number : 1146
Request Date : Saturday, February 11th 2012 @ 11:38:17 PM
Error Date : Saturday, February 11th 2012 @ 11:38:17 PM
Script : http://forum.sadaar.com/battleships.php
Referrer :
IP Address : xxxxxxxxxx
Username : Sadaar
Classname : vB_Database_MySQLi
MySQL Version : 5.5.20-cll

[CoZmicShReddeR]

No issues installing it here using 4.1.0 dropped the files on the server and imported the product-battleships (english Master).xml

Had to set each usergroup to allow access..

It is a really neat idea just did not like the idea that each turn reloads the entire webpage...

[Emeralda]

Dunno, for some reason I couldn't use the chat there, but the other member could. For the game itself, the rules say you can't have ships next to each other, but this version of the game clearly ignores this rule.

[Hippy]

this mod is great ..
is there anyway to add if the player was playing the computer or a member in the stats?

thanks for providing this for vb.org members

[Hippy]

in battleships / battleships_game.php
look for
< -- german
$gogameoption .= "<option value=\"".$gameids[$i]."\">".$gameplayers[$i]." wartet auf einen Mitspieler</option>";


and change to
--- english fix
$gogameoption .= "<option value=\"".$gameids[$i]."\">".$gameplayers[$i]." is waiting for an opponent</option>";<

;)

[sadaar]

Uninstalled - no assistance for error. Unfortunate, seemed like a really cool mod :(

[sadaar]

[edit]

[Hippy]

what errors ..

[sadaar]

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT * FROM battleships_user WHERE userid=1;

MySQL Error : Table 'ttnb_production.battleships_user' doesn't exist
Error Number : 1146
Request Date : Saturday, February 11th 2012 @ 11:38:17 PM
Error Date : Saturday, February 11th 2012 @ 11:38:17 PM
Script : http://forum.sadaar.com/battleships.php
Referrer :
IP Address : xxxxxxxxxx
Username : Sadaar
Classname : vB_Database_MySQLi
MySQL Version : 5.5.20-cll

[otttto]

Is working on 4.1.12 thanks.
Firefox ask for Plugin, can you tell me the Plugin Name ?

Thanks

[Hippy]

never asked me for any plugin..
if ff ever says I need a plugin it will direct you to it..

weird

[goarack]

same problem as sadaar
uninstalling

[Hippy]

still working with the latest vb4.2 pl3

[andyv72]

still working with the latest vb4.2 pl3

not really....

[goarack]

is this like a game of battleship ?

[gundelpfanne]

Hello

I have fixed the sql code.
It works for me.
I have no sound in the game , but I do not know why.
Open the " product-battleships (deutsche Master).xml or the english version"
Delete the old code from:

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


to the last:
) TYPE=MyISAM;");

And paste the new code from me .


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

CREATE TABLE IF NOT EXISTS `battleships_game` (
`gameid` int(11) NOT NULL default '0',
`player1` int(11) NOT NULL default '0',
`player2` int(11) NOT NULL default '0',
`maxpl` int(11) NOT NULL default '0',
`turn` int(3) NOT NULL default '1',
`steps` int(11) NOT NULL default '0',
`stime` int(11) NOT NULL default '0',
`showend` int(3) NOT NULL default '0',
`aishoot` text NOT NULL,
`aiboat1` int(3) NOT NULL default '0',
`aiboat2` int(3) NOT NULL default '0',
`aiboat3` int(3) NOT NULL default '0',
`aiboat4` int(3) NOT NULL default '0',
`aiboat5` int(3) NOT NULL default '0',
`pl1matrix` text NOT NULL,
`pl2matrix` text NOT NULL,
`pl1matrix2` text NOT NULL,
`pl2matrix2` text NOT NULL,
`player12` int(11) NOT NULL default '0',
`player13` int(11) NOT NULL default '0',
`player14` int(11) NOT NULL default '0',
`player15` int(11) NOT NULL default '0',
`player22` int(11) NOT NULL default '0',
`player23` int(11) NOT NULL default '0',
`player24` int(11) NOT NULL default '0',
`player25` int(11) NOT NULL default '0',
`scorepl1` int(11) NOT NULL default '0',
`scorepl2` int(11) NOT NULL default '0',
`playhit` int(3) NOT NULL default '0',
`booom` int(3) NOT NULL default '0',
`booompos` int(3) NOT NULL default '0',
`gameover` int(3) NOT NULL default '0'
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `battleships_highscore` (
`place` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`score` int(11) NOT NULL default '0',
`rankpoint` int(3) NOT NULL default '0',
`rank` varchar(50) NOT NULL default '',
`bstart` int(11) NOT NULL default '0',
messi text NOT NULL
)ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `battleships_message` (
`mesid` int(11) NOT NULL default'0',
`userid` int (11) NOT NULL default '0',
messi text NOT NULL

) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `battleships_user` (
`gameid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`player` int(11) NOT NULL default '0',
`setok` int(3) NOT NULL default '0',
`gonow` int(3) NOT NULL default '0',
`watershoot` int(5) NOT NULL default '0',
`boomshoot` int(5) NOT NULL default '0',
`checkit` int(3) NOT NULL default '0'
) ENGINE=MyISAM;