WordPress.org
Get WordPress

Plugin Directory

Changeset 1055323


Ignore:
Timestamp:
12/28/2014 04:56:15 AM (11 years ago)
Author:
TheCertifiedTech
Message:

Updated: Plugin Now Retains Gamertag So Data Can Re-Sync If API or Xbox Live Goes Offline Then Back Online.

Location:
mygamertag/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • mygamertag/trunk/MyGamerTag.php

    r1055251 r1055323  
    55Plugin URI: http://thecertifiedtech.net
    66Description: Pulls Xbox Gamertag Info And Displays In Widget
    7 Version: 1.0
     7Version: 1.1
    88Author: Paul Dow
    99Author URI: http://thecertifiedtech.net
    1010 */
    11  ?>
    12 <?php
    13 /* 
     11?>
     12<?php
     13 /*
    1414Copyright 2014  Paul Dow  (email : thecertifiedtech@outlook.com)
    1515
    … …  
    3131global $MGT_db_version;
    3232$MGT_db_version = '1.0';
    33 
    3433function MGT_install() {
    3534    global $wpdb;
    36        
    3735    $table_name = $wpdb->prefix . "MyGamerTag";
    38    
    3936    $charset_collate = $wpdb->get_charset_collate();
    40 
    4137    $sql = "CREATE TABLE $table_name (
    4238        id mediumint(9) NOT NULL,
    4339        time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    44         gamertag varchar(60) NOT NULL,
     40        gamertag varchar(250) NOT NULL,
    4541        xboxapikey varchar(250) NOT NULL,
    4642        gamerscore varchar(60) NOT NULL,
    … …  
    5147        UNIQUE KEY id (id)
    5248    ) $charset_collate;";
    53 
    5449    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
    5550    dbDelta( $sql );
    56    
    5751    add_option( 'MGT_db_version', $MGT_db_version );
     52    $wpdb->insert("$table_name", array(
     53   "gamertag" => "ENTER-GAMERTAG",
     54   "xboxapikey" => "ENTER-XBOXAPIKEY"
     55   ));
    5856}
    5957register_activation_hook( __FILE__, 'MGT_install' );
    60 ?>
    61 <?php
    6258function MGT_uninstall() {
    6359    global $wpdb;
    64    
    6560    $table_name = $wpdb->prefix . "MyGamerTag";
    66    
    6761     $sql = "DROP TABLE IF EXISTS $table_name;";
    6862     //die($sql);
    … …  
    7165}
    7266register_deactivation_hook( __FILE__, 'MGT_uninstall' );
    73 ?>
    74 <?php
    7567class MyGamerTag extends WP_Widget
    7668{
    … …  
    8678  extract( $args, EXTR_SKIP);
    8779  $title = ($instance['title']);
    88 //
    89 global $wpdb;
    90 $table_name = $wpdb->prefix . 'MyGamerTag';
    91 $userdata = $wpdb->get_row("SELECT * FROM ".$table_name."");
    92 
     80global $wpdb;
     81$table_name = $wpdb->prefix . 'MyGamerTag';
     82$id = 0;$userdata = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".$table_name." WHERE id = %d", $id));
    9383$currentgamertag = $userdata->gamertag;
    9484$currentgamerscore = $userdata->gamerscore;
    95 $currentname = $userdata->name;
    96 $currentlocation = $userdata->location;
    9785$currenttier = $userdata->tier;
    9886$currentrep = $userdata->xboxonerep;
    … …  
    10088$currentgamerpic = $userdata->gamerpic;
    10189$currentupdatetime = $userdata->time;
    102     ?>
     90?>
    10391<?php echo $before_widget; ?>
    10492<?php echo $before_title . $title . $after_title; ?>
    … …  
    150138function MGT_settings()
    151139{
    152 ?>
    153 <?php
    154 global $wpdb;
    155 $table_name = $wpdb->prefix . 'MyGamerTag';
    156 $userdata = $wpdb->get_row("SELECT * FROM ".$table_name."");
     140global $wpdb;
     141$table_name = $wpdb->prefix . 'MyGamerTag';
     142$id = 0;$userdata = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".$table_name." WHERE id = %d", $id));
    157143$currentgamertag = $userdata->gamertag;
    158144$currentxboxapikey = $userdata->xboxapikey;
    … …  
    195181$cleangamertag = rawurlencode($_POST['gamertag']);
    196182$wpdb->replace( $table_name, array( 'gamertag' => $cleangamertag, 'xboxapikey' => $_POST['xboxapikey'] ) );
    197 //
    198183do_action('xbox_api','execute_xboxapi');
    199 //
    200184echo "  <script type='text/javascript'>
    201185    window.location=document.location.href;
    … …  
    213197{
    214198global $wpdb;
    215 //
    216 $table_name = $wpdb->prefix . 'MyGamerTag';
    217 $userdata = $wpdb->get_row("SELECT * FROM ".$table_name."");
     199$table_name = $wpdb->prefix . 'MyGamerTag';
     200$id = 0;$userdata = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".$table_name." WHERE id = %d", $id));
    218201$insertgamertag = $userdata->gamertag;
    219202$insertxboxapikey = $userdata->xboxapikey;
    220 //
    221203$url = "https://xboxapi.com/v2/".$insertgamertag."/profile";
    222204$headers = array("X-AUTH: ".$insertxboxapikey."");
    … …  
    227209curl_close($ch);
    228210$pdata = json_decode ( $presult );
    229 $table_name = $wpdb->prefix . 'MyGamerTag';
    230 $wpdb->replace(
     211$id = 0;
     212$table_name = $wpdb->prefix . 'MyGamerTag';
     213$wpdb->update(
    231214        $table_name,
    232215       array(
    … …  
    234217                'gamerpic'  => $pdata->GameDisplayPicRaw,
    235218                'gamerscore'    => $pdata->Gamerscore,
    236                 'gamertag' => $pdata->Gamertag,
     219                'gamertag' => $userdata->gamertag,
    237220                'xboxonerep' => $pdata->XboxOneRep,
    238221                'xboxapikey' => $userdata->xboxapikey,
    239                 )               
     222                ),                array('ID' => $id)               
    240223            );
    241224//

  • mygamertag/trunk/readme.txt

    r1055251 r1055323  
    11=== MyGamerTag ===
    22Contributors: TheCertifiedTech
    3 Donate link: https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=DZ3KJZTST5WVA&lc=US&item_name=TheCertifiedTech&item_number=Development%20Support&currency_code=USD&bn=PP%2dDonationsBF%3abtn_donate_LG%2egif%3aNonHosted
     3Donate link: https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=DZ3KJZTST5WVA&lc=US&item_name=Paul%20Dow%20%2d%20TheCertifiedTech&item_number=Development%20Support&currency_code=USD&bn=PP%2dDonationsBF%3abtn_donateCC_LG%2egif%3aNonHosted
    44Tags: gaming, gamertag, xbox, gamerscore, achievements
    55Requires at least: 4.0
    66Tested up to: 4.1
    7 Stable tag: 1.0
     7Stable tag: 1.1
    88License: GPLv2 or later
    99License URI: http://www.gnu.org/licenses/gpl-2.0.html
    … …  
    2727
    2828= Option 1 =
     291. Click 'Add New' -> Search WordPress Plugin Directory For 'MyGamerTag'.
     301. Click 'Install Now' Then Click 'Activate'.
     31
     32= Option 2 =
    29331. Unzip 'MyGamerTag.zip' Upload the `MyGamerTag` folder to the `/wp-content/plugins/` directory.
    30341. Activate the plugin through the 'Plugins' menu in WordPress.
    3135
    32 = Option 2 =
     36= Option 3 =
    33371. Click 'Add New' -> 'Upload Plugin' -> 'Choose File' -> Choose The 'MyGamerTag.zip' that you downloaded.
    34 1. Then Activate Plugin
     381. Activate the plugin through the 'Plugins' menu in WordPress.
    3539
    3640You will find 'MGT' settings menu in your WordPress admin panel on the left side.
    … …  
    5761== Changelog ==
    5862
     63= 1.1 =
     64
     65* Plugin Now Retains Gamertag So Data Can Re-Sync If API or Xbox Live Goes Offline Then Back Online.
     66
    5967= 1.0 =
    6068
    … …  
    6371== Upgrade Notice ==
    6472
     73= 1.1 =
     74
     75* Plugin Now Retains Gamertag So Data Can Re-Sync If API or Xbox Live Goes Offline Then Back Online.
     76
    6577= 1.0 =
    6678
Note: See TracChangeset for help on using the changeset viewer.