You are an unregistered user, you can register here
Navigation

Information

Site

Donations
If you wish to make a donation you can by clicking the image below.


 
Go Back   The Unreal Admins Page > Forums > Hosted Forums > UTAN > Feature Requests

 
Thread Tools Display Modes
  #1  
Unread 8th April, 2006, 07:13 PM
Warped_Out Warped_Out is offline
Godlike
 
Join Date: Nov 2002
Location: USA
Posts: 426
Default Condensed GUID Search

Since most competitive ladders are requiring the last 8 digits of your GUID for validation, could UTAN provide a "Last 8 Digit GUID" search. This could, perhaps, help in catching some botters.
  #2  
Unread 8th April, 2006, 07:44 PM
Wormbo's Avatar
Wormbo Wormbo is offline
out of order
 
Join Date: Sep 2003
Posts: 3,383
Default

Searching for anything other than the first (or all) digits of the GUID may kill the database server. Sorry, but it's nasty enough if an admin triggers that by accident.
__________________
Wormbo's UT/UT2004/UT3 mods | PlanetJailbreak | Unreal Wiki | Liandri Archives
Quote:
<@Mych|Lockdown> ...and the award for the most creative spelling of "Jailbreak" goes to ... "Gandis Jealbrake Server"
  #3  
Unread 8th April, 2006, 10:09 PM
mahe mahe is offline
Godlike
 
Join Date: May 2004
Location: Austria
Posts: 253
Default

Sounds like a strange structure of the database to me.
Normally it shouldn't make any difference, it's just one simple query o_O
__________________
  #4  
Unread 9th April, 2006, 12:27 AM
Bitty's Avatar
Bitty Bitty is offline
Rampage
 
Join Date: Jun 2004
Posts: 51
Default

Yes, the query would be very simple, but getting the results would be murder on the database. Imagine looking at a stack of papers with someone's name on each, sorted alphabetically. Very easy to find what you're looking for if you're looking at the first few characters. How easy do you think it'd be if you needed to find someone with a name ending in a certain string of characters?
  #5  
Unread 9th April, 2006, 01:03 AM
mahe mahe is offline
Godlike
 
Join Date: May 2004
Location: Austria
Posts: 253
Default

That doesn't really matter ...
Try a search through the forum an look how long it takes, there you search for something in a string (%1234%) and the query is much more complicatet (Threadinfo, Userinfo, ...) imo
__________________
  #6  
Unread 9th April, 2006, 01:17 AM
Techslacker Techslacker is offline
Unstoppable
 
Join Date: Aug 2004
Posts: 248
Default

I'm no database expert but it would seem to me that a database should be able to be created that would take the guid and simply reverse it and place it into a different field that could be searched. When the user enters the last 8 digits to search, have it reversed on the fly and do the search on that field.

I would have to agree that it would probably wiser to have just a search on the last 8. The question is probably more about weighing convenience and security with utans resources and ability to execute on it. No one wants an extremely slow database to access such info.
 


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

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:10 AM.


 

All pages are copyright The Unreal Admins Page.
You may not copy any pages without our express permission.