Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-29-2011, 10:31 AM
Tabasco's Avatar
Tabasco
Discordant
 
Join Date: Sep 2009
Posts: 269
Default

You could have an NPC in game that has a registration script. They hail and go through whatever process you like, ultimately generating a random password and whispering it to the client. The perl script should write the account name and the generated password to a table in the db. You might query that table first to see if they've already completed registration or if they've only attempted it and decide how resets or forgotten temporary passwords will be handled.

Next, when they go to the forum to register, you would need to add two new form elements for the account name and the temporary password. In phpbb this is pretty easy. I already use the account_ip table on my server to keep spammers out of my forums without having to worry about registration emails. If it all matches up you update that original username/temp pw table to include the forum username and current status, which at creation should probably be 0. Just to be clear, login server account names should not be forum usernames. They really should never be exposed, instead map one to the other privately.

The last step would be to update status based on forum settings. The easy way would be to set up a cron job or scheduled task to process updates, but even with a cache to prevent redundant updates, your overhead will grow with your userbase, regardless of whether or not they are playing. If you really wanted to get intimate with your BB package you could insert immediate update hooks any time a group is changed, which would probably be more efficient but also a little more complex.
I think status gets re-read when a user logs in so just writing the status to the db should be fine. If I'm wrong you could use a telnet library.

This all assumes you're competent and comfortable with some programming, mostly perl and php. I've never used vBulletin (I'm guessing that's what your VB stands for) but you wouldn't be able to do this without source access.
Reply With Quote
 


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

Forum Jump

   

All times are GMT -4. The time now is 02:36 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3