Find IP

03/29/2018 17:25 dorado1234#1

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.

03/29/2018 17:28 AnimuNazi#2

it should be found in db char panels

03/29/2018 17:35 {Skrillex}#3

Hi,
use this query:

Quote:

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

03/29/2018 19:36 dorado1234#4

i can see when player is online from my database?

03/29/2018 20:03 {Skrillex}#5

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:

Quote:

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

Quote:

USE PS_GameData
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER Proc [dbo].[usp_Read_Chars_Detail2_R]
@[Only registered and activated users can see links. Click Here To Register...]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 = @[Only registered and activated users can see links. Click Here To Register...]D)
SET @GuildID = (SELECT GuildID FROM GuildChars WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]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 = @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]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 = @[Only registered and activated users can see links. Click Here To Register...]D

-- 접속시간 기록
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID @[Only registered and activated users can see links. Click Here To Register...]D
SELECT @UID=UserID FROM CHARS WHERE CharID @[Only registered and activated users can see links. Click Here To Register...]D
UPDATE Chars SET LoginStatus = 0 WHERE (CharID< @[Only registered and activated users can see links. Click Here To Register...]D) AND (UserID=@UID)
--

SET NOCOUNT OFF
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS OFF

Spoiler

Cheers

03/29/2018 21:28 dorado1234#6

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

04/01/2018 22:02 momocruz#7

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>

04/03/2018 22:55 dorado1234#8

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

04/03/2018 23:01 AnimuNazi#9

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.

04/04/2018 04:41 sominus#10

Quote:

Originally Posted by dorado1234

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

Find user last ip

Code:

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

Find accounts currently connected from the same ip

Code:

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.

04/04/2018 05:31 dorado1234#11

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

Quote:
Originally Posted by sominus
Find user last ip
Code:
SELECT UserID as ACCOUNT, UserIp FROM PS_UserData.dbo.Users_Master WHERE UserID = 'put_account_here'
Find accounts currently connected from the same ip
Code:
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??

04/06/2018 00:16 AnimuNazi#12

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

04/08/2018 05:39 dorado1234#13

Quote:

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)

04/08/2018 17:46 sominus#14

"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

04/08/2018 19:57 dorado1234#15

Quote:

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