<?php
class Redirects
{
  function delete()
  {

    global $wpdb;
    $sql = "DELETE FROM ts_redirects";
    $wpdb->query($sql);
  } // delete


  function edit($title, $section, $new_link, $old_link)
  {

    global $wpdb;
    $sql = $wpdb->prepare("INSERT INTO ts_redirects (title, section, new_link, old_link) VALUES ('%s', '%s', '%s', '%s')", array($title, $section, $new_link, $old_link));
    $wpdb->query($sql);
  } // edit


  function getFields($id)
  {

    global $wpdb;
    $sql = $wpdb->prepare("SELECT * FROM ts_redirects WHERE id = '%s'", array($id));
    $result = $wpdb->query($sql);
    if ($result !== 0) {
      $fields = array();
      foreach ($wpdb->get_results($sql) as $row) {
        $fields['title'] = $row->title;
        $fields['section'] = $row->section;
        $fields['new_link'] = $row->new_link;
        $fields['old_link'] = $row->old_link;
      }

      return $fields;
    } else {

      return false;
    }
  } // getFields


  function createRedirectsTable()
  {
    global $wpdb;
    $sql = "CREATE TABLE ts_redirects (id BIGINT(20) PRIMARY KEY AUTO_INCREMENT,title TEXT,section TEXT, new_link TEXT, old_link TEXT)";
    $wpdb->query($sql);
  } // createRedirectsTable


  function checkForRedirectsTable()
  {
    global $wpdb;
    $sql = "SHOW TABLES LIKE 'ts_redirects'";
    $result = $wpdb->query($sql);
    if ($result != 1) {
      $this->createRedirectsTable();
    }
  } // checkForRedirectsTable


  function getAll()
  {
    global $wpdb;
    $this->checkForRedirectsTable();

    $sql = "SELECT * FROM ts_redirects ORDER by id ASC";
    $result = $wpdb->query($sql);
    if ($result !== 0) {

      $id_arr = array();
      foreach ($wpdb->get_results($sql) as $row) {
        $id_arr[] = $row->id;
      }

      return $id_arr;
    } else {

      return false;
    }
  } // getAll

  function remove($custom_id)
  {
    global $wpdb;
    $sql = $wpdb->prepare("DELETE FROM ts_redirects WHERE id = '%s'", array($custom_id));
    $wpdb->query($sql);
  }
} // remove

$redirectsplugin = new Redirects();
$GLOBALS['redirectsplugins'] = $redirectsplugin;