Ebta Setiawan ebta

## ctags.opt
--langdef=js
--langmap=js:.js
--regex-js=/([A-Za-z0-9._$()]+)[ \t]*[=][ \t]*function[ \t]*\(/\1/,function/
--regex-js=/function[ \t]+([A-Za-z0-9._$]+)[ \t]*\(([^)])\)/\1/,function/
--regex-js=/(var)*[ \t]+(\w+)[ \t]+=/\2/,var/
--langdef=css
--langmap=css:.css
--regex-css=/^[ \t]*\.([A-Za-z0-9_-]+)/.\1/c,class,classes/
--regex-css=/^[ \t]*#([A-Za-z0-9_-]+)/#\1/i,id,ids/
--regex-css=/^[ \t]*(([A-Za-z0-9_-]+[ \t\n,]+)+)\{/\1/t,tag,tags/

## crosstab-query-oracle-month.sql
SELECT
  field_1,
	id_master,
	sum(decode(bln,'01',jumlah)) jan,
	sum(decode(bln,'02',jumlah)) feb,
	sum(decode(bln,'03',jumlah)) mar,
	sum(decode(bln,'04',jumlah)) apr,
	sum(decode(bln,'05',jumlah)) mei,
	sum(decode(bln,'06',jumlah)) jun,
	sum(decode(bln,'07',jumlah)) jul,

## 403forbidden.php
<?php
header('HTTP/1.1 403 Forbidden');
?>
<html>
    <head>
        <title>Congratulations! You have been DENIED access</title>
    </head>
    <body>
        <font size="4">You have been denied access because of the following reasons:<br /><br />
        1.) Too many failed login attempts, so you are likely brute forcing through logins.<br />

## obj_length.js
Object.size = function(obj) {
    var size = 0, key;
    for (key in obj) {
        if (obj.hasOwnProperty(key)) size++;
    }
    return size;
};

// Get the size of an object
var size = Object.size(myArray);

## chmod_recursively.sh
# To recursively give directories read&execute privileges:
find /path/to/base/dir -type d -exec chmod 755 {} +

# To recursively give files read privileges:
find /path/to/base/dir -type f -exec chmod 644 {} +

# Or, if there are many objects to process:
chmod 755 $(find /path/to/base/dir -type d)
chmod 644 $(find /path/to/base/dir -type f)

## fossil-checkout.php
<?php
/* fossil-checkout.php
 * Untuk melakukan checkout fossil di server tanpa harus login SSH
 *
 * Agar bisa berjalan, Fossil butuh HOME variabel : putenv()
 * Add server environment. The environment variable will only exist
 * for the duration of the current request. At the end of the request
 * the environment is restored to its original state
 * */

## formatMoney.js
Number.prototype.formatMoney = function(c, d, t){
var n = this,
    c = isNaN(c = Math.abs(c)) ? 2 : c,
    d = d == undefined ? "." : d,
    t = t == undefined ? "," : t,
    s = n < 0 ? "-" : "",
    i = parseInt(n = Math.abs(+n || 0).toFixed(c)) + "",
    j = (j = i.length) > 3 ? j % 3 : 0;
   return s + (j ? i.substr(0, j) + t : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + t) + (c ? d + Math.abs(n - i).toFixed(c).slice(2) : "");
 };

## fossil.sh
# Menjalankan fossil di server sebagai service
# Jangan sebagai root, karena ada masalah hak akses, jadi perlu user lain
# /repo/path adalah lokasi repository *.fossil
su user -c "nohup fossil server --port 1234 /repo/path > /dev/null 2>&1 &"

## dat2mp4.bat
"C:\Dir\ffmpeg\bin\ffmpeg" -i %1 -vcodec copy -acodec copy "F:\TargetDir\%~n1.mp4"

## update.sh
cd
wget http://www-eu.apache.org/dist//httpd/httpd-2.4.20.tar.gz
tar xf httpd-2.4.12.tar.gz
cd httpd-2.4.12
./configure
make
make install

