public function get_mapped_domain($blog_id)
{
$domain_mapping_table_name = $this->add_prefix('domain_mapping');
try {
$data = $this->dbconnection->query("SELECT * FROM `{$domain_mapping_table_name}` WHERE `blog_id`={$blog_id}");
} catch (PDOException $e) {
script_die("Unable to get '{$this->name}' domain mapping data.", "SELECT * FROM `{$domain_mapping_table_name}` WHERE `blog_id`={$blog_id}", $e->getMessage());
}
if ($data->rowCount() > 0) {
$row = $data->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
return $row['domain'];
}
return NULL;
}
public function get_table_row_list($table_name, $row_count, $limit = 1000)
{
$offset = $row_count * $limit;
try {
$data = $this->dbconnection->query("SELECT * FROM `{$table_name}` LIMIT {$limit} OFFSET {$offset}");
} catch (PDOException $e) {
script_die("Unable to get '{$this->name}' '{$table_name}' data.", "SELECT * FROM `{$table_name}` LIMIT {$limit} OFFSET {$offset}", $e->getMessage());
}
if ($data->rowCount() > 0) {
return $data->fetchAll(PDO::FETCH_ASSOC);
}
return NULL;
}
public function get_table_primary_key($dbname, $table_name)
{
$column_name = NULL;
$select_sql = "SELECT `COLUMN_NAME` FROM `information_schema`.`COLUMNS` WHERE (`TABLE_SCHEMA`='{$dbname}') AND (`TABLE_NAME`='{$table_name}') AND (`COLUMN_KEY`='PRI')";
try {
$primary_key = $this->dbconnection->query($select_sql);
$column_name = $primary_key->fetchColumn(0);
} catch (PDOException $e) {
script_die('Unable to retrieve the primary key for table "' . $table_name . '".', "SELECT `COLUMN_NAME` FROM `COLUMNS` WHERE (`TABLE_SCHEMA`='{$dbname}') AND (`TABLE_NAME`='{$table_name}') AND (`COLUMN_KEY`='PRI')", $e->getMessage());
}
return $column_name;
}
public function insert($row, $name, $dbname, $table_name)
{
$columns = $this->db->escape_fields($row, $dbname, $table_name);
try {
$this->dbconnection->query("INSERT INTO {$table_name} (`" . implode('`,`', array_keys($columns)) . "`) VALUES (" . implode(',', $columns) . ");");
} catch (PDOException $e) {
script_die("Unable to insert `{$this->name}`.`{$name}` row.", "INSERT INTO {$table_name} (`" . implode('`,`', array_keys($columns)) . "`) VALUES (" . implode(',', $columns) . ");", $e->getMessage());
}
}
