Sudoku MOD 2.5.2 (phpbb2 engine!)

[sputum]

allo!



My Users told me that there is an mistake in the second ninja Puzzle, in the right corner....Can someone confirm this?!

[el_teniente]

t's not mistake but a little variant of multiple solution



ater i'm planning to run some validation script that will solve all puzzles to find if they have variants of multiple solution next to intersections, but that will demand all server resources and server is busy now



anyway those so called "mistakes" are not critical



till then, me and future players would appreciate those users who send me the screenshots of the "mistakeful" places to fix

[elmexo]

Code: Select all

INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'sudoku_version', '2.5.0' )

+++ Error: Duplicate entry 'sudoku_version' for key 1



INSERT INTO `phpbb_config` VALUES('samurai_version', '1.3.2' )

+++ Error: Duplicate entry 'samurai_version' for key 1



INSERT INTO `phpbb_config` VALUES('ninja_version', '1.3.2' )

+++ Error: Duplicate entry 'ninja_version' for key 1



INSERT INTO `phpbb_config` (`config_name` , `config_value` ) VALUES ( 'points_name', 'Points' )

+++ Error: Duplicate entry 'points_name' for key 1



INSERT INTO `phpbb_config` (`config_name` , `config_value` ) VALUES ( 'sudoku_cron_last_time', '')

+++ Error: Duplicate entry 'sudoku_cron_last_time' for key 1



INSERT INTO `phpbb_config` (`config_name` , `config_value` ) VALUES ( 'sudoku_cron_time', '604800')

+++ Error: Duplicate entry 'sudoku_cron_time' for key 1



INSERT INTO `phpbb_config` (`config_name` , `config_value` ) VALUES ( 'board_sudoku','1')

+++ Error: Duplicate entry 'board_sudoku' for key 1



ALTER TABLE `phpbb_users` ADD `user_sudoku_playing` INT( 1 ) DEFAULT '0' NOT NULL

+++ Error: Duplicate column name 'user_sudoku_playing'



ALTER TABLE `phpbb_users` ADD user_points INT(8) NOT NULL DEFAULT '0'

+++ Error: Duplicate column name 'user_points'

помогите решить проблему

[el_teniente]

а самом деле все в порядке---база данных не позволила дублировать уже существующие поля, поскольку ставилось поверх, но единственное что надо сделать это обновить версии следующими запросами:

Code: Select all

UPDATE `phpbb_config` SET config_value = '2.5.0' WHERE config_name= 'sudoku_version';

UPDATE `phpbb_config` SET config_value = '1.3.2' WHERE config_name= 'samurai_version';

UPDATE `phpbb_config` SET config_value = '1.3.2' WHERE config_name= 'ninja_version';

[elmexo]

Это обязательно, просто я в майскл не умею апдейтить базы)

[el_teniente]

...просто я в майскл не умею апдейтить базы)

а чё там уметь? надо скопировать запросы в окошко SQL открытой базы форума в phpMyAdmin и нажать кнопочку ОТПРАВИТЬ)

[elmexo]

Code: Select all

[b]SQL-запрос: [/b]



UPDATE `phpbb_config` SET config_value = '2.5.0' WHERE config_name = 'sudoku_version'



[b]Ответ MySQL:  [/b]

#1046 - No Database Selected

[elmexo]

Все, до меня дошло, что я базу не выбрал, сделал, спасибо

[el_teniente]

... открытой базы форума в phpMyAdmin и нажать кнопочку ОТПРАВИТЬ)

надо открыть базу и SQL кликнуть не левый, а центральный)

[femu]

i el_teniente,



first of all, as I just saw the last postings. Would be great, if everybody in this forum would write in English. So there be hints, which noone else ouside the russian language can read



Ok. We have a little problem (on a friends side), and I have no glue where the error might be. The attached error message comes up after saving the first Ninja game. The highscores are written.



Hopefully you have an idea, what's going wrong.



Thanks and regards,

Felix

[el_teniente]

$play_level variable is missing

if he(she) has an upgrade done---he(she) has some mistake made

open sudoku_ninja.php



find:

Code: Select all

// success!

in both instances the code after must be:

Code: Select all

sudoku_grid_success($pack, $num, $curr_points, $redirect, 0, 1, $statsdata['ninja_play_level'], 'ninja');

there must be the field `ninja_play_level` in the table prefix_sudoku_stats



and sorry, not all russians can write in English

[femu]

$play_level variable is missing

if he(she) have an upgrade done---he(she) have some mistake made

open sudoku_ninja.php



find:

Code: Select all

// success!

in both instances the code after must be:

Code: Select all

sudoku_grid_success($pack, $num, $curr_points, $redirect, 0, 1, $statsdata['ninja_play_level'], 'ninja');

there must be the field `ninja_play_level` in the table prefix_sudoku_stats

Thanks very much. I will check with him!

and sorry, not all russians can write in English

That's true. Surely more Russians, that can speak English, than other speaking Russian. But maybe a good chance to learn a little bit

[CemetaryMan]

finally got around to playing the Ninja today, after finishing the first board. I got the same error as the one above, referring to the error in line 953 in functions_sudoku.php.



I checked the sudoku_ninja.php and those lines are there in both places. any other suggestions to where the fault might be.

[el_teniente]

1)have you v.2.5.0 fresh installed or upgraded from younger version?

2)how does feel sudoku samurai---the same error?



P.S. your nick is great

[CemetaryMan]

1 It is an upgrade from 2.1.6, I checked to see if all the files had been upgraded and they had.

2 I haven't tried the Samurai yet, I will give it a go now and will let you know how that goes.



ic is my Alltime favourite