Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in /homepages/34/d258180810/htdocs/phpAR/viewtopic.php on line 954

Strict Standards: getdate(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in /homepages/34/d258180810/htdocs/phpAR/viewtopic.php on line 954
[phpBB Debug] PHP Notice: in file /includes/session.php on line 2088: Array to string conversion
[phpBB Debug] PHP Notice: in file /includes/session.php on line 2088: Array to string conversion
[phpBB Debug] PHP Notice: in file /includes/session.php on line 2088: Array to string conversion
[phpBB Debug] PHP Notice: in file /includes/session.php on line 2088: Array to string conversion
[phpBB Debug] PHP Notice: in file /includes/session.php on line 2088: Array to string conversion
[phpBB Debug] PHP Notice: in file /includes/session.php on line 2088: Array to string conversion
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3778: Cannot modify header information - headers already sent by (output started at /viewtopic.php:954)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3780: Cannot modify header information - headers already sent by (output started at /viewtopic.php:954)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3781: Cannot modify header information - headers already sent by (output started at /viewtopic.php:954)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3782: Cannot modify header information - headers already sent by (output started at /viewtopic.php:954)
Arcade Room • View topic - [REQ] Allow arcade to submit negative values
Page 1 of 1

[REQ] Allow arcade to submit negative values

PostPosted: Sat Oct 25, 2008 2:28 pm
by Gleasonator
Sometimes a game will have a final score of a positive or a negative number. An example is here: http://gleasonator.com/forums/viewgame.php?g=128

It is actually pretty rare to get a negative score in the game, but because it's possible the user should be able to submit the score is he/she wants to. Right now if a negative value is submitted to the arcade, this error is returned:

General Error

SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'highscore' at row 1 [1264]

SQL

INSERT INTO phpbb_ar_highscores (highscore_game, highscore_user, highscore) VALUES (game ID, 'user ID', '-#')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: viewgame.php
LINE: 189
CALL: dbal_mysql->sql_query()

Re: [REQUEST] Allow arcade to submit negative values

PostPosted: Sat Oct 25, 2008 9:58 pm
by patrikStar
ok i took a quick look into this and its because the highscores table has the column set to UNSIGNED

Code: Select all
ALTER TABLE `phpbb_ar_highscores` CHANGE `highscore` `highscore` DOUBLE( 21, 1 ) NOT NULL

that should take off the unsigned part of the column

fixed in 0.6.9c