phpBB.de

Code: Alles auswählen

#-----[ SQL ]------------------------------------------ 
# 

CREATE TABLE phpbb_ina_data (
  version varchar(255) default NULL
) TYPE=MyISAM;

INSERT INTO phpbb_ina_data VALUES ('v1.0.0');

INSERT INTO phpbb_config VALUES ('use_point_system', '0');
INSERT INTO phpbb_config VALUES ('use_gamelib', '1');
INSERT INTO phpbb_config VALUES ('games_path', 'games');
INSERT INTO phpbb_config VALUES ('gamelib_path', 'gamelib');
INSERT INTO phpbb_config VALUES ('use_gk_shop', '0');

CREATE TABLE phpbb_ina_games (
  game_id smallint(5) NOT NULL auto_increment,
  game_name varchar(25) default NULL,
  game_path varchar(255) default NULL,
  game_desc varchar(255) default NULL,
  game_charge int(11) unsigned default '0',
  game_reward int(11) unsigned NOT NULL default '0',
  game_bonus smallint(5) unsigned default '0',
  game_use_gl tinyint(3) unsigned default '0',
  game_flash tinyint(1) unsigned NOT NULL default '0',
  win_width smallint(6) NOT NULL default '0',
  win_height smallint(6) NOT NULL default '0',
  KEY game_id (game_id)
) TYPE=MyISAM;

CREATE TABLE phpbb_ina_scores (
  game_name varchar(255) default NULL,
  player varchar(40) default NULL,
  score int(10) unsigned NOT NULL default '0',
  date int(11) default NULL
) TYPE=MyISAM;

#

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

Incorrect string value: '\xEF\xBF\xBD ai...' for column 'game_desc' at row 1 [1366]

SQL

INSERT INTO phpbb_arcade_games (game_order, game_image, game_desc, game_highscore, game_highdate, game_highuser, game_files, game_name, game_name_clean, game_swf, game_width, game_height, game_installdate, game_scorevar, game_scoretype, game_type, cat_id, game_jackpot, game_filesize) VALUES (12260, 'IceShuffleDR.gif', 'A skill game combining curling and pinball � aim for the targets and watch out for water hazards.! A skill game combining curling and pinball � aim for the targets and watch out for water hazards..', 0, 0, 0, 'a:1:{i:0;s:29:\"arcade/gamedata/IceShuffleDR/\";}', 'Ice Shuffle', 'ice shuffle', 'IceShuffleDR.swf', 580, 430, 1267711909, 'IceShuffleDR', 0, 4, '25', '0', 1745153)

BACKTRACE

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

FILE: includes/arcade/arcade_admin_class.php
LINE: 158
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_arcade_games.php
LINE: 101
CALL: arcade_admin->add_game()

FILE: includes/acp/acp_arcade_games.php
LINE: 45
CALL: acp_arcade_games->add_games()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_arcade_games->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()