Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 06-23-2019, 11:56 AM
Scandal's Avatar
Scandal Scandal is offline
 
Join Date: Dec 2005
Location: Athens / Greece
Posts: 409
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Merging two vB3 forums - import avatars question - I have stuck

Hello all!

I'm building my own vB3 merge tool for personal use since Impex is not compatible with PHP 7.

I have stuck to the following code.

We have a vB3 forum which saving the avatars on the database (source forum) and the destination forum which is saving the avatars on the file system.

PHP Code:
// make connection with source forum database
$es = new mysqli('localhost''root''''es_db');

// fetching users for merge == it takes also the avatar data
$users $es->query("
        SELECT _vbuser.*, customavatar.filename AS afilename, customavatar.filedata AS afiledata, customavatar.filedata_thumb AS afiledata_thumb,
            customprofilepic.filename AS pfilename, customprofilepic.filedata AS pfiledata,
            sigpic.filename AS sfilename, sigpic.filedata AS sfiledata
        FROM _vbuser
        LEFT JOIN _vbcustomavatar AS customavatar ON (_vbuser.userid = customavatar.userid)
        LEFT JOIN _vbcustomprofilepic AS customprofilepic ON (_vbuser.userid = customprofilepic.userid)
        LEFT JOIN _vbsigpic AS sigpic ON (_vbuser.userid = sigpic.userid)        
        ORDER BY _vbuser.userid
        LIMIT "
intval($vbulletin->GPC['perpage']) ."
    "
);
    
while (
$user $db->fetch_array($users))
{    
    
$userdm datamanager_init('User'$vbulletinERRTYPE_CP);
    
// doing things [...]
    
$userdm->pre_save(); 
    
$userid $userdm->save();    
    
    
// $userid is the new account userid on the destination forum // I want to get the Avatar data ("afiledata") and upload it to destination file system

    // Converting FROM mysql TO fs
    # !!!
    
$vbulletin->options['usefileavatar'] = true;
    if (!empty(
$user['afiledata']))
    {
        
$userpic datamanager_init('Userpic_Avatar'$vbulletinERRTYPE_CP'userpic');
        
$userpic->set_condition("userid = " $userid);
        
$userpic->setr('filedata'$user['afiledata']);
        
$pictureid $userpic->save();
    }    


# !!!
code is not working Any idea?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:23 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08672 seconds
  • Memory Usage 2,167KB
  • 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