3 require_once('joe.lib.php');
5 function DBMaster($sql) {
7 $res = mysql_query($sql);
11 function DBSlave($sql) {
13 $res = mysql_query($sql);
18 function DBSelect($sql) { return DBSlave($sql); }
19 function DBInsert($sql) {
21 if (mysql_error()) die($sql."<br />\n".mysql_error());
22 return mysql_insert_id();
24 function DBUpdate($sql) { DBInsert($sql); }
25 function DBDelete($sql) { DBInsert($sql); }
26 function DBCreate($sql) { DBMaster($sql); }
27 function DBDrop($sql) { DBMaster($sql); }
28 function DBGrant($sql) { DBInsert($sql); }
29 function DBRevoke($sql) { DBInsert($sql); }
30 function DBSet($sql) { DBInsert($sql); }
31 function DBShow($sql) { return DBSlave($sql); }
33 function calcDBSize($tdb) {
34 $sql_result = "SHOW TABLE STATUS FROM `" .mysql_escape_string($tdb)."`";
35 // $result = @mysql_db_query($tdb,$sql_result);
36 $result = DBShow($sql_result);
40 while ($data = mysql_fetch_array($result)) {
41 $size += $data["Data_length"] + $data["Index_length"];
43 mysql_free_result($result);