Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # забор сайта для постинга
- public function multi_get_site() {
- $interval1='"'.rand(0, 1).' '.rand(0, 24).':'.rand(0, 60).'"';
- $interval2='"'.rand(1, 2).' '.rand(0, 24).':'.rand(0, 60).'"';
- $sql = "
- SELECT
- `" . TB_SITES . "`.`id`,
- `" . TB_SITES . "`.`theme_id`,
- `" . TB_SITES . "`.`domain`,
- `" . TB_SITES . "`.`login`,
- `" . TB_SITES . "`.`pass`,
- `" . TB_SITES . "`.`platform`,
- `" . TB_SITES . "`.`onoff`,
- `" . TB_SITES . "`.`ip`
- FROM
- `" . TB_SITES . "`
- WHERE
- `" . TB_SITES . "`.`domain` IS NOT NULL
- AND
- `" . TB_SITES . "`.`login` IS NOT NULL
- AND
- `" . TB_SITES . "`.`pass` IS NOT NULL
- AND
- `" . TB_SITES . "`.`onoff` NOT IN ('0', '2') -- не должен быть выключен, не должен ожидать активации
- AND
- `" . TB_SITES . "`.`lock_posting` IS NULL -- должен быть разлочен
- AND
- (
- NOW()>(TIMESTAMP(`" . TB_SITES . "`.`date`)+INTERVAL ".$interval1." DAY_MINUTE)
- OR
- NOW()>(TIMESTAMP(`" . TB_SITES . "`.`date`)+INTERVAL ".$interval2." DAY_MINUTE)
- )
- ORDER BY RAND()
- LIMIT 1";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement