vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Administrative and Maintenance Tools - Change Threads/Posts Owner/Date for vB3.8 (https://vborg.vbsupport.ru/showthread.php?t=200952)

Phalynx 09-20-2009 07:41 PM

Quote:

Originally Posted by RenatoMN (Post 1886827)
Hello, Phalynx.

I just upgraded a vB from 3.7.2 to 3.8.4 using ImpEx, instead actually doing an update. I was not careful enough to create the admin account in the new vB with a diff. e-mail from the admin in the old vB, so this user was NOT migrated. The posts and threads are there, with "RenatoMN" as a unregistered user.

May you explain how can I find all posts/threads from this unregistered user and change the owner to my new user without need to browse all the forums? The posts aren't returned when I search posts by author username.

Regards,
Renato

You will need to run SQL Queries to accomplish this to all postings:
PHP Code:

update post set userid=1 where username="User"
update thread set postuserid=1 where postusername="User" 

Replace userid/postuserid with the UserID of the new owner, also replace "User" with the Username of the old user.

morrow 09-22-2009 01:52 PM

This mod looks great. I was wondering though.... I had a mod a while back which actually let me post a new thread or reply to a thread as a different user. I need to satisify my alter ego's. Is there any way to work that feature into your mod?

Phalynx 09-22-2009 04:34 PM

No, and not on my todo list.

RenatoMN 10-03-2009 07:04 PM

Quote:

Originally Posted by Phalynx (Post 1888160)
You will need to run SQL Queries to accomplish this to all postings:
PHP Code:

update post set userid=1 where username="User"
update thread set postuserid=1 where postusername="User" 

Replace userid/postuserid with the UserID of the new owner, also replace "User" with the Username of the old user.

Very thanks, Phalynx :)

tlwwolfseye 10-04-2009 07:02 AM

Are there any permission settings on this Mod for who can use it or not ?

ClanAH 10-05-2009 06:50 AM

Hey, Great mod .. But what if a username was 666? Wouldn't that be a conflict with the username and userID? Or does a username take precedence over userID?

Also, when you edit the date it is setup as Day - Month - Year, This is confusing because in the actual thread the date is setup as Month - Day - Year.

Powlo 10-10-2009 07:59 PM

Ive just attempted to install this mod but i am getting this error when i import it and thus need to 'go back'

Code:

XML Error: Undeclared entity warning at Line 475
Any ideas what i need to do.

I'm running vb 3.8.1

Phalynx 10-12-2009 08:40 AM

Quote:

Originally Posted by tlwwolfseye (Post 1894526)
Are there any permission settings on this Mod for who can use it or not ?

You can enter the usergroup that can use this via options.

Quote:

Originally Posted by ClanAH (Post 1895036)
Hey, Great mod .. But what if a username was 666? Wouldn't that be a conflict with the username and userID? Or does a username take precedence over userID?

In fact, this could be a problem. Why not testing this out? :)

Quote:

Originally Posted by Powlo (Post 1897732)
Ive just attempted to install this mod but i am getting this error when i import it and thus need to 'go back'

Code:

XML Error: Undeclared entity warning at Line 475
Any ideas what i need to do.

I'm running vb 3.8.1

It seems the downloaded file is corrupt.

BRotondi 10-18-2009 06:44 PM

Very nice, installed :) Thanks a lot!

"Nice to have": Detailed Log, what has been changed (User/Date).

Greetings from Switzerland, Bruno
(vB 3.8.4 PL1)

BRotondi 10-18-2009 06:57 PM

Another interesting setting would be a "Time Offset": My server is the USA, my seat in Switzerland. This means: I always have to subtract 9 hours when changing the posting time (e.g. to add an "intro post" to an existing thread).

But anyway: Thanks again for this nice hack!
Bruno


All times are GMT. The time now is 08:04 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.01230 seconds
  • Memory Usage 1,745KB
  • 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
  • (2)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete