private function setFormValuesArray($md_values) { setMickaLog("data", 'DEBUG', 'MdRecord.setFormValuesArray'); $rs = array(); if (is_array($md_values) && count($md_values) > 0) { foreach ($md_values as $row) { $md_path = getMdPath($row['MD_PATH']); if ($this->mds == 0 || $this->mds == 10) { if ($row['MD_ID'] == 5527 && strlen(trim($row['MD_VALUE'])) == 3) { $this->md_first_lang = trim($row['MD_VALUE']); } } $eval_text = '$rs' . $md_path . "['" . $row['LANG'] . "']" . "=\"" . gpc_addslashes($row['MD_VALUE']) . "\";"; eval($eval_text); } } $this->sortMdLangs(); $this->form_values = $rs; //my_print_r($rs); }
<?php /** * Licensed under WTFPL - DoWhatTheFuckYouWant Public License * - Jesús García Sáez 2009- <*****@*****.**> * - Hugues Hiegel 2006-2008 <*****@*****.**> */ ini_set('display_errors', 1); error_reporting(E_ALL | E_STRICT); // get the parameters and initial setup $username_orig = $_GET['user']; $username = gpc_addslashes(strtolower($username_orig)); $type = $_GET['type']; $style = $_GET['style']; $color = $_GET['color']; include "Config.php"; // default values will be setted if they aren't defined clearstatcache(); mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS); mysql_select_db(MYSQL_DB); // fetch data for badget output $res = mysql_query("SELECT * FROM users WHERE username='******'"); $data = mysql_fetch_assoc($res); $exists_user = mysql_num_rows($res) > 0; $expired_cache = $data["lastupdate"] && $data["lastupdate"] + CACHE < time(); if (!$exists_user || $expired_cache) { $data = make_db_cache($username); } // generate badget if needed $output_badge = CACHE_FOLDER . "/" . image_filename(); if (!$data) {
public function getXmlTmpMd($uuid) { setMickaLog("uuid={$uuid}", 'FUNCTION', "MdExport.getXmlTmpMd.start"); $vysl = array(); $recno_arr = array(); $elements_label = $this->getIdElements(); // nacteni elementu pro prevod na kody $sql = array(); $tmp_table_md = TMPTABLE_PREFIX . '_md'; $tmp_table_md_values = TMPTABLE_PREFIX . '_md_values'; array_push($sql, "\n\t\t\tSELECT {$tmp_table_md_values}.recno, {$tmp_table_md_values}.md_path, " . setNtext2Text($tmp_table_md_values . '.', 'md_value') . ", {$tmp_table_md_values}.lang, {$tmp_table_md}.md_standard\n\t\t\tFROM ({$tmp_table_md} JOIN {$tmp_table_md_values} ON {$tmp_table_md}.recno = {$tmp_table_md_values}.recno)\n\t\t\t\tJOIN standard ON {$tmp_table_md}.md_standard = standard.md_standard\n\t\t\tWHERE {$tmp_table_md}.sid=%s and {$tmp_table_md}.uuid=%s\n\t\t\tORDER BY {$tmp_table_md_values}.md_path\n\t\t", $this->sid, $uuid); $result = DB_DRIVER == 'oracle' ? _executeSql('select', array($sql), array('assoc', 'RECNO,#,=')) : _executeSql('select', array($sql), array('assoc', 'recno,#,=')); //$result = _executeSql('select', array($pom['sql']), array('assoc', 'recno,#,=')); $eval_text = ''; foreach ($result as $recno => $data) { $recno_arr[] = $recno; // seznam recno foreach ($data as $idx => $row) { if ($row['MD_PATH'] == '') { continue; } $mds = $row['MD_STANDARD']; if ($mds - 10 > -1) { $mds = $mds - 10; } $path_arr = explode('_', substr($row['MD_PATH'], 0, strlen($row['MD_PATH']) - 1)); $eval_text_tmp = '$vysl[' . $recno . ']'; foreach ($path_arr as $key => $value) { if ($key % 2 == 0) { $eval_text_tmp .= "['" . $elements_label[$mds][$value] . "']"; } else { $eval_text_tmp .= '[' . $value . ']'; } } $eval_text_tmp .= "['!" . $row['LANG'] . "']=" . '"' . gpc_addslashes($row['MD_VALUE']) . '";' . "\n"; $eval_text .= $eval_text_tmp; } } eval($eval_text); $this->md = array(); $this->setMdHeader($recno_arr); $this->printMDXML($vysl); setMickaLog($this->rs_xml, 'DEBUG', "MdExport.getXmlTmpMd.return"); return $this->rs_xml; }