Skip to content

Instantly share code, notes, and snippets.

View ziggi's full-sized avatar
🏠
Working from home

Sergei Marochkin ziggi

🏠
Working from home
View GitHub Profile
0000
0001 AIRPORT THRW_BARL_THRW
0002 ATTRACTORS STEPSIT_IN
0003 ATTRACTORS STEPSIT_LOOP
0004 ATTRACTORS STEPSIT_OUT
0005 BAR BARCUSTOM_GET
0006 BAR BARCUSTOM_LOOP
0007 BAR BARCUSTOM_ORDER
0008 BAR BARMAN_IDLE
0009 BAR BARSERVE_BOTTLE
@gatno
gatno / mp.methods
Last active July 11, 2023 13:33
Rage-MP Client Methods
Provided by rage-mp.de
mp.version:
-->mp.version.core
-->mp.version.net
mp._events:
-->mp._events.add
-->mp._events.call
-->mp._events.callRemote
@brijrajsingh
brijrajsingh / NotNullToDefault.sql
Created August 23, 2016 07:36
Convert all the NOT NULL Columns in a Mysql database to Default NULL
SELECT CONCAT_WS('.',TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME) col,CONCAT('alter table ',TABLE_NAME,' MODIFY COLUMN ', COLUMN_NAME,' ',DATA_TYPE,'(',CHARACTER_MAXIMUM_LENGTH,') NULL DEFAULT NULL') as script_col
FROM information_schema.COLUMNS
WHERE is_nullable=0
and length(COLUMN_DEFAULT) is NULL and
CHARACTER_MAXIMUM_LENGTH is not NULL and
table_schema = 'dbName'
Union
SELECT CONCAT_WS('.',TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME) col,CONCAT('alter table ',TABLE_NAME,' MODIFY COLUMN ', COLUMN_NAME,' ',DATA_TYPE,' NULL DEFAULT NULL') as script_col
FROM information_schema.COLUMNS
WHERE is_nullable=0
@ranacseruet
ranacseruet / VideoStream.php
Last active February 19, 2024 17:10
PHP VideoStream class for HTML5 video streaming
<?php
/**
* Description of VideoStream
*
* @author Rana
* @link http://codesamplez.com/programming/php-html5-video-streaming-tutorial
*/
class VideoStream
{
private $path = "";