Skip to content

Instantly share code, notes, and snippets.

Avatar
🤠
🤠

Markus Staab staabm

🤠
🤠
206 followers · 38 following
View GitHub Profile
@staabm
staabm / gist:a4934f916666ede19dedb5face702615
Created Apr 22, 2022
3val error
View gist:a4934f916666ede19dedb5face702615
<?php
$queryString = '
SELECT
land.*,
COALESCE(NULLIF(landsprache.ort, ""), land.ort) AS ort
FROM land
INNER JOIN landsprache ON (land.landid=landsprache.landid and landsprache.spracheid = ?)
WHERE (webinaktiv = 0) ORDER BY COALESCE(NULLIF(landsprache.ort, ""), land.ort) ASC
@staabm
staabm / user-export.diff
Created Jun 1, 2020
redaxo example console command
View user-export.diff
$ git diff --staged
diff --git a/redaxo/src/addons/project/lib/user_export.php b/redaxo/src/addons/project/lib/user_export.php
new file mode 100644
index 000000000..26a85625e
--- /dev/null
+++ b/redaxo/src/addons/project/lib/user_export.php
@@ -0,0 +1,25 @@
+<?php
+
+use Symfony\Component\Console\Input\InputInterface;
@staabm
staabm / I'm an early 🐤
Last active Apr 24, 2021
View I'm an early 🐤
🌞 Morning 62 commits ███████▋░░░░░░░░░░░░░ 36.5%
🌆 Daytime 32 commits ███▉░░░░░░░░░░░░░░░░░ 18.8%
🌃 Evening 70 commits ████████▋░░░░░░░░░░░░ 41.2%
🌙 Night 6 commits ▋░░░░░░░░░░░░░░░░░░░░ 3.5%
@staabm
staabm / navigation_iterator.php
Last active Jul 30, 2020
redaxo navigation iterator
View navigation_iterator.php
<?php
/**
* Klasse zum Erstellen von Navigationen, v0.1.
*
* benötigt PHP7!
*
* @package redaxo\structure
*/
@staabm
staabm / cd_catalog.xml
Last active Sep 7, 2016
test asset for php bug #73037
View cd_catalog.xml
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:Body>
<CATALOG>
<CD>
<TITLE>Empire Burlesque</TITLE>
<ARTIST>Bob Dylan</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>Columbia</COMPANY>
<PRICE>10.90</PRICE>
<YEAR>1985</YEAR>
</CD>
@staabm
staabm / FileSessionHandler.php
Last active Aug 3, 2017
Drop in replacement for the native php file session handler with lock-timeout support. Work arround PHP Bug #72345.
View FileSessionHandler.php
<?php
class FileSessionHandler implements SessionHandlerInterface
{
/**
* time in milliseconds how fast to poll the filesystem for a file-lock
* in case it cannot be acquired / is (b)locked by other resources.
*
* @var int
* @internal
@staabm
staabm / gist:b06a39d524a9e5aabf46ebce74304a3a
Created Jun 10, 2016
melody script crawler
View gist:b06a39d524a9e5aabf46ebce74304a3a
<?php
<<<CONFIG
packages:
- "codeguy/arachnid: 1.*"
CONFIG;
set_time_limit(0);
$crawler = new \Arachnid\Crawler('https://www.example.com/', 5);
$crawler->traverse();
@staabm
staabm / jquery.validate.js
Created Mar 29, 2016
jq-validate input event
View jquery.validate.js
/*!
* jQuery Validation Plugin v1.15.1-pre
*
* http://jqueryvalidation.org/
*
* Copyright (c) 2016 Jörn Zaefferer
* Released under the MIT license
*/
(function( factory ) {
if ( typeof define === "function" && define.amd ) {
@staabm
staabm / gist:d56fd2cc1d64a7589457
Created Mar 24, 2016
segfault
View gist:d56fd2cc1d64a7589457
Program terminated with signal 11, Segmentation fault.
#0 zend_mm_remove_from_free_list (heap=0x7f22fe23fe30, mm_block=0x7f22fed48448) at /build/php5-0ouR7y/php5-5.4.45/Zend/zend_alloc.c:833
833 /build/php5-0ouR7y/php5-5.4.45/Zend/zend_alloc.c: No such file or directory.
(gdb) bt
#0 zend_mm_remove_from_free_list (heap=0x7f22fe23fe30, mm_block=0x7f22fed48448) at /build/php5-0ouR7y/php5-5.4.45/Zend/zend_alloc.c:833
#1 0x00007f22f9cc8280 in _zend_mm_free_int (heap=0x7f22fe23fe30, p=0x7f22fed48400) at /build/php5-0ouR7y/php5-5.4.45/Zend/zend_alloc.c:2101
#2 0x00007f22f9cfcd1e in zend_hash_destroy (ht=0x7f22fed48260) at /build/php5-0ouR7y/php5-5.4.45/Zend/zend_hash.c:565
#3 0x00007f22f9ced85b in _zval_dtor_func (zvalue=0x7f22fed48230) at /build/php5-0ouR7y/php5-5.4.45/Zend/zend_variables.c:45
#4 0x00007f22f9cdf6ca in _zval_dtor (zvalue=<optimized out>) at /build/php5-0ouR7y/php5-5.4.45/Zend/zend_variables.h:35
#5 _zval_ptr_dtor (zval_ptr=0x7f22fed7ece0) at /build/php5-0ouR7y/php5-5.4.45/Zend/zend_execut
@staabm
staabm / domainlist.php
Last active Nov 19, 2015
create a index over all registered vhosts of the local apache2 webserver
View domainlist.php
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
<!--
ul {
float: left;
width: 300px;
margin-top: 10px;
padding-left: 10px;