phpBB2 by Przemo

slevin · **Pomógł:** 6 razy Posty: 118

mam konto na prv.pl (dokladnie pev.pl) i tworzy kopie bazy danych w db_beckup nie skompresowana do gz tylko sql mozna taki plik otworzyc przez przegladarke (nie mozna go sciagnac przez ftp bo ma 4mb)
czy takie cos mozna pozniej przenisc na inny serwer? (to kawalek kodu)

Kod:

CREATE TABLE phpbb_adv_person(
user_id mediumint(9) NOT NULL,
person_id mediumint(9) NOT NULL,
person_ip char(8),
PRIMARY KEY (user_id, person_id)
);

CREATE TABLE phpbb_advertisement(
id mediumint(9) NOT NULL auto_increment,
html text,
email varchar(128),
clicks int(9) NOT NULL,
position tinyint(1) NOT NULL,
porder mediumint(4) NOT NULL,
added int(11) NOT NULL,
expire int(11) NOT NULL,
last_update int(11) NOT NULL,
notify tinyint(1) NOT NULL,
type tinyint(1) NOT NULL,
PRIMARY KEY (id)
);

CREATE TABLE phpbb_album(
pic_id int(11) unsigned NOT NULL auto_increment,
pic_filename varchar(255) NOT NULL,
pic_thumbnail varchar(255),
pic_title varchar(255) NOT NULL,
pic_desc text,
pic_user_id mediumint(8) NOT NULL,
pic_username varchar(32),
pic_user_ip char(8) NOT NULL,
pic_time int(11) unsigned NOT NULL,
pic_cat_id mediumint(8) unsigned DEFAULT '1' NOT NULL,
pic_view_count int(11) unsigned NOT NULL,
pic_lock tinyint(3) NOT NULL,
pic_approval tinyint(3) DEFAULT '1' NOT NULL,
PRIMARY KEY (pic_id),
KEY pic_cat_id (pic_cat_id),
KEY pic_user_id (pic_user_id),
KEY pic_time (pic_time)
);

INSERT INTO phpbb_album VALUES('6', 'af8a9f4b3bc6ef0c9174b2b46051f5a7.jpg', 'af8a9f4b3bc6ef0c9174b2b46051f5a7.jpg', 'Zdjecie 4', 'opis zdjecia opis zdjecia opis zdjecia opis zdjecia', '2', 'Przemo', '7f000001', '1055091404', '1', '11', '0', '1');
INSERT INTO phpbb_album VALUES('3', '324c3dcd885b202cbe12358ab21e3073.jpg', '324c3dcd885b202cbe12358ab21e3073.jpg', 'Zdjecie 2', '', '2', 'Przemo', '7f000001', '1055091316', '1', '4', '0', '1');
INSERT INTO phpbb_album VALUES('5', '66738c6936cc0a48670409a2a85dcf7a.jpg', '66738c6936cc0a48670409a2a85dcf7a.jpg', 'Las', 'LasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLasLas', '2', 'Przemo', '7f000001', '1055091390', '1', '8', '0', '1');
INSERT INTO phpbb_album VALUES('8', '3db1bbec200fa429fe10ed150708dbf1.jpg', '', 'test', '', '2', 'SLEVIN', '5303d162', '1208300075', '3', '0', '0', '1');
CREATE TABLE phpbb_album_cat(
cat_id mediumint(8) unsigned NOT NULL auto_increment,
cat_parent mediumint(8) unsigned NOT NULL,
cat_type tinyint(2) NOT NULL,
cat_title varchar(255) NOT NULL,
cat_desc text,
cat_order mediumint(8) NOT NULL,
cat_view_level tinyint(3) DEFAULT '-1' NOT NULL,
cat_upload_level tinyint(3) NOT NULL,
cat_rate_level tinyint(3) NOT NULL,
cat_comment_level tinyint(3) NOT NULL,
cat_edit_level tinyint(3) NOT NULL,
cat_delete_level tinyint(3) DEFAULT '2' NOT NULL,
cat_view_groups varchar(255),
cat_upload_groups varchar(255),
cat_rate_groups varchar(255),
cat_comment_groups varchar(255),
cat_edit_groups varchar(255),
cat_delete_groups varchar(255),
cat_moderator_groups varchar(255),
cat_approval tinyint(3) NOT NULL,
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
);

