msgbartop
用铅笔写日记,记录那最原始的美丽
msgbarbottom

由于大量垃圾评论,本站默认启用评论审核机制

mysql> select * from typecho_comments order by coid desc limit 1;
+-------+------+------------+--------------------------------------------------------------------+----------+---------+--------------------+--------------------------------------------------------------------+-----------------+--------------------------------------------------------------------------+-------------------------------------------------------+---------+----------+--------+
| coid  | cid  | created    | author                                                             | authorId | ownerId | mail               | url                                                                | ip              | agent                                                                    | text                                                  | type    | status   | parent |
+-------+------+------------+--------------------------------------------------------------------+----------+---------+--------------------+--------------------------------------------------------------------+-----------------+--------------------------------------------------------------------------+-------------------------------------------------------+---------+----------+--------+
| 24539 |  470 | 1448358462 | http://auto.insurance.farm.autoinsurance17.com/usaa-car-quote.html |        0 |       3 | [email protected] | http://auto.insurance.farm.autoinsurance17.com/usaa-car-quote.html | 188.143.234.155 | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0 | Wow, that's a really clever way of thinking about it! | comment | approved |  16247 |
+-------+------+------------+--------------------------------------------------------------------+----------+---------+--------------------+--------------------------------------------------------------------+-----------------+--------------------------------------------------------------------------+-------------------------------------------------------+---------+----------+--------+
1 row in set (0.00 sec)

mysql> delete from typecho_comments where ip = "188.143.234.155";
Query OK, 2405 rows affected (0.07 sec)

mysql> select * from typecho_comments order by coid desc limit 1;
+-------+------+------------+--------------+----------+---------+------------------------+-----------------------+--------------+--------------------------------------------------------------------------------------------------------------+-------------------------+---------+----------+--------+
| coid  | cid  | created    | author       | authorId | ownerId | mail                   | url                   | ip           | agent                                                                                                        | text                    | type    | status   | parent |
+-------+------+------------+--------------+----------+---------+------------------------+-----------------------+--------------+--------------------------------------------------------------------------------------------------------------+-------------------------+---------+----------+--------+
| 18126 |  531 | 1442480509 | 雪鹰领主     |        0 |       3 | [email protected] | http://kanshenzuo.com | 182.84.18.18 | Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36 | [围观]。。。。。        | comment | approved |      0 |
+-------+------+------------+--------------+----------+---------+------------------------+-----------------------+--------------+--------------------------------------------------------------------------------------------------------------+-------------------------+---------+----------+--------+
1 row in set (0.00 sec)