dead

File manager - Edit - /home/theblueo/tv/wp-content/plugins/sfwd-lms/includes/lib/wp-pro-quiz/lib/model/WpProQuiz_Model_QuizMapper.php

Back
<?php class WpProQuiz_Model_QuizMapper extends WpProQuiz_Model_Mapper { protected $_table; function __construct() { parent::__construct(); //$this->_table = $this->_prefix."master"; $this->_table = $this->_tableMaster; } public function delete($id) { $this->_wpdb->delete($this->_table, array( 'id' => $id), array('%d')); } public function exists($id) { return $this->_wpdb->get_var($this->_wpdb->prepare("SELECT COUNT() FROM {$this->_table} WHERE id = %d", $id)); } public function fetch($id) { $queried_object = get_queried_object(); $sql_str = $this->_wpdb->prepare("SELECT FROM {$this->_table} WHERE id = %d", $id ); $results = $this->_wpdb->get_row( $sql_str, ARRAY_A ); if($results['result_grade_enabled']) $results['result_text'] = unserialize($results['result_text']); return new WpProQuiz_Model_Quiz($results); } public function fetchAll() { $r = array(); $results = $this->_wpdb->get_results("SELECT * FROM {$this->_table} ORDER BY id ASC", ARRAY_A); foreach ($results as $row) { if($row['result_grade_enabled']) $row['result_text'] = unserialize($row['result_text']); $r[] = new WpProQuiz_Model_Quiz($row); } return $r; } public function save(WpProQuiz_Model_Quiz $data) { if($data->isResultGradeEnabled()) { $resultText = serialize($data->getResultText()); } else { $resultText = $data->getResultText(); } $name = $data->getName(); if(empty($name)) $name = "no title"; $text = $data->getText(); if(empty($text)) $text = "AAZZAAZZ"; $set = array( 'name' => $name, 'text' => $text, 'result_text' => $resultText, 'title_hidden' => (int)$data->isTitleHidden(), 'btn_restart_quiz_hidden' => (int)$data->isBtnRestartQuizHidden(), 'btn_view_question_hidden' => (int)$data->isBtnViewQuestionHidden(), 'question_random' => (int)$data->isQuestionRandom(), 'answer_random' => (int)$data->isAnswerRandom(), 'time_limit' => (int)$data->getTimeLimit(), 'statistics_on' => (int)$data->isStatisticsOn(), 'statistics_ip_lock' => (int)$data->getStatisticsIpLock(), 'result_grade_enabled' => (int)$data->isResultGradeEnabled(), 'show_points' => (int)$data->isShowPoints(), 'quiz_run_once' => (int)$data->isQuizRunOnce(), 'quiz_run_once_type' => $data->getQuizRunOnceType(), 'quiz_run_once_cookie' => (int)$data->isQuizRunOnceCookie(), 'quiz_run_once_time' => (int)$data->getQuizRunOnceTime(), 'numbered_answer' => (int)$data->isNumberedAnswer(), 'hide_answer_message_box' => (int)$data->isHideAnswerMessageBox(), 'disabled_answer_mark' => (int)$data->isDisabledAnswerMark(), 'show_max_question' => (int)$data->isShowMaxQuestion(), 'show_max_question_value' => (int)$data->getShowMaxQuestionValue(), 'show_max_question_percent' => (int)$data->isShowMaxQuestionPercent(), 'toplist_activated' => (int)$data->isToplistActivated(), 'toplist_data' => $data->getToplistData(), 'show_average_result' => (int)$data->isShowAverageResult(), 'prerequisite' => (int)$data->isPrerequisite(), 'quiz_modus' => (int)$data->getQuizModus(), 'show_review_question' => (int)$data->isShowReviewQuestion(), 'quiz_summary_hide' => (int)$data->isQuizSummaryHide(), 'skip_question_disabled' => (int)$data->isSkipQuestionDisabled(), 'email_notification' => $data->getEmailNotification(), 'user_email_notification' => (int)$data->isUserEmailNotification(), 'show_category_score' => (int)$data->isShowCategoryScore(), 'hide_result_correct_question' => (int)$data->isHideResultCorrectQuestion(), 'hide_result_quiz_time' => (int)$data->isHideResultQuizTime(), 'hide_result_points' => (int)$data->isHideResultPoints(), 'autostart' => (int)$data->isAutostart(), 'forcing_question_solve' => (int)$data->isForcingQuestionSolve(), 'hide_question_position_overview' => (int)$data->isHideQuestionPositionOverview(), 'hide_question_numbering' => (int)$data->isHideQuestionNumbering(), 'form_activated' => (int)$data->isFormActivated(), 'form_show_position' => $data->getFormShowPosition(), 'start_only_registered_user' => (int)$data->isStartOnlyRegisteredUser(), 'questions_per_page' => $data->getQuestionsPerPage(), 'sort_categories' => (int)$data->isSortCategories(), 'show_category' => (int)$data->isShowCategory() ); /** * Convert emoji to HTML entities to allow saving in DB. * * @since 2.6.0. / $set['name'] = wp_encode_emoji( $set['name'] ); if($data->getId() != 0) { $result = $this->_wpdb->update( $this->_table, $set, array( 'id' => $data->getId() ), array( '%s', '%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d' ), array( '%d' ) ); } else { $result = $this->_wpdb->insert( $this->_table, $set, array( '%s', '%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d' ) ); $data->setId($this->_wpdb->insert_id); } if($result === false) { return null; } $data->saveTimeLimitCookie(); $data->saveViewProfileStatistics(); return $data; } public function sumQuestionPoints($id) { return $this->_wpdb->get_var($this->_wpdb->prepare("SELECT SUM(points) FROM {$this->_tableQuestion} WHERE quiz_id = %d AND online = 1", $id)); } public function sumQuestionPointsFromArray( $question_ids = array() ) { if ( ! empty( $question_ids ) ) { $sql_str = "SELECT SUM(points) FROM {$this->_tableQuestion} WHERE id IN (" . implode(',', $question_ids ) . ") AND online = 1"; return $this->_wpdb->get_var( $sql_str ); } else { return 0; } } public function countQuestion($id) { return $this->_wpdb->get_var($this->_wpdb->prepare("SELECT COUNT() FROM {$this->_tableQuestion} WHERE quiz_id = %d AND online = 1", $id)); } public function fetchAllAsArray( $list, $outIds = array() ) { $where = ' 1 '; if( !empty ($outIds ) ) { $where .= ' AND id NOT IN (' . implode( ', ', array_map( 'intval', (array) $outIds ) ) . ') '; } $sql_str = "SELECT " . implode( ', ', (array) $list ) . " FROM {$this->_tableMaster} WHERE $where ORDER BY name"; $quiz_list = $this->_wpdb->get_results( $sql_str, ARRAY_A ); if ( ! empty( $quiz_list ) ) { $quiz_pro_ids = wp_list_pluck( $quiz_list, 'id' ); $sql_str = "SELECT postmeta.meta_value as quiz_pro_id FROM {$this->_wpdb->posts} AS posts INNER JOIN {$this->_wpdb->postmeta} as postmeta ON posts.ID = postmeta.post_id WHERE posts.post_type='". learndash_get_post_type_slug( 'quiz' ) . "' AND posts.post_status = 'publish' AND postmeta.meta_key='quiz_pro_id' AND postmeta.meta_value IN ( ". implode( ',', $quiz_pro_ids ) . " )"; $quiz_pro_ids = $this->_wpdb->get_col( $sql_str ); if ( ! empty( $quiz_pro_ids ) ) { $quiz_pro_ids = array_map( 'intval', $quiz_pro_ids ); $quiz_pro_ids = array_unique( $quiz_pro_ids ); foreach( $quiz_list as $quiz_idx => $quiz_item ) { if ( ! in_array( $quiz_item['id'], $quiz_pro_ids ) ) { unset( $quiz_list[ $quiz_idx ] ); } } } } return ( array ) $quiz_list; } public function fetchCol($ids, $col) { $ids = implode(', ', array_map('intval', (array)$ids)); return $this->_wpdb->get_col("SELECT {$col} FROM {$this->_tableMaster} WHERE id IN({$ids})"); } public function activateStatitic($quizIds, $lockIpTime) { $quizIds = implode(', ', array_map('intval', (array)$quizIds)); return $this->_wpdb->query($this->_wpdb->prepare( "UPDATE {$this->_tableMaster} SET `statistics_on` = 1, `statistics_ip_lock` = %d WHERE `statistics_on` = 0 AND id IN(".$quizIds.")" , $lockIpTime)); } public function deleteAll($quizId) { return $this->_wpdb->query( $this->_wpdb->prepare( "DELETE m, q, l, p, t, f, sr, s FROM {$this->_tableMaster} AS m LEFT JOIN {$this->_tableQuestion} AS q ON(q.quiz_id = m.id) LEFT JOIN {$this->_tableLock} AS l ON(l.quiz_id = m.id) LEFT JOIN {$this->_tablePrerequisite} AS p ON(p.prerequisite_quiz_id = m.id) LEFT JOIN {$this->_tableToplist} AS t ON(t.quiz_id = m.id) LEFT JOIN {$this->_tableForm} AS f ON(f.quiz_id = m.id) LEFT JOIN {$this->_tableStatisticRef} AS sr ON(sr.quiz_id = m.id) LEFT JOIN {$this->_tableStatistic} AS s ON(s.statistic_ref_id = sr.statistic_ref_id) WHERE m.id = %d" , $quizId) ); } }

| ver. 1.4 | Github | . | PHP 7.0.33 | Generation time: 0.02 | proxy | phpinfo | Settings