All New

Register

Login

All gists

stuzer05 / Decode HeidiSQL export password

0 likes

0 forks

1 files

Last active 1737805613

1	function heidiDecode(hex) {
2	var str = '';
3	var shift = parseInt(hex.substr(-1));
4	hex = hex.substr(0, hex.length - 1);
5	for (var i = 0; i < hex.length; i += 2)
6	str += String.fromCharCode(parseInt(hex.substr(i, 2), 16) - shift);
7	return str;
8	}
9	document.write(heidiDecode('755A5A585C3D8141786B3C385E3A393'));

stuzer05 / Oracle search source code in functions DDL

1 likes

0 forks

1 files

Last active 1731272130

1	SELECT
2	type,
3	name,
4	text
5	FROM
6	all_source
7	WHERE
8	type IN ( 'FUNCTION', 'PROCEDURE' )
9	AND UPPER(text) like UPPER('%EI_KURS_VAL%')
10	ORDER BY type, name

stuzer05 / Go context.WithCancel() example

0 likes

0 forks

1 files

Last active 1718274035

1	func doWork(ctx context.Context) {
2	for {
3	select {
4	case <-ctx.Done():
5	return
6	default:
7	}
8
9	time.Sleep(1 * time.Second)
10	fmt.Println("doing work...")

stuzer05 / Oracle view locked tables

0 likes

0 forks

1 files

Last active 1718092169

1	SELECT o.object_name, o.object_type, l.session_id, l.locked_mode
2	FROM v$locked_object l
3	JOIN dba_objects o ON l.object_id = o.object_id;

stuzer05 / Nginx default vhost configuration

0 likes

0 forks

1 files

Last active 1717238660

1	http {
2
3	server {
4	listen 80 default_server;
5	server_name _;
6
7	return 404;
8	}
9

stuzer05 / PHP show all errors

0 likes

0 forks

1 files

Last active 1714735618

1	ini_set('display_errors', 1);
2	ini_set('display_startup_errors', 1);
3	error_reporting(E_ALL);

stuzer05 / PHP build tree from sql result

0 likes

0 forks

1 files

Last active 1714735592

1	function buildTree(array $elements, $parentId = 0) {
2	$branch = array();
3
4	foreach ($elements as $element) {
5	if ($element['parent_id'] == $parentId) {
6	$children = buildTree($elements, $element['id']);
7	if ($children) {
8	$element['children'] = $children;
9	}
10	$branch[] = $element;

stuzer05 / PHP create in-memory zip archive

0 likes

0 forks

1 files

Last active 1714735548

1	$tmp_file = tmpfile();
2	$tmp_file_path = stream_get_meta_data($tmp_file)['uri'];
3
4	$zip = new ZipArchive;
5	$res = $zip->open($tmp_file_path, ZipArchive::CREATE);
6
7	foreach ($ptah_p7s->Signs as $i => $sign) {
8	$zip->addFromString("signature{$i}.p7s", base64_decode($sign));
9	}

stuzer05 / SQL tables to Go structs

0 likes

0 forks

3 files

Last active 1714309050

1	SELECT
2	'type ' \|\| table_name \|\| ' struct {' \|\| CHR(10) \|\| fields \|\| CHR(10) \|\| '}' AS models
3	FROM
4	(
5	SELECT
6	table_name,
7	REPLACE(RTRIM(XMLAGG(XMLELEMENT(E, CHR(9) \|\| column_name \|\| CHR(9) \|\| type_info \|\| CHR(9) \|\| annotation \|\| CHR(10))).EXTRACT('//text()').GETCLOBVAL(), CHR(10)), '"', '"') AS fields
8	FROM
9	(
10	SELECT

Newer Older

Powered by Opengist ⋅ Load: 94ms⋅

English