Skip to content

Instantly share code, notes, and snippets.

@ViskoB
ViskoB / GW2_TS3_Auth.sql
Last active November 7, 2015 19:27
GW2 TS3 Authentication - Table
CREATE TABLE IF NOT EXISTS `ts3auth` (
`ts3_uniqueid` varchar(250) NOT NULL,
`gw2_name` varchar(250) NOT NULL,
`gw2_refresh` varchar(250) NOT NULL,
`gw2_apikey` varchar(250) NOT NULL,
`gw2_world` int(11) NOT NULL,
`last_check` datetime NOT NULL,
`dbsessionhash` varchar(250) NOT NULL,
`type` varchar(20) NOT NULL DEFAULT 'oauth',
`keyname` varchar(250) NOT NULL DEFAULT '',
@ViskoB
ViskoB / GW2_TS3_Auth_Cron.php
Last active August 29, 2015 14:20
GW2 TS3 Authentication - Cron
<?php
require_once('TS3F/libraries/TeamSpeak3/TeamSpeak3.php');
require_once('request.inc.php');
$ts3_squeryuser = "squeryuser";
$ts3_squerypass = "squerypass";
$ts3_squery_urlport = "ts3.example.com:10011";
$ts3_server_port = "9987";
$AuthWorldID = 2014; // Set this to your world ID you wish to allow access
@ViskoB
ViskoB / GW2_TS3_Auth.php
Last active August 29, 2015 14:20
GW2 TS3 Authentication - Enter API Key
<?php
require_once('TS3F/libraries/TeamSpeak3/TeamSpeak3.php');
require_once('request.inc.php');
$ts3_squeryuser = "squeryuser";
$ts3_squerypass = "squerypass";
$ts3_squery_urlport = "ts3.example.com:10011";
$ts3_server_port = "9987";
$myTS3FErrors = array();
@ViskoB
ViskoB / request.inc.php
Last active August 29, 2015 14:20
gw2api-tools
<?php
/**
* request.inc.php
* created: 05.06.13 by codemasher (smiley.1438) https://github.com/codemasher/gw2api-tools/blob/master/inc/request.inc.php
* modified: 09.05.15 by moturdrn (Moturdrn.2837) for API v2 Keys
*/
/**
* A small function to request&receive data from the GW2 API.
* Doesn't use CURL and doesn't depend on allow_url_fopen.
*
@ViskoB
ViskoB / gw2_emblems_imagick.php
Last active December 18, 2015 02:09
An attempt to colour Guild Wars 2 guild emblems using PHP and the Imagick library
<?php
/* Guild Wars 2 Emblem Creator Script by Moturdrn.2837
Special thanks to:
- Cliff Spradlin and ArenaNet for making available the API and information
- smiley.1438 and Think.8042 with PHP colour conversion
- smiley.1438 for the gw2_api_request function
- Dr Ishmael.9685 for providing information and downloads of the emblem parts and backgrounds, and the idea to split the matrix and colour conversion functions
- Killer Rhino.6794 for the extra advanced information on working out how to decode the API colour information into something useable
- The general Guild Wars 2 development community for being a bunch of guys and gals ready and willing to help one another out
- Apologies if I've left you out, please contact me and I'll add you in here :)
@ViskoB
ViskoB / gw2_emblems_gd.php
Last active December 18, 2015 02:09
An attempt to colour Guild Wars 2 guild emblems using PHP and the GD library
<?php
/* Guild Wars 2 Emblem Creator Script by Moturdrn.2837
Special thanks to:
- Cliff Spradlin and ArenaNet for making available the API and information
- smiley.1438 and Think.8042 with PHP colour conversion
- smiley.1438 for the gw2_api_request function
- Dr Ishmael.9685 for providing information and downloads of the emblem parts and backgrounds, and the idea to split the matrix and colour conversion functions
- Killer Rhino.6794 for the extra advanced information on working out how to decode the API colour information into something useable
- The general Guild Wars 2 development community for being a bunch of guys and gals ready and willing to help one another out
- Apologies if I've left you out, please contact me and I'll add you in here :)