Sokratis Galiatsis sokratisg
-
e-food.gr
- Greece
- https://www.linkedin.com/in/sokratisg/
View myisam_to_innodb.sql
SELECT CONCAT('ALTER TABLE `',table_schema,'`.`',table_name,'` engine=InnoDB;') FROM information_schema.tables WHERE TABLE_SCHEMA='<MY_DATABASE>' AND ENGINE = 'MyISAM'; |
View cdpinfo.pl
#!/usr/bin/perl -w | |
# | |
# Listen for Cisco Discovery Protocol (CDP) packets | |
# and print out key values such as switch, port and vlan. | |
# | |
# This script depends on either "snoop" (Solaris) or | |
# "tcpdump" (Linux, AIX, and others). Both of those programs generally | |
# must be run as root. | |
# | |
# It has been tested on Solaris 10 and Linux (CentOS, Ubuntu) |
View permissions.sql
CREATE USER 'backupadmin'@'localhost' IDENTIFIED BY '<secret_password>'; | |
GRANT LOCK TABLES, SELECT ON <DB_NAME>.* TO 'backupadmin'@'localhost'; | |
GRANT RELOAD ON *.* TO 'backupadmin'@'localhost'; | |
GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker TO 'backupadmin'@'localhost'; | |
GRANT CREATE, INSERT, DROP ON mysql.backup_progress TO 'backupadmin'@'localhost'; | |
GRANT CREATE, INSERT, SELECT, DROP ON mysql.backup_history TO 'backupadmin'@'localhost'; | |
GRANT REPLICATION CLIENT ON *.* TO 'backupadmin'@'localhost'; | |
GRANT SUPER ON *.* TO 'backupadmin'@'localhost'; | |
GRANT CREATE TEMPORARY TABLES ON mysql.* TO 'backupadmin'@'localhost'; | |
FLUSH PRIVILEGES; |
View sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux | |
# | |
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and | |
# sysctl.conf(5) for more details. | |
# Turn on execshield | |
# 0 completely disables ExecShield and Address Space Layout Randomization | |
# 1 enables them ONLY if the application bits for these protections are set to “enable” | |
# 2 enables them by default, except if the application bits are set to “disable” | |
# 3 enables them always, whatever the application bits |
View pdns-pipebackend.py
#!/usr/bin/python -u | |
import sys, os, time | |
import random | |
class DNSLookup(object): | |
"""Handle PowerDNS pipe-backend domain name lookups.""" | |
ttl = 30 | |
View functions.php
/* Restrict users viewing their own attachments */ | |
add_filter('pre_get_posts', 'restrict_media'); | |
function restrict_media($arg) { | |
global $user_ID; | |
if ( current_user_can('editor') ) { // Disable this to apply on all roles | |
if ($arg->query['post_type'] == 'attachment' && is_admin()) { | |
$arg->query['author'] = $user_ID; | |
$arg->query_vars['author'] = $user_ID; | |
} | |
} |
View gist:7894195
<?php | |
$json = '{"image_intro":"storage\/images\/media\/fotografies\/thumbnail.jpg","float_intro":"","image_intro_alt":"fragkoul | |
$obj = json_decode($json); | |
echo $obj->{'image_intro'} . '<br>'; | |
?> |
NewerOlder