agent47 Wrote:Ich habe gerade mal versucht den bericht einzubauen, wenn ich die localhost/spaeher.php?action=make_tables lade kommt Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in K:\Web_Anwendungen\ds_lan\DS_LAN\htdocs\spaeher.php on line 13
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in K:\Web_Anwendungen\ds_lan\DS_LAN\htdocs\spaeher.php on line 142
eigentlich solltest du garnicht in den sql teil kommen.
gib mal den code im sql ein
erst DROP TABLE IF EXISTS `reports`
dann
CREATE TABLE IF NOT EXISTS `reports` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(230) character set latin1 collate latin1_german1_ci NOT NULL,
`title_image` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL,
`time` int(25) NOT NULL,
`type` varchar(40) character set latin1 collate latin1_german1_ci NOT NULL,
`a_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`b_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`c_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`d_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`e_units` varchar(350) character set latin1 collate latin1_german1_ci default NULL,
`agreement` varchar(20) character set latin1 collate latin1_german1_ci NOT NULL,
`ram` varchar(15) character set latin1 collate latin1_german1_ci NOT NULL,
`catapult` varchar(40) character set latin1 collate latin1_german1_ci NOT NULL,
`message` text character set latin1 collate latin1_german1_ci NOT NULL,
`to_user` int(11) NOT NULL,
`from_user` int(11) NOT NULL,
`to_village` int(11) NOT NULL,
`from_village` int(11) NOT NULL,
`receiver_userid` int(11) NOT NULL,
`is_new` int(1) NOT NULL default '1',
`in_group` varchar(40) character set latin1 collate latin1_german1_ci default NULL,
`luck` varchar(6) character set latin1 collate latin1_german1_ci default NULL,
`moral` int(6) default NULL,
`wins` varchar(15) character set latin1 collate latin1_german1_ci NOT NULL,
`hives` varchar(100) character set latin1 collate latin1_german1_ci NOT NULL,
`see_def_units` int(1) NOT NULL default '1',
`ally` int(11) NOT NULL,
`allyname` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL,
`from_username` varchar(200) collate utf8_unicode_ci NOT NULL,
`to_username` varchar(200) collate utf8_unicode_ci NOT NULL,
`barracks` int(2) default '-1',
`farm` int(2) default '-1',
`garage` int(2) default '-1',
`iron` int(2) default '-1',
`main` int(2) default '-1',
`market` int(2) default '-1',
`place` int(2) default '-1',
`smith` int(2) default '-1',
`snob` int(2) default '-1',
`stable` int(2) default '-1',
`stone` int(2) default '-1',
`storage` int(2) default '-1',
`wall` int(2) default '-1',
`wood` int(2) default '-1',
`geprueft` varchar(11) collate utf8_unicode_ci NOT NULL default '0',
`hide` int(2) default '-1',
`r_wood` int(20) default '-1',
`r_stone` int(20) default '-1',
`r_iron` int(20) default '-1',
PRIMARY KEY (`id`),
KEY `receiver_userid` (`receiver_userid`),
KEY `group` (`in_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=188
versuchs dann nochmal