Nice package dharmil ... a good combination of all released punbb arcade mods. thx ...

You can test my modification here. User=punbb PW=test, You can use the arcade games after clicking on "Forum" on the portal page.

Btw, there is another modification of this mod on: http://www.punres.org/viewtopic.php?pid=6091#p6091.
Give it a try ...

My mistake!!
There are missing coma´s in the query of the first games between the thumb picture and the game dimension.

wrong:
INSERT INTO `jeux` VALUES (2, 'Easter Egg Catch', 'eastercatch', 'Move the bunny and catch the falling eggs. If the bunny is holding five eggs put the eggs in the basket. Avoid ROTTEN EGGS. They will make you drop your eggs. Catch CHOCOLATE RABBITS for more speed.', 'eastercatch.jpg' '550', '400');

correct:
INSERT INTO `jeux` VALUES (2, 'Easter Egg Catch', 'eastercatch', 'Move the bunny and catch the falling eggs. If the bunny is holding five eggs put the eggs in the basket. Avoid ROTTEN EGGS. They will make you drop your eggs. Catch CHOCOLATE RABBITS for more speed.', 'eastercatch.jpg', '550', '400');

I´ve tested only all german query´s. Some of the english query are messed up.  Sorry ...

All query´s are now ok. Download Links updated.

rednapx wrote:

Hi people, i really need your help smile

I'm trying to install the mod on my forum, but when i execute the query for add a game, i get this error:

#1136 - Column count doesn't match value count at row 1 

What can i do?
Thanks in advance.

Did you install the original mod or my modification mod?

Btw, I´ve updated the mod again with small adjustments. See above ...

dharmil wrote:

Nice More games(there is only one problem with more games it makes a hige page i thing we should pages now like display 10 games per page

I agree! We need help from a programer.  Maybe nico_somb must help.

This would sort all topics but I need it only for one forum.

dharmil wrote:

i Also think some one who is a probgamer should work on creating a high score box that shows the top high scores...

yes, that would be a nice feature.

A small update:
- added language definition files for english, german and french
- added username and highscore for each game to the game index page
- added two tables "width" and "height" for the correct game dimensions.
- changed the data type of the table "clsst_score" from int to double , cause some games need decimal places
- changed some links. Now a new highscore is directing to the highscore page.
- added paging links (10 games each page, you can adjust the limited numbers of games for a page in arcade.php.)
- some small optical adjustments

Arcade mod and some games. (1,8 MB)

43 games for this mod! (17,8 MB)
English and German descriptions for each game included. 

Query files only for the messed up old download links:  Arcade mod query , Game addon query

You can test it here , User= punbb PW=test. Just klick on "Forum" after login to see the arcade games.

Have fun ...

dharmil wrote:

nice and when is this pacage expected to come out

--> today! <--  :-)

dharmil wrote:

I have added the Change Check it out

http://forum1.dharmil.info/

good job

Nice forum ...
I´ve made more games to run with this mod. (The complete YETISPORTS collection :-) )
Only a few tests and I make a new package.

I agree, sorry for the mistake.  It was late that day ... :-)

Ok, fixed it now and added a newdownload link. I also added language definition files for english, french and german.

Well, this is a translated english version of the "Arcade Game" mod. Over 40 good games are included!
I´ve edited all games by hand and adapted all for this mod. All games are working.  :-)

First: Make backups and read the info.txt inside the archive.
You have to create the tables and add the games to your database by hand. Sorry, I´m not a programmer ...

I´ve made the following changes:
- added the original game dimensions, so they are displayed correctly
- added the name of the user with the highscore to the game index

Again a big thanx to nico_somb, he has adapted this mod for punbb!

I´ll make a new package with more modified games for this mod.

A big thank to nico_somb for this first beta release. I like it very much.

Here are a few improvement suggestions:
- translated mod into other languages (english, german, russian)
- The possibility  to add the image dimensions of the games into the database, so the games are displayed corectly
- Add the name of the user with the highscore to the index game page
- Add an administration panel

I´ve made some changes by myself, but I´m not a programmer. It´s better a more experienced programmer do that.  :-)

Here are some more:

http://www.ibparcade.com/
http://forumarcades.com/dn/
http://www.ibpdownloads.com
http://www.teamwolfpack.org/
http://www.gaming-heaven.com/
http://www.invisionsportsarcade.com/
http://www.anubistemple.net/gaming/
http://ibpextra.jordanpardy.com

But this games are not working with this mod. You must modify the games ...

dharmil wrote:

i tryed it i cant do it um do you have the ggames uploaded on the web if you do can you just give me the links and i can download them?

Here are some games for this mod.

dharmil wrote:

where do i get more game for the mod like you sAID YOU DID

