initOptions();
// Initialize DB Tables used by the plugin
$this->installDatabaseTables();
// Other Plugin initialization - for the plugin writer to override as needed
$this->otherInstall();
// To avoid running install() more then once
$this->markAsInstalled();
}
public function uninstall(){
$this->otherUninstall();
$this->unInstallDatabaseTables();
$this->deleteSavedOptions();
$this->markAsUnInstalled();
}
public function upgrade() {
}
protected function initOptions() {
}
protected function installDatabaseTables() {
}
protected function unInstallDatabaseTables() {
}
protected function otherInstall() {
}
protected function otherUninstall() {
}
public function addMenuPages() {
$this->addMainPage();
$this->addSettingsPage();
$this->addAccessPage();
$this->addInfoPage();
$this->addReleasesPage();
}
protected function getPluginSlug() {
return 'tuskcode_puzzle_crossword';
}
protected function getPluginSettingsSlug(){
return 'tuskcode_crossword_settings';
}
protected function getPluginInfoSlug(){
return 'tuskcode_crossword_info';
}
protected function getPluginAccessSlug(){
return 'tuskcode_crossword_access';
}
protected function getPluginReleasesSlug(){
return 'tuskcode_crossword_releases';
}
protected function addMainPage(){
global $pc_puzzle_crossword_main_page;
$displayName = $this->getPluginDisplayName();
$capab = current_user_can( self::ACCESS_CRU_CROSSWORD ) ? self:: ACCESS_CRU_CROSSWORD : 'manage_options';
$pc_puzzle_crossword_main_page = add_menu_page( $displayName,
$displayName,
$capab,
$this->getPluginSlug(),
array( &$this, 'puzzle_crossword_main'),
(PC_PUZZLE_CROSSWORD_URL.'/assets/images/plugin-icon.png'),
150
);
}
protected function addSettingsPage(){
global $pc_puzzle_crossword_settings_page;
$displayName = $this->getPluginSettingsDisplayName();
$capab = current_user_can( self::ACCESS_SETTINGS ) ? self::ACCESS_SETTINGS : 'manage_options';
$pc_puzzle_crossword_settings_page = add_submenu_page(
$this->getPluginSlug(),
$displayName,
$displayName,
$capab,
$this->getPluginSettingsSlug(),
array( &$this, 'puzzle_crossword_settings'),
151
);
}
protected function addAccessPage(){
global $pc_puzzle_crossword_access_page;
$displayName = esc_html__('User Access', 'advanced-crossword');
$capab = current_user_can(self::ACCESS_RULES ) ? self::ACCESS_RULES : 'manage_options';
$pc_puzzle_crossword_access_page = add_submenu_page(
$this->getPluginSlug(),
$displayName,
$displayName,
$capab,
$this->getPluginAccessSlug(),
array( &$this, 'puzzle_crossword_access'),
152
);
}
protected function addInfoPage(){
global $pc_puzzle_crossword_info_page;
$displayName = $this->getPluginInfoDisplayName();
$capab = current_user_can( self::ACCESS_LICENSE ) ? self::ACCESS_LICENSE : 'manage_options';
$pc_puzzle_crossword_info_page = add_submenu_page(
$this->getPluginSlug(),
$displayName,
$displayName,
$capab,
$this->getPluginInfoSlug(),
array( &$this, 'puzzle_crossword_info'),
155
);
}
protected function addReleasesPage(){
global $pc_puzzle_crossword_releases_page;
$displayName = $this->getPluginReleasesDisplayName();
$capab = current_user_can( self::ACCESS_RELEASES ) ? self::ACCESS_RELEASES : 'manage_options';
$pc_puzzle_crossword_releases_page = add_submenu_page(
$this->getPluginSlug(),
$displayName,
$displayName,
$capab,
$this->getPluginReleasesSlug(),
array( &$this, 'puzzle_crossword_releases'),
165
);
}
public function crossword_feedback_uninstall(){
PcPuzzleCrossword_Includes::crossword_add_feedback_form();
}
public function puzzle_shortcodes_init(){
add_shortcode( PC_PUZZLE_CROSSWORD_SHORTCODE, array( &$this, 'pc_shortcode_puzzle') );
}
public function pc_shortcode_puzzle( $atts, $content, $tag ){
// normalize attribute keys, lowercase
$atts = array_change_key_case((array)$atts, CASE_LOWER);
$wporg_atts = shortcode_atts([
'id' => '',
'name' => ''
], $atts, $tag);
$short_id = $wporg_atts['id'];
$short_name = $wporg_atts['name'];
$puzzle_obj = null;
if( $short_id != '' ){
$puzzle_obj = $this->getCrosswordById( $short_id );
}else{
return $content;
}
if( $puzzle_obj == null )
return $content;
$rules_check = $this->rules_continue( $short_id );
if( ! $rules_check['lok'] ){
return $rules_check['message'];
}
$data_json = unserialize( $puzzle_obj->data_json );
$data_json = json_decode( $data_json );
//$data_json = stripcslashes( $data_json );
$table_data = wp_json_encode( $data_json->table_data, ( JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_NUMERIC_CHECK ) );
$hor_clues = wp_json_encode( $data_json->hor_clues, (JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_NUMERIC_CHECK ) );
$ver_clues = wp_json_encode( $data_json->ver_clues, (JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_NUMERIC_CHECK) );
//get custom menu template, and custom menu template per puzzle
$menu_template = $this->get_custom_template('PcPuzzleCrosswordTemplate_MenuFront.php');
$print_header_template = '';
$puzzle_top_template = $this->get_custom_template('PcPuzzleCrosswordTemplate_TopSection.php');
$puzzle_bottom_template = '';
$puzzle_clues_template = $this->get_custom_template('PcPuzzleCrosswordTemplate_Clues.php');
$puzzle_info_template = $this->get_custom_template('PcPuzzleCrosswordTemplate_Info.php');
$default_settings_arr = $this->pc_get_default_settings();
if( isset( $default_settings_arr['menu']['general']['showInfoTemplate'] ) &&
( $default_settings_arr['menu']['general']['showInfoTemplate'] === true )
) {
//load from template
$default_settings_arr['info'] = wp_kses_post( $puzzle_info_template );
}
$default_settings = wp_json_encode( $default_settings_arr, ( JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_NUMERIC_CHECK ) );
$plugin_version = PC_PUZZLE_CROSSWORD_VER;
$nonce = wp_create_nonce( self::NONCE_NAME );
$nonce_name = self::NONCE_NAME;
$ajax_url = admin_url('admin-ajax.php');
$show_answers = false;
$answers_data = wp_json_encode( $data_json->answer_data, ( JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_NUMERIC_CHECK ) );
$show_answers = $show_answers ? 'true' : 'false';
$content .= "
";
if( $puzzle_obj !== null ){
wp_enqueue_script('pc-puzzle-script-vue',
PC_PUZZLE_CROSSWORD_URL.'/assets/js/back/vue-prod.min.js', '', $this->getVersion(), false );
wp_enqueue_style( 'pc_puzzle_custom_style', PC_PUZZLE_CROSSWORD_URL.'/assets/css/front/front-crossword.css' . '?v='.$this->getVersion() );
wp_enqueue_script('pc-puzzle-script-main-front',
PC_PUZZLE_CROSSWORD_URL.'/assets/js/front/js-front-crossword.js' . '?v='.$this->getVersion(),
'', null, array('in_footer' => true) );
}
return $content;
}
private function rules_continue( $puzzle_id ){
$result = array(
'lok' => true,
'message' => ''
);
try {
//code...
$rules = $this->get_rules();
$cross_rules = (array) json_decode( $this->get_crosswordRules() );
if( isset( $cross_rules[ $puzzle_id ] )){
$added_rules = $cross_rules[ $puzzle_id ];
//anonymous users
if( ! is_user_logged_in() ){
$skip_rule_anon = apply_filters('crossowrd_skip_rule_anon', false, $puzzle_id );
if( ! $skip_rule_anon && $added_rules->au ){
$au_rules = $rules['login_rules']->au;
$au_template = $this->get_custom_template( 'PcPuzzleCrosswordTemplate_AnonUser.php' );
$bg_image = trim( $au_rules->img_url ) != '' ? esc_url( $au_rules->img_url ) : '';
$bg_image = $bg_image != '' ? "background-image: url(\"$bg_image\");" : '';
$text = $au_rules->text;
$current_url = home_url($_SERVER['REQUEST_URI']);
$login_url = trim( $au_rules->red_url ) != '' ? add_query_arg( 'redirect_to', urlencode( $current_url ), esc_html( $au_rules->red_url ) ) : '';
$login_url = $login_url == '' ? wp_login_url( $current_url ) : $login_url;
$login_text = " onclick=\"window.location.href='$login_url';\" ";
$au_template = str_replace('{bgimage}', $bg_image , $au_template );
$au_template = str_replace('{text}', $text , $au_template );
$au_template = str_replace('{onclicklogin}', $login_text , $au_template );
$result['lok'] = false;
$result['message'] = $au_template;
}
}else{ //logged in users
}
}
}catch (\Throwable $th) {
error_log('Filtering Rules Error');
error_log( $th->getMessage() );
}
return $result;
}
private function get_custom_template( $template_name ){
$result = '';
ob_start();
locate_template( $template_name, true );
$result = ob_get_contents();
if( $result == ''){
$path = PC_PUZZLE_CROSSWORD_PATH . "templates/$template_name";
load_template( $path , false );
$result = ob_get_contents();
}
ob_end_clean();
return $result;
}
private function default_settings(){
return array(
'general' => array(
'highlightAnswers' => true,
'colorCorrect' => 'rgba(128, 240, 171, 0.7)',
'colorWrong' => 'rgba(241, 193, 193, 0.7)',
'timeCheck' => 1,
'extraOne' => '',
'extraTwo' => '',
'extraThree' => '',
'extraFour' => '',
'extra1' => 0,
'extra2' => 0,
'extra3' => 1,
'extra4' => 1
),
'menu' => array(
'general' => array(
'showMenu' => false,
'showDownloadEmptyPuzzlePdf' => false,
'showPrintEmptyPuzzle' => false,
'showPrintCurrentState' => true,
'showRememberSettings' => true,
'skipFilledCells' => true,
'showCellSizeAdjs' => true,
'showCellFontSize' => true,
'showFontSizeClueNo' => true,
'colorDefaultBlank' => '#565a7b',
'colorDefaultHighlighted' => '#ebd700',
'colorDefaultFocused' => '#2b0dbf',
'colorCellText' => '#2b0dbf',
'reportBugEmail' => '',
'showInfo' => true,
'showInfoTemplate' => true
)
),
'sizes' => array(
'desktop' => array(
'low' => 1200,
'cellSize' => 34,
'fontSize' => 1.3,
'fontSizeClueNo' => 0.7
),
'laptop' => array(
'cellSize' => 30,
'fontSize' => 1.2,
'fontSizeClueNo' => 0.7
),
'tablet' => array(
'high' => 768,
'cellSize' => 26,
'fontSize' => 1.1,
'fontSizeClueNo' => 0.7
),
'mobile' => array(
'low' => 0,
'high' => 576,
'cellSize' => 24,
'fontSize' => 1,
'fontSizeClueNo' => 0.7
)
),
'labels' => array(
'general' => array(
'across_clues' => esc_html__( 'Across Clues', 'advanced-crossword' ),
'down_clues' => esc_html__( 'Down Clues', 'advanced-crossword' ),
'clue_display' => esc_html__( 'Clue Display - Press on any cell to start', 'advanced-crossword'),
'clue' => esc_html__( 'Clue', 'advanced-crossword'),
'cell' => esc_html__( 'Cell', 'advanced-crossword'),
'puzzle' => esc_html__( 'Puzzle', 'advanced-crossword'),
),
'menu' => array(
),
'message' => array(
)
),
'info' => ''
);
}
private function pc_get_default_settings(){
$opt_settings = $this->getDefaultSettings();
if( $opt_settings == '' ){
return $this->default_settings();
}else{
/*
if( ! isset( $opt_settings['general']) ){
$opt_settings['general'] = $this->pc_load_general_settings();
}
*/
$result = unserialize( $opt_settings );
$result = $this->pc_update_default_settings( $result );
return $result;
}
}
private function pc_load_general_settings(){
return array(
'highlightAnswers' => true,
'colorCorrect' => 'rgba(128, 240, 171, 0.7)',
'colorWrong' => 'rgba(241, 193, 193, 0.7)',
'timeCheck' => 2,
'extraOne' => '',
'extraTwo' => '',
'extraThree' => '',
'extraFour' => '',
'extra1' => 0,
'extra2' => 0,
'extra3' => 1,
'extra4' => 1
);
}
private function pc_update_default_settings( $saved_settings ){
$def_settings = $this->default_settings();
$saved_settings = json_decode( wp_json_encode( $saved_settings ), true );
foreach( $def_settings as $key=>$item ){
if( ! isset( $saved_settings[ $key ] ) ){
$saved_settings[ $key ] = $def_settings[ $key ];
}
if( is_array( $item ) ){
foreach( $item as $key2=>$item2 ){
if( ! isset( $saved_settings[ $key ][ $key2 ] ) ){
$saved_settings[ $key ][ $key2 ] = $def_settings[$key][ $key2 ];
}
if( is_array( $item2 ) ){
foreach( $item2 as $key3=>$item3 ){
if( ! isset( $saved_settings[$key][$key2][ $key3 ] ) ){
$saved_settings[$key][$key2][ $key3 ] = $def_settings[$key][$key2][ $key3 ];
}
}
}
}
}
}
return $saved_settings;
}
private function pc_set_default_settings( $settings ){
foreach( $settings as $key=>$value ){
//$this->sanitize_array( $settings, $key );
if( $key == 'info' ){
$settings[ $key ] = wp_kses_post( $settings[ $key ]);
}else{
if( is_array( $value )){
foreach( $value as $key2=>$value2 ){
$text = wp_json_encode( $value2 );
$txt_to_sanitize = sanitize_text_field( $text );
$value_array = json_decode( $txt_to_sanitize, true );
$settings[ $key ][ $key2 ] = $value_array;
}
}
}
}
$str_opt = serialize( $settings );
$this->setDefaultSettings( $str_opt );
}
public function puzzle_admin_actions(){
if( isset( $_POST['data'] ) &&
is_user_logged_in() &&
( current_user_can( 'manage_options' ) ||
current_user_can( self::ACCESS_CRU_CROSSWORD )
) &&
is_admin() ){
if ( ! isset( $_POST['nonce'] )
|| ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_POST['nonce'] ) ), 'pc_secure_action' )
) {
//did not verify
echo wp_json_encode(
array( 'response' => false,
'message' => esc_html__( 'The page did not pass the verification test', 'advanced-crossword' )
)
);
die();
}
$data_obj = wp_unslash( $_POST['data'] );
$data_json = json_decode( $data_obj );
$page_action = sanitize_text_field( wp_unslash( $_POST['page_action'] ));
//rules page
if( $page_action === self::PUZZLE_ACTION_SAVE_RULES ){
if( trim( $data_json->lu->img_url ) != ''){
$data_json->lu->img_url = sanitize_url( wp_unslash( $data_json->lu->img_url ));
}
if( trim( $data_json->lu->red_url ) != ''){
$data_json->lu->red_url = sanitize_url( wp_unslash( $data_json->lu->red_url ));
}
$data_json->lu->text = wp_kses_post( wp_unslash( $data_json->lu->text ));
if( trim( $data_json->au->img_url ) != ''){
$data_json->au->img_url = sanitize_url( wp_unslash( $data_json->au->img_url ));
}
if( trim( $data_json->au->red_url ) != ''){
$data_json->au->red_url = sanitize_url( wp_unslash( $data_json->au->red_url ));
}
$data_json->au->text = wp_kses_post( wp_unslash( $data_json->au->text ));
$data_array = array();
$data_array['login_rules'] = $data_json;
$data_array = $this->set_rules( $data_array );
echo wp_json_encode(
array( 'response' => 'fine',
'data' => $this->get_rules(),
'type' => gettype( $data_array )
)
);
die();
}
$data_obj = sanitize_text_field( wp_unslash( $data_obj ) );
if( $page_action == self::SAVE_CROSS_RULES ){
$data_obj = wp_unslash( $data_obj );
$this->set_crosswordRules( $data_obj );
echo wp_json_encode(
array(
'response' => 'fine',
'data' => wp_unslash( $this->get_crosswordRules() )
)
);
die();
}
//settings page
if( $page_action === self::PUZZLE_ACTION_SAVE_SETTINGS ){
$data_array = json_decode( wp_json_encode( $data_json ), true );
$data_array = $this->pc_set_default_settings( $data_array );
echo wp_json_encode(
array( 'response' => 'fine',
'data' => $this->pc_get_default_settings(),
'type' => gettype( $data_array )
)
);
die();
}
//crossword actions
$h_clues_santzd = $this->sanitize_clues( $data_json->hor_clues );
$v_clues_santzd = $this->sanitize_clues( $data_json->ver_clues );
$data_json->hor_clues = $h_clues_santzd;
$data_json->ver_clues = $v_clues_santzd;
$data_json->puzzle_name = sanitize_text_field( wp_unslash( $data_json->puzzle_name ) );
$data_json->rows_no = 15;
$data_json->cols_no = 15;
$data_json->answer_data = unserialize( sanitize_text_field( serialize( $data_json->answer_data )));
$data_obj = sanitize_text_field( wp_json_encode( $data_json ) );
$puzzle_name = isset( $_POST['puzzle_name'] ) ? sanitize_text_field( $_POST['puzzle_name'] ) : '';
$rows_no = 15;
$cols_no = 15;
$user_id = get_current_user_id();
$puzzle_id = (int) isset( $_POST['puzzle_id']) ? sanitize_text_field( $_POST['puzzle_id'] ) : -2;
$answer_from_date = isset( $_POST['answer_from_date'] ) ? sanitize_text_field ( $_POST['answer_from_date'] ) : '';
$answer_from_time = isset( $_POST['answer_from_time'] ) ? sanitize_text_field( $_POST['answer_from_time'] ) : '';
$answer_from = $answer_from_date . ' ' . $answer_from_time;
$message = '';
$result = false;
$answer_from_number = '';
if( $answer_from_date !== ''){
$answer_from_number = strtotime( $answer_from_date . ' ' . $answer_from_time );
}
if( self::PUZZLE_ACTION_NEW == $page_action ){
$insert_data = array(
'pc_name' => $puzzle_name,
'rows_no' => $rows_no,
'cols_no' => $cols_no,
'is_active' => 1,
'data_json' => $data_obj,
'user_id' => $user_id,
'answer_from' => $answer_from,
'pdf_filename' => '',
'answer_from_no' => $answer_from_number
);
try {
//code...
$result = $this->insertNewCrossword( $insert_data );
if( $result ){
$puzzle_id = $this->getLastInsertedId();
}
}catch( Exception $e ){
$result = false;
$message = esc_html__('Could not save the crossword puzzle', 'advanced-crossword' );
error_log( $e->getMessage() );
}
}else if( self::PUZZLE_ACTION_EDIT == $page_action &&
$puzzle_id > -1 ){
$insert_data = array(
'pc_name' => $puzzle_name,
'rows_no' => $rows_no,
'cols_no' => $cols_no,
'data_json' => $data_obj,
'answer_from' => $answer_from,
'answer_from_no' => $answer_from_number
);
try {
$result = $this->updateCrossword(
$puzzle_id, $insert_data );
} catch (\Throwable $th) {
$result = false;
$message = esc_html__('Could not save the crossword puzzle', 'advanced-crossword' );
error_log( $th->getMessage() );
}
//$this->createBlankPdfPuzzle( $table_html, $across_q_html, $down_q_html, $id );
}else if( self::PUZZLE_ACTION_DEL == $page_action ){
}
echo wp_json_encode( array(
'response' => $result,
'message' => $message,
'puzzle_id' => (int)$puzzle_id,
'lastAction' => $page_action
), ( JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_NUMERIC_CHECK )
);
die;
}
echo wp_json_encode(
array(
'response' => false,
'message' => esc_html__('You dont have permission for such action', 'advanced-crossword') )
);
die;
}
private function sanitize_clues( $data_clues ){
foreach( $data_clues as $clue ){
if( isset( $clue->q )){
$clue->q = sanitize_text_field( $clue->q );
}
}
return $data_clues;
}
public function puzzle_crossword_settings(){
if( is_user_logged_in() &&
( current_user_can( 'manage_options' ) ||
current_user_can( self::ACCESS_SETTINGS )
)
&&
is_admin() ){
$data = array(
'main' => $this->pc_get_default_settings()
);
W_PcPuzzleCrosswords_Settings::pcpuzzle_settingsPage( $data );
}
}
public function puzzle_crossword_main(){
if( is_user_logged_in() &&
( current_user_can( 'manage_options' ) ||
current_user_can( self::ACCESS_D_CROSSWORD ) ||
current_user_can( self::ACCESS_CRU_CROSSWORD ) ) &&
is_admin() ){
$action = '';
if( isset( $_GET['action'] ) )
$action = sanitize_text_field( $_GET['action'] );
$new_url = admin_url( 'admin.php?page=' . urlencode( $this->getPluginSlug() ) );
if( $action == 'new' || $action == 'edit'){
if ( ! isset( $_GET['_wpnonce'] ) || ! wp_verify_nonce(
sanitize_text_field( wp_unslash( $_GET['_wpnonce'] ) ), 'view_page' ) ) {
// Actions to do should the nonce is invalid
die('Page did not verify');
}
$id = '';
if( $action == 'new'){
$data = null;
}else{
$action = 'edit';
$id = sanitize_text_field( $_GET['id'] );
$data = $this->getCrosswordById( $id );
}
W_PcPuzzleCrosswords_View::pcpuzzle_addPage( $new_url, $data, $action, $id );
}else{
if( $action == 'delete'){
if ( ! isset( $_GET['_wpnonce'] ) || ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_GET['_wpnonce'] ) ), 'view_page' ) ) {
// Actions to do should the nonce is invalid
die('Page did not verify');
}
$id = sanitize_text_field( $_GET['id'] );
//delete pdf too
if( current_user_can( 'manage_options' ) || current_user_can( self::ACCESS_D_CROSSWORD ) ){
$this->deleteCrossword( $id );
}
}
$data = $this->getAllCrosswords();
$prize_data = array(
'title' => $this->getPrizeTitle(),
'desc' => $this->getPrizeDesc()
);
$rules = $this->get_crosswordRules();
W_PcPuzzleCrosswords_View::pcpuzzle_viewPage( $new_url, $data, $prize_data, $rules );
}
}
}
public function puzzle_crossword_access(){
if ( is_user_logged_in() &&
( current_user_can( 'manage_options' ) ||
current_user_can( self::ACCESS_RULES )
)
&& is_admin() ) {
$data = $this->get_rules();
W_PcPuzzleCrosswords_Access::pcpuzzle_settingsPageAccess( $data );
}
}
public function puzzle_crossword_info(){
if ( is_user_logged_in() &&
( current_user_can( 'manage_options' ) ||
current_user_can( self::ACCESS_LICENSE )
) && is_admin() ) {
$settings = array(
'license' => false,
'license_txt' => '',
'version' => PC_PUZZLE_CROSSWORD_VER,
'last_checked' => '2020-01-01',
'valid_license' => false
);
W_PcPuzzleCrosswords_License\W_PcPuzzleCrosswords_License::drp_InfoLicensePage( $settings );
}
}
public function puzzle_crossword_releases(){
if ( is_user_logged_in() &&
( current_user_can( 'manage_options' ) ||
current_user_can( self::ACCESS_RELEASES )
) && is_admin() ) {
W_PcPuzzleCrosswords_Releases::drp_InfoReleasesPage();
}
}
protected function prefixTableName($name) {
global $wpdb;
return $wpdb->prefix . strtolower($this->prefix($name));
}
}