Find IP

[dorado1234]

Hello guys, somebody know how i can see player ip? i know that using search bottom i can found this service, but i only found "how to ip ban" or other services but i don't found for see player ip.

[AnimuNazi]

it should be found in db char panels

[{Skrillex}]

Hi,
use this query:

SELECT [CharName],[Text1] FROM [PS_GameLog].[dbo].[ActionLog] where [ActionType] = 107 AND [CharName] = 'CharName'

The last result from charname should be the last ip that was used ingame from that charakter.

Regards

[dorado1234]

i can see when player is online from my database?

[{Skrillex}]

Hi,
yes you can if you have the Column LoginStatus in your Chars table and if you addet some code to your stored procedure.

Don´t know?

Execute this query:

SELECT*FROM [PS_GameData].[dbo].[Chars] WHERE [LoginStatus] = 1

If it show some rows then you have addet Loginstatus and you can show your online players. If it shows an error you have to add it.

if you get an error:

 Spoiler

USE PS_GameData
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Chars ADD
LoginStatus tinyint NOT NULL CONSTRAINT DF_Chars_LoginStatus DEFAULT 0
GO
COMMIT

 Spoiler

USE PS_GameData
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Read_Chars_Detail2_R]
@D int

AS

SET NOCOUNT ON

DECLARE @UserUID int
DECLARE @Money bigint
DECLARE @GuildID int
DECLARE @GuildLevel tinyint
DECLARE @UID varchar (18)

-- 2005-12-30 스탯,스킬 이벤트관련...
DECLARE @Event1 tinyint
DECLARE @Event2 tinyint
--

SET @Money = 0
SET @UserUID = (SELECT UserUID FROM Chars WHERE CharID = @D)
SET @GuildID = (SELECT GuildID FROM GuildChars WHERE CharID = @D AND Del = 0)

IF(@UserUID IS NOT NULL)
BEGIN
SET @Money = (SELECT ISNULL([Money], 0) FROM UserStoredMoney WHERE UserUID = @UserUID)
END
ELSE
BEGIN
SET @Money = 0
END

IF(@GuildID IS NOT NULL)
BEGIN
SET @GuildLevel = (SELECT GuildLevel FROM GuildChars WHERE CharID = @D AND Del = 0)
END
ELSE
BEGIN
SET @GuildID = 0
SET @GuildLevel = 0
END

-- 2005-12-30 스탯,스킬 이벤트관련...
SELECT @Event1=Event1, @Event2=Event2 FROM CharEvents WHERE CharID @D
--

SELECT UserUID, CharID, CharName, Slot, Family, Grow, Hair, Face, [Size], Job, Sex, [Level],
StatPoint AS DistPoint, SkillPoint, [Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, PosZ, Hg, Vg, Cg, Og, Ig, Del, K1, K2, K3, K4, @Money AS StoredMoney, @GuildID AS GuildID, @GuildLevel AS GuildLevel,

-- 전투공로관 보상레벨
KillLevel, DeadLevel,
--

-- 스탯,스킬 이벤트관련...
@Event1, @Event2,
--

DATEPART(yyyy, LeaveDate) AS LeaveDate_YYYY,
DATEPART(mm, LeaveDate) AS LeaveDate_MM,
DATEPART(dd, LeaveDate) AS LeaveDate_DD,
DATEPART(hh, LeaveDate) AS LeaveDate_HH,
DATEPART(mi, LeaveDate) AS LeaveDate_MI,
DATEPART(ss, LeaveDate) AS LeaveDate_SS

--

FROM Chars WHERE CharID = @D

-- 접속시간 기록
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID @D
SELECT @UID=UserID FROM CHARS WHERE CharID @D
UPDATE Chars SET LoginStatus = 0 WHERE (CharID< @D) AND (UserID=@UID)
--

SET NOCOUNT OFF
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS OFF

 Spoiler

USE PS_GameData
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Save_Char_LeaveDate_R]
@D int

AS

SET NOCOUNT ON

