function GetMainConnection()
{
global $MainConnection;
if (!isset($MainConnection)) {
$MainConnection = GetConnection(DB_HOST, DB_PORT, DB_NAME, DB_CHARSET, DB_USER, DB_PASSWORD);
}
return $MainConnection;
}
public function run()
{
global $connection_string;
global $last_migration;
$migrations = array();
try {
$migrations = MigrationHistory::find('all', array('order' => 'migration_date desc'));
} catch (Exception $e) {
//error_log($e);
$create_migration_history = "CREATE TABLE `migration_history` (\n\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t `migration_timestamp` bigint(20) DEFAULT NULL,\n\t\t\t `migration_file` varchar(100) DEFAULT NULL,\n\t\t\t `migration_date` datetime DEFAULT NULL,\n\t\t\t `datecreated` datetime NOT NULL,\n\t\t\t PRIMARY KEY (`id`)\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8";
GetConnection()->query($create_migration_history);
}
$last_migration_timestamp = strtotime($last_migration);
//if(count($migrations) > 0){
// $last_migration_timestamp = $migrations[0]->migration_timestamp;
//}
$migrations_ran = array_map(function ($m) {
return $m->migration_file;
}, $migrations);
//$last_migration_date = new DateTime("@$last_migration_timestamp");
$migrationFiles = array();
if (is_dir($this->dir)) {
if ($dh = opendir($this->dir)) {
while (false !== ($file = readdir($dh))) {
if ($file != "." && $file != ".." && filetype($this->dir . "/" . $file) == "file") {
$migrationFiles[] = $file;
}
}
sort($migrationFiles);
closedir($dh);
}
}
foreach ($migrationFiles as $file) {
$file_parts = split('_', $file);
$datestamp = $file_parts[0];
$timestamp = strtotime($datestamp);
if ($timestamp > $last_migration_timestamp && !in_array($file, $migrations_ran)) {
error_log("executing " . $file . ": " . $timestamp);
try {
$sqlpipe = "/usr/bin/mysql " . $connection_string . " < \"" . $this->dir . "/" . $file . "\" 2>&1 1> /dev/null";
$return = shell_exec($sqlpipe);
if (!is_null($return)) {
throw new Exception("Migration failed: " . $return);
}
$migrationHistory = new MigrationHistory();
$migrationHistory->migration_timestamp = $timestamp;
$migrationHistory->migration_file = $file;
$migrationHistory->migration_date = date("Y-m-d H:i:s", $timestamp);
$migrationHistory->datecreated = GetNewDate();
$migrationHistory->save();
$last_migration_timestamp = $timestamp;
} catch (Exception $e) {
error_log($e);
break;
}
}
}
}
static function Get()
{
$conn = GetConnection();
$results = $conn->query("SELECT * FROM 2015Fall_Persons");
$row = $results->fetch_assoc();
//var_dump($row);//=> its like "print(r);"
//echo '<pre>'
//print_r
my_print($row);
}
static function Update($row)
{
$conn = GetConnection();
$sql = "UPDATE Admin " . "Set Username='******'Username']}',Password='******'Password']}',Last_log='{$row['Last_log']}' " . "WHERE id={$row['id']} ";
//echo $sql;
$conn->query($sql);
$error = $conn->error;
$conn->close();
return $error != '' ? array('Server Error' => $error) : true;
}
static function Update($row)
{
$conn = GetConnection();
$sql = "UPDATE Suppliers " . "Set FirstName='{$row['FirstName']}',LastName='{$row['LastName']}',created_at='{$row['created_at']}',updated_at='{$row['updated_at']}',Keyword_id='{$row['Keyword_id']}' " . "WHERE id={$row['id']} ";
//echo $sql;
$conn->query($sql);
$error = $conn->error;
$conn->close();
return $error != '' ? array('Server Error' => $error) : true;
}
public static function Delete($id)
{
$conn = GetConnection();
$sql = "DELETE FROM 2014Fall_Food_Eaten WHERE id = {$id}";
//echo $sql;
$results = $conn->query($sql);
$error = $conn->error;
$conn->close();
return $error ? array('sql error' => $error) : false;
}
function TestLogin($pseudo, $password)
{
$db = GetConnection();
$request = $db->prepare('SELECT idUser, pseudo, pwd FROM `users` WHERE pseudo = "' . $pseudo . '" AND pwd = "' . $password . '"');
$request->execute();
$tabUser = $request->fetchAll(PDO::FETCH_ASSOC);
if ($tabUser != null) {
return $tabUser[0]["idUser"];
} else {
return false;
}
}
public static function Save($row)
{
if ($row['id']) {
$sql = "UPDATE 2015Fall_Meals Set Name = '{$row['Name']}', Calories = '{$row['Calories']}', Carbohydrates = '{$row['Carbohydrates']}', " . "Cholestrol='{$row['Cholestrol']}', Fiber = '{$row['Fiber']}', Protein = '{$row['Protein']}', Users_id=1, 2015Fall_MealTypes_id={$row['MealType']} WHERE id={$row['id']} ";
} else {
$sql = "Insert Into 2015Fall_Meals (Name, Calories, Carbohydrates, Cholestrol, Fiber, Protein, Users_id, 2015Fall_MealTypes_id) " . " Values ('{$row['Name']}', '{$row['Calories']}', '{$row['Carbohydrates']}', '{$row['Cholestrol']}', '{$row['Fiber']}', '{$row['Protein']}', 1, {$row['MealType']})";
}
$conn = GetConnection();
$results = $conn->query($sql);
$error = $conn->error;
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save($row)
{
if ($row['id']) {
$sql = "Update 2015Fall_Users set Name='{$row['Name']}', Age='{$row['Age']}', Height='{$row['Height']}', Weight='{$row['Weight']}', Avatar='{$row['Avatar']}', Status='offline' WHERE id= {$row['id']}";
} else {
$sql = "Insert Into 2015Fall_Users (Name, Age, Height, Weight, Avatar, Status) Values ( '{$row['Name']}', '{$row['Age']}', '{$row['Height']}', '{$row['Weight']}', '{$row['Avatar']}', 'offline' )";
}
$conn = GetConnection();
$results = $conn->query($sql);
$error = $conn->error;
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save(&$row)
{
$conn = GetConnection();
$row2 = escape_all($row, $conn);
//my_print( $sql );
$results = $conn->query($sql);
$error = $conn->error;
if (!$error && empty($row['id'])) {
$row['id'] = $conn->insert_id;
}
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save($row)
{
if ($row['id']) {
$sql = "UPDATE Exercises " . " Set Name = '{$row['Name']}', Minutes='{$row['Minutes']}', Calories_Burned='{$row['Calories_Burned']}', Users_id='{$row['Users_id']}', 2015Fall_ExerciseTypes_id='{$row['Users_id']}' " . " WHERE id={$row['id']} ";
} else {
$sql = "Insert Into Exercises (Name, Minutes, Calories_Burned, ) Values ('{$row['Name']}', '{$row['Minutes']}', '{$row['Calories_Burned']}', '{$row['Users_id']}', )";
}
$conn = GetConnection();
$results = $conn->query($sql);
$error = $conn->error;
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save($row)
{
if ($row['id']) {
$sql = "UPDATE Friend " . " Set Name = '{$row['Name']}', Friend_id='{$row['Friend_id']}', Users_id='{$row['Person_id']}' WHERE Friend_id={$row['id']} ";
} else {
$sql = "Insert Into Friends (Friend_id, Person_id) Values('{$row['Friend_id']}', '{$row['Person_id']}')";
}
$conn = GetConnection();
$results = $conn->query($sql);
$error = $conn->error;
$conn->close();
return $error ? array('sql error' => $error) : false;
}
function FetchAll($sql)
{
$ret = array();
$conn = GetConnection();
$results = $conn->query($sql);
$error = $conn->error;
if ($error) {
echo $error;
} else {
while ($rs = $results->fetch_assoc()) {
$ret[] = $rs;
}
}
return $ret;
}
public static function Save(&$row)
{
$conn = GetConnection();
if (!empty($row['id'])) {
$sql = "Update Persons set Name='{$row['Name']}', Age='{$row['Age']}', Height='{$row['Height']}', Weight='{$row['Weight']}', Avatar='{$row['Avatar']}', Status='offline' WHERE id= {$row['id']}";
} else {
$sql = "Insert Into Persons (Name, Age, Height, Weight, Avatar, Status) Values ( '{$row['Name']}', '{$row['Age']}', '{$row['Height']}', '{$row['Weight']}', '{$row['Avatar']}', 'offline' )";
}
//my_print( $sql );
$results = $conn->query($sql);
$error = $conn->error;
if (!$error && empty($row['id'])) {
$row['id'] = $conn->insert_id;
}
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save(&$row)
{
$conn = GetConnection();
$row2 = escape_all($row, $conn);
$row2['date'] = date('Y-m-d H:i:s', strtotime($row2['date']));
if (!empty($row['id'])) {
$sql = "Update exercises\n\t\t\t\t\t\tSet exercisename='{$row2['exercisename']}', date='{$row2['date']}' ,calories='{$row2['calories']}',updated=Now(),minutes='{$row2['minutes']}'\n\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t";
} else {
$sql = "INSERT INTO exercises\n\t\t\t\t\t(exercisename, date, created,calories,minutes)\n\t\t\t\t\tVALUES ('{$row2['exercisename']}', '{$row2['date']}', Now() , '{$row['calories']}', '{$row['minutes']}')";
}
$results = $conn->query($sql);
$error = $conn->error;
if (!$error && empty($row['id'])) {
$row['id'] = $conn->insert_id;
}
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save(&$row)
{
$conn = GetConnection();
$row2 = escape_all($row, $conn);
$row2['dob'] = date('Y-m-d H:i:s', strtotime($row2['dob']));
if (!empty($row['id'])) {
$sql = "Update FitnessTracker_User\n\t\t\t\t\t\t\tSet name='{$row2['name']}', dob='{$row2['dob']}'\n\t\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t\t";
} else {
$sql = "INSERT INTO FitnessTracker_User\n\t\t\t\t\t\t(name, dob, created_at)\n\t\t\t\t\t\tVALUES ('{$row2['name']}', '{$row2['dob']}', Now() ) ";
}
//my_print( $sql );
$results = $conn->query($sql);
$error = $conn->error;
if (!$error && empty($row['id'])) {
$row['id'] = $conn->insert_id;
}
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save(&$row)
{
$conn = GetConnection();
$row2 = escape_all($row, $conn);
// $row2['Birthday'] = date( 'Y-m-d H:i:s', strtotime( $row2['Birthday'] ) );
if (!empty($row['meals_id'])) {
$sql = "Update Meals Set Name ='{$row2['Name']}',Calories = '{$row['Calories']}, MealType = '{$row['MealType']} WHERE meals_id = {$row2['meal_id']}";
} else {
$sql = "INSERT INTO Meals(Name, Calories, MealType) VALUES ('{$row2['Name']}', '{$row2['Calories']}', '{$row['MealType']}',Now() ) ";
}
//my_print( $sql );
$results = $conn->query($sql);
$error = $conn->error;
if (!$error && empty($row['id'])) {
$row['id'] = $conn->insert_id;
}
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save(&$row)
{
$conn = GetConnection();
$row2 = escape_all($row, $conn);
$row2['Date'] = date('Y-m-d H:i:s', strtotime($row2['Date']));
if (!empty($row['id'])) {
$sql = "Update 2015Fall_WorkoutDate\n\t\t\t\t\t\t\tSet Name='{$row2['Name']}', Date='{$row2['Date']}', Calories='{$row2['Calories']}'\n\t\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t\t";
} else {
$sql = "INSERT INTO 2015Fall_WorkoutDate\n\t\t\t\t(Name, Date, created_at, Calories)\n\t\t\t\tVALUES ('{$row2['Name']}', '{$row2['Date']}', Now(), '{$row2['Calories']}') ";
}
//my_print( $sql );
$results = $conn->query($sql);
$error = $conn->error;
if (!$error && empty($row['id'])) {
$row['id'] = $conn->insert_id;
}
$conn->close();
return $error ? array('sql error' => $error) : false;
}
public static function Save(&$row)
{
$conn = GetConnection();
$row2 = escape_all($row, $conn);
$row2['Birthday'] = date('Y-m-d H:i:s', strtotime($row2['Birthday']));
if (!empty($row['foods_id'])) {
$sql = "Update Foods Set firstname='{$row2['firstname']}', Birthday='{$row2['Birthday']}' WHERE foods_id = {$row2['foods_id']}";
} else {
$sql = "INSERT INTO Foods(firstname, Birthday, created_at) VALUES ('{$row2['firstname']}', '{$row2['Birthday']}', Now() ) ";
}
//my_print( $sql );
$results = $conn->query($sql);
$error = $conn->error;
if (!$error && empty($row['id'])) {
$row['id'] = $conn->insert_id;
}
$conn->close();
return $error ? array('sql error' => $error) : false;
}
$iid = $options['item'];
$item_param = ItemParam($db, $iid);
$ddb = GetDomainConnection($item_param["item_module"]);
$ns = "";
$ns_num = 0;
while (array_key_exists("ns" . $ns_num, $item_param)) {
$ns .= $item_param["ns" . $ns_num] . " ";
$ns_num++;
}
$ddb->query("UPDATE domain SET ns = '" . $ddb->real_escape_string($ns) . "' WHERE name = '" . $ddb->real_escape_string($item_param["domain"]) . "' AND status != 'deleted'");
} elseif ($command == "import") {
// Get list of domains and contact. Import into BILLmanager
$module = $options['module'];
$search = array_key_exists("searchstring", $options) ? $options['searchstring'] : "";
$search_array = explode(" ", $search);
$db = GetConnection();
$ddb = GetDomainConnection($module);
$sub_query = "";
foreach ($search_array as $domain) {
if ($domain == "") {
continue;
}
if ($sub_query == "") {
$sub_query .= " AND name in (";
} else {
$sub_query .= ",";
}
$sub_query .= "'" . $ddb->real_escape_string($domain) . "'";
}
if ($sub_query != "") {
$sub_query .= ")";
