FUDforum: How To » Table columns questions and some bug reports

Home » FUDforum » How To » Table columns questions and some bug reports

Show: Today's Messages :: Polls :: Message Navigator

Table columns questions and some bug reports [message #24331]

Sun, 24 April 2005 04:12

cstdenis

Messages: 17
Registered: April 2005

Karma: 0

Junior Member

I'm trying to integrate your forums into my site and have some questions on the structure of the user's table.

alias - What is the purpose of this? Appears to always be the same as username.
affero - What is this? Appears to always be blank.
posts_ppg - What is it? Always 0 for my test users.
referer_id - Whats this? where is it set/used?
level_id - What is this used for?
reset_key - What does this reset?
cat_collapse_status - What IS this?
users_opt - Is this a bitset of user prefrences or something?
sq - Whats this? It looks like an md5 of something.
reg_ip - What is this? -1709954525 doesn't look like an IP to me.

Also some quick bug reports.
- The registration page on your site just shows a black page after successful submission. Password was too short first try then it rejected the anti-bot code.
- Changing somebodies username causes the new username inserted into the database to be blank (latest versions of postgresql 8 & php5 and FUDforum 2.6.12)
- New topic was leading to a blank page when logged in, then gave invalid URL error on refresh untill I clicked the activate url in email.

Report message to a moderator

Re: Table columns questions and some bug reports [message #24337 is a reply to message #24331]

Sun, 24 April 2005 20:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

alias - either alias or htmlencoded version of the login.
affero - is a IM client
posts_ppg - posts to show per page (0 == default)
referer_id - referring user id, not used unless referrer tracking is enabled.
level_id - user's rank
reset_key - passwords
cat_collapse_status - category status on front page
users_opt -user's preferences
sq - sequence key for session validation
reg_ip - ip address in integer form

FUDforum Core Developer

Report message to a moderator

Previous Topic:	users bad rating
Next Topic:	header-footer files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 02:14:47 GMT 2024

Total time taken to generate the page: 0.01959 seconds