Skip to content

Instantly share code, notes, and snippets.

SELECT count( a.ticket_id ), t.name
FROM article a
INNER JOIN article_type t
ON a.article_type_id = t.id
INNER JOIN article_sender_type st
ON a.article_sender_type_id = st.id
WHERE a.id = (
SELECT MIN(id)
FROM article a2
WHERE a2.ticket_id = a.ticket_id
alter table ps_quick_close drop foreign key FK_ps_quick_close_article_type_id_id;
@reneeb
reneeb / Mail1
Last active December 7, 2017 23:52
From: test@test.de
To: test2@test.de
Subject: This is a test
And a simple body
@reneeb
reneeb / Ideen_Service_Mocks.txt
Created December 5, 2017 10:14
Service Mocks
http://blogs.perl.org/users/lee_j/2017/01/emulating-just-about-any-restful-json-api.html
http://blogs.perl.org/users/chase_whitener/2016/01/mock-testing-web-services-with-mojo.html
http://forums.otterhub.org/viewtopic.php?f=34&t=38399&p=155556&hilit=postmaster#p155556
http://forums.otterhub.org/viewtopic.php?f=62&t=37482&p=155094&hilit=postmaster#p155094
http://forums.otterhub.org/viewtopic.php?f=53&t=38308&p=155161&hilit=postmaster#p155161
http://forums.otterhub.org/viewtopic.php?f=53&t=37331&p=151884&hilit=postmaster#p151884
http://forums.otterhub.org/viewtopic.php?f=35&t=36523&p=152059&hilit=postmaster#p152059
http://forums.otterhub.org/viewtopic.php?f=62&t=37466&p=152193&hilit=postmaster#p152193
http://forums.otterhub.org/viewtopic.php?f=53&t=37303&p=151440&hilit=postmaster#p151440
http://forums.otterhub.org/viewtopic.php?f=53&t=33538&p=146450&hilit=postmaster#p146450
http://forums.otterhub.org/viewtopic.php?f=62&t=35693&p=144564&hilit=postmaster#p144564
http://forums.otterhub.org/viewtopic.php?f=34&t=38553
iptables -I INPUT 5 -i eth0 -p tcp --dport 80 -m state --state NEW,ESTABLISHED -j ACCEPT
@reneeb
reneeb / keybase.md
Created November 20, 2017 09:01
keybase.md

Keybase proof

I hereby claim:

  • I am reneeb on github.
  • I am reneeb (https://keybase.io/reneeb) on keybase.
  • I have a public key ASC5DGpkTC56SUQDig7qh2UJqWBlKhz28GyYB25pX921Igo

To claim this, I am signing this object:

http://opartest.local/registration/change_passwd?token=927640ce5d5c6a5208313a55f132d90e
<?xml version="1.0" encoding="utf-8" ?>
<otrs_config version="1.0" init="Config">
<ConfigItem Name="Hook::Types" Required="0" Valid="1">
<Description Translatable="1">Define the background color of tickets based on types. (It has to be the html colors)</Description>
<Group>Ticket</Group>
<SubGroup>TicketOverview</SubGroup>
<Setting>
<Hash>
<Item Key="Default">808080</Item>
<Item Key="Incident">00ff00</Item>
ec5aa296f66860aa85978e41f4ef8207b1ea084b perl-5.25.10.tar.bz2
0e7f4400de762b15d108f44b522175562ed51277 perl-5.25.10.tar.gz
f1090316ae6c831c88200d3ed77d2c86b2771e31 perl-5.25.10.tar.xz