?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
ok, let's recode other text fields too...
[phpbb.git] / phpBB / install / convertors / functions_phpbb20.php
blob62ce8b774a06157b8954e694754ea90cd665be77
1 <?php
2 /**
3 *
4 * @package install
5 * @version $Id$
6 * @copyright (c) 2006 phpBB Group
7 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
8 *
9 */
10
11 /**
12 * Helper functions for phpBB 2.0.x to phpBB 3.0.x conversion
13 */
14
15 /**
16 * Set forum flags - only prune old polls by default
17 */
18 function phpbb_forum_flags()
19 {
20 // Set forum flags
21 $forum_flags = 0;
22
23 // FORUM_FLAG_LINK_TRACK
24 $forum_flags += 0;
25
26 // FORUM_FLAG_PRUNE_POLL
27 $forum_flags += FORUM_FLAG_PRUNE_POLL;
28
29 // FORUM_FLAG_PRUNE_ANNOUNCE
30 $forum_flags += 0;
31
32 // FORUM_FLAG_PRUNE_STICKY
33 $forum_flags += 0;
34
35 // FORUM_FLAG_ACTIVE_TOPICS
36 $forum_flags += 0;
37
38 // FORUM_FLAG_POST_REVIEW
39 $forum_flags += FORUM_FLAG_POST_REVIEW;
40
41 return $forum_flags;
42 }
43
44 /**
45 * Insert/Convert forums
46 */
47 function phpbb_insert_forums()
48 {
49 global $db, $convert, $user, $config;
50
51 $db->sql_query($convert->truncate_statement . FORUMS_TABLE);
52
53 // Determine the highest id used within the old forums table (we add the categories after the forum ids)
54 $sql = 'SELECT MAX(forum_id) AS max_forum_id
55 FROM ' . $convert->src_table_prefix . 'forums';
56 $result = $db->sql_query($sql);
57 $max_forum_id = (int) $db->sql_fetchfield('max_forum_id');
58 $db->sql_freeresult($result);
59
60 $max_forum_id++;
61
62 // Insert categories
63 $sql = 'SELECT cat_id, cat_title
64 FROM ' . $convert->src_table_prefix . 'categories
65 ORDER BY cat_order';
66 $result = $db->sql_query($sql);
67
68 $cats_added = array();
69 while ($row = $db->sql_fetchrow($result))
70 {
71 $sql_ary = array(
72 'forum_id' => $max_forum_id,
73 'forum_name' => ($row['cat_title']) ? htmlspecialchars(phpbb_set_encoding($row['cat_title'], false), ENT_COMPAT, 'UTF-8') : $user->lang['CATEGORY'],
74 'parent_id' => 0,
75 'forum_parents' => '',
76 'forum_desc' => '',
77 'forum_type' => FORUM_CAT,
78 'forum_status' => ITEM_UNLOCKED,
79 'forum_rules' => '',
80 );
81
82 $sql = 'SELECT MAX(right_id) AS right_id
83 FROM ' . FORUMS_TABLE;
84 $_result = $db->sql_query($sql);
85 $cat_row = $db->sql_fetchrow($_result);
86 $db->sql_freeresult($_result);
87
88 $sql_ary['left_id'] = $cat_row['right_id'] + 1;
89 $sql_ary['right_id'] = $cat_row['right_id'] + 2;
90
91 $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
92 $db->sql_query($sql);
93
94 $cats_added[$row['cat_id']] = $max_forum_id;
95 $max_forum_id++;
96 }
97 $db->sql_freeresult($result);
98
99 // There may be installations having forums with non-existant category ids.
100 // We try to catch them and add them to an "unknown" category instead of leaving them out.
101 $sql = 'SELECT cat_id
102 FROM ' . $convert->src_table_prefix . 'forums
103 GROUP BY cat_id';
104 $result = $db->sql_query($sql);
105
106 $unknown_cat_id = false;
107 while ($row = $db->sql_fetchrow($result))
108 {
109 // Catch those categories not been added before
110 if (!isset($cats_added[$row['cat_id']]))
111 {
112 $unknown_cat_id = true;
113 }
114 }
115 $db->sql_freeresult($result);
116
117 // Is there at least one category not known?
118 if ($unknown_cat_id === true)
119 {
120 $unknown_cat_id = 'ghost';
121
122 $sql_ary = array(
123 'forum_id' => $max_forum_id,
124 'forum_name' => $user->lang['CATEGORY'],
125 'parent_id' => 0,
126 'forum_parents' => '',
127 'forum_desc' => '',
128 'forum_type' => FORUM_CAT,
129 'forum_status' => ITEM_UNLOCKED,
130 'forum_rules' => '',
131 );
132
133 $sql = 'SELECT MAX(right_id) AS right_id
134 FROM ' . FORUMS_TABLE;
135 $_result = $db->sql_query($sql);
136 $cat_row = $db->sql_fetchrow($_result);
137 $db->sql_freeresult($_result);
138
139 $sql_ary['left_id'] = $cat_row['right_id'] + 1;
140 $sql_ary['right_id'] = $cat_row['right_id'] + 2;
141
142 $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
143 $db->sql_query($sql);
144
145 $cats_added[$unknown_cat_id] = $max_forum_id;
146 $max_forum_id++;
147 }
148
149 // Now insert the forums
150 $sql = 'SELECT f.*, fp.prune_days, fp.prune_freq FROM ' . $convert->src_table_prefix . 'forums f
151 LEFT JOIN ' . $convert->src_table_prefix . 'forum_prune fp ON f.forum_id = fp.forum_id
152 GROUP BY f.forum_id
153 ORDER BY f.cat_id, f.forum_order';
154 $result = $db->sql_query($sql);
155
156 while ($row = $db->sql_fetchrow($result))
157 {
158 // Some might have forums here with an id not being "possible"...
159 // To be somewhat friendly we "change" the category id for those to a previously created ghost category
160 if (!isset($cats_added[$row['cat_id']]) && $unknown_cat_id !== false)
161 {
162 $row['cat_id'] = $unknown_cat_id;
163 }
164
165 if (!isset($cats_added[$row['cat_id']]))
166 {
167 continue;
168 }
169
170 // Define the new forums sql ary
171 $sql_ary = array(
172 'forum_id' => (int) $row['forum_id'],
173 'forum_name' => htmlspecialchars(phpbb_set_encoding($row['forum_name'], false), ENT_COMPAT, 'UTF-8'),
174 'parent_id' => $cats_added[$row['cat_id']],
175 'forum_parents' => '',
176 'forum_desc' => htmlspecialchars(phpbb_set_encoding($row['forum_desc'], false), ENT_COMPAT, 'UTF-8'),
177 'forum_type' => FORUM_POST,
178 'forum_status' => is_item_locked($row['forum_status']),
179 'enable_prune' => $row['prune_enable'],
180 'prune_next' => null_to_zero($row['prune_next']),
181 'prune_days' => null_to_zero($row['prune_days']),
182 'prune_viewed' => 0,
183 'prune_freq' => null_to_zero($row['prune_freq']),
184
185 'forum_flags' => phpbb_forum_flags(),
186
187 // Default values
188 'forum_desc_bitfield' => '',
189 'forum_desc_options' => 7,
190 'forum_desc_uid' => '',
191 'forum_link' => '',
192 'forum_password' => '',
193 'forum_style' => 0,
194 'forum_image' => '',
195 'forum_rules' => '',
196 'forum_rules_link' => '',
197 'forum_rules_bitfield' => '',
198 'forum_rules_options' => 7,
199 'forum_rules_uid' => '',
200 'forum_topics_per_page' => 0,
201 'forum_posts' => 0,
202 'forum_topics' => 0,
203 'forum_topics_real' => 0,
204 'forum_last_post_id' => 0,
205 'forum_last_poster_id' => 0,
206 'forum_last_post_subject' => '',
207 'forum_last_post_time' => 0,
208 'forum_last_poster_name' => '',
209 'forum_last_poster_colour' => '',
210 'display_on_index' => 1,
211 'enable_indexing' => 1,
212 'enable_icons' => 0,
213 );
214
215 // Now add the forums with proper left/right ids
216 $sql = 'SELECT left_id, right_id
217 FROM ' . FORUMS_TABLE . '
218 WHERE forum_id = ' . $cats_added[$row['cat_id']];
219 $_result = $db->sql_query($sql);
220 $cat_row = $db->sql_fetchrow($_result);
221 $db->sql_freeresult($_result);
222
223 $sql = 'UPDATE ' . FORUMS_TABLE . '
224 SET left_id = left_id + 2, right_id = right_id + 2
225 WHERE left_id > ' . $cat_row['right_id'];
226 $db->sql_query($sql);
227
228 $sql = 'UPDATE ' . FORUMS_TABLE . '
229 SET right_id = right_id + 2
230 WHERE ' . $cat_row['left_id'] . ' BETWEEN left_id AND right_id';
231 $db->sql_query($sql);
232
233 $sql_ary['left_id'] = $cat_row['right_id'];
234 $sql_ary['right_id'] = $cat_row['right_id'] + 1;
235
236 $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
237 $db->sql_query($sql);
238 }
239 $db->sql_freeresult($result);
240 }
241
242 /**
243 * Function for recoding text with the default language
244 *
245 * @param string $text text to recode to utf8
246 * @param bool $grab_user_lang if set to true the function tries to use $convert_row['user_lang'] (and falls back to $convert_row['poster_id']) instead of the boards default language
247 */
248 function phpbb_set_encoding($text, $grab_user_lang = true)
249 {
250 global $lang_enc_array, $convert_row;
251 global $convert, $phpEx;
252
253 /*static $lang_enc_array = array(
254 'korean' => 'euc-kr',
255 'serbian' => 'windows-1250',
256 'polish' => 'iso-8859-2',
257 'kurdish' => 'windows-1254',
258 'slovak' => 'Windows-1250',
259 'russian' => 'windows-1251',
260 'estonian' => 'iso-8859-4',
261 'chinese_simplified' => 'gb2312',
262 'macedonian' => 'windows-1251',
263 'azerbaijani' => 'UTF-8',
264 'romanian' => 'iso-8859-2',
265 'romanian_diacritice' => 'iso-8859-2',
266 'lithuanian' => 'windows-1257',
267 'turkish' => 'iso-8859-9',
268 'ukrainian' => 'windows-1251',
269 'japanese' => 'shift_jis',
270 'hungarian' => 'ISO-8859-2',
271 'romanian_no_diacritics' => 'iso-8859-2',
272 'mongolian' => 'UTF-8',
273 'slovenian' => 'windows-1250',
274 'bosnian' => 'windows-1250',
275 'czech' => 'Windows-1250',
276 'farsi' => 'Windows-1256',
277 'croatian' => 'windows-1250',
278 'greek' => 'iso-8859-7',
279 'russian_tu' => 'windows-1251',
280 'sakha' => 'UTF-8',
281 'serbian_cyrillic' => 'windows-1251',
282 'bulgarian' => 'windows-1251',
283 'chinese_traditional_taiwan' => 'big5',
284 'chinese_traditional' => 'big5',
285 'arabic' => 'windows-1256',
286 'hebrew' => 'WINDOWS-1255',
287 'thai' => 'windows-874',
288 //'chinese_traditional_taiwan' => 'utf-8' // custom modified, we may have to do an include :-(
289 );*/
290
291 if (empty($lang_enc_array))
292 {
293 $lang_enc_array = array();
294 }
295
296 $get_lang = trim(get_config_value('default_lang'));
297
298 // Do we need the users language encoding?
299 if ($grab_user_lang && !empty($convert_row))
300 {
301 if (!empty($convert_row['user_lang']))
302 {
303 $get_lang = trim($convert_row['user_lang']);
304 }
305 else if (!empty($convert_row['poster_id']))
306 {
307 global $db;
308
309 $sql = 'SELECT user_lang
310 FROM ' . $convert->src_table_prefix . 'users
311 WHERE user_id = ' . (int) $convert_row['poster_id'];
312 $result = $db->sql_query($sql);
313 $get_lang = (string) $db->sql_fetchfield('user_lang');
314 $db->sql_freeresult($result);
315
316 $get_lang = (!trim($get_lang)) ? trim(get_config_value('default_lang')) : trim($get_lang);
317 }
318 }
319
320 if (!isset($lang_enc_array[$get_lang]))
321 {
322 $filename = $convert->convertor_status['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx;
323
324 if (!file_exists($filename))
325 {
326 $get_lang = trim(get_config_value('default_lang'));
327 }
328
329 if (!isset($lang_enc_array[$get_lang]))
330 {
331 include($convert->convertor_status['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx);
332 $lang_enc_array[$get_lang] = $lang['ENCODING'];
333 unset($lang);
334 }
335 }
336
337 $encoding = $lang_enc_array[$get_lang];
338
339 return utf8_recode($text, $lang_enc_array[$get_lang]);
340 }
341
342 /**
343 * Same as phpbb_set_encoding, but forcing boards default language
344 */
345 function phpbb_set_default_encoding($text)
346 {
347 return phpbb_set_encoding($text, false);
348 }
349
350 /**
351 * Convert Birthday from Birthday MOD to phpBB Format
352 */
353 function phpbb_get_birthday($birthday = '')
354 {
355 $birthday = (int) $birthday;
356
357 if (defined('MOD_BIRTHDAY_TERRA'))
358 {
359 // stored as month, day, year
360 if (!$birthday)
361 {
362 return ' 0- 0- 0';
363 }
364
365 $birthday = (string) $birthday;
366
367 $month = substr($birthday, 0, 2);
368 $day = substr($birthday, 2, 2);
369 $year = substr($birthday, -4);
370
371 return sprintf('%02d-%02d-%04d', $day, $month, $year);
372 }
373 else
374 {
375 if (!$birthday || $birthday == 999999 || $birthday < 0)
376 {
377 return ' 0- 0- 0';
378 }
379
380 // The birthday mod from niels is using this code to transform to day/month/year
381 return gmdate('d-m-Y', $birthday * 86400 + 1);
382 }
383 }
384
385 /**
386 * Return correct user id value
387 * Everyone's id will be one higher to allow the guest/anonymous user to have a positive id as well
388 */
389 function phpbb_user_id($user_id)
390 {
391 if (!$user_id)
392 {
393 return 0;
394 }
395
396 if ($user_id == -1)
397 {
398 return ANONYMOUS;
399 }
400
401 global $config;
402
403 // Increment user id if the old forum is having a user with the id 1
404 if (!isset($config['increment_user_id']))
405 {
406 global $db, $convert;
407
408 // Now let us set a temporary config variable for user id incrementing
409 $sql = "SELECT user_id
410 FROM {$convert->src_table_prefix}users
411 WHERE user_id = 1";
412 $result = $db->sql_query($sql);
413 $id = (int) $db->sql_fetchfield('user_id');
414 $db->sql_freeresult($result);
415
416 // If there is a user id 1, we need to increment user ids. :/
417 if ($id === 1)
418 {
419 set_config('increment_user_id', 1, true);
420 $config['increment_user_id'] = 1;
421 }
422 else
423 {
424 set_config('increment_user_id', 0, true);
425 $config['increment_user_id'] = 0;
426 }
427 }
428
429 if (!empty($config['increment_user_id']))
430 {
431 $user_id++;
432 }
433
434 return $user_id;
435 }
436
437 /* Copy additional table fields from old forum to new forum if user wants this (for Mod compatibility for example)
438 function phpbb_copy_table_fields()
439 {
440 }
441 */
442
443 /**
444 * Convert authentication
445 * user, group and forum table has to be filled in order to work
446 */
447 function phpbb_convert_authentication($mode)
448 {
449 global $db, $convert, $user, $config, $cache;
450
451 if ($mode == 'start')
452 {
453 $db->sql_query($convert->truncate_statement . ACL_USERS_TABLE);
454 $db->sql_query($convert->truncate_statement . ACL_GROUPS_TABLE);
455
456 // Grab user id of first user with user_level of ADMIN
457 $sql = "SELECT user_id
458 FROM {$convert->src_table_prefix}users
459 WHERE user_level = 1
460 ORDER BY user_regdate ASC";
461 $result = $db->sql_query_limit($sql, 1);
462 $row = $db->sql_fetchrow($result);
463 $db->sql_freeresult($result);
464
465 $founder_id = phpbb_user_id($row['user_id']);
466
467 // Set a founder admin ... we'll assume it's the first user with admin level access
468 $sql = 'UPDATE ' . USERS_TABLE . '
469 SET user_type = ' . USER_FOUNDER . "
470 WHERE user_id = $founder_id";
471 $db->sql_query($sql);
472 }
473
474 // Grab forum auth information
475 $sql = "SELECT *
476 FROM {$convert->src_table_prefix}forums";
477 $result = $db->sql_query($sql);
478
479 $forum_access = array();
480 while ($row = $db->sql_fetchrow($result))
481 {
482 $forum_access[] = $row;
483 }
484 $db->sql_freeresult($result);
485
486 // Grab user auth information from 2.0.x board
487 $sql = "SELECT ug.user_id, aa.*
488 FROM {$convert->src_table_prefix}auth_access aa, {$convert->src_table_prefix}user_group ug, {$convert->src_table_prefix}groups g
489 WHERE g.group_id = aa.group_id
490 AND g.group_single_user = 1
491 AND ug.group_id = g.group_id";
492 $result = $db->sql_query($sql);
493
494 $user_access = array();
495 while ($row = $db->sql_fetchrow($result))
496 {
497 $user_access[$row['forum_id']][] = $row;
498 }
499 $db->sql_freeresult($result);
500
501 // Grab group auth information
502 $sql = "SELECT g.group_id, aa.*
503 FROM {$convert->src_table_prefix}auth_access aa, {$convert->src_table_prefix}groups g
504 WHERE g.group_id = aa.group_id
505 AND g.group_single_user <> 1";
506 $result = $db->sql_query($sql);
507
508 $group_access = array();
509 while ($row = $db->sql_fetchrow($result))
510 {
511 $group_access[$row['forum_id']][] = $row;
512 }
513 $db->sql_freeresult($result);
514
515 // Add Forum Access List
516 $auth_map = array(
517 'auth_view' => array('f_', 'f_list'),
518 'auth_read' => 'f_read',
519 'auth_post' => array('f_post', 'f_bbcode', 'f_smilies', 'f_img', 'f_sigs', 'f_search', 'f_postcount'),
520 'auth_reply' => 'f_reply',
521 'auth_edit' => 'f_edit',
522 'auth_delete' => 'f_delete',
523 'auth_pollcreate' => 'f_poll',
524 'auth_vote' => 'f_vote',
525 'auth_announce' => 'f_announce',
526 'auth_sticky' => 'f_sticky',
527 'auth_attachments' => 'f_attach',
528 'auth_download' => 'f_download',
529 );
530
531 // Define the ACL constants used in 2.0 to make the code slightly more readable
532 define('AUTH_ALL', 0);
533 define('AUTH_REG', 1);
534 define('AUTH_ACL', 2);
535 define('AUTH_MOD', 3);
536 define('AUTH_ADMIN', 5);
537
538 // A mapping of the simple permissions used by 2.0
539 $simple_auth_ary = array(
540 'public' => array(
541 'auth_view' => AUTH_ALL,
542 'auth_read' => AUTH_ALL,
543 'auth_post' => AUTH_ALL,
544 'auth_reply' => AUTH_ALL,
545 'auth_edit' => AUTH_REG,
546 'auth_delete' => AUTH_REG,
547 'auth_sticky' => AUTH_MOD,
548 'auth_announce' => AUTH_MOD,
549 'auth_vote' => AUTH_REG,
550 'auth_pollcreate' => AUTH_REG,
551 ),
552 'registered' => array(
553 'auth_view' => AUTH_ALL,
554 'auth_read' => AUTH_ALL,
555 'auth_post' => AUTH_REG,
556 'auth_reply' => AUTH_REG,
557 'auth_edit' => AUTH_REG,
558 'auth_delete' => AUTH_REG,
559 'auth_sticky' => AUTH_MOD,
560 'auth_announce' => AUTH_MOD,
561 'auth_vote' => AUTH_REG,
562 'auth_pollcreate' => AUTH_REG,
563 ),
564 'registered_hidden' => array(
565 'auth_view' => AUTH_REG,
566 'auth_read' => AUTH_REG,
567 'auth_post' => AUTH_REG,
568 'auth_reply' => AUTH_REG,
569 'auth_edit' => AUTH_REG,
570 'auth_delete' => AUTH_REG,
571 'auth_sticky' => AUTH_MOD,
572 'auth_announce' => AUTH_MOD,
573 'auth_vote' => AUTH_REG,
574 'auth_pollcreate' => AUTH_REG,
575 ),
576 'private' => array(
577 'auth_view' => AUTH_ALL,
578 'auth_read' => AUTH_ACL,
579 'auth_post' => AUTH_ACL,
580 'auth_reply' => AUTH_ACL,
581 'auth_edit' => AUTH_ACL,
582 'auth_delete' => AUTH_ACL,
583 'auth_sticky' => AUTH_ACL,
584 'auth_announce' => AUTH_MOD,
585 'auth_vote' => AUTH_ACL,
586 'auth_pollcreate' => AUTH_ACL,
587 ),
588 'private_hidden' => array(
589 'auth_view' => AUTH_ACL,
590 'auth_read' => AUTH_ACL,
591 'auth_post' => AUTH_ACL,
592 'auth_reply' => AUTH_ACL,
593 'auth_edit' => AUTH_ACL,
594 'auth_delete' => AUTH_ACL,
595 'auth_sticky' => AUTH_ACL,
596 'auth_announce' => AUTH_MOD,
597 'auth_vote' => AUTH_ACL,
598 'auth_pollcreate' => AUTH_ACL,
599 ),
600 'moderator' => array(
601 'auth_view' => AUTH_ALL,
602 'auth_read' => AUTH_MOD,
603 'auth_post' => AUTH_MOD,
604 'auth_reply' => AUTH_MOD,
605 'auth_edit' => AUTH_MOD,
606 'auth_delete' => AUTH_MOD,
607 'auth_sticky' => AUTH_MOD,
608 'auth_announce' => AUTH_MOD,
609 'auth_vote' => AUTH_MOD,
610 'auth_pollcreate' => AUTH_MOD,
611 ),
612 'moderator_hidden' => array(
613 'auth_view' => AUTH_MOD,
614 'auth_read' => AUTH_MOD,
615 'auth_post' => AUTH_MOD,
616 'auth_reply' => AUTH_MOD,
617 'auth_edit' => AUTH_MOD,
618 'auth_delete' => AUTH_MOD,
619 'auth_sticky' => AUTH_MOD,
620 'auth_announce' => AUTH_MOD,
621 'auth_vote' => AUTH_MOD,
622 'auth_pollcreate' => AUTH_MOD,
623 ),
624 );
625
626 if ($mode == 'start')
627 {
628 user_group_auth('guests', 'SELECT user_id, {GUESTS} FROM ' . USERS_TABLE . ' WHERE user_id = ' . ANONYMOUS);
629 user_group_auth('registered', 'SELECT user_id, {REGISTERED} FROM ' . USERS_TABLE . ' WHERE user_id <> ' . ANONYMOUS);
630
631 // Selecting from old table
632 $auth_sql = 'SELECT ';
633 $auth_sql .= (!empty($config['increment_user_id'])) ? 'user_id + 1 as user_id' : 'user_id';
634 $auth_sql .= ', {ADMINISTRATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1';
635
636 user_group_auth('administrators', $auth_sql);
637 }
638 else if ($mode == 'first')
639 {
640 // Go through all 2.0.x forums (we saved those ids for reference)
641 foreach ($forum_access as $forum)
642 {
643 $new_forum_id = (int) $forum['forum_id'];
644
645 // Administrators have full access to all forums whatever happens
646 mass_auth('group_role', $new_forum_id, 'administrators', 'FORUM_FULL');
647
648 $matched_type = '';
649 foreach ($simple_auth_ary as $key => $auth_levels)
650 {
651 $matched = 1;
652 foreach ($auth_levels as $k => $level)
653 {
654 if ($forum[$k] != $auth_levels[$k])
655 {
656 $matched = 0;
657 }
658 }
659
660 if ($matched)
661 {
662 $matched_type = $key;
663 break;
664 }
665 }
666
667 switch ($matched_type)
668 {
669 case 'public':
670 mass_auth('group_role', $new_forum_id, 'guests', 'FORUM_LIMITED');
671 mass_auth('group_role', $new_forum_id, 'registered', 'FORUM_LIMITED_POLLS');
672 mass_auth('group_role', $new_forum_id, 'bots', 'FORUM_BOT');
673 break;
674
675 case 'registered':
676 mass_auth('group_role', $new_forum_id, 'guests', 'FORUM_READONLY');
677 mass_auth('group_role', $new_forum_id, 'bots', 'FORUM_BOT');
678
679 // no break;
680
681 case 'registered_hidden':
682 mass_auth('group_role', $new_forum_id, 'registered', 'FORUM_LIMITED_POLLS');
683 break;
684
685 case 'private':
686 case 'private_hidden':
687 case 'moderator':
688 case 'moderator_hidden':
689 default:
690 // The permissions don't match a simple set, so we're going to have to map them directly
691
692 // No post approval for all, in 2.0.x this feature does not exist
693 mass_auth('group', $new_forum_id, 'guests', 'f_noapprove', ACL_YES);
694 mass_auth('group', $new_forum_id, 'registered', 'f_noapprove', ACL_YES);
695
696 // Go through authentication map
697 foreach ($auth_map as $old_auth_key => $new_acl)
698 {
699 // If old authentication key does not exist we continue
700 // This is helpful for mods adding additional authentication fields, we need to add them to the auth_map array
701 if (!isset($forum[$old_auth_key]))
702 {
703 continue;
704 }
705
706 // Now set the new ACL correctly
707 switch ($forum[$old_auth_key])
708 {
709 // AUTH_ALL
710 case AUTH_ALL:
711 mass_auth('group', $new_forum_id, 'guests', $new_acl, ACL_YES);
712 mass_auth('group', $new_forum_id, 'registered', $new_acl, ACL_YES);
713 break;
714
715 // AUTH_REG
716 case AUTH_REG:
717 mass_auth('group', $new_forum_id, 'registered', $new_acl, ACL_YES);
718 break;
719
720 // AUTH_ACL
721 case AUTH_ACL:
722 // Go through the old group access list for this forum
723 if (isset($group_access[$forum['forum_id']]))
724 {
725 foreach ($group_access[$forum['forum_id']] as $index => $access)
726 {
727 // We only check for ACL_YES equivalence entry
728 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)
729 {
730 mass_auth('group', $new_forum_id, $access['group_id'], $new_acl, ACL_YES);
731 }
732 }
733 }
734
735 if (isset($user_access[$forum['forum_id']]))
736 {
737 foreach ($user_access[$forum['forum_id']] as $index => $access)
738 {
739 // We only check for ACL_YES equivalence entry
740 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)
741 {
742 mass_auth('user', $new_forum_id, phpbb_user_id($access['user_id']), $new_acl, ACL_YES);
743 }
744 }
745 }
746 break;
747
748 // AUTH_MOD
749 case AUTH_MOD:
750 if (isset($group_access[$forum['forum_id']]))
751 {
752 foreach ($group_access[$forum['forum_id']] as $index => $access)
753 {
754 // We only check for ACL_YES equivalence entry
755 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)
756 {
757 mass_auth('group', $new_forum_id, $access['group_id'], $new_acl, ACL_YES);
758 }
759 }
760 }
761
762 if (isset($user_access[$forum['forum_id']]))
763 {
764 foreach ($user_access[$forum['forum_id']] as $index => $access)
765 {
766 // We only check for ACL_YES equivalence entry
767 if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)
768 {
769 mass_auth('user', $new_forum_id, phpbb_user_id($access['user_id']), $new_acl, ACL_YES);
770 }
771 }
772 }
773 break;
774 }
775 }
776 break;
777 }
778 }
779 }
780 else if ($mode == 'second')
781 {
782 // Assign permission roles
783
784 // By default all converted administrators are given full access
785 // @todo Review the implications of this - we might want to remove access to clear logs, view phpinfo, etc
786 mass_auth('group_role', 0, 'administrators', 'ADMIN_FULL');
787 mass_auth('group_role', 0, 'administrators', 'MOD_FULL');
788 mass_auth('group_role', 0, 'administrators', 'USER_FULL');
789
790 // All registered users are assigned the standard user role
791 mass_auth('group_role', 0, 'registered', 'USER_STANDARD');
792
793 // And now those who have had their avatar rights removed get assigned a more restrictive role
794 $sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users
795 WHERE user_allowavatar = 0
796 AND user_id > 0';
797 $result = $db->sql_query($sql);
798
799 while ($row = $db->sql_fetchrow($result))
800 {
801 mass_auth('user_role', 0, phpbb_user_id($row['user_id']), 'USER_NOAVATAR');
802 }
803 $db->sql_freeresult($result);
804
805 // And the same for those who have had their PM rights removed
806 $sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users
807 WHERE user_allow_pm = 0
808 AND user_id > 0';
809 $result = $db->sql_query($sql);
810
811 while ($row = $db->sql_fetchrow($result))
812 {
813 mass_auth('user_role', 0, phpbb_user_id($row['user_id']), 'USER_NOPM');
814 }
815 $db->sql_freeresult($result);
816 }
817 else if ($mode == 'third')
818 {
819 // And now the moderators
820 // We make sure that they have at least standard access to the forums they moderate in addition to the moderating permissions
821 foreach ($user_access as $forum_id => $access_map)
822 {
823 $forum_id = (int) $forum_id;
824
825 foreach ($access_map as $access)
826 {
827 if (isset($access['auth_mod']) && $access['auth_mod'] == 1)
828 {
829 mass_auth('user_role', $forum_id, phpbb_user_id($access['user_id']), 'MOD_STANDARD');
830 mass_auth('user_role', $forum_id, phpbb_user_id($access['user_id']), 'FORUM_STANDARD');
831 }
832 }
833 }
834
835 foreach ($group_access as $forum_id => $access_map)
836 {
837 $forum_id = (int) $forum_id;
838
839 foreach ($access_map as $access)
840 {
841 if (isset($access['auth_mod']) && $access['auth_mod'] == 1)
842 {
843 mass_auth('group_role', $forum_id, $access['group_id'], 'MOD_STANDARD');
844 mass_auth('group_role', $forum_id, $access['group_id'], 'FORUM_STANDARD');
845 }
846 }
847 }
848
849 // We grant everyone readonly access to the categories to ensure that the forums are visible
850 $sql = 'SELECT forum_id, forum_name, parent_id, left_id, right_id
851 FROM ' . FORUMS_TABLE . '
852 ORDER BY left_id ASC';
853 $result = $db->sql_query($sql);
854
855 $parent_forums = $forums = array();
856 while ($row = $db->sql_fetchrow($result))
857 {
858 if ($row['parent_id'] == 0)
859 {
860 mass_auth('group_role', $row['forum_id'], 'administrators', 'FORUM_FULL');
861 $parent_forums[] = $row;
862 }
863 else
864 {
865 $forums[] = $row;
866 }
867 }
868 $db->sql_freeresult($result);
869
870 global $auth;
871
872 // Let us see if guests/registered users have access to these forums...
873 foreach ($parent_forums as $row)
874 {
875 // Get the childs...
876 $branch = $forum_ids = array();
877
878 foreach ($forums as $key => $_row)
879 {
880 if ($_row['left_id'] > $row['left_id'] && $_row['left_id'] < $row['right_id'])
881 {
882 $branch[] = $_row;
883 $forum_ids[] = $_row['forum_id'];
884 continue;
885 }
886 }
887
888 if (sizeof($forum_ids))
889 {
890 // Now make sure the user is able to read these forums
891 $hold_ary = $auth->acl_group_raw_data(get_group_id('guests'), 'f_list', $forum_ids);
892
893 if (!empty($hold_ary))
894 {
895 mass_auth('group', $row['forum_id'], 'guests', 'f_list', ACL_YES);
896 mass_auth('group', $row['forum_id'], 'registered', 'f_list', ACL_YES);
897 }
898 }
899 }
900 }
901 }
902
903 /**
904 * Set primary group.
905 * Really simple and only based on user_level (remaining groups will be assigned later)
906 */
907 function phpbb_set_primary_group($user_level)
908 {
909 global $convert_row;
910
911 if ($user_level == 1)
912 {
913 return get_group_id('administrators');
914 }
915 /* else if ($user_level == 2)
916 {
917 return get_group_id('global_moderators');
918 }
919 else if ($user_level == 0 && $convert_row['user_active'])*/
920 else if ($convert_row['user_active'])
921 {
922 return get_group_id('registered');
923 }
924
925 return 0;
926 }
927
928 /**
929 * Convert the group name, making sure to avoid conflicts with 3.0 special groups
930 */
931 function phpbb_convert_group_name($group_name)
932 {
933 $default_groups = array(
934 'GUESTS',
935 'REGISTERED',
936 'REGISTERED_COPPA',
937 'GLOBAL_MODERATORS',
938 'ADMINISTRATORS',
939 'BOTS',
940 );
941
942 if (in_array(strtoupper($group_name), $default_groups))
943 {
944 return 'phpBB2 - ' . $group_name;
945 }
946
947 return phpbb_set_encoding($group_name, false);
948 }
949
950 /**
951 * Convert the group type constants
952 */
953 function phpbb_convert_group_type($group_type)
954 {
955 switch ($group_type)
956 {
957 case 0:
958 return GROUP_OPEN;
959 break;
960
961 case 1:
962 return GROUP_CLOSED;
963 break;
964
965 case 2:
966 return GROUP_HIDDEN;
967 break;
968 }
969
970 return GROUP_SPECIAL;
971 }
972
973 /**
974 * Convert the topic type constants
975 */
976 function phpbb_convert_topic_type($topic_type)
977 {
978 switch ($topic_type)
979 {
980 case 0:
981 return POST_NORMAL;
982 break;
983
984 case 1:
985 return POST_STICKY;
986 break;
987
988 case 2:
989 return POST_ANNOUNCE;
990 break;
991
992 case 3:
993 return POST_GLOBAL;
994 break;
995 }
996
997 return POST_NORMAL;
998 }
999
1000 /**
1001 * Reparse the message stripping out the bbcode_uid values and adding new ones and setting the bitfield
1002 * @todo What do we want to do about HTML in messages - currently it gets converted to the entities, but there may be some objections to this
1003 */
1004 function phpbb_prepare_message($message)
1005 {
1006 global $phpbb_root_path, $phpEx, $db, $convert, $user, $config, $cache, $convert_row, $message_parser;
1007
1008 if (!$message)
1009 {
1010 $convert->row['mp_bbcode_bitfield'] = $convert_row['mp_bbcode_bitfield'] = 0;
1011 return '';
1012 }
1013
1014 // Decode phpBB 2.0.x Message
1015 if (isset($convert->row['old_bbcode_uid']) && $convert->row['old_bbcode_uid'] != '')
1016 {
1017 $message = preg_replace('/\:(([a-z0-9]:)?)' . $convert->row['old_bbcode_uid'] . '/s', '', $message);
1018 }
1019
1020 if (strpos($message, '[quote=') !== false)
1021 {
1022 $message = preg_replace('/\[quote="(.*?)"\]/s', '[quote=&quot;\1&quot;]', $message);
1023 }
1024
1025 $user_id = $convert->row['poster_id'];
1026
1027 $message = str_replace('<', '&lt;', $message);
1028 $message = str_replace('>', '&gt;', $message);
1029 $message = str_replace('<br />', "\n", $message);
1030
1031 // make the post UTF-8
1032 $message = phpbb_set_encoding($message);
1033
1034 $message_parser->warn_msg = array(); // Reset the errors from the previous message
1035 $message_parser->bbcode_uid = make_uid($convert->row['post_time']);
1036 $message_parser->message = $message;
1037 unset($message);
1038
1039 // Make sure options are set.
1040 // $enable_html = (!isset($row['enable_html'])) ? false : $row['enable_html'];
1041 $enable_bbcode = (!isset($convert->row['enable_bbcode'])) ? true : $convert->row['enable_bbcode'];
1042 $enable_smilies = (!isset($convert->row['enable_smilies'])) ? true : $convert->row['enable_smilies'];
1043 $enable_magic_url = (!isset($convert->row['enable_magic_url'])) ? true : $convert->row['enable_magic_url'];
1044
1045 // parse($allow_bbcode, $allow_magic_url, $allow_smilies, $allow_img_bbcode = true, $allow_flash_bbcode = true, $allow_quote_bbcode = true, $allow_url_bbcode = true, $update_this_message = true, $mode = 'post')
1046 $message_parser->parse($enable_bbcode, $enable_magic_url, $enable_smilies);
1047
1048 if (sizeof($message_parser->warn_msg))
1049 {
1050 $msg_id = isset($convert->row['post_id']) ? $convert->row['post_id'] : $convert->row['privmsgs_id'];
1051 $convert->p_master->error('<span style="color:red">' . $user->lang['POST_ID'] . ': ' . $msg_id . ' ' . $user->lang['CONV_ERROR_MESSAGE_PARSER'] . ': <br /><br />' . implode('<br />', $message_parser->warn_msg), __LINE__, __FILE__, true);
1052 }
1053
1054 $convert->row['mp_bbcode_bitfield'] = $convert_row['mp_bbcode_bitfield'] = $message_parser->bbcode_bitfield;
1055
1056 $message = $message_parser->message;
1057 unset($message_parser->message);
1058
1059 return $message;
1060 }
1061
1062 /**
1063 * Return the bitfield calculated by the previous function
1064 */
1065 function get_bbcode_bitfield()
1066 {
1067 global $convert_row;
1068
1069 return $convert_row['mp_bbcode_bitfield'];
1070 }
1071
1072 /**
1073 * Determine the last user to edit a post
1074 * In practice we only tracked edits by the original poster in 2.0.x so this will only be set if they had edited their own post
1075 */
1076 function phpbb_post_edit_user()
1077 {
1078 global $convert_row, $config;
1079
1080 if (isset($convert_row['post_edit_count']))
1081 {
1082 return phpbb_user_id($convert_row['poster_id']);
1083 }
1084
1085 return 0;
1086 }
1087
1088 /**
1089 * Obtain the path to uploaded files on the 2.0.x forum
1090 * This is only used if the Attachment MOD was installed
1091 */
1092 function phpbb_get_files_dir()
1093 {
1094 if (!defined('MOD_ATTACHMENT'))
1095 {
1096 return;
1097 }
1098
1099 global $db, $convert, $user, $config, $cache;
1100
1101 $sql = 'SELECT config_value AS upload_dir
1102 FROM ' . $convert->src_table_prefix . "attachments_config
1103 WHERE config_name = 'upload_dir'";
1104 $result = $db->sql_query($sql);
1105 $upload_path = $db->sql_fetchfield('upload_dir');
1106 $db->sql_freeresult($result);
1107
1108 $sql = 'SELECT config_value AS ftp_upload
1109 FROM ' . $convert->src_table_prefix . "attachments_config
1110 WHERE config_name = 'allow_ftp_upload'";
1111 $result = $db->sql_query($sql);
1112 $ftp_upload = (int) $db->sql_fetchfield('ftp_upload');
1113 $db->sql_freeresult($result);
1114
1115 if ($ftp_upload)
1116 {
1117 $convert->p_master->error($user->lang['CONV_ERROR_ATTACH_FTP_DIR'], __LINE__, __FILE__);
1118 }
1119
1120 return $upload_path;
1121 }
1122
1123 /**
1124 * Copy thumbnails of uploaded images from the 2.0.x forum
1125 * This is only used if the Attachment MOD was installed
1126 */
1127 function phpbb_copy_thumbnails()
1128 {
1129 global $db, $convert, $user, $config, $cache, $phpbb_root_path;
1130
1131 $src_path = $convert->convertor_status['forum_path'] . '/' . phpbb_get_files_dir() . '/thumbs/';
1132
1133 if ($handle = @opendir($src_path))
1134 {
1135 while ($entry = readdir($handle))
1136 {
1137 if ($entry[0] == '.')
1138 {
1139 continue;
1140 }
1141
1142 if (is_dir($src_path . $entry))
1143 {
1144 continue;
1145 }
1146 else
1147 {
1148 copy_file($src_path . $entry, $config['upload_path'] . '/' . preg_replace('/^t_/', 'thumb_', $entry));
1149 @unlink($phpbb_root_path . $config['upload_path'] . '/thumbs/' . $entry);
1150 }
1151 }
1152 closedir($handle);
1153 }
1154 }
1155
1156 /**
1157 * Convert the attachment category constants
1158 * This is only used if the Attachment MOD was installed
1159 */
1160 function phpbb_attachment_category($cat_id)
1161 {
1162 switch ($cat_id)
1163 {
1164 case 1:
1165 return ATTACHMENT_CATEGORY_IMAGE;
1166 break;
1167
1168 case 2:
1169 return ATTACHMENT_CATEGORY_WM;
1170 break;
1171
1172 case 3:
1173 return ATTACHMENT_CATEGORY_FLASH;
1174 break;
1175 }
1176
1177 return ATTACHMENT_CATEGORY_NONE;
1178 }
1179
1180 /**
1181 * Obtain list of forums in which different attachment categories can be used
1182 */
1183 function phpbb_attachment_forum_perms($forum_permissions)
1184 {
1185 if (empty($forum_permissions))
1186 {
1187 return '';
1188 }
1189
1190 // Decode forum permissions
1191 $forum_ids = array();
1192
1193 $one_char_encoding = '#';
1194 $two_char_encoding = '.';
1195
1196 $auth_len = 1;
1197 for ($pos = 0; $pos < strlen($forum_permissions); $pos += $auth_len)
1198 {
1199 $forum_auth = substr($forum_permissions, $pos, 1);
1200 if ($forum_auth == $one_char_encoding)
1201 {
1202 $auth_len = 1;
1203 continue;
1204 }
1205 else if ($forum_auth == $two_char_encoding)
1206 {
1207 $auth_len = 2;
1208 $pos--;
1209 continue;
1210 }
1211
1212 $forum_auth = substr($forum_permissions, $pos, $auth_len);
1213 $forum_id = base64_unpack($forum_auth);
1214
1215 $forum_ids[] = (int) $forum_id;
1216 }
1217
1218 if (sizeof($forum_ids))
1219 {
1220 return attachment_forum_perms($forum_ids);
1221 }
1222
1223 return '';
1224 }
1225
1226 /**
1227 * Convert the avatar type constants
1228 */
1229 function phpbb_avatar_type($type)
1230 {
1231 switch ($type)
1232 {
1233 case 1:
1234 return AVATAR_UPLOAD;
1235 break;
1236
1237 case 2:
1238 return AVATAR_REMOTE;
1239 break;
1240
1241 case 3:
1242 return AVATAR_GALLERY;
1243 break;
1244 }
1245
1246 return 0;
1247 }
1248
1249 /**
1250 * Transfer avatars, copying the image if it was uploaded
1251 */
1252 function phpbb_import_avatar($user_avatar)
1253 {
1254 global $convert_row;
1255
1256 if (!$convert_row['user_avatar_type'])
1257 {
1258 return '';
1259 }
1260 else if ($convert_row['user_avatar_type'] == 1)
1261 {
1262 // Uploaded avatar
1263 return import_avatar($user_avatar, '');
1264 }
1265 else if ($convert_row['user_avatar_type'] == 2)
1266 {
1267 // Remote avatar
1268 return $user_avatar;
1269 }
1270 else if ($convert_row['user_avatar_type'] == 3)
1271 {
1272 // Gallery avatar
1273 return $user_avatar;
1274 }
1275
1276 return '';
1277 }
1278
1279 /**
1280 * Calculate the correct to_address field for private messages
1281 */
1282 function phpbb_privmsgs_to_userid($to_userid)
1283 {
1284 global $config;
1285
1286 return 'u_' . phpbb_user_id($to_userid);
1287 }
1288
1289 /**
1290 * Calculate whether a private message was unread using the bitfield
1291 */
1292 function phpbb_unread_pm($pm_type)
1293 {
1294 return ($pm_type == 5) ? 1 : 0;
1295 }
1296
1297 /**
1298 * Calculate whether a private message was new using the bitfield
1299 */
1300 function phpbb_new_pm($pm_type)
1301 {
1302 return ($pm_type == 1) ? 1 : 0;
1303 }
1304
1305 /**
1306 * Obtain the folder_id for the custom folder created to replace the savebox from 2.0.x (used to store saved private messages)
1307 */
1308 function phpbb_get_savebox_id($user_id)
1309 {
1310 global $db;
1311
1312 $user_id = phpbb_user_id($user_id);
1313
1314 // Only one custom folder, check only one
1315 $sql = 'SELECT folder_id
1316 FROM ' . PRIVMSGS_FOLDER_TABLE . '
1317 WHERE user_id = ' . $user_id;
1318 $result = $db->sql_query_limit($sql, 1);
1319 $folder_id = (int) $db->sql_fetchfield('folder_id');
1320 $db->sql_freeresult($result);
1321
1322 return $folder_id;
1323 }
1324
1325 /**
1326 * Transfer attachment specific configuration options
1327 * These were not stored in the main config table on 2.0.x
1328 * This is only used if the Attachment MOD was installed
1329 */
1330 function phpbb_import_attach_config()
1331 {
1332 global $db, $convert, $config;
1333
1334 $sql = 'SELECT *
1335 FROM ' . $convert->src_table_prefix . 'attachments_config';
1336 $result = $db->sql_query($sql);
1337
1338 $attach_config = array();
1339 while ($row = $db->sql_fetchrow($result))
1340 {
1341 $attach_config[$row['config_name']] = $row['config_value'];
1342 }
1343 $db->sql_freeresult($result);
1344
1345 set_config('allow_attachments', 1);
1346
1347 // old attachment mod? Must be very old if this entry do not exist...
1348 if (!empty($attach_config['display_order']))
1349 {
1350 set_config('display_order', $attach_config['display_order']);
1351 }
1352 set_config('max_filesize', $attach_config['max_filesize']);
1353 set_config('max_filesize_pm', $attach_config['max_filesize_pm']);
1354 set_config('attachment_quota', $attach_config['attachment_quota']);
1355 set_config('max_attachments', $attach_config['max_attachments']);
1356 set_config('max_attachments_pm', $attach_config['max_attachments_pm']);
1357 set_config('allow_pm_attach', $attach_config['allow_pm_attach']);
1358
1359 set_config('img_display_inlined', $attach_config['img_display_inlined']);
1360 set_config('img_max_width', $attach_config['img_max_width']);
1361 set_config('img_max_height', $attach_config['img_max_height']);
1362 set_config('img_link_width', $attach_config['img_link_width']);
1363 set_config('img_link_height', $attach_config['img_link_height']);
1364 set_config('img_create_thumbnail', $attach_config['img_create_thumbnail']);
1365 set_config('img_max_thumb_width', 400);
1366 set_config('img_min_thumb_filesize', $attach_config['img_min_thumb_filesize']);
1367 set_config('img_imagick', $attach_config['img_imagick']);
1368 }
1369
1370 /**
1371 * Calculate the date a user became inactive
1372 */
1373 function phpbb_inactive_time()
1374 {
1375 global $convert_row;
1376
1377 if ($convert_row['user_active'])
1378 {
1379 return 0;
1380 }
1381
1382 if ($convert_row['user_lastvisit'])
1383 {
1384 return $convert_row['user_lastvisit'];
1385 }
1386
1387 return $convert_row['user_regdate'];
1388 }
1389
1390 /**
1391 * Calculate the reason a user became inactive
1392 * We can't actually tell the difference between a manual deactivation and one for profile changes
1393 * from the data available to assume the latter
1394 */
1395 function phpbb_inactive_reason()
1396 {
1397 global $convert_row;
1398
1399 if ($convert_row['user_active'])
1400 {
1401 return 0;
1402 }
1403
1404 if ($convert_row['user_lastvisit'])
1405 {
1406 return INACTIVE_PROFILE;
1407 }
1408
1409 return INACTIVE_REGISTER;
1410 }
1411
1412 ?>
phpbb is a php-based BBS (buletin board system)