/**
* Execute a MySQL query
*
* @param array $dsn
* @param string $query
* @return void FALSE / array
*/
function myQuery($dsn, $query)
{
require_once 'DB.php';
$db =& DB::connect($dsn['DB_dsn'], $dsn['DB_options']);
// if (PEAR::isError($db)) {
if (DB::isError($db)) {
myLog($db->getMessage() . $db->getUserInfo());
return false;
}
$db->setFetchMode(DB_FETCHMODE_ASSOC);
// always set utf8
$result = $db->query('SET NAMES utf8;');
if (DB::isError($result)) {
myLog('Query error:' . $result->getMessage());
return false;
}
// $result = $db->query($query);
$result = $db->getAll($query);
if (DB::isError($result)) {
myLog('Query error: "' . $query . '" -> ' . $result->getMessage());
return false;
}
$db->disconnect();
return $result;
}
/**
* Create Project on open refine.
*
* @param string $project_name
* @param string $file_path
* @return boolean
*/
function create_project($project_name, $file_path)
{
$data = NULL;
$uri = $this->server . '/command/core/create-project-from-upload';
myLog("URL=> {$uri}");
myLog("File Path=> {$file_path}");
$post_field = array('project-file' => "@{$file_path}", 'project-name' => $project_name);
$response = $this->send_curl_request($uri, $post_field);
/* Checking the google refine url */
$pattern = '`.*?((http)://[\\w#$&+,\\/:;=?@.-]+)[^\\w#$&+,\\/:;=?@.-]*?`i';
//this regexp finds your url
if (preg_match_all($pattern, $response, $matches)) {
$project_url = $matches[1][0];
}
//project ID URL
if (isset($project_url)) {
$data['project_url'] = $project_url;
$explode_url = explode('project=', $project_url);
$data['project_id'] = $explode_url[1];
return $data;
} else {
return FALSE;
}
}
myLog($descs[$i] . ' ' . ($args[$i] != null ? $args[$i] : '') . ' ' . '(' . intval($i) . ') ' . MDMDevice::getConnectionName($conns[$j]));
$device = $devices[$j];
if (USE_SERVER) {
$device->exec((int) $argv[3], (int) $argv[4], $cmds[$i], 300000, 300000, $args[$i]);
$resultCode = $device->getResponseCode();
$resultMsg = $device->getResponseMessage();
myLog($device->getRawResponse());
if ($resultCode != 0) {
throw new Exception('Command failed: ' . $resultCode . ': ' . $resultMsg);
}
if ($responses[$i] != null) {
myLog(print_r($device->{$responses}[$i](), true));
}
} else {
$output = array();
$ret = 0;
$cmd = '../../bin/mdm_test_device_dslam_huawei_ma5600 ' . intval($conns[$j]) . ' ' . (int) $argv[3] . ' ' . (int) $argv[4] . ' ' . $tgts[$j] . ' user pass ' . intval($cmds[$i]) . ' ' . ($args[$i] != null ? $args[$i] : '');
myLog($cmd);
exec($cmd, $output, $ret);
if ($ret != 0) {
throw new Exception('Command returned error.');
}
myLog(print_r($output, true));
}
}
}
} catch (Exception $e) {
myLog('Error: ' . $e->getMessage());
}
myLog('Done.');
/**
* Store or Update migration event type
*
* @param Array $event_row row of spreed sheet
* @param Integer $instantiation_id use to match event instantiation id
*
* @return helper
*/
private function _store_event_type_migration($event_row, $instantiation_id)
{
if (isset($event_row[17]) && !empty($event_row[17])) {
$event_type = 'migration';
$event_data['instantiations_id'] = $instantiation_id;
$event_data['event_types_id'] = $this->instantiation->_get_event_type($event_type);
if (isset($event_row[17]) && !empty($event_row[17])) {
$event_data['event_date'] = date('Y-m-d', strtotime(str_replace("'", '', trim($event_row[17]))));
}
if (isset($event_row[34]) && !empty($event_row[34])) {
if ($event_row[34] === 'N' || strtolower($event_row[34]) === 'no') {
$event_data['event_outcome'] = 0;
} else {
$event_data['event_outcome'] = 1;
}
}
if (isset($event_row[35]) && !empty($event_row[35])) {
$event_data['event_note'] = $event_row[35];
}
$this->instantiation->_insert_or_update_event($instantiation_id, $event_data['event_types_id'], $event_data);
} else {
myLog('No Event Migration info from Spreadsheet');
}
}
session_start();
authenticate();
foreach ($_POST as $name => $value) {
$req[$name] = trim(clean($value, 64));
}
if (isset($req['sub'])) {
$sql_insert_sub = "INSERT INTO subs (name, created_by_user_id) \n\t\t\tVALUES ('" . $req['sub'] . "', " . $_SESSION['id'] . ")";
@mysql_query($sql_insert_sub);
$sql_get_sub_id = "SELECT id FROM subs WHERE name = '" . $req['sub'] . "'";
$sth_get_sub_id = @mysql_query($sql_get_sub_id);
$row_get_sub_id = @mysql_fetch_assoc($sth_get_sub_id);
$sub_id = $row_get_sub_id['id'];
$sql_get_users = "SELECT id FROM users";
$sth_get_users = @mysql_query($sql_get_users);
$sql_insert_ptrs = "INSERT INTO pointers (user_id, sub_id) VALUES ";
while ($row_get_users = @mysql_fetch_assoc($sth_get_users)) {
$sql_insert_ptrs .= "(" . $row_get_users['id'] . "," . $sub_id . "), ";
}
$sql_insert_ptrs = rtrim($sql_insert_ptrs);
$sql_insert_ptrs = substr($sql_insert_ptrs, 0, -1);
if ($sth_insert_ptrs = @mysql_query($sql_insert_ptrs)) {
incrementStat($_SESSION['id'], 'subs');
myLog('NEWSUB', $_SESSION['id'], $req['sub']);
$_SESSION['success'] = "Sub added!";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/addsub.php");
exit;
}
}
$_SESSION['error'] = "Could not add sub.";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/addsub.php");
exit;
<?php
//引用库
define("DAWN_PATH", "F:/xampp/htdocs/txtBlog/DawnPHP/");
include 'DawnPHP/door.php';
//获取数据
$c = Dawn::get('c', 'Index') . 'Controller';
//控制器
$a = Dawn::get('a', 'index');
//动作
$k = Dawn::get('k', 'PHP');
//关键词
$id = Dawn::get('id', '0_0');
//关键词下的页面，由页面序号索引到文件名
//获取完整的url(http://www.cnblogs.com/A-Song/archive/2011/12/14/2288215.html)
$url = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
//记录日志
myLog($url);
//实例化控制器
$controller = new $c();
//调用操作
$controller->{$a}($k, $id);
$sql_insert_ptrs .= "(" . $user_id . ", " . $row_get_subs['id'] . "), ";
}
$sql_insert_ptrs = rtrim($sql_insert_ptrs);
$sql_insert_ptrs = substr($sql_insert_ptrs, 0, -1);
$my_success = @mysql_query($sql_insert_stats);
if (!$my_success) {
$_SESSION['error'] = 'Database error.';
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/signup.php");
exit;
}
$my_success = @mysql_query($sql_insert_prefs);
if (!$my_success) {
$_SESSION['error'] = 'Database error.';
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/signup.php");
exit;
}
$my_success = @mysql_query($sql_insert_ptrs);
if (!$my_success) {
$_SESSION['error'] = 'Database error.';
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/signup.php");
exit;
}
$_SESSION['alias'] = $req['alias'];
$_SESSION['sl'] = DEFAULT_SL;
$_SESSION['logged_in'] = 1;
$_SESSION['id'] = getUserID($req['alias']);
$_SESSION['sub'] = 1;
myLog('NEWUSER', $_SESSION['id']);
myLog('LOGIN', $_SESSION['id']);
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/login.php?new=true");
exit;
<?php
require_once 'lib/utils.php';
require_once 'lib/config.php';
session_start();
authenticate();
$automessage = trim(clean($_POST['automessage'], MAXMSGLENGTH));
$sql_insert_automessage = "INSERT INTO automessages (automessage, user_id, date) VALUES ('" . $automessage . "', " . $_SESSION['id'] . ", NOW())";
if (@mysql_query($sql_insert_automessage)) {
incrementStat($_SESSION['id'], 'automessages');
myLog('AUTOMESS', $_SESSION['id']);
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/automessage.php?success=true");
exit;
} else {
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/automessage.php?success=false");
exit;
}
function shellsort(array $arr)
{
$n = myCount($arr);
$t = myCeil(myLog($n, 2));
$d = [0, 1];
for ($i = 2; $i <= $t; $i++) {
$d[$i] = 2 * $d[$i - 1] + 1;
}
$d = myArrayReverse($d);
foreach ($d as $curIncrement) {
for ($i = $curIncrement; $i < $n; $i++) {
$x = $arr[$i];
$j = $i - $curIncrement;
while ($j >= 0 && $x < $arr[$j]) {
$arr[$j + $curIncrement] = $arr[$j];
$j = $j - $curIncrement;
}
$arr[$j + $curIncrement] = $x;
}
}
return $arr;
}
/**
* Process all pending PBCore 1.x files.
* @param type $folder_id
* @param type $station_cpb_id
* @param type $offset
* @param type $limit
*/
function process_xml_file_child($folder_id, $offset = 0, $limit = 100)
{
error_reporting(E_ALL);
ini_set('display_errors', 1);
$folder_data = $this->cron_model->get_data_folder_by_id($folder_id);
if ($folder_data) {
$data_files = $this->cron_model->get_pbcore_file_by_folder_id($folder_data->id, $offset, $limit);
if (isset($data_files) && !is_empty($data_files)) {
foreach ($data_files as $d_file) {
if ($d_file->is_processed == 0) {
$this->cron_model->update_prcoess_data(array("processed_start_at" => date('Y-m-d H:i:s')), $d_file->id);
$file_path = '';
$file_path = trim($folder_data->folder_path . $d_file->file_path);
if (file_exists($file_path)) {
$this->import_media_files($file_path);
$this->cron_model->update_prcoess_data(array('is_processed' => 1, "processed_at" => date('Y-m-d H:i:s'), 'status_reason' => 'Complete'), $d_file->id);
} else {
myLog(" Is File Check Issues " . $file_path);
$this->cron_model->update_prcoess_data(array('status_reason' => 'file_not_found'), $d_file->id);
}
}
}
unset($data_files);
} else {
myLog(" Data files not found ");
}
} else {
myLog(" folders Data not found " . $file_path);
}
}
<?php
session_start();
require_once 'lib/config.php';
require_once 'lib/utils.php';
if (isset($_GET['error']) and $_GET['error'] == 'You are now logged out.') {
if (isset($_SESSION['id'])) {
myLog('LOGOUT', $_SESSION['id']);
}
$_SESSION['logged_in'] = null;
unset($_SESSION['logged_in']);
$_SESSION['alias'] = null;
unset($_SESSION['alias']);
$_SESSION['id'] = null;
unset($_SESSION['id']);
$_SESSION['sl'] = null;
unset($_SESSION['sl']);
} else {
if (isset($_SESSION['id'])) {
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/main_frames.php?login=true&newscan=true&sub=1");
}
}
$sql_get_motto = "SELECT motto FROM mottos ORDER BY RAND() LIMIT 1";
$row = @mysql_fetch_assoc(@mysql_query($sql_get_motto));
echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?" . ">";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php
echo BBSNAME;
/**
* Export records from AMS for PBCore and PREMIS and save all the exported records in zip file using BagIt.
*
* @return void
*/
function export_pbcore()
{
@ini_set("max_execution_time", 999999999999.0);
# unlimited
@ini_set("memory_limit", "2000M");
# 2GB
error_reporting(E_ALL);
ini_set('display_errors', 1);
$export_job = $this->export_job->get_export_jobs('pbcore');
if (count($export_job) > 0) {
$this->export_job->update_job($export_job->id, array('status' => '1'));
myLog('Started export for ID =>' . $export_job->id);
$bag_name = 'ams_export_' . time();
$bagit_info = array('Source-Organization' => 'WGBH on behalf of the American Archive of Public Broadcasting', 'Organization-Address' => 'Media Library & Archives, One Guest Street, Boston, MA 02135', 'Contact-Name' => 'Casey E. Davis, Project Manager', 'Contact-Phone' => '+1 617-300-5921', 'Contact-Email' => 'info@americanarchive.org ', 'External-Description' => 'The American Archive of Public Broadcasting, a collaboration between WGBH Boston and the Library of Congress, includes millions of records of public television and radio assets contributed by over 100 stations and organizations across the United States.');
$bagit_lib = new BagIt("{$this->bagit_path}{$bag_name}", TRUE, TRUE, FALSE, $bagit_info);
$bagit_lib->setHashEncoding('md5');
$total_size = 0;
$total_files = 0;
if ($export_job->query_loop == 0) {
$export_ids = explode(',', $export_job->export_query);
foreach ($export_ids as $asset_id) {
$this->do_export($asset_id, $total_size, $total_files, $bagit_lib);
}
} else {
for ($i = 0; $i < $export_job->query_loop; $i++) {
$query = $export_job->export_query;
$query .= ' LIMIT ' . $i * 100000 . ', 100000';
$records = $this->export_job->get_csv_records($query);
foreach ($records as $value) {
$this->do_export($value->id, $total_size, $total_files, $bagit_lib);
}
}
}
$bagit_lib->setBagInfoData('Payload-Oxum', $total_size . '.' . $total_files);
$bagit_lib->setBagInfoData('Bagging-Date', date('Y-m-d'));
$bagit_lib->setBagInfoData('Bag-Size', sizeFormat($total_size));
$bagit_lib->update();
$bagit_lib->package("{$this->bagit_path}{$bag_name}", 'zip');
exec("rm -rf {$this->temp_path}");
exec("rm -rf {$this->bagit_path}{$bag_name}");
$this->export_job->update_job($export_job->id, array('status' => '1', 'file_path' => "{$this->bagit_path}{$bag_name}.zip"));
$user = $this->users->get_user_by_id($export_job->user_id)->row();
$data['user_profile'] = $this->user_profile->get_profile($export_job->user_id)->row();
$data['user'] = $user;
$data['export_id'] = $export_job->id;
myLog('Sending Email to ' . $user->email);
send_email($user->email, $this->config->item('from_email'), 'AMS XML Export', $this->load->view('email/export_pbcore', $data, TRUE));
myLog('email sent successfully ' . $user->email);
} else {
myLog('No record availabe for export');
}
exit_function();
}
<?php
require_once 'lib/utils.php';
session_start();
authenticate();
foreach ($_POST as $name => $value) {
$req[$name] = trim(clean($value, 255));
}
if (!isset($req['motto']) or $req['motto'] == '') {
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/motto.php?badmotto=true");
exit;
}
$req['motto'] = clean($req['motto'], 255);
$sql_put_motto = "INSERT INTO mottos (motto) VALUES ('" . $req['motto'] . "')";
if (@mysql_query($sql_put_motto)) {
myLog('MOTTO', $_SESSION['id'], $req['motto']);
incrementStat($_SESSION['id'], 'mottos');
$_SESSION['success'] = "Motto added!";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/motto.php");
exit;
} else {
$_SESSION['error'] = "Could not add motto.";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/motto.php");
exit;
}
<?php
require_once 'lib/utils.php';
session_start();
authenticate();
foreach ($_POST as $name => $value) {
$req[$name] = trim(clean($value, 255));
}
if (!isset($req['id']) or !isset($req['option']) or hasVoted($_SESSION['id'], $req['id'])) {
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/voting_vote.php?badvote=true" . "&id=" . $req['id']);
exit;
}
$sql_tally = "INSERT INTO votes (user_id, topic_id, option_id) SELECT u.id AS user_id, \n\t\tvt.id AS topic_id, vo.id AS option_id FROM users u, voting_topics vt, voting_options vo\n\t\tWHERE u.alias = '" . $_SESSION['alias'] . "' AND vt.id = " . $req['id'] . " AND vo.opt \n\t\t= '" . $req['option'] . "'";
myLog('VOTE', $_SESSION['id'], $req['id']);
if (@mysql_query($sql_tally)) {
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/voting_vote.php?id=" . $req['id']);
exit;
} else {
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/voting_vote.php?badvote=true" . "&id=" . $req['id']);
exit;
}
/**
* Save Facet Search Values into memcahed.
*
* @return
*/
function auto_memcached_facets()
{
$this->load->library('memcached_library');
$this->load->model('sphinx_model', 'sphinx');
$memcached = new StdClass();
$memcached->ins = 'instantiations_list';
$memcached->asset = 'assets_list';
$search_facet = new stdClass();
$search_facet->state = 'state';
$search_facet->stations = 'organization';
$search_facet->status = 'status';
$search_facet->media_type = 'media_type';
$search_facet->physical = 'physical_format_name';
$search_facet->digital = 'digital_format_name';
$search_facet->generations = 'facet_generation';
$search_facet->digitized = 'digitized';
$search_facet->migration = 'migration';
foreach ($memcached as $index => $index_name) {
foreach ($search_facet as $columns => $facet) {
$result = $this->sphinx->facet_index($facet, $index_name, $columns);
if (in_array($facet, array('media_type', 'physical_format_name', 'digital_format_name', 'facet_generation'))) {
$make_facet = array();
foreach ($result['records'] as $_row) {
$exploded_facet = explode('___', $_row[$facet]);
foreach ($exploded_facet as $single_value) {
if (isset($make_facet[trim($single_value)])) {
$make_facet[trim($single_value)] = $make_facet[trim($single_value)] + $_row['@count'];
} else {
$make_facet[trim($single_value)] = $_row['@count'];
}
}
}
$final_facet = array();
foreach ($make_facet as $_index => $_single_facet) {
if ($_index != '(**)' && $_index != '') {
$final_facet[] = array($facet => $_index, '@count' => $_single_facet);
}
}
$this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($final_facet, $facet, TRUE)), 36000);
} else {
if (in_array($columns, array('digitized', 'migration'))) {
$this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($result['records'], $facet, FALSE)), 36000);
} else {
if ($columns == 'stations') {
$result = $this->sphinx->facet_index($facet, $index_name);
$this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($result['records'], $facet)), 36000);
} else {
$result = $this->sphinx->facet_index($facet, $index_name);
$this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($result['records'], $facet, FALSE)), 36000);
}
}
}
}
myLog("Succussfully Updated {$index_name} Facet Search");
}
exit;
}
/**
* You need to add instantiations.id in an array that you want to update. and then run this script.
*
*/
function update_instantiations_index()
{
$instantiation_ids = array(1, 2, 3, 4);
foreach ($instantiation_ids as $_id) {
$instantiation = $this->searchd_model->run_query("SELECT id from instantiations WHERE id = {$_id}")->row();
$instantiation_list = $this->searchd_model->get_ins_index(array($instantiation));
$new_list_info = make_instantiation_sphnix_array($instantiation_list[0], FALSE);
$this->sphnixrt->update($this->config->item('instantiatiion_index'), $new_list_info);
myLog('Instantiation successfully update with id=> ' . $_id);
}
}
exit;
}
$sql_add_topic = "INSERT INTO voting_topics (name, date) VALUES ('" . $req['topic'] . "', NOW())";
if (!@mysql_query($sql_add_topic)) {
$_SESSION['error'] = "Add topic failed.";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/voting_booth.php");
exit;
}
$sql_get_id = "SELECT id FROM voting_topics WHERE name = '" . $req['topic'] . "'";
$sth_get_id = @mysql_query($sql_get_id);
$row = @mysql_fetch_assoc($sth_get_id);
$opt_id = $row['id'];
$sql_add_options = "INSERT INTO voting_options (topic_id, opt) VALUES ";
for ($i = 1; $i <= 10; $i++) {
if ($req['o' . $i] != '') {
$sql_add_options .= "({$opt_id}, '" . $req['o' . $i] . "'), ";
}
}
$sql_add_options = rtrim($sql_add_options);
$sql_add_options = substr($sql_add_options, 0, -1);
#debug($sql_add_options); exit;
if (@mysql_query($sql_add_options)) {
myLog('VTOPIC', $_SESSION['id'], $req['topic']);
$_SESSION['success'] = "Topic added!";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/voting_booth.php");
exit;
} else {
$_SESSION['error'] = "Add topic failed.";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/voting_booth.php");
exit;
}
/**
* Update assets information from csv that is exported from AMS Refine.
*
* @param string $csv_path complete path of csv
*
* @return
*/
function update_assets($csv_path, $user_id)
{
$records = file($csv_path);
foreach ($records as $index => $line) {
if ($index != 0) {
$exploded_columns = preg_split("/\t/", $line);
$asset_id = $exploded_columns[51];
myLog('Asset ID => ' . $asset_id);
$asset_date_id = $exploded_columns[50];
$asset_identifier_id = $exploded_columns[49];
$asset_type_id = $exploded_columns[48];
$asset_right_id = $exploded_columns[47];
$asset_annotation_id = $exploded_columns[46];
$asset_rating_id = $exploded_columns[45];
$asset_level_id = $exploded_columns[44];
$asset_coverage_id = $exploded_columns[43];
$asset_publisher_id = $exploded_columns[42];
$asset_contributer_id = $exploded_columns[41];
$asset_creator_id = $exploded_columns[40];
$asset_genre_id = $exploded_columns[39];
$asset_subject_id = $exploded_columns[38];
/* Check and update Subject Start */
if (!empty($exploded_columns[3])) {
$subjects = $this->assets_model->get_subjects_id_by_subject($exploded_columns[3]);
if (isset($subjects) && isset($subjects->id)) {
$subject_id = $subjects->id;
} else {
$subject_d['subject'] = $exploded_columns[3];
$subject_d['subject_source'] = $exploded_columns[4];
$subject_d['subject_ref'] = $exploded_columns[5];
$subject_id = $this->assets_model->insert_subjects($subject_d);
}
if (!empty($asset_subject_id)) {
$this->refine_modal->update_asset_subject($asset_id, $asset_subject_id, array('subjects_id' => $subject_id));
} else {
$subject_data = array('subjects_id' => $subject_id, 'assets_id' => $asset_id);
$this->assets_model->insert_assets_subjects($subject_data);
}
}
/* Check and update Subject End */
/* Check and update Genre Start */
if (!empty($exploded_columns[6])) {
$asset_genre['assets_id'] = $asset_id;
$asset_genre_type = $this->assets_model->get_genre_type($exploded_columns[6]);
if (isset($asset_genre_type) && isset($asset_genre_type->id)) {
$asset_genre['genres_id'] = $asset_genre_type->id;
} else {
$asset_genre_d['genre'] = $exploded_columns[6];
$asset_genre_d['genre_source'] = $exploded_columns[7];
$asset_genre_d['genre_ref'] = $exploded_columns[8];
$asset_genre['genres_id'] = $this->assets_model->insert_genre($asset_genre_d);
}
if (!empty($asset_genre_id)) {
$this->refine_modal->update_asset_genre($asset_id, $asset_genre_id, array('genres_id' => $asset_genre['genres_id']));
} else {
$this->assets_model->insert_asset_genre($asset_genre);
}
}
/* Check and update Genre Start */
/* Check and update Creator Start */
if (!empty($exploded_columns[9])) {
$assets_creators_roles_d['assets_id'] = $asset_id;
$creator_d = $this->assets_model->get_creator_by_creator_name($exploded_columns[9]);
if (isset($creator_d) && isset($creator_d->id)) {
$assets_creators_roles_d['creators_id'] = $creator_d->id;
} else {
$creator_data = array('creator_name' => $exploded_columns[9], 'creator_affiliation' => $exploded_columns[10], 'creator_source' => $exploded_columns[11], 'creator_ref' => $exploded_columns[12]);
$assets_creators_roles_d['creators_id'] = $this->assets_model->insert_creators($creator_data);
}
if (!empty($asset_creator_id)) {
$this->refine_modal->update_creator_role($asset_id, $asset_creator_id, array('creators_id' => $assets_creators_roles_d['creators_id']));
} else {
$this->assets_model->insert_assets_creators_roles($assets_creators_roles_d);
}
}
/* Check and update Creator End */
/* Check and update Contributer Start */
if (!empty($exploded_columns[13])) {
$assets_contributer_roles_d['assets_id'] = $asset_id;
$contributer_d = $this->assets_model->get_contributor_by_contributor_name($exploded_columns[13]);
if (isset($contributer_d) && isset($contributer_d->id)) {
$assets_contributer_roles_d['contributors_id'] = $contributer_d->id;
} else {
$contributer_data = array('contributor_name' => $exploded_columns[13], 'contributor_affiliation' => $exploded_columns[14], 'contributor_source' => $exploded_columns[15], 'contributor_ref' => $exploded_columns[16]);
$assets_contributer_roles_d['contributors_id'] = $this->assets_model->insert_contributors($contributer_data);
}
if (!empty($asset_contributer_id)) {
$this->refine_modal->update_contributer_role($asset_id, $asset_contributer_id, array('contributors_id' => $assets_contributer_roles_d['contributors_id']));
} else {
$this->assets_model->insert_assets_contributors_roles($assets_contributer_roles_d);
}
}
/* Check and update Contributer End */
/* Check and update Publisher Start */
if (!empty($exploded_columns[17])) {
$assets_publisher_d['assets_id'] = $asset_id;
$publisher_d = $this->assets_model->get_publishers_by_publisher($exploded_columns[17]);
if (isset($publisher_d) && isset($publisher_d->id)) {
$assets_publisher_d['publishers_id'] = $publisher_d->id;
} else {
$publisher_data = array('publisher' => $exploded_columns[17], 'publisher_affiliation' => $exploded_columns[18], 'publisher_ref' => $exploded_columns[19]);
$assets_publisher_d['publishers_id'] = $this->assets_model->insert_publishers($publisher_data);
}
if (!empty($asset_publisher_id)) {
$this->refine_modal->update_publisher_role($asset_id, $asset_publisher_id, array('publishers_id' => $assets_publisher_d['publishers_id']));
} else {
$this->assets_model->insert_assets_publishers_role($assets_publisher_d);
}
}
/* Check and update Publisher End */
/* Check and update Coverage Start */
if (!empty($exploded_columns[20])) {
$coverage['coverage'] = $exploded_columns[20];
$coverage['coverage_type'] = $exploded_columns[21];
if (!empty($asset_coverage_id)) {
$this->refine_modal->update_asset_coverage($asset_id, $asset_coverage_id, $coverage);
} else {
$coverage['assets_id'] = $asset_id;
$asset_coverage = $this->assets_model->insert_coverage($coverage);
}
}
/* Check and update Coverage End */
/* Check and update Audience Level Start */
if (!empty($exploded_columns[22])) {
$asset_audience_level['assets_id'] = $asset_id;
$db_audience_level = $this->assets_model->get_audience_level($exploded_columns[22]);
if (isset($db_audience_level) && isset($db_audience_level->id)) {
$asset_audience_level['audience_levels_id'] = $db_audience_level->id;
} else {
$audience_level['audience_level'] = $exploded_columns[22];
$audience_level['audience_level_source'] = $exploded_columns[23];
$audience_level['audience_level_ref'] = $exploded_columns[24];
$asset_audience_level['audience_levels_id'] = $this->assets_model->insert_audience_level($audience_level);
}
if (!empty($asset_level_id)) {
$this->refine_modal->update_asset_audience_level($asset_id, $asset_level_id, array('audience_levels_id' => $asset_audience_level['audience_levels_id']));
} else {
$asset_audience = $this->assets_model->insert_asset_audience($asset_audience_level);
}
}
/* Check and update Audience Level End */
/* Check and update Audience Rating Start */
if (!empty($exploded_columns[25])) {
$asset_audience_rating['assets_id'] = $asset_id;
$db_audience_rating = $this->assets_model->get_audience_rating($audience_rating['audience_rating']);
if (isset($db_audience_rating) && isset($db_audience_rating->id)) {
$asset_audience_rating['audience_ratings_id'] = $db_audience_rating->id;
} else {
$audience_rating['audience_rating'] = $exploded_columns[25];
$audience_rating['audience_rating_source'] = $exploded_columns[26];
$audience_rating['audience_rating_ref'] = $exploded_columns[27];
$asset_audience_rating['audience_ratings_id'] = $this->assets_model->insert_audience_rating($audience_rating);
}
if (!empty($asset_rating_id)) {
$this->refine_modal->update_asset_audience_rating($asset_id, $asset_rating_id, array('audience_ratings_id' => $asset_audience_rating['audience_ratings_id']));
} else {
$asset_audience_rate = $this->assets_model->insert_asset_audience_rating($asset_audience_rating);
}
}
/* Check and update Audience Rating End */
/* Check and update Annotation Start */
if (!empty($exploded_columns[28])) {
$annotation['annotation'] = $exploded_columns[28];
$annotation['annotation_type'] = $exploded_columns[29];
$annotation['annotation_ref'] = $exploded_columns[30];
if (!empty($asset_annotation_id)) {
$this->refine_modal->update_annotation_type($asset_id, $asset_annotation_id, $annotation);
} else {
$annotation['assets_id'] = $asset_id;
$asset_annotation = $this->assets_model->insert_annotation($annotation);
}
}
/* Check and update Annotation End */
/* Check and update Rights Start */
if (!empty($exploded_columns[31])) {
$rights_summary_d['rights'] = $exploded_columns[31];
$rights_summary_d['rights_link'] = $exploded_columns[32];
if (!empty($asset_right_id)) {
$this->refine_modal->update_right_summary($asset_id, $asset_right_id, $rights_summary_d);
} else {
$rights_summary_d['assets_id'] = $asset_id;
$this->assets_model->insert_rights_summaries($rights_summary_d);
}
}
/* Check and update Rights End */
/* Check and update Asset Type Start */
if (!empty($exploded_columns[33])) {
$asset_type_d['assets_id'] = $asset_id;
if ($asset_type = $this->assets_model->get_assets_type_by_type($exploded_columns[33])) {
$asset_type_d['asset_types_id'] = $asset_type->id;
} else {
$asset_type_d['asset_types_id'] = $this->assets_model->insert_asset_types(array("asset_type" => $exploded_columns[33]));
}
if (!empty($asset_type_id)) {
$this->refine_modal->update_asset_type($asset_id, $asset_right_id, array('asset_types_id' => $asset_type_d['asset_types_id']));
} else {
$this->assets_model->insert_assets_asset_types($asset_type_d);
}
}
/* Check and update Asset Type End */
/* Check and update Asset Identifier Start */
if (!empty($exploded_columns[34])) {
$identifier_d['identifier'] = $exploded_columns[34];
$identifier_d['identifier_source'] = $exploded_columns[35];
$identifier_d['identifier_ref'] = $exploded_columns[36];
if (!empty($asset_identifier_id)) {
$this->refine_modal->update_asset_identifier($asset_id, $asset_identifier_id, $identifier_d);
} else {
$identifier_d['assets_id'] = $asset_id;
$this->assets_model->insert_identifiers($identifier_d);
}
}
/* Check and update Asset Identifier End */
/* Check and update Asset Date Start */
if (!empty($exploded_columns[37])) {
$asset_date['asset_date'] = $exploded_columns[37];
if (!empty($asset_date_id)) {
$this->refine_modal->update_asset_date($asset_id, $asset_date_id, $asset_date);
} else {
$asset_date['assets_id'] = $asset_id;
$this->assets_model->insert_asset_date($asset_date);
}
}
/* Check and update Asset Date Start */
$log = array('user_id' => $user_id, 'record_id' => $asset_id, 'record' => 'asset', 'type' => 'refine', 'comments' => 'record updated using refine.');
$this->audit_trail($log);
// Update Sphnix Indexes
$asset_list = $this->searchd_model->get_asset_index(array($asset_id));
$new_asset_info = make_assets_sphnix_array($asset_list[0], FALSE);
$this->sphnixrt->update('assets_list', $new_asset_info);
$instantiations_of_asset = $this->searchd_model->get_ins_by_asset_id($asset_id);
if (count($instantiations_of_asset) > 0) {
foreach ($instantiations_of_asset as $ins_asset) {
$instantiation_list = $this->searchd_model->get_ins_index(array($ins_asset->id));
$new_list_info = make_instantiation_sphnix_array($instantiation_list[0], FALSE);
$this->sphnixrt->update('instantiations_list', $new_list_info);
}
}
// End Update Sphnix Indexes
}
}
}
<?php
/*
* Hello World client
* Connects REQ socket to tcp://localhost:5555
* Sends "Hello" to server, expects "World" back
* @author Ian Barber <ian(dot)barber(at)gmail(dot)com>
*/
ini_set("display_errors", true);
$context = new ZMQContext();
// Socket to talk to server
echo "Connecting to hello world server…\n";
$requester = new ZMQSocket($context, ZMQ::SOCKET_REQ);
$requester->connect("tcp://192.168.1.79:5555");
for ($request_nbr = 0; $request_nbr <= 10; $request_nbr++) {
printf("Sending request %d…\n", $request_nbr);
myLog("before send ");
$requester->send("Hello");
myLog("after send ");
$reply = $requester->recv();
myLog("after rev :" . $reply);
printf("Received reply %d: [%s]\n", $request_nbr, $reply);
}
function myLog($content, $isObj = false)
{
if ($isObj) {
$content = serialize($content);
}
$logTxt = fopen(dirname(__FILE__) . "/log.txt", "a+");
fwrite($logTxt, $content . "\r\n");
}
case LOOP:
$sql_get_tagline = "SELECT t.id FROM taglines t, users u WHERE u.last_tagline = t.id AND u.id = " . $_SESSION['id'];
$sth_get_tagline = @mysql_query($sql_get_tagline);
if ($sth_get_tagline and @mysql_num_rows($sth_get_tagline) > 0) {
$row_get_tagline = @mysql_fetch_assoc($sth_get_tagline);
$tagline = $row_get_tagline['id'];
} else {
$sql_get_tagline = "SELECT t.id FROM taglines t WHERE user_id = " . $_SESSION['id'];
if ($sth_get_tagline and @mysql_num_rows($sth_get_tagline) > 0) {
$row_get_tagline = @mysql_fetch_assoc($sth_get_tagline);
$tagline = $row_get_tagline['id'];
}
}
break;
}
if ($tagline) {
$sql_post = "INSERT INTO messages (sub_id, user_id, message, date, tag_id) VALUES (" . $_SESSION['sub'] . ", " . $_SESSION['id'] . ", '" . $message . "', NOW(), " . $tagline . " )";
} else {
$sql_post = "INSERT INTO messages (sub_id, user_id, message, date) VALUES (" . $_SESSION['sub'] . ", " . $_SESSION['id'] . ", '" . $message . "', NOW())";
}
if (@mysql_query($sql_post)) {
incrementStat($_SESSION['id'], 'posts');
myLog('POST', $_SESSION['id'], $_SESSION['sub']);
$_SESSION['success'] = "Message posted!";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/main.php?newscan=true¤t=true&nojump=true&sub=" . $_SESSION['sub']);
exit;
} else {
$_SESSION['error'] = "Post failed.";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/main.php?newscan=true¤t=true&nojump=true&sub=" . $_SESSION['sub']);
exit;
}
$playback = "";
while (true) {
myLog("Waiting for incoming connections...");
$msgsock = socket_accept($sock);
if ($msgsock === false) {
myLog("Failed accepting a connection: " . socket_strerror(socket_last_error()));
break;
}
$buf = socket_read($msgsock, 2048, PHP_NORMAL_READ);
myLog('Received: "' . trim($buf) . '"');
// Shutdown command
if (trim($buf) == 'shutdown') {
myLog("Shutting down.");
socket_close($msgsock);
break;
} else {
if (trim($buf) == 'playback') {
myLog("Returning playback: \"{$playback}\"");
socket_write($msgsock, $playback);
} else {
$playback .= trim($buf);
}
}
socket_close($msgsock);
}
myLog("Closing socket.");
socket_close($sock);
function myLog($msg)
{
echo date("Y-m-d H:i:s") . " {$msg}\n";
}
/**
* Parse XML file for importing.
*
* @param string $path file path
*/
function parse_xml_file($path, $station_id)
{
error_reporting(E_ALL);
ini_set('display_errors', 1);
@ini_set("max_execution_time", 999999999999.0);
myLog($path);
$file_content = file_get_contents($this->mint_path . 'unzipped/' . $path);
$xml_string = @simplexml_load_string($file_content);
unset($file_content);
$xmlArray = xmlObjToArr($xml_string);
foreach ($xmlArray['children']['ams:pbcoredescriptiondocument'] as $document) {
if (isset($document['children'])) {
$asset_id = $this->assets_model->insert_assets(array("stations_id" => $station_id, "created" => date("Y-m-d H:i:s")));
myLog('Created Asset ID ' . $asset_id);
$this->import_asset_info($asset_id, $station_id, $document['children']);
myLog('Successfully inserted assets info.');
$this->import_instantiation_info($asset_id, $document['children']);
myLog('Successfully imported all the information to AMS');
}
}
}
function createResourceAssociation($wsObj, $asso)
{
//use_soap_error_handler (false);
$result = "";
try {
$response = $wsObj->createResourceAssociation(array('resourceAssociation' => $asso));
//var_dump($response);
$result = true;
myLog("createResourceAssociation OK: " . $asso['role'], 0, "");
} catch (SoapFault $exception) {
//var_dump($exception);
//echo "\n\n\n\n\n\n\n\n\n\n============================================\n\n";
//echo $exception->faultstring."\n";
//echo $exception->faultcode."\n";
//echo $exception->faultcodens."\n";
//echo $exception->detail->NrfServiceException->reason."\n";
//echo $exception->faultstring."\n";
myLog("createResrouceAssociation ErrorSOAP:" . $exception->__toString(), 1, "createResourceAssociation");
myLog("createResourceAssociation ErrorSOAP:" . $exception->faultstring . " (" . $exception->faultcode . ") " . $exception->detail->NrfServiceException->reason, 0, "createResrouceAssociation");
//die();
$result = false;
}
return $result;
}
*/
if (!isset($req['alias']) or !isset($req['password'])) {
myLog('BADPW', getUserID($req['alias']), $req['password']);
$_SESSION['error'] = "Bad user name and/or password.";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']));
exit;
}
$sql_check_password = "******" . $req['alias'] . "'";
$sth_check_password = @mysql_query($sql_check_password);
if ($sth_check_password) {
$row = @mysql_fetch_assoc($sth_check_password);
if (md5(crypt($req['password'], substr($req['alias'], 0, 2))) == $row['password']) {
$_SESSION['alias'] = $req['alias'];
$_SESSION['id'] = $row['id'];
$_SESSION['logged_in'] = 1;
$_SESSION['sl'] = $row['sl'];
$_SESSION['sub'] = 1;
incrementStat($row['id'], 'logins');
myLog('LOGIN', $row['id']);
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/main_frames.php?login=true&newscan=true&sub=1");
exit;
} else {
myLog('BADPW', getUserID($req['alias']), $req['password']);
$_SESSION['error'] = "Bad user name and/or password.";
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']));
exit;
}
}
$_SESSION['error'] = "Bad user name and/or password.";
myLog('BADPW', getUserID($req['alias']), $req['password']);
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']));
<?php
/*
$dataArray = array (
'code' => 500,
'log' => true,
'description' => 'Votre requête n\'a pu aboutir car une erreur interne au serveur est survenue !',
);
*/
if (!empty($dataArray['log'])) {
require_once dirname(__FILE__) . '/functions.inc.php';
myLog($dataArray['code']);
}
// format français
if (setlocale(LC_TIME, 'fr_FR.utf8') === FALSE) {
die('unable to setlocale()!');
}
$htmlDate = strftime('le %A %d %B %Y, à %H heures %M minutes et %S secondes', time());
$htmlRequesturi = 'http://' . htmlentities($_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'], ENT_QUOTES);
$htmlRemoteAddr = htmlentities($_SERVER['REMOTE_ADDR'], ENT_QUOTES);
if (gethostbyaddr($_SERVER['REMOTE_ADDR']) != $_SERVER['REMOTE_ADDR']) {
$htmlRemoteAddr .= ' (' . htmlentities(gethostbyaddr($_SERVER['REMOTE_ADDR'])) . ')';
}
$htmlAgent = htmlentities($_SERVER['HTTP_USER_AGENT'], ENT_QUOTES);
$htmlReferer = '-';
if (!empty($_SERVER['HTTP_REFERER'])) {
// TODO: better cause petable and syntaxe
$htmlReferer = '<a href="' . $_SERVER['HTTP_REFERER'] . '" title="Revenir à la page de provenance">' . htmlentities($_SERVER['HTTP_REFERER'], ENT_QUOTES) . '</a>';
}
$htmlPost = '';
foreach ($_POST as $k => $v) {
/**
*
* @param array $db_instantiation_id
*/
function update_ins_asset_index($db_instantiation_id)
{
$this->_CI->load->library('sphnixrt');
$this->_CI->load->model('searchd_model');
$this->_CI->load->helper('sphnixdata');
$instantiation_list = $this->_CI->searchd_model->get_ins_index(array($db_instantiation_id));
$new_list_info = make_instantiation_sphnix_array($instantiation_list[0], FALSE);
myLog('Instantiation Updated');
$this->_CI->sphnixrt->update('instantiations_list', $new_list_info);
$asset_list = $this->_CI->searchd_model->get_asset_index(array($instantiation_list[0]->assets_id));
$new_asset_info = make_assets_sphnix_array($asset_list[0], FALSE);
$this->_CI->sphnixrt->update('assets_list', $new_asset_info);
}
