</td>
<td><?php
echo $data['variable_alias'];
?>
</td>
<td>
<?php
$sql1 = mysql_query("SELECT vv.variable_value_alias as variable_value_alias,\n vv.variable_value_name as variable_value_name \n FROM variable v \n JOIN variable_value vv \n ON v.id_variable = vv.id_variable\n WHERE vv.id_variable = '{$data['id_variable']}'\n ");
while ($data1 = mysql_fetch_array($sql1)) {
echo "<span class='badge'>" . $data1['variable_value_alias'] . "</span> ";
}
?>
</td>
<td>
<?php
if (null_check('variable_value', 'id_variable', "{$data['id_variable']}") > 0) {
?>
<a href="?p=dynamic_edit_variable&id_variable=<?php
echo $data['id_variable'];
?>
" class="btn bgm-orange waves-effect"><i class="md md-create"></i></a>
<?php
} else {
?>
<a href="?p=dynamic_tambah_variable&id_variable=<?php
echo $data['id_variable'];
?>
" class="btn bgm-cyan waves-effect"><i class="md md-add"></i></a>
<?php
}
?>
function do_slots_table()
{
global $postgres;
printf("\tCleaning postgres-table\n");
pg_exec($postgres, "DELETE FROM ltrSlots") or die("Error while cleaning table");
printf("\tReading from MySQL...\n");
$query = "SELECT * FROM ltrSlots";
$res = mysql_query($query) or die("Could not query slots data\n\n");
begin_transaction();
while ($row = mysql_fetch_array($res)) {
foreach ($row as $key => $value) {
$row[$key] = addslashes($value);
}
null_check($row, 'Trail_2_ID');
null_check($row, 'Trail_2_Text');
null_check($row, 'Next');
$query = sprintf("\n INSERT INTO\n ltrSlots\n (Slot_ID, Node_ID, Trail_1_ID, Trail_1_Text, Trail_2_ID, Trail_2_Text, Description, Next, IsLive)\n VALUES\n (%d, %d, %d, '%s', %s, %s, '%s', %s, '%s')\n ", $row['Slot_ID'], $row['Node_ID'], $row['Trail_1_ID'], $row['Trail_1_Text'], $row['Trail_2_ID'], $row['Trail_2_Text'], $row['Description'], $row['Next'], $row['IsLive']);
$pg_res = pg_exec($postgres, $query);
if (!$pg_res) {
end_transaction(false);
die("SQL-Error! Query:\n\n{$query}\n\n");
} else {
printf("\tInserted Slot. Node: %d", $row['Node_ID'] . "\n");
}
}
mysql_free_result($res);
end_transaction();
}
