<?

include $_SERVER['DOCUMENT_ROOT'] . "/WebBuilder/WebApp.class.php";
$db = new DBMain();

$results = $db->query("SELECT COLUMN_NAME  FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '{$_GET['table_name']}' and table_schema = '{$_SESSION['db_name']}'");
while ($row = $results->fetch_assoc()) {
    $column_name = $row['COLUMN_NAME'];
    if ($column_name == 'record_id') {
        continue;
    } else {
        $name_arr[] = $column_name;
        if ($column_name == 'password') {
            $var_arr[] = hash("sha256", $_GET["$column_name"]);
        } else {
            $var_arr[] = $_GET["$column_name"];
        }
    }
}


$index = 0;
$$log = '';
while ($index <= count($name_arr)) {
    if (strlen($name_arr[$index]) < 2) {
    } else {
        $columns[] = $name_arr[$index];
        $data[] = $var_arr[$index];
        $log = $log . $name_arr[$index] . ' -> ' . $var_arr[$index] . ",";
    }

    $index++;
}


$insert_event = $db->Update($_GET['table_name'], $columns, $data, "record_id = {$_GET['record_id']}");

if ($insert_event) {
    $db->add_log("UPDATED $log", $_GET['table_name'], $_GET['record_id']);
    echo 1;
} else {
    echo "INSERT INTO `{$_GET['table_name']}` (" . implode(",", $string_1) . ") VALUES (" . implode(",", $string_2) . ")";
}