1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
|
<?php
/**
* This file implements upgrading from cafelog/b2
*
* b2evolution - {@link http://b2evolution.net/}
* Released under GNU GPL License - {@link http://b2evolution.net/about/license.html}
* @copyright (c)2003-2005 by Francois PLANQUE - {@link http://fplanque.net/}
*
* @package install
*/
if( !defined('DB_USER') ) die( 'Please, do not access this page directly.' );
/**
* {@internal upgrade_cafelog_tables(-)}}
*/
function upgrade_cafelog_tables()
{
global $tableposts, $tableusers, $tablesettings, $tablecategories, $tablecomments,
$tableblogs, $tablepostcats, $tablehitlog, $tableantispam, $tablegroups, $tableblogusers;
global $baseurl, $old_db_version, $new_db_version;
global $default_locale;
global $oldtableposts, $oldtableusers, $oldtablesettings, $oldtablecategories, $oldtablecomments;
global $timestamp, $admin_email;
global $Group_Admins, $Group_Priviledged, $Group_Bloggers, $Group_Users;
global $blog_all_ID, $blog_a_ID, $blog_b_ID, $blog_linkblog_ID;
global $cat_ann_a, $cat_news, $cat_bg, $cat_ann_b, $cat_fun, $cat_life, $cat_web, $cat_sports, $cat_movies, $cat_music, $cat_b2evo, $cat_linkblog_b2evo, $cat_linkblog_contrib;
global $DB;
// Create blogs:
create_default_blogs( 'Blog A (Upg)', 'Blog A (Cafelog Upgrade)', T_("This blog holds all your posts upgraded from Cafelog. This blog is named '%s'. %s"), false );
echo 'Copying Cafelog settings... ';
// forcing paged mode because this works so much better !!!
// You can always change it back in the options if you don't like it.
$query = "SELECT archive_mode, time_difference, AutoBR FROM $oldtablesettings";
$q = $DB->get_row( $query, ARRAY_A );
$query = "INSERT INTO $tablesettings (set_name, set_value)
VALUES
('db_version', '$new_db_version'),
('default_locale', '$default_locale'),
('posts_per_page', '5'),
('what_to_show', 'paged'),
('archive_mode', '".$q['archive_mode']."'),
('time_difference', '".$q['time_difference']."'),
('AutoBR', '".$q['AutoBR']."'),
('antispam_last_update', '2000-01-01 00:00:00'),
('newusers_grp_ID', '".$Group_Users->get('ID')."' ),
('newusers_level', '1'),
('newusers_canregister', '0'),
('links_extrapath', '0'),
('permalink_type', 'urltitle'),
( 'user_minpwdlen', '5' )
";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Copying Cafelog users... ';
$query = "INSERT INTO $tableusers( ID, user_login, user_pass, user_firstname, user_lastname,
user_nickname, user_icq, user_email, user_url, user_ip, user_domain, user_browser,
dateYMDhour, user_level, user_aim, user_msn, user_yim, user_idmode )
SELECT ID, user_login, MD5(user_pass), user_firstname, user_lastname, user_nickname,
user_icq, user_email, user_url, user_ip, user_domain, user_browser, dateYMDhour,
user_level, user_aim, user_msn, user_yim, user_idmode
FROM $oldtableusers";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Make sure user #1 is at level 10... ';
$query = "UPDATE $tableusers
SET user_level = 10
WHERE ID = 1";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Setting groups... ';
$query = "UPDATE $tableusers
SET user_grp_ID = ".$Group_Users->get('ID')."
WHERE user_level = 0";
$DB->query( $query );
$query = "UPDATE $tableusers
SET user_grp_ID = ".$Group_Bloggers->get('ID')."
WHERE user_level > 0 and user_level < 10 ";
$DB->query( $query );
// Level 10 users get default group (1)
echo "OK.<br />\n";
echo 'Creating user blog permissions... ';
// Admin for all blogs:
$query = "INSERT INTO $tableblogusers( bloguser_blog_ID, bloguser_user_ID, bloguser_ismember,
bloguser_perm_poststatuses, bloguser_perm_delpost, bloguser_perm_comments,
bloguser_perm_cats, bloguser_perm_properties)
SELECT blog_ID, ID, 1, 'published,deprecated,protected,private,draft', 1, 1, 1, 1
FROM $oldtableusers, $tableblogs
WHERE user_level = 10";
$DB->query( $query );
// Normal users for upgraded blog:
$query = "INSERT INTO $tableblogusers( bloguser_blog_ID, bloguser_user_ID, bloguser_ismember,
bloguser_perm_poststatuses, bloguser_perm_delpost, bloguser_perm_comments,
bloguser_perm_cats, bloguser_perm_properties)
SELECT $blog_a_ID, ID, 1, 'published,protected,private,draft', 0, 1, 0, 0
FROM $oldtableusers
WHERE user_level > 0 AND user_level < 10";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Copying Cafelog categories... ';
$query = "INSERT INTO $tablecategories( cat_ID, cat_parent_ID, cat_name, cat_blog_ID ) SELECT DISTINCT cat_ID, NULL, cat_name, 2 FROM $oldtablecategories";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Copying Cafelog posts... ';
$query = "INSERT INTO $tableposts( ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content,post_title, post_category, post_autobr, post_flags, post_karma)
SELECT ID, post_author, post_date, post_date, 'published', '$default_locale', post_content, post_title, post_category, 1, 'pingsdone,imported', post_karma FROM $oldtableposts";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Generating wordcounts... ';
$query = "SELECT ID, post_content FROM $tableposts";
$q = $DB->get_results( $query, ARRAY_A );
if( count( $q ) ) foreach( $q as $row )
{
$query_update_wordcount = "UPDATE $tableposts
SET post_wordcount = " . bpost_count_words($row['post_content']) . "
WHERE ID = " . $row['ID'];
$DB->query($query_update_wordcount);
}
echo "OK. (".count($q)." rows updated)<br />\n";
echo 'Generating postcats... ';
$query = "INSERT INTO $tablepostcats( postcat_post_ID, postcat_cat_ID ) SELECT ID, post_category FROM $tableposts";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Copying Cafelog comments... ';
$query = "INSERT INTO $tablecomments( comment_ID, comment_post_ID, comment_type, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_content, comment_karma ) SELECT comment_ID, comment_post_ID, 'comment', comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_content, comment_karma FROM $oldtablecomments";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Qualifying comments... Trackback... ';
$query = "UPDATE $tablecomments SET comment_type = 'trackback' WHERE comment_content LIKE '<trackback />%'";
$DB->query( $query );
echo "OK.<br />\n";
echo 'Qualifying comments... Pingback... ';
$query = "UPDATE $tablecomments SET comment_type = 'pingback' WHERE comment_content LIKE '<pingback />%'";
$DB->query( $query );
echo "OK.<br />\n";
create_default_categories( false /* not for A */ );
// POPULATE THE LINKBLOG:
populate_linkblog( $now, $cat_linkblog_b2evo, $cat_linkblog_contrib );
// Create other default contents:
create_default_contents( false /* not for A */ );
// Cleanup extra quotes in comments:
cleanup_post_quotes();
cleanup_comment_quotes();
}
?>
|
