Quote:
Originally Posted by Rogean
[You must be logged in to view images. Log in or Register.]
*sigh*
Alright if I have to...
Code:
mysql> select * from account_ip where ip = "71.48.226.181";
+-------+---------------+-------+---------------------+
| accid | ip | count | lastused |
+-------+---------------+-------+---------------------+
| 18146 | 71.48.226.181 | 5 | 2010-09-13 21:15:24 |
+-------+---------------+-------+---------------------+
1 row in set (0.00 sec)
Code:
mysql> select id, name from account where id = 18146;
+-------+---------+
| id | name |
+-------+---------+
| 18146 | Jaytee2 |
+-------+---------+
1 row in set (0.00 sec)
Lets go a little further...
Code:
mysql> select id, name, charname from account where charname = "Jaytee";
+------+--------+----------+
| id | name | charname |
+------+--------+----------+
| 8080 | Jaytee | Jaytee |
+------+--------+----------+
1 row in set (0.03 sec)
Code:
mysql> select * from account_ip where accid = 8080;
+-------+----------------+-------+---------------------+
| accid | ip | count | lastused |
+-------+----------------+-------+---------------------+
| 8080 | **.***.***.***| * | 2010-01-29 15:48:11 |
| 8080 | **.**.**.*** | ** | 2010-05-01 19:54:24 |
| 8080 | **.**.***.*** | ** | 2010-01-30 20:42:28 |
| 8080 | 75.80.132.232 | 516 | 2010-06-20 23:34:37 |
+-------+----------------+-------+---------------------+
4 rows in set (0.01 sec)
mysql> select * from account_ip where accid = 18146;
+-------+---------------+-------+---------------------+
| accid | ip | count | lastused |
+-------+---------------+-------+---------------------+
| 18146 | ***.**.***.** | ** | 2010-08-14 18:05:21 |
| 18146 | **.**.***.** | ** | 2010-08-06 00:46:06 |
| 18146 | **.**.***.*** | * | 2010-09-13 21:15:24 |
| 18146 | **.**.***.*** | *** | 2010-09-10 15:55:38 |
| 18146 | 75.80.132.232 | 33 | 2010-08-21 00:28:30 |
| 18146 | **.***.**.*** | * | 2010-08-08 22:13:06 |
+-------+---------------+-------+---------------------+
6 rows in set (0.00 sec)
|
Lol, you do know that jaytee2 is Raren right? It was made to get around another IP ban