Polskie forum wsparcia dla phpBB

Kod: Zaznacz cały

Plusminus error

DEBUG MODE

SQL Error : 1146 Table 'vtx.phpbb_plusminus' doesn't exist

INSERT INTO phpbb_plusminus (post_id, pm_time, pm_from, pm_to, pm_type, pm_reason) VALUES (5,1212421431,2,3,-1,'hfgbnfgn')

Line : 555
File : plusminus.php

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;

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

Kod: Zaznacz cały

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` )
);

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,1212423796,2,3,1,'vbhumc')

Line : 555
File : plusminus.php

Kod: Zaznacz cały

$sql='INSERT INTO '.PLUSMINUS_TABLE.' (post_id, pm_time, pm_from, pm_to, pm_type, pm_reason) VALUES ('.$post_id.','.time().','.$userdata['user_id'].','.$poster_id.','.$typeint.','."'$reason'".')';