AffCommandments
DEBUG
SELECT * FROM tblVisitsLinks WHERE `ip` = '81.155.26.72' AND `linkid` = '38984' AND
datetime <= '1177015349' AND datetime >= '1176928949'
counthits =
findAd: SELECT `id` FROM tblAds WHERE `uid` != '19374' AND `hitsleft` > '0'
ORDER BY rand() LIMIT 1
Visits Ads: SELECT * FROM tblVisitsAds WHERE `ip` = '81.155.26.72' AND `id` = '3278'
deductAdHit = 1
Update ads sql = UPDATE `tblAds` SET `hits`=`hits`+1, `hitsleft`=`hitsleft`-1 WHERE `id`='3278'
Insert ads visit = INSERT INTO `tblVisitsAds` (`key`,`uid`, `ip`, `datetime`)
VALUES('','3278', '81.155.26.72','1177015349') |
|