function ValidTime($t) { $temptime = split('[:]', $t); $hour = $temptime[0]; $minute = $temptime[1]; $second = @$temptime[2]; /* MAY NOT EXIST */ if (!IS_NULL($hour) && (!IS_NUMERIC($hour) || $hour < 0 || $hour > 60)) { return False; } if (!IS_NULL($minute) && (!IS_NUMERIC($minute) || $minute < 0 || $minute > 60)) { return False; } if (!IS_NULL($second) && (!IS_NUMERIC($second) || $second < 0 || $second > 60)) { return False; } return True; }
public function Query($sql) { /* GLOBAL DATABASE OBJECT */ $db = $GLOBALS['db']; /* EXECUTE THE ENTIRE QUERY WITHOUT LIMITING THE RECORDS */ $full_result = $db->Query($sql); /* COUNT THE NUMBER OF ROWS FOUND */ $this->num_rows_found = $db->NumRows($full_result); /* STORE THE COLUMN NAMES */ $this->get_col_names = $db->GetColumns($full_result); /* DO SOME FILTERING - NOT IMPLEMENTED */ if (isset($_GET['col_sort'])) { //$sql.="ORDER BY ".$this->get_col_names[$_GET['col_sort']]; } /* DETERMINE THE OFFSET */ if (isset($_GET['offset']) && IS_NUMERIC($_GET['offset']) && $_GET['offset'] < $this->num_rows_found) { $this->offset = $_GET['offset']; $this->start_offset = 0; $this->sql_start_offset = $_GET['offset']; } else { $this->start_offset = 10; $this->offset = 10; $this->sql_start_offset = 0; } /* APPEND A LIMIT TO THE QUERY */ $sql .= " LIMIT " . $this->sql_start_offset . "," . $this->limit; //echo $sql; $result = $db->Query($sql); $this->count_rows = 0; $result = $db->Query($sql); //$this->cols=pg_fetch_all_columns($result); if ($db->NumRows($result) > 0) { while ($row = $db->FetchArray($result)) { for ($i = 0; $i < count($this->cols); $i++) { $this->temp_col_data[$this->count_rows][$i] = $row[$this->cols[$i]]; } $this->count_rows++; } } else { $this->display_data .= "<tr>\n"; $this->display_data .= "<td colspan='" . count($this->friendly_cols) . "'><div id='nodata'>No data exists</div></td>\n"; $this->display_data .= "</tr>\n"; } }
public function Info($module_id) { $db = $GLOBALS['db']; $this->module_id = $module_id; if (!IS_NUMERIC($module_id)) { $this->Errors("Non numeric module ID"); return False; } $sql = "SELECT name,description,available_teamspaces,logo,signup_module,introduction,available_all_workspaces,anonymous_access\n\t\t\t\t\tFROM " . $GLOBALS['database_prefix'] . "core_module_master\n\t\t\t\t\tWHERE module_id = " . $this->module_id . "\n\t\t\t\t\t"; //echo $sql; $result = $db->Query($sql); if ($db->NumRows($result) > 0) { while ($row = $db->FetchArray($result)) { /* HERE WE CALL THE FIELDS AND SET THEM INTO DYNAMIC VARIABLES */ $arr_cols = $db->GetColumns($result); for ($i = 1; $i < count($arr_cols); $i++) { $col_name = $arr_cols[$i]; $this->{$col_name} = $row[$col_name]; } } } return True; }
public function Delete($user_id, $workspace_id, $module_id) { if (IS_NUMERIC($user_id)) { $this->Errors("User Invalid"); return False; } if (IS_NUMERIC($workspace_id)) { $this->Errors("Workspace Invalid"); return False; } if (IS_NUMERIC($module_id)) { $this->Errors("Module Invalid"); return False; } $this->db = $GLOBALS['db']; $sql = "DELETE FROM " . $GLOBALS['database_prefix'] . "core_space_user_modules\n\t\t\t\t\tWHERE user_id = {$user_id}\n\t\t\t\t\tAND workspace_id = {$workspace_id}\n\t\t\t\t\tAND module_id = {$module_id}\n\t\t\t\t\t"; $result = $db->Query($sql); if ($db->AffectedRows() > 0) { return True; } else { $this->Errors("Failed to delete user module"); return False; } }
defined('_VALID_MVH') or die('Direct Access to this location is not allowed.'); /*** CLASS FOR SITE SETUP ***/ require_once $GLOBALS['dr'] . "classes/setup/setup.php"; $setup = new Setup(); require_once $GLOBALS['dr'] . "include/functions/design/curve_boxes.php"; /* SESSION ID */ if (isset($_SESSION['sid'])) { $sid = $_SESSION['sid']; $user_id = $_SESSION['user_id']; require_once $GLOBALS['dr'] . "classes/user/user_info.php"; require_once $GLOBALS['dr'] . "include/functions/date_time/set_timezone.php"; $ui = new UserInfo($user_id); $workspace_id = $ui->WorkspaceID(); $teamspace_id = $ui->TeamspaceID(); //echo $teamspace_id; //if (IS_NULL($teamspace_id)) { echo "NULL teamspace"; } else { echo "Not null teamspace"; } SetTimezone($ui->Timezone()); if (IS_NULL($ui->TeamspaceID())) { $teamspace_sql = "IS NULL"; $teamspace_id = "NULL"; } else { $teamspace_sql = "= {$teamspace_id}"; } } /* CREATE AN INSTANCE OF THE WORKSPACE */ if (isset($_SESSION['sid']) && IS_NUMERIC($ui->WorkspaceID())) { require_once $GLOBALS['dr'] . "modules/workspace/classes/workspace_user_info.php"; $wui = new WorkspaceUserInfo($_SESSION['user_id'], $ui->WorkspaceID()); } /* JPGRAPH SETTINGS */ $jpgraph_font_dir = $dr . "include/jpgraph/fonts/";
} $A['Q2'] = STR_REPLACE(array('+', '-', '=', ' '), '', $Q); if ($A['Q1'] != '=') { $A['Q3'] = 'quantity = quantity ' . $A['Q1'] . ' ?'; } else { $A['Q3'] = 'quantity = ?'; } $A['P1'] = SUBSTR($P, 0, 1); if (IS_NUMERIC($A['P1'])) { $A['P1'] = '='; } $A['P2'] = STR_REPLACE(array('+', '-', '=', ' '), '', $P); if ($A['P1'] != '=') { $A['P3'] = 'price = price ' . $A['P1'] . ' ?'; } else { $A['P3'] = 'price = ?'; } $A['M1'] = SUBSTR($M, 0, 1); if (IS_NUMERIC($A['M1'])) { $A['M1'] = '='; } $A['M2'] = STR_REPLACE(array('+', '-', '=', ' '), '', $M); if ($A['M1'] != '=') { $A['M3'] = 'minimum = minimum ' . $A['M1'] . ' ?'; } else { $A['M3'] = 'minimum = ?'; } $Q = 'INSERT INTO inventory_stock (store, item, quantity, minimum, price, modified) VALUES (?,?,?,?,?,?) ON DUPLICATE KEY UPDATE ' . $A['Q3'] . ', ' . $A['P3'] . ', ' . $A['M3']; MYSQL::QUERY($Q, array($user['store'], $PID, $A['Q2'], $A['M2'], $A['P2'], DATE('Y-m-d H:i:s'), $A['Q2'], $A['P2'], $A['M2'])); $CHECK = MYSQL::QUERY('SELECT quantity,minimum,price FROM inventory_stock WHERE store = ? AND item = ? LIMIT 1', array($user['store'], $PID)); echo $CHECK['quantity'] . '|' . $CHECK['price'] . '|' . $CHECK['minimum'];
$P = $_GET['p']; $V = $_GET['v']; $T = $_GET['t']; switch ($T) { case 'Q': $R = 'quantity'; break; case 'P': $R = 'price'; break; case 'M': $R = 'minimum'; break; } $CH = SUBSTR($V, 0, 1); if (IS_NUMERIC($CH)) { $CH = '='; } $VALUE = STR_REPLACE(array('+', '-', '=', ' '), '', $V); if ($CH == '+' || $CH == '-' || $CH == '=') { if ($CH != '=') { $R = $R . " = " . $R; } if ($CH != '-') { $OD = ''; } else { $OD = '-'; } $Q = 'INSERT INTO inventory_stock (store, item, quantity, minimum, price, modified) VALUES (?,?,?,?,?,?) ON DUPLICATE KEY UPDATE ' . $R . ' ' . $CH . ' ' . $VALUE; MYSQL::QUERY($Q, array($user['store'], $P, $OD . $VALUE, 0, 0, DATE('Y-m-d H:i:s'))); echo $CH . "|" . $VALUE;
function Body() { $dr = $GLOBALS['dr']; $wb = $GLOBALS['wb']; global $mi; /* PUT THE MODULE ID IN THE GLOBAL CONTEXT */ $c = "<table align='center' width='780' cellpadding='0' cellspacing='0' border='0' class='plain'>\n"; $c .= "<tr>\n"; $c .= "<td width='20' bgcolor='#3399CC'><img src='" . $wb . "images/curves/top_left.gif' width='20' height='42'></td>\n"; //$c.="<td width='740' bgcolor='#66CC33'><a href='index.php'></a></td>\n"; $c .= "<td width='740' bgcolor='#66CC33'><a href='index.php'>" . $GLOBALS['site_logo'] . "</a></td>\n"; $c .= "<td width='20' bgcolor='#3399CC'><img src='" . $wb . "images/curves/top_right.gif' width='20' height='42'></td>\n"; $c .= "</tr>\n"; $c .= "<tr>\n"; $c .= "<td bgcolor='#99CCFF' colspan='3'>\n"; if (isset($_SESSION['user_id'])) { require_once $dr . "include/functions/design/login_bar.php"; $c .= LoginBar(); } else { require_once $dr . "include/functions/design/logout_bar.php"; $c .= LogoutBar(); } $c .= "</td>\n"; $c .= "</tr>\n"; /* NOT LOGGED IN AND NO MODULE IN QUERYSTRING */ if (!isset($_SESSION['user_id']) && !isset($_GET['module'])) { require_once $dr . "modules/core/functions/forms/login_form.php"; $c .= "<tr bgcolor='#ffffff' align='center'>\n"; $c .= "<td colspan='3'>\n"; if (isset($_COOKIE['mvh_username'])) { $c .= LoginFormCookie(); } else { $c .= LoginForm(); } $c .= "</td>\n"; $c .= "</tr>\n"; } elseif (isset($_SESSION['user_id']) && !isset($_GET['module']) && isset($GLOBALS['ui']) && isset($GLOBALS['wui'])) { /* PROCESS THE ACTIVATION AND DEACTIVATION OF MODULES IN THE WORKSPACE HERE AS WE NEED UI TO BE SET */ if (isset($_GET['wtask']) && $_GET['wtask'] == "install_workspace_user_module") { require_once $dr . "modules/workspace/classes/add_remove_user_workspace_module.php"; $aruwm = new AddRemoveUserWorkspaceModule(); $aruwm->SetParameters($_GET['module_id']); $result = $aruwm->AddRemove(); //if (!$result) { echo Alert("3",$at->ShowErrors()); } } /* ACTIVATE THE TEAMSPACE MODULES */ if (isset($_GET['wtask']) && $_GET['wtask'] == "install_teamspace_user_module") { require_once $dr . "modules/teamspace/classes/add_remove_user_teamspace_module.php"; $arutm = new AddRemoveUserTeamspaceModule(); $arutm->SetParameters($_GET['module_id']); $result = $arutm->AddRemove(); //if (!$result) { echo Alert("3",$at->ShowErrors()); } } /* INCLUDE THE MAIN FILES FOR THE WORKSPACE */ require_once $dr . "modules/workspace/functions/browse/non_enterprise_workspace_modules.php"; require_once $dr . "include/functions/design/teamspace_slider.php"; require_once $dr . "include/functions/teamspace/user_teamspaces.php"; /* TODO: CHANGE THIS TO THE WORKSPACE FOLDER */ //require_once($dr."modules/teamspace/functions/browse/user_available_modules.php"); require_once $dr . "modules/teamspace/classes/user_available_modules.php"; // $c .= "<tr>\n"; $c .= "<td colspan='3'>\n"; $c .= "<table cellspacing='0'>\n"; $c .= "<tr>\n"; if (IS_NUMERIC($GLOBALS['teamspace_id'])) { $c .= "<td width='150' valign='top'>" . UserAvailableModules() . "</td>\n"; } else { $obj_uam = new UserAvailableModules(); if ($obj_uam->CountUserAvailableModules() > 0) { $c .= "<td width='150' valign='top'>" . TeamspaceSliderItems() . "</td>\n"; } } $c .= "<td width='630'>" . CurveBox(NonEnterpriseModules($GLOBALS['ui']->WorkspaceID(), $_SESSION['user_id'], $GLOBALS['wui']->RoleID(), True)) . "</td>\n"; $c .= "<td width='150' valign='top'>" . UserTeamspaces() . "</td>\n"; $c .= "</tr>\n"; $c .= "</table>\n"; $c .= "</td>\n"; $c .= "</tr>\n"; } elseif (isset($_SESSION['user_id']) && !isset($_GET['module']) && empty($workspace_id)) { require_once $dr . "modules/workspace/functions/browse/select_workspace.php"; require_once $dr . "modules/workspace/functions/misc/menu.php"; $c .= "<tr>\n"; $c .= "<td colspan='3'>\n"; $c .= "<table cellspacing='0' class='plain_border'>\n"; $c .= "<tr>\n"; $c .= "<td>" . SelectWorkspace() . "</td>\n"; if ($GLOBALS['ui']->GetInfo("default_role") != "y") { $c .= "<td width='150' valign='top'>" . Menu() . "</td>\n"; } $c .= "</tr>\n"; $c .= "</table>\n"; $c .= "</td>\n"; $c .= "</tr>\n"; //$c.=CurveBox(SelectWorkspace()); } elseif (isset($_GET['module']) && file_exists($dr . "modules/" . $_GET['module'] . ".php")) { $module_id = GetColumnValue("module_id", "core_module_master", "name", $_GET['module']); require_once $dr . "modules/" . $_GET['module'] . ".php"; require_once $dr . "classes/modules/module_id.php"; $mi = new ModuleID(); $module_result = $mi->Info($module_id); $anonymous_access = $mi->GetInfo("anonymous_access"); $c .= "<tr>\n"; $c .= "<td colspan='3'>"; /* CHECK FOR ERRORS OR ACCESS DENIED */ if ($module_result && $mi->CheckACL()) { $c .= LoadModule($module_id, $anonymous_access); } else { $c .= CurveBox("Access to module denied"); } $c .= "</td>\n"; $c .= "</tr>\n"; } $c .= "<tr>\n"; $c .= "<td width='20' bgcolor='#3399CC'><img src='" . $wb . "images/curves/white_bottom_left.gif' width='20' height='20'></td>\n"; $c .= "<td width='780' bgcolor='#ffffff' align='center'>" . $GLOBALS['copyright_notice'] . "</td>\n"; $c .= "<td width='20' bgcolor='#3399CC'><img src='" . $wb . "images/curves/white_bottom_right.gif' width='20' height='20'></td>\n"; $c .= "</tr>\n"; $c .= "</table>\n"; return $c; }
/** * Creates and appends one or more children elements * * This method is a shortcut to the createElement, appendChild * sequence and can also accept associative arrays of any depth * * There are a few ways to call this method: * - Flow::add('name', 'value'); would result in a new child at the root * called 'name' with a value of 'value'. * - Flow::add(array('name1'=>'value1', 'name2'=>'value2')); would result 2 * new children at root level (name1 and name2) with respective values * - Flow:add('name', array('blue','red')); would result in 2 nodes at root * level of name 'name' with values of 'blue' and 'red' respectively. * - Flow::add('name', array('sub1'=> 'blue','sub2'=>'red')); results in a * new node of name 'name' at rool level, which contains 2 children * each with the values of blue and red respectively. * * Note that multi level arrays can be used. * * @param mixed $node a string for a child or associative array of values * @param mixed $value (optional) if a string is passed $node * If an array is passed, it represents the multiple children of $node. * @param object $root (optional) reference to a DOMElement child * if none is passed, root is assumed * * @return boolean success. Usual fail reason is non valid XML names */ public static function add($node, $value = null, $root = false) { $flow = Nexista_Flow::singleton('Nexista_Flow'); //where do we place this? if (!$root) { $root = $flow->root; } if (is_array($node)) { foreach ($node as $n => $v) { if (IS_NUMERIC) { return false; } $flow->add($n, $v, $root); } } else { if (is_array($value)) { //numeric array? we replicate the node if (IS_NUMERIC(key($value))) { foreach ($value as $n => $v) { $flow->add($node, $v, $root); } } else { //associative array $e = $root->appendChild($flow->flowDocument->createElement($node)); foreach ($value as $n => $v) { if ($n == 'GLOBALS' || $n == '') { continue; } $flow->add($n, $v, $e); } } } elseif (!is_null($value)) { $e = $root->appendChild($flow->flowDocument->createElement($node)); $e->appendChild($flow->flowDocument->createTextNode($value)); } } return true; }