Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.08 KB | None | 0 0
  1. # забор сайта для постинга
  2.    public function multi_get_site() {
  3.             $interval1='"'.rand(0, 1).' '.rand(0, 24).':'.rand(0, 60).'"';
  4.             $interval2='"'.rand(1, 2).' '.rand(0, 24).':'.rand(0, 60).'"';
  5.  
  6.         $sql = "
  7. SELECT
  8. `" . TB_SITES . "`.`id`,
  9. `" . TB_SITES . "`.`theme_id`,
  10. `" . TB_SITES . "`.`domain`,
  11. `" . TB_SITES . "`.`login`,
  12. `" . TB_SITES . "`.`pass`,
  13. `" . TB_SITES . "`.`platform`,
  14. `" . TB_SITES . "`.`onoff`,
  15. `" . TB_SITES . "`.`ip`
  16. FROM
  17. `" . TB_SITES . "`
  18. WHERE
  19. `" . TB_SITES . "`.`domain` IS NOT NULL
  20. AND
  21. `" . TB_SITES . "`.`login` IS NOT NULL
  22. AND
  23. `" . TB_SITES . "`.`pass` IS NOT NULL
  24. AND
  25. `" . TB_SITES . "`.`onoff` NOT IN ('0', '2') -- не должен быть выключен, не должен ожидать активации
  26. AND
  27. `" . TB_SITES . "`.`lock_posting` IS NULL -- должен быть разлочен
  28. AND
  29. (
  30. NOW()>(TIMESTAMP(`" . TB_SITES . "`.`date`)+INTERVAL ".$interval1." DAY_MINUTE)
  31. OR
  32. NOW()>(TIMESTAMP(`" . TB_SITES . "`.`date`)+INTERVAL ".$interval2." DAY_MINUTE)
  33. )
  34. ORDER BY RAND()
  35. LIMIT 1";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement