Raised This Month: $ Target: $400
 0% 

SQLx help again :P


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-30-2008 , 18:42   Re: SQLx help again :P
Reply With Quote #5

What I do whenever I need that functionality is just build the table as a keytable. Then I have two fields:

Code:
key | value
-----------
    |
    |
    |
The key contains whatever I'm looking for on the user along with whatever key component of them I'm looking for:

Code:
key                  | value
--------------------------------------
STEAM_0:0:1|name     | Hawk
STEAM_0:0:1|kills    | 7
STEAM_0:0:1|deaths   | 0
etc...
Of course, you have many more rows, but it's the only way to make it truly dynamic. You can also separate them into different tables, but I think that's more cumbersome and harder to maintain. Another advantage of this method is that you can also make each key unique.
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
 



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 09:06.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode