if($_SERVER['HTTPS'] == 'on') header("Location: http://www.giorgiosoave.it/tecnicamista.php"); function my_query($query, $defs) { $ini = @parse_ini_file($defs); $ini['Sqlhost'] = 'localhost'; $ini['Sqluser'] = 'pco1m4v3_gsoavex'; $ini['Sqldatabase'] = 'pco1m4v3_gsoave'; $ini['Sqlpass'] = '2_h72Mn5i'; $conn_id = @mysql_pconnect($ini['Sqlhost'], $ini['Sqluser'], $ini['Sqlpass']) or die(mysql_errno() . ": " . mysql_error() . "\n"); $query = trim($query); $query = ereg_replace('[ ]{1,}', ' ', $query); $query = ereg_replace('\([ ]{1,}', '(', $query); $query = ereg_replace('[ ]{1,}\)', ')', $query); while(strpos(strtoupper($query), "(SELECT ")) { $i = 0; $n = 0; $l = $substart = strlen($query) - strpos(strtoupper(strrev($query)), " TCELES(") - 8; while ($l < strlen($query)) { $x = substr($query, $l++, 1); if ($x == "(") $n++; if ($x == ")") $n--; if ($n == 0) break; } $res_id = @mysql_db_query($ini['Sqldatabase'], substr($query, $substart + 1, $l - $substart - 2), $conn_id) or die (mysql_errno() . ": " . mysql_error() . "\n"); while ($y = mysql_fetch_row($res_id)) $buff[0][$i++] = $y[0]; $query = substr($query, 0, $substart)."('".implode("','", $buff[0])."')".substr($query, $l); unset($buff); } $i = 0; $res_id = @mysql_db_query($ini['Sqldatabase'], $query, $conn_id) or die (mysql_errno() . ": " . mysql_error() . "\n"); if (strpos(strtoupper($query), 'INSERT') === 0 || strpos(strtoupper($query), 'UPDATE') === 0) $res_id = @mysql_db_query($ini['Sqldatabase'], "SELECT LAST_INSERT_ID()", $conn_id); while ($y = mysql_fetch_array($res_id, MYSQL_BOTH)) $buff[$i++] = $y; @mysql_free_result($res_id); return $buff; } $query = "SELECT a.lang_value, a.glossario_id as id FROM glossario_lang as a JOIN glossario as b ON a.glossario_id=b.id_glossario AND b.publish = '1' WHERE a.lang_id = '1' AND lang_key = 'titolo' ORDER BY a.glossario_id DESC"; $buff = my_query($query, ''); ?>