wapdesire v-2 ip And browser member query

[eynesilli]

add a new feature but I do not know how to. ip with the first record and browser

CREATE TABLE `users` (
`id` int(100) NOT NULL auto_increment,
`regdate` int(100) NOT NULL default '0',
`username` varchar(12) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`level` char(1) NOT NULL default '0',
`shield` char(1) NOT NULL default '0',
`lastact` int(100) NOT NULL default '0',
`pollid` int(100) NOT NULL default '0',
`reg_browser` varchar(100) NOT NULL default '',
`reg_ipaddress` varchar(30) NOT NULL default '',
`browser` varchar(100) NOT NULL default '',
`ipaddress` varchar(30) NOT NULL default '',
`host` varchar(100) NOT NULL default '',
`reg_host` varchar(100) NOT NULL default '',
`validated` char(1) NOT NULL default '0',
`images` char(1) NOT NULL default '1',
`automsgs` char(1) NOT NULL default '1',
`popups` char(1) NOT NULL default '1',
`hidden` char(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

new added
............. function is not change them. fixed ...............
`reg_browser` varchar(100) NOT NULL default '',
`reg_ipaddress` varchar(30) NOT NULL default '',
reg.php

mysql_query("UPDATE users SET reg_browser='".browser()."', reg_ipaddress='".ip()."', reg_host='".subno()."' WHERE id='".getuid_sid($sid)."'");
.................................................. ...................................

`browser` varchar(100) NOT NULL default '',
`ipaddress` varchar(30) NOT NULL default '',

mysql_query("UPDATE users SET browser='".browser()."', ipaddress='".ip()."', host='".subno()."' WHERE id='".getuid_sid($sid)."'");





This how-to?

Added after 10 minutes:

prevent user to take the banned members repeatedly re-.
As a result of interrogation sort.
1= brpwser + ip + host a high similarity members
2 =browser a low similarity members
3=ip a low similarity members

Added after 3 minutes:

JACK-like
Mode: Detailed Screening (Low)
Note: Results of multi membership does not mean that.
»FREE
Co; Last BR
»kabuswolki
Co; Last BR

[something else]

im confused on what you want :/

I think you want to search members to see if they have same: ip || browser || ip and browser ?

[eynesilli]

thank something else

im confused on what you want :/

I think you want to search members to see if they have same: ip || browser || ip and browser ?

yes but it must be the old browser and ip?