Wątek: Baza danych

??ciągnąłem sobie XNova v1.1A.Wrzuciłem pliki na serwer>chce wrzucić bazę danych (sql) ale za chol...... nie mogę znalesc w tym folderze zadnego pliku z rozszezeniem .sql jest jedynie w folderze db/ plik mysql.php. Prosze o udostepnienie bazy .sql albo o pomoc.
z gory dzieki

PS. beda piwka za pomoc

Nie znam się na silniku, ale:

Plik nie musi być .sql. Równie dobrze może być .txt.
Może jest jakiś install.php.

Jeśli się nie myle to jest tam folder db czy cos takiego, a po za tym jest tam plik install.php więc może zainstalować...

jak chce wrzucic to zawsze jest blad

Błąd

Wygląda na to, że w twoim zapytaniu SQL jest błąd. W znalezieniu przyczyny problemu może pomóc także - jeśli się pojawi - poniższy opis błędu serwera MySQL.
ERROR: Nieznany znak przestankowy @ 1STR: <?SQL: <?php// UGAMELA 2 XNOVA - DATABASE MODIFICATOR// Version: 0.5// Created by e-Zobar// XNova (c) Copyright 2008$querys = array("ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_end_stay` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_target_owner` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_group` int (11) NOT NULL DEFAULT '0';","ALTER TABLE `{{prefix}}messages` MODIFY `message_from` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}messages` MODIFY `message_subject` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_planets`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank_old`;","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_buildlist` INT (11) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `expedition_tech` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_expedition` INT( 11 ) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_geologue` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_amiral` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_ingenieur` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_technocrate` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_points` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_minier` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_raid` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpraid` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpminier` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `banaday` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `timeonline` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `user_agent` text character set latin1 NOT NULL;","ALTER TABLE `{{prefix}}users` MODIFY `lang` varchar(8) character set latin1 NOT NULL default 'fr';","CREATE TABLE `{{prefix}}annonce` (`id` int(11) NOT NULL auto_increment,`user` text collate latin1_general_ci NOT NULL,`galaxie` int(11) NOT NULL,`systeme` int(11) NOT NULL,`metala` bigint(11) NOT NULL,`cristala` bigint(11) NOT NULL,`deuta` bigint(11) NOT NULL,`metals` bigint(11) NOT NULL,`cristals` bigint(11) NOT NULL,`deuts` bigint(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=5;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `b_building_queue`;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `unbau`;","ALTER TABLE `{{prefix}}planets` ADD COLUMN `last_jump_time` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}planets` MODIFY `b_building_id` text character set latin1 NOT NULL;","CREATE TABLE `{{prefix}}statpoints` (`id_owner` int(11) NOT NULL,`id_ally` int(11) NOT NULL,`stat_type` int(2) NOT NULL,`stat_code` int(11) NOT NULL,`tech_rank` int(11) NOT NULL,`tech_old_rank` int(11) NOT NULL,`tech_points` bigint(20) NOT NULL,`tech_count` int(11) NOT NULL,`build_rank` int(11) NOT NULL,`build_old_rank` int(11) NOT NULL,`build_points` bigint(20) NOT NULL,`build_count` int(11) NOT NULL,`defs_rank` int(11) NOT NULL,`defs_old_rank` int(11) NOT NULL,`defs_points` bigint(20) NOT NULL,`defs_count` int(11) NOT NULL,`fleet_rank` int(11) NOT NULL,`fleet_old_rank` int(11) NOT NULL,`fleet_points` bigint(20) NOT NULL,`fleet_count` int(11) NOT NULL,`total_rank` int(11) NOT NULL,`total_old_rank` int(11) NOT NULL,`total_points` bigint(20) NOT NULL,`total_count` int(11) NOT NULL,`stat_date` int(11) NOT NULL,KEY `TECH` (`tech_points`),KEY `BUILDS` (`build_points`),KEY `DEFS` (`defs_points`),KEY `FLEET` (`fleet_points`),KEY `TOTAL` (`total_points`)) ENGINE=MyISAM;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_members_points`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet2`;","CREATE TABLE `{{prefix}}chat` (`messageid` int(5) unsigned NOT NULL auto_increment,`user` varchar(255) NOT NULL default '',`message` text NOT NULL,`timestamp` int(11) NOT NULL default '0',PRIMARY KEY (`messageid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;","DROP TABLE `{{prefix}}admin_acl`;","DROP TABLE `{{prefix}}admin_modules`;","INSERT INTO `{{prefix}}config` (`config_name`, `config_value`) VALUES('Fleet_Cdr', '30'),('Defs_Cdr', '30'),('Debug', '0'),('game_disable', '0'),('close_reason', ''),('BuildLabWhileRun', '0'),('LastSettedGalaxyPos', '1'),('LastSettedSystemPos', '9'),('LastSettedPlanetPos', '1'),('urlaubs_modus_erz', '1'),('forum_url', 'http://www.xnova.fr/forum'),('OverviewNewsFrame', '1'),('OverviewNewsText', 'Vous avez correctement mis votre serveur UGamela sous XNova!'),('OverviewExternChat', '0'),('OverviewExternChatCmd', ''),('OverviewBanner', '0'),('OverviewClickBanner', '');","UPDATE `{{prefix}}config` SET `config_value`='XNova' WHERE `config_name`='COOKIE_NAME';","UPDATE `{{prefix}}config` SET `config_value`='XNova' WHERE `config_name`='game_name';");<?php// UGAMELA 2 XNOVA - DATABASE MODIFICATOR// Version: 0.5// Created by e-Zobar// XNova (c) Copyright 2008$querys = array("ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_end_stay` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_target_owner` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_group` int (11) NOT NULL DEFAULT '0';","ALTER TABLE `{{prefix}}messages` MODIFY `message_from` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}messages` MODIFY `message_subject` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_planets`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank_old`;","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_buildlist` INT (11) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `expedition_tech` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_expedition` INT( 11 ) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_geologue` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_amiral` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_ingenieur` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_technocrate` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_points` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_minier` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_raid` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpraid` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpminier` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `banaday` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `timeonline` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `user_agent` text character set latin1 NOT NULL;","ALTER TABLE `{{prefix}}users` MODIFY `lang` varchar(8) character set latin1 NOT NULL default 'fr';","CREATE TABLE `{{prefix}}annonce` (`id` int(11) NOT NULL auto_increment,`user` text collate latin1_general_ci NOT NULL,`galaxie` int(11) NOT NULL,`systeme` int(11) NOT NULL,`metala` bigint(11) NOT NULL,`cristala` bigint(11) NOT NULL,`deuta` bigint(11) NOT NULL,`metals` bigint(11) NOT NULL,`cristals` bigint(11) NOT NULL,`deuts` bigint(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=5;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `b_building_queue`;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `unbau`;","ALTER TABLE `{{prefix}}planets` ADD COLUMN `last_jump_time` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}planets` MODIFY `b_building_id` text character set latin1 NOT NULL;","CREATE TABLE `{{prefix}}statpoints` (`id_owner` int(11) NOT NULL,`id_ally` int(11) NOT NULL,`stat_type` int(2) NOT NULL,`stat_code` int(11) NOT NULL,`tech_rank` int(11) NOT NULL,`tech_old_rank` int(11) NOT NULL,`tech_points` bigint(20) NOT NULL,`tech_count` int(11) NOT NULL,`build_rank` int(11) NOT NULL,`build_old_rank` int(11) NOT NULL,`build_points` bigint(20) NOT NULL,`build_count` int(11) NOT NULL,`defs_rank` int(11) NOT NULL,`defs_old_rank` int(11) NOT NULL,`defs_points` bigint(20) NOT NULL,`defs_count` int(11) NOT NULL,`fleet_rank` int(11) NOT NULL,`fleet_old_rank` int(11) NOT NULL,`fleet_points` bigint(20) NOT NULL,`fleet_count` int(11) NOT NULL,`total_rank` int(11) NOT NULL,`total_old_rank` int(11) NOT NULL,`total_points` bigint(20) NOT NULL,`total_count` int(11) NOT NULL,`stat_date` int(11) NOT NULL,KEY `TECH` (`tech_points`),KEY `BUILDS` (`build_points`),KEY `DEFS` (`defs_points`),KEY `FLEET` (`fleet_points`),KEY `TOTAL` (`total_points`)) ENGINE=MyISAM;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_members_points`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet2`;","CREATE TABLE `{{prefix}}chat` (`messageid` int(5) unsigned NOT NULL auto_increment,`user` varchar(255) NOT NULL default '',`message` text NOT NULL,`timestamp` int(11) NOT NULL default '0',PRIMARY KEY (`messageid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;","DROP TABLE `{{prefix}}admin_acl`;","DROP TABLE `{{prefix}}admin_modules`;","INSERT INTO `{{prefix}}config` (`config_name`, `config_value`) VALUES('Fleet_Cdr', '30'),('Defs_Cdr', '30'),('Debug', '0'),('game_disable', '0'),('close_reason', ''),('BuildLabWhileRun', '0'),('LastSettedGalaxyPos', '1'),('LastSettedSystemPos', '9'),('LastSettedPlanetPos', '1'),('urlaubs_modus_erz', '1'),('forum_url', 'http://www.xnova.fr/forum'),('OverviewNewsFrame', '1'),('OverviewNewsText', 'Vous avez correctement mis votre serveur UGamela sous XNova!'),('OverviewExternChat', '0'),('OverviewExternChatCmd', ''),('OverviewBanner', '0'),('OverviewClickBanner', '');","UPDATE `{{prefix}}config` SET `config_value`='XNova' WHERE `config_name`='COOKIE_NAME';","UPDATE `{{prefix}}config` SET `config_value`='XNova' WHERE `config_name`='game_name';");<?php// UGAMELA 2 XNOVA - DATABASE MODIFICATOR// Version: 0.5// Created by e-Zobar// XNova (c) Copyright 2008$querys = array("ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_end_stay` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_target_owner` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_group` int (11) NOT NULL DEFAULT '0';","ALTER TABLE `{{prefix}}messages` MODIFY `message_from` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}messages` MODIFY `message_subject` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_planets`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank_old`;","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_buildlist` INT (11) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `expedition_tech` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_expedition` INT( 11 ) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_geologue` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_amiral` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_ingenieur` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_technocrate` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_points` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_minier` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_raid` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpraid` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpminier` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `banaday` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `timeonline` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `user_agent` text character set latin1 NOT NULL;","ALTER TABLE `{{prefix}}users` MODIFY `lang` varchar(8) character set latin1 NOT NULL default 'fr';","CREATE TABLE `{{prefix}}annonce` (`id` int(11) NOT NULL auto_increment,`user` text collate latin1_general_ci NOT NULL,`galaxie` int(11) NOT NULL,`systeme` int(11) NOT NULL,`metala` bigint(11) NOT NULL,`cristala` bigint(11) NOT NULL,`deuta` bigint(11) NOT NULL,`metals` bigint(11) NOT NULL,`cristals` bigint(11) NOT NULL,`deuts` bigint(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=5;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `b_building_queue`;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `unbau`;","ALTER TABLE `{{prefix}}planets` ADD COLUMN `last_jump_time` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}planets` MODIFY `b_building_id` text character set latin1 NOT NULL;","CREATE TABLE `{{prefix}}statpoints` (`id_owner` int(11) NOT NULL,`id_ally` int(11) NOT NULL,`stat_type` int(2) NOT NULL,`stat_code` int(11) NOT NULL,`tech_rank` int(11) NOT NULL,`tech_old_rank` int(11) NOT NULL,`tech_points` bigint(20) NOT NULL,`tech_count` int(11) NOT NULL,`build_rank` int(11) NOT NULL,`build_old_rank` int(11) NOT NULL,`build_points` bigint(20) NOT NULL,`build_count` int(11) NOT NULL,`defs_rank` int(11) NOT NULL,`defs_old_rank` int(11) NOT NULL,`defs_points` bigint(20) NOT NULL,`defs_count` int(11) NOT NULL,`fleet_rank` int(11) NOT NULL,`fleet_old_rank` int(11) NOT NULL,`fleet_points` bigint(20) NOT NULL,`fleet_count` int(11) NOT NULL,`total_rank` int(11) NOT NULL,`total_old_rank` int(11) NOT NULL,`total_points` bigint(20) NOT NULL,`total_count` int(11) NOT NULL,`stat_date` int(11) NOT NULL,KEY `TECH` (`tech_points`),KEY `BUILDS` (`build_points`),KEY `DEFS` (`defs_points`),KEY `FLEET` (`fleet_points`),KEY `TOTAL` (`total_points`)) ENGINE=MyISAM;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_members_points`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet2`;","CREATE TABLE `{{prefix}}chat` (`messageid` int(5) unsigned NOT NULL auto_increment,`user` varchar(255) NOT NULL default '',`message` text NOT NULL,`timestamp` int(11) NOT NULL default '0',PRIMARY KEY (`messageid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;","DROP TABLE `{{prefix}}admin_acl`;","DROP TABLE `{{prefix}}admin_modules`;","INSERT INTO `{{prefix}}config` (`config_name`, `config_value`) VALUES('Fleet_Cdr', '30'),('Defs_Cdr', '30'),('Debug', '0'),('game_disable', '0'),('close_reason', ''),('BuildLabWhileRun', '0'),('LastSettedGalaxyPos', '1'),('LastSettedSystemPos', '9'),('LastSettedPlanetPos', '1'),('urlaubs_modus_erz', '1'),('forum_url', 'http://www.xnova.fr/forum'),('OverviewNewsFrame', '1'),('OverviewNewsText', 'Vous avez correctement mis votre serveur UGamela sous XNova!'),('OverviewExternChat', '0'),('OverviewExternChatCmd', ''),('OverviewBanner', '0'),('OverviewClickBanner', '');","UPDATE `{{prefix}}config` SET `config_value`='XNova' WHERE `config_name`='COOKIE_NAME';","UPDATE `{{prefix}}config` SET `config_value`='XNova' WHERE `config_name`='game_name';");<?php// UGAMELA 2 XNOVA - DATABASE MODIFICATOR// Version: 0.5// Created by e-Zobar// XNova (c) Copyright 2008$querys = array("ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_end_stay` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_target_owner` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}fleets` ADD COLUMN `fleet_group` int (11) NOT NULL DEFAULT '0';","ALTER TABLE `{{prefix}}messages` MODIFY `message_from` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}messages` MODIFY `message_subject` varchar(48) character set latin1 default NULL;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet2`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_builds_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_tech_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_fleet_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_planets`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `points_points_old`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank`;","ALTER TABLE `{{prefix}}users` DROP COLUMN `rank_old`;","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_buildlist` INT (11) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `expedition_tech` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `mnl_expedition` INT( 11 ) NOT NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_geologue` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_amiral` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_ingenieur` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_technocrate` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `rpg_points` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_minier` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `lvl_raid` int(11) NOT NULL default '1';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpraid` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `xpminier` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}users` ADD COLUMN `banaday` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `timeonline` int(11) default NULL;","ALTER TABLE `{{prefix}}users` ADD COLUMN `user_agent` text character set latin1 NOT NULL;","ALTER TABLE `{{prefix}}users` MODIFY `lang` varchar(8) character set latin1 NOT NULL default 'fr';","CREATE TABLE `{{prefix}}annonce` (`id` int(11) NOT NULL auto_increment,`user` text collate latin1_general_ci NOT NULL,`galaxie` int(11) NOT NULL,`systeme` int(11) NOT NULL,`metala` bigint(11) NOT NULL,`cristala` bigint(11) NOT NULL,`deuta` bigint(11) NOT NULL,`metals` bigint(11) NOT NULL,`cristals` bigint(11) NOT NULL,`deuts` bigint(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=5;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `b_building_queue`;","ALTER TABLE `{{prefix}}planets` DROP COLUMN `unbau`;","ALTER TABLE `{{prefix}}planets` ADD COLUMN `last_jump_time` int(11) NOT NULL default '0';","ALTER TABLE `{{prefix}}planets` MODIFY `b_building_id` text character set latin1 NOT NULL;","CREATE TABLE `{{prefix}}statpoints` (`id_owner` int(11) NOT NULL,`id_ally` int(11) NOT NULL,`stat_type` int(2) NOT NULL,`stat_code` int(11) NOT NULL,`tech_rank` int(11) NOT NULL,`tech_old_rank` int(11) NOT NULL,`tech_points` bigint(20) NOT NULL,`tech_count` int(11) NOT NULL,`build_rank` int(11) NOT NULL,`build_old_rank` int(11) NOT NULL,`build_points` bigint(20) NOT NULL,`build_count` int(11) NOT NULL,`defs_rank` int(11) NOT NULL,`defs_old_rank` int(11) NOT NULL,`defs_points` bigint(20) NOT NULL,`defs_count` int(11) NOT NULL,`fleet_rank` int(11) NOT NULL,`fleet_old_rank` int(11) NOT NULL,`fleet_points` bigint(20) NOT NULL,`fleet_count` int(11) NOT NULL,`total_rank` int(11) NOT NULL,`total_old_rank` int(11) NOT NULL,`total_points` bigint(20) NOT NULL,`total_count` int(11) NOT NULL,`stat_date` int(11) NOT NULL,KEY `TECH` (`tech_points`),KEY `BUILDS` (`build_points`),KEY `DEFS` (`defs_points`),KEY `FLEET` (`fleet_points`),KEY `TOTAL` (`total_points`)) ENGINE=MyISAM;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_builds_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_fleet_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `ally_points_tech_old`;","ALTER TABLE `{{prefix}}alliance` DROP COLUMN `al pomocy

O ile mi wiadomo,bo sam mam postawiona gre na silniku xnova to xnova nie ma pliku sql ani zadnego innego do wrzucania do bazy danych,wrzucasz pliki na serwer,potem dajesz http://www.adrestwojejstrony.twojhosting.pl/install i instalujesz gre,w czasie instalacji podajesz dane do bazy danych i tam sie automatycznie instalują wszystkie tabele do bazy. Nie spotkałem sie z xnovą zeby trzeba bylo wrzucac sql do bazy lub inne pliki.

a ja się spotkałem i instalacja nie działała trzeba było ręcznie bazę dać

No może,ale przynajmniej w mojej xnovie nie trzeba było nic przesylac do bazy

Tak patrzę i widzę że wkleiłeś plik php!
: <?SQL: <?php// UGAMELA 2 XNOVA - DATABASE MODIFICATOR// Version: 0.5// Created by e-Zobar// XNova (c) Copyright 2008$querys = array("[...]"); itd ?> to ma być zapytanie sql?

,heh tez na to patrzylem a nie zauwazylem tego,masz racje,bardziej to do php pasuje

dzieki widze ze jest ktos porzadny na tym forum masz WIELKIE PIWO