Problem with week points sudoku_weekly_cron.php

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

Moderator: el_teniente

Problem with week points sudoku_weekly_cron.php

Postby sile on Wed Aug 08, 2007 4:05 pm

i el_teniente

I am not sure but i have no PN this week for points, also the best user of sudoku, sukoku samurai and sudoku ninja.



I have this copy by you smile:::



By you of russisch



Установлены еженедельные призы!

Установлены еженедельные призы за 1,2 и 3 место в очках 1000, 500 и 200 Points, а также специальные призы активных игроков: внимательность+терпение за наивысшую результативность - 1500 Points и энергичность+упорство за количество сыгранных игр - 700 Points! Спешите играть!



an you help me please smile:::

User avatar
sile
Кольт-поручик
Кольт-поручик
 
Posts: 174
Joined: Wed Apr 25, 2007 6:15 pm
Gender: Female
Country: Switzerland

Postby CHARLIE on Wed Aug 08, 2007 4:05 pm

hat's nice. I have a lofty goal.

Bots are much wiser than the most of the humans
User avatar
CHARLIE
Шеф-ковбой
Шеф-ковбой
 
Posts: 121
Joined: Sat Mar 04, 2006 4:29 pm
Location: PC
Gender: Male
Country: United States

Postby Fred on Wed Aug 08, 2007 4:23 pm

udoku_weekly_cron.php

2.5.0 seems not to be working for me online

Code: Select all
if (!$board_config['sudoku_cron_last_time'])

{

$sql= "UPDATE ".CONFIG_TABLE." SET config_value = ".time()." WHERE config_name='sudoku_cron_last_time' ";

if(!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, 'Error updating board config' , '', __LINE__, __FILE__, $sql);

$board_config['sudoku_cron_last_time'] = time();

}

   $sql = "SELECT config_value FROM  " . CONFIG_TABLE ." WHERE config_name='sudoku_cron_last_time'";

if(!$result = $db->sql_query($sql)) message_die(CRITICAL_ERROR, 'Error Getting config!', '', __LINE__, __FILE__, $sql);

$row = $db->sql_fetchrow($result);

$board_config['sudoku_cron_last_time'] = $row['config_value'];

if(time() - $board_config['sudoku_cron_last_time'] > $board_config['sudoku_cron_time'])