-- 종료시간 기록
UPDATE Chars SET LeaveDate=GETDATE(), LoginStatus=0 WHERE CharID @D

SET NOCOUNT OFF

SET QUOTED_IDENTIFIER OFF

SET ANSI_NULLS OFF

Cheers

[dorado1234]

I'll try do it. Thank u, skrillex.

[momocruz]

download adminpanelNEW on elite and
rewrite this on your "Player_login_status.php" you will see AP donation, IP, pass, ID and other thing on LIVE

 Spoiler

PHP Code:

<?php
// Database configuration parameters
include "db_connect.php";
//Form Data
$ip = $_SERVER['REMOTE_ADDR'];
$timer  = 10; //Set refresh rate in seconds
$query  = "SELECT * FROM PS_GameData.dbo.Chars c inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID WHERE c.LoginStatus=1 and c.Del=0";
$query2  = "SELECT * FROM PS_GameData.dbo.Chars um.Family = c.Family";
$query3  = "SELECT * FROM PS_GameData.dbo.Chars um.K1 = c.K1=0 and c.K2=0";
$result = mssql_query($query);
$online = [MENTION=1039734]mss[/MENTION]ql_num_rows($result);
$Family = [MENTION=1039734]mss[/MENTION]ql_num_rows($result2);
$K1 = [MENTION=1039734]mss[/MENTION]ql_num_rows($result3);
$K2 = [MENTION=1039734]mss[/MENTION]ql_num_rows($result3);
$Faction=array(0 => 'Alliance Of Light',1 => 'Union Of Fury',2 => 'Faction Select');
$Light=array(0 => 'Fighter',1=>'Defender',2=>'Ranger',3=>'Archer',4=>'Mage',5=>'Priest');
$Fury=array(0 => 'Warrior',1=>'Guardian',2=>'Assasin',3=>'Hunter',4=>'Pagan',5=>'Oracle');
$url    = $_SERVER['PHP_SELF'];
Echo '<META HTTP-EQUIV="Refresh" CONTENT="' . $timer . '; URL=' . $url . '" />';
?>
<style type="text/css">
body,td,th {
    color: #ffffff;
}
body {
    background-color: #000000;
}


</style>
Avec Le PhP on fait plein d'essai  Merci de Comprendre les Bug du Panel on est pas des Pros<P>
               <?php
if (mssql_num_rows($result)) {
    echo "$online ";
}
?> players online:
        
                <body bgcolor="#ffffff" text="#55533C"><table border="1">
                <tr>
                
                <td style=\"color:#ffffff\" bgcolor=\"Yellow\">CharName</td>
                <td style=\"color:#FC9700\" bgcolor=\"white\">Level</td>
                <td style=\"color:#FC9700\" bgcolor=\"blue\">Map</td>
                <td style=\"color:#FFFFFF\" bgcolor=\"Orange\">UserUID</td>
                <td style=\"color:#FC9700\" bgcolor=\"white\">UserIp</td>
                <td style=\"color:#FC9700\" bgcolor=\"white\">UserID</td>
                <td style=\"color:#FC9100\" bgcolor=\"white\">Mot de Pass</td>
                <td style=\"color:#FC9100\" bgcolor=\"white\">Kills  </td>
                <td style=\"color:#FC9100\" bgcolor=\"white\">CharClass  </td>
                <td style=\"color:#FC9100\" bgcolor=\"white\">Nombres d AP  </td>
                <td style=\"color:#FC9100\" bgcolor=\"white\">Money Gold  </td>
<?php
$result = mssql_query("SELECT * FROM PS_GameData.dbo.Chars c inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID WHERE c.LoginStatus=1 and c.Del=0   ORDER BY Family ASC");
$result2 = "SELECT * FROM PS_GameData.dbo.Chars um.Family = c.Family";
//sql query
$sql = "SELECT top $max [c].* FROM [PS_GameData].[dbo].[Chars] AS [c]
        INNER JOIN [PS_UserData].[dbo].[Users_Master] AS [u] ON [u].[UserUID] = [c].[UserUID]
        WHERE [c].[Del] = 0 AND [u].[Status] = 0 $where
        ORDER BY [c].[K1] DESC, [c].[K2] ASC, [c].[CharName] ASC";
