Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO analytics (TYPE,path)
- SELECT %d,'%s' FROM analytics WHERE NOT EXISTS (
- SELECT %d AS tmp FROM analytics WHERE
- (MONTH(ts) = MONTH(NOW()) AND YEAR(ts) = YEAR(NOW()) AND TYPE=%d AND path='%s')
- ) LIMIT 1;
- UPDATE analytics SET counter = counter + 1 WHERE (MONTH(ts) = MONTH(NOW()) AND YEAR(ts) = YEAR(NOW()) AND path='%s' AND TYPE=%d);
Advertisement
Add Comment
Please, Sign In to add comment