function db_page_update($page_id, $name, $title, $content, $type) { $param_arr = _init_db_params(); LOG_MSG('INFO', "db_page_update(): START {\n\t\t\t\t\t\t\t\tpage_id=[{$page_id}],\n\t\t\t\t\t\t\t\tname=[{$name}],\n\t\t\t\t\t\t\t\ttitle=[{$title}],\n\t\t\t\t\t\t\t\tcontent=[{$content}]\n\t\t\t\t\t\t\t\ttype=[{$type}]\n}"); // Add params to params_arr $param_arr = _db_prepare_param($param_arr, "s", "title", $title); $param_arr = _db_prepare_param($param_arr, "s", "content", $content); // Only Super user can update type if (!is_superuser()) { $param_arr = _db_prepare_param($param_arr, "s", "type", $type); $param_arr = _db_prepare_param($param_arr, "s", "name", $name); } // For the where clause $where_clause = " WHERE page_id=? AND shop_id=" . SHOP_ID; $param_arr = _db_prepare_param($param_arr, "i", "page_id", $page_id, true); $resp = execSQL("UPDATE \n\t\t\t\t\t\t\ttPage\n\t\t\t\t\t\tSET " . $param_arr['update_fields'] . $where_clause, $param_arr['params'], true); LOG_MSG('INFO', "db_page_update(): END"); return $resp; }
} ?> <!-- CENTER CONTENT --> <div class="span-24 center-content"> <?php show_msgs(); if (is_loggedin() && is_admin() || is_viewer()) { if (file_exists("modules/{$MOD}/{$ENTITY}/controller.php")) { include "modules/" . $MOD . "/" . $ENTITY . "/controller.php"; } } else { if (is_loggedin() && is_supervisor()) { include "modules/admin/vehicle/controller.php"; } else { if (is_loggedin() && is_superuser()) { include "modules/admin/travel/controller.php"; } else { add_msg('SUCCESS', "Welcome to {$DOMAIN}. Please login to start using your account"); show_msgs(); } } } ?> </div> <!-- END CENTER CONTENT --> <!-- FOOTER --> <?php include "static/html/footer.html"; ?>