Wrzuciłem:
Kod: Zaznacz cały
ALTER TABLE `phpbb_users`
ADD `user_plusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `user_minusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `user_disallowed_write` TINYINT ( 1 ) DEFAULT '0' NOT NULL ,
ADD `user_banned` TINYINT ( 1 ) DEFAULT '0' NOT NULL ,
ADD `user_diswrite_time` INT ( 32 ) NOT NULL ,
ADD `user_banned_time` INT ( 32 ) NOT NULL
;
ALTER TABLE `phpbb_posts`
ADD `post_plusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `post_minusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ;
CREATE TABLE `phpbb_plusminus` (
`pm_id` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`post_id` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_time` INT ( 32 ) NOT NULL ,
`pm_from` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_to` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_type` INT ( 2 ) NOT NULL ,
`pm_reason` VARCHAR ( 255 ) ,
`pm_value` INT ( 6 ) UNSIGNED DEFAULT '1' NOT NULL ,
`rule_id` INT ( 11 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `pm_id` )
);
CREATE TABLE `phpbb_plusminus_rules` (
`rule_id` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`rule_parent` INT ( 11 ) UNSIGNED NOT NULL ,
`rule_order` INT ( 11 ) UNSIGNED NOT NULL ,
`rule_topic` TEXT ,
`rule_text` TEXT ,
PRIMARY KEY ( `rule_id` )
);
CREATE TABLE `phpbb_plusminus_triggers` (
`trigger_id` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`trigger_type` INT ( 2 ) NOT NULL ,
`trigger_value` INT ( 6 ) NOT NULL ,
`trigger_action` INT ( 3 ) UNSIGNED NOT NULL ,
`trigger_time` INT ( 32 ) NOT NULL ,
PRIMARY KEY ( `trigger_id` )
);
CREATE TABLE `phpbb_mods_cache` (
`cache_id` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`cache_name` VARCHAR ( 255 ) NOT NULL ,
`cache_value` LONGBLOB ,
PRIMARY KEY ( `cache_id` )
);
ALTER TABLE `phpbb_groups`
ADD `auth_disallow_write` TINYINT( 11 ) DEFAULT '0' NOT NULL ,
ADD `auth_ban` TINYINT DEFAULT '0' NOT NULL ,
ADD `auth_remove_points` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `auth_add_plus` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `auth_add_minus` TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `phpbb_forums`
ADD `enable_pluspoints` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `enable_minuspoints` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `enable_plusadmin` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `enable_plusmod` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `enable_plusonlyauthor` TINYINT( 1 ) DEFAULT '1' NOT NULL;
I teraz mam:
Kod: Zaznacz cały
Plusminus error
DEBUG MODE
SQL Error : 1146 Table 'vtx.INTOphpbb_plusminus' doesn't exist
INSERT INTOphpbb_plusminus (post_id, pm_time, pm_from, pm_to, pm_type, pm_reason) VALUES (7,1212422858,2,3,1,'frgte')
Line : 555
File : plusminus.php