Total ' . $this->conn->affected_rows . ' Redirect row(s) deleted.
'; if ($this->conn->affected_rows > 0) { $message .= $this->generateDomainRedirects($domain, $domain_name); } echo json_encode(["status" => $res, "message" => $message]); } else { echo json_encode(["status" => false, "message" => "Error: " . mysqli_error($this->conn) . '
']); } } function insertByQuery($query, $domain, $domain_name) { $res = mysqli_query($this->conn, $query); if ($res && $this->conn->affected_rows > 0) { $message = 'Redirect added.
'; if ($this->conn->affected_rows > 0) { $message .= $this->generateDomainRedirects($domain, $domain_name); } } else { $res = false; $message = "Error: " . mysqli_error($this->conn) . '
'; } echo json_encode(["status" => $res, "message" => $message]); } function updateByQuery($query, $domain, $domain_name, $old_domain) { $res = mysqli_query($this->conn, $query); if ($res) { $res = 'success'; $message = 'Total ' . $this->conn->affected_rows . ' Redirect row(s) updated.
'; if ($this->conn->affected_rows > 0) { if ($old_domain == '1' || $domain == '1') { $message .= $this->generateAllDomainRedirects(); } elseif ($old_domain != $domain) { $message .= $this->updateDomainRedirects($domain, $old_domain); } else { $message .= $this->generateSingleDomainRedirects($domain, $domain_name); } } } else { $res = false; $message = "Error: " . mysqli_error($this->conn) . '
'; } echo json_encode(["status" => $res, "message" => $message]); } function updateDomainRedirects($new_domain, $old_domain) { $query = "SELECT * FROM domains where id IN ($new_domain,$old_domain)"; $result = mysqli_query($this->conn, $query); $status = ''; if ($result->num_rows > 0) { while ($domain = mysqli_fetch_assoc($result)) { $status .= $this->generateSingleDomainRedirects($domain['id'], $domain['name']); } } else { $status = 'Domain not found.
'; } return $status; } function generateDomainRedirects($domain, $domain_name) { $status = ''; if ($domain == '1') { $status = $this->generateAllDomainRedirects(); } else { $status = $this->generateSingleDomainRedirects($domain, $domain_name); } return $status; } function generateAllDomainRedirects() { if (!is_dir($this->targetpath)) { mkdir($this->targetpath, 0777, true); } else { $files = glob($this->targetpath . '/*'); foreach ($files as $file) { if (is_file($file)) { unlink($file); } } } $query = "SELECT * FROM domains WHERE id!='1'"; $result = mysqli_query($this->conn, $query); $status = ''; if ($result->num_rows > 0) { while ($domain = mysqli_fetch_assoc($result)) { $status .= $this->generateSingleDomainRedirects($domain['id'], $domain['name']); } } else { $status = 'Domain not found.
'; } return $status; } function generateSingleDomainRedirects($domain, $domain_name) { if (!is_dir($this->targetpath)) { mkdir($this->targetpath, 0777, true); } $query = "SELECT DISTINCT d.name AS domain_name, r.link, (CASE WHEN (mode = 'off') THEN offlink ELSE onlink END) AS redirectlink FROM redirects r INNER JOIN domains d ON r.did = d.id WHERE r.did = '$domain' LIMIT 0, 2500000;"; $result = mysqli_query($this->conn, $query); $text = PHP_EOL; $status = ''; if ($result->num_rows > 0) { while ($row = mysqli_fetch_assoc($result)) { // remove leading/trailing slashes $link = trim($row['link'], '/'); $redirect_link = trim($row['redirectlink']); // generate RewriteRule $text .= "RewriteRule ^" . $link . "$ " . $redirect_link . " [R=302,L]" . PHP_EOL; } } try { $ht_file_path = "$this->targetpath$domain_name/.htaccess"; if (file_exists($ht_file_path)) { $htaccess = file_get_contents($ht_file_path); $needle_start = '#start_custom_redirects'; $needle_end = '#end_custom_redirects'; if (str_contains($htaccess, $needle_start) && str_contains($htaccess, $needle_end)) { $new_redirects = $this->replace_between($htaccess, $needle_start, $needle_end, $text); file_put_contents($ht_file_path, $new_redirects); $status = "Redirects added in $ht_file_path
"; } else { $status = "Needle not found in $ht_file_path
"; } } else { $status = "File $ht_file_path not found
"; } } catch (\Throwable $th) { $status = $th->getMessage(); } return $status; } function replace_between($str, $needle_start, $needle_end, $replacement) { if (str_contains($str, $needle_start) && str_contains($str, $needle_end)) { $pos = strpos($str, $needle_start); $start = $pos === false ? 0 : $pos + strlen($needle_start); $pos = strpos($str, $needle_end, $start); $end = $pos === false ? strlen($str) : $pos; return substr_replace($str, $replacement, $start, $end - $start); } else { return $str; } } }