dutt3684

Hi, Thanks for your response. I have trying finding table and find “ts-redirects.js” in JS folder and no other file found here with naming “wp_ts_redirects” file at any of file or folder, Kindly advise what to do . Below is the coding I found related to details given by you, Kindly make a look is this the fil you are writing about:–

<?php
class Redirects
{
function delete()
{
global $wpdb;

$sql = "TRUNCATE TABLE {$wpdb->prefix}ts_redirects";
$wpdb->query($sql);

} // delete

function edit($title, $section, $new_link, $old_link)
{
global $wpdb;
$sql = $wpdb->prepare(“INSERT INTO {$wpdb->prefix}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 {$wpdb->prefix}ts_redirects WHERE id = %d", 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 {$wpdb->prefix}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->get_results($sql);
if (sizeof($result) == 1) {
  $wpdb->query("RENAME TABLE ts_redirects TO {$wpdb->prefix}ts_redirects");
}

$sql = "SHOW TABLES LIKE '{$wpdb->prefix}ts_redirects'";
$result = $wpdb->get_results($sql);
if (sizeof($result) != 1) {
  $this->createRedirectsTable();
}

} // checkForRedirectsTable

function getAll()
{
global $wpdb;

$this->checkForRedirectsTable();

$sql = "SELECT * FROM {$wpdb->prefix}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 {$wpdb->prefix}ts_redirects WHERE id = %d", array($custom_id));
$wpdb->query($sql);

}
} // remove

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

• This reply was modified 2 years, 2 months ago by dutt3684.
• This reply was modified 2 years, 2 months ago by dutt3684.
• This reply was modified 2 years, 2 months ago by dutt3684.