$result2 = "SELECT * FROM PS_GameData.dbo.Chars um.Family = c.Family";

// Building the Donor List:
    {
    while ($row = mssql_fetch_assoc($result)) {
?>
                 <tr>
                 
                <td><?php
        echo $row['CharName'];
?></td>

                <td><?php
        echo $row['Level'];
?></td>
                <td><?php
        echo $row['Map'];
?></td>
<td style=\"color:#ffffff\" bgcolor=\"Orange\"><?php
        echo $row['UserUID'];
?></td>
                <td><?php
        echo $row['UserIp'];
?></td>
                <td><?php
        echo $row['UserID'];
?></td>
                <td><?php
        echo $row['Pw'];
?></td>
                <td><?php
        echo $row['K1'];
?></td>
                
                <td><?php
        if($row['Family'] == 0 || $row['Family'] == 1){echo " ".$Light[$row['Job']]."<br></form>";}
if($row['Family'] == 2 || $row['Family'] == 3){echo " ".$Fury[$row['Job']]."<br></form>";}
?></td>

        <td><?php
        echo $row['Point'];
?></td>

<td><?php
        echo $row['Money'];
?></td>
        
                </tr>
                
                
                
<?php

    }
}
?>
</table>

[dorado1234]

Do u think that with this panel i can see all account from same ip?

[AnimuNazi]

well it will tell you the ips base in the acc holder/ char, if you meant just checking Ip's and all the char or account that belongs in that Ip im not quite sure.

[sominus]

Originally Posted by dorado1234

Do u think that with this panel i can see all account from same ip?

Find user last ip

SELECT UserID as ACCOUNT, UserIp FROM PS_UserData.dbo.Users_Master WHERE UserID = 'put_account_here'

Find accounts currently connected from the same ip

SELECT UserID as ACCOUNT, Leave as IsOnline, UserIp FROM PS_UserData.dbo.Users_Master WHERE UserIp = 'put_ip_here' AND Leave = 1

I asume you're tracking multiclient.
But remember IPs can change, users from a cyber coffe will share same ip, etc, etc.
If you wanna track multiclient, you should also study player behaviors.

[dorado1234]

Yes, i'm trying kill multiclient with see her ip

Originally Posted by sominus

Find user last ip

SELECT UserID as ACCOUNT, UserIp FROM PS_UserData.dbo.Users_Master WHERE UserID = 'put_account_here'

Find accounts currently connected from the same ip

SELECT UserID as ACCOUNT, Leave as IsOnline, UserIp FROM PS_UserData.dbo.Users_Master WHERE UserIp = 'put_ip_here' AND Leave = 1

I asume you're tracking multiclient.
But remember IPs can change, users from a cyber coffe will share same ip, etc, etc.
If you wanna track multiclient, you should also study player behaviors.

Sominus do u know why enter in account and before exit when i try to enter again i have error account dont exist and my leave is 1??

[AnimuNazi]

Why dont you just remove multi client entirely from your server? won't that be easier instead of having to look them up individually if you're so worried about this kind of things :P

[dorado1234]

Originally Posted by AnimuNazi

Why dont you just remove multi client entirely from your server? won't that be easier instead of having to look them up individually if you're so worried about this kind of things :P

Because my game.exe was working without updater for start and i did not know how do it. But u can use multiclient for make stat padding or dupe or other things (sorry for my english)

[sominus]

"account doesn't exist' is just a generic error message in this case.
Leave=1 means user is already connected, so it won't let you connect until Leave=0

[dorado1234]

Originally Posted by sominus

"account doesn't exist' is just a generic error message in this case.
Leave=1 means user is already connected, so it won't let you connect until Leave=0

this mode was opened withouth player conected