对在线销售的AUL许可证的计数方法作了一点改变, 在新的方法中不将IP地址列入考虑, 当不同日期的访问仍计数, 在同一天内五次访问将会计数一次. 但要注意, 不要对页面进行刷新, 重复的访问也会计算次数的.
下面是到今天为止, 10月份免费的请求情况, 同时我们也来计数一下:
USER NAME = free
// count = 1
DAY=20061013 IP=58.212.85.189 CODE=5IFW-1D8F-UB4U-MT6J-K89C
DAY=20061013 IP=66.211.156.98 CODE=OC0Y-USYX-PP5C-YAGD-O6AN
//count = 2
DAY=20061014 IP=200.6.100.10 CODE=AU3I-KV2S-KQKM-30VS-TV46
DAY=20061014 IP=65.113.143.60 CODE=9WBJ-9Q1A-74W1-UK7C-PO88
DAY=20061014 IP=65.113.143.60 CODE=UJ42-URTU-ZEPK-16NZ-2M7L
DAY=20061014 IP=69.140.195.22 CODE=F901-OX9H-RTAN-NMTT-RDON
DAY=20061014 IP=69.140.195.22 CODE=GLHF-22F5-TR7F-0KL1-NQS5
//count = 3
DAY=20061016 IP=124.168.94.122 CODE=8KPD-95HT-7GMJ-JPGI-OFUZ
DAY=20061016 IP=222.69.61.134 CODE=SIWU-P6P8-Y4JC-MOV5-KD52
//count = 4
DAY=20061017 IP=211.96.15.27 CODE=BOG3-FT04-3XMF-FTU6-4YSE
DAY=20061017 IP=212.68.138.137 CODE=SB9J-1XZT-KHNI-RO0T-IR6L
DAY=20061017 IP=58.20.108.23 CODE=FMDO-DU90-49H6-V1W9-DRUI
DAY=20061017 IP=61.178.48.199 CODE=EBIE-WHZT-5WCF-AB44-QDW0
DAY=20061017 IP=61.178.48.199 CODE=ZVKS-AQKH-PV6Y-BTK6-KAUE
//count = 5
DAY=20061017 IP=69.71.188.90 CODE=PTPP-MHWE-AN20-LSUY-0R2K
//count = 6
DAY=20061018 IP=218.244.187.201 CODE=XCX1-TAFL-2CIP-02LX-HCOK
DAY=20061018 IP=222.91.162.118 CODE=IZJP-DCO2-GWF7-X9DT-14D1
DAY=20061018 IP=222.91.162.118 CODE=YZ4G-TV7D-MRKC-F42B-WFVX
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
//count = 7
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
DAY=20061018 IP=60.63.172.202 CODE=EIEF-F8SL-WY7K-PXIO-LT47
USED = 7, TOTAL=20
现在的价格(8000元一次)真是很优惠的, 你要请人来恢复或临时联系我的话, 价格至少在1.5倍以上.
留言 (2)
重复刷新已经不列入计算了.
Posted by anysql | Oct 19, 2006 9:01 PM
用SQL的方法来计算就是:
-- TABLE AUL_REQUEST (DAY,IP,CODE)
-- PK (DAY,IP,CODE)
SELECT SUM(CEILING(DAYCNT)/5)
FROM
(SELECT DAY, COUNT(*) DAYCNT FROM AUL_REQUEST)
Posted by anysql | Oct 19, 2006 9:13 PM