vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   [URGENT] Unique User Profile Field (https://vborg.vbsupport.ru/showthread.php?t=219135)

Lind101 07-21-2009 11:22 PM

[URGENT] Unique User Profile Field
 
Firstly, hello to everyone of VBulletin.org.

Now to the problem. I have a board which i have linked up to the Login Server of an Online Game that i have created. To login to this game you are required to enter your GameID (A private User Profile Field i have added to the registration form and is mandatory upon forum registration) and your forum password. All works fine, however i suddenly realised that this new field i have added is not unique, which means two people may enter the same GameID which obviously would in turn cause havoc for the Login Server as it is unable to determine between accounts with the same GameID.

The reason i have decided to do it this way? Security. If i did it solely off the forum username, potential hackers would already have half of the login details and would only need the password to hack the account. This way the extra ID is kept secret and only know to the creator of the forum account.

So the question is, upon registration, is there anyway that i can get VB to check that the entered User Profile Field (GameID) is unique? Much like it does with username and email?

If not does anyone know how any hacks/mods that might allow me to add and check such a field straight into the "user" table rather than "userfield"?

Thanks in advance.

Lind

Antivirus 07-21-2009 11:43 PM

I would suggest a plugin at hook: 'register_addmember_process' to check for the duplicates. You could possibly look at how vbulletin checks for duplicate usernames, then modify that code to suit your need.

Marco van Herwaarden 07-22-2009 10:11 AM

What happens if you simply add a unique index to that column in the database?

Lind101 07-22-2009 01:12 PM

Quote:

Originally Posted by Antivirus (Post 1853227)
I would suggest a plugin at hook: 'register_addmember_process' to check for the duplicates. You could possibly look at how vbulletin checks for duplicate usernames, then modify that code to suit your need.

Yea thats the conclusion i came to, but unfortuantly i have no idea about writting Plugins for VB. I suppose i could give it a go, thanks.

Quote:

Originally Posted by Marco van Herwaarden (Post 1853420)
What happens if you simply add a unique index to that column in the database?

Throws up a database error message, but still goes ahead with the registration, just doesn't put any information in the User Profile Field in the database. Which i suppose is half the battle, as it woun't let you view any of the forums until you fill out your GameID, just a bit messy. Thanks though.

Any other idea's/solutions welcome. :)

Marco van Herwaarden 07-22-2009 02:50 PM

In that case a plugin is needed. Plugin's are just small snippets of PHP-code executed at a specific location. For more info see the manual: Plugin System


All times are GMT. The time now is 01:30 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.00973 seconds
  • Memory Usage 1,707KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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