vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Change username on a post? (https://vborg.vbsupport.ru/showthread.php?t=210851)

Ohiosweetheart 04-10-2009 02:38 PM

Change username on a post?
 
Is there a way to change the username on a post? So that it's posted by someone else, not me? (hypothetically)

Lynne 04-10-2009 03:26 PM

I believe there is a mod to do this.

Ohiosweetheart 04-10-2009 03:53 PM

off I go to look then.

Thanks Lynne

EnIgMa1234 04-10-2009 03:58 PM

You could also run a query from your admincp with the following:

[SQL]UPDATE post SET username = 'NEWUSERNAME HERE', userid = 'NEW USERID HERE' WHERE postid = 'POSTID HERE'[/SQL]

Ohiosweetheart 04-10-2009 04:06 PM

do that to change the username on just one post?

Lynne 04-10-2009 07:37 PM

That should work for just one post unless the post is the first post in a thread (in which case you need to modify the thread table also to set the thread starter username and id) or the last post in a thread (in which case you need to modify the thread table to set the lastposter username). Oh, and then if there are attachments, you'd need to change the owner of those also.

Ohiosweetheart 04-10-2009 07:45 PM

ah geeze, never mind then, lol.
Thanks anyway! :)


All times are GMT. The time now is 03:29 PM.

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.01004 seconds
  • Memory Usage 1,709KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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