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

[REQ] Allow arcade to submit negative values

Discuss features or request them here.
Forum rules
put "[REQ]" in front of your post topic to show you are requesting a feature.

[REQ] Allow arcade to submit negative values

Postby Gleasonator » Sat Oct 25, 2008 2:28 pm

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()
User avatar
Gleasonator
VIP
VIP
 
Posts: 39
Cash: 59
Donate
Joined: Wed Sep 17, 2008 10:41 pm

Trophies

gold: 1
silver: 0
bronze: 2

Re: [REQUEST] Allow arcade to submit negative values

Postby patrikStar » Sat Oct 25, 2008 9:58 pm

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
User avatar
patrikStar
Site Admin
Site Admin
 
Posts: 244
Cash: 442
Donate
Joined: Tue Sep 16, 2008 8:17 am
Location: Phoenix, AZ

Trophies

gold: 5
silver: 4
bronze: 2


Return to Features

Who is online

Users browsing this forum: No registered users and 1 guest

cron