vb.org Archive - Moving posts from one user to another...

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Moving posts from one user to another... (https://vborg.vbsupport.ru/showthread.php?t=244240)

Moving posts from one user to another...

Hi.

I want to move posts, private messages from one user to another one, from user 2 (membership 2) to user 4 (membership 4). I don't want to delete user 2 but I want his posts to be 0 and his posts will be moved to user 4.

Please tell me about the SQL query or any code to do this.

My vBulletin Version is 3.8.5

That is not an easy task. Better would be to merge the account and then create a new account with the old name.

Can you tell me how to do the task which is not easy because I need very importantly to have the user 2 with the ID 2?

Thank you.

The new user would get a new id.

What is the reason you need the user to have id = 2? Id's are only internal reference numbers and have no special meaning.

sorry I need that because we have VIP membership numbers and most important membership will get the first numbers. Can you help please? :)

Quote:

Originally Posted by Marco van Herwaarden (Post 2050886)

The new user would get a new id.

What is the reason you need the user to have id = 2? Id's are only internal reference numbers and have no special meaning.

Is there a reason why changing the userid of the 'new' member in the user table back to '2' wouldn't work so long as there is no existing entry for user '2.'?

Userid's are referenced in many places, so it is not a simple change.

@xsultanx
I strongly suggest you change your method, as this is really limiting your options. A userid is only a reference number and should never be given any meaning.

OK is there a ways to change the user ID from starting from 1 to start from 0? or to start from 10 for example?

The problem is that in posbit_lagacy template I have a field which shows the membership number which is the same as ID :)

Quote:

Originally Posted by xsultanx (Post 2051635)

Although this would be a 'dirty' fix you could include a conditional so that "if userid = 750, display userid = 2" in the postbit... If this is the only member you need to do this for it will work but would totally suck for multiple members.

I will try this but how should I write the code exactly?

I don't know what the variable name is for the userid, but I'm guessing you do since you are already displaying it so for the example I will call is $userid...

Code:



<if condition="$userid = 750">

$user_display_id = 2;

<else />

$user_display_id = $userid;

</if>

Then change wherever you display $userid to $user_display_id and it will over-ride the number for user '750' in this example with '2'

Thanks so much, but can you edit it I did not know the variables name, here is the code:

PHP Code:


		
			
    <div class="smallfont">

                &nbsp;<br />

                <if condition="$post['joindate']">

                <input type="text" name="Date" size="25" dir="rtl" value="$vbphrase[join_date]: $post[joindate]" class="alt1 infouser" />

                </if>



                <input type="text" name="ID" size="25" dir="rtl" value="$vbphrase[userid] : $post[userid]" class="alt1 infouser" />

                <if condition="$post['field2']">

                <input type="text" name="location" size="25" dir="rtl" value="$vbphrase[location_perm] : $post[field2]" class="alt1 infouser" />

                </if>

I'm sorry I just tested this and it does not work. I forgot you can't do php in a template, so there's no way of setting/changing the variables. I don't know if there's a way around this but the code would have been this:

PHP Code:


		
			
<div class="smallfont"> 
                &nbsp;<br /> 
                <if condition="$post['joindate']"> 
                <input type="text" name="Date" size="25" dir="rtl" value="$vbphrase[join_date]: $post[joindate]" class="alt1 infouser" />
                </if> 

<if condition="$post[userid]= 750">
    $user_display_id = 2;
<else />
    $user_display_id = $post[userid];
</if>

                <input type="text" name="ID" size="25" dir="rtl" value="$vbphrase[userid] :  $user_display_id" class="alt1 infouser" />
                <if condition="$post['field2']"> 
                <input type="text" name="location" size="25" dir="rtl" value="$vbphrase[location_perm] : $post[field2]" class="alt1 infouser" />
                </if>

But like I said, it doesn't work... Maybe someone else knows if there is way of doing this?

--------------- Added [DATE]1276222079[/DATE] at [TIME]1276222079[/TIME] ---------------

OK, I see what you have to do is add the php code to a plugin... in 100% honesty I have never done this before so I don't want to even guess at how to do it, I doubt it would work- but maybe someone else could tell you the code you'd need to put in the plugin... I guess my issue is if $post[userid] is available to the plugin... if so it would be relatively simple... OK this might be a tremendous waste of time and I strongly urge you to backup your forum first or better yet try this on a test board first...

In Admin CP go to Plugins and Products -> add new plugin

Hook Location: global_start
Title: UserID Override
Execution Order: 5
Plugin PHP Code:

PHP Code:


		
			
   if ($post[userid] = 750)
      $user_display_id = 2;
   else
      $user_display_id = $post[userid];

Of course change the numbers 750 and 2 to fit your needs.
Save Plugin...

And then change the code in the template you gave me above to:

PHP Code:


		
			
<div class="smallfont"> 
                &nbsp;<br /> 
                <if condition="$post['joindate']"> 
                <input type="text" name="Date" size="25" dir="rtl" value="$vbphrase[join_date]: $post[joindate]" class="alt1 infouser" />
                </if> 

                <input type="text" name="ID" size="25" dir="rtl" value="$vbphrase[userid] : $user_display_id" class="alt1 infouser" />
                <if condition="$post['field2']"> 
                <input type="text" name="location" size="25" dir="rtl" value="$vbphrase[location_perm] : $post[field2]" class="alt1 infouser" />
                </if>

And if all that works it would be a fricken miracle... please let me know if you decide to try it.

immm I guess I would not try that:) .. but I have an idea... now I just want to delete all posts of the user 2 and remain the user.. can I do that?

--------------- Added [DATE]1276257027[/DATE] at [TIME]1276257027[/TIME] ---------------

or at least make his posts related to anonymous membership and make his posts 0

You may delete all his post in admincp > threads & Posts > prune > prune by username. Or search for user > select Find all post by user > then select them all > user Moderation Tools to delete them.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (16)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01192 seconds Memory Usage 1,788KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (16)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: