Jump to content

walisonfox

Members
  • Content count

    8
  • Joined

  • Last visited

Community Reputation

0 Comum

About walisonfox

  1. walisonfox

    Adicionar um modal

    Olá pessoal. Tenho um plugin: wti-like-post do wordpress. Preciso de criar um função quando clicar na imagem de unlike aparecer um modal para comentar o unlike (Não curtiu) e não estou conseguindo: Segue os codigos: wti_like_post_site.php: /** * Get the like output on site * @param array * @return string */ function GetWtiLikePost($arg = null) { global $wpdb; $post_id = get_the_ID(); $wti_like_post = ""; // Get the posts ids where we do not need to show like functionality $allowed_posts = explode(",", get_option('wti_like_post_allowed_posts')); $excluded_posts = explode(",", get_option('wti_like_post_excluded_posts')); $excluded_categories = get_option('wti_like_post_excluded_categories'); $excluded_sections = get_option('wti_like_post_excluded_sections'); if (empty($excluded_categories)) { $excluded_categories = array(); } if (empty($excluded_sections)) { $excluded_sections = array(); } $title_text = get_option('wti_like_post_title_text'); $category = get_the_category(); $excluded = false; // Checking for excluded section. if yes, then dont show the like/dislike option if ((in_array('home', $excluded_sections) && is_home()) || (in_array('archive', $excluded_sections) && is_archive())) { return; } // Checking for excluded categories foreach($category as $cat) { if (in_array($cat->cat_ID, $excluded_categories) && !in_array($post_id, $allowed_posts)) { $excluded = true; } } // If excluded category, then dont show the like/dislike option if ($excluded) { return; } // Check for title text. if empty then have the default value if (empty($title_text)) { $title_text_like = __('Like', 'wti-like-post'); $title_text_unlike = __('Unlike', 'wti-like-post'); } else { $title_text = explode('/', get_option('wti_like_post_title_text')); $title_text_like = $title_text[0]; $title_text_unlike = isset( $title_text[1] ) ? $title_text[1] : ''; } // Checking for excluded posts if (!in_array($post_id, $excluded_posts)) { // Get the nonce for security purpose and create the like and unlike urls $nonce = wp_create_nonce("wti_like_post_vote_nonce"); $ajax_like_link = admin_url('admin-ajax.php?action=wti_like_post_process_vote&task=like&post_id=' . $post_id . '&nonce=' . $nonce); $ajax_unlike_link = admin_url('admin-ajax.php?action=wti_like_post_process_vote&task=unlike&post_id=' . $post_id . '&nonce=' . $nonce); $like_count = GetWtiLikeCount($post_id); $unlike_count = GetWtiUnlikeCount($post_id); $msg = GetWtiVotedMessage($post_id); $alignment = ("left" == get_option('wti_like_post_alignment')) ? 'align-left' : 'align-right'; $show_dislike = get_option('wti_like_post_show_dislike'); $style = (get_option('wti_like_post_voting_style') == "") ? 'style1' : get_option('wti_like_post_voting_style'); $wti_like_post .= "<div class='watch-action'>"; $wti_like_post .= "<div class='watch-position " . $alignment . "'>"; $wti_like_post .= "<div class='action-like'>"; $wti_like_post .= "<a class='lbg-" . $style . " like-" . $post_id . " jlk' href='javascript:void(0)' data-task='like' data-post_id='" . $post_id . "' data-nonce='" . $nonce . "' rel='nofollow'>"; $wti_like_post .= "<img src='" . plugins_url( 'images/pixel.gif' , __FILE__ ) . "' title='" . __($title_text_like, 'wti-like-post') . "' />"; $wti_like_post .= "<span class='lc-" . $post_id . " lc'>" . $like_count . "</span>"; $wti_like_post .= "</a></div>"; if ($show_dislike) { $wti_like_post .= "<div class='action-unlike'>"; $wti_like_post .= "<a class='unlbg-" . $style . " unlike-" . $post_id . " jlk' href='javascript:void(0)' data-task='unlike' data-post_id='" . $post_id . "' data-nonce='" . $nonce . "' rel='nofollow'>"; $wti_like_post .= "<img src='" . plugins_url( 'images/pixel.gif' , __FILE__ ) . "' title='" . __($title_text_unlike, 'wti-like-post') . "' />"; $wti_like_post .= "<span class='unlc-" . $post_id . " unlc'>" . $unlike_count . "</span>"; $wti_like_post .= "</a></div> "; } $wti_like_post .= "</div> "; $wti_like_post .= "<div class='status-" . $post_id . " status " . $alignment . "'>" . $msg . "</div>"; $wti_like_post .= "</div><div class='wti-clear'></div>"; } if ($arg == 'put') { return $wti_like_post; } else { echo $wti_like_post; } } /** * Show the like content * @param $content string * @param $param string * @return string */ function PutWtiLikePost($content) { $show_on_pages = false; if ((is_page() && get_option('wti_like_post_show_on_pages')) || (!is_page())) { $show_on_pages = true; } if (!is_feed() && $show_on_pages) { $wti_like_post_content = GetWtiLikePost('put'); $wti_like_post_position = get_option('wti_like_post_position'); if ($wti_like_post_position == 'top') { $content = $wti_like_post_content . $content; } elseif ($wti_like_post_position == 'bottom') { $content = $content . $wti_like_post_content; } else { $content = $wti_like_post_content . $content . $wti_like_post_content; } } return $content; } add_filter('the_content', 'PutWtiLikePost'); /** * Get already voted message * @param $post_id integer * @param $ip string * @return string */ function GetWtiVotedMessage($post_id, $ip = null) { global $wpdb, $wti_ip_address; $wti_voted_message = ''; $voting_period = get_option('wti_like_post_voting_period'); if (null == $ip) { $ip = $wti_ip_address; } /*$query = $wpdb->prepare( "SELECT COUNT(id) AS has_voted FROM {$wpdb->prefix}wti_like_post WHERE post_id = %d AND ip = %s", $post_id, $ip );*/ if ($voting_period != 0 && $voting_period != 'once') { // If there is restriction on revoting with voting period, check with voting time $last_voted_date = GetWtiLastDate($voting_period); //$query .= " AND date_time >= '$last_voted_date'"; $query = $wpdb->prepare( "SELECT COUNT(id) AS has_voted FROM {$wpdb->prefix}wti_like_post WHERE post_id = %d AND ip = %s AND date_time >= %s", $post_id, $ip, $last_voted_date ); } else { $query = $wpdb->prepare( "SELECT COUNT(id) AS has_voted FROM {$wpdb->prefix}wti_like_post WHERE post_id = %d AND ip = %s", $post_id, $ip ); } $wti_has_voted = $wpdb->get_var($query); if ($wti_has_voted > 0) { $wti_voted_message = get_option('wti_like_post_voted_message'); } return $wti_voted_message; } add_shortcode('most_liked_posts', 'WtiMostLikedPostsShortcode'); /** * Most liked posts shortcode * @param $args array * @return string */ function WtiMostLikedPostsShortcode($args) { global $wpdb; $most_liked_post = ''; $where = ''; if (isset($args['limit'])) { $limit = $args['limit']; } else { $limit = 10; } if (!empty($args['time']) && $args['time'] != 'all') { $last_date = GetWtiLastDate($args['time']); $where .= " AND date_time >= '$last_date'"; } $posts = $wpdb->get_results( "SELECT post_id, SUM(value) AS like_count, post_title FROM `{$wpdb->prefix}wti_like_post` L, {$wpdb->prefix}posts P WHERE L.post_id = P.ID AND post_status = 'publish' AND value > 0 $where GROUP BY post_id ORDER BY like_count DESC, post_title ASC LIMIT $limit" ); if (count($posts) > 0) { $most_liked_post .= '<table class="most-liked-posts-table">'; $most_liked_post .= '<tr>'; $most_liked_post .= '<td>' . __('Title', 'wti-like-post') .'</td>'; $most_liked_post .= '<td>' . __('Like Count', 'wti-like-post') .'</td>'; $most_liked_post .= '</tr>'; foreach ($posts as $post) { $post_title = stripslashes($post->post_title); $permalink = get_permalink($post->post_id); $like_count = $post->like_count; $most_liked_post .= '<tr>'; $most_liked_post .= '<td><a href="' . $permalink . '" title="' . $post_title . '">' . $post_title . '</a></td>'; $most_liked_post .= '<td>' . $like_count . '</td>'; $most_liked_post .= '</tr>'; } $most_liked_post .= '</table>'; } else { $most_liked_post .= '<p>' . __('No posts liked yet.', 'wti-like-post') . '</p>'; } return $most_liked_post; } add_shortcode('recently_liked_posts', 'WtiRecentlyLikedPostsShortcode'); /** * Get recently liked posts shortcode * @param $args array * @return string */ function WtiRecentlyLikedPostsShortcode($args) { global $wpdb; $recently_liked_post = ''; $where = ''; if ( isset( $args['limit'] ) ) { $limit = $args['limit']; } else { $limit = 10; } $show_excluded_posts = get_option('wti_like_post_show_on_widget'); $excluded_posts = trim( get_option('wti_like_post_excluded_posts') ); $excluded_post_ids = explode(',', get_option('wti_like_post_excluded_posts')); if ( !$show_excluded_posts && !empty( $excluded_posts ) ) { $where = "AND post_id NOT IN (" . $excluded_posts . ")"; } // Get the post IDs recently voted $recent_ids = $wpdb->get_col( "SELECT DISTINCT(post_id) FROM `{$wpdb->prefix}wti_like_post` WHERE value > 0 $where GROUP BY post_id ORDER BY MAX(date_time) DESC" ); if ( count( $recent_ids ) > 0 ) { $where = "AND post_id IN(" . implode(",", $recent_ids) . ")"; // Getting the most liked posts $query = "SELECT post_id, SUM(value) AS like_count, post_title FROM `{$wpdb->prefix}wti_like_post` L, {$wpdb->prefix}posts P WHERE L.post_id = P.ID AND post_status = 'publish' $where GROUP BY post_id ORDER BY FIELD(post_id, " . implode(",", $recent_ids) . ") ASC LIMIT $limit"; $posts = $wpdb->get_results($query); if ( count( $posts ) > 0 ) { $recently_liked_post .= '<table class="recently-liked-posts-table">'; $recently_liked_post .= '<tr>'; $recently_liked_post .= '<td>' . __('Title', 'wti-like-post') .'</td>'; $recently_liked_post .= '</tr>'; foreach ( $posts as $post ) { $post_title = stripslashes($post->post_title); $permalink = get_permalink($post->post_id); $recently_liked_post .= '<tr>'; $recently_liked_post .= '<td><a href="' . $permalink . '" title="' . $post_title . '">' . $post_title . '</a></td>'; $recently_liked_post .= '</tr>'; } $recently_liked_post .= '</table>'; } } else { $recently_liked_post .= '<p>' . __('No posts liked yet.', 'wti-like-post') . '</p>'; } return $recently_liked_post; comments_template(); } /** * Add the javascript for the plugin * @param no-param * @return string */ function WtiLikePostEnqueueScripts() { wp_register_script( 'wti_like_post_script', plugins_url( 'js/wti_like_post.js', __FILE__ ), array('jquery') ); wp_localize_script( 'wti_like_post_script', 'wtilp', array( 'ajax_url' => admin_url( 'admin-ajax.php' ))); wp_enqueue_script( 'jquery' ); wp_enqueue_script( 'wti_like_post_script' ); // Load css file wp_enqueue_style( 'wti_like_post_script', plugins_url( 'css/wti_like_post.css', __FILE__ ) ); } wti_like_post.js: jQuery(document).ready(function(){ jQuery(document).on("click", ".jlk", function(e){ e.preventDefault(); var task = jQuery(this).attr("data-task"); var post_id = jQuery(this).attr("data-post_id"); var nonce = jQuery(this).attr("data-nonce"); jQuery(".status-" + post_id).html(" ").addClass("loading-img").show(); jQuery.ajax({ type : "post", async : false, dataType : "json", url : wtilp.ajax_url, data : {action: "wti_like_post_process_vote", task : task, post_id : post_id, nonce: nonce}, success: function(response) { jQuery(".lc-" + post_id).html(response.like); jQuery(".unlc-" + post_id).html(response.unlike); jQuery(".status-" + post_id).removeClass("loading-img").empty().html(response.msg); load(comments_template()); } }); }); });
  2. walisonfox

    SELECT em Coluna

    Obrigado Motta pela ajuda. Funcionou perfeito.
  3. walisonfox

    SELECT em Coluna

    Obrigado Motta. Deu certo a geração do select .O problema agora que não estou conseguindo concatenar com informações de outra tabela. Estou tentando usar o INNER JOIN mais está dando erro pois no mesmo select estou usando o left JOIN. Tem alguma solução?
  4. walisonfox

    SELECT em Coluna

    Tentei de tudo. Realmente não estou conseguindo. Quem poder me ajudar. Agradeço. Obrigado. umeta_id | user_id | meta_key | meta_value | 1 1 nickname Antonio 2 1 first_name Soares 3 1 last_name Souza 4 1 description Vamos nessa! 5 1 rich_editing true 6 1 comment_shortcuts false 7 1 admin_color fresh 8 1 use_ssl 0 9 2 nickname Jose 10 2 first_name Soares 11 2 last_name Souza 12 2 description Vamos! 13 2 rich_editing true 14 2 comment_shortcuts false 15 2 admin_color fresh 16 2 use_ssl 23
  5. walisonfox

    SELECT em Coluna

    Pesquisei UNPIVOT e PIVOT. Mais não consegui encaixar no meu exemplo..
  6. walisonfox

    SELECT em Coluna

    Boa noite, Pessoal. Eu tenho uma tabela que tenha varias informações em linhas essa tabela e do WORDPRESS. umeta_id | user_id | meta_key | meta_value | 1 1 nickname Antonio 2 1 first_name Soares 3 1 last_name Souza 4 1 description Vamos nessa! 5 1 rich_editing true 6 1 comment_shortcuts false 7 1 admin_color fresh 8 1 use_ssl 0 Como faço para agrupar por user_id e aparecer dentro do mysql assim: Usando o SELECT... user_id | nickname | first_name | last_name | description | rich_editing | comment_shortcuts | admin_color | use_ssl 1 antonio Soares Souza Vamos nessa! true false fresh 0
  7. walisonfox

    Aplicar Marcações nas Imagem

    Olá pessoal. Estou desenvolvendo um site em php onde tem imagem com marcações em alfinete por exemplo. Estou sem saber como fazer. Exemplo: Tem o mapa do brasil, onde tem um alfinete no estado de SP, ao passar o mouse em cima ou ao clicar na imagem do alfinete aparece mais informações. São imagem estáticas. Não estou acessando imagem do google maps.
  8. Olá Pessoal. Estou querendo refazer alguns códigos e AS2 para AS3. Como reescrever em AS3 o código abaixo: on (release) { gotoAndStop(5); tellTarget("/teste") { gotoAndStop("off"); tellTarget("") { } // End of TellTarget } // End of TellTarget } Deste já obrigado Obrigado!
×

Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.