INSERT INTO phpbb_album_cat VALUES('1', '0', '0', 'TAPETY', '', '10', '-1', '0', '0', '0', '0', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO phpbb_album_cat VALUES('4', '0', '0', 'GRA', 'zdjecia z gry:)', '30', '-1', '0', '0', '0', '0', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO phpbb_album_cat VALUES('3', '0', '0', 'ALBUM', 'wrzucajcie zdjęcia :) 1600x1200 px do 2,5 MB', '20', '-1', '0', '0', '0', '0', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
CREATE TABLE phpbb_album_comment(
comment_id int(11) unsigned NOT NULL auto_increment,
comment_pic_id int(11) unsigned NOT NULL,
comment_user_id mediumint(8) NOT NULL,
comment_username varchar(32),
comment_user_ip char(8) NOT NULL,
comment_time int(11) unsigned NOT NULL,
comment_text text,
comment_edit_time int(11) unsigned,
comment_edit_count smallint(5) unsigned NOT NULL,
comment_edit_user_id mediumint(8),
PRIMARY KEY (comment_id),
KEY comment_pic_id (comment_pic_id),
KEY comment_user_id (comment_user_id),
KEY comment_user_ip (comment_user_ip),
KEY comment_time (comment_time)
);

CREATE TABLE phpbb_album_config(
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name)
);

INSERT INTO phpbb_album_config VALUES('max_pics', '1024');
INSERT INTO phpbb_album_config VALUES('user_pics_limit', '50');
INSERT INTO phpbb_album_config VALUES('mod_pics_limit', '250');
INSERT INTO phpbb_album_config VALUES('max_file_size', '700000');
INSERT INTO phpbb_album_config VALUES('max_width', '2500');
INSERT INTO phpbb_album_config VALUES('max_height', '1800');
INSERT INTO phpbb_album_config VALUES('rows_per_page', '3');
INSERT INTO phpbb_album_config VALUES('cols_per_page', '4');
INSERT INTO phpbb_album_config VALUES('fullpic_popup', '1');
INSERT INTO phpbb_album_config VALUES('thumbnail_quality', '50');
INSERT INTO phpbb_album_config VALUES('thumbnail_size', '125');
INSERT INTO phpbb_album_config VALUES('thumbnail_cache', '1');
INSERT INTO phpbb_album_config VALUES('sort_method', 'pic_time');
INSERT INTO phpbb_album_config VALUES('sort_order', 'DESC');
INSERT INTO phpbb_album_config VALUES('jpg_allowed', '1');
INSERT INTO phpbb_album_config VALUES('png_allowed', '1');
INSERT INTO phpbb_album_config VALUES('gif_allowed', '0');
INSERT INTO phpbb_album_config VALUES('desc_length', '512');
INSERT INTO phpbb_album_config VALUES('hotlink_prevent', '0');
INSERT INTO phpbb_album_config VALUES('hotlink_allowed', '');
INSERT INTO phpbb_album_config VALUES('personal_gallery', '0');
INSERT INTO phpbb_album_config VALUES('personal_gallery_private', '0');
INSERT INTO phpbb_album_config VALUES('personal_gallery_limit', '10');
INSERT INTO phpbb_album_config VALUES('personal_gallery_view', '-1');
INSERT INTO phpbb_album_config VALUES('rate', '1');
INSERT INTO phpbb_album_config VALUES('rate_scale', '10');
INSERT INTO phpbb_album_config VALUES('comment', '1');
INSERT INTO phpbb_album_config VALUES('gd_version', '1');
INSERT INTO phpbb_album_config VALUES('album_version', '.0.51');
INSERT INTO phpbb_album_config VALUES('watermark_width', '10');
INSERT INTO phpbb_album_config VALUES('watermark_height', '10');
INSERT INTO phpbb_album_config VALUES('watermark_transparent', '0');
CREATE TABLE phpbb_album_rate(
rate_pic_id int(11) unsigned NOT NULL,
rate_user_id mediumint(8) NOT NULL,
rate_user_ip char(8) NOT NULL,
rate_point tinyint(3) unsigned NOT NULL,
KEY rate_pic_id (rate_pic_id),
KEY rate_user_id (rate_user_id),
KEY rate_user_ip (rate_user_ip),
KEY rate_point (rate_point)
);

Gadatliwa Kasia

warna · **Pomógł:** 475 razy Posty: 2335

Skoro znasz bezpośredni link do pliku i z jakiegoś powodu nie możesz go ściągnąć przez ftp, to możesz spróbować go wkleić w Szybkim pobieraniu w zakładce Transfery w Operze.

Centurion · **Pomógł:** 543 razy Posty: 1972

tak o ile plik ładuje się cały, tylko że możesz miec problem z kodowaniem pl znaczków ale jak na stronie widzisz je poprawnie to powinno byc ok

mozesz calosc zapisac jako plik z rozszerzeniem .sql

slevin · **Pomógł:** 6 razy Posty: 118

rozumiem ..

Radek · **Pomógł:** 955 razy Posty: 4614

Tabela już phpbb_adv_person już istnieje. Nie wgrywasz kopii do czystej bazy danych. Usuń najpierw z niej wszystkie tabele, potem wgraj kopię.

slevin · **Pomógł:** 6 razy Posty: 118

) no i poszlo

thx wielkie

:*