User details

[Argon]

I am now working on an system but ho do I need to ask for the user details, now I have done like for an topic (adding "user_name" and "user_colour" in the table, but what if the users color changes I thaught it was something in the acp when changing the users default group. But how I do it best because if i put the name and the colour code in the table and the users default group changes the color is wrong So what can i do the best if I won't change so less as possible files in the ACP and my systems load time must be also so low as possible... Is it possible to easy ask all user details with an user_id orso or need i to make an resync module for the acp?

[A_Jelly_Doughnut]

user_color in the phpbb_users table changes whenever the default group changes.

I'm not 100% clear on what your problem is, honestly.

[Handyman]

The user_colour in the users table updates when the users color updates so you don't have to worry about it being updated.
To get all users details, just do this

Code: Select all

$sql = 'SELECT * FROM ' . USERS_TABLE . " WHERE user_id = $user_id";

That will have all the users details.

[Argon]

:o Lol okey thats easy but I thought it must be done at an other manier becausse there is the field "colours" in the topics table :o

[Handyman]

Yes, the user_colour in the topics table can become outdated.
I don't know what kind of resyncing they have on those? but I'll test it in a few minutes.