function update_dash_tile($tile, $url, $link, $title, $reload_interval, $all_users, $default_order_by, $resource_count, $text = "", $delete = 1)
{
if (!is_array($tile)) {
$tile = get_tile($tile);
}
#Sensible Defaults for insertion to Database
if (empty($reload_interval) || !is_numeric($reload_interval)) {
$reload_interval = 0;
}
$delete = $delete ? 1 : 0;
$all_users = $all_users ? 1 : 0;
if (!is_numeric($default_order_by)) {
$default_order_by = $tile["default_order_by"];
}
$resource_count = $resource_count ? 1 : 0;
sql_query("UPDATE dash_tile \n\t\t\t\tSET \n\t\t\t\t\turl='" . escape_check($url) . "',\n\t\t\t\t\tlink='" . escape_check($link) . "',\n\t\t\t\t\ttitle='" . escape_check($title) . "',\n\t\t\t\t\treload_interval_secs=" . $reload_interval . ",\n\t\t\t\t\tall_users='" . $all_users . "',\n\t\t\t\t\tdefault_order_by='" . $default_order_by . "',\n\t\t\t\t\tresource_count='" . $resource_count . "',\n\t\t\t\t\tallow_delete='" . $delete . "',\n\t\t\t\t\ttxt='" . escape_check($text) . "'\n\t\t\t\tWHERE \n\t\t\t\t\tref='" . $tile["ref"] . "'");
# Check if the tile is being changed to an all_user tile from user specific
if ($all_users == 1 && $tile["all_users"] == 0) {
#Delete the users existing record to ensure they don't get a duplicate.
sql_query("DELETE FROM user_dash_tile WHERE dash_tile=" . $tile["ref"]);
sql_query("INSERT user_dash_tile (user,dash_tile,order_by) SELECT user.ref,'" . $tile["ref"] . "',5 FROM user");
}
}
} else {
if (substr($title, 0, 5) == "!last") {
$last = preg_replace("/^!last/", "", $title);
$title = $last != "" ? $lang["last"] . " " . $last : $lang["recent"];
}
}
}
}
$pagetitle = $lang["createnewdashtile"];
$formextra = '<input type="hidden" name="submitdashtile" value="true" />';
$validpage = true;
$submittext = $lang["create"];
} else {
if ($edit) {
#edit contains the dash_tile record ref
$tile = get_tile($edit);
$allusers = $tile["all_users"];
$url = $tile["url"];
$link = $tile["link"];
$title = $tile["title"];
$freetext = empty($tile["txt"]) ? "true" : $tile["txt"];
$resource_count = $tile["resource_count"];
#Get field data
$buildstring = explode('?', $tile["url"]);
parse_str(str_replace("&", "&", $buildstring[1]), $buildstring);
if (isset($buildstring["tltype"])) {
$tile_type = $buildstring["tltype"];
$tile_nostyle = isset($buildstring["tlstyle"]) ? FALSE : TRUE;
$tile_style = $buildstring["tlstyle"];
} else {
$tile_type = "";
*/
include "../../include/db.php";
include "../../include/general.php";
include "../../include/authenticate.php";
include "../../include/search_functions.php";
include_once "../../include/collections_functions.php";
include "../../include/dash_functions.php";
/* You must correctly use exit calls when functionality is complete. */
global $userref, $baseurl_short;
/* Tile */
$rawtile = getvalescaped("tile", null, TRUE);
if (isset($rawtile) && !empty($rawtile)) {
if (!is_numeric($rawtile)) {
exit($lang["invaliddashtile"]);
}
$tile = get_tile($rawtile);
if (!$tile) {
exit($lang["nodashtilefound"]);
}
}
/* User Tile */
$user_rawtile = getvalescaped("user_tile", null, TRUE);
if (isset($user_rawtile) && !empty($user_rawtile)) {
if (!is_numeric($user_rawtile)) {
exit($lang["invaliddashtile"]);
}
$usertile = get_user_tile($user_rawtile, $userref);
if (!$usertile) {
exit($lang["nodashtilefound"]);
}
}
