function page_logic()
{
?>
<!-- PAGE CONTAINER -->
<div class="container">
<?php
open_panel("dash2_toggle", "Goals");
?>
<?php
open_panel_item("Goals", "goals", "6");
?>
<div id="draw_goals_style">
<?php
draw_goals();
?>
</div>
<?php
draw_goal_form();
?>
<?php
close_panel_item();
?>
<?php
open_panel_item("Progress", "goals", "6");
?>
<div id="draw_progress_style">
<?php
draw_progress();
?>
</div>
<?php
close_panel_item();
?>
<?php
close_panel();
?>
</div>
<?php
}
/* Add the new members to the queue */
$sqls[] = "Delete FROM SineDialer.queue_member_table WHERE interface = " . sanitize("Agent/" . $agent_num);
$sqls[] = "INSERT INTO SineDialer.queue_member_table (queue_name, membername, interface) VALUES ('so_crm_" . sanitize($_GET['save_members'], false) . "', " . sanitize($username) . "," . sanitize("Agent/" . $agent_num) . ")";
}
/* Connect to SmoothTorque MySQL Database */
$link = mysql_connect($config_values['smoothtorque_db_host'], $config_values['smoothtorque_db_user'], $config_values['smoothtorque_db_pass']) or die(mysql_error());
foreach ($sqls as $sql) {
mysql_query($sql) or die(mysql_error());
}
}
//echo $sql."\n";
exit(0);
}
if (isset($_GET['save'])) {
require "header.php";
draw_progress("Please wait, saving your job");
/* Add a job to the database */
$sql = "INSERT INTO jobs (name, description) VALUES (" . sanitize($_POST['name']) . ", " . sanitize($_POST['description']) . ")";
mysqli_query($connection, $sql);
/* Find out the newly created job ID */
$job = mysqli_insert_id($connection);
/* If there is a SmoothTorque host/user/pass connect to it */
if (strlen($config_values['smoothtorque_db_host']) > 0) {
/* Connect to SmoothTorque MySQL Database */
$link = mysql_connect($config_values['smoothtorque_db_host'], $config_values['smoothtorque_db_user'], $config_values['smoothtorque_db_pass']) or die(mysql_error());
/* Create a queue */
$sql = "INSERT INTO SineDialer.queue_table (name) VALUES (" . sanitize("so_crm_" . $job) . ")";
$result = mysql_query($sql);
/* Create a campaign */
$sql = "INSERT INTO SineDialer.campaign (id, name, description, groupid, astqueuename, mode, clid, context) VALUES (";
$sql .= sanitize($job + 100000) . "," . sanitize($_POST['name']) . "," . sanitize("From SmoothOperator") . "," . sanitize($_POST['st_campaign_group_id']) . "," . sanitize("so_crm_" . $job) . ",1," . sanitize($_POST['st_callerid']) . "," . sanitize($_POST['st_campaign_type']) . ")";
redirect("scripts.php");
require "footer.php";
exit(0);
}
if (isset($_GET['delete_sure'])) {
require "header.php";
?>
<div class="thin_700px_box"><?php
$id = sanitize($_GET['delete_sure']);
//TODO: Make this delete script entries
$result = mysqli_query($connection, "DELETE FROM scripts WHERE id = {$id}");
if (!$result) {
$messages[] = "There was a problem deleting this script: " . mysqli_error();
$_SESSION['messages'] = $messages;
}
draw_progress("Please wait we are saving your changes...");
redirect("scripts.php", 0);
?>
</div><?php
require "footer.php";
exit(0);
}
if (isset($_GET['delete'])) {
require "header.php";
?>
<div class="thin_700px_box"><?php
?>
Are you sure you would like to delete this script?<br />
<br />
<?php
$id = sanitize($_GET['delete']);
