Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

if (!defined('ABSPATH')) exit;

[2] Fix | Delete

if (!class_exists('BVWPDb')) :

[3] Fix | Delete

[4] Fix | Delete

class BVWPDb {

[5] Fix | Delete

public function dbprefix() {

[6] Fix | Delete

global $wpdb;

[7] Fix | Delete

$prefix = $wpdb->base_prefix ? $wpdb->base_prefix : $wpdb->prefix;

[8] Fix | Delete

return $prefix;

[9] Fix | Delete

}

[10] Fix | Delete

[11] Fix | Delete

public function prepare($query, $args) {

[12] Fix | Delete

global $wpdb;

[13] Fix | Delete

return $wpdb->prepare($query, $args);

[14] Fix | Delete

}

[15] Fix | Delete

[16] Fix | Delete

public function getSiteId() {

[17] Fix | Delete

global $wpdb;

[18] Fix | Delete

return $wpdb->siteid;

[19] Fix | Delete

}

[20] Fix | Delete

[21] Fix | Delete

public function getResult($query, $obj = ARRAY_A) {

[22] Fix | Delete

global $wpdb;

[23] Fix | Delete

return $wpdb->get_results($query, $obj);

[24] Fix | Delete

}

[25] Fix | Delete

[26] Fix | Delete

public function query($query) {

[27] Fix | Delete

global $wpdb;

[28] Fix | Delete

return $wpdb->query($query);

[29] Fix | Delete

}

[30] Fix | Delete

[31] Fix | Delete

public function getVar($query, $col = 0, $row = 0) {

[32] Fix | Delete

global $wpdb;

[33] Fix | Delete

return $wpdb->get_var($query, $col, $row);

[34] Fix | Delete

}

[35] Fix | Delete

[36] Fix | Delete

public function getCol($query, $col = 0) {

[37] Fix | Delete

global $wpdb;

[38] Fix | Delete

return $wpdb->get_col($query, $col);

[39] Fix | Delete

}

[40] Fix | Delete

[41] Fix | Delete

public function tableName($table) {

[42] Fix | Delete

return $table[0];

[43] Fix | Delete

}

[44] Fix | Delete

[45] Fix | Delete

public function showTables() {

[46] Fix | Delete

$tables = $this->getResult("SHOW TABLES", ARRAY_N);

[47] Fix | Delete

return array_map(array($this, 'tableName'), $tables);

[48] Fix | Delete

}

[49] Fix | Delete

[50] Fix | Delete

[51] Fix | Delete

public function showTableStatus() {

[52] Fix | Delete

return $this->getResult("SHOW TABLE STATUS");

[53] Fix | Delete

}

[54] Fix | Delete

[55] Fix | Delete

public function tableKeys($table) {

[56] Fix | Delete

return $this->getResult("SHOW KEYS FROM $table;");

[57] Fix | Delete

}

[58] Fix | Delete

[59] Fix | Delete

public function showDbVariables($variable) {

[60] Fix | Delete

$variables = $this->getResult("Show variables like '%$variable%' ;");

[61] Fix | Delete

$result = array();

[62] Fix | Delete

foreach ($variables as $variable) {

[63] Fix | Delete

$result[$variable["Variable_name"]] = $variable["Value"];

[64] Fix | Delete

}

[65] Fix | Delete

return $result;

[66] Fix | Delete

}

[67] Fix | Delete

[68] Fix | Delete

public function describeTable($table) {

[69] Fix | Delete

return $this->getResult("DESCRIBE $table;");

[70] Fix | Delete

}

[71] Fix | Delete

[72] Fix | Delete

public function showTableIndex($table) {

[73] Fix | Delete

return $this->getResult("SHOW INDEX FROM $table");

[74] Fix | Delete

}

[75] Fix | Delete

[76] Fix | Delete

public function checkTable($table, $type) {

[77] Fix | Delete

return $this->getResult("CHECK TABLE $table $type;");

[78] Fix | Delete

}

[79] Fix | Delete

[80] Fix | Delete

public function repairTable($table) {

[81] Fix | Delete

return $this->getResult("REPAIR TABLE $table;");

[82] Fix | Delete

}

[83] Fix | Delete

[84] Fix | Delete

public function showTableCreate($table) {

[85] Fix | Delete

return $this->getVar("SHOW CREATE TABLE $table;", 1);

[86] Fix | Delete

}

[87] Fix | Delete

[88] Fix | Delete

public function rowsCount($table) {

[89] Fix | Delete

$count = $this->getVar("SELECT COUNT(*) FROM $table;");

[90] Fix | Delete

return intval($count);

[91] Fix | Delete

}

[92] Fix | Delete

[93] Fix | Delete

public function createTable($query, $name, $usedbdelta = false) {

[94] Fix | Delete

$table = $this->getBVTable($name);

[95] Fix | Delete

if (!$this->isTablePresent($table)) {

[96] Fix | Delete

if ($usedbdelta) {

[97] Fix | Delete

if (!function_exists('dbDelta'))

[98] Fix | Delete

require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

[99] Fix | Delete

dbDelta($query);

[100] Fix | Delete

} else {

[101] Fix | Delete

$this->query($query);

[102] Fix | Delete

}

[103] Fix | Delete

}

[104] Fix | Delete

return $this->isTablePresent($table);

[105] Fix | Delete

}

[106] Fix | Delete

[107] Fix | Delete

public function createTables($tables, $usedbdelta = false) {

[108] Fix | Delete

$result = array();

[109] Fix | Delete

foreach ($tables as $table => $query) {

[110] Fix | Delete

$result[$table] = $this->createTable($query, $table, $usedbdelta);

[111] Fix | Delete

}

[112] Fix | Delete

return $result;

[113] Fix | Delete

}

[114] Fix | Delete

[115] Fix | Delete

public function alterBVTable($query, $name) {

[116] Fix | Delete

$resp = false;

[117] Fix | Delete

$table = $this->getBVTable($name);

[118] Fix | Delete

if ($this->isTablePresent($table)) {

[119] Fix | Delete

$resp = $this->query($query);

[120] Fix | Delete

}

[121] Fix | Delete

return $resp;

[122] Fix | Delete

}

[123] Fix | Delete

[124] Fix | Delete

public function alterTables($tables) {

[125] Fix | Delete

$result = array();

[126] Fix | Delete

foreach ($tables as $table => $query) {

[127] Fix | Delete

$result[$table] = $this->alterBVTable($query, $table);

[128] Fix | Delete

}

[129] Fix | Delete

return $result;

[130] Fix | Delete

}

[131] Fix | Delete

[132] Fix | Delete

public function getTableContent($table, $fields = '*', $filter = '', $limit = 0, $offset = 0) {

[133] Fix | Delete

$query = "SELECT $fields from $table $filter";

[134] Fix | Delete

if ($limit > 0)

[135] Fix | Delete

$query .= " LIMIT $limit";

[136] Fix | Delete

if ($offset > 0)

[137] Fix | Delete

$query .= " OFFSET $offset";

[138] Fix | Delete

$rows = $this->getResult($query);

[139] Fix | Delete

return $rows;

[140] Fix | Delete

}

[141] Fix | Delete

[142] Fix | Delete

public function isTablePresent($table) {

[143] Fix | Delete

return ($this->getVar("SHOW TABLES LIKE '$table'") === $table);

[144] Fix | Delete

}

[145] Fix | Delete

[146] Fix | Delete

public function getCharsetCollate() {

[147] Fix | Delete

global $wpdb;

[148] Fix | Delete

return $wpdb->get_charset_collate();

[149] Fix | Delete

}

[150] Fix | Delete

[151] Fix | Delete

public function getWPTable($name) {

[152] Fix | Delete

return ($this->dbprefix() . $name);

[153] Fix | Delete

}

[154] Fix | Delete

[155] Fix | Delete

public function getBVTable($name) {

[156] Fix | Delete

return ($this->getWPTable("bv_" . $name));

[157] Fix | Delete

}

[158] Fix | Delete

[159] Fix | Delete

public function truncateBVTable($name) {

[160] Fix | Delete

$table = $this->getBVTable($name);

[161] Fix | Delete

if ($this->isTablePresent($table)) {

[162] Fix | Delete

return $this->query("TRUNCATE TABLE $table;");

[163] Fix | Delete

} else {

[164] Fix | Delete

return false;

[165] Fix | Delete

}

[166] Fix | Delete

}

[167] Fix | Delete

[168] Fix | Delete

public function deleteBVTableContent($name, $filter = "") {

[169] Fix | Delete

$table = $this->getBVTable($name);

[170] Fix | Delete

if ($this->isTablePresent($table)) {

[171] Fix | Delete

return $this->query("DELETE FROM $table $filter;");

[172] Fix | Delete

} else {

[173] Fix | Delete

return false;

[174] Fix | Delete

}

[175] Fix | Delete

}

[176] Fix | Delete

[177] Fix | Delete

public function dropBVTable($name) {

[178] Fix | Delete

$table = $this->getBVTable($name);

[179] Fix | Delete

if ($this->isTablePresent($table)) {

[180] Fix | Delete

$this->query("DROP TABLE IF EXISTS $table;");

[181] Fix | Delete

}

[182] Fix | Delete

return !$this->isTablePresent($table);

[183] Fix | Delete

}

[184] Fix | Delete

[185] Fix | Delete

public function dropTables($tables) {

[186] Fix | Delete

$result = array();

[187] Fix | Delete

foreach ($tables as $table) {

[188] Fix | Delete

$result[$table] = $this->dropBVTable($table);

[189] Fix | Delete

}

[190] Fix | Delete

return $result;

[191] Fix | Delete

}

[192] Fix | Delete

[193] Fix | Delete

public function truncateTables($tables) {

[194] Fix | Delete

$result = array();

[195] Fix | Delete

foreach ($tables as $table) {

[196] Fix | Delete

$result[$table] = $this->truncateBVTable($table);

[197] Fix | Delete

}

[198] Fix | Delete

return $result;

[199] Fix | Delete

}

[200] Fix | Delete

[201] Fix | Delete

public function deleteRowsFromtable($name, $count = 1) {

[202] Fix | Delete

$table = $this->getBVTable($name);

[203] Fix | Delete

if ($this->isTablePresent($table)) {

[204] Fix | Delete

return $this->getResult("DELETE FROM $table LIMIT $count;");

[205] Fix | Delete

} else {

[206] Fix | Delete

return false;

[207] Fix | Delete

}

[208] Fix | Delete

}

[209] Fix | Delete

[210] Fix | Delete

public function replaceIntoBVTable($name, $value) {

[211] Fix | Delete

global $wpdb;

[212] Fix | Delete

$table = $this->getBVTable($name);

[213] Fix | Delete

return $wpdb->replace($table, $value);

[214] Fix | Delete

}

[215] Fix | Delete

[216] Fix | Delete

public function insertIntoBVTable($name, $value) {

[217] Fix | Delete

global $wpdb;

[218] Fix | Delete

$table = $this->getBVTable($name);

[219] Fix | Delete

return $wpdb->insert($table, $value);

[220] Fix | Delete

}

[221] Fix | Delete

[222] Fix | Delete

public function tinfo($name) {

[223] Fix | Delete

$result = array();

[224] Fix | Delete

$table = $this->getBVTable($name);

[225] Fix | Delete

[226] Fix | Delete

$result['name'] = $table;

[227] Fix | Delete

[228] Fix | Delete

if ($this->isTablePresent($table)) {

[229] Fix | Delete

$result['exists'] = true;

[230] Fix | Delete

$result['createquery'] = $this->showTableCreate($table);

[231] Fix | Delete

}

[232] Fix | Delete

[233] Fix | Delete

return $result;

[234] Fix | Delete

}

[235] Fix | Delete

[236] Fix | Delete

public function getMysqlVersion() {

[237] Fix | Delete

return $this->showDbVariables('version')['version'];

[238] Fix | Delete

}

[239] Fix | Delete

}

[240] Fix | Delete

endif;

[241] Fix | Delete