vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Plugin? or something (https://vborg.vbsupport.ru/showthread.php?t=269681)

silvermerc 09-05-2011 05:08 AM
Plugin? or something
 
Can someone give me a guide to connect a users posts together, Not a merge. The user got deleted and then i need to restore his posts to his current amount?
Ross

Gio~Logist 09-05-2011 06:21 AM
As far as i know, you would need to run a query to update the database.

But even then, i'm wondering how you'd tell your server what posts to associate the user with, if the posts were set to guest already.

Lynne 09-05-2011 03:16 PM
Actually, the post table keeps the username even if the post was deleted (it will have the original username, but have userid set to 0). So, you would do a query that changes all posts with username "xxxx" and userid "0" to username "yyyy" and userid "1234" You'd then have to also update the user table and enter in the correct number of posts for the user.

Gio~Logist 09-05-2011 07:25 PM
Lynne's right. Run the queries as follows:

Code:
update thread SET postuserid = 'x' AND postusername = 'y' WHERE postusername = 'oldusername'
Code:
update post  SET userid = 'x' AND username = 'y' WHERE username = 'oldusername'
Update it accordingly if your tables have prefixes.


All times are GMT. The time now is 01:12 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01105 seconds
  • Memory Usage 1,710KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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