专门给站长用的插件-识别马甲

Originally posted by 克隆熊猫 at 2005-4-27 09:23


没错，比较消耗资源。在那么大的数据库里查找人们的相似关系，当然耗资源。

呵呵~不可能天天每时每记刻都在查吧~问题不大！

哈哈～～！已经装了！

Discuz! info: MySQL Query Error

User: admin
Time: 2005-4-27 8:19pm
Script: /index/getsimilar.php

SQL: select author from cdb_posts where useip in (Array'202.105.38.104','202.105.38.119','202.105.38.138','202.105.38.139','202.105.38.160','202.105.38.171','202.105.38.18','202.105.38.189','202.105.38.199','202.105.38.215','202.105.38.243','202.105.38.245','202.105.38.43','202.105.38.50','202.105.38.54','202.105.38.84','202.105.42.159','202.105.42.183','202.105.42.205','202.105.42.21','202.105.42.229','202.105.42.26','202.105.42.37','202.105.42.45','202.105.42.48','202.105.42.49','218.19.1.120','218.19.157.15','218.19.157.153','218.19.157.156','218.19.157.184','218.19.157.190','218.19.157.197','218.19.157.47','218.19.157.48','218.19.157.79','218.19.157.9','218.19.160.122','218.19.160.54','218.19.3.100','218.19.3.23','219.135.212.185','219.135.212.196','219.136.104.176','219.136.104.219','219.136.104.249','219.136.104.41','219.136.105.129','219.136.105.144','219.136.105.185','219.136.105.244','219.136.13.12','219.136.13.81','219.136.130.120','219.136.130.144','219.136.130.153','219.136.130.180','219.136.130.223','219.136.130.243','219.136.130.58','219.136.131.161','219.136.131.204','219.136.131.251','219.136.14.50','219.136.164.117','219.136.164.122','219.136.164.183','219.136.164.193','219.136.164.199','219.136.164.201','219.136.164.205','219.136.164.223','219.136.164.252','219.136.164.27','219.136.164.67','219.136.164.85','219.136.164.87','219.136.165.11','219.136.165.111','219.136.165.148','219.136.165.153','219.136.165.171','219.136.165.201','219.136.165.43','219.136.165.46','219.136.165.49','219.136.165.52','219.136.165.88','219.136.165.95','219.136.165.97','219.136.166.127','219.136.166.138','219.136.166.139','219.136.166.145','219.136.166.166','219.136.166.216','219.136.166.223','219.136.166.230','219.136.166.248','219.136.166.5','219.136.166.60','219.136.166.76','219.136.166.92','219.136.167.145','219.136.167.152','219.136.167.189','219.136.167.197','219.136.167.202','219.136.167.205','219.136.167.214','219.136.167.233','219.136.167.24','219.136.167.52','219.136.167.54','219.136.188.124','219.136.188.128','219.136.188.13','219.136.188.145','219.136.188.163','219.136.188.171','219.136.188.215','219.136.188.25','219.136.188.251','219.136.188.35','219.136.188.63','219.136.188.73','219.136.188.74','219.136.188.90','219.136.188.91','219.136.188.96','219.136.189.10','219.136.189.102','219.136.189.109','219.136.189.114','219.136.189.13','219.136.189.149','219.136.189.234','219.136.189.238','219.136.189.64','219.136.189.92','219.136.190.100','219.136.190.108','219.136.190.110','219.136.190.122','219.136.190.193','219.136.190.2','219.136.190.56','219.136.190.79','219.136.210.148','219.136.211.143','219.136.211.185','219.136.212.5','219.136.212.98','219.136.213.207','219.136.213.210','219.137.107.25','219.137.136.19','219.137.137.62','219.137.140.177','219.137.201.192','219.137.202.104','219.137.202.176','219.137.202.194','219.137.202.244','219.137.202.60','219.137.202.84','219.137.203.103','219.137.203.180','219.137.203.189','219.137.203.230','219.137.203.36','219.137.203.66','219.137.203.84','219.137.204.143','219.137.204.162','219.137.204.94','219.137.39.40','221.216.203.79','59.42.101.1','59.42.101.147','59.42.2.106','61.144.104.108','61.144.104.123','61.144.104.160','61.144.104.204','61.144.104.22','61.144.104.220','61.144.104.243','61.144.104.81','61.144.105.123','61.144.105.131','61.144.105.134','61.144.105.136','61.144.105.148','61.144.105.176','61.144.105.181','61.144.105.191','61.144.105.249','61.144.105.39','61.144.105.43','61.144.105.52','61.144.105.69','61.144.105.87','61.144.105.92','61.144.106.103','61.144.106.147','61.144.106.156','61.144.106.178','61.144.106.207','61.144.106.250','61.144.106.78','61.144.106.80','61.144.107.134','61.144.107.175','61.144.107.195','61.144.107.199','61.144.107.206','61.144.107.208','61.144.107.212','61.144.107.225','61.144.107.60','61.144.107.65','61.144.107.66','61.144.107.77','61.144.107.83','61.144.20.118','61.144.33.180','61.144.96.10','61.144.96.109','61.144.96.117','61.144.96.12','61.144.96.140','61.144.96.153','61.144.96.173','61.144.96.181','61.144.96.193','61.144.96.209','61.144.96.213','61.144.96.238','61.144.96.239','61.144.96.50','61.144.97.100','61.144.97.110','61.144.97.123','61.144.97.135','61.144.97.247','61.144.97.248','61.144.97.84','61.144.97.85','61.149.25.71','61.49.138.123','127.0.0.1') group by author
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''202.105.38.104','202.105.38.119','202.105.38.138','202.105.38.
Errno.: 1064

Similar error report has beed dispatched to administrator before.


请问这个错误提示怎么解决？ 我是 2.2版本的。

2.5sp1 应该没问题吧

是不是把文件放在根目录下　然后用IE地址栏访问？

非常好用，我已经查到一个马甲了，因为我的会员比较少，所以很好查……

好东西好东西好东西~~~~~~~~~~哟

不错,好用

不怎么样,只是针对同一IP段查询的吧?

全是猜的了...

作者很厲害，以後我們找馬甲就不用猜了。

另外可否也加入用電郵作查詢呢？
現時檢查的ip，是註冊ip還是平時上論壇用的ip？可否兩個也檢查呀？

呵呵~有意思~