deviantintegral

SELECT kfm.id                                     AS id,
       IF(n.title IS NOT NULL, n.title, kfm.name) AS title,
       Concat("Source_Video/", kvu.file_name)     AS video,
       IF(n.title IS NOT NULL, "/kaltura import",
       "/kaltura_import,/no g365 node id")
       AS labels,
       kfm.id                                     AS "metadata:kaltura_id"
FROM   kaltura_full_metadata kfm
       LEFT JOIN node_kaltura nk
         ON kfm.id = nk.kaltura_entryid

deviantintegral

SELECT kfm.id,
       n.title,
       kvu.file_and_folder,
       kfm.id AS "metadata:kaltura_id"
FROM   kaltura_full_metadata kfm
       LEFT JOIN node_kaltura nk
         ON kfm.id = nk.kaltura_entryid
       LEFT JOIN node n
         ON nk.nid = n.nid
       LEFT JOIN kaltura_video_and_audio_urls kvu

deviantintegral

<?php

db_query("TRUNCATE {kaltura_custom_data}");

$result = db_query("SELECT id FROM {kaltura_full_metadata}");

$count = 0;
while ($id = db_result($result)) {
  $count++;

deviantintegral

#!/bin/bash

(for i in `echo 'SHOW TABLES;' | mysql -u root --password=MYPASS -h localhost drupal7  | grep -v Tables_in`; do echo "DROP TABLE $i;"; done;) | mysql -u root --password=MYPASS -h localhost drupal7

deviantintegral

<?php

db_query("TRUNCATE {kaltura_custom_data}");

$result = db_query("SELECT id FROM {kaltura_full_metadata}");

$count = 0;
while ($id = db_result($result)) {
  $count++;

deviantintegral

     o
   _ | _     
 [| ◡ ◡ |]
 _ - ⏝ - _  
|         |
|  |   |  |

deviantintegral

#!/usr/bin/env bash

# Compress MySQL tables on disk.
# Author: Andrew Berry, andrew.berry@lullabot.com
#
# Compress all tables in a MySQL InnoDB database using compression from the
# Barracuda table format. Tables have to already be in the Barracuda file
# format to actually compress tables, otherwise the table setting is ignored.
#
# innodb_file_per_table = 1 MUST be set in my.cnf for compression to work.

deviantintegral

body,
div.page-content.two-column-layout,
div.page-content.three-column-layout {
    background: none !important;
}

/* Hide the chat window. */
#yj-yam.ui.chat.ChatManager {
  display: none;
}

deviantintegral

# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /Applications/MAMP/db/mysql) or

deviantintegral

(**
 * Pause and resume Growl. Use in a launcher like Quicksilver or Alfred to
 * pause and resume Growl when the menu bar icon is disabled.
 *
 * Author: Andrew Berry, deviantintegral@gmail.com
 *)
tell application "Growl"
	register as application "Growl pause/resume" all notifications {"Growl paused", "Growl resumed"} default notifications {"Growl paused", "Growl resumed"} icon of application "Growl"
	if is paused then
		resume