Update ip when login.

[banktakung]

1.make new column and name it "ipaddress" at ACCOUNT_TBL_DETAIL


2.go to Stored Procedures --> Edit dbo.LOGIN_STR

under

PHP Code:

WHERE account = @iaccount  AND password = @ipassword) BEGIN 


insert

PHP Code:

UPDATE ACCOUNT_TBL_DETAIL SET ipaddress = @i_IPAddress WHERE account = @iaccount 


3.execute it.

done.

[Michi]

I think its not really useful because you can see the IP via website.

PHP Code:

        $strLastIngameLogin = @odbc_fetch_array(@odbc_exec($odbc_connect, '
            SELECT  [remoteIP],
                    [Start_Time]
            FROM  [' . $_CONFIG['db_databases']['log'] . '].[dbo].[LOG_LOGIN_TBL]
            WHERE [account] = \'' . $mixedAccountInformationArray['account'] . '\'
            ORDER BY [Start_Time] DESC
        ')); 


[banktakung]

Originally Posted by Dude';32505330]I think its not really useful because you can see the IP via website.


[php] $strLastIngameLogin = @odbc_fetch_array(@odbc_exec($odbc_connect, '
SELECT [remoteIP],
[Start_Time]
FROM [' . $_CONFIG['db_databases

['log'] . '].[dbo].[LOG_LOGIN_TBL]
WHERE [account] = \'' . $mixedAccountInformationArray['account'] . '\'
ORDER BY [Start_Time] DESC
'));[/php]

In my opinion.it made alot more easy if you developer program to check ip of user

[Michi]

Originally Posted by banktakung

In my opinion.it made alot more easy if you developer program to check ip of user

Sry but your sentence doesn't make sense.
Could you explain me your sentence.

Greets
Dude

[alfredico]

Originally Posted by banktakung

In my opinion.it made alot more easy if you developer program to check ip of user

But it's worse, you can see only the last IP of the user while on log database you can see all IP the user used and much more information.

[banktakung]

example.

i'm develop gameguard. and if i want my program to auto-ban so i need to have user ip to make query update where ip bla bla bla.

[xTwiLightx]

Originally Posted by banktakung

example.

i'm develop gameguard. and if i want my program to auto-ban so i need to have user ip to make query update where ip bla bla bla.

Well, you have the LOG_LOGIN_TBL which logs the ip address of every login - why should we fill SQL Server with data that is saved more than once?

[pakinglalat]

IP address banning is useless if the user has a dynamic IP.

[Drabur]

Originally Posted by pakinglalat

IP address banning is useless if the user has a dynamic IP.

you can use range ips

[banktakung]

Originally Posted by pakinglalat

IP address banning is useless if the user has a dynamic IP.

$db->prepare("UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = blablabla WHERE ipaddress = :s");
$db->BindParam(':s',$ip);

-.-!