user table and profile table

I'm just wondering why AU class is using 2 tables. Because of the following things i found:

- I don't need the "real name" column in my user table
- I like to add some other information which i wouldn't describe as a "profile"
- If you want all the user data you have to query 2 tables instead of one.
- I read how to add extra fields to the profile table but it's not really easily done since you need to modify some code. Which i think will be about the same if you want to add something to the normal user table.

Then some questions about adding more fields.

define("TBL_USERFIELD_5", "user_5");
does this needs to be succesive. I.E. user_5 user_6 user_7 and so on ?
is the TBL_USERFIELD_5 the column name of the table which i can set to anything?


And last, how do i know which user data is already available to me $user->id or something and which i have to query for ?

once again thx for your support

hehe, I was asking me this often too :)

The reason was to use AU without the profile ext. and 1mio. users.

a table with 30+ columns and a large amount of user could have some performance issues (at least in mysql 3.23)

I was happy if I had the time to rewrite AU to a newer php5 styled version ;)

thanks for your reply olaf.

can you please answer the questions below "Then some questions about adding more fields."

is it true you won't be releasing any new versions?

check this thread for the extra table fields.

I don't plan to expand this script, but I will fix important things.

Look php4 is an old horse, I don't spend time in php4 based classes anymore, maybe there is some days a AU class written for php5/6.

at the end php4 becomes boring the last time :(

Ok i was working on different area's of my website but now i'm back at this issue.

What i need it about 30 fields for users with access level 3 or higher.
I don't need any of the fields in users_profile.

Now i can do two things:
1. Alter your files but that has to be a lot and since i don't wrote it myself it is somewhat confusing.
2. Make a table myself and put all the extra data in there and make seperate query's outside the class.

Which one would you recommend looking at security and flexibility ?

thx

check this thread
http://www.webdigity.com/index.php/topic,2345.0.adding+new+fields+to+the+profile+table.html

i've read that thread a couple of times already, my question remains. what do you recommend ?

depends on what you need to do with that data, if this fits into the data structure use class