Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 31 Jan 2004, 01:25
Teresa Teresa is offline
 
Join Date: Jan 2004
Question Change Guest to User on threads (EZBoard)

Freddie just updated my vB3 with my old EZBoard posts. Worked GREAT! Yea.

Now I'd like to be able to convert the old GUEST userid's to registered members (including my own) as the new come over and register on the site.

I think I've found two vB tables: POSTS and THREADS that contain the userid and the user name.

I manually changed one post to test it, and changing the userid from zero to the correct userid number works perfectly.

So, I just need a simple script to search for users of a certain name and change the associated userid's to the appropriate number.

ALSO, I need to rerun some query to properly update the number of posts for that user.

Anybody??
Reply With Quote
  #2  
Old 28 May 2004, 18:09
Titus Titus is offline
 
Join Date: Apr 2004
Sorry to bump this, but I too would like this hack. Our board is planning on moving off of ezBoard very soon, and I really, really do not want to import to vb2, and then upgrade to 3.

If someone could update this hack to vB3, I would be incredibly grateful.

Thanks!
Reply With Quote
  #3  
Old 31 May 2004, 15:44
Titus Titus is offline
 
Join Date: Apr 2004
Pretty Please?

*blinks bambi-eyes*
Reply With Quote
  #4  
Old 31 May 2004, 17:16
dstruct2k's Avatar
dstruct2k dstruct2k is offline
 
Join Date: Dec 2002
Real name: Bill
Actually, that code looks like it would work with vb3 as well... At least, the part where it links new registrants to old accounts.

I'll still look for antiquated functions and fix if needed, but I think it's good.
Reply With Quote
  #5  
Old 31 May 2004, 17:23
dstruct2k's Avatar
dstruct2k dstruct2k is offline
 
Join Date: Dec 2002
Real name: Bill
Alright, it was just missing TABLE_PREFIX's but I added them and cleaned up the code.

In register.php find:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

After add:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #6  
Old 01 Jun 2004, 04:36
Titus Titus is offline
 
Join Date: Apr 2004
Awesome, thanks!
Reply With Quote
  #7  
Old 08 Jul 2004, 01:54
Berethorn Berethorn is offline
 
Join Date: Jun 2004
Is this a proven working script, then? And if I someone registers with their username before the old posts move from ezboard, will those old posts not get linked?
Reply With Quote
  #8  
Old 16 Aug 2004, 17:28
Titus Titus is offline
 
Join Date: Apr 2004
It worked great for me. I deleted all the user accounts that had been registered prior to our ezboard being moved over, so I can't say whether or not this would work with an existing user.

Hmm.. If you have a lot of users registered already, and they want their old posts back, I would say you would (short of writing a merge hack, which I recall seeing for vb2 somewhere) change the existing user name (Like: Bob2), then have the person register their old name (Bob), and then merge the two together.

Lots of trouble to go through though.
Reply With Quote
  #9  
Old 12 Sep 2004, 19:11
lazserus's Avatar
lazserus lazserus is offline
 
Join Date: Mar 2004
Has anyone figured how to implement these hacks after the board has been converted by vB? I've been with vB for over a year and no hack I've tried links usernames. For instance, my username here is the same on my board, but all the old EzBoard posts (under the exact same name) show me as a guest. I see how hacking the register.php would link NEW users to a guest name, but I need to link currently registered members over. The vB2 script did this, but it doesn't work for vB3.

I'm not a coder, so I can't write a script for it. I'm also not about to make 600 of my members register again and do merging. That's just too much.

Last edited by lazserus; 12 Sep 2004 at 19:13.
Reply With Quote
  #10  
Old 19 Jul 2005, 00:40
feldon23's Avatar
feldon23 feldon23 is offline
 
Join Date: Nov 2001
This works on vB3.0.7?
Reply With Quote
  #11  
Old 27 Jul 2005, 17:47
Alex Apple Alex Apple is offline
 
Join Date: Aug 2004
Originally Posted by feldon23
This works on vB3.0.7?
I'm in the same boat. I'm about to convert an ezboard over to vBulletin but this user question is going to be key.

The only way I think this might be possible is use the ezboard-->phpBB converter available here, which I've tested and which seems to work quite well. It's basically a spider, but which creates dummy accounts. It gives all the dummy usernames the same dummy password and email, but it's obviously changeable (bit of a security risk though). I'm currently planning to do the ezb-->phpBB import, and then use Impex to import the phpBB database. It's a bit long-winded, but I can't see much other of a way round.
Reply With Quote
  #12  
Old 27 Jul 2005, 19:35
feldon23's Avatar
feldon23 feldon23 is offline
 
Join Date: Nov 2001
Originally Posted by Alex Apple
I'm in the same boat. I'm about to convert an ezboard over to vBulletin but this user question is going to be key.

The only way I think this might be possible is use the ezboard-->phpBB converter available here, which I've tested and which seems to work quite well. It's basically a spider, but which creates dummy accounts. It gives all the dummy usernames the same dummy password and email, but it's obviously changeable (bit of a security risk though). I'm currently planning to do the ezb-->phpBB import, and then use Impex to import the phpBB database. It's a bit long-winded, but I can't see much other of a way round.
I tried to rewrite the EZBoard user importer posted here:
http://www.vbulletin.org/forum/showthread.php?t=31443

to work with vBulletin 3 but I have failed. I am now having to restore a forum database because of it.

The problem is that one of the users I imported has an apostrophe in their name.


EDIT: Please see the updated version of this script later down the page that fixes various bugs and cleans up the rest of the code.

Last edited by feldon23; 28 Jul 2005 at 19:51. Reason: Automerged Doublepost
Reply With Quote
  #13  
Old 27 Jul 2005, 21:56
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Change:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Do that everywhere the username is used in a query.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #14  
Old 28 Jul 2005, 00:22
feldon23's Avatar
feldon23 feldon23 is offline
 
Join Date: Nov 2001
Originally Posted by MarcoH64
Change:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Do that everywhere the username is used in a query.
Should I go ahead and do addslashes(htmlspecialchars($newusername)) for every occurence of $newusername to be thorough?

Also wrestling with getting some kind of CSS to load.
Reply With Quote
  #15  
Old 28 Jul 2005, 05:26
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Only addslashes, never said anything about htmlspecialchars.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Guest to User on threads (EZBoard) Freddie Bingham vBulletin 3.5 Add-ons 16 12 Feb 2008 14:44
Guest,s Can,t see the Threads all-the-vb vBulletin 2.x Full Releases 26 21 Jan 2004 04:25



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:37.

Layout Options | Width: Wide Color: