 Hallo,
ich habe da mal ein kleines Problem mit dem Arcade-Modul (also das neue).
Ich habe es soweit fertig, habe das Modul einmal deinstalliert und dann nochmal in der Datenbank alle Einträge die mit Arcade zu tun hatten gelöscht.
Dann habe ich das Modul wieder installiert und es gibt Fehler.
Bei der installations installiert er mir nur 4 Tabellen anstatt 6.
(arcade_cats, arcade_games, arcade_scores und arcade_groups_downzip installiert er... arcade_matchpoints und arcade_topflop nicht.)
Bei der deinstallation sagt er mir auch:
Konnte nicht Deinstallieren Punkte-Spiele. Fehler:
- Could not delete table e_xoops_arcade_matchpoints
- Could not delete table e_xoops_arcade_topflop
(is ja auch klar, weil er die ja nicht installiert hat)
Meine Frage ist jetzt: Warum???
In der xoops_version.php habe ich folgendes rein gesetzt:
Code:// SQL
$modversion['sqlfile']['mysql'] = 'sql/mysql.sql';
$modversion['tables'][0] = 'arcade_cats';
$modversion['tables'][1] = 'arcade_games';
$modversion['tables'][2] = 'arcade_scores';
$modversion['tables'][3] = 'arcade_groups_downzip';
$modversion['tables'][4] = 'arcade_matchpoints';
$modversion['tables'][5] = 'arcade_topflop';
Die SQL Datei sieht wie folgt aus:
(Die zusätzlichen Tabellen habe ich mit phpMyAdmin automatisch erstellt)
Code:
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 28, 2004 at 07:29 PM
# Server version: 4.0.16
# PHP Version: 4.3.4
#
# Database : `aqvp07_exoops`
#
# --------------------------------------------------------
#
# Table structure for table `arcade_cats`
#
CREATE TABLE arcade_cats (
cat_id int(10) unsigned NOT NULL auto_increment,
cat_name varchar(64) NOT NULL default '',
is_active tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (cat_id)
) TYPE=MyISAM;
#
# Dumping data for table arcade_cats
#
INSERT INTO arcade_cats VALUES (1, 'General', 1);
# --------------------------------------------------------
#
# Table structure for table `arcade_games`
#
CREATE TABLE arcade_games (
gid int(11) NOT NULL auto_increment,
gname varchar(40) NOT NULL default '',
gwords text NOT NULL,
gcount int(11) NOT NULL default '0',
gtitle varchar(40) NOT NULL default '',
bgcolor varchar(6) NOT NULL default '000',
active tinyint(1) NOT NULL default '1',
gwidth int(11) NOT NULL default '400',
gheight int(11) NOT NULL default '400',
position mediumint(8) NOT NULL default '1',
cat_id int(10) unsigned NOT NULL default '1',
object text NOT NULL,
gkeys text NOT NULL,
date_added int(10) NOT NULL default '0',
UNIQUE KEY gid (gid)
) TYPE=MyISAM;
#
# Dumping data for table `arcade_games`
#
INSERT INTO arcade_games VALUES (1, 'asteroids', ' Kill some asteroids and flying saucers&#33; ', 0, 'Asteroids', '000000', 1, 500, 375, 1, 1, 'Shoot all of the asteroids.', 'Arrow keys move the ship.<br>rnSpace bar fires.', 0);
INSERT INTO arcade_games VALUES (2, 'invaders', ' Kill the invading army of UFO&#39;s ', 0, 'Space Invaders', '000000', 1, 500, 410, 1, 1, 'To shoot all of the aliens.', 'Left and Right arrow keys to move.<br>rnSpace bar to shoot.', 0);
INSERT INTO arcade_games VALUES (3, 'pacman', ' Eat all the little dots without letting the ghosts get you&#33; ', 0, 'Pacman', '000000', 1, 360, 420, 1, 1, 'Eat all of the dots.', 'Arrow keys to move.', 0);
# --------------------------------------------------------
#
# Table structure for table `arcade_scores`
#
CREATE TABLE arcade_scores (
score_id int(10) unsigned NOT NULL auto_increment,
gid int(10) unsigned NOT NULL default '0',
uid int(10) unsigned NOT NULL default '0',
score int(10) unsigned NOT NULL default '0',
score_date int(10) unsigned NOT NULL default '0',
PRIMARY KEY (score_id)
) TYPE=MyISAM;
#
# Dumping data for table arcade_scores
#
# --------------------------------------------------------
#
# Table structure for table `arcade_groups_downzip`
#
CREATE TABLE arcade_groups_downzip (
groupid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table e_xoops_arcade_groups_downzip
#
# --------------------------------------------------------
#
# Table structure for table `arcade_matchpoints`
#
CREATE TABLE arcade_matchpoints (
matchpoints_id int(10) unsigned NOT NULL auto_increment,
uid int(10) unsigned NOT NULL default '0',
gid int(10) unsigned NOT NULL default '0',
crashmode_score int(10) unsigned NOT NULL default '0',
crashmode_date timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
battlemode_hfordern int(10) unsigned NOT NULL default '0',
battlemode_vteitigen int(10) unsigned NOT NULL default '0',
ges_matchpoints int(10) unsigned NOT NULL default '0',
PRIMARY KEY (matchpoints_id)
) TYPE=MyISAM
#
# Dumping data for table `e_xoops_arcade_matchpoints`
#
# --------------------------------------------------------
#
# Table structure for table `arcade_topflop`
#
CREATE TABLE arcade_topflop (
topflop_id int(10) unsigned NOT NULL auto_increment,
gid int(10) unsigned NOT NULL default '0',
uid int(10) unsigned NOT NULL default '0',
top_game int(10) unsigned NOT NULL default '0',
flop_game int(10) unsigned NOT NULL default '0',
PRIMARY KEY (topflop_id)
) TYPE=MyISAM
#
# Dumping data for table e_xoops_arcade_topflop
#
Weiß jemand Rat???
Was mach ich falsch???
Vielen Dank für Eure Hilfe... |
Home
News
Archiv
Forum
[Arcade] Datenbankproblem
Dj_PD :
