update sql file for 143 i could it find it on the zip...so here is one
#better thumbs
INSERT INTO cpg143_config (name, value) values ('enable_unsharp', '0');
INSERT INTO cpg143_config (name, value) values ('unsharp_amount', '120');
INSERT INTO cpg143_config (name, value) values ('unsharp_radius', '0.5');
INSERT INTO cpg143_config (name, value) values ('unsharp_threshold', '3');
INSERT INTO cpg143_config (name, value) values ('thumb_height', '140');
#watermark
INSERT INTO cpg143_config (name, value) values ('enable_watermark', '0');
INSERT INTO cpg143_config (name, value) values ('where_put_watermark', 'southeast');
INSERT INTO cpg143_config (name, value) values ('watermark_file', '/absolute/server/path/to/watermark.png');
INSERT INTO cpg143_config (name, value) values ('which_files_to_watermark', 'both');
INSERT INTO cpg143_config (name, value) values ('orig_pfx', 'orig_');
INSERT INTO cpg143_config (name, value) values ('watermark_transparency', '40');
INSERT INTO cpg143_config (name, value) values ('watermark_transparency_featherx', '0');
INSERT INTO cpg143_config (name, value) values ('watermark_transparency_feathery', '0');
#mini_thumbs
INSERT INTO cpg143_config (name, value) values ('enable_mini_thumbs', '0');
INSERT INTO cpg143_config (name, value) values ('mini_thumb_width', '60');
INSERT INTO cpg143_config (name, value) values ('mini_thumb_height', '60');
INSERT INTO cpg143_config (name, value) values ('mini_pfx', 'mini_');
INSERT INTO cpg143_config (name, value) values ('mini_as_category_lead', '1');
#notification system
INSERT INTO cpg143_config (name, value) values ('enable_user_notification', '0');
ALTER TABLE cpg143_users ADD auto_subscribe_post tinyint(4) NOT NULL DEFAULT 1;
ALTER TABLE cpg143_users ADD auto_subscribe_comment tinyint(4) NOT NULL DEFAULT 1;
CREATE TABLE cpg143_notify (
user_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
picture_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
mail_sent TINYINT(4) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (user_id, picture_id)
) TYPE=MyISAM;
#avatar
INSERT INTO cpg143_config (name, value) values ('enable_avatar', '0');
ALTER TABLE cpg143_users ADD avatar_url varchar(255) NOT NULL default '';
ALTER TABLE cpg143_comments ADD avatar_url varchar(255) NOT NULL default '';
#PMS
CREATE TABLE cpg143_pms (
id INT(10) NOT NULL AUTO_INCREMENT,
owner int(10) NOT NULL DEFAULT '',
subject VARCHAR(120) NOT NULL DEFAULT '',
message TEXT,
sender VARCHAR(120) NOT NULL DEFAULT '',
sender_id int(10) NOT NULL DEFAULT '',
posted INT(10) NOT NULL DEFAULT '',
sender_ip VARCHAR(120),
smileys TINYINT DEFAULT '1',
status TINYINT DEFAULT '0',
showed TINYINT DEFAULT '0',
replied TINYINT DEFAULT '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
ALTER TABLE cpg143_users ADD user_pmsmail tinyint(4) NOT NULL DEFAULT 1;
INSERT INTO cpg143_config (name, value) values ('pms_enabled', '0');
INSERT INTO cpg143_config (name, value) values ('pms_messages', '200');
INSERT INTO cpg143_config (name, value) values ('pms_enable_email', '1');
INSERT INTO cpg143_config (name, value) values ('pms_make_links', '1');
INSERT INTO cpg143_config (name, value) values ('pms_date_format', 'l dS of F Y ');
INSERT INTO cpg143_config (name, value) values ('pms_time_format', 'h:i:s');
INSERT INTO cpg143_config (name, value) values ('pms_smilies', '1');
INSERT INTO cpg143_config (name, value) values ('pms_post_flood', '30');
INSERT INTO cpg143_config (name, value) values ('pms_message_bbcode', '1');
INSERT INTO cpg143_config (name, value) values ('pms_message_img_tag', '1');
INSERT INTO cpg143_config (name, value) values ('display_buddy_status', '1');
INSERT INTO cpg143_config (name, value) values ('display_pms_status', '1');
#buddy
INSERT INTO cpg143_config (name, value) values ('enable_buddy', '0');
INSERT INTO cpg143_config (name, value) values ('enable_buddy_email', '1');
INSERT INTO cpg143_config (name, value) values ('enable_buddy_private_view', '1');
INSERT INTO cpg143_config (name, value) values ('buddy_enhanced_display', '1');
ALTER TABLE cpg143_users ADD enable_admin_email tinyint(4) NOT NULL DEFAULT 1;
CREATE TABLE `cpg143_buddy_req` (
`id` int(11) NOT NULL auto_increment,
`buddy_from` int(11) NOT NULL default '',
`buddy_to` int(11) NOT NULL default '',
`since` int(11) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `cpg143_buddy` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '',
`buddy_id` int(11) NOT NULL default '',
`buddy_ok` enum('YES','NO') NOT NULL default 'NO',
`buddy_block` enum('YES','NO') NOT NULL default 'NO',
`since` int(11) NOT NULL default '',
PRIMARY KEY (`id`,`user_id`)
) TYPE=MyISAM;
### performance settings, thumb desc settings
INSERT INTO cpg143_config (name, value) values ('fast_stats', '0');
INSERT INTO cpg143_config (name, value) values ('enable_stats', '0');
### misc settings
INSERT INTO cpg143_config (name, value) values ('enable_loginform', '0');
### right side adjusts
INSERT INTO cpg143_config (name, value) values ('info_block_align', '1');
INSERT INTO cpg143_config (name, value) values ('display_pic_voting', '0');
INSERT INTO cpg143_config (name, value) values ('display_pic_rating', '0');