{





changing to this



Code: Select all
if (!$board_config['sudoku_cron_last_time'])

{

$sql= "UPDATE ".CONFIG_TABLE." SET config_value = ".time()." WHERE config_name='sudoku_cron_last_time' ";

if(!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, 'Error updating board config' , '', __LINE__, __FILE__, $sql);

$board_config['sudoku_cron_last_time'] = time();

}



if(time() - $board_config['sudoku_cron_last_time'] > $board_config['sudoku_cron_time'])

{

//Set new time   

$new_time = $board_config['sudoku_cron_last_time'] +  $board_config['sudoku_cron_time'];

   $sql= "UPDATE ". CONFIG_TABLE . "

   SET config_value = $new_time

   WHERE config_name = 'sudoku_cron_last_time' ";

if(!$result = $db->sql_query($sql))

      {

         message_die(GENERAL_ERROR, 'Error updating config' , '', __LINE__, __FILE__, $sql);

      }





seems to be working better. (part is from 2.1.6)
Last edited by Fred on Wed Aug 08, 2007 4:24 pm, edited 1 time in total.
Fred
Новобранец
 
Posts: 10
Joined: Thu Apr 12, 2007 10:58 pm
Gender: None specified
Country: Germany

Postby el_teniente on Wed Aug 08, 2007 4:24 pm

re you sure that you have sudoku_weekly_cron.php been replaced by the updated one?



and i need the dump of you prefix_sudoku_stats. table



in you test board everytnig was OK winkk:::
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4283
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby sile on Wed Aug 08, 2007 4:28 pm

ts o.k only for one houre smile:::

I test this 3 time in my testboard but only with 1 houre



But not for a week sad:::
User avatar
sile
Кольт-поручик
Кольт-поручик
 
Posts: 174
Joined: Wed Apr 25, 2007 6:15 pm
Gender: Female
Country: Switzerland

Postby sile on Wed Aug 08, 2007 5:02 pm

have send the dump of my prefix_sudoku_stats. table to you per PN smile:::

User avatar
sile
Кольт-поручик
Кольт-поручик
 
Posts: 174
Joined: Wed Apr 25, 2007 6:15 pm
Gender: Female
Country: Switzerland

Postby el_teniente on Wed Aug 08, 2007 9:55 pm

Fred wrote:sudoku_weekly_cron.php

2.5.0 seems not to be working for me online


this is very strange :shock:

anyway sudoku_weekly_cron.php 2.5.0 is updated in all packages with semi-old variant ;-)
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4283
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby sile on Thu Aug 09, 2007 6:08 am

ood morning el_teniente

So now i have a blackout sad:::



Please what for a sudoku_weekly_cron.php must i take.



From the new 2.5.0?



I dont now what i make now, can you hlep me please smile:::
User avatar
sile
Кольт-поручик
Кольт-поручик
 
Posts: 174
Joined: Wed Apr 25, 2007 6:15 pm
Gender: Female
Country: Switzerland

Postby el_teniente on Thu Aug 09, 2007 7:38 am

sile wrote:From the new 2.5.0?


yes---the package is updated
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4283
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby sile on Thu Aug 09, 2007 8:21 am

lso then i can take this sudoku_weekly_cron.php from the pack of 2.50.



lso the newest http://vfalcone.ru/forum/viewtopic.php?t=380



And then the last 2.5.0 Sudoku_MOD_v.2.5.0.zip "Fresh install

BETA" its the last pack of the site smile:::



Is this all correctly? I want make a mistake winkk:::
User avatar
sile
Кольт-поручик
Кольт-поручик
 
Posts: 174
Joined: Wed Apr 25, 2007 6:15 pm
Gender: Female
Country: Switzerland

Postby Fred on Thu Aug 09, 2007 10:53 am

ake the sudoku_weekly_cron.php from updated Sudoku_MOD_v.2.5.0.zip

and you should be fine.



Nimm die sudoku_weekly_cron.php vom aktualisierten Sudoku_MOD_v.2.5.0.zip und fertig. winkk:::
Fred
Новобранец
 
Posts: 10
Joined: Thu Apr 12, 2007 10:58 pm
Gender: None specified
Country: Germany

Postby el_teniente on Thu Aug 09, 2007 12:29 pm

Fred wrote:Nimm die sudoku_weekly_cron.php vom aktualisierten Sudoku_MOD_v.2.5.0.zip und fertig. winkk:::




Ja-Ja, für die Richtigkeit :smt023 (danke, Genosse Fred)
die hard---live easy
User avatar
el_teniente
Статс-админ
Статс-админ
 
Posts: 4283
Joined: Mon Nov 07, 2005 7:51 pm
Location: Белокаменная
Gender: Male
Country: Russian Federation

Postby sile on Thu Aug 09, 2007 3:35 pm

anke schön smile:::

Also i have take the file from the update pack:



Update from 2.1.6 to 2.5.0.zip
User avatar
sile
Кольт-поручик
Кольт-поручик
 
Posts: 174
Joined: Wed Apr 25, 2007 6:15 pm
Gender: Female
Country: Switzerland

Postby el_teniente on Thu Aug 09, 2007 4:34 pm

sile wrote:Also i have take the file from the update pack:

Update from 2.1.6 to 2.5.0.zip


what for??? they are the same :shock:



as mujeres... roll:::

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

Postby sile on Thu Aug 09, 2007 4:46 pm

lso i have the right file up of my gameboard ImageImage



Image
User avatar
sile
Кольт-поручик
Кольт-поручик
 
Posts: 174
Joined: Wed Apr 25, 2007 6:15 pm
Gender: Female
Country: Switzerland

Next

Return to Sudoku MOD

Who is online

Users browsing this forum: No registered users and 1 guest


Page generation time 0.08 sec (PHP: 75% - SQL: 25%) - DB queries 27 - Peak memory usage 3.56 MB
cron