From 19985dbb8c0aa66dc4bf7905abc1148de909097d Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Anton=20Luka=20=C5=A0ijanec?= <anton@sijanec.eu>
Date: Tue, 11 Jan 2022 12:35:47 +0100
Subject: prvi-commit

---
 admin/survey/parapodatki.php | 671 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 671 insertions(+)
 create mode 100644 admin/survey/parapodatki.php

(limited to 'admin/survey/parapodatki.php')

diff --git a/admin/survey/parapodatki.php b/admin/survey/parapodatki.php
new file mode 100644
index 0000000..b1615cd
--- /dev/null
+++ b/admin/survey/parapodatki.php
@@ -0,0 +1,671 @@
+<?php
+
+include_once('../../function.php');
+define('delimiter', ';');
+
+header('Content-type: text/csv; charset=UTF-8');
+header('Content-Disposition: attachment; filename="ankete.csv"');
+header('Pragma: public');
+header('Expires: 0');
+header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
+header('Cache-Control: private',false);
+header('Content-Transfer-Encoding:­ binary');
+
+echo "\xEF\xBB\xBF";
+
+
+if ($_GET['a'] == 'nejc' || $_GET['a'] == 'parapodatki') {
+	
+	echo 'ID SURVEY'.delimiter;
+	echo 'ID USER'.delimiter;
+	echo 'RECNUM'.delimiter;
+	echo 'TIMESTAMP'.delimiter;
+	echo 'EVENT'.delimiter;
+	echo 'PAGE'.delimiter;
+	echo 'QUESTION'.delimiter;
+	echo 'ITEM'.delimiter;
+	echo "\n";
+	
+	if (isset($_GET['anketa'])) $where = " AND p.ank_id = '$_GET[anketa]'";
+	else $where = '';
+	$sql = sisplet_query("SELECT p.*, u.recnum  FROM srv_parapodatki p, srv_user u WHERE u.id=p.usr_id $where ORDER BY p.id ASC");
+	while ($row = mysqli_fetch_array($sql)) {
+		echo $row['ank_id'].delimiter;
+		echo $row['usr_id'].delimiter;
+		echo $row['recnum'].delimiter;
+		echo $row['datetime'].delimiter;
+		echo $row['what'].delimiter;
+		echo $row['gru_id'].delimiter;
+		echo $row['spr_id'].delimiter;
+		echo $row['item'].delimiter;
+		
+		echo "\n";
+	}
+	die();
+}
+
+
+//sisplet_query("USE www1kasi_2011");
+
+if (isset($_GET['anketa'])) {
+	// ID ankete
+	if (is_numeric($_GET['anketa'])) {
+		$ids = array((int)$_GET['anketa']);
+
+	// ankete poberemo iz baze
+	} else {
+		
+		if ($_GET['anketa'] == 'users') {
+			
+			$ids = array();
+			$sql = sisplet_query("SELECT DISTINCT ank_id FROM srv_user WHERE last_status IN ('0', '1', '2')");
+			while ($row = mysqli_fetch_array($sql)) {
+				$ids[] = $row['ank_id'];
+			}	
+		}
+		elseif ($_GET['anketa'] == 'huge') {
+			
+			$ids = array(12102,12248,12245,12212,12177,12152,11842,11795,11707,11653,10986,10968,10951,10879,10863,10493,10199,10022,12251,12188,12159,12123,12039,11933,11766,11489,11405,11386,11375,11124,10981,10881,10836,10822,10463,10457,10414,10404,10372,10280,9982,9903,12362,12354,12340,12307,12285,12283,12255,12253,12249,12223,12202,12199,12197,12189,12187,12185,12183,12176,12153,12139,12132,12113,12112,12109,12108,12096,12093,12075,12056,12053,12048,12038,12034,12033,12026,12022,12020,12018,11965,11953,11934,11918,11907,11892,11882,11881,11876,11841,11831,11825,11824,11815,11792,11784,11783,11778,11762,11754,11749,11748,11712,11697,11691,11685,11683,11680,11676,11667,11661,11652,11650,11649,11635,11632,11613,11584,11581,11580,11575,11559,11551,11536,11531,11528,11522,11518,11516,11508,11490,11466,11464,11463,11439,11438,11431,11422,11420,11419,11390,11379,11378,11377,11374,11365,11347,11346,11345,11339,11318,11317,11249,11234,11232,11225,11228,11174,11151,11153,11135,11130,11125,11122,11120,11111,11075,11072,11070,11068,11067,11050,11048,11027,11013,11012,11001,10995,10992,10990,10988,10983,10975,10952,10950,10937,10917,10911,10896,10893,10890,10880,10875,10869,10844,10843,10831,10825,10824,10823,10818,10809,10807,10806,10799,10797,10792,10776,10772,10763,10762,10750,10743,10739,10736,10718,10717,10714,10670,10668,10665,10660,10632,10630,10627,10615,10610,10601,10597,10585,10583,10579,10577,10573,10563,10539,10530,10520,10515,10494,10475,10456,10446,10437,10434,10431,10426,10412,10398,10391,10381,10375,10370,10361,10360,10359,10349,10338,10337,10333,10327,10319,10307,10304,10294,10291,10289,10279,10278,10277,10241,10233,10230,10227,10223,10203,10190,10152,10146,10130,10124,10113,10108,10106,10105,10104,10103,10100,10092,10087,10021,9994,9985,9984,9974,9971,9959,9966,9964,9956,9954,9951,9947,9928,9922,9913,9912,9910,9898,9891,9889,9880,9874,1585,2364,2511,2671,2696,2830,2836,3012,3531,4281,5013,5201,5710,5711,5771,7202,7333,7349,8447,8457,8651,8792,9286,9331,9399,9542);
+			
+		}
+		// preberemo VSE ankete
+		else if($_GET['anketa'] == 'all'){
+		
+			$ids = array();
+			$sql = sisplet_query("SELECT id FROM srv_anketa WHERE id>'0'");
+			while ($row = mysqli_fetch_array($sql)) {
+				$ids[] = $row['id'];
+			}
+		}		
+	}
+} else {
+	$ids = array(8566, 9541, 6156);
+}
+
+// seznam anket
+if ($_GET['a'] == 'ankete') {
+
+	echo 'ID SURVEY'.delimiter;
+	echo 'ID USER'.delimiter;
+	echo 'FIRST RESP'.delimiter;
+	echo 'LAST RESP'.delimiter;
+	echo 'FP CONTENT'.delimiter;
+	echo 'NO QUESTIONS'.delimiter;
+	echo 'NO ITEMS'.delimiter;
+	echo 'NO PAGES'.delimiter;
+	echo 'EMAIL INVT'.delimiter;
+	echo 'EMAIL INVT OTHERS'.delimiter;
+	echo 'EMAIL INVITED';
+
+	echo "\n";
+
+	foreach ($ids AS $id) {
+		
+		$sql = sisplet_query("SELECT a.*, sl.a_first, sl.a_last FROM srv_anketa a, srv_survey_list sl WHERE a.id = '$id' AND sl.id=a.id");
+		if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+		if (mysqli_num_rows($sql) > 0) {
+			
+			$row = mysqli_fetch_array($sql);
+			
+			if ($row['db_table'] == 1) $db_table = '_active'; else $db_table = '';
+			
+			echo $row['id'].delimiter;
+			echo $row['insert_uid'].delimiter;
+			echo $row['a_first'].delimiter;
+			echo $row['a_last'].delimiter;
+			echo str_replace("\n", '', str_replace(delimiter, '', $row['introduction']) ).delimiter;
+			
+			$sql1 = sisplet_query("SELECT COUNT(*) AS count FROM srv_spremenljivka s, srv_grupa g WHERE s.tip!='5' AND s.gru_id=g.id AND g.ank_id='$id'");
+			if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+			$row1 = mysqli_fetch_array($sql1);
+			
+			echo $row1['count'].delimiter;
+			
+			$sql1 = sisplet_query("SELECT s.id, s.tip FROM srv_spremenljivka s, srv_grupa g WHERE s.tip!='5' AND s.gru_id=g.id AND g.ank_id='$id'");
+			if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+			$items = 0;
+			while ($row1 = mysqli_fetch_array($sql1)) {
+				
+				switch ($row1['tip']) {
+					case 2:		// checkbox
+					case 21:	// besedilo
+					case 6:		// multigrid
+					case 7:		// number
+					case 17:	// ranking
+					case 18:	// vsota
+					case 16:	// multicheck
+					case 19:	// multitext
+					case 20:	// multinumber
+						//$sql2 = sisplet_query("SELECT COUNT(*) FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+						//$row2 = mysqli_fetch_array($sql2);
+						$items += srv_vrednost($row1['id']);
+					break;
+					
+					default: 
+						$items += 1;
+					break;
+				}
+			}
+			
+			echo $items.delimiter;
+			
+			$sql1 = sisplet_query("SELECT COUNT(*) AS count FROM srv_grupa g WHERE g.ank_id='$id'");
+			if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+			$row1 = mysqli_fetch_array($sql1);
+			
+			echo $row1['count'].delimiter;
+			
+			echo $row['email'].delimiter;
+			
+			echo $row['usercode_skip'].delimiter;
+			
+			$sql1 = sisplet_query("SELECT COUNT(*) AS count FROM srv_user u WHERE u.ank_id='$id' AND pass IS NOT NULL");
+			if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+			$row1 = mysqli_fetch_array($sql1);
+			
+			echo $row1['count'];
+			
+			echo "\n";
+			
+		}
+		
+	}
+
+// seznam anketirancev
+} elseif ($_GET['a'] == 'anketiranci') {
+	
+	echo 'ID SURVEY'.delimiter;
+	echo 'ID RESP'.delimiter;
+	echo 'RESP STATUS'.delimiter;
+	echo 'RESP LURKER'.delimiter;
+	echo 'RESP IP'.delimiter;
+	echo 'RESP BROWSER'.delimiter;
+	echo 'RESP REFERAL'.delimiter;
+	echo 'RESP ITEMS'.delimiter;
+	echo 'RESP RESPONSE'.delimiter;
+	echo 'TIME FIRST'.delimiter;
+	echo 'TIME LAST'.delimiter;
+	echo 'TIME INTRO'.delimiter;
+	
+	$groups = 0;
+	foreach ($ids AS $id) {
+		$sql1 = sisplet_query("SELECT COUNT(*) FROM srv_grupa WHERE ank_id='$id'");
+		$row1 = mysqli_fetch_array($sql1);
+		if ($row1[0] > $groups) $groups = $row1[0];
+	}
+	for ($i=1; $i<=$groups; $i++)
+		echo 'TIME PAGE '.$i.delimiter;
+	
+	echo "\n";
+	
+	foreach ($ids AS $id) {
+		
+		$sql = sisplet_query("SELECT a.*, u.time_insert, u.time_edit, u.id AS uid, u.last_status, u.lurker, u.ip, u.useragent, u.referer FROM srv_anketa a, srv_user u WHERE a.id = '$id' AND u.ank_id=a.id");
+		if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+		if (mysqli_num_rows($sql) > 0) {
+			
+			$sql1 = sisplet_query("SELECT s.id, s.tip FROM srv_spremenljivka s, srv_grupa g WHERE s.tip!='5' AND s.gru_id=g.id AND g.ank_id='$id'");
+			if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+			$items = 0;
+			while ($row1 = mysqli_fetch_array($sql1)) {
+				
+				switch ($row1['tip']) {
+					case 2:		// checkbox
+					case 21:	// besedilo
+					case 6:		// multigrid
+					case 7:		// number
+					case 17:	// ranking
+					case 18:	// vsota
+					case 16:	// multicheck
+					case 19:	// multitext
+					case 20:	// multinumber
+						//$sql2 = sisplet_query("SELECT COUNT(*) FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+						//$row2 = mysqli_fetch_array($sql2);
+						$items += srv_vrednost($row1['id']);
+					break;
+					
+					default: 
+						$items += 1;
+					break;
+				}
+			}
+			
+			while ($row = mysqli_fetch_array($sql)) {
+				
+				if ($row['db_table'] == 1) $db_table = '_active'; else $db_table = '';
+							
+				echo $row['id'].delimiter;
+				echo $row['uid'].delimiter;
+				echo $row['last_status'].delimiter;
+				echo $row['lurker'].delimiter;
+				echo $row['ip'].delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['useragent']) ).delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['referer']) ).delimiter;
+				
+				// stevilo itmov userja - kaj je videl
+				$sql1 = sisplet_query("SELECT s.id, s.tip FROM srv_spremenljivka s, srv_grupa g, srv_user_grupa{$db_table} ug WHERE s.tip!='5' AND s.gru_id=g.id AND g.ank_id='$id' AND ug.gru_id=g.id AND ug.usr_id='$row[uid]'");
+				if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+				$usertrueitems = 0;
+				while ($row1 = mysqli_fetch_array($sql1)) {
+					
+					$sql3 = sisplet_query("SELECT spr_id FROM srv_data_vrednost{$db_table} WHERE spr_id='$row1[id]' AND usr_id='$row[uid]' AND (vre_id='-2' OR vre_id='-4')");
+					if (mysqli_num_rows($sql3) == 0) {
+						
+						switch ($row1['tip']) {
+							case 2:		// checkbox
+							case 21:	// besedilo
+							case 6:		// multigrid
+							case 7:		// number
+							case 17:	// ranking
+							case 18:	// vsota
+							case 16:	// multicheck
+							case 19:	// multitext
+							case 20:	// multinumber
+								//$sql2 = sisplet_query("SELECT COUNT(*) FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+								//$row2 = mysqli_fetch_array($sql2);
+								$usertrueitems += srv_vrednost($row1['id']);
+							break;
+							
+							default: 
+								$usertrueitems += 1;
+							break;
+						}
+					}
+				}
+				
+				// stevilo itmov na katere je odgovoril 
+				$sql1 = sisplet_query("SELECT s.id, s.tip FROM srv_spremenljivka s, srv_grupa g, srv_user_grupa{$db_table} ug WHERE s.tip!='5' AND s.gru_id=g.id AND g.ank_id='$id' AND ug.gru_id=g.id AND ug.usr_id='$row[uid]'");
+				//$sql1 = sisplet_query("SELECT s.id, s.tip FROM srv_spremenljivka s, srv_grupa g WHERE s.tip!='5' AND s.gru_id=g.id AND g.ank_id='$id'");
+				if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+				$useritems_resp = 0;
+				while ($row1 = mysqli_fetch_array($sql1)) {
+					
+					$sql3 = sisplet_query("SELECT spr_id FROM srv_data_vrednost{$db_table} WHERE spr_id='$row1[id]' AND usr_id='$row[uid]' AND (vre_id='-2' OR vre_id='-4')");
+					if (mysqli_num_rows($sql3) == 0) {
+							
+						switch ($row1['tip']) {
+							case 1:		// radio
+							case 3:		// dropdown
+								$sql2 = sisplet_query("SELECT COUNT(*) FROM srv_data_vrednost{$db_table} WHERE spr_id='$row1[id]' AND vre_id > '0' AND usr_id='$row[uid]'");
+								$row2 = mysqli_fetch_array($sql2);
+								if ($row2[0] > 0) {
+									$useritems_resp += 1;
+								}
+							break;
+							case 2:		// checkbox
+								$sql2 = sisplet_query("SELECT COUNT(*) FROM srv_data_vrednost{$db_table} WHERE spr_id='$row1[id]' AND vre_id > '0' AND usr_id='$row[uid]'");
+								$row2 = mysqli_fetch_array($sql2);
+								if ($row2[0] > 0) {
+									//$sql2 = sisplet_query("SELECT COUNT(*) FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+									//$row2 = mysqli_fetch_array($sql2);
+									$useritems_resp += srv_vrednost($row1['id']);
+								}
+							break;
+							case 6:	// grid
+								$sql2 = sisplet_query("SELECT id FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+								while ($row2 = mysqli_fetch_array($sql2)) {
+									$sql3 = sisplet_query("SELECT COUNT(*) FROM srv_data_grid{$db_table} WHERE spr_id='$row1[id]' AND vre_id='$row2[id]' AND usr_id='$row[uid]'");
+									$row3 = mysqli_fetch_array($sql3);
+									if ($row3[0] > 0) {
+										$useritems_resp += 1;
+									}
+								}
+							break;
+							case 16: // checkgrid
+								$sql2 = sisplet_query("SELECT id FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+								while ($row2 = mysqli_fetch_array($sql2)) {
+									$sql3 = sisplet_query("SELECT COUNT(*) FROM srv_data_checkgrid{$db_table} WHERE spr_id='$row1[id]' AND vre_id='$row2[id]' AND usr_id='$row[uid]'");
+									$row3 = mysqli_fetch_array($sql3);
+									if ($row3[0] > 0) {
+										$useritems_resp += 1;
+									}
+								}
+							break;
+							case 19: // textgrid
+							case 20: // numbergrid
+								$sql2 = sisplet_query("SELECT id FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+								while ($row2 = mysqli_fetch_array($sql2)) {
+									$sql3 = sisplet_query("SELECT COUNT(*) FROM srv_data_textgrid{$db_table} WHERE spr_id='$row1[id]' AND vre_id='$row2[id]' AND usr_id='$row[uid]'");
+									$row3 = mysqli_fetch_array($sql3);
+									if ($row3[0] > 0) {
+										$useritems_resp += 1;
+									}
+								}
+							break;
+							
+							case 21:	// besedilo
+							case 7:		// number
+							case 18:	// vsota
+								$sql2 = sisplet_query("SELECT id FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+								while ($row2 = mysqli_fetch_array($sql2)) {
+									$sql3 = sisplet_query("SELECT COUNT(*) FROM srv_data_text{$db_table} WHERE spr_id='$row1[id]' AND vre_id='$row2[id]' AND usr_id='$row[uid]'");
+									$row3 = mysqli_fetch_array($sql3);
+									if ($row3[0] > 0) {
+										$useritems_resp += 1;
+									}
+								}
+							break;
+							
+							case 17:	// ranking
+								$sql2 = sisplet_query("SELECT id FROM srv_vrednost WHERE spr_id = '$row1[id]'");
+								while ($row2 = mysqli_fetch_array($sql2)) {
+									$sql3 = sisplet_query("SELECT COUNT(*) FROM srv_data_rating WHERE spr_id='$row1[id]' AND vre_id='$row2[id]' AND usr_id='$row[uid]'");
+									$row3 = mysqli_fetch_array($sql3);
+									if ($row3[0] > 0) {
+										$useritems_resp += 1;
+									}
+								}
+							break;
+						}
+						
+					}
+				}
+				
+				echo $usertrueitems.delimiter;
+				echo $useritems_resp.delimiter;
+				
+				echo $row['time_insert'].delimiter;
+				echo $row['time_edit'].delimiter;
+				
+				// uvod
+				$sql1 = sisplet_query("SELECT ug.* FROM srv_user_grupa{$db_table} ug WHERE ug.usr_id = '$row[uid]' AND ug.gru_id='0'");
+				if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+				$row1 = mysqli_fetch_array($sql1);
+				echo $row1['time_edit'].delimiter;
+				
+				// ostale strani
+				$sql1 = sisplet_query("SELECT ug.* FROM srv_user_grupa{$db_table} ug, srv_grupa g WHERE ug.usr_id = '$row[uid]' AND ug.gru_id=g.id AND g.ank_id='$id' ORDER BY g.vrstni_red ASC");
+				if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
+				while ($row1 = mysqli_fetch_array($sql1)) {
+					echo $row1['time_edit'].delimiter;
+				}
+				
+				echo "\n";
+				
+			}	
+			
+		}
+		
+		
+	}
+	
+} elseif ($_GET['a'] == 'vprasanja') {
+	
+	echo 'ID SURVEY'.delimiter;
+	echo 'ID QUESTION'.delimiter;
+	echo 'ID PAGE'.delimiter;
+	echo 'QUESTION NUMBER'.delimiter;
+	
+	echo 'naslov'.delimiter;
+	echo 'info'.delimiter;
+	echo 'variable'.delimiter;
+	echo 'variable_custom'.delimiter;
+	echo 'label'.delimiter;
+	echo 'tip'.delimiter;
+	echo 'vrstni_red'.delimiter;
+	echo 'random'.delimiter;
+	echo 'size'.delimiter;
+	echo 'undecided'.delimiter;
+	echo 'rejected'.delimiter;
+	echo 'inappropriate'.delimiter;
+	echo 'stat'.delimiter;
+	echo 'orientation'.delimiter;
+	echo 'checkboxhide'.delimiter;
+	echo 'reminder'.delimiter;
+	echo 'visible'.delimiter;
+	echo 'textfield'.delimiter;
+	echo 'textfield_label'.delimiter;
+	echo 'cela'.delimiter;
+	echo 'decimalna'.delimiter;
+	echo 'enota'.delimiter;
+	echo 'timer'.delimiter;
+	echo 'sistem'.delimiter;
+	echo 'folder'.delimiter;
+	echo 'params'.delimiter;
+	echo 'antonucci'.delimiter;
+	echo 'design'.delimiter;
+	echo 'podpora'.delimiter;
+	echo 'grids'.delimiter;
+	echo 'grids_edit'.delimiter;
+	echo 'grid_subtitle1'.delimiter;
+	echo 'grid_subtitle2'.delimiter;
+	echo 'ranking_k'.delimiter;
+	echo 'vsota'.delimiter;
+	echo 'vsota_limit'.delimiter;
+	echo 'vsota_min'.delimiter;
+	echo 'skala'.delimiter;
+	echo 'vsota_reminder'.delimiter;
+	echo 'vsota_limittype'.delimiter;
+	echo 'vsota_show'.delimiter;
+	echo 'thread'.delimiter;
+	echo 'text_kosov'.delimiter;
+	echo 'text_orientation'.delimiter;
+	echo 'note'.delimiter;
+	echo 'upload'.delimiter;
+	echo 'dostop'.delimiter;
+	echo 'inline_edit'.delimiter;
+	echo 'onchange_submit'.delimiter;
+	echo 'hidden_default'.delimiter;
+	echo 'naslov_graf'.delimiter;
+	echo 'edit_graf'.delimiter;
+	echo 'wide_graf'.delimiter;
+	echo 'coding'.delimiter;
+	echo 'dynamic_mg'.delimiter;
+	echo 'QUESTION IF'.delimiter;
+	
+	echo "\n";
+
+	foreach ($ids AS $id) {
+		
+		$sql = sisplet_query("SELECT s.* FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id='$id' ORDER BY g.vrstni_red, s.vrstni_red");
+		if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+		if (mysqli_num_rows($sql) > 0) {
+			
+			$i = 0;
+			
+			while ($row = mysqli_fetch_array($sql)) {
+				
+				$i++;
+				
+				echo $id.delimiter;
+				echo $row['id'].delimiter;
+				echo $row['gru_id'].delimiter;
+				echo $i.delimiter;
+                
+                // Posebej za Gregorja lahko izvozimo prevode - opcijski parameter "lang_id"
+                if(isset($_GET['lang_id'])){
+
+                    $lang_id = $_GET['lang_id'];
+                    $sqlL = sisplet_query("SELECT naslov, info FROM srv_language_spremenljivka WHERE spr_id='".$row['id']."' AND lang_id='".$lang_id."'");
+                    
+                    if(mysqli_num_rows($sqlL) > 0){
+                        $rowL = mysqli_fetch_array($sqlL);
+
+                        $row['naslov'] = $rowL['naslov'];
+                        $row['info'] = $rowL['info'];
+                    }
+                }
+
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['naslov']) ).delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['info']) ).delimiter;
+				echo $row['variable'].delimiter;
+				echo $row['variable_custom'].delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['label']) ).delimiter;
+				echo $row['tip'].delimiter;
+				echo $row['vrstni_red'].delimiter;
+				echo $row['random'].delimiter;
+				echo $row['size'].delimiter;
+				echo $row['undecided'].delimiter;
+				echo $row['rejected'].delimiter;
+				echo $row['inappropriate'].delimiter;
+				echo $row['stat'].delimiter;
+				echo $row['orientation'].delimiter;
+				echo $row['checkboxhide'].delimiter;
+				echo $row['reminder'].delimiter;
+				echo $row['visible'].delimiter;
+				echo $row['textfield'].delimiter;
+				echo $row['textfield_label'].delimiter;
+				echo $row['cela'].delimiter;
+				echo $row['decimalna'].delimiter;
+				echo $row['enota'].delimiter;
+				echo $row['timer'].delimiter;
+				echo $row['sistem'].delimiter;
+				echo $row['folder'].delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['params']) ).delimiter;
+				echo $row['antonucci'].delimiter;
+				echo $row['design'].delimiter;
+				echo $row['podpora'].delimiter;
+				echo $row['grids'].delimiter;
+				echo $row['grids_edit'].delimiter;
+				echo $row['grid_subtitle1'].delimiter;
+				echo $row['grid_subtitle2'].delimiter;
+				echo $row['ranking_k'].delimiter;
+				echo $row['vsota'].delimiter;
+				echo $row['vsota_limit'].delimiter;
+				echo $row['vsota_min'].delimiter;
+				echo $row['skala'].delimiter;
+				echo $row['vsota_reminder'].delimiter;
+				echo $row['vsota_limittype'].delimiter;
+				echo $row['vsota_show'].delimiter;
+				echo $row['thread'].delimiter;
+				echo $row['text_kosov'].delimiter;
+				echo $row['text_orientation'].delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['note']) ).delimiter;
+				echo $row['upload'].delimiter;
+				echo $row['dostop'].delimiter;
+				echo $row['inline_edit'].delimiter;
+				echo $row['onchange_submit'].delimiter;
+				echo $row['hidden_default'].delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['naslov_graf']) ).delimiter;
+				echo $row['edit_graf'].delimiter;
+				echo $row['wide_graf'].delimiter;
+				echo $row['coding'].delimiter;
+				echo $row['dynamic_mg'].delimiter;
+				
+				$sql1 = sisplet_query("SELECT f.* FROM srv_branching b, srv_if f WHERE b.element_spr = '$row[id]' AND b.parent=f.id");
+				$row1 = mysqli_fetch_array($sql1);
+				echo parentIf($id, $row1['id']).delimiter;
+	
+				echo "\n";
+			}
+			
+		}
+		
+		
+	}
+	
+	
+	
+} elseif ($_GET['a'] == 'items') {
+	
+	
+	
+	echo 'ID SURVEY'.delimiter;
+	echo 'ID QUESTION'.delimiter;
+	echo 'ID ITEM'.delimiter;
+	
+	echo 'naslov'.delimiter;
+	echo 'naslov2'.delimiter;
+	echo 'variable'.delimiter;
+	echo 'variable_custom'.delimiter;
+	echo 'vrstni_red'.delimiter;
+	echo 'random'.delimiter;
+	echo 'other'.delimiter;
+	echo 'if_id'.delimiter;
+	echo 'size'.delimiter;
+	echo 'naslov_graf'.delimiter;
+	
+	echo 'grid_vrstni_red'.delimiter;
+	echo 'grid_variable'.delimiter;
+	echo 'grid_other'.delimiter;
+	echo 'grid_naslov'.delimiter;
+
+	
+	echo "\n";
+
+	foreach ($ids AS $id) {
+		
+		$sql = sisplet_query("SELECT v.* FROM srv_vrednost v, srv_spremenljivka s, srv_grupa g WHERE v.spr_id=s.id AND s.gru_id=g.id AND g.ank_id='$id' ORDER BY g.vrstni_red, s.vrstni_red");
+		if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
+		if (mysqli_num_rows($sql) > 0) {
+                    
+            // Posebej za Gregorja lahko izvozimo prevode - opcijski parameter "lang_id"
+            if(isset($_GET['lang_id'])){
+
+                $lang_id = $_GET['lang_id'];
+                $sqlL = sisplet_query("SELECT vre_id, naslov, naslov2 FROM srv_language_vrednost WHERE ank_id='".$id."' AND lang_id='".$lang_id."'");
+
+                $translations = array();
+                
+                while($rowL = mysqli_fetch_array($sqlL)){
+                    $translations[$rowL['vre_id']]['naslov'] = $rowL['naslov'];
+                    $translations[$rowL['vre_id']]['naslov2'] = $rowL['naslov2'];
+                }
+            }
+
+			while ($row = mysqli_fetch_array($sql)) {
+								
+				echo $id.delimiter;
+				echo $row['spr_id'].delimiter;
+				echo $row['id'].delimiter;
+
+                // Posebej za Gregorja lahko izvozimo prevode - opcijski parameter "lang_id"
+                if(isset($_GET['lang_id']) && isset($translations[$row['id']])){
+                    $row['naslov'] = $translations[$row['id']]['naslov'];
+                    $row['naslov2'] = $translations[$row['id']]['naslov2'];
+                }
+
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['naslov']) ).delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['naslov2']) ).delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['variable']) ).delimiter;
+				echo $row['variable_custom'].delimiter;
+				echo $row['vrstni_red'].delimiter;
+				echo $row['random'].delimiter;
+				echo $row['other'].delimiter;
+				echo $row['if_id'].delimiter;
+				echo $row['size'].delimiter;
+				echo str_replace("\n", '', str_replace(delimiter, '', $row['naslov_graf']) ).delimiter;
+				
+				$sql1 = sisplet_query("SELECT naslov, variable, vrstni_red, other FROM srv_grid WHERE spr_id = '$row[spr_id]' ORDER BY vrstni_red ASC");
+				while ($row1 = mysqli_fetch_array($sql1)) {
+					
+					echo str_replace("\n", '', str_replace(delimiter, '', $row1['vrstni_red']) ).delimiter;
+					echo str_replace("\n", '', str_replace(delimiter, '', $row1['variable']) ).delimiter;
+					echo str_replace("\n", '', str_replace(delimiter, '', $row1['other']) ).delimiter;
+					echo str_replace("\n", '', str_replace(delimiter, '', $row1['naslov']) ).delimiter;				
+				}
+				
+				echo "\n";
+			}			
+		}		
+	}	
+}
+
+$srv_vrednost = null;
+function srv_vrednost ($id) {
+	global $srv_vrednost;
+	
+	if ( $srv_vrednost != null && array_key_exists($id, $srv_vrednost) )
+		return $srv_vrednost[$id];
+	
+	$sql2 = sisplet_query("SELECT COUNT(*) FROM srv_vrednost WHERE spr_id = '$id'");
+	$row2 = mysqli_fetch_array($sql2);
+	$srv_vrednost[$id] = $row2[0];
+	return $row2[0];
+	
+}
+
+function parentIf($anketa, $element) {
+	
+	$sql = sisplet_query("SELECT tip FROM srv_if WHERE id = '$element'");
+	$row = mysqli_fetch_array($sql);
+	
+	if ($row['tip'] == 0) return $element;
+	
+	$sql1 = sisplet_query("SELECT parent FROM srv_branching WHERE ank_id='$anketa' AND element_if = '$element'");
+	$row1 = mysqli_fetch_array($sql1);
+	
+	return parentIf($anketa, $row1['parent']);
+}
+
+?>
-- 
cgit v1.2.3