[Phpbbproject-svn] SF.net SVN: phpbbproject: [269] trunk/phpbb3/root/project_install/schemas/ schema_data.sql

[<lor...@us...>]

Revision: 269
          http://phpbbproject.svn.sourceforge.net/phpbbproject/?rev=269&view=rev
Author:   lord_le_brand
Date:     2008-04-24 06:20:07 -0700 (Thu, 24 Apr 2008)

Log Message:
-----------
Changed default project to Forum prune move (that also fixed a nub)

Modified Paths:
--------------
    trunk/phpbb3/root/project_install/schemas/schema_data.sql

Modified: trunk/phpbb3/root/project_install/schemas/schema_data.sql
===================================================================
--- trunk/phpbb3/root/project_install/schemas/schema_data.sql	2008-04-23 23:59:42 UTC (rev 268)
+++ trunk/phpbb3/root/project_install/schemas/schema_data.sql	2008-04-24 13:20:07 UTC (rev 269)
@@ -154,23 +154,46 @@
 INSERT INTO phpbb_project_categories (parent_id, left_id, right_id, category_title, category_description) VALUES (0, 0, 1, '{L_PROJECT_TEST_CAT_TITLE}', '{L_PROJECT_TEST_CAT_DESC}');
 
 # Project
-INSERT INTO phpbb_project_projects (category_id, topic_id, project_title, project_description, project_level, project_install_time, project_notes, project_license, project_target_version, project_version, project_stage, project_start_time, project_start_id, project_start_author, project_last_update, is_active, file_only, project_downloads) VALUES (1, 0, '{L_PROJECT_TESTING_TITLE}', '{L_PROJECT_TESTING_DESCRIPTION}', 1, 60, '{L_PROJECT_TESTING_NOTES}', 1, '3.0.RC2', '1.2.3', 3, 1167609600, 2, 'Lord Le Brand', 1185926400, 1, 0, 0);
+INSERT INTO phpbb_project_projects (category_id, topic_id, project_title, project_title_clean, project_description, project_level, project_install_time, project_notes, project_license, project_target_version, project_version, project_stage, project_target, project_logo, project_logo_type, project_logo_width, project_logo_height, project_start_time, project_owner, project_last_update, project_status, file_only, project_downloads) VALUES (1, 1, 0, 'Forum prune move', 'forum prune move', 'Add an option to move posts instead of delete them on pruning.', 1, 180, 'Requested by bulldogg597, one of the best MOD requests i''ve seen.', 1, '3.0.0', '1.0.1', 4, '', '', 0, 0, 0, 1203634800, 2, 1207951200, 1, 0, 0);
 
+# Author - acutally Igor but meh...
+INSERT INTO phpbb_project_project_authors (project_id, author_id, author_role) SELECT 1, 2, role_id FROM phpbb_acl_roles WHERE role_name = 'ROLE_PROJECT_MANAGER';
+
 # Versions
-INSERT INTO phpbb_project_versions (project_id, version_time, version_major, version_minor, version_revision, version_release, version_stage, version_changelog) VALUES (1, 1171411200, 0, 1, 0, '', 2, '{L_PROJECT_TEST_CHANGELOG_OLD}');
-INSERT INTO phpbb_project_versions (project_id, version_time, version_major, version_minor, version_revision, version_release, version_stage, version_changelog) VALUES (1, 1185926400, 1, 2, 3, '', 3, '{L_PROJECT_TEST_CHANGELOG_NEW}');
+INSERT INTO phpbb_project_versions (version_id, project_id, previous_id, version_time, version_major, version_minor, version_revision, version_stage, version_release, version_changelog) VALUES (1, 1, 0, 1203634800, 1, 0, 0, 4, '', 'Initial release');
+INSERT INTO phpbb_project_versions (version_id, project_id, previous_id, version_time, version_major, version_minor, version_revision, version_stage, version_release, version_changelog) VALUES (2, 1, 1, 1207432800, 1, 0, 0, 4, 'a', 'MODX file');
+INSERT INTO phpbb_project_versions (version_id, project_id, previous_id, version_time, version_major, version_minor, version_revision, version_stage, version_release, version_changelog) VALUES (3, 1, 2, 1207951200, 1, 0, 1, 4, '', 'some small changes and fixed pauls pickyness');
 
 # Actions
