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']);