in-bulletin
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Wed, Aug 13, 9:45 AM

in-bulletin
View Options

	Index: branches/5.2.x/install/install_schema.sql
	===================================================================
	--- branches/5.2.x/install/install_schema.sql (revision 16833)
	+++ branches/5.2.x/install/install_schema.sql (revision 16834)
	@@ -1,198 +1,198 @@
	CREATE TABLE Posting (
	PostingId int(11) NOT NULL AUTO_INCREMENT,
	- IPAddress varchar(255) NOT NULL DEFAULT '',
	+ IPAddress varchar(50) NOT NULL DEFAULT '',
	PosterAlias varchar(255) NOT NULL DEFAULT '',
	Pending tinyint(4) NOT NULL DEFAULT '0',
	`Subject` varchar(255) DEFAULT NULL,
	PostingText text,
	GraphicsUrl varchar(255) DEFAULT NULL,
	CreatedOn int(11) DEFAULT NULL,
	Modified int(11) DEFAULT NULL,
	ModifiedById int(11) DEFAULT NULL,
	CreatedById int(11) DEFAULT NULL,
	TopicId int(11) NOT NULL DEFAULT '0',
	ResourceId int(11) NOT NULL DEFAULT '0',
	ReplyTo int(11) NOT NULL DEFAULT '0',
	`Options` int(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (PostingId),
	KEY TopicId (TopicId),
	KEY Pending (Pending),
	KEY CreatedById (CreatedById),
	KEY CreatedOn (CreatedOn),
	KEY ModifiedOn (Modified),
	KEY ModifiedById (ModifiedById)
	);

	CREATE TABLE Topic (
	TopicId int(11) NOT NULL AUTO_INCREMENT,
	NotifyOwnerOnChanges tinyint(4) NOT NULL DEFAULT '0',
	Modified int(11) DEFAULT NULL,
	TopicText varchar(255) NOT NULL DEFAULT '',
	AutomaticFilename tinyint(3) unsigned NOT NULL DEFAULT '1',
	Posts int(11) NOT NULL DEFAULT '0',
	Views double(20,6) NOT NULL DEFAULT '0.000000',
	EditorsPick tinyint(4) NOT NULL DEFAULT '0',
	`Status` tinyint(4) unsigned NOT NULL DEFAULT '2',
	Priority int(11) NOT NULL DEFAULT '0',
	OwnerId int(11) DEFAULT NULL,
	ModifiedById int(11) DEFAULT NULL,
	ResourceId int(11) DEFAULT NULL,
	TopicType int(11) NOT NULL DEFAULT '1',
	CreatedOn int(11) DEFAULT NULL,
	CachedReviewsQty int(11) NOT NULL DEFAULT '0',
	CachedRating varchar(10) NOT NULL DEFAULT '0',
	CachedVotesQty int(11) NOT NULL DEFAULT '0',
	NewItem tinyint(4) NOT NULL DEFAULT '2',
	PopItem tinyint(4) NOT NULL DEFAULT '2',
	HotItem tinyint(4) NOT NULL DEFAULT '2',
	PostedBy varchar(255) NOT NULL DEFAULT '',
	OrgId int(11) DEFAULT NULL,
	LastPostId int(11) NOT NULL DEFAULT '0',
	LastPostDate int(11) DEFAULT NULL,
	TodayDate date DEFAULT NULL,
	TodayPosts int(11) NOT NULL DEFAULT '0',
	MetaKeywords varchar(255) DEFAULT NULL,
	MetaDescription text,
	PRIMARY KEY (TopicId),
	UNIQUE KEY ResourceId (ResourceId),
	KEY OwnerId (OwnerId),
	KEY ModifiedById (ModifiedById),
	KEY Posts (Posts),
	KEY Modified (Modified),
	KEY Views (Views),
	KEY EditorsPick (EditorsPick),
	KEY `Status` (`Status`),
	KEY Priority (Priority),
	KEY CreatedOn (CreatedOn),
	KEY NewItem (NewItem),
	KEY PopItem (PopItem),
	KEY HotItem (HotItem),
	KEY LastPostId (LastPostId)
	);

	CREATE TABLE Censorship (
	CensorshipId int(11) NOT NULL auto_increment,
	BadWord varchar(80) NOT NULL default '',
	Replacement varchar(80) NOT NULL default '',
	PRIMARY KEY (CensorshipId)
	);

	CREATE TABLE Emoticon (
	EmoticonId int(11) NOT NULL AUTO_INCREMENT,
	`Name` varchar(20) NOT NULL DEFAULT '',
	KeyStroke varchar(20) NOT NULL DEFAULT '',
	Enabled int(11) NOT NULL DEFAULT '1',
	EmotionImage varchar(255) NOT NULL DEFAULT '',
	PRIMARY KEY (EmoticonId),
	KEY Enabled (Enabled),
	KEY EmotionImage (EmotionImage)
	);

	CREATE TABLE PrivateMessageBody (
	PMBodyId int(11) unsigned NOT NULL AUTO_INCREMENT,
	`Subject` varchar(255) NOT NULL DEFAULT '',
	Body text,
	`Options` tinyint(3) unsigned NOT NULL DEFAULT '0',
	ReferenceCount smallint(5) unsigned NOT NULL DEFAULT '2',
	PRIMARY KEY (PMBodyId),
	KEY ReferenceCount (ReferenceCount)
	);

	CREATE TABLE PrivateMessages (
	PmId int(11) unsigned NOT NULL AUTO_INCREMENT,
	FromId int(11) unsigned DEFAULT NULL,
	ToId int(11) unsigned DEFAULT NULL,
	FolderId tinyint(3) NOT NULL DEFAULT '-1',
	`Status` tinyint(1) unsigned NOT NULL DEFAULT '0',
	PMBodyId int(11) unsigned NOT NULL DEFAULT '0',
	CreatedOn int(11) unsigned DEFAULT NULL,
	PRIMARY KEY (PmId),
	KEY FromId (FromId),
	KEY CreatedOn (CreatedOn),
	KEY ToId (ToId),
	KEY FolderId (FolderId)
	);

	CREATE TABLE TopicCustomData (
	CustomDataId int(11) NOT NULL auto_increment,
	ResourceId int(10) unsigned NOT NULL default '0',
	KEY ResourceId (ResourceId),
	PRIMARY KEY (CustomDataId)
	);

	CREATE TABLE Polls (
	PollId int(11) NOT NULL AUTO_INCREMENT,
	`Name` varchar(255) NOT NULL DEFAULT '',
	l1_Question text,
	l2_Question text,
	l3_Question text,
	l4_Question text,
	l5_Question text,
	Image varchar(255) NOT NULL DEFAULT '',
	CreatedOn int(11) unsigned DEFAULT NULL,
	StartDate int(11) unsigned DEFAULT NULL,
	EndDate int(11) unsigned DEFAULT NULL,
	Priority tinyint(4) NOT NULL DEFAULT '0',
	RequireLogin tinyint(4) NOT NULL DEFAULT '0',
	AllowMultipleVotings tinyint(4) NOT NULL DEFAULT '1',
	AllowComments tinyint(4) NOT NULL DEFAULT '1',
	`Status` tinyint(4) NOT NULL DEFAULT '1',
	CachedVotesQty int(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (PollId),
	KEY `Status` (`Status`),
	KEY Priority (Priority),
	KEY StartDate (StartDate),
	KEY EndDate (EndDate)
	);

	CREATE TABLE PollsAnswers (
	AnswerId int(11) NOT NULL AUTO_INCREMENT,
	PollId int(11) NOT NULL DEFAULT '0',
	l1_Answer text,
	l2_Answer text,
	l3_Answer text,
	l4_Answer text,
	l5_Answer text,
	VotesQty int(11) NOT NULL DEFAULT '0',
	Priority int(11) NOT NULL DEFAULT '0',
	`Status` tinyint(4) NOT NULL DEFAULT '1',
	PRIMARY KEY (AnswerId),
	KEY `Status` (`Status`),
	KEY Priority (Priority),
	KEY VoteCount (VotesQty),
	KEY PollId (PollId)
	);

	CREATE TABLE PollsComments (
	CommentId int(11) NOT NULL AUTO_INCREMENT,
	PollId int(11) NOT NULL DEFAULT '0',
	AnswerId int(11) DEFAULT NULL,
	CreatedById int(11) DEFAULT NULL,
	GuestName varchar(255) NOT NULL DEFAULT '',
	GuestEmail varchar(255) NOT NULL DEFAULT '',
	CommentBody text,
	CreatedOn int(11) DEFAULT NULL,
	- UserIP varchar(255) NOT NULL DEFAULT '',
	+ UserIP varchar(50) NOT NULL DEFAULT '',
	Priority int(11) NOT NULL DEFAULT '0',
	`Status` tinyint(4) NOT NULL DEFAULT '1',
	PRIMARY KEY (CommentId),
	KEY `Status` (`Status`),
	KEY Priority (Priority),
	KEY CreatedOn (CreatedOn),
	KEY AnswerId (AnswerId),
	KEY PollId (PollId),
	KEY CreatedById (CreatedById)
	);

	CREATE TABLE PollsStatistics (
	StatisticsId int(11) NOT NULL AUTO_INCREMENT,
	PollId int(11) NOT NULL DEFAULT '0',
	AnswerId int(11) NOT NULL DEFAULT '0',
	CreatedById int(11) NOT NULL DEFAULT '-2',
	- UserIP varchar(255) NOT NULL DEFAULT '',
	+ UserIP varchar(50) NOT NULL DEFAULT '',
	AnswerDate int(10) unsigned DEFAULT NULL,
	PRIMARY KEY (StatisticsId),
	KEY AnswerId (AnswerId,PollId),
	KEY CreatedById (CreatedById),
	KEY UserIP (UserIP)
	-);
	\ No newline at end of file
	+);
	Index: branches/5.2.x/install/upgrades.sql
	===================================================================
	--- branches/5.2.x/install/upgrades.sql (revision 16833)
	+++ branches/5.2.x/install/upgrades.sql (revision 16834)
	@@ -1,284 +1,289 @@
	# ===== v 4.3.9 =====
	ALTER TABLE Emoticon
	ADD EmotionImage VARCHAR(255) NOT NULL,
	ADD INDEX (EmotionImage),
	DROP ImageId;

	UPDATE Emoticon SET EmotionImage = CONCAT('0_',EmoticonId,'.gif') WHERE EmoticonId < 21;

	# ===== v 5.0.0 =====
	CREATE TABLE Polls (
	PollId int(11) NOT NULL auto_increment,
	`Name` varchar(255) NOT NULL default '',
	l1_Question text,
	l2_Question text,
	l3_Question text,
	l4_Question text,
	l5_Question text,
	Image varchar(255) NOT NULL default '',
	CreatedOn int(11) unsigned NOT NULL,
	StartDate int(11) unsigned NOT NULL,
	EndDate int(11) unsigned default NULL,
	Priority tinyint(4) NOT NULL default '0',
	RequireLogin tinyint(4) NOT NULL default '0',
	AllowMultipleVotings tinyint(4) NOT NULL default '1',
	AllowComments tinyint(4) NOT NULL default '1',
	`Status` tinyint(4) NOT NULL default '1',
	CachedVotesQty int(11) NOT NULL,
	PRIMARY KEY (PollId),
	KEY `Status` (`Status`),
	KEY Priority (Priority),
	KEY StartDate (StartDate),
	KEY EndDate (EndDate)
	);

	CREATE TABLE PollsAnswers (
	AnswerId int(11) NOT NULL auto_increment,
	PollId int(11) NOT NULL,
	l1_Answer text,
	l2_Answer text,
	l3_Answer text,
	l4_Answer text,
	l5_Answer text,
	VotesQty int(11) NOT NULL,
	Priority int(11) NOT NULL default '0',
	Status tinyint(4) NOT NULL default '1',
	PRIMARY KEY (AnswerId),
	KEY Status (Status),
	KEY Priority (Priority),
	KEY VoteCount (VotesQty),
	KEY PollId (PollId)
	);

	CREATE TABLE PollsComments (
	CommentId int(11) NOT NULL auto_increment,
	PollId int(11) NOT NULL,
	AnswerId int(11) default NULL,
	CreatedById int(11) NOT NULL default '-2',
	GuestName varchar(255) NOT NULL,
	GuestEmail varchar(255) NOT NULL,
	CommentBody text,
	CreatedOn int(11) NOT NULL,
	UserIP varchar(255) NOT NULL,
	Priority int(11) NOT NULL,
	`Status` tinyint(4) NOT NULL default '1',
	PRIMARY KEY (CommentId),
	KEY `Status` (`Status`),
	KEY Priority (Priority),
	KEY CreatedOn (CreatedOn),
	KEY AnswerId (AnswerId),
	KEY PollId (PollId),
	KEY CreatedById (CreatedById)
	);

	CREATE TABLE PollsStatistics (
	StatisticsId int(11) NOT NULL auto_increment,
	PollId int(11) NOT NULL default '0',
	AnswerId int(11) NOT NULL default '0',
	CreatedById int(11) NOT NULL default '-2',
	UserIP varchar(255) NOT NULL,
	AnswerDate int(10) unsigned default NULL,
	PRIMARY KEY (StatisticsId),
	KEY AnswerId (AnswerId,PollId),
	KEY CreatedById (CreatedById),
	KEY UserIP (UserIP)
	);

	INSERT INTO ConfigurationAdmin VALUES ('poll_CommentDelay_Value', 'la_Text_Polls', 'la_prompt_DupPollComments', 'text', '', '', 60.1, 1, 1);
	INSERT INTO ConfigurationAdmin VALUES ('poll_CommentDelay_Interval', 'la_Text_Polls', 'la_prompt_DupPollComments', 'select', '', '1=la_Text_Second,60=la_Text_Minute,3600=la_Text_Hour,86400=la_Text_Day,604800=la_Text_Week,2419200=la_Text_Month,29030400=la_text_Year', 60.2, 2, 1);
	INSERT INTO ConfigurationValues VALUES (DEFAULT, 'poll_CommentDelay_Interval', '60', 'In-Bulletin', 'in-bulletin:configuration_output');
	INSERT INTO ConfigurationValues VALUES (DEFAULT, 'poll_CommentDelay_Value', '10', 'In-Bulletin', 'in-bulletin:configuration_output');

	UPDATE Category SET Template = '/in-bulletin/designs/section' WHERE Template = 'inbulletin/index';
	UPDATE Category SET CachedTemplate = '/in-bulletin/designs/section' WHERE CachedTemplate = 'inbulletin/index';

	UPDATE ConfigurationValues SET VariableValue = '/in-bulletin/designs/section' WHERE VariableName = 'bb_CategoryTemplate';
	UPDATE ConfigurationValues SET VariableValue = 'in-bulletin/designs/detail' WHERE VariableName = 'bb_ItemTemplate';

	INSERT INTO Permissions VALUES (DEFAULT, 'in-bulletin:topics.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-bulletin:setting_folder.view', 11, 1, 1, 0);
	DELETE FROM Permissions WHERE Permission LIKE 'in-bulletin:inbulletin_general.%';

	UPDATE Phrase SET Module = 'In-Bulletin' WHERE ((Phrase LIKE '%Topic%' OR Phrase LIKE '%Post%' OR Phrase LIKE '%Forum%' OR Phrase LIKE '%Censor%' OR Phrase LIKE '%Smiley%' OR Phrase = 'la_title_In-Bulletin') AND (Module = 'Core'));

	# ===== v 5.0.1 =====
	UPDATE ConfigurationValues SET VariableValue = 'in-bulletin/topics/topic_detail' WHERE VariableName = 'bb_ItemTemplate';

	UPDATE ConfigurationAdmin
	SET ValueList = 'TopicText=la_opt_TopicText,Posts=la_opt_NumberOfPosts,CreatedOn=la_opt_CreatedOn,LastPostDate=la_opt_LastUpdated,Views=la_opt_TopicViews,CachedRating=la_opt_Rating,LastPoser=la_opt_LastPoster,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 3) AND (IsSystem = 0)</SQL>'
	WHERE VariableName IN ('Topic_SortField', 'Topic_SortField2');

	UPDATE ConfigurationAdmin
	SET ValueList = 'ASC=la_common_Ascending,DESC=la_common_Descending'
	WHERE VariableName IN ('Topic_SortOrder', 'Topic_SortOrder2');

	UPDATE ConfigurationAdmin SET ValueList = '1=la_opt_Sec,60=la_opt_Min,3600=la_opt_Hour,86400=la_opt_Day,604800=la_opt_Week,2419200=la_opt_Month,29030400=la_opt_Year' WHERE VariableName = 'topic_ReviewDelay_Interval';
	UPDATE ConfigurationAdmin SET ValueList = '1=la_opt_Sec,60=la_opt_Min,3600=la_opt_Hour,86400=la_opt_Day,604800=la_opt_Week,2419200=la_opt_Month,29030400=la_opt_Year' WHERE VariableName = 'topic_RatingDelay_Interval';
	UPDATE ConfigurationAdmin SET ValueList = '1=la_opt_Sec,60=la_opt_Min,3600=la_opt_Hour,86400=la_opt_Day,604800=la_opt_Week,2419200=la_opt_Month,29030400=la_opt_Year' WHERE VariableName = 'poll_CommentDelay_Interval';

	UPDATE CustomField SET FieldLabel = 'la_fld_cust_bb_ItemTemplate', Prompt = 'la_fld_cust_bb_ItemTemplate' WHERE FieldName = 'bb_ItemTemplate';

	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.ADD', NULL, 1, 1, NULL, 'In-Bulletin', 'la_event_topic.add', 0);
	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.ADD.PENDING', NULL, 1, 1, NULL, 'In-Bulletin', 'la_event_topic.add.pending', 1);
	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.ADD.PENDING', NULL, 1, 1, NULL, 'In-Bulletin', 'la_event_topic.add.pending', 0);
	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.MODIFY', NULL, 1, 1, NULL, 'In-Bulletin', 'la_event_topic.modify', 1);
	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.MODIFY', NULL, 1, 1, NULL, 'In-Bulletin', 'la_event_topic.modify', 0);
	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.MODIFY.PENDING', NULL, 1, 1, NULL, 'In-Bulletin', 'la_event_topic.modify.pending', 1);
	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.MODIFY.PENDING', NULL, 1, 1, NULL, 'In-Bulletin', 'la_event_topic.modify.pending', 0);
	INSERT INTO Events VALUES(DEFAULT, 'TOPIC.APPROVE', NULL, 1, 0, NULL, 'In-Bulletin', 'la_event_topic.approve', 0);

	UPDATE ConfigurationAdmin SET ValueList = 'style="width: 50px;"' WHERE VariableName IN ('topic_ReviewDelay_Value', 'topic_RatingDelay_Value', 'poll_CommentDelay_Value');

	# ===== v 5.0.2-B1 =====
	ALTER TABLE PrivateMessageBody CHANGE Body Body text NULL;

	ALTER TABLE Emoticon CHANGE EmotionImage EmotionImage VARCHAR(255) NOT NULL DEFAULT '';

	ALTER TABLE Polls
	CHANGE CreatedOn CreatedOn INT(11) UNSIGNED NULL DEFAULT NULL ,
	CHANGE StartDate StartDate INT(11) UNSIGNED NULL DEFAULT NULL ,
	CHANGE CachedVotesQty CachedVotesQty INT(11) NOT NULL DEFAULT '0';

	ALTER TABLE PollsAnswers
	CHANGE PollId PollId INT(11) NOT NULL DEFAULT '0',
	CHANGE VotesQty VotesQty INT(11) NOT NULL DEFAULT '0';

	ALTER TABLE PollsComments
	CHANGE PollId PollId INT(11) NOT NULL DEFAULT '0',
	CHANGE GuestName GuestName VARCHAR(255) NOT NULL DEFAULT '',
	CHANGE GuestEmail GuestEmail VARCHAR(255) NOT NULL DEFAULT '',
	CHANGE CreatedOn CreatedOn INT(11) NULL DEFAULT NULL ,
	CHANGE UserIP UserIP VARCHAR(255) NOT NULL DEFAULT '',
	CHANGE Priority Priority INT(11) NOT NULL DEFAULT '0';

	ALTER TABLE PollsStatistics CHANGE UserIP UserIP VARCHAR(255) NOT NULL DEFAULT '';

	ALTER TABLE Posting
	CHANGE CreatedOn CreatedOn INT(11) NULL DEFAULT NULL,
	CHANGE Modified Modified INT(11) NULL DEFAULT NULL;

	ALTER TABLE PrivateMessages CHANGE CreatedOn CreatedOn INT(11) UNSIGNED NULL DEFAULT NULL;

	ALTER TABLE Topic
	CHANGE Modified Modified INT(11) NULL DEFAULT NULL,
	CHANGE CreatedOn CreatedOn INT(11) NULL DEFAULT NULL;

	# ===== v 5.0.2-B2 =====

	# ===== v 5.0.2-RC1 =====

	# ===== v 5.0.2 =====

	# ===== v 5.0.3-B1 =====

	# ===== v 5.0.3-B2 =====

	# ===== v 5.0.3-RC1 =====

	# ===== v 5.0.3 =====

	# ===== v 5.0.4-B1 =====

	# ===== v 5.0.4-B2 =====

	# ===== v 5.0.4 =====

	# ===== v 5.1.0-B1 =====
	UPDATE Modules SET Path = 'modules/in-bulletin/' WHERE `Name` = 'In-Bulletin';
	DELETE FROM ConfigurationValues WHERE VariableName IN (
	'Post_Sortfield', 'Post_SortOrder', 'Perpage_PrivateMessages', 'Topic_Root',
	'Topic_Background1', 'Topic_Background2', 'Post_Background1', 'Post_Background2',
	'Posting_SortOrder', 'Bulletin_TopCount', 'Bulletin_CatNewDays', 'Bulletin_Pick_First'
	);
	UPDATE ConfigurationValues SET ModuleOwner = 'In-Bulletin' WHERE VariableName = 'BBTags';

	UPDATE Phrase SET Module = 'Core' WHERE Phrase = 'la_fld_Replacement';
	DELETE FROM Permissions WHERE Permission LIKE 'in-bulletin:configuration_email%';

	# ===== v 5.1.0-B2 =====

	# ===== v 5.1.0-RC1 =====

	# ===== v 5.1.0 =====

	# ===== v 5.1.1-B1 =====
	ALTER TABLE PollsComments CHANGE CreatedById CreatedById INT(11) NULL DEFAULT NULL;

	ALTER TABLE Topic
	CHANGE OwnerId OwnerId INT( 11 ) NULL DEFAULT NULL ,
	CHANGE ModifiedById ModifiedById INT( 11 ) NULL DEFAULT NULL;

	UPDATE Topic SET ModifiedById = NULL WHERE ModifiedById = 0;

	# ===== v 5.1.1-B2 =====

	# ===== v 5.1.1-RC1 =====

	# ===== v 5.1.1 =====

	# ===== v 5.1.2-B1 =====

	# ===== v 5.1.2-RC1 =====

	# ===== v 5.1.2 =====

	# ===== v 5.1.3-B1 =====

	# ===== v 5.1.3-B2 =====

	# ===== v 5.1.3-RC1 =====
	UPDATE ConfigurationValues
	SET VariableValue = 'in-bulletin/topics/topic_detail'
	WHERE VariableName = 'bb_ItemTemplate' AND VariableValue = 'in-bulletin/designs/detail';

	# ===== v 5.1.3-RC2 =====

	# ===== v 5.1.3 =====
	UPDATE Phrase
	SET `Module` = 'Core'
	WHERE PhraseKey = 'LA_FLD_REQUIRELOGIN';

	# ===== v 5.2.0-B1 =====
	UPDATE SearchConfig
	SET DisplayName = REPLACE(DisplayName, 'lu_', 'lc_')
	WHERE DisplayName IN (
	'lu_field_notifyowneronchanges', 'lu_field_topicid', 'lu_field_ownerid',
	'lu_field_topictext', 'lu_field_postedby', 'lu_field_lastpostid'
	);

	DELETE FROM LanguageLabels
	WHERE PhraseKey IN ('LA_POSTS_NEWDAYS_PROMPT');

	DELETE FROM SystemSettings
	WHERE VariableName IN ('Topic_Highlight_OpenTag', 'Topic_Highlight_CloseTag', 'Posts_NewDays');

	# ===== v 5.2.0-B2 =====
	UPDATE Topic main_table
	SET main_table.CachedReviewsQty = (SELECT COUNT(*) FROM <%TABLE_PREFIX%>CatalogReviews review_table WHERE review_table.ItemId = main_table.ResourceId);

	# ===== v 5.2.0-B3 =====
	INSERT INTO EmailEvents (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, Module, Description, Type, AllowChangingSender, AllowChangingRecipient, BindToSystemEvent) VALUES(DEFAULT, 'POST.ADD.SUB', NULL, 1, 0, 'In-Bulletin', 'Post Added (for subscribers)', 0, 1, 0, 'bb-post:OnCreate');
	INSERT INTO EmailEvents (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, Module, Description, Type, AllowChangingSender, AllowChangingRecipient, BindToSystemEvent) VALUES(DEFAULT, 'TOPIC.ADD.SUB', NULL, 1, 0, 'In-Bulletin', 'Topic Added (for subscribers)', 0, 1, 0, 'bb:OnCreate');

	# ===== v 5.2.0-RC1 =====

	# ===== v 5.2.0 =====
	INSERT INTO Permissions VALUES(DEFAULT, 'in-bulletin:configuration_output.add', 11, 1, 1, 0);

	# ===== v 5.2.1-B1 =====

	# ===== v 5.2.1-B2 =====
	UPDATE Modules
	SET ClassNamespace = 'Intechnic\\InPortal\\Modules\\InBulletin'
	WHERE `Name` = 'In-Bulletin';

	# ===== v 5.2.1-RC1 =====

	# ===== v 5.2.1 =====

	# ===== v 5.2.2-B1 =====

	# ===== v 5.2.2-B2 =====
	UPDATE Modules
	SET ClassNamespace = 'InPortal\\Modules\\InBulletin'
	WHERE `Name` = 'In-Bulletin';
	+
	+# ===== v 5.2.2-B3 =====
	+ALTER TABLE PollsComments CHANGE `UserIP` `UserIP` varchar(50) NOT NULL DEFAULT '';
	+ALTER TABLE PollsStatistics CHANGE `UserIP` `UserIP` varchar(50) NOT NULL DEFAULT '';
	+ALTER TABLE Posting CHANGE `IPAddress` `IPAddress` varchar(50) NOT NULL DEFAULT '';
	Index: branches/5.2.x/units/poll_comments/poll_comments_config.php
	===================================================================
	--- branches/5.2.x/units/poll_comments/poll_comments_config.php (revision 16833)
	+++ branches/5.2.x/units/poll_comments/poll_comments_config.php (revision 16834)
	@@ -1,112 +1,112 @@
	<?php
	/**
	* @version $Id$
	* @package In-Bulletin
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	$config = Array (
	'Prefix' => 'poll-comment',

	'ItemClass' => Array ('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'),
	'ListClass' => Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'),
	'EventHandlerClass' => Array ('class' => 'PollCommentEventHandler', 'file' => 'poll_comment_eh.php', 'build_event' => 'OnBuild'),
	'TagProcessorClass' => Array ('class' => 'kDBTagProcessor', 'file' => '', 'build_event' => 'OnBuild'),

	'AutoLoad' => true,

	'QueryString' => Array (
	1 => 'id',
	2 => 'Page',
	3 => 'PerPage',
	4 => 'event',
	),

	'IDField' => 'CommentId',
	'TableName' => TABLE_PREFIX . 'PollsComments',

	'ParentPrefix' => 'poll',
	'ForeignKey' => 'PollId',
	'ParentTableKey' => 'PollId',
	'AutoDelete' => true,
	'AutoClone' => true,

	'StatusField' => Array ('Status'),

	// key - special, value - list select sql
	'ListSQLs' => Array (
	'' => ' SELECT %1$s.* %2$s
	FROM %1$s
	LEFT JOIN '.TABLE_PREFIX.'Users pu ON pu.PortalUserId = %1$s.CreatedById',
	),

	'ListSortings' => Array (
	'' => Array (
	'ForcedSorting' => Array ('Priority' => 'desc'),
	'Sorting' => Array ('CreatedOn' => 'desc'),
	)
	),

	'Fields' => Array (
	'CommentId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'PollId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'AnswerId' => Array ('type' => 'int', 'default' => NULL),
	'CreatedById' => Array (
	'type' => 'int',
	'formatter' => 'kLEFTFormatter',
	'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'),
	'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'),
	'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Users WHERE %s',
	'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD,
	'required' => 1, 'default' => NULL
	),
	'GuestName' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''),
	'GuestEmail' => Array('type' => 'string', 'max_len' => 255, 'formatter' => 'kFormatter', 'regexp' => '/^(' . REGEX_EMAIL_USER . '@' . REGEX_EMAIL_DOMAIN . ')$/i', 'sample_value' => 'email@domain.com', 'not_null' => '1', 'default' => '', 'error_msgs' => Array ('invalid_format' => '!la_invalid_email!', 'unique' => '!lu_email_already_exist!'), 'required' => 0),
	'CommentBody' => Array ('type' => 'string', 'required' => 1, 'default' => NULL),
	'CreatedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'required' => 1, 'default' => '#NOW#'),
	- 'UserIP' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''),
	+ 'UserIP' => Array ('type' => 'string', 'max_len' => 50, 'not_null' => 1, 'default' => ''),
	'Priority' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'Status' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_opt_Active', 0 => 'la_opt_Disabled', 2 => 'la_opt_Pending'), 'use_phrases' => 1, 'required' => 1, 'not_null' => 1, 'default' => 1),
	),

	'VirtualFields' => Array (
	'CommentedByUser' => Array ('type' => 'string', 'default' => ''),
	'CommentedByEmail' => Array ('type' => 'string', 'default' => ''),
	),

	'CalculatedFields' => Array (
	'' => Array (
	'CommentedByUser' => 'IF( ISNULL(pu.Username), IF (%1$s.CreatedById = ' . USER_ROOT . ', \'root\', IF (%1$s.CreatedById = ' . USER_GUEST . ', \'Guest\', \'n/a\')), IF(pu.Username = "", pu.Email, pu.Username))',
	),
	),

	'Grids' => Array (
	'Default' => Array (
	'Icons' => Array (
	'default' => 'icon16_item.png',
	0 => 'icon16_disabled.png',
	1 => 'icon16_item.png',
	2 => 'icon16_pending.png',
	'module' => 'core',
	),
	'Fields' => Array (
	'CommentId' => Array ('title' => 'column:la_fld_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60, ),
	'CommentBody' => Array ('title' => 'column:la_fld_PollComment', 'data_block' => 'grid_priority_td', 'filter_block' => 'grid_like_filter', 'width' => 250, ),

	'CommentedByUser' => Array ( 'title' => 'la_col_CommentedByUser', 'filter_block' => 'grid_like_filter', 'width' => 150, ),

	'CreatedOn' => Array ('filter_block' => 'grid_date_range_filter', 'width' => 145, ),
	'Status' => Array ('filter_block' => 'grid_options_filter', 'width' => 100, ),
	),
	),
	),
	);
	Index: branches/5.2.x/units/posts/posts_config.php
	===================================================================
	--- branches/5.2.x/units/posts/posts_config.php (revision 16833)
	+++ branches/5.2.x/units/posts/posts_config.php (revision 16834)
	@@ -1,111 +1,111 @@
	<?php
	/**
	* @version $Id$
	* @package In-Bulletin
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	$config = Array (
	'Prefix' => 'bb-post',
	'ItemClass' => Array ('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'),
	'ListClass' => Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'),
	'EventHandlerClass' => Array ('class' => 'PostEventHandler', 'file' => 'post_eh.php', 'build_event' => 'OnBuild'),
	'TagProcessorClass' => Array ('class' => 'PostTagProcessor', 'file' => 'post_tp.php', 'build_event' => 'OnBuild'),

	'AutoLoad' => true,

	'QueryString' => Array (
	1 => 'id',
	2 => 'Page',
	3 => 'PerPage',
	4 => 'event',
	),

	'IDField' => 'PostingId',
	'StatusField' => Array ('Pending'),

	'TitleField' => 'Subject',

	'TableName' => TABLE_PREFIX.'Posting',

	'ForeignKey' => 'TopicId',
	'ParentTableKey' => 'TopicId',
	'ParentPrefix' => 'bb',
	'AutoDelete' => true,
	'AutoClone' => true,

	'ListSQLs' => Array (
	'' => ' SELECT %1$s.* %2$s
	FROM %1$s
	LEFT JOIN '.TABLE_PREFIX.'Users u ON %1$s.CreatedById = u.PortalUserId
	LEFT JOIN '.TABLE_PREFIX.'CatalogImages img ON (img.ResourceId = u.ResourceId) AND (img.DefaultImg = 1 OR img.Name = "avatar")',
	),

	'ListSortings' => Array (
	'' => Array (
	'ForcedSorting' => Array ('CreatedOn' => 'asc',),
	),
	),

	'CalculatedFields' => Array (
	'' => Array (
	'UserName' => 'IF (ISNULL(u.Username), IF (%1$s.CreatedById = ' . USER_ROOT . ', "root", IF (%1$s.CreatedById = ' . USER_GUEST . ', "Guest", "n/a")), IF(u.Username = "", u.Email, u.Username))',

	'AltName' => 'img.AltName',
	'SameImages' => 'img.SameImages',
	'LocalThumb' => 'img.LocalThumb',
	'ThumbPath' => 'img.ThumbPath',
	'ThumbUrl' => 'img.ThumbUrl',
	'LocalImage' => 'img.LocalImage',
	'LocalPath' => 'img.LocalPath',
	'FullUrl' => 'img.Url',
	),
	),

	'Fields' => Array (
	'PostingId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	- 'IPAddress' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''),
	+ 'IPAddress' => Array ('type' => 'string', 'max_len' => 50, 'not_null' => 1, 'default' => ''),
	'PosterAlias' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''),
	'Pending' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'Subject' => Array ('type' => 'string', 'max_len' => 255, 'default' => NULL),
	'PostingText' => Array ('type' => 'string', 'allow_html' => 1, 'default' => NULL),
	'GraphicsUrl' => Array ('type' => 'string', 'max_len' => 255, 'default' => NULL),
	'CreatedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
	'Modified' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => NULL),
	'ModifiedById' => Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'Users WHERE %s', 'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD, 'default' => NULL),
	'CreatedById' => Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'Users WHERE %s', 'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD, 'default' => NULL),
	'TopicId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'ResourceId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'ReplyTo' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'Options' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	),

	'VirtualFields' => Array (
	'DisableBBCodes' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'default' => 0),
	'DisableSmileys' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'default' => 0),
	'ShowSignatures' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_No', 1 => 'la_Yes'), 'use_phrases' => 1, 'default' => 0),
	'UserName' => Array ('type' => 'string', 'default' => ''),
	// for avatar image
	'AltName' => Array ('type' => 'string', 'default' => ''),
	'SameImages' => Array ('type' => 'string', 'default' => ''),
	'LocalThumb' => Array ('type' => 'string', 'default' => ''),
	'ThumbPath' => Array ('type' => 'string', 'default' => ''),
	'ThumbUrl' => Array ('type' => 'string', 'default' => ''),
	'LocalImage' => Array ('type' => 'string', 'default' => ''),
	'LocalPath' => Array ('type' => 'string', 'default' => ''),
	'FullUrl' => Array ('type' => 'string', 'default' => ''),
	),

	'ConfigMapping' => Array (
	'PerPage' => 'Perpage_Postings',
	),
	);

in-bulletinNo OneTemporaryActions

File Metadata

in-bulletinView Options

Event Timeline

in-bulletin
No OneTemporary
Actions

in-bulletin
View Options