bootstrap.php 604 B

123456789101112131415161718192021
  1. <?php
  2. $redis = new Redis();
  3. $redis->connect('127.0.0.1', 6379);
  4. $mysql_user = '';
  5. $mysql_pass = '';
  6. $db = new PDO('mysql:host=127.0.0.1;dbname=certalertbot;charset=utf8mb4', $mysql_user, $mysql_pass);
  7. $stmt = $db->prepare("SELECT id, chatid, type, value FROM rules");
  8. $stmt->execute();
  9. $rules = $stmt->fetchAll(PDO::FETCH_ASSOC);
  10. foreach ($rules as $rule) {
  11. $toadd = array();
  12. $id = $rule["id"];
  13. $toadd["id"] = $id;
  14. $toadd["value"] = array("t" => $rule["type"], "v" => $rule["value"], "c" => $rule["chatid"]);
  15. $toadd = json_encode($toadd, JSON_NUMERIC_CHECK);
  16. $redis->rPush('toadd', $toadd);
  17. }