Antworten: 7
Seite [1] |
|
momimherz Beginner Beiträge: 5 |
# Thema - 05.10.2006 um 16:51 Uhr
Hallo Ihr !! Hatte eine längere Zeit nicht upgedatet und entschied mich heute dies zu tun. Anzeige nach update... ALTER TABLE {pre}_users DROP users_postalcode ALTER TABLE {pre}_users ADD users_postalcode varchar(8) NOT NULL default '' UPDATE {pre}_users SET users_country = 'fam' WHERE users_country = 'na' UPDATE {pre}_users SET users_country = 'gb' WHERE users_country = 'uk' UPDATE {pre}_users SET users_sex = '' WHERE users_sex = 'no' UPDATE {pre}_users SET users_sex = 'male' WHERE users_sex = 'm' UPDATE {pre}_users SET users_sex = 'female' WHERE users_sex = 'w' ALTER TABLE {pre}_access ADD access_maps int(2) NOT NULL default '0' ALTER TABLE {pre}_cash DROP cash_money ALTER TABLE {pre}_cash ADD cash_money varchar(8) NOT NULL default '' [color=red]ALTER TABLE {pre}_news ADD news_pictures text NOT NULL default '' DROP TABLE {pre}_readtopics CREATE TABLE {pre}_read ( read_id int(8) unsigned NOT NULL auto_increment, threads_id int(8) NOT NULL default '0', users_id int(8) NOT NULL default '0', read_since varchar(14) NOT NULL default '', PRIMARY KEY (read_id), UNIQUE (threads_id,users_id) ) TYPE=MyISAM CREATE TABLE {pre}_maps ( maps_id int(8) unsigned NOT NULL auto_increment, games_id int(8) NOT NULL default '0', maps_name varchar(100) NOT NULL default '', maps_text text NOT NULL default '', maps_picture varchar(80) NOT NULL default '', PRIMARY KEY (maps_id) ) TYPE=MyISAM CREATE TABLE {pre}_rounds ( rounds_id int(8) unsigned NOT NULL auto_increment, wars_id int(8) NOT NULL default '0', maps_id int(8) NOT NULL default '0', rounds_score1 int(6) NOT NULL default '0', rounds_score2 int(6) NOT NULL default '0', rounds_description varchar(80) NOT NULL default '', PRIMARY KEY (rounds_id) ) TYPE=MyISAM CREATE TABLE {pre}_players ( players_id int(8) unsigned NOT NULL auto_increment, users_id int(8) NOT NULL DEFAULT '0', wars_id int(8) NOT NULL DEFAULT '0', players_status varchar(20) NOT NULL DEFAULT '', players_played int(2) NOT NULL DEFAULT '0', players_time varchar(14) NOT NULL DEFAULT '', PRIMARY KEY (players_id) ) TYPE=MyISAM CREATE TABLE {pre}_boardvotes ( boardvotes_id int(8) unsigned NOT NULL auto_increment, threads_id int(8) NOT NULL default '0', users_id int(8) NOT NULL default '0', boardvotes_access int(2) NOT NULL default '0', boardvotes_time varchar(14) NOT NULL default '', boardvotes_end varchar(14) NOT NULL default '', boardvotes_question varchar(50) NOT NULL default '', boardvotes_election text NOT NULL default '', PRIMARY KEY (boardvotes_id) ) TYPE=MyISAM CREATE TABLE {pre}_boardfiles ( boardfiles_id int(8) unsigned NOT NULL auto_increment, threads_id int(8) NOT NULL default '0', comments_id int(8) NOT NULL default '0', users_id int(8) NOT NULL default '0', boardfiles_time varchar(14) NOT NULL default '', boardfiles_name varchar(80) NOT NULL default '', PRIMARY KEY (boardfiles_id) ) TYPE=MyISAM INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('bxcp', 'def_admin', '') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('abcode', 'max_width', '300') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('abcode', 'max_height', '300') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('abcode', 'max_size', '51200') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('abcode', 'def_func', '') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('banners', 'max_width', '100') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('banners', 'max_height', '100') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('banners', 'max_size', '51200') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('banners', 'def_order', '1') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('categories', 'max_width', '150') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('categories', 'max_height', '150') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('categories', 'max_size', '51200') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('categories', 'def_mod', 'news') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('computers', 'max_width', '800') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('computers', 'max_height', '600') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('computers', 'max_size', '204800') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('board', 'file_size', '204800') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('board', 'file_types', 'jpg,jpeg,gif,png,txt,pdf') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('squads', 'max_width', '250') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('squads', 'max_height', '100') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('squads', 'max_size', '76800') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('squads', 'def_order', '1') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('users', 'max_width', '140') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('users', 'max_height', '170') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('users', 'max_size', '51200') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('wars', 'max_width', '800') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('wars', 'max_height', '600') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('wars', 'max_size', '204800') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('news', 'max_width', '800') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('news', 'max_height', '600') INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('news', 'max_size', '204800') CREATE INDEX {pre}_abonements_users_id_index ON {pre}_abonements (users_id) CREATE INDEX {pre}_abonements_threads_id_index ON {pre}_abonements (threads_id) CREATE INDEX {pre}_articles_users_id_index ON {pre}_articles (users_id) CREATE INDEX {pre}_articles_categories_id_index ON {pre}_articles (categories_id) CREATE INDEX {pre}_autoresponder_users_id_index ON {pre}_autoresponder (users_id) CREATE INDEX {pre}_awards_users_id_index ON {pre}_awards (users_id) CREATE INDEX {pre}_awards_games_id_index ON {pre}_awards (games_id) CREATE INDEX {pre}_board_users_id_index ON {pre}_board (users_id) CREATE INDEX {pre}_board_categories_id_index ON {pre}_board (categories_id) CREATE INDEX {pre}_boardfiles_threads_id_index ON {pre}_boardfiles (threads_id) CREATE INDEX {pre}_boardfiles_comments_id_index ON {pre}_boardfiles (comments_id) CREATE INDEX {pre}_boardfiles_users_id_index ON {pre}_boardfiles (users_id) CREATE INDEX {pre}_boardmods_users_id_index ON {pre}_boardmods (users_id) CREATE INDEX {pre}_boardpws_board_id_index ON {pre}_boardpws (board_id) CREATE INDEX {pre}_boardpws_users_id_index ON {pre}_boardpws (users_id) CREATE INDEX {pre}_boardvotes_threads_id_index ON {pre}_boardvotes (threads_id) CREATE INDEX {pre}_boardvotes_users_id_index ON {pre}_boardvotes (users_id) CREATE INDEX {pre}_buddys_users_id_index ON {pre}_buddys (users_id) CREATE INDEX {pre}_buddys_buddys_user_index ON {pre}_buddys (buddys_user) CREATE INDEX {pre}_comments_users_id_index ON {pre}_comments (users_id) CREATE INDEX {pre}_comments_comments_fid_index ON {pre}_comments (comments_fid) CREATE INDEX {pre}_computers_users_id_index ON {pre}_computers (users_id) CREATE INDEX {pre}_events_categories_id_index ON {pre}_events (categories_id) CREATE INDEX {pre}_faq_users_id_index ON {pre}_faq (users_id) CREATE INDEX {pre}_faq_categories_id_index ON {pre}_faq (categories_id) CREATE INDEX {pre}_fightus_categories_id_index ON {pre}_fightus (categories_id) (clans_id); Das ganze äussert sich lediglich so, das man nach klicken eines Threads oberhalb der kommentare einen solchen Auswurf lesen kann hier ein direkter link http://gamelaunch.de/page/index.php?mod=board&action=thread&where=311 |
Inaktiv |
|
hajo VIP - Poster Herkunft: Barsbüttel Beiträge: 9411 |
# Antwort: 1 - 09.10.2006 um 10:00 Uhr
update von welcher zu welcher version? ------------------ ClanSphere - professional clan care starts here |
Inaktiv |
|
viper Rock the board Beiträge: 60 |
# Antwort: 2 - 09.10.2006 um 10:13 Uhr
Steht doch im Themanamen "0.3.1.0 to 0.3.1.1" Was mich wundert... Warum nicht zu 0.3.2.2? Und auf der Clanseite selber steht "BXCP 0.3.0.4" Gruß viper |
Inaktiv |
|
hajo VIP - Poster Herkunft: Barsbüttel Beiträge: 9411 |
# Antwort: 3 - 09.10.2006 um 10:26 Uhr
das wundert mich auch alles ------------------ ClanSphere - professional clan care starts here |
Inaktiv |
|
momimherz Thread-Ersteller Beginner Beiträge: 5 |
# Antwort: 4 - 09.10.2006 um 10:51 Uhr
je eben der hat das irgendwie nicht angenommen könnte ich eigentlich das board neu installieren und die einzelnden themen postings usw. aus der alten db implementieren?? |
Inaktiv |
|
hajo VIP - Poster Herkunft: Barsbüttel Beiträge: 9411 |
# Antwort: 5 - 09.10.2006 um 10:52 Uhr
musst die updates in der richtigen reihenfolge ausführen und im anschluss bxcp dateien aufm webspace komplett erneuern alle ------------------ ClanSphere - professional clan care starts here |
Inaktiv |
|
momimherz Thread-Ersteller Beginner Beiträge: 5 |
# Antwort: 6 - 09.10.2006 um 11:37 Uhr
Hallo hallo allles wieder cool.. Ich bitte um Spott in meine Richtung, ich bin soooooooo doof habe nur sql upgedatet und keine files ... los macht Euch über mich lustig!! Ich habe diese Pein verdient.. Jetzt habe ich nur das PRBL. mit der Shoutbox Floodsperre von 7000 Sek .lol |
Inaktiv |
|
duRiel Weltmeister Herkunft: Cambridge Beiträge: 7300 |
# Antwort: 7 - 09.10.2006 um 11:54 Uhr
pein gibts hier nicht floodsperre wird ja schon im anderen thread behandelt. und bevor du noch gepeinigt wirst schließe ich mal schnell /close |
Inaktiv |
|
Antworten: 7
Seite [1] |
Sie müssen sich registrieren, um zu antworten. |