function insertGameData()
{
$sql = "INSERT INTO `ca_letterTime`(`letter`, `duration`) VALUES (:letter,:time)";
$namedParameters = array();
$namedParameters[':letter'] = $_GET['letter'];
$namedParameters[':time'] = $_GET['time'];
insertRecord($sql, $namedParameters);
}
function readFromFile($conn, $fname, $dryrun)
{
//This is my function to read from the csv file.
if ($dryrun) {
fwrite(STDOUT, "\n[DRYRUN: Reading from file (\"" . $fname . "\")]");
} else {
fwrite(STDOUT, "\n[Reading from file (\"" . $fname . "\") and Inserting into DB]");
}
$file = fopen($fname, "r");
//Open the file.
$firstLine = true;
//We don't need the first line (it's the headers).
while (!feof($file)) {
//While we are not at the end of the file...
if ($firstLine) {
$firstLine = false;
fgetcsv($file);
//Read in the first line and don't do anything with it.
} else {
$person = fgetcsv($file);
//Read in all details.
$name = cleanString($person[0]);
//Clean the string.
$surname = cleanString($person[1]);
//Clean the string.
$email = trim(strtolower($person[2]));
//trim trims whitespace, strtolower puts the string to lowercase.
$emailFlag = filter_var($email, FILTER_VALIDATE_EMAIL);
//Use php's function for checking valid emails.
if ($emailFlag) {
//If it's a valid email...
if (!$dryrun) {
//If we are not on a dry run, we have access to the DB.
insertRecord($conn, $name, $surname, $email);
//Call function to insert.
} else {
fwrite(STDOUT, "\nPerson: " . $name . " " . $surname . " (" . $email . ")");
}
} else {
//If email isn't valid, tell the user.
fwrite(STDOUT, "\n[ERROR]: The supplied email address, \"" . $email . "\", is invalid");
}
}
}
fclose($file);
//Close the file after we are done.
}
function elementoEquipaInsert($fields)
{
unset($fields['id_elemento_equipa']);
$fields['id_elemento_equipa'] = insertRecord('elementos_equipas', $fields, true);
}
function modifrepInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("modifrep", $fields, true);
}
function add_link($in)
{
// establish whether the required variables are all present
$precondition = array("url", "cap", "cat");
$required_vars_are_present = checkVarsPresent($in, $precondition);
if ($required_vars_are_present) {
$results = insertRecord($in);
} else {
$results = [];
$results["meta"]["ok"] = false;
$results["meta"]["status"] = 400;
$results["meta"]["msg"] = "Bad Request";
$results["meta"]["feedback"] = "That request doesn't appear to have all the necessary fields for it to work.";
$results["meta"]["developer"] = "See the required and received fields in json metadata to evaluate what was omitted.";
$results["meta"]["received"] = $in;
$results["meta"]["required"] = $precondition;
}
return $results;
}
// load vars
$item_id = trim($_POST["item_id"]);
$coord_x1 = trim($_POST["coord_x1"]);
$coord_y1 = trim($_POST["coord_y1"]);
$coord_x2 = trim($_POST["coord_x2"]);
$coord_y2 = trim($_POST["coord_y2"]);
$width = trim($_POST["width"]);
$height = trim($_POST["height"]);
// verify if a row is already there in type_map for given item_id
$map_result = fetchSimpleTotal("sale_maps", "sales_id = " . $item_id);
// if not there yet, add it, else update
if ($map_result == 0) {
// insert the item into [sale_maps]
$sql_fields = "sales_id, coord_x1, coord_y1, coord_x2, coord_y2, width, height, date_modified";
$sql_values = "'" . $item_id . "', '" . $coord_x1 . "', '" . $coord_y1 . "', '" . $coord_x2 . "', '" . $coord_y2 . "', '" . $width . "', '" . $height . "', NOW()";
$image_id = insertRecord("sale_maps", $sql_fields, $sql_values, TRUE);
} else {
// update item in [sale_maps]
$sql = "UPDATE sale_maps SET ";
$sql .= "coord_x1 = " . $coord_x1 . ", ";
$sql .= "coord_y1 = " . $coord_y1 . ", ";
$sql .= "coord_x2 = " . $coord_x2 . ", ";
$sql .= "coord_y2 = " . $coord_y2 . ", ";
$sql .= "width = " . $width . ", ";
$sql .= "height = " . $height . ", ";
$sql .= "date_modified = NOW() ";
$sql .= "WHERE sales_id = '" . $item_id . "' ";
$sqlConn->Execute($sql);
}
// Send back to edit page on #map anchor
header("Location: sales_edit.php?action=edit&result=update&item_id=" . $item_id . "#map");
function recheioInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("pp_recheio", $fields, true);
}
}
if ($mb_forbid_pattern != "") {
if (preg_match($mb_forbid_pattern, $body)) {
if (!preg_match($mb_forbid_except_pattern, $body)) {
$body = "";
}
}
}
if ($body != "") {
$fields = array("board", "created", "author", "body");
$values = array("\"{$mb_board}\"", "now()", "\"{$author}\"", "\"{$body}\"");
if ($mb_fld_subject != "") {
$fields[] = $mb_fld_subject;
$values[] = "\"{$subject}\"";
}
if (insertRecord($mb_table, $fields, $values)) {
?>
<div style="<?php
echo $style1;
?>
">
<div style="<?php
echo $style2;
?>
"><b>Info</b></div>
<?php
echo $mb_posted_msg;
?>
</div>
<br>
<?php
// load vars
$item_id = trim($_POST["item_id"]);
$coord_x1 = trim($_POST["coord_x1"]);
$coord_y1 = trim($_POST["coord_y1"]);
$coord_x2 = trim($_POST["coord_x2"]);
$coord_y2 = trim($_POST["coord_y2"]);
$width = trim($_POST["width"]);
$height = trim($_POST["height"]);
// verify if a row is already there in type_map for given item_id
$map_result = fetchSimpleTotal("activity_maps", "activities_id = " . $item_id);
// if not there yet, add it, else update
if ($map_result == 0) {
// insert the item into [activity_maps]
$sql_fields = "activities_id, coord_x1, coord_y1, coord_x2, coord_y2, width, height, date_modified";
$sql_values = "'" . $item_id . "', '" . $coord_x1 . "', '" . $coord_y1 . "', '" . $coord_x2 . "', '" . $coord_y2 . "', '" . $width . "', '" . $height . "', NOW()";
$image_id = insertRecord("activity_maps", $sql_fields, $sql_values, TRUE);
} else {
// update item in [activity_maps]
$sql = "UPDATE activity_maps SET ";
$sql .= "coord_x1 = " . $coord_x1 . ", ";
$sql .= "coord_y1 = " . $coord_y1 . ", ";
$sql .= "coord_x2 = " . $coord_x2 . ", ";
$sql .= "coord_y2 = " . $coord_y2 . ", ";
$sql .= "width = " . $width . ", ";
$sql .= "height = " . $height . ", ";
$sql .= "date_modified = NOW() ";
$sql .= "WHERE activities_id = '" . $item_id . "' ";
$sqlConn->Execute($sql);
}
// Send back to edit page on #map anchor
header("Location: activities_edit.php?action=edit&result=update&item_id=" . $item_id . "#map");
}
// insert the item into [rentals], and return item_id
$sql_fields = "locations_id, name, code, type, is_featured, highlights_en, highlights_fr, highlights_es, address, \r\n\t\t rooms, sleeps, has_internet, has_longstay, has_safe, size_m2, \r\n\t\t\t size_f2, has_pool, pool_type, has_smoking, has_animals, distance_beach, beds, beds_details_en, beds_details_fr, \r\n\t\t\t beds_details_es, bathrooms, bathrooms_details, has_bbq, has_lastminute, price_low, price_medium, price_high, price_vacation, \r\n\t\t\t price_long_stay, has_promotion, price_promotion, deadline_promotion, google_map, online, rank, date_created, date_modified, project_id";
$sql_values = "'" . magicAddSlashes($locations_id) . "',\r\n\t\t\t '" . magicAddSlashes($name) . "', \r\n\t\t\t '" . magicAddSlashes($code) . "', \r\n\t\t\t '" . magicAddSlashes($type) . "', \r\n\t\t\t '" . magicAddSlashes($is_featured) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_en) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_fr) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_es) . "', \r\n\t\t\t '" . magicAddSlashes($address) . "', \r\n\t\t\t '" . magicAddSlashes($rooms) . "', \r\n\t\t\t '" . magicAddSlashes($sleeps) . "', \r\n\t\t\t '" . magicAddSlashes($has_internet) . "', \r\n\t\t\t '" . magicAddSlashes($has_longstay) . "', \r\n\t\t\t '" . magicAddSlashes($has_safe) . "', \r\n\t\t\t '" . magicAddSlashes($size_m2) . "', \r\n\t\t\t '" . magicAddSlashes($size_f2) . "', \r\n\t\t\t '" . magicAddSlashes($has_pool) . "', \r\n\t\t\t '" . magicAddSlashes($pool_type) . "', \r\n\t\t\t '" . magicAddSlashes($has_smoking) . "', \r\n\t\t\t '" . magicAddSlashes($has_animals) . "', \r\n\t\t\t '" . magicAddSlashes($distance_beach) . "', \r\n\t\t\t '" . magicAddSlashes($beds) . "', \r\n\t\t\t '" . magicAddSlashes($beds_details_en) . "', \r\n\t\t\t '" . magicAddSlashes($beds_details_fr) . "', \r\n\t\t\t '" . magicAddSlashes($beds_details_es) . "', \r\n\t\t\t '" . magicAddSlashes($bathrooms) . "', \r\n\t\t\t '" . magicAddSlashes($bathrooms_details) . "', \r\n\t\t\t '" . magicAddSlashes($has_bbq) . "', \r\n\t\t\t\t '" . magicAddSlashes($has_lastminute) . "', \r\n\t\t\t '" . magicAddSlashes($price_low) . "', \r\n\t\t\t '" . magicAddSlashes($price_medium) . "', \r\n\t\t\t '" . magicAddSlashes($price_high) . "', \r\n\t\t\t '" . magicAddSlashes($price_vacation) . "', \r\n\t\t\t '" . magicAddSlashes($price_long_stay) . "', \r\n\t\t\t '" . magicAddSlashes($has_promotion) . "', \r\n\t\t\t '" . magicAddSlashes($price_promotion) . "', \r\n\t\t\t '" . magicAddSlashes($deadline_promotion) . "', \r\n\t\t\t '" . magicAddSlashes($google_map) . "', \r\n\t\t\t '" . magicAddSlashes($online) . "', \r\n\t\t\t '" . intval($db_rank) . "', \r\n\t\t\t NOW(), \r\n\t\t\t NOW(),\r\n\t\t\t\t " . intval($project_id);
$item_id = insertRecord("rentals", $sql_fields, $sql_values, TRUE);
$estampa_large = imagecreatefrompng(FILES_PATH . 'logo_large.png');
$estampa_medium = imagecreatefrompng(FILES_PATH . 'logo_medium.png');
$estampa_thumbs = imagecreatefrompng(FILES_PATH . 'logo_thumbs.png');
$rankImage = 1;
// put file in DB, and place file in directory, if uploaded
foreach ($file_image["name"] as $key => $name_file) {
if ($name_file != "") {
// insert the item into [news_images], and return photo_id
$sql_fields = "rentals_id, image, rank, date_created, date_modified";
$sql_values = "'" . magicAddSlashes($item_id) . "', '', '" . $rankImage . "', NOW(), NOW()";
$photo_id = insertRecord("rental_photos", $sql_fields, $sql_values, TRUE);
$rankImage++;
// clean up filenames
$filename = $name_file;
$filename = $item_id . "_" . $photo_id . "_" . $filename;
$filename = cleanData($filename);
/// include auto cropper, to limit photo filesize
include_once $path_to_dynamik . "auto_cropper.inc.php";
// full - save the new (cropped) image to the folder
$crop = new autoCropper(imagecreatefromjpeg($file_image["tmp_name"][$key]), FILES_PATH . FILES_RENTALS_LARGE . $filename, IMG_RENTALS_LARGE_WIDTH, IMG_RENTALS_LARGE_HEIGHT, IMG_RENTALS_LARGE_FIXED, 100, array(255, 255, 255));
$crop->processImage();
// chmod the file
@chmod(FILES_PATH . FILES_RENTALS_LARGE . $filename, 0777);
// Watermark large
$margen_dcho = 0;
$margen_inf = 0;
/**
* call back function of classEmailProcessor
*
* @param mixed $email
* @return true - then classEmailProcessor may remove this email
*/
function add_email_as_record($email)
{
global $emails_processed, $emails_failed, $attachment_size_max, $sys_sender, $ownership, $oldFileArray;
$emails_processed++;
$description = $email->getBody();
$rec_id = null;
/* use UNIX-style lines
$description=str_replace("\r\n", "\n", $description);
$description=str_replace("\r", "\n", $description);
*/
/*****DEBUG****/
//error_log(">>>desc:".$description);
$description = str_replace("\r\n", "", $description);
$description = str_replace("\r", "", $description);
$arr = json_decode($description, true);
/*****DEBUG****/
//error_log("arr=>>>>".is_array($arr)." ".count($arr)." ".print_r($arr, true));
// assume all id (rtID, dtID, trmID and ontID) are all concept ids (dbID - ID)
// get rectype concept id and convert to local id or notes
// for each detail type: convert to local ids
//if type is file the save Attachment first
//if type is enum then convert term ID to local
// for any id that doesn't convert, save info in scratch in record.
if (is_array($arr) && count($arr) > 2) {
//this is from export record from another heurist instance
$key_file = null;
//id of field type for assoc files (attachments)
$arrnew = array();
//convert all global id to local id
foreach ($arr as $key => $value) {
$pos = strpos($key, "type:");
/*****DEBUG****/
error_log(">>>> " . (is_numeric($pos) && $pos == 0) . " " . $pos);
if (is_numeric($pos) && $pos == 0) {
//@todo we have to convert the content of fields as well -
// since it may contain terms and references to other rectypes !!!1
$typeid = substr($key, 5);
// temporay code to translate existing reports
switch ($typeid) {
case "2-221":
case "68-221":
$typeid = DT_BUG_REPORT_FILE;
$oldFileArray = true;
break;
case "2-179":
case "68-179":
$typeid = DT_BUG_REPORT_NAME;
break;
case "2-303":
case "68-303":
$typeid = DT_BUG_REPORT_DESCRIPTION;
break;
case "2-560":
case "68-560":
$typeid = DT_BUG_REPORT_STEPS;
break;
case "2-725":
case "68-725":
$typeid = DT_BUG_REPORT_STATUS;
break;
}
$newkey = getDetailTypeLocalID($typeid);
/*****DEBUG****/
error_log(">>>> " . $newkey . " dettype=" . $typeid);
$value = str_replace(" ", "\n", $value);
if ($newkey) {
$arrnew["type:" . $newkey] = $value;
if ($newkey == DT_FILE_RESOURCE) {
$key_file = "type:" . $newkey;
}
} else {
$email->setErrorMessage("Can't find the local id for fieldtype #" . $typeid);
$key_file = null;
//avoid processing attachments
break;
}
} else {
$arrnew[$key] = $value;
}
}
//for
$rectype = $arr["rectype"];
switch ($rectype) {
case "2-216":
case "68-216":
$rectype = RT_BUG_REPORT;
}
$newrectype = getRecTypeLocalID($rectype);
if ($newrectype) {
$arrnew["rectype"] = $newrectype;
if ($rectype == RT_BUG_REPORT) {
}
} else {
$email->setErrorMessage("Can't find the local id for rectype #" . $_POST["rectype"]);
$key_file = null;
//avoid processing attachments
exit;
}
/*****DEBUG****/
//error_log("KEY FILE ".$key_file);
//assosiated files
if ($key_file) {
$files_arr = $arrnew[$key_file];
if ($files_arr && count($files_arr) > 0) {
/*****DEBUG****/
//error_log(">>>>files_arr=".print_r($files_arr[0], true));
$arrnew[$key_file] = saveAttachments($files_arr, $email);
if ($arrnew[$key_file] == 0) {
return false;
}
} else {
unset($arrnew[$key_file]);
}
}
/*$bug_descr = $arrnew["type:".DT_BUG_REPORT_DESCRIPTION];
if($bug_descr){
$bug_descr = str_replace("<br>","\n",$bug_descr);
$arrnew["type:".DT_BUG_REPORT_DESCRIPTION] = $bug_descr;
}*/
/*****DEBUG****/
//error_log(">>>>ARRAY=".print_r($arrnew, true));
$_POST = $arrnew;
$statusKey = getDetailTypeLocalID(DT_BUG_REPORT_STATUS);
/*****DEBUG****/
//error_log("status key ".print_r($statusKey,true));
if ($statusKey) {
$_POST["type:" . $statusKey] = array("Received");
}
} else {
if (defined('RT_NOTE')) {
// this is from usual email - we will add email rectype
//error_log(" in emailProccesor as Note");
// liposuction away those unsightly double, triple and quadruple spaces
$description = preg_replace('/ +/', ' ', $description);
// trim() each line
$description = preg_replace('/^[ \\t\\v\\f]+|[ \\t\\v\\f]+$/m', '', $description);
$description = preg_replace('/^\\s+|\\s+$/s', '', $description);
// reduce anything more than two newlines in a row
$description = preg_replace("/\n\n\n+/s", "\n\n", $description);
//consider this message as usual email and
$_POST["save-mode"] = "new";
$_POST["notes"] = "";
$_POST["rec_url"] = "";
/* FOR EMAIL RECORD TYPE - BUT IAN REQUIRES POST "NOTE" RECORDTYPE
$_POST["type:160"] = array($email->getSubject());
$_POST["type:166"] = array(date('Y-m-d H:i:s')); //date sent
$_POST["type:521"] = array($email->getFrom()); //email owner
$_POST["type:650"] = array($email->getFrom()); //email sender
$_POST["type:651"] = array("*****@*****.**"); //recipients
//$_POST["type:221"] = array(); //attachments
$_POST["type:560"] = array($description);
$_POST["rectype"]="183"; //EMAIL
*/
if (defined('DT_NAME')) {
$_POST["type:" . DT_NAME] = array($email->getSubject());
}
//title
//$_POST["type:158"] = array("email harvesting"); //creator (recommended)
if (defined('DT_DATE')) {
$_POST["type:" . DT_DATE] = array(date('Y-m-d H:i:s'));
}
//specific date
if (defined('DT_SHORT_SUMMARY')) {
$_POST["type:" . DT_SHORT_SUMMARY] = array($email->getFrom() . " " . $description);
}
//notes
$_POST["rectype"] = RT_NOTE;
//NOTE
$_POST["check-similar"] = "1";
$arr = saveAttachments(null, $email);
if ($arr == 0) {
return false;
} else {
if (count($arr) > 0) {
if (defined('DT_FILE_RESOURCE')) {
$_POST['type:' . DT_FILE_RESOURCE] = $arr;
}
//array_push($_POST['type:221'], $arr);
/*****DEBUG****/
//error_log(">>>>>>>>>ARRAY>>".print_r($arr, true));
}
}
/*****DEBUG****/
//error_log(">>>>>>>>>HERE>>>>>>".print_r($_POST['type:221'],true));
}
}
if ($email->getErrorMessage() == null) {
$_POST["owner"] = get_user_id();
$sss = $email->getFrom();
if (is_array($sys_sender)) {
foreach ($sys_sender as $sys_sender_email) {
if ($sys_sender_email == $sss || strpos($sss, "<" + $sys_sender_email + ">") >= 0) {
$_POST["owner"] = $ownership;
break;
}
}
}
$_POST["visibility"] = 'hidden';
/*****DEBUG****/
//error_log(">>>>before insert POST=".print_r($_POST, true));
$updated = insertRecord($_POST['rectype']);
//from saveRecordDetails.php
if ($updated) {
$rec_id = $_REQUEST["recID"];
$email->setRecId($rec_id);
}
/*****DEBUG****/
//error_log("updated = $updated recID = $rec_id ");
}
printEmail($email);
//$rec_id=null;
if ($rec_id) {
//($rec_id){
return true;
} else {
$emails_failed++;
return false;
}
}
function modifBolosInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("pp_modif_bolos", $fields, true);
}
// submit data if no form_error and for was submitted
if ($form_submit == "Y" && $form_error == "") {
//all data checks out, can proceed with inserting / updating [activities]
if ($action == "add") {
// rank check - new item at top of list - others go down a rank
if ($online == "Y") {
$db_rank = 1;
$sql = "UPDATE activities SET rank = rank + 1 WHERE online = 'Y' ";
$sqlConn->Execute($sql);
} else {
$db_rank = 0;
}
// insert the item into [activities], and return item_id
$sql_fields = "name_en, name_fr, name_es, description_en, description_fr, description_es, intro_en, intro_fr, intro_es, highlights_en, highlights_fr, \r\n\t\t\t highlights_es, online, rank, date_created, date_modified";
$sql_values = "'" . magicAddSlashes($name_en) . "',\r\n\t\t\t\t '" . magicAddSlashes($name_fr) . "', \r\n\t\t\t\t '" . magicAddSlashes($name_es) . "', \r\n\t\t\t\t '" . magicAddSlashes($description_en) . "', \r\n\t\t\t\t '" . magicAddSlashes($description_fr) . "', \r\n\t\t\t\t '" . magicAddSlashes($description_es) . "', \r\n\t\t\t\t '" . magicAddSlashes($intro_en) . "', \r\n\t\t\t\t '" . magicAddSlashes($intro_fr) . "', \r\n\t\t\t\t '" . magicAddSlashes($intro_es) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_en) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_fr) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_es) . "', \r\n\t\t\t '" . magicAddSlashes($online) . "', \r\n\t\t\t '" . intval($db_rank) . "', \r\n\t\t\t NOW(), \r\n\t\t\t NOW()";
$item_id = insertRecord("activities", $sql_fields, $sql_values, TRUE);
//echo $item_id;
//exit();
/* // put file in DB, and place file in directory, if uploaded
if ($file_image["name"] != "") {
// insert the item into [news_images], and return photo_id
$sql_fields = "activities_id, image, rank, date_created, date_modified";
$sql_values = "'".magicAddSlashes($item_id)."', '', '1', NOW(), NOW()";
$photo_id = insertRecord("activity_photos", $sql_fields, $sql_values, TRUE);
// clean up filenames
$filename = $file_image["name"];
$filename = $item_id."_".$photo_id."_".$filename;
$filename = cleanData($filename);
/// include auto cropper, to limit photo filesize
function provaClassificacaoInsert($fields)
{
unset($fields['id_classificacao']);
$fields['id_classificacao'] = insertRecord('provas_classificacoes', $fields, true);
}
function reparadorInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("reparador", $fields, true);
}
function loginInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("users", $fields, true);
}
function visitanteInsert(&$fields)
{
unset($fields['id_visitante']);
$fields['id_visitante'] = insertRecord("visitantes", $fields, true);
}
}
}
// submit data if no form_error and for was submitted
if ($form_submit == "Y" && $form_error == "") {
//all data checks out, can proceed with inserting / updating [contacts]
if ($action == "add") {
// rank check - new item at top of list - others go down a rank
if ($online == "Y") {
$db_rank = 1;
} else {
$db_rank = 0;
}
// insert the item into [contacts], and return item_id
$sql_fields = "name, job_es, job_en, job_fr, descr_job_es, descr_job_en, descr_job_fr, email, description_en, description_fr, description_es, online";
$sql_values = "'" . magicAddSlashes($name) . "',\r\n\t\t\t\t '" . magicAddSlashes($job_es) . "', \r\n\t\t\t\t '" . magicAddSlashes($job_en) . "', \r\n\t\t\t\t '" . magicAddSlashes($job_fr) . "', \r\n\t\t\t\t '" . magicAddSlashes($descr_job_es) . "', \r\n\t\t\t\t '" . magicAddSlashes($descr_job_en) . "', \r\n\t\t\t\t '" . magicAddSlashes($descr_job_fr) . "', \r\n\t\t\t\t '" . magicAddSlashes($email) . "', \r\n\t\t\t\t '" . magicAddSlashes($description_en) . "', \r\n\t\t\t\t '" . magicAddSlashes($description_fr) . "', \r\n\t\t\t\t '" . magicAddSlashes($description_es) . "', \r\n\t\t\t '" . magicAddSlashes($online) . "'";
$item_id = insertRecord("contacts", $sql_fields, $sql_values, TRUE);
// put file in DB, and place file in directory, if uploaded
if ($file_image["name"] != "") {
// clean up filenames
$filename = $file_image["name"];
$filename = $item_id . "_" . $filename;
$filename = cleanData($filename);
/// include auto cropper, to limit photo filesize
include_once $path_to_dynamik . "auto_cropper.inc.php";
// full - save the new (cropped) image to the folder
$crop = new autoCropper(imagecreatefromjpeg($file_image["tmp_name"]), FILES_PATH . FILES_CONTACTS_LARGE . $filename, IMG_CONTACTS_LARGE_WIDTH, IMG_CONTACTS_LARGE_HEIGHT, IMG_CONTACTS_LARGE_FIXED, 100, array(255, 255, 255));
$crop->processImage();
// chmod the file
@chmod(FILES_PATH . FILES_CONTACTS_LARGE . $filename, 0777);
// medium - save the new (cropped) image to the folder
$crop = new autoCropper(imagecreatefromjpeg($file_image["tmp_name"]), FILES_PATH . FILES_CONTACTS_MEDIUM . $filename, IMG_CONTACTS_MEDIUM_WIDTH, IMG_CONTACTS_MEDIUM_HEIGHT, IMG_CONTACTS_MEDIUM_FIXED, 100, array(255, 255, 255));
function sugestaoInsert($fields)
{
unset($fields['id_sugestao']);
$fields['id_sugestao'] = insertRecord('sugestoes', $fields, true);
}
function localInsert($fields)
{
unset($fields['id_local']);
$fields['id_local'] = insertRecord('locais', $fields, true);
}
function massaInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("pp_massa", $fields, true);
}
}
// insert the item into [sales], and return item_id
$sql_fields = "locations_id, name, type, is_featured, highlights_en, highlights_fr, \r\n\t\t\t highlights_es, address, rooms, size_m2, \r\n\t\t\t size_f2, has_pool, pool_type, distance_beach, beds, beds_details_en, beds_details_fr, \r\n\t\t\t beds_details_es, bathrooms, bathrooms_details, has_bbq, \r\n\t\t\t price, has_promotion, price_promotion, deadline_promotion, google_map, online, rank, date_created, date_modified";
$sql_values = "'" . magicAddSlashes($locations_id) . "', \r\n\t\t\t '" . magicAddSlashes($name) . "', \r\n\t\t\t '" . magicAddSlashes($type) . "', \r\n\t\t\t '" . magicAddSlashes($is_featured) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_en) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_fr) . "', \r\n\t\t\t '" . magicAddSlashes($highlights_es) . "', \r\n\t\t\t '" . magicAddSlashes($address) . "', \r\n\t\t\t '" . magicAddSlashes($rooms) . "',\r\n\t\t\t '" . magicAddSlashes($size_m2) . "', \r\n\t\t\t '" . magicAddSlashes($size_f2) . "', \r\n\t\t\t '" . magicAddSlashes($has_pool) . "', \r\n\t\t\t '" . magicAddSlashes($pool_type) . "', \r\n\t\t\t '" . magicAddSlashes($distance_beach) . "', \r\n\t\t\t '" . magicAddSlashes($beds) . "', \r\n\t\t\t '" . magicAddSlashes($beds_details_en) . "', \r\n\t\t\t '" . magicAddSlashes($beds_details_fr) . "', \r\n\t\t\t '" . magicAddSlashes($beds_details_es) . "', \r\n\t\t\t '" . magicAddSlashes($bathrooms) . "', \r\n\t\t\t '" . magicAddSlashes($bathrooms_details) . "', \r\n\t\t\t '" . magicAddSlashes($has_bbq) . "', \r\n\t\t\t '" . magicAddSlashes($price) . "', \r\n '" . magicAddSlashes($has_promotion) . "',\r\n\t\t\t '" . magicAddSlashes($price_promotion) . "', \r\n\t\t\t '" . magicAddSlashes($deadline_promotion) . "', \r\n\t\t\t '" . magicAddSlashes($google_map) . "', \r\n\t\t\t '" . magicAddSlashes($online) . "', \r\n\t\t\t '" . intval($db_rank) . "', \r\n\t\t\t NOW(), \r\n\t\t\t NOW()";
$item_id = insertRecord("sales", $sql_fields, $sql_values, TRUE);
$estampa_large = imagecreatefrompng(FILES_PATH . 'logo_large.png');
$estampa_medium = imagecreatefrompng(FILES_PATH . 'logo_medium.png');
$estampa_thumbs = imagecreatefrompng(FILES_PATH . 'logo_thumbs.png');
$rankImage = 1;
// put file in DB, and place file in directory, if uploaded
foreach ($file_image["name"] as $key => $name_file) {
if ($name_file != "") {
// insert the item into [news_images], and return photo_id
$sql_fields = "sales_id, image, rank, date_created, date_modified";
$sql_values = "'" . magicAddSlashes($item_id) . "', '', '" . $rankImage . "', NOW(), NOW()";
$photo_id = insertRecord("sale_photos", $sql_fields, $sql_values, TRUE);
$rankImage++;
// clean up filenames
$filename = $name_file;
$filename = $item_id . "_" . $photo_id . "_" . $filename;
$filename = cleanData($filename);
/// include auto cropper, to limit photo filesize
include_once $path_to_dynamik . "auto_cropper.inc.php";
// full - save the new (cropped) image to the folder
$crop = new autoCropper(imagecreatefromjpeg($file_image["tmp_name"][$key]), FILES_PATH . FILES_SALES_LARGE . $filename, IMG_SALES_LARGE_WIDTH, IMG_SALES_LARGE_HEIGHT, IMG_SALES_LARGE_FIXED, 100, array(255, 255, 255));
$crop->processImage();
// chmod the file
@chmod(FILES_PATH . FILES_SALES_LARGE . $filename, 0777);
// Watermark large
$margen_dcho = 0;
$margen_inf = 0;
function encomendasInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("pp_encomendas", $fields, true);
}
function provaInsert(&$fields)
{
unset($fields['id_prova']);
$fields['id_prova'] = insertRecord('provas', $fields, true);
}
<?php
if (isset($_GET['addForm'])) {
//admin submitted form to add product
include './includes/genericDataAccess.inc.php';
$sql = "INSERT INTO oe_product ( productName, productDescription, price, categoryId) \n VALUES ( :productName, :productDescription, :price, :categoryId)";
$namedParameters = array();
$namedParameters[':productName'] = $_GET['productName'];
$namedParameters[':productDescription'] = $_GET['productDescription'];
$namedParameters[':price'] = $_GET['price'];
$namedParameters[':categoryId'] = $_GET['categoryId'];
insertRecord($sql, $namedParameters);
echo "Record has been added!";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<!-- Always force latest IE rendering engine (even in intranet) & Chrome Frame
Remove this if you use the .htaccess -->
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Add Products</title>
<meta name="description" content="Otter Express Add Product admin page">
<meta name="author" content="Richard Ciampa">
<meta name="viewport" content="width=device-width; initial-scale=1.0">
$rtyID = $rtyID[0];
}
}
$TL = array();
$query = 'SELECT trm_ID, trm_Label, trm_ParentTermID, trm_OntID, trm_Code FROM defTerms';
$res = mysql_query($query);
while ($row = mysql_fetch_assoc($res)) {
$TL[$row['trm_ID']] = $row;
}
/*****DEBUG****/
//error_log(" Save dtl Post before ".print_r($_POST,true));
if ($_POST["save-mode"] == "edit" && intval($_POST["recID"])) {
$updated = updateRecord(intval($_POST["recID"]), $rtyID);
} else {
if ($_POST["save-mode"] == "new") {
$updated = insertRecord($rtyID);
} else {
$updated = false;
}
}
/*****DEBUG****/
//error_log(" Save dtl Request ".print_r($_REQUEST,true));
/*****DEBUG****/
//error_log(" Save dtl Post ".print_r($_POST,true));
if ($updated) {
updateRecTypeUsageCount();
//getRecordInfoLibrary
// Update bib record data
// Update recDetails, rec_ScratchPad and rec_Title in (parent.parent).HEURIST.record
print "(";
define("JSON_RESPONSE", 1);
function modalidadeInsert($fields)
{
unset($fields['id_modalidade']);
$fields['id_modalidade'] = insertRecord('modalidades', $fields, true);
}
function coberturaInsert($fields)
{
#$fields['id'] = insertRecord("grep", $fields, true);
return insertRecord("pp_cobertura", $fields, true);
}
function equipaInsert(&$fields)
{
unset($fields['id_equipa']);
$fields['id_equipa'] = insertRecord('equipas', $fields, true);
}
function delegacaoInsert($fields)
{
unset($fields['id_delegacao']);
$fields['id_delegacao'] = insertRecord("delegacoes", $fields, true);
}
