source: trunk/client/modules.php@ 352

Last change on this file since 352 was 345, checked in by roby, 3 years ago

correzione su funzione di scarico liste
File size: 9.5 KB
Line 
1<?php
2
3/************************************************************************/
4/* Eleonline - Raccolta e diffusione dei dati elettorali */
5/* by Luciano Apolito & Roberto Gigli */
6/* http://www.eleonline.it */
7/* info@eleonline.it luciano@aniene.net rgigli@libero.it */
8/************************************************************************/
9
10define('MODULE_FILE', true);
11
12// Additional security (Union, CLike, XSS)
13// We want to use the function stripos,
14// but thats only available since PHP5.
15// So we cloned the function...
16if(!function_exists('stripos')) {
17 function stripos_clone($haystack, $needle, $offset=0) {
18 return strpos(strtoupper($haystack), strtoupper($needle), $offset);
19 }
20} else {
21// But when this is PHP5, we use the original function
22 function stripos_clone($haystack, $needle, $offset=0) {
23 return stripos($haystack, $needle, $offset=0);
24 }
25}
26
27 if(isset($_SERVER['QUERY_STRING']) && (!stripos_clone($_SERVER['QUERY_STRING'], "ad_click") || !stripos_clone($_SERVER['QUERY_STRING'], "url"))) {
28 $queryString = $_SERVER['QUERY_STRING'];
29 if (stripos_clone($queryString,'%20union%20') OR stripos_clone($queryString,'..') OR stripos_clone($queryString,'+') OR stripos_clone($queryString,'/*') OR stripos_clone($queryString,'*/union/*') OR stripos_clone($queryString,'c2nyaxb0') OR stripos_clone($queryString,'+union+') OR stripos_clone($queryString,'http://') OR (stripos_clone($queryString,'cmd=') AND !stripos_clone($queryString,'&cmd')) OR (stripos_clone($queryString,'exec') AND !stripos_clone($queryString,'execu')) OR stripos_clone($queryString,'concat')) {
30 die('Operazione non consentita');
31 }
32 }
33
34foreach ($_GET as $sec_key => $secvalue) {
35 if ((preg_match("/<[^>]*script*\"?[^>]*>/i",$secvalue)) ||
36 (preg_match("/<[^>]*object*\"?[^>]*>/i", $secvalue)) ||
37 (preg_match("/<[^>]*iframe*\"?[^>]*>/i", $secvalue)) ||
38 (preg_match("/<[^>]*applet*\"?[^>]*>/i", $secvalue)) ||
39 (preg_match("/<[^>]*meta*\"?[^>]*>/i", $secvalue)) ||
40 (preg_match("/<[^>]*style*\"?[^>]*>/i", $secvalue)) ||
41 (preg_match("/<[^>]*form*\"?[^>]*>/i", $secvalue)) ||
42 (preg_match("/<[^>]*img*\"?[^>]*>/i", $secvalue)) ||
43 (preg_match("/<[^>]*onmouseover*\"?[^>]*>/i", $secvalue)) ||
44 (preg_match("/<[^>]*body*\"?[^>]*>/i", $secvalue)) ||
45 (preg_match("/\([^>]*\"?[^)]*\)/", $secvalue)) ||
46 (preg_match("/\"/", $secvalue)) ||
47 (preg_match("/inside_mod/i", $sec_key))) {
48 die ("Operazione non consentita");
49 }
50 }
51
52 foreach ($_POST as $secvalue) {
53 if ((preg_match("/<[^>]*onmouseover*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]script*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]*body*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]style*\"?[^>]*>/i", $secvalue))) {
54 die ($htmltags);
55 }
56 }
57
58// Posting from other servers in not allowed
59// Fix by Quake
60// Bug found by PeNdEjO
61if ($_SERVER['REQUEST_METHOD'] == "POST") {
62 if (isset($_SERVER['HTTP_REFERER'])) {
63 if (!stripos_clone($_SERVER['HTTP_REFERER'], $_SERVER['HTTP_HOST'])) {
64 die('Posting da un altro server non consentito!');
65 } else {
66# die('<b>Attenzione:</b> il tuo browser non puo inviare gli header HTTP_REFERER al website.<br/>');
67 }
68 }
69}
70
71function jsexist(){ // controlla javascript by l.apolito 2008
72global $op,$name;
73if(!isset($_GET['js'])){
74$querystring= @preg_replace('/'.$_SERVER['DOCUMENT_ROOT'].'/i','http://'.$_SERVER['HTTP_HOST'].'/',$_SERVER['SCRIPT_FILENAME']);
75if (preg_match("/modules.php/i",$_SERVER['SCRIPT_NAME'])) $pagina="name=$name"; // reindirizza
76if (preg_match("/admin.php/i",$_SERVER['SCRIPT_NAME'])) $pagina="op=$op"; // reindirizza
77 echo "<noscript><meta http-equiv=\"refresh\" content=\"0; url=".$querystring."?js=b&amp;$pagina\"/></noscript>";
78 }
79$js=$_GET['js'];
80return $js;
81}
82
83
84
85
86
87
88session_start();//MODIFICHE PER GESTIONE SESSIONI
89// apre database
90////////////////////////
91if (file_exists("config.php")) { @require_once("config.php");$install="";}else{ $install="1";}
92
93
94
95# verifica se effettuata la configurazione
96if(empty($dbname) || $install=="1") {
97 die("<html><body><div style=\"text-align:center\"><br /><br /><img src=\"modules/Elezioni/images/logo.jpg\" alt=\"Eleonline\" title=\"Eleonline\"><br /><br /><strong>Sembra che <a href='http://www.eleonline.it' title='Eleonline'>Eleonline</a> non sia stato ancora installato.<br /><br />Puoi procedere <a href='../install/index.php'>cliccando qui</a> per iniziare l'installazione</strong></div></body></html>");
98}
99
100
101$dbi = new PDO("mysql:host=$dbhost;charset=latin1", $dbuname, $dbpass, array(PDO::ATTR_EMULATE_PREPARES => false,
102 PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION));
103$sql = "use $dbname";
104$dbi->exec($sql);
105
106# protezione csrf ottobre 2012 - by l.apolito
107if (file_exists("inc/csrf-magic/csrf-magic.php")) {
108 include_once 'inc/csrf-magic/csrf-magic.php';
109}
110
111
112
113
114
115
116# carica i parametri di default sulla tabella
117$sql = $dbi->prepare("SELECT * FROM ".$prefix."_config");
118$sql->execute();
119while($riga = $sql->fetchAll(PDO::FETCH_ASSOC)){$row=$riga[0];
120$sitename = stripslashes($row['sitename']);
121$siteurl = $row['siteurl'];
122$site_logo = $row['site_logo'];
123$startdate = $row['startdate'];
124$adminmail = $row['adminmail'];
125$tema = $row['tema'];
126$language = $row['language'];
127$blocco = intval($row['blocco']);
128$fileout = intval($row['fileout']);
129$copyright = $row['copyright'];
130$Versione = $row['versione'];
131$patch = $row['patch'];
132$siteistat = intval($row['siteistat']);
133$multicomune = intval($row['multicomune']);
134$flash = intval($row['flash']);
135$displayerrors = $row['displayerrors'];
136$gkey = $row['gkey'];
137$googlemaps = intval($row['googlemaps']);
138$editor = intval($row['editor']);
139$tema_on = intval($row['tema_on']);
140$ed_user = $row['ed_user'];
141#tema mobile
142}
143
144
145
146# altre config
147$sql = $dbi->prepare("SELECT * FROM ".$prefix."_ele_comuni where id_comune='$siteistat' ");
148$sql->execute();
149$riga = $sql->fetchAll(PDO::FETCH_ASSOC);
150$row=$riga[0];
151$id_cons_pred = intval($row['id_cons']);
152if($id_cons_pred=='0')$id_cons_pred='';
153if(!isset($id_cons_gen)) $id_cons_gen=$id_cons_pred;
154# carica il metodo d'hontd
155##$sql = $dbi->prepare("SELECT * FROM ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' ");
156##$sql->execute();
157
158$param=strip_tags(strtolower($_SERVER['REQUEST_METHOD'])) == 'get' ? $_GET : $_POST;
159////////////////////
160#funzione di backup
161if (isset($param['op']) and $param['op']=='backup')
162{
163$id_cons_bak=intval($param['id_cons_gen']);
164if (isset($param['id_comune'])) $id_combak=intval($param['id_comune']); else $id_combak=$_SESSION['id_comune'];
165$sql = $dbi->prepare("SELECT id_cons,id_conf FROM ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_bak' and id_comune='$id_combak'");
166$sql->execute();
167list($id_cons,$hondt) = $sql->fetch(PDO::FETCH_NUM);
168
169// incluso in consiglieri.php, ma io carico le vecchie variabili per compatibilit'a all'indietro
170if($hondt>=1){
171# proiezione consiglio
172 $res2 = $dbi->prepare("SELECT * FROM ".$prefix."_ele_conf where id_conf='$hondt'");
173 $res2->execute();
174 $row=$res2->fetch(PDO::FETCH_ASSOC);
175
176 $descrizione_consiglio = $row['descrizione'];
177 $LIMITE = intval($row['limite']);
178 $CONSIN = intval($row['consin']);
179 $INFPREMIO=intval($row['infpremio']);
180 $SUPSBARRAMENTO=intval($row['supsbarramento']);
181 $SUPMINPREMIO=intval($row['supminpremio']);
182 $SUPPREMIO=intval($row['suppremio']);
183 $LISTINFSBAR=intval($row['listinfsbar']);
184 $LISTINFCONTA=intval($row['listinfconta']);
185 $LISTSUPCONTA=intval($row['listsupconta']);
186 $SUPMINPREMIO=intval($row['supminpremio']);
187 $INFMINPREMIO=intval($row['infminpremio']);
188}
189
190
191include("modules/Elezioni/backup.php");
192die();
193}
194///////////////////
195// lingua x demo
196if (isset($param['newl'])){
197 $newl=$param['newl'];
198 if (file_exists("modules/Elezioni/language/lang-$newl.php")){ $lang=$newl;$_SESSION['newl']="$lang";
199 }
200}
201
202// seesioni per flash, blocco e linguaggio, tour
203
204if (isset($param['block'])){
205 $blocco=$param['block'];
206 $_SESSION['newblock']="$blocco";
207 }
208if (isset($_SESSION['newblock'])) $blocco=$_SESSION['newblock'];
209
210
211
212// linguaggio
213if (isset($_SESSION['newl'])) $lang=$_SESSION['newl'];
214//else $lang=$lang;
215if (! isset($lang)) $lang=$language;
216if (strlen($lang)!=2) $lang=$language;
217
218// flash x demo
219if (isset($param['flash'])){
220 $flash=$param['flash'];
221 $_SESSION['newflash']="$flash";
222 }
223if (isset($_SESSION['newflash'])) $flash=$_SESSION['newflash'];
224
225if (isset($param['tema'])){
226 $tema=$param['tema'];
227 $tema=htmlentities($tema); // evita xss
228 if(preg_match("/%/i", $tema)) $tema="default";// evita xss
229 $_SESSION['newtema']="$tema";
230
231 }
232if (isset($_SESSION['newtema'])) {
233 $tema=$_SESSION['newtema'];
234 if (preg_match("/%/i",$_SESSION['newtema'])) $_SESSION['newtema']="default"; // xss
235}
236
237//ritorno disabilita tema cellulare dal file backtoapp e dal footer lo riattiva
238if (isset($param['nocell'])){
239$nocell=$param['nocell'];
240$_SESSION['newcell']="$nocell";
241}
242if (isset($_SESSION['newcell'])) $nocell=$_SESSION['newcell'];
243
244
245
246
247
248$PHP_SELF=$_SERVER['PHP_SELF'];
249$file=(isset($_GET['file'])) ? htmlentities($_GET['file']):"index";
250$name=(isset($_GET['name'])) ? htmlentities($_GET['name']):"Elezioni";
251$op=(isset($_GET['op'])) ? htmlentities($_GET['op']):"gruppo";
252if (!isset($_GET['op'])) $_GET['op']="gruppo";
253
254$modpath = "modules/$name/$file.php";
255if (file_exists($modpath)) {
256 include($modpath);
257} else {
258 die ("Sorry, such file doesn't exist...:$modpath");
259}
260
261
262
263
264
265
266
267?>
Note: See TracBrowser for help on using the repository browser.