nevedeli by ste mi pomoct so sql tabulkami???ze ako ich vytvarat a prerabat.no proste mam mod v ktorom je napisane ze:
ALTER TABLE phpbb_users ADD user_cell_time INT(11) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_cell_time_judgement INT(11) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_cell_caution INT(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_cell_sentence TEXT DEFAULT '';
ALTER TABLE phpbb_users ADD user_cell_enable_caution INT(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_cell_enable_free INT(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_cell_celleds INT(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_cell_punishment TINYINT(1) DEFAULT '0' NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_display_bars', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_display_celleds', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_user_caution', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_user_judge', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_user_blank', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_amount_user_blank', '5000');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_user_judge_voters', '10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_user_judge_posts', '2');
CREATE TABLE phpbb_jail_users (
celled_id int(8) NOT NULL default '0',
user_id int(8) NOT NULL default '0',
user_cell_date int(11) NOT NULL default '0',
user_freed_by int(8) NOT NULL default '0',
user_sentence text,
user_caution int(8) NOT NULL default '0',
user_time int(11) NOT NULL default '0',
PRIMARY KEY (celled_id)
) TYPE=MyISAM;
CREATE TABLE phpbb_jail_votes (
vote_id mediumint(8) NOT NULL default '0',
voter_id mediumint(8) NOT NULL default '0',
vote_result mediumint(8) NOT NULL default '0',
KEY vote_id (vote_id),
KEY voter_id (voter_id)
) TYPE=MyISAM;
a ja neviem ako to a co s tym mam spravit.diky
|