vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Map Post to users in vBulletin after EZBoard Import (https://vborg.vbsupport.ru/showthread.php?t=53588)

iamtgo3 05-30-2003 09:56 PM

Map Post to users in vBulletin after EZBoard Import
 
Sorry I know this is presale but it does pertain to a question people may ask about.

Ok I have bought vBulletin and I had Freddie import the data from EZBoard. Which I must say he did an awesome job and for that I am thankful. Now that I have all the post in vBulletin I need to map the post to the users once they register on the new forums. Does anyone have a link or an idea on how to do this. I have already searched and found nothing so please do not say search for this unless it will pull up some results.

Thanks

Dan 05-30-2003 10:04 PM

I have yet to see anything like this... but it would be useful I think because I've done things like this before.

And I think someone should move this to hack requests

iamtgo3 05-30-2003 10:52 PM

Well as far as I can see there are two table you need to change Post and Thread.

Post Change would go like this.
PHP Code:

UPDATE post SET userid '[I]posters userid[/I] ' WHERE username '[I]posters username[/I] ' 

Thread Change would go like this.
PHP Code:

UPDATE thread SET postuserid '[I]posters userid[/I] ' WHERE postusername '[I]posters username[/I] ' 

NOTE - This is a suggestion please do not use it till someone who knows vBulletin verifies that it is right. I tried it and it seems to work.

iamtgo3 06-05-2003 04:28 PM

On my above post I was wondering if that is the correct way to remap users to their old EZBoard post that have been converted to vBulletin??? Also after you have ran the above the post date and the user reg date is way different any fixes for this.

Erwin 06-07-2003 01:21 AM

There is a hack like this already - search for "ezboard".

iamtgo3 06-15-2003 02:31 AM

I have been looking for this hack but all I get from everyone here is search for EZBoard. I have and it is like a millions post to search through. What I suggest is make a link on the main page to this answer becuase it is a hot topic for people asking it here are converting to your vBulletin software.

This post will help people out for changing post counts
EZBoard to vBulletin

Thanks

Erwin 06-15-2003 04:21 AM

Quote:

Today at 01:31 PM iamtgo3 said this in Post #6
This post will help people out for changing post counts
EZBoard to vBulletin

Thanks

It's more than just links post counts. It also will automatically link an ezboard member who registers with the same username in the new vB forum with all his old posts, and thus get his old post count and old posts. Just tell your old ezboard members to register with the same username, and they will get their old posts link to them automatically on registration.


All times are GMT. The time now is 11:11 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.01063 seconds
  • Memory Usage 1,727KB
  • 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_php_printable
  • (1)bbcode_quote_printable
  • (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