You know.. while this may be the lazy way, it's actually the most effective
for what I want to do. Thanks for the idea. It works perfectly and very
quickly. :)
- Valnir
----- Original Message -----
From: "Michael Barton" <[EMAIL PROTECTED]>
To: "Ammaross Danan" <[EMAIL PROTECTED]>
Cc: <[email protected]>
Sent: Tuesday, August 15, 2006 7:11 PM
Subject: Re: Questions about FORK.
I embedded an sqlite database in my MUD, since my host doesn't provide
me with a mysql process. I'm pretty impressed with it. The only
advantage with using mysql would be the ability to interact with it
from a website. Actually, I can interact with the sqlite database
from our website, but that's a long discussion.
Anyway, database is a good option.
Have you also considered doing it the lazy way?
-bash-3.00$ time grep '^Mkill' ../player/* | grep -i '[EMAIL PROTECTED]'
real 0m0.026s
user 0m0.020s
sys 0m0.013s
0.03 seconds to search a field from 500 pfiles... And I'm assuming
your account files are shorter than my pfiles.
--Palrich
On 8/15/06, Ammaross Danan <[EMAIL PROTECTED]> wrote:
I like Mark's suggestion (repeated below) of having accounts sorted by
email address. It does, however, remove the 'RP' of logging in using a
name (weak argument I know). Personally, my biggest problem would be if
the email address was [EMAIL PROTECTED] Pain
to type.
One more alternative though is that your accounts could be stored in a
MySQL database. Then a "SELECT id FROM accounts WHERE email = '%s' LIMIT
1" would pull the first account found with the email (no sense pulling
the whole list if by some hack of the admins there are more than one
account with the same email...) so a mysql_num_rows() > 0 would tell you
if their new or not. If the email field is indexed properly, should take
all of 0.0085 seconds for 400 accounts (random figures, but you get the
idea).
Ammaross Danan
Realms of the Forgotten
telnet://www.rotf.net:5000
http://www.rotf.net
Mark Roberts wrote:
> Honestly, the 2nd option is probably the cleanest and most efficient
> way to validate accounts my email address.
>
> I would store all account information by email address either in a
> single account file or in a subdirectory containing all pfiles for that
> player.
>
> Example:
> You have 5 players, bob, sue, john, ellen, and michael (all
> @example.com). You might have such a directory structure as this:
>
> ~/accts/[EMAIL PROTECTED]/bob.pfile
>
> ~/accts/[EMAIL PROTECTED]/sue.pfile
> ~/accts/[EMAIL PROTECTED]/irtehleetkillar.pfile
>
> ~/accts/[EMAIL PROTECTED]/john.pfile
>
> ~/accts/[EMAIL PROTECTED]/ellen.pfile
>
> ~/accts/[EMAIL PROTECTED]/michael.pfile
> ~/accts/[EMAIL PROTECTED]/korteliandree4431.pfile
> ~/accts/[EMAIL
PROTECTED]/somesillynamethaticannotpronouncegivenadictionaryandacompass.pfile
>
> Now, someone goes to log into your system. They log in with the name
> [EMAIL PROTECTED] (or try to log in anyway)
>
> We'll notice there is no accts/[EMAIL PROTECTED] directory. So we
> immediately know that we have to create a new account.
>
> Now, [EMAIL PROTECTED] decides to come play, and you immediately
> notice that there is a [EMAIL PROTECTED] directory.
> So you get a list of all the .pfile's in the directory and present them
> as character choices to play as.
>
> Mark
--
ROM mailing list
[email protected]
Unsubscribe here ->>> http://www.rom.org/cgi-bin/mailman/listinfo/rom
--
ROM mailing list
[email protected]
Unsubscribe here ->>> http://www.rom.org/cgi-bin/mailman/listinfo/rom
--
ROM mailing list
[email protected]
Unsubscribe here ->>> http://www.rom.org/cgi-bin/mailman/listinfo/rom
