
Compactos y ligeros, Micrófono para ANC, Tecnología ANC, Bluetooth
Q447.00
{\rtf1\ansi\ansicpg1252\cocoartf2821 \cocoatextscaling0\cocoaplatform0{\fonttbl\f0\fswiss\fcharset0 Helvetica;} {\colortbl;\red255\green255\blue255;} {\*\expandedcolortbl;;} \margl1440\margr1440\vieww11520\viewh8400\viewkind0 \pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0 \f0\fs24 \cf0 prefix . 'banner_clicks';\ $charset_collate = $wpdb->get_charset_collate();\ \ $sql = "CREATE TABLE $table_name (\ id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,\ banner_text VARCHAR(255) NOT NULL,\ banner_url TEXT NOT NULL,\ clicks INT NOT NULL DEFAULT 0\ ) $charset_collate;";\ \ require_once ABSPATH . 'wp-admin/includes/upgrade.php';\ dbDelta($sql);\ \}\ register_activation_hook(__FILE__, 'bct_create_table');\ \ // Enqueue JavaScript\ function bct_enqueue_scripts() \{\ wp_enqueue_script('bct-tracker', plugin_dir_url(__FILE__) . 'tracker.js', array('jquery'), null, true);\ wp_localize_script('bct-tracker', 'bct_ajax', array('ajax_url' => admin_url('admin-ajax.php')));\ \}\ add_action('wp_enqueue_scripts', 'bct_enqueue_scripts');\ \ // AJAX handler to log clicks\ function bct_log_click() \{\ global $wpdb;\ $table_name = $wpdb->prefix . 'banner_clicks';\ \ $banner_text = sanitize_text_field($_POST['banner_text']);\ $banner_url = esc_url_raw($_POST['banner_url']);\ \ $existing = $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_name WHERE banner_text = %s AND banner_url = %s", $banner_text, $banner_url));\ \ if ($existing) \{\ $wpdb->query($wpdb->prepare("UPDATE $table_name SET clicks = clicks + 1 WHERE id = %d", $existing->id));\ \} else \{\ $wpdb->insert($table_name, array('banner_text' => $banner_text, 'banner_url' => $banner_url, 'clicks' => 1));\ \}\ \ wp_die();\ \}\ add_action('wp_ajax_bct_log_click', 'bct_log_click');\ add_action('wp_ajax_nopriv_bct_log_click', 'bct_log_click');\ \ // Add admin menu page\ function bct_admin_menu() \{\ add_menu_page('Banner Click Stats', 'Banner Click Stats', 'manage_options', 'bct-stats', 'bct_display_stats', 'dashicons-chart-bar', 25);\ \}\ add_action('admin_menu', 'bct_admin_menu');\ \ // Display stats in admin panel\ function bct_display_stats() \{\ global $wpdb;\ $table_name = $wpdb->prefix . 'banner_clicks';\ $banners = $wpdb->get_results("SELECT * FROM $table_name ORDER BY clicks DESC");\ echo '
Banner | Destination URL | Clicks |
---|---|---|
\{$banner->banner_text\} | \{$banner->banner_url\} | \{$banner->clicks\} |
No banner clicks recorded yet.
';\ \}\ echo '';\ echo '