function Logger($text, $level) { $gLogError = 1; $gLogErrorFile = "./log.txt"; if ($gLogError) { $text = date('D M j G:i:s T Y') . " {$text}" . "\n"; $file = $gLogErrorFile; ErrorLog($text, $file); } }
function DoEmail() { global $config, $dump, $databases, $email, $lang, $out, $REMOTE_ADDR; $header = ""; if ($config['cron_use_sendmail'] == 1) { //sendmail if (ini_get("sendmail_path") != $config['cron_sendmail']) { @ini_set("SMTP", $config['cron_sendmail']); } if (ini_get("sendmail_from") != $config['email_sender']) { @ini_set("SMTP", $config['email_sender']); } } else { //SMTP } if (ini_get("SMTP") != $config['cron_smtp']) { @ini_set("SMTP", $config['cron_smtp']); } if (ini_get("smtp_port") != 25) { @ini_set("smtp_port", 25); } if ($config['multi_part'] == 0) { $file = $dump['backupdatei']; $file_name = strpos("/", $file) ? substr($file, strrpos("/", $file)) : $file; $file_type = filetype($config['paths']['backup'] . $file); $file_size = filesize($config['paths']['backup'] . $file); if ($config['email_maxsize'] > 0 && $file_size > $config['email_maxsize'] || $config['send_mail_dump'] == 0) { //anhang zu gross $subject = "Backup '" . $databases['Name'][$dump['dbindex']] . "' - " . date("d\\.m\\.Y H:i", time()); $header .= "FROM:" . $config['email_sender'] . "\n"; if (isset($config['email_recipient_cc']) && trim($config['email_recipient_cc']) > '') { $header .= "Cc: " . $config['email_recipient_cc'] . "\r\n"; } $header .= "MIME-version: 1.0\n"; $header .= "X-Mailer: PHP/" . phpversion() . "\n"; $header .= "X-Sender-IP: {$REMOTE_ADDR}\n"; $header .= "Content-Type: text/html; charset=utf-8\n"; if ($config['send_mail_dump'] != 0) { $msg_body = sprintf(addslashes($lang['L_EMAILBODY_TOOBIG']), byte_output($config['email_maxsize']), $databases['Name'][$dump['dbindex']], "{$file} (" . byte_output(filesize($config['paths']['backup'] . $file)) . ")<br>"); } else { $msg_body = sprintf(addslashes($lang['L_EMAILBODY_NOATTACH']), $databases['Name'][$dump['dbindex']], "{$file} (" . byte_output(filesize($config['paths']['backup'] . $file)) . ")"); } include_once './inc/functions.php'; $msg_body .= '<a href="' . getServerProtocol() . $_SERVER['HTTP_HOST'] . substr($_SERVER["PHP_SELF"], 0, strrpos($_SERVER["PHP_SELF"], "/")) . '/' . $config['paths']['backup'] . $file . '">' . $file . '</a>'; $email_log = "Email sent to '" . $config['email_recipient'] . "'"; $email_out = $lang['L_EMAIL_WAS_SEND'] . "`" . $config['email_recipient'] . "`<br>"; } else { //alles ok, anhang generieren $msg_body = sprintf(addslashes($lang['L_EMAILBODY_ATTACH']), $databases['Name'][$dump['dbindex']], "{$file} (" . byte_output(filesize($config['paths']['backup'] . $file)) . ")"); $subject = "Backup '" . $databases['Name'][$dump['dbindex']] . "' - " . date("d\\.m\\.Y", time()); $fp = fopen($config['paths']['backup'] . $file, "r"); $contents = fread($fp, $file_size); $encoded_file = chunk_split(base64_encode($contents)); fclose($fp); $header .= "FROM:" . $config['email_sender'] . "\n"; if (isset($config['email_recipient_cc']) && trim($config['email_recipient_cc']) > '') { $header .= "Cc: " . $config['email_recipient_cc'] . "\r\n"; } $header .= "MIME-version: 1.0\n"; $header .= "Content-type: multipart/mixed; "; $header .= "boundary=\"Message-Boundary\"\n"; $header .= "Content-transfer-encoding: 7BIT\n"; $header .= "X-attachments: {$file_name}"; $body_top = "--Message-Boundary\n"; $body_top .= "Content-type: text/html; charset=utf-8\n"; $body_top .= "Content-transfer-encoding: 7BIT\n"; $body_top .= "Content-description: Mail message body\n\n"; $msg_body = $body_top . $msg_body; $msg_body .= "\n\n--Message-Boundary\n"; $msg_body .= "Content-type: {$file_type}; name=\"{$file}\"\n"; $msg_body .= "Content-Transfer-Encoding: BASE64\n"; $msg_body .= "Content-disposition: attachment; filename=\"{$file}\"\n\n"; $msg_body .= "{$encoded_file}\n"; $msg_body .= "--Message-Boundary--\n"; $email_log = "Email was sent to '" . $config['email_recipient'] . "' with '" . $dump['backupdatei'] . "'."; $email_out = $lang['L_EMAIL_WAS_SEND'] . "`" . $config['email_recipient'] . "`" . $lang['L_WITH'] . "`" . $dump['backupdatei'] . "`.<br>"; } } else { //Multipart $mp_sub = "Backup '" . $databases['Name'][$dump['dbindex']] . "' - " . date("d\\.m\\.Y", time()); $subject = $mp_sub; $header .= "FROM:" . $config['email_sender'] . "\n"; if (isset($config['email_recipient_cc']) && trim($config['email_recipient_cc']) > '') { $header .= "Cc: " . $config['email_recipient_cc'] . "\r\n"; } $header .= "MIME-version: 1.0\n"; $header .= "X-Mailer: PHP/" . phpversion() . "\n"; $header .= "X-Sender-IP: {$REMOTE_ADDR}\n"; $header .= "Content-Type: text/html; charset=utf-8"; $dateistamm = substr($dump['backupdatei'], 0, strrpos($dump['backupdatei'], "part_")) . "part_"; $dateiendung = $config['compression'] == 1 ? ".sql.gz" : ".sql"; $mpdatei = array(); $mpfiles = ""; for ($i = 1; $i < $dump['part'] - $dump['part_offset']; $i++) { $mpdatei[$i - 1] = $dateistamm . $i . $dateiendung; $sz = byte_output(@filesize($config['paths']['backup'] . $mpdatei[$i - 1])); $mpfiles .= $mpdatei[$i - 1] . " (" . $sz . ")<br>"; } $msg_body = $config['send_mail_dump'] == 1 ? sprintf(addslashes($lang['L_EMAILBODY_MP_ATTACH']), $databases['Name'][$dump['dbindex']], $mpfiles) : sprintf(addslashes($lang['L_EMAILBODY_MP_NOATTACH']), $databases['Name'][$dump['dbindex']], $mpfiles); $email_log = "Email was sent to '" . $config['email_recipient'] . "'"; $email_out = $lang['L_EMAIL_WAS_SEND'] . "`" . $config['email_recipient'] . "`<br>"; } if (@mail($config['email_recipient'], stripslashes($subject), $msg_body, $header)) { $out .= '<span class="success">' . $email_out . '</span>'; WriteLog("{$email_log}"); } else { $out .= '<span class="error">' . $lang['L_MAILERROR'] . '</span><br>'; WriteLog("Email to '" . $config['email_recipient'] . "' failed !"); ErrorLog("Email ", $databases['Name'][$dump['dbindex']], 'Subject: ' . stripslashes($subject), $lang['L_MAILERROR']); $dump['errors']++; } if (isset($mpdatei) && $config['send_mail_dump'] == 1) { // && ($config['email_maxsize']==0 || ($config['email_maxsize']>0 && $config['multipartgroesse2']<=$config['email_maxsize']))) { for ($i = 0; $i < count($mpdatei); $i++) { $file_name = $mpdatei[$i]; $file_type = filetype($config['paths']['backup'] . $mpdatei[$i]); $file_size = filesize($config['paths']['backup'] . $mpdatei[$i]); $fp = fopen($config['paths']['backup'] . $mpdatei[$i], "r"); $contents = fread($fp, $file_size); $encoded_file = chunk_split(base64_encode($contents)); fclose($fp); $subject = $mp_sub . " [Part " . ($i + 1) . " / " . count($mpdatei) . "]"; $header = "FROM:" . $config['email_sender'] . "\n"; if (isset($config['email_recipient_cc']) && trim($config['email_recipient_cc']) > '') { $header .= "Cc: " . $config['email_recipient_cc'] . "\r\n"; } $header .= "MIME-version: 1.0\n"; $header .= "Content-type: multipart/mixed; "; $header .= "boundary=\"Message-Boundary\"\n"; $header .= "Content-transfer-encoding: 7BIT\n"; $header .= "X-attachments: {$file_name}"; $body_top = "--Message-Boundary\n"; $body_top .= "Content-type: text/html; charset=utf-8\n"; $body_top .= "Content-transfer-encoding: 7BIT\n"; $body_top .= "Content-description: Mail message body\n\n"; $msg_body = $body_top . addslashes($lang['L_EMAIL_ONLY_ATTACHMENT'] . $lang['L_EMAILBODY_FOOTER']); $msg_body .= "\n\n--Message-Boundary\n"; $msg_body .= "Content-type: {$file_type}; name=\"" . $mpdatei[$i] . "\"\n"; $msg_body .= "Content-Transfer-Encoding: BASE64\n"; $msg_body .= "Content-disposition: attachment; filename=\"" . $mpdatei[$i] . "\"\n\n"; $msg_body .= "{$encoded_file}\n"; $msg_body .= "--Message-Boundary--\n"; $email_log = "Email with {$mpdatei[$i]} was sent to '" . $config['email_recipient'] . "'"; $email_out = $lang['L_EMAIL_WAS_SEND'] . "`" . $config['email_recipient'] . "`" . $lang['L_WITH'] . "`" . $mpdatei[$i] . "`.<br>"; if (@mail($config['email_recipient'], stripslashes($subject), $msg_body, $header)) { $out .= '<span class="success">' . $email_out . '</span>'; WriteLog("{$email_log}"); } else { $out .= '<span class="error">' . $lang['L_MAILERROR'] . '</span><br>'; WriteLog("Email to '" . $config['email_recipient'] . "' failed !"); ErrorLog("Email ", $databases['Name'][$dump['dbindex']], 'Subject: ' . stripslashes($subject), $lang['L_MAILERROR']); $dump['errors']++; } } } }
public function ShowData() { //check pk and ptable are set up if (is_empty($this->GetTabledef())) { ErrorLog('Primary table not set up for ' . get_class($this)); return; } echo '<h1>' . $this->GetTitle() . '</h1>'; echo '{list.' . get_class($this) . '}'; $row = null; $num_rows = 0; if (!isset($_GET['_n_' . $this->GetModuleId()])) { $this->GetLimit($limit, $page); $dataset = $this->GetDataset(); $num_rows = $dataset->CountRecords(); $row = $dataset->GetPage($page, $limit)->fetch(); } $pagination = ''; $this->GetLimit($limit); if ($limit) { $pages = max(ceil($num_rows / $limit), 1); ob_start(); utopia::OutputPagination($pages, '_p_' . $this->GetModuleId()); $pagination = ob_get_clean(); } $records = $num_rows == 0 ? "There are no records to display." : 'Total Rows: ' . $num_rows; $pager = '<div class="right">' . $pagination . '</div>'; uEvents::TriggerEvent('OnShowDataDetail', $this); if ($this->flag_is_set(ALLOW_DELETE) && $row) { $fltr =& $this->FindFilter($this->GetPrimaryKey(), ctEQ, itNONE); $delbtn = $this->GetDeleteButton($this->GetFilterValue($fltr['uid']), 'Delete Record'); utopia::AppendVar('footer_left', $delbtn); } // if (!$this->IsNewRecord()) { // records exist, lets get the first. // pagination? // if (mysql_num_rows($result) > 1) { // multiple records exist in this set, sort out pagination // } // } $order = $this->GetSortOrder(); $extraCount = 1; $secCount = count($this->layoutSections); foreach ($this->layoutSections as $sectionID => $sectionInfo) { $out = ''; if ($secCount > 1) { $sectionName = $sectionInfo['title']; if ($sectionName === '') { if ($sectionID === 0) { $SN = 'General'; } else { $SN = "Extra ({$extraCount})"; $extraCount++; } } else { $SN = ucwords($sectionName); } $out .= '<h2>' . $SN . '</h2>'; } if (!$this->isAjax) { $out .= '<form class="uf" action="" onsubmit="this.action = window.location" method="post">'; } $out .= "<div class=\"table-wrapper\"><table class=\"module-content layoutDetailSection\">"; $fields = $this->GetFields(true, $sectionID); $hasFieldHeaders = false; foreach ($fields as $fieldName => $fieldData) { $hasFieldHeaders = $hasFieldHeaders || !empty($fieldData['visiblename']); } $fieldCount = count($fields); foreach ($fields as $fieldName => $fieldData) { $targetUrl = $this->GetTargetUrl($fieldName, $row); $out .= "<tr>"; if ($hasFieldHeaders) { $out .= "<td class=\"fld\">" . $fieldData['visiblename'] . "</td>"; } $out .= '<td>' . $this->GetCell($fieldName, $row, $targetUrl) . '</td>'; $out .= "</tr>"; } $out .= "</table></div>"; if (!$this->isAjax) { $out .= '</form>'; } echo $out; } if ($num_rows > 1) { echo '<div class="oh"><b>' . $records . '</b>' . $pager . '</div>'; } }
function Logger_Array($pointer, $arr1, $arr2 = -5, $arr3 = -5, $arr4 = -5, $arr5 = -5, $arr6 = -5, $arr7 = -5, $arr8 = -5, $arr9 = -5, $arr10 = -5, $arr11 = -5, $arr12 = -5) { $arr[0] = $arr1; $k = 1; if ($arr2 != -5) { $arr[1] = $arr2; $k++; } if ($arr3 != -5) { $arr[2] = $arr3; $k++; } if ($arr4 != -5) { $arr[3] = $arr4; $k++; } if ($arr5 != -5) { $arr[4] = $arr5; $k++; } if ($arr6 != -5) { $arr[5] = $arr6; $k++; } if ($arr7 != -5) { $arr[6] = $arr7; $k++; } if ($arr8 != -5) { $arr[7] = $arr8; $k++; } if ($arr9 != -5) { $arr[8] = $arr9; $k++; } if ($arr10 != -5) { $arr[9] = $arr10; $k++; } if ($arr11 != -5) { $arr[10] = $arr11; $k++; } if ($arr12 != -5) { $arr[11] = $arr12; $k++; } global $gLogError; global $gLogErrorFile; if ($gLogError) { $text = date('D M j G:i:s T Y') . " " . $pointer . " "; $file = $gLogErrorFile; ErrorLog($text, $file); for ($j = 0; $j < $k; $j++) { $text = " "; if (is_array($arr[$j])) { if (is_array($arr[$j][0])) { for ($i = 0; $i < count($arr[$j]); $i++) { foreach ($arr[$j][$i] as $key => $value) { $text .= $value . " "; } $text .= "\n"; } } else { for ($i = 0; $i < count($arr[$j]); $i++) { $text .= $arr[$j][$i] . " "; } } $text .= "\n"; } else { $text = $arr[$j] . "\n"; } $file = $gLogErrorFile; ErrorLog($text, $file); } } }
public function getAvailableTypes($personId, $year) { if (!checkClearanceLevel(ORGANIZER)) { return false; } // Sanitize input data $personId = sanitizeInput($personId); $year = sanitizeInput($year); $query = "SELECT * FROM type AS t WHERE NOT EXISTS (SELECT * FROM hours_extra AS he WHERE he.id_type_name=t.id && he.year={$year} && he.id_person={$personId} && NOT (t.name='Projekt' || t.name='Övrigt'))"; $result = mysql_query($query, $this->dbConn); if (!$result) { ErrorLog(mysql_error($this->dbConn)); return false; } $availableTypes = array(); while ($row = mysql_fetch_assoc($result)) { $availableTypes[$row['id']] = $row; } return $availableTypes; }
static function DrawInput($fieldName, $inputType, $defaultValue = '', $possibleValues = NULL, $attributes = NULL, $noSubmit = FALSE) { $out = ''; if ($attributes === NULL) { $attributes = array(); } // $defaultValue = str_replace(DEFAULT_CURRENCY_HTML,DEFAULT_CURRENCY,$defaultValue); // $defaultValue = str_replace(DEFAULT_CURRENCY,DEFAULT_CURRENCY_HTML,$defaultValue); // if (!isset($attributes['id'])) $attributes['id'] = $fieldName; // if(!isset($attributes['name']) && !$noSubmit) $attributes['name'] = $fieldName; $attributes['name'] = $fieldName; if (isset($attributes['class'])) { $attributes['class'] .= ' inputtype inputtype-' . $inputType; } else { $attributes['class'] = 'inputtype inputtype-' . $inputType; } $defaultValue = utopia::jsonTryDecode($defaultValue); $attr = BuildAttrString($attributes); if (isset(self::$customInputs[$inputType])) { return call_user_func_array(self::$customInputs[$inputType], array($fieldName, $inputType, $defaultValue, $possibleValues, $attributes, $noSubmit)); } switch ($inputType) { case itNONE: $out .= $defaultValue; break; case itBUTTON: if (isset($attributes['class'])) { $attributes['class'] .= ' btn'; } else { $attributes['class'] = 'btn'; } $attributes['class'] .= ' btn-' . $inputType; $attributes['class'] = str_replace('inputtype ', '', $attributes['class']); $attr = BuildAttrString($attributes); $out .= '<button' . $attr . '>' . $defaultValue . '</button>'; break; case itSUBMIT: if (isset($attributes['class'])) { $attributes['class'] .= ' btn'; } else { $attributes['class'] = 'btn'; } $attributes['class'] .= ' btn-' . $inputType; $attributes['class'] = str_replace('inputtype ', '', $attributes['class']); $attr = BuildAttrString($attributes); $out .= '<input' . $attr . ' type="submit" value="' . $defaultValue . '"/>'; break; case itRESET: if (isset($attributes['class'])) { $attributes['class'] .= ' btn'; } else { $attributes['class'] = 'btn'; } $attributes['class'] .= ' btn-' . $inputType; $attributes['class'] = str_replace('inputtype ', '', $attributes['class']); $attr = BuildAttrString($attributes); $out .= '<input' . $attr . ' type="reset" value="' . $defaultValue . '"/>'; break; case itCHECKBOX: if (is_array($possibleValues)) { $at = array(); if (isset($attributes['styles'])) { $at['styles'] = $attributes['styles']; } $at = BuildAttrString($at); if (!preg_match('/^usql\\-/', $fieldName)) { $attributes['name'] = $attributes['name'] . '[]'; $attr = BuildAttrString($attributes); } $out .= '<span' . $at . ' class="inputtype inputtype-checkboxlist">'; foreach ($possibleValues as $key => $val) { $checked = (string) $key === $defaultValue || is_array($defaultValue) && in_array($key, $defaultValue) ? ' checked="checked"' : ''; $val = htmlentities($val, ENT_COMPAT, CHARSET_ENCODING); $out .= "<label><input{$attr} type=\"checkbox\"{$checked} value=\"{$key}\"/>{$val}</label>"; } $out .= '</span>'; } else { $checked = $defaultValue == 1 ? ' checked="checked"' : ''; $out .= "<input{$attr} type=\"checkbox\"{$checked} value=\"1\"/>"; } break; case itOPTION: if (!is_array($possibleValues)) { ErrorLog('Option field specified but no possible values found'); return ''; } $count = 0; $defaultExists = false; foreach ($possibleValues as $key => $val) { $count++; $attributes['id'] = "{$fieldName}-{$count}"; $attr = BuildAttrString($attributes); $checked = $key == $defaultValue || is_array($defaultValue) && in_array($key, $defaultValue) ? ' checked="checked"' : ''; if ($checked != '') { $defaultExists = true; } $out .= "<input type=\"radio\" {$attr} value=\"{$key}\"{$checked}/>{$val}<br/>"; } if (!$defaultExists && $defaultValue != '') { $out .= "<input type=\"radio\" {$attr} value=\"{$val}\" checked=\"true\">{$defaultValue}"; } break; case itPASSWORD: case itPLAINPASSWORD: $out .= "<input type=\"password\" {$attr} value=\"\"/>"; break; case itTEXT: $defaultValue = str_replace('"', '"', $defaultValue); $out .= "<input type=\"text\" {$attr} value=\"{$defaultValue}\"/>"; break; case itTEXTAREA: //sanitise value. if (!utopia::SanitiseValue($defaultValue, 'string') && !utopia::SanitiseValue($defaultValue, 'NULL')) { $defaultValue = 'Value has been sanitised: ' . var_export($defaultValue, true); } $defaultValue = htmlentities($defaultValue, ENT_COMPAT, CHARSET_ENCODING); $out .= "<textarea {$attr}>{$defaultValue}</textarea>"; break; case itCOMBO: if (empty($possibleValues)) { $possibleValues = array(); } $out .= "<select {$attr}>"; if (!isset($possibleValues[''])) { // blank value does not exist. if (isset($attributes['placeholder']) && $attributes['placeholder'] && !isset($possibleValues[$attributes['placeholder']])) { $blankVal = $attributes['placeholder']; } else { $blankVal = ' '; } $possibleValues = array('' => $blankVal) + $possibleValues; } else { // blank value exists, ensure it is at the top. $v = $possibleValues['']; unset($possibleValues['']); $possibleValues = array('' => $v) + $possibleValues; } $defaultExists = false; if (is_array($possibleValues)) { foreach ($possibleValues as $key => $val) { if ($val === false) { continue; } $selected = ''; if ($defaultValue !== '' && (is_array($defaultValue) && in_array($key, $defaultValue) || (string) $key === (string) $defaultValue)) { $defaultExists = true; $selected = ' selected="selected"'; } $valOutput = $key !== $val ? " value=\"{$key}\"" : ''; $out .= "<option{$valOutput}{$selected}>{$val}</option>"; } } if (!$defaultExists && $defaultValue) { $out .= "<optgroup label=\"No longer available\"><option selected=\"selected\">{$defaultValue}</option></optgroup>"; } $out .= "</select>"; break; case itLISTBOX: if (!is_array($possibleValues)) { ErrorLog('Listbox field specified but no possible values found'); return ''; } $out .= "<select size=5 {$attr}><option value=\"\"></option>"; foreach ($possibleValues as $name => $val) { if (empty($val)) { continue; } $selected = $val == $defaultValue || is_array($defaultValue) && in_array($val, $defaultValue) ? ' selected="selected"' : ''; $out .= "<option value=\"{$val}\"{$selected}>{$name}</option>"; } $out .= "</select>"; break; case itFILE: //$defaultValue = htmlentities($defaultValue,ENT_QUOTES,CHARSET_ENCODING); //$defaultValue = htmlentities($defaultValue); $out .= "<input type=\"file\" {$attr}/>"; break; case itDATE: //$formattedVal = ($defaultValue === SQL_FORMAT_EMPTY_TIMESTAMP) || ($defaultValue === SQL_FORMAT_EMPTY_DATE) || ($defaultValue === NULL) || ($defaultValue === '') ? '' : $defaultValue;//date('d/m/Y',strptime($defaultValue,'d/m/Y')); $formattedVal = $defaultValue; $out .= "<input type=\"text\" {$attr} value=\"{$formattedVal}\"/>"; break; default: $defaultValue = str_replace('"', '"', $defaultValue); $out .= "<input type=\"{$inputType}\" {$attr} value=\"{$defaultValue}\"/>"; break; } return $out; }
if (!$res === false) { $anzsql = mysql_affected_rows($config['dbconnection']); // Anzahl der eingetragenen Datensaetze ermitteln (Indexaktionen nicht zaehlen) $command = strtoupper(substr($sql_command, 0, 7)); if ($command == 'INSERT ') { $anzsql = mysql_affected_rows($config['dbconnection']); if ($anzsql > 0) { $restore['eintraege_ready'] += $anzsql; } } } // Bei MySQL-Fehlern sofort abbrechen und Info ausgeben $meldung = mysql_error($config['dbconnection']); if ($meldung != '') { if (strtolower(substr($meldung, 0, 15)) == 'duplicate entry') { ErrorLog('RESTORE', $databases['db_actual'], $sql_command, $meldung, 1); $restore['notices']++; } else { if ($config['stop_with_error'] == 0) { Errorlog("RESTORE", $databases['db_actual'], $sql_command, $meldung); $restore['errors']++; } else { Errorlog("RESTORE", $databases['db_actual'], $sql_command, 'Restore failed: ' . $meldung, 0); SQLError($sql_command, $meldung); die; } } } } $a++; $dauer = time() - $restore['startzeit'];
public function Delete($query, $tablename) { $status = ""; $this->dbconnect(); $runq = mysql_query("DELETE FROM" . $query) or die($this - ErrorLog("ERROR: " . mysql_error())); // Possible Scenarios if ($runq === true) { $status = "OK"; } else { if ($runq === false) { $status = "ERROR: " . mysql_error(); } else { $status = mysql_error(); } } return $status; }
// Only update if Rank is less than expected. if ($rank < $expRank[0] || $rank > $expRank[1]) { // Rank seems to be messed up, will reset to minimum rank for this level $errmsg = "Rank Correction (" . $playerinfoData1["pID_{$x}"] . "): " . "Score:" . $score . "; " . "Expected:" . $expRank[0] . "-" . $expRank[1] . "; " . "Found:" . $playerinfoData1["rank_{$x}"] . "; " . "New Rank:" . $expRank[0]; ErrorLog($errmsg, 2); $playerinfoData1["rank_{$x}"] = $expRank[0]; } } else { // Fail-safe in-case rank data was not obtained and reset to '0' in-game. $rank = $playerinfoData1["rank_{$x}"]; $rank_db = $row['rank']; if ($rank_db > $rank) { // SNAPSHOT rank data appears to be incorrect, will use current db rank $playerinfoData1["rank_{$x}"] = $rank_db; $errmsg = "Rank Correction (" . $playerinfoData1["pID_{$x}"] . "), using db rank ({$rank_db})"; ErrorLog($errmsg, 2); } } // Calculate kill/deathstreak $killstreak = $row['killstreak'] > $playerinfoData1["ks_{$x}"] ? $row['killstreak'] : $playerinfoData1["ks_{$x}"]; $deathstreak = $row['deathstreak'] > $playerinfoData1["ds_{$x}"] ? $row['deathstreak'] : $playerinfoData1["ds_{$x}"]; // Calculate best round score $rndscore = $row['rndscore'] > $playerinfoData1["rs_{$x}"] ? $row['rndscore'] : $playerinfoData1["rs_{$x}"]; // Check if Minimal Central Update if ($centralupdate == 2) { // Ignore any Rank Data in SnapShot as this could mess up current data $playerinfoData1["rank_{$x}"] = $row['rank']; } // Calculate rank change $chng = $decr = 0; if ($playerinfoData1["rank_{$x}"] != $row['rank']) {
$query = "SELECT ip, dnshost, gport, port FROM servers WHERE bydnsname=1"; $result = mysql_query($query); checkSQLResult($result, $query); if (!mysql_num_rows($result)) { // ErrorLog("Player (".$data["pid_$x"].") not found in `subaccounts`.",3); exit; } while ($data = mysql_fetch_assoc($result)) { $newip = ""; $newip = gethostbyname($data['dnshost']); if ($newip != $data['dnshost']) { if ($newip == $data['ip']) { //ErrorLog("NOT CHANGE ".$data['dnshost']." == ".$data['ip'],3); } else { $query1 = "SELECT id FROM servers WHERE ip='" . $newip . "' AND gport='" . $data['gport'] . "' AND port='" . $data['port'] . "'"; $result1 = mysql_query($query1); checkSQLResult($result1, $query1); if (mysql_num_rows($result1)) { while ($data1 = mysql_fetch_assoc($result1)) { $query1a = "DELETE FROM servers WHERE id='" . $data1['id'] . "'"; $result1a = mysql_query($query1a); checkSQLResult($result1a, $query1a); } } ErrorLog("CHANGE " . $data['dnshost'] . " == " . $data['ip'] . " => " . $newip, 3); $query2 = "UPDATE servers VALUE SET ip='" . $newip . "' WHERE dnshost='" . $data['dnshost'] . "'"; $result2 = mysql_query($query2); checkSQLResult($result2, $query2); } } }
if (file_exists($fn_src)) { if (file_exists($fn_dest)) { $errmsg = "SNAPSHOT Data File Already Exists, Over-writing! ({$fn_src} -> {$fn_dest})"; ErrorLog($errmsg, 2); } copy($fn_src, $fn_dest); // Remove the original ONLY if it copies if (file_exists($fn_dest)) { unlink($fn_src); } } $errmsg = "SNAPSHOT Data File Moved! ({$fn_src} -> {$fn_dest})"; ErrorLog($errmsg, 3); } $errmsg = "SNAPSHOT Data File Processed: {$stats_filename}"; ErrorLog($errmsg, -1); } // Close database connection @mysql_close($connection); /* * ************************************************** * Helper Functions Not Used * * ************************************************** */ // Compile Awards from SNAPSHOT function getAwards() { global $data, $x, $awards, $awardsdata; foreach ($awardsdata as $award) { $awdkey = $award[1] . "_{$x}"; if (isset($data[$awdkey])) { $awards[] = $award[0]; $awards[] = $award[2] == 0 ? $data[$awdkey] : $award[2];
function checkSQLResult($result, $query) { if (!$result) { $msg = 'ERROR: ' . mysql_error() . "\n"; $msg .= 'Query String: ' . $query; ErrorLog($msg, 1); return 1; } else { return 0; } }
function checkSQLResult($result, $query) { if (!$result) { $msg = mysql_errno() . ':' . mysql_error() . ' Query String: ' . $query; ErrorLog($msg, 1); return 1; } else { return 0; } }
include_once "../database/initSetting.php"; if (isset($_POST) && isset($_POST['method'])) { $post = $_POST; } else { echo "not defined"; exit; } $method = $post['method']; switch ($method) { case "SaveSchedule": $param = array("scheduleTime" => $post['B64_scheduleTime'], "shiftSchedule" => $post['B64_schedule']); $nFID = $post['fid']; $aryResult = array(); $nErrorCode = GetDBData('SaveShiftSchedule', $nFID, $param, $aryResult); ErrorLog($nErrorCode); $result = array("result" => "success", "data" => $aryResult); print_r(json_encode($result)); break; case "LoadSchedule": $fid = isset($post['fid']) == true ? $post['fid'] : 0; //get fid from cncid if ($fid === 0) { $nCNCID = $post['cncid']; $result_fid = array(); $nErrorCode = GetDBData('cncGetFactoryID', $nCNCID, array(), $result_fid); $fid = $result_fid; } $nFID = $fid; $aryResult = array(); $nErrorCode = GetDBData('GetShiftSchedule', $nFID, array(), $aryResult);