=0)
{
if ($pageNum_Recordset1 > ceil($max_links/2))
{
$fgp = $pageNum_Recordset1 - ceil($max_links/2) > 0 ? $pageNum_Recordset1 - ceil($max_links/2) : 1;
$egp = $pageNum_Recordset1 + ceil($max_links/2);
if ($egp >= $totalPages_Recordset1)
{
$egp = $totalPages_Recordset1+1;
$fgp = $totalPages_Recordset1 - ($max_links-1) > 0 ? $totalPages_Recordset1 - ($max_links-1) : 1;
}
}
else {
$fgp = 0;
$egp = $totalPages_Recordset1 >= $max_links ? $max_links : $totalPages_Recordset1+1;
}
if($totalPages_Recordset1 >= 1) {
$_get_vars = '';
if(!empty($_GET) || !empty($HTTP_GET_VARS)){
$_GET = empty($_GET) ? $HTTP_GET_VARS : $_GET;
foreach ($_GET as $_get_name => $_get_value) {
if ($_get_name != "pageNum_news") {
$_get_vars .= "&$_get_name=$_get_value";
}
}
}
$successivo = $pageNum_Recordset1+1;
$precedente = $pageNum_Recordset1-1;
$firstArray = ($pageNum_Recordset1 > 0) ? "$prev_Recordset1 " : "$prev_Recordset1";
for($a = $fgp+1; $a <= $egp; $a++){
$theNext = $a-1;
if($show_page)
{
$textLink = $a;
} else {
$min_l = (($a-1)*$maxRows_news) + 1;
$max_l = ($a*$maxRows_news >= $totalRows_news) ? $totalRows_news : ($a*$maxRows_news);
$textLink = "$min_l - $max_l";
}
$_ss_k = floor($theNext/26);
if ($theNext != $pageNum_Recordset1)
{
$pagesArray .= "";
$pagesArray .= "$textLink " . ($theNext < $egp-1 ? $separator : "");
} else {
$pagesArray .= "$textLink " . ($theNext < $egp-1 ? $separator : "");
}
}
$theNext = $pageNum_Recordset1+1;
$offset_end = $totalPages_Recordset1;
$lastArray = ($pageNum_Recordset1 < $totalPages_Recordset1) ? "$next_Recordset1 " : "$next_Recordset1";
}
}
return array($firstArray,$pagesArray,$lastArray);
}
?>
addField("email", true, "text", "email", "", "", "Inserire un indirizzo email valido!");
$formValidation->addField("privacy", true, "", "", "", "", "Per proseguire è necessario accettare la normativa di legge vigente in materia di privacy!");
$tNGs->prepareValidation($formValidation);
// End trigger
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$maxRows_categorie = 5;
$pageNum_categorie = 0;
if (isset($_GET['pageNum_categorie'])) {
$pageNum_categorie = $_GET['pageNum_categorie'];
}
$startRow_categorie = $pageNum_categorie * $maxRows_categorie;
mysql_select_db($database_domuscoop, $domuscoop);
$query_categorie = "SELECT * FROM domuscoop_cat ORDER BY ordinamento ASC";
$query_limit_categorie = sprintf("%s LIMIT %d, %d", $query_categorie, $startRow_categorie, $maxRows_categorie);
$categorie = mysql_query($query_limit_categorie, $domuscoop) or die(mysql_error());
$row_categorie = mysql_fetch_assoc($categorie);
if (isset($_GET['totalRows_categorie'])) {
$totalRows_categorie = $_GET['totalRows_categorie'];
} else {
$all_categorie = mysql_query($query_categorie);
$totalRows_categorie = mysql_num_rows($all_categorie);
}
$totalPages_categorie = ceil($totalRows_categorie/$maxRows_categorie)-1;
$colname_sottocategorie = "-1";
if (isset($_GET['cat'])) {
$colname_sottocategorie = (get_magic_quotes_gpc()) ? $_GET['cat'] : addslashes($_GET['cat']);
}
mysql_select_db($database_domuscoop, $domuscoop);
$query_sottocategorie = sprintf("SELECT * FROM domuscoop_subcat WHERE id_rel = %s ORDER BY ordinamento ASC", GetSQLValueString($colname_sottocategorie, "int"));
$sottocategorie = mysql_query($query_sottocategorie, $domuscoop) or die(mysql_error());
$row_sottocategorie = mysql_fetch_assoc($sottocategorie);
$totalRows_sottocategorie = mysql_num_rows($sottocategorie);
mysql_select_db($database_domuscoop, $domuscoop);
$query_subcat_1 = "SELECT id FROM domuscoop_subcat WHERE id_rel = 1 LIMIT 1";
$subcat_1 = mysql_query($query_subcat_1, $domuscoop) or die(mysql_error());
$row_subcat_1 = mysql_fetch_assoc($subcat_1);
$totalRows_subcat_1 = mysql_num_rows($subcat_1);
mysql_select_db($database_domuscoop, $domuscoop);
$query_subcat_2 = "SELECT id FROM domuscoop_subcat WHERE id_rel = 2 LIMIT 1";
$subcat_2 = mysql_query($query_subcat_2, $domuscoop) or die(mysql_error());
$row_subcat_2 = mysql_fetch_assoc($subcat_2);
$totalRows_subcat_2 = mysql_num_rows($subcat_2);
mysql_select_db($database_domuscoop, $domuscoop);
$query_subcat_3 = "SELECT id FROM domuscoop_subcat WHERE id_rel = 3 LIMIT 1";
$subcat_3 = mysql_query($query_subcat_3, $domuscoop) or die(mysql_error());
$row_subcat_3 = mysql_fetch_assoc($subcat_3);
$totalRows_subcat_3 = mysql_num_rows($subcat_3);
mysql_select_db($database_domuscoop, $domuscoop);
$query_subcat_4 = "SELECT id FROM domuscoop_subcat WHERE id_rel = 4 LIMIT 1";
$subcat_4 = mysql_query($query_subcat_4, $domuscoop) or die(mysql_error());
$row_subcat_4 = mysql_fetch_assoc($subcat_4);
$totalRows_subcat_4 = mysql_num_rows($subcat_4);
mysql_select_db($database_domuscoop, $domuscoop);
$query_subcat_5 = "SELECT id FROM domuscoop_subcat WHERE id_rel = 5 LIMIT 1";
$subcat_5 = mysql_query($query_subcat_5, $domuscoop) or die(mysql_error());
$row_subcat_5 = mysql_fetch_assoc($subcat_5);
$totalRows_subcat_5 = mysql_num_rows($subcat_5);
mysql_select_db($database_domuscoop, $domuscoop);
$query_sub_index = "SELECT * FROM domuscoop_subcat WHERE id_rel = 6 ORDER BY ordinamento ASC";
$sub_index = mysql_query($query_sub_index, $domuscoop) or die(mysql_error());
$row_sub_index = mysql_fetch_assoc($sub_index);
$totalRows_sub_index = mysql_num_rows($sub_index);
$maxRows_news = 2;
$pageNum_news = 0;
if (isset($_GET['pageNum_news'])) {
$pageNum_news = $_GET['pageNum_news'];
}
$startRow_news = $pageNum_news * $maxRows_news;
mysql_select_db($database_domuscoop, $domuscoop);
$query_news = "SELECT * FROM domuscoop_news ORDER BY `data` DESC";
$query_limit_news = sprintf("%s LIMIT %d, %d", $query_news, $startRow_news, $maxRows_news);
$news = mysql_query($query_limit_news, $domuscoop) or die(mysql_error());
$row_news = mysql_fetch_assoc($news);
if (isset($_GET['totalRows_news'])) {
$totalRows_news = $_GET['totalRows_news'];
} else {
$all_news = mysql_query($query_news);
$totalRows_news = mysql_num_rows($all_news);
}
$totalPages_news = ceil($totalRows_news/$maxRows_news)-1;
// Make an insert transaction instance
$ins_domuscoop_newsletter = new tNG_insert($conn_domuscoop);
$tNGs->addTransaction($ins_domuscoop_newsletter);
// Register triggers
$ins_domuscoop_newsletter->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_domuscoop_newsletter->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_domuscoop_newsletter->registerTrigger("END", "Trigger_Default_Redirect", 99, "newsletter_ok.php");
// Add columns
$ins_domuscoop_newsletter->setTable("domuscoop_newsletter");
$ins_domuscoop_newsletter->addColumn("email", "STRING_TYPE", "POST", "email");
$ins_domuscoop_newsletter->addColumn("privacy", "CHECKBOX_1_0_TYPE", "POST", "privacy", "0");
$ins_domuscoop_newsletter->setPrimaryKey("id", "NUMERIC_TYPE");
// Execute all the registered transactions
$tNGs->executeTransactions();
// Get the transaction recordset
$rsdomuscoop_newsletter = $tNGs->getRecordset("domuscoop_newsletter");
$row_rsdomuscoop_newsletter = mysql_fetch_assoc($rsdomuscoop_newsletter);
$totalRows_rsdomuscoop_newsletter = mysql_num_rows($rsdomuscoop_newsletter);
?>
DomusCoop | Beta
Iscrizione Newsletter
Il servizio newsletter offre la possibilità di ricevere periodicamente una e-mail contenente novità e informazioni relative alle iniziative della Domus Coop e delle realtà ad essa collegate.
Per iscriversi inserire il proprio indirizzo e-mail, nome, cognome e indirizzo postale. Al termine è sufficiente premere il pulsante "Iscriviti" e si verrà inseriti nella mailing list.
include("footer.php"); ?>