Skip to content

Instantly share code, notes, and snippets.

View staabm's full-sized avatar
👋

Markus Staab staabm

👋
View GitHub Profile
<?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 June 1, 2020 07:00
redaxo example console command
$ 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;
🌞 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 July 30, 2020 14:07
redaxo navigation iterator
<?php
/**
* Klasse zum Erstellen von Navigationen, v0.1.
*
* benötigt PHP7!
*
* @package redaxo\structure
*/
@staabm
staabm / cd_catalog.xml
Last active September 7, 2016 08:03
test asset for php bug #73037
<?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 February 12, 2023 20:20
Drop in replacement for the native php file session handler with lock-timeout support. Work arround PHP Bug #72345.
<?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
<?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 March 29, 2016 08:21
jq-validate input event
/*!
* 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 ) {
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 November 19, 2015 13:47
create a index over all registered vhosts of the local apache2 webserver
<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;