; if needed, download apr and apr-util from here https://apr.apache.org/download.cgi
; extract and move folder to httpd-2.4.x/srclib, rename with just 'apr' and 'apr-util'
	--langdef=js
	--langmap=js:.js
	--regex-js=/([A-Za-z0-9._$()]+)[ \t][=][ \t]function[ \t]*\(/\1/,function/
	--regex-js=/function[ \t]+([A-Za-z0-9._$]+)[ \t]*\(([^)])\)/\1/,function/
	--regex-js=/(var)*[ \t]+(\w+)[ \t]+=/\2/,var/
	--langdef=css
	--langmap=css:.css
	--regex-css=/^[ \t]*\.([A-Za-z0-9_-]+)/.\1/c,class,classes/
	--regex-css=/^[ \t]*#([A-Za-z0-9_-]+)/#\1/i,id,ids/
	--regex-css=/^[ \t]*(([A-Za-z0-9_-]+[ \t\n,]+)+)\{/\1/t,tag,tags/
	SELECT
	field_1,
	id_master,
	sum(decode(bln,'01',jumlah)) jan,
	sum(decode(bln,'02',jumlah)) feb,
	sum(decode(bln,'03',jumlah)) mar,
	sum(decode(bln,'04',jumlah)) apr,
	sum(decode(bln,'05',jumlah)) mei,
	sum(decode(bln,'06',jumlah)) jun,
	sum(decode(bln,'07',jumlah)) jul,
	<?php
	header('HTTP/1.1 403 Forbidden');
	?>
	<html>
	<head>
	<title>Congratulations! You have been DENIED access</title>
	</head>
	<body>
	<font size="4">You have been denied access because of the following reasons:<br /><br />
	1.) Too many failed login attempts, so you are likely brute forcing through logins.<br />
	Object.size = function(obj) {
	var size = 0, key;
	for (key in obj) {
	if (obj.hasOwnProperty(key)) size++;
	}
	return size;
	};

	// Get the size of an object
	var size = Object.size(myArray);
	# To recursively give directories read&execute privileges:
	find /path/to/base/dir -type d -exec chmod 755 {} +

	# To recursively give files read privileges:
	find /path/to/base/dir -type f -exec chmod 644 {} +

	# Or, if there are many objects to process:
	chmod 755 $(find /path/to/base/dir -type d)
	chmod 644 $(find /path/to/base/dir -type f)
	<?php
	/* fossil-checkout.php
	* Untuk melakukan checkout fossil di server tanpa harus login SSH
	*
	* Agar bisa berjalan, Fossil butuh HOME variabel : putenv()
	* Add server environment. The environment variable will only exist
	* for the duration of the current request. At the end of the request
	* the environment is restored to its original state
	* */
	Number.prototype.formatMoney = function(c, d, t){
	var n = this,
	c = isNaN(c = Math.abs(c)) ? 2 : c,
	d = d == undefined ? "." : d,
	t = t == undefined ? "," : t,
	s = n < 0 ? "-" : "",
	i = parseInt(n = Math.abs(+n \|\| 0).toFixed(c)) + "",
	j = (j = i.length) > 3 ? j % 3 : 0;
	return s + (j ? i.substr(0, j) + t : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + t) + (c ? d + Math.abs(n - i).toFixed(c).slice(2) : "");
	};
	# Menjalankan fossil di server sebagai service
	# Jangan sebagai root, karena ada masalah hak akses, jadi perlu user lain
	# /repo/path adalah lokasi repository *.fossil
	su user -c "nohup fossil server --port 1234 /repo/path > /dev/null 2>&1 &"
	cd
	wget http://www-eu.apache.org/dist//httpd/httpd-2.4.20.tar.gz
	tar xf httpd-2.4.12.tar.gz
	cd httpd-2.4.12
	./configure
	make
	make install

	; if needed, download apr and apr-util from here https://apr.apache.org/download.cgi
	; extract and move folder to httpd-2.4.x/srclib, rename with just 'apr' and 'apr-util'