Is it possible to retrieve an accounts IP via rA scripts?

[megablox]

What I mean is can you somehow read a players IP by having him/her interact with an NPC?

[Euphy]

query_sql("SELECT `last_ip` FROM `login` WHERE `account_id` = "+getcharid(3)+";",.@IP$);
dispbottom .@IP$;

[herenow]

query_sql("SELECT `last_ip` FROM `login` WHERE `account_id` = "+getcharid(3)+" LIMIT 1;",.@IP$);
dispbottom .@IP$;

'-'

[Mystery]

query_sql("SELECT `last_ip` FROM `login` WHERE `account_id` = "+getcharid(3)+" LIMIT 1;",.@IP$);
dispbottom .@IP$;

'-'

?.. You just easily add that to an existing script or make an entire new script revolving around that little code blurb o_O

Edited July 18, 2012 by Mysterious

[herenow]

I supose that by account_id being primary key, mysql adds a limit 1 by default '-'.

But querys that only expects 1 result and dont have a limit 1, gives me a itch lol.

[Euphy]

All results from SQL queries are stored in a variable array, starting at the 0th element (as you would expect). There's nothing fancy about it. O:

[Mystery]

You can increase the Limit by changing 1 to whatever. But really, with that snippet, you're just getting THAT character's IP.. and knowing 1 char, he has only 1 IP attached to it, not multiple

[megablox]

I see, thanks!