74 lines
3.0 KiB
PHP
74 lines
3.0 KiB
PHP
<?php
|
|
|
|
include_once('../../function.php');
|
|
|
|
$sql = sisplet_query("SELECT * FROM srv_spremenljivka WHERE textfield='1'");
|
|
if (!$sql) echo mysqli_error($GLOBALS['connect_db']);
|
|
while ($row = mysqli_fetch_array($sql)) {
|
|
|
|
echo $row['id'].': ';
|
|
|
|
$sql1 = sisplet_query("SELECT * FROM srv_vrednost WHERE spr_id='$row[id]' AND vrstni_red>0");
|
|
if (!$sql1) echo mysqli_error($GLOBALS['connect_db']);
|
|
$row1 = mysqli_fetch_array($sql1);
|
|
$nums = mysqli_num_rows($sql1);
|
|
$vrstni_red = $nums + 1;
|
|
|
|
if ($row['tip'] == 2 || $row['tip'] == 6)
|
|
$variable = $row['variable'].chr($vrstni_red+96);
|
|
else
|
|
$variable = $vrstni_red;
|
|
|
|
$naslov = $lang['srv_other'].':';
|
|
|
|
$sql2 = sisplet_query("INSERT INTO srv_vrednost (id, spr_id, naslov, variable, vrstni_red, other) VALUES ('', '$row[id]', '$naslov', '$variable', '$vrstni_red', '1')");
|
|
if (!$sql2) echo mysqli_error($GLOBALS['connect_db']);
|
|
$vre_id = mysqli_insert_id($GLOBALS['connect_db']);
|
|
|
|
|
|
// radio in checkbox
|
|
if ($row['tip'] <= 2) {
|
|
|
|
$sql2 = sisplet_query("SELECT * FROM srv_data_vrednost WHERE spr_id='$row[id]' AND vre_id='-3'");
|
|
while ($row2 = mysqli_fetch_array($sql2)) {
|
|
|
|
$sql3 = sisplet_query("INSERT INTO srv_data_vrednost (spr_id, vre_id, usr_id) VALUES ('$row[id]', '$vre_id', '$row2[usr_id]')");
|
|
if (!$sql3) echo mysqli_error($GLOBALS['connect_db']);
|
|
echo $sql3;
|
|
|
|
$sql4 = sisplet_query("SELECT * FROM srv_data_text WHERE spr_id='$row[id]' AND usr_id = '$row2[usr_id]'");
|
|
if (!$sql4) echo mysqli_error($GLOBALS['connect_db']);
|
|
$row4 = mysqli_fetch_array($sql4);
|
|
|
|
$sql3 = sisplet_query("INSERT INTO srv_data_text (spr_id, vre_id, text, text2, usr_id) VALUES ('$row[id]', '$vre_id', '$row4[text]', '$row4[text2]', '$row2[usr_id]')");
|
|
if (!$sql3) echo mysqli_error($GLOBALS['connect_db']);
|
|
echo $sql3.'<br />';
|
|
}
|
|
|
|
// multugrid
|
|
} elseif ($row['tip'] == 6) {
|
|
|
|
$sql2 = sisplet_query("SELECT * FROM srv_data_grid WHERE spr_id='$row[id]' AND vre_id='-3'");
|
|
while ($row2 = mysqli_fetch_array($sql2)) {
|
|
|
|
$sql3 = sisplet_query("INSERT INTO srv_data_grid (spr_id, vre_id, usr_id, grd_id) VALUES ('$row[id]', '$vre_id', '$row2[usr_id]', '$row2[grd_id]')");
|
|
if (!$sql3) echo mysqli_error($GLOBALS['connect_db']);
|
|
echo $sql3;
|
|
|
|
$sql4 = sisplet_query("SELECT * FROM srv_data_text WHERE spr_id='$row[id]' AND usr_id = '$row2[usr_id]'");
|
|
if (!$sql4) echo mysqli_error($GLOBALS['connect_db']);
|
|
$row4 = mysqli_fetch_array($sql4);
|
|
|
|
$sql3 = sisplet_query("INSERT INTO srv_data_text (spr_id, vre_id, text, text2, usr_id) VALUES ('$row[id]', '$vre_id', '$row4[text]', '$row4[text2]', '$row2[usr_id]')");
|
|
if (!$sql3) echo mysqli_error($GLOBALS['connect_db']);
|
|
echo $sql3.'<br />';
|
|
}
|
|
|
|
}
|
|
|
|
echo '<br />';
|
|
}
|
|
|
|
echo 'done';
|
|
|
|
?>
|