FUDforum: How To » users table (what is sq and reg

Home » FUDforum » How To » users table (what is sq and reg_ip)?

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

users table (what is sq and reg_ip)? [message #25156]

Sat, 28 May 2005 22:16

enicholse

Messages: 30
Registered: May 2005

Karma: 0

Member

I want to move my users from egroupware/phpgroupware fud_users table into a stand alone fud installation. The fields look the same except for two, sq and reg_ip. What are they used for?

Aloha, Eric

Report message to a moderator

Re: users table (what is sq and reg_ip)? [message #25163 is a reply to message #25156]

Sun, 29 May 2005 15:58

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Both fields can be safely skipped, sq is a session validation sequence key and reg_ip is the registration IP address.

FUDforum Core Developer

Report message to a moderator

Re: users table (what is sq and reg_ip)? [message #29291 is a reply to message #25163]

Fri, 09 December 2005 07:37

viktor

Messages: 12
Registered: November 2004

Karma: 0

Junior Member

For my script i need the reg_ip value. Which is table contain it? I can't found it through sql search in MysqlAdmin.
I want to use it for something like this:
SELECT alias FROM `db_users` WHERE id = 'ID' AND reg_ip = 'reg_ip_value'

thank you

[Updated on: Fri, 09 December 2005 15:48]

Report message to a moderator

Re: users table (what is sq and reg_ip)? [message #29296 is a reply to message #29291]

Fri, 09 December 2005 17:40

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The reg_ip value is found inside the users table, so {tbl_prefix}users would be the table you'd query.

Keep in mind that reg_ip is an integer so you need to use ip2long() function to covert the raw ipv4 to that.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Topic and anonymous user
Next Topic:	No confirmation mail after registration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 11:34:55 GMT 2024

Total time taken to generate the page: 0.02662 seconds