Track IP

[DJFUNK]

I need the NPC script for track IP for my player as GM tool in game (include the features that player's same IP,etc...)

so I can use it in game nor in gameCP

Edited December 14, 2012 by DJFUNK

[AnnieRuru]

-    script    flsdfjlskdfj    -1,{
OnInit:
   bindatcmd "whoip", strnpcinfo(0)+"::Onaaa",60,99;
   end;
Onaaa:
   while ( getusers(1) > .@count ) {
       .@nb = query_sql("select name, last_ip from `char` left join login on `char`.account_id = login.account_id where online = 1 order by last_ip limit 128 offset "+ .@count, .@name$, .@ip$ );
       .@i = 0;
       while ( .@i < .@nb ) {
           message strcharinfo(0), ( .@count + .@i +1 )+". "+ .@name$ +" -> "+ .@ip$;
           .@i++;
       }
       .@count += 128;
   }
   freeloop 0;
}

hmm .. ?

this is just listing all players name and their IP

otherwise, please specify more in detail of your request

[DJFUNK]

how can I use that?

hhm... I think the NPC that I can input the ID or Char name, and track their IP.

just like this gmassistant.txt

it doesn't work for rAthena.. /spin

how I can use it

[AnnieRuru]

[sql]: DB error - Unknown column 'level' in 'field list'
[Debug]: at d:\eathena\rathena sql 16819\src\map\script.c:14506 - select `sex`,`
email`,`level`,`unban_time`,`logincount`,`lastlogin`,`last_ip` from `login` wher
e `account_id` = '2000000'
[Debug]: Source (NPC): GM Assistant at prontera (156,181)

that's because rathena has changed `level` field into `group_id` field

run a replace all

find

`level'

replace all with

`group_id`

and this script will works in rathena

[DJFUNK]

DONE... it's work..

only that changes? to use in rAthena

[AnnieRuru]

only that changes? to use in rAthena

as far as I can tell, yeah that's it

though sometimes I can be wrong too, because everyone might make mistakes in their scripts

so if you have spotted another bug that you couldn't able to solve it on your own

always welcome to make a discussion here and we can discuss how to solve your problem together