Skip to content

Instantly share code, notes, and snippets.

View jastend's full-sized avatar

Jan Sterl jastend

View GitHub Profile
{
"name": "angular-desktop-notification",
"version": "1.1.5",
"description": "A simple HTML5 notification for Angular 1",
"files": ["dist"],
"main": "dist/angular-desktop-notification.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"keywords": [
@jastend
jastend / gist:d394869b4243b8f4dfef
Created April 12, 2015 01:39
Live Control 2.0 (KBS Version) for update from version 1
CREATE TABLE IF NOT EXISTS `lc_notes` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`admin` text NOT NULL,
`adminid` varchar(50) NOT NULL,
`playerid` varchar(50) NOT NULL,
`time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`note` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
@jastend
jastend / gist:e81ea58ebc04d0f38ea9
Created April 12, 2015 01:35
Live Control 2.0 (KBS Version)
CREATE TABLE IF NOT EXISTS `lc_notes` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`admin` text NOT NULL,
`adminid` varchar(50) NOT NULL,
`playerid` varchar(50) NOT NULL,
`time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`note` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
@jastend
jastend / db.php
Created April 11, 2015 19:55
Life Control KBS Altis DB File. Add into /config/
<?php
/**
* Configuration for: Database Connection
*
* For more information about constants please @see http://php.net/manual/en/function.define.php
* If you want to know why we use "define" instead of "const" @see http://stackoverflow.com/q/2447791/1114320
*
* DB_HOST: database host, usually it's "127.0.0.1" or "localhost", some servers also need port info
* DB_NAME: name of the database. please note: database and database table are not the same thing
* DB_USER: user for your database. the user needs to have rights for SELECT, UPDATE, DELETE and INSERT.
@jastend
jastend / UserAction.class.php
Last active August 29, 2015 14:18
Updated UserAction.class.php for Atrox Dev
<?php
namespace wcf\data\user;
use wcf\data\object\type\ObjectTypeCache;
use wcf\data\user\avatar\UserAvatarAction;
use wcf\data\user\group\UserGroup;
use wcf\data\user\UserEditor;
use wcf\data\AbstractDatabaseObjectAction;
use wcf\data\IClipboardAction;
use wcf\data\ISearchAction;
use wcf\system\clipboard\ClipboardHandler;
@jastend
jastend / gist:16eeec33ba470735a8da
Last active August 29, 2015 14:17
Life Control Add Database
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL COMMENT 'auto incrementing user_id of each user, unique index',
`user_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s name, unique',
`user_password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s password in salted and hashed format',
`user_email` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s email, unique',
`playerid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`user_level` enum('1','2','3') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='user data';
INSERT INTO `users` (`user_id`, `user_name`, `user_password_hash`, `user_email`, `playerid`, `user_level`) VALUES
@jastend
jastend / init.lua
Last active August 29, 2015 14:15 — forked from thorwe/init.lua
-- written by https://github.com/thorwe aka philosound in the teamspeak forums
-- Installation:
-- Go to your Teamspeak program folder -> plugins -> lua_plugin
-- Create a new folder, rename it to "notifier"
-- Put this init.lua file in the "notifier" folder
-- Adjust user config below to your needs
-- Start Teamspeak, make sure the lua plugin is enabled in options->plugins
-- Enter the plugin settings, enable the notifier script