FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Table columns questions and some bug reports
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Table columns questions and some bug reports [message #24331] Sun, 24 April 2005 04:12 Go to next message
cstdenis is currently offline  cstdenis   Canada
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.
Re: Table columns questions and some bug reports [message #24337 is a reply to message #24331] Sun, 24 April 2005 20:54 Go to previous message
Ilia is currently offline  Ilia   Canada
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
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: users bad rating
Next Topic: header-footer files
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 12:41:40 GMT 2024

Total time taken to generate the page: 0.02459 seconds