sokratisg

SELECT CONCAT('ALTER TABLE `',table_schema,'`.`',table_name,'` engine=InnoDB;') FROM information_schema.tables WHERE TABLE_SCHEMA='<MY_DATABASE>' AND ENGINE = 'MyISAM';

sokratisg

#!/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)

sokratisg

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;

sokratisg

# 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

sokratisg

#!/usr/bin/python -u

import sys, os, time
import random

class DNSLookup(object):
    """Handle PowerDNS pipe-backend domain name lookups."""
    ttl = 30

sokratisg

/* 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;
    }
  }

sokratisg

<?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>';

?>