Jeste jednou trasovani
[mirrors/Kyberia-bloodline.git] / scripts / forumaccess.php
1 <?php
2 //requiring main config file with path/database etc. constants
3 require('../config/config.inc');
4
5 //connecting to database and creating universal $db object
6 require(SYSTEM_ROOT.'/inc/log.inc');
7 require(SYSTEM_ROOT.'/inc/database.inc');
8 require(SYSTEM_ROOT.'/inc/nodes.inc');
9 $db=new CLASS_DATABASE();
10 $db_old=new CLASS_DATABASE("kyberia","kyberia","cyb3ry","127.0.0.1");
11
12 $q="select * from nodes where node_type='7'";
13 $userset=$db->query($q);
14 while ($userset->next()) {
15 $users[$userset->getString('old_id')]=$userset->getString('node_id');
16 }
17
18 $q="select * from nodes where node_type='3'";
19 $forumset=$db->query($q);
20 while ($forumset->next()) {
21 $forums[$forumset->getString('old_id')]=$forumset->getString('node_id');
22 }
23
24 $q="select * from nodes where node_type='10'";
25 $bookcatset=$db->query($q);
26 while ($bookcatset->next()) {
27 $bookcats[$bookcatset->getString('node_creator')][$bookcatset->getString('old_id')]=$bookcatset->getString('node_id');
28 }
29
30
31
32 foreach ($forums as $forum_old => $forum_new) {
33 $q="select user_forum.*,node_access.*,user_forum.user_id as user_id from user_forum left join node_access on (node_access.node_id=user_forum.forum_id and node_access.user_id=user_forum.user_id) where forum_id='$forum_old'";
34 echo $q;
35 $set=$db_old->query($q);
36
37 while ($set->next()) {
38 $user_id=$users[$set->getString('user_id')];
39 $q="insert into node_access set
40 node_id='$forum_new',user_id='$user_id',node_bookmark='".$set->getString('user_bookmark')."'
41 ,node_permission='".$set->getString('access_type')."',
42 bookmark_category='".($bookcats[$user_id][$set->getString('parent_id')])."',
43 node_user_subchild_count='".$set->getString('submission_count')."',
44 last_visit='".$set->getString('last_visit')."'";
45
46 if ($forum_new>0 AND $user_id>0) $db->query($q);
47
48 }
49 echo "forum $forum_new flushed<br>";
50
51 }
52
53
54 ?>
This page took 0.39806 seconds and 4 git commands to generate.