-INSERT INTO phpbb_project_actions (project_id) VALUES (1);
-INSERT INTO phpbb_project_actions (project_id) VALUES (1);
-INSERT INTO phpbb_project_actions (project_id) VALUES (1);
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (1, 1, 1, 1203634800, 0, '', 1, 'ALTER TABLE phpbb_forums ADD COLUMN prune_move INT(9) UNSIGNED NOT NULL DEFAULT 0;', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (2, 1, 1, 1203634800, 10, 'adm/style/acp_forums.html', 4, '		<dl>\n			<dt><label for="prune_sticky">{L_PRUNE_STICKY}:</label></dt>\n			<dd><label><input type="radio" class="radio" name="prune_sticky" value="1"<!-- IF S_PRUNE_STICKY --> id="prune_sticky" checked="checked"<!-- ENDIF --> /> {L_YES}</label>\n				<label><input type="radio" class="radio" name="prune_sticky" value="0"<!-- IF not S_PRUNE_STICKY --> id="prune_sticky" checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>\n		</dl>', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (3, 1, 1, 1203634800, 20, 'adm/style/acp_forums.html', 5, '		<dl>\n			<dt><label for="prune_move">{L_PRUNE_MOVE}:</label><br /><span>{L_PRUNE_MOVE_EXPLAIN}</span></dt>\n			<dd><select name="prune_move" id="prune_move"><option class="sep" value="0">{L_DISABLED}</option>{S_PRUNE_MOVE_OPTIONS}</select></dd>\n		</dl>', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (4, 1, 1, 1203634800, 30, 'includes/acp/acp_forums.php', 4, '						''prune_sticky''			=> request_var(''prune_sticky'', false),', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (4, 1, 3, 1207951200, 30, 'includes/acp/acp_forums.php', 4, '						''forum_password_unset''	=> request_var(''forum_password_unset'', false),\n					);', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (5, 1, 1, 1203634800, 40, 'includes/acp/acp_forums.php', 5, '						''prune_move''			=> request_var(''prune_move'', 0),', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (5, 1, 3, 1207951200, 40, 'includes/acp/acp_forums.php', 5, '					$forum_data[''prune_move''] = 0;\n					if ($forum_data[''forum_type''] == FORUM_POST)\n					{\n						$forum_data[''prune_move''] = request_var(''prune_move'', 0);\n					}', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (6, 1, 1, 1203634800, 50, 'includes/acp/acp_forums.php', 4, '							''prune_freq''			=> 1,', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (7, 1, 1, 1203634800, 60, 'includes/acp/acp_forums.php', 5, '							''prune_move''			=> 0,', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (8, 1, 1, 1203634800, 70, 'includes/acp/acp_forums.php', 4, '				''S_PRUNE_ENABLE''			=> ($forum_data[''enable_prune'']) ? true : false,', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (8, 1, 3, 1207951200, 70, 'includes/acp/acp_forums.php', 4, '					''S_PRUNE_ENABLE''			=> ($forum_data[''enable_prune'']) ? true : false,', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (9, 1, 1, 1203634800, 80, 'includes/acp/acp_forums.php', 5, '				''S_PRUNE_MOVE_OPTIONS''		=> make_forum_select(($action == ''edit'') ? $forum_data[''prune_move''] : false, ($action == ''edit'') ? $forum_data[''forum_id''] : false, false, false, false),', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (9, 1, 3, 1207951200, 80, 'includes/acp/acp_forums.php', 5, '					''S_PRUNE_MOVE_OPTIONS''		=> make_forum_select(($action == ''edit'') ? $forum_data[''prune_move''] : false, ($action == ''edit'') ? $forum_data[''forum_id''] : false, false, true),', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (10, 1, 1, 1203634800, 90, 'includes/functions_admin.php', 4, 'function prune(', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (11, 1, 1, 1203634800, 100, 'includes/functions_admin.php', 9, '$auto_sync = true', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (12, 1, 1, 1203634800, 110, 'includes/functions_admin.php', 10, ', $prune_move = false', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (13, 1, 1, 1203634800, 120, 'includes/functions_admin.php', 4, '	return delete_topics(''topic_id'', $topic_list, $auto_sync, false);', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (14, 1, 1, 1203634800, 130, 'includes/functions_admin.php', 6, '	if ($prune_move)\n	{\n		// $prune_move is the forum id we want to move our posts to\n		return move_topics($topic_list, $prune_move, $auto_sync);\n	}', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (15, 1, 1, 1203634800, 140, 'includes/functions_admin.php', 4, 'function auto_prune(', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (15, 1, 2, 1207432800, 140, 'includes/functions_admin.php', 4, 'function auto_prune($forum_id', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (16, 1, 1, 1203634800, 150, 'includes/functions_admin.php', 4, '	$sql = ''SELECT forum_name', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (17, 1, 1, 1203634800, 160, 'includes/functions_admin.php', 9, 'forum_name', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (18, 1, 1, 1203634800, 170, 'includes/functions_admin.php', 10, ', prune_move', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (19, 1, 1, 1203634800, 180, 'includes/functions_admin.php', 4, 'prune($forum_id, $prune_mode, $prune_date, $prune_flags, true', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (20, 1, 1, 1203634800, 190, 'includes/functions_admin.php', 9, 'prune($forum_id, $prune_mode, $prune_date, $prune_flags, true', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (21, 1, 1, 1203634800, 200, 'includes/functions_admin.php', 10, ', $row[''prune_move'']', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (22, 1, 1, 1203634800, 210, 'language/en/acp/forums.php', 4, '?>', '');
+INSERT INTO phpbb_project_actions (action_id, project_id, version_id, version_time, action_order, action_file, action_type, action_content, action_comment) VALUES (23, 1, 1, 1203634800, 220, 'language/en/acp/forums.php', 6, '$lang = array_merge($lang, array(\n	''PRUNE_MOVE''			=> ''Move pruned forums'',\n	''PRUNE_MOVE_EXPLAIN''	=> ''If you select a forum from the list below, topics will be moved to that forum instead of deleted.'',\n));', '');
 
-INSERT INTO phpbb_project_action_contents (action_id, version_id, version_time, action_order, action_type, action_content) VALUES (1, 1, 1171411200, 1, 4, 'index.php');
-INSERT INTO phpbb_project_action_contents (action_id, version_id, version_time, action_order, action_type, action_content) VALUES (2, 1, 1171411200, 2, 5, '?>');
-INSERT INTO phpbb_project_action_contents (action_id, version_id, version_time, action_order, action_type, action_content) VALUES (3, 1, 1171411200, 3, 7, '// See I can do mods!');
-
-INSERT INTO phpbb_project_action_contents (action_id, version_id, version_time, action_order, action_type, action_content) VALUES (3, 2, 1185926400, 3, 7, '// See I can do mods! :D Great aint it!');
-
 # Bookmark the project
 INSERT INTO phpbb_project_marx (project_id, user_id, marx_type) VALUES (1, 2, 1);
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.