Sudoku MOD 2.5.2 (phpbb2 engine!)

форум посвящен дальнейшим разработкам базового мода SUDOKU

Moderator: el_teniente

Postby sputum on Fri Aug 10, 2007 8:52 am

allo!



My Users told me that there is an mistake in the second ninja Puzzle, in the right corner....Can someone confirm this?!
sputum
Новобранец
 
Posts: 13
Joined: Mon Jul 23, 2007 7:42 pm
Gender: Male
Country: Austria

Postby el_teniente on Fri Aug 10, 2007 9:35 am

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 winkk:::



till then, me and future players would appreciate those users who send me the screenshots of the "mistakeful" places to fix winkk:::
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4282
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby elmexo on Fri Sep 28, 2007 12:50 pm

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'




помогите решить проблему
elmexo
Новобранец
 
Posts: 18
Joined: Thu Sep 27, 2007 11:46 pm
Gender: None specified
Country: Estonia

Postby el_teniente on Fri Sep 28, 2007 1:02 pm

а самом деле все в порядке---база данных не позволила дублировать уже существующие поля, поскольку ставилось поверх, но единственное что надо сделать это обновить версии следующими запросами:
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';
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4282
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby elmexo on Fri Sep 28, 2007 1:15 pm

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

elmexo
Новобранец
 
Posts: 18
Joined: Thu Sep 27, 2007 11:46 pm
Gender: None specified
Country: Estonia

Postby el_teniente on Fri Sep 28, 2007 1:19 pm

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


а чё там уметь? надо скопировать запросы в окошко SQL открытой базы форума в phpMyAdmin и нажать кнопочку ОТПРАВИТЬ)
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4282
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby elmexo on Fri Sep 28, 2007 1:23 pm

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
Новобранец
 
Posts: 18
Joined: Thu Sep 27, 2007 11:46 pm
Gender: None specified
Country: Estonia

Postby elmexo on Fri Sep 28, 2007 1:25 pm

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

elmexo
Новобранец
 
Posts: 18
Joined: Thu Sep 27, 2007 11:46 pm
Gender: None specified
Country: Estonia

Postby el_teniente on Fri Sep 28, 2007 1:25 pm

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


надо открыть базу и SQL кликнуть не левый, а центральный)
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4282
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby femu on Mon Oct 01, 2007 5:37 am

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
Attachments
sudoku_error.txt
(2.36 KB) Downloaded 704 times
femu
Мастер-ковбой
Мастер-ковбой
 
Posts: 84
Joined: Sat May 19, 2007 8:15 pm
Gender: Male
Country: Germany

Postby el_teniente on Mon Oct 01, 2007 10:17 am

$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 roll:::
Last edited by el_teniente on Mon Oct 01, 2007 4:01 pm, edited 1 time in total.
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4282
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby femu on Mon Oct 01, 2007 2:49 pm

el_teniente wrote:$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!



el_teniente wrote:and sorry, not all russians can write in English roll:::




That's true. Surely more Russians, that can speak English, than other speaking Russian. But maybe a good chance to learn a little bit ;-)
femu
Мастер-ковбой
Мастер-ковбой
 
Posts: 84
Joined: Sat May 19, 2007 8:15 pm
Gender: Male
Country: Germany

Postby CemetaryMan on Wed Dec 12, 2007 6:20 am

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.
CemetaryMan
Новобранец
 
Posts: 3
Joined: Wed Dec 12, 2007 6:15 am
Gender: None specified
Country: United States

Postby el_teniente on Wed Dec 12, 2007 6:40 am

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 :smt023
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4282
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby CemetaryMan on Wed Dec 12, 2007 6:52 am

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

:twisted:
CemetaryMan
Новобранец
 
Posts: 3
Joined: Wed Dec 12, 2007 6:15 am
Gender: None specified
Country: United States

PreviousNext

Return to Sudoku MOD

Who is online

Users browsing this forum: No registered users and 1 guest


Page generation time 0.08 sec (PHP: 62% - SQL: 38%) - DB queries 28 - Peak memory usage 3.62 MB
cron