[SQL Query Request]IP Selection

[Vasil 71]

Hello,right now i am creating some new system that works with Lua-SQL,i am really not good in SQL or making my own SQL Queries so please can anyone reply in this topic an SQL Query that Select an Account IP?

Thanks in Advance

[Guest]

SELECT column FROM table WHERE condition;

...

SELECT last_ip FROM GameDB.dbo.account WHERE act_name = "Vasil";

[V3ct0r 2,117]

Get IP address by character name:

SELECT a.last_ip FROM GameDB.dbo.account AS a LEFT join GameDB.dbo.character AS c ON (a.act_id = c.act_id) WHERE c.cha_name = 'Vector'

or

SELECT last_ip FROM GameDB.dbo.account WHERE act_id IN (SELECT act_id FROM GameDB.dbo.character WHERE cha_name = 'Vector')

 

similar by character id, but instead of "WHERE cha_name = '...'" use "WHERE cha_id = ID"