public function todolists_progressbar_shortcode($atts) { require_once "form_todolist_user.php"; $form = new WPTodoList_FormTodoList(); extract(shortcode_atts(array('id' => '0'), $atts)); return $form->get_progressbar($id); }
public function todolists_wp_ajax_nopriv_updatetask() { global $wpdb, $ip_id, $todolist_task_disappear; $userid = get_current_user_id(); $task_id = $_POST['taskid']; $status = $_POST["status"]; if ($todolist_task_disappear == "on" && is_super_admin($userid)) { $type = 'draft'; $disappear = "yes"; } else { $type = 'publish'; $disappear = "no"; } if (is_user_logged_in()) { $select_task = $wpdb->get_results("SELECT user_id FROM " . $wpdb->prefix . "todolists_usertask WHERE user_id = '" . $userid . "' AND task_id = '" . $task_id . "'"); $update_task = "UPDATE " . $wpdb->prefix . "todolists_usertask SET status='true', type='{$type}', completiondate=NOW() where user_id='{$userid}' AND task_id='{$task_id}'"; $insert_task = "INSERT IGNORE INTO " . $wpdb->prefix . "todolists_usertask SET user_id='{$userid}', task_id='{$task_id}', status='{$status}', type='{$type}', completiondate=NOW()"; $delete_task = "DELETE FROM " . $wpdb->prefix . "todolists_usertask WHERE user_id='{$userid}' AND task_id='{$task_id}'"; } else { $select_task = $wpdb->get_results("SELECT ip_id FROM " . $wpdb->prefix . "todolists_iptask WHERE ip_id = '" . $ip_id . "' AND task_id = '" . $task_id . "'"); $update_task = "UPDATE " . $wpdb->prefix . "todolists_iptask SET status='true', type='{$type}', completiondate=NOW() where ip_id='{$ip_id}' AND task_id='{$task_id}'"; $insert_task = "INSERT IGNORE INTO " . $wpdb->prefix . "todolists_iptask SET ip_id='{$ip_id}', task_id='{$task_id}', status='{$status}',type='{$type}', completiondate=NOW()"; $delete_task = "DELETE FROM " . $wpdb->prefix . "todolists_iptask WHERE ip_id='{$ip_id}' AND task_id='{$task_id}'"; } if ($status == "true") { if (count($result) > 0) { $wpdb->query($update_task); } else { $wpdb->query($insert_task); } //insert } else { $wpdb->query($delete_task); //delete } require_once "code/form_todolist_user.php"; $form = new WPTodoList_FormTodoList(); $listid = $form->get_tasklistid($task_id); $taskcountdetails = $form->get_taskcountdetails($listid); echo $taskcountdetails["completed"] . "_" . $taskcountdetails["total"] . "_" . $taskcountdetails["percent"] . "_" . $listid . "_" . $disappear; die; }