The Arcive of Official vBulletin Modifications Site.

ChristianAlfred · #1 01-07-2016, 12:13 PM

Here is a script for import from vb3 to vb5

How can I make it work for vb4 to vb5?
Original code: https://github.com/netgainCanada/photo-migration-vbulletin/blob/master/old-album-to-new-album.php

PHP Code:


			
<?php

/*

 * NOT FOR PHOTOPLOG MIRGRATION - THIS IS FOR USERS WITH MISSING ALBUMS AND ALBUM IMAGES

 */

//HOST, USER, PASS, NAME

$link = mysqli_connect('host','dbuser','dbpass','dbname') or die("Error " . mysqli_error($link));

//USE IF SERVER CAN RUN ALL QUERIES

$userquery = 'SELECT DISTINCT userid FROM picture ';

//USE IF SERVER CAN'T RUN ALL QUERIES AND YOU NEED TO BREAK IT UP BY OFFSET AND RUN SCRIPT MULTIPLE TIMES

//$userquery = 'SELECT DISTINCT userid FROM picture LIMIT 10 OFFSET 0';

$userresult = mysqli_query($link, $userquery) or die(mysqli_error($link)." Q=".$userquery);

/*

 * LOOP ALL THE USERS

 */

while($user = mysqli_fetch_array($userresult)){

    //GET USER ID

    $userid = $user['userid'];

    //SELECT ALL DATA FROM NODE

    $albumquery = 'SELECT * FROM node WHERE userid = '.$userid.' AND parentid = 9';

    $albumresults = mysqli_query($link, $albumquery) or die(mysqli_error($link)." Q=".$albumquery);

    //LOOP ALBUM TO GET NODE INFO

    while($albumdata = mysqli_fetch_array($albumresults)){

        //GET NODEID, PUBLISH DATE, URL && NEW URL

        $albumid = $albumdata['nodeid'];

        $username = $albumdata['authorname'];

        $publishdate = $albumdata['publishdate'];

        $url = $albumdata['urlident'];

        $newurl = 'new-albums-'.$userid;

        $routeid = $albumdata['routeid'];

        $lastcontentdate = $albumdata['lastcontent'];

        echo 'I am the album <strong>'.$albumid.'</strong><br/><br/>';

        //UPDATE urlident FROM NULL TO NEW URL

        if($url == NULL || $url == ''){

            $updateStarter = 'UPDATE node SET urlident = "'.$newurl.'" WHERE nodeid = '.$albumid;

            $updateStarterQuery = mysqli_query($link, $updateStarter) or die(mysqli_error($link)." Q=".$updateStarter);

        }

        //UPDATE routeid

        if($routeid == '51'){

            $updateRoute = 'UPDATE node SET routeid = "52" WHERE nodeid = '.$albumid;

            $updateRouteQuery = mysqli_query($link, $updateRoute) or die(mysqli_error($link)." Q=".$updateRoute);

        }

        //UPDATE LAST CONTENT DATE

        if($lastcontentdate == '' || $lastcontentdate == 0 || $lastcontentdate == NULL){

            $updateLastContent = 'UPDATE node SET lastcontent = "'.$publishdate.'" WHERE nodeid = '.$albumid;

            $updateLastContentQuery = mysqli_query($link, $updateLastContent) or die(mysqli_error($link)." Q=".$updateLastContent);

        }

        //INSERT ALBUM INTO CLOSURE

        $selectClosure = 'SELECT * FROM closure WHERE parent = '.$albumid.' AND child = '.$albumid.'';

        $selectresults = mysqli_query($link, $selectClosure) or die(mysqli_error($link)." Q=".$selectClosure);

        if(mysqli_num_rows($selectresults) == 0){

            $insertClosure = 'INSERT INTO closure(parent,child,depth,displayorder,publishdate) VALUES("'.$albumid.'","'.$albumid.'",0,0,"'.$publishdate.'")';

            $insertQuery = mysqli_query($link, $insertClosure) or die(mysqli_error($link)." Q=".$insertClosure);

        }

        /*******/

        $selectClosure = 'SELECT * FROM closure WHERE parent = 9 AND child = '.$albumid.'';

        $selectresults = mysqli_query($link, $selectClosure) or die(mysqli_error($link)." Q=".$selectClosure);

        if(mysqli_num_rows($selectresults) == 0){

            $insertClosure = 'INSERT INTO closure(parent,child,depth,displayorder,publishdate) VALUES("9","'.$albumid.'",1,0,"'.$publishdate.'")';

            $insertQuery = mysqli_query($link, $insertClosure) or die(mysqli_error($link)." Q=".$insertClosure);

        }

        /*******/

        $selectClosure = 'SELECT * FROM closure WHERE parent = 6 AND child = '.$albumid.'';

        $selectresults = mysqli_query($link, $selectClosure) or die(mysqli_error($link)." Q=".$selectClosure);

        if(mysqli_num_rows($selectresults) == 0){

            $insertClosure = 'INSERT INTO closure(parent,child,depth,displayorder,publishdate) VALUES("6","'.$albumid.'",2,0,"'.$publishdate.'")';

            $insertQuery = mysqli_query($link, $insertClosure) or die(mysqli_error($link)." Q=".$insertClosure);

        }

        /*******/

        $selectClosure = 'SELECT * FROM closure WHERE parent = 1 AND child = '.$albumid.'';

        $selectresults = mysqli_query($link, $selectClosure) or die(mysqli_error($link)." Q=".$selectClosure);

        if(mysqli_num_rows($selectresults) == 0){

            $insertClosure = 'INSERT INTO closure(parent,child,depth,displayorder,publishdate) VALUES("1","'.$albumid.'",3,0,"'.$publishdate.'")';

            $insertQuery = mysqli_query($link, $insertClosure) or die(mysqli_error($link)." Q=".$insertClosure);

        }

        /**************************************************************/

        //QUERY & LOOP PICTURES FOR SPECIFIC USER ALBUM

        $pictable = 'SELECT * FROM node

            LEFT JOIN photo ON(

                photo.nodeid = node.nodeid

            )

            LEFT JOIN attachment ON(

                attachment.filedataid = photo.filedataid

            )

            LEFT JOIN picturelegacy ON(

                picturelegacy.attachmentid = attachment.attachmentid

            )

            LEFT JOIN picture ON(

                picture.pictureid = picturelegacy.pictureid

            )

            WHERE node.parentid = '.$albumid.' AND node.userid = '.$userid;

        $picresult = mysqli_query($link, $pictable) or die(mysqli_error($link)." Q=".$pictable);

        while($pic = mysqli_fetch_array($picresult)){

            $filenode = $pic['nodeid'];

            $picid = $pic['pictureid'];

            $filedataid = $pic['filedataid'];

            $filedata = $pic['filedata'];

            $ext = $pic['extension'];

            $filename = $pic['filename'];

            if($filedata != ''){

                //INSERT INTO ATTACH TABLE

                $selectAttach = 'SELECT * FROM attach WHERE nodeid = '.$filenode.' AND filedataid = '.$filedataid.'';

                $attachresults = mysqli_query($link, $selectAttach) or die(mysqli_error($link)." Q=".$selectAttach);

                if(mysqli_num_rows($attachresults) == 0){

                    $insertAttach = 'INSERT INTO attach(nodeid,filedataid,visible,counter,filename,caption) VALUES("'.$filenode.'", "'.$filedataid.'",1,0,"'.$filename.'","")';

                    $insertAttachQuery = mysqli_query($link, $insertAttach) or die(mysqli_error($link)." Q=".$insertAttach);

                }

                //UPDATE EXTENSION

                if($ext == 'png'){

                    $updateFiledata = 'UPDATE filedata SET extension = "jpg" WHERE filedataid = '.$filedataid;

                    $updateFiledataQuery = mysqli_query($link, $updateFiledata) or die(mysqli_error($link)." Q=".$updateFiledata);

                    echo 'Update PNG to JPG '.$filedataid.'<br/>';

                }

                /********************************************/

                //CREATE USER DIRECTORY IF NOT EXIST

                $dirArray = str_split($userid);

                $dirString = '';

                foreach($dirArray as $dir){

                    if (!file_exists('forum_path-attachments/'.$dirString.'/'.$dir.'')) {

                        mkdir('forum_path-attachments'.$dirString.'/'.$dir.'', 0777, true);

                    }

                    $dirString = $dirString.'/'.$dir;

                }

                // MOVE OLD FILE TO NEW ATTACH FOLDER STRUCTURE

                if(!file_exists('forum_path-attachments/'.$dirString.'/'.$filedataid.'.attach') && $filedata != ''){

                    file_put_contents('forum_path-attachments'.$dirString.'/'.$filedataid.'.attach', $filedata);

                }

                /********************************************/

                //INSERT INTO FILENODEID INTO CLOSURE WITH ALBUMID AS PARENT

                $selectAlbumClosure = 'SELECT * FROM closure WHERE parent = '.$albumid.' AND child = '.$filenode.'';

                $selectAlbumresults = mysqli_query($link, $selectAlbumClosure) or die(mysqli_error($link)." Q=".$selectAlbumClosure);

                if(mysqli_num_rows($selectAlbumresults) == 0){

                    $insertAlbumClosure = 'INSERT INTO closure(parent,child,depth,displayorder,publishdate) VALUES("'.$albumid.'","'.$filenode.'",1,0,"'.$publishdate.'")';

                    $insertAlClQuery = mysqli_query($link, $insertAlbumClosure) or die(mysqli_error($link)." Q=".$insertAlbumClosure);

                }

                /****/

                //INSERT INTO FILENODEID INTO CLOSURE WITH FILENODEID AS PARENT

                $selectFileClosure = 'SELECT * FROM closure WHERE parent = '.$filenode.' AND child = '.$filenode.'';

                $selectFileresults = mysqli_query($link, $selectFileClosure) or die(mysqli_error($link)." Q=".$selectFileClosure);

                if(mysqli_num_rows($selectFileresults) == 0){

                    $insertFileClosure = 'INSERT INTO closure(parent,child,depth,displayorder,publishdate) VALUES("'.$filenode.'","'.$filenode.'",0,0,"'.$publishdate.'")';

                    $insertFiClQuery = mysqli_query($link, $insertFileClosure) or die(mysqli_error($link)." Q=".$insertFileClosure);

                }

            }

        }

    }

    echo '<br/>DONE<br/>';

}

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08849 seconds Memory Usage 2,281KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!