I´ve self-made changes to the games. You have to edit the swf games (for example with Sothink SWF Quicker) and insert some code into the place where the score is submitted.

For example:

if (score > 0)
{
    score = score;
    game_name = "invaders";
    getURL("newscore.php", "_self", "POST");
}
score = 0;

I´ve found another error after sending the highscore  to newscore.php : Error: 1265 SQLSTATE: 01000  (ER_WARN_DATA_TRUNCATED)
Maybe this problem is only on my MySql version , I don´t know, I´m not a programmer ...

But I´ve found a way to fix it. 

Edit newscore.php and find:

$sql = 'SELECT * FROM '.$db->prefix.'classement WHERE clsst_joueur = "'.$pun_user['id'].'" AND clsst_jeu = "'.$game_name.'"';

change to:

$sql = 'SELECT * FROM '.$db->prefix.'classement WHERE clsst_joueur = '.$pun_user['id'].' AND clsst_jeu = "'.$game_name.'"';

find:

$sql = 'UPDATE '.$db->prefix.'classement SET clsst_score = "'.$score.'" WHERE clsst_joueur = "'.$pun_user['id'].'" AND clsst_jeu = '.$game_name.'"';

change to:

$sql = 'UPDATE '.$db->prefix.'classement SET clsst_score = '.$score.' WHERE clsst_joueur = '.$pun_user['id'].' AND clsst_jeu = "'.$game_name.'"';

find:

$sql = 'INSERT INTO '.$db->prefix.'classement (clsst_jeu, clsst_joueur, clsst_score) VALUES ("'.$game_name.'", "'.$pun_user['id'].'", "'.$score.'")';

change to:

$sql = 'INSERT INTO '.$db->prefix.'classement (clsst_jeu, clsst_joueur, clsst_score) VALUES ("'.$game_name.'", '.$pun_user['id'].', '.$score.')';

Think the problem was the difference between the variable INTEGER and CHAR ...

Btw, I like this mod. :-)

-- There is another thread on Punre.org , I´ve posted there too --

Nice Mod!

But  I´ve had to change something, now its working for me.
Here is wat I´ve changed:


CREATE TABLE `classement` (
  `clsst_id` int(11) NOT NULL auto_increment,
  `clsst_jeu` varchar(50) NOT NULL default '0',
  `clsst_joueur` int(11) NOT NULL default '0',
  `clsst_score` int(11) NOT NULL default '0',
  PRIMARY KEY  (`clsst_id`)
) ENGINE=MyISAM  ;


CREATE TABLE `jeux` (
  `jeux_id` int(11) NOT NULL auto_increment,
  `jeux_name` varchar(50) NOT NULL default '',
  `jeux_fichier` varchar(50) NOT NULL default '',
  `jeux_desc` text NOT NULL,
  `jeux_img` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`jeux_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 ;

... I´ve changed TYPE to ENGINE , becaus my MySQL server said so  :-)
also the table name must be jeux and classement and not pun_classement and pun_jeux like describe in lisez_moi.txt.

INSERT INTO `jeux` VALUES (1, 'Dolphin Dash', 'dolphindash', 'Récoltez le plus de pièces possibles dans un temps limité!', 'dolphindash.gif');
INSERT INTO `jeux` VALUES (2, 'La course aux oeufs', 'eggs', 'Ramassez le plus d''oeufs qui tombent en évitant de faire des omelettes...!', 'oeufs.jpg');
INSERT INTO `jeux` VALUES (3, 'Shootez les pingouins!', 'penguin_arcade', 'Armé d''un "icegun", vous devez congeler un max de pingouins!', 'pingouin.jpg');
INSERT INTO `jeux` VALUES (4, 'Snowboard', 'snowboarding', 'Chaussez votre planche et descendez le plus vite possible! N''oubliez pas de slalomer entre les portes...', 'snowboard.jpg');
INSERT INTO `jeux` VALUES (5, 'Snake', 'snakeneave', 'Le traditionnel jeu du Serpent, rendu célèbre par les téléphones portables... Ici, trois niveaux de difficulté!', 'serpent.jpg');

... I also have changed the table name pun_jeux  to jeux here.

Sounds great!

What can I do to fix this?

Yep, need it too.

How can I add an option "sort alphabetical" into the AM module "Forums"?

Hi,
need help. Cant install the mod. Error:

File: Array
Line:

PunBB reported: Unable to alter the config table

Running MySql 4.19 Server, Client 5.0
Php 5.0.3
PunBB 1.2.11

98

(2 replies, posted in Feature requests)

Ok, thats a solution but it would be nice to see the ids in the Forums-AM.

99

(2 replies, posted in Feature requests)

First, I love PunBB!  :-)

Ok, here is my request.
It would be useful to add the forum id into the "Forums" administration module.

There are some mods out which need to add forum ids in the configuration.