function options__save_item_order($item_type, $order_array, $details = array()) { $pars = array(':item_type' => $item_type); $query = "DELETE FROM " . table('objects') . "\n WHERE item_type= :item_type"; $done = or_query($query, $pars); $pars = array(); foreach ($order_array as $k => $v) { if (isset($details[$v]) && is_array($details[$v])) { $detstr = property_array_to_db_string($details[$v]); } else { $detstr = ''; } $pars[] = array(':item_type' => $item_type, ':item_name' => $v, ':order_number' => $k, ':item_details' => $detstr); } $query = "INSERT INTO " . table('objects') . "\n SET order_number = :order_number,\n item_type = :item_type,\n item_name = :item_name,\n item_details = :item_details"; $done = or_query($query, $pars); return $done; }
$subpool = orsee_db_load_array("subpools", $subpool_id, "subpool_id"); if (!$subpool['subpool_id']) { $subpool = orsee_db_load_array("subpools", 1, "subpool_id"); } } if ($proceed) { if (isset($_REQUEST['edit']) && $_REQUEST['edit']) { $t['item_details']['current_draft'] = $_REQUEST['current_draft']; $t['item_details'] = property_array_to_db_string($t['item_details']); $done = orsee_db_save_array($t, "objects", $t['item_id'], "item_id"); log__admin("pform_templates_edit", "item_name:" . $t['item_name']); message(lang('changes_saved')); redirect('admin/options_profile_template_edit.php?item_name=' . $item_name . '&subpool_id=' . $subpool_id); } elseif (isset($_REQUEST['activate']) && $_REQUEST['activate']) { $t['item_details']['current_template'] = $t['item_details']['current_draft']; $t['item_details'] = property_array_to_db_string($t['item_details']); $done = orsee_db_save_array($t, "objects", $t['item_id'], "item_id"); log__admin("pform_templates_activate", "item_name:" . $t['item_name']); message(lang('template_draft_activated')); redirect('admin/options_profile_template_edit.php?item_name=' . $item_name . '&subpool_id=' . $subpool_id); } } if ($proceed) { if (!isset($t['item_details']['current_template'])) { $t['item_details']['current_template'] = ''; } if (!isset($t['item_details']['current_draft'])) { $t['item_details']['current_draft'] = $t['item_details']['current_template']; } echo '<center> <TABLE class="or_page_subtitle" style="background: ' . $color['page_subtitle_background'] . '; color: ' . $color['page_subtitle_textcolor'] . '; width: 98%">
function query__save_query($json_query, $type, $experiment_id = 0, $properties = array(), $permanent = false) { // type can be participants_search_active, participants_search_all, assign, deassign global $expadmin; $now = time(); if ($experiment_id && $permanent) { // if this query is supposed to be permanent, then reset current permanent query if any $done = query__reset_permanent($experiment_id); // for new query $properties['is_permanent'] = 1; $properties['permanent_start_time'] = time(); $properties['assigned_count'] = 0; $addquery = ", permanent=1"; $addmessage = lang('activated_as_permanent_query'); } else { $addquery = ", permanent=0"; } $properties_string = property_array_to_db_string($properties); $continue = true; if ($experiment_id == 0) { // check if we already know this query, and if so, just update the record $pars = array(':json_query' => $json_query); $query = "SELECT * FROM " . table('queries') . "\n WHERE json_query= :json_query LIMIT 1"; $line = orsee_query($query, $pars); if (isset($line['query_id'])) { $pars = array(':query_time' => $now, ':query_id' => $line['query_id']); $query = "UPDATE " . table('queries') . "\n SET query_time= :query_time\n WHERE query_id= :query_id"; $done = or_query($query, $pars); message(lang('query_existed_now_updated')); $continue = false; } } // otherwise, save the query if ($continue) { if (isset($expadmindata['admin_id'])) { $admin_id = $expadmindata['admin_id']; } else { $admin_id = ''; } $pars = array(':query_time' => $now, ':json_query' => $json_query, ':query_type' => $type, ':experiment_id' => $experiment_id, ':properties' => $properties_string, ':admin_id' => $admin_id); $query = "INSERT INTO " . table('queries') . "\n SET query_time=:query_time,\n json_query=:json_query,\n query_type=:query_type,\n experiment_id=:experiment_id,\n admin_id=:admin_id,\n properties=:properties " . $addquery; $done = or_query($query, $pars); message(lang('query_saved')); if (isset($addmessage)) { message($addmessage); } } return $done; }
function email__attachment_array_to_dbstring($attachments = array()) { $atts = array(); foreach ($attachments as $k => $attachment) { // $attachment['data']=base64_encode($attachment['data']); already comes base64 encoded ... $atts[] = property_array_to_db_string($attachment); } $data_string = implode('|-!nextatt!-|', $atts); return $data_string; }
if ($tv) { $_REQUEST[$k][$tk] = trim($tv); } else { unset($_REQUEST[$k][$tk]); } } $prop_array[$k] = implode(',', $_REQUEST[$k]); } else { $prop_array[$k] = trim($_REQUEST[$k]); } } else { $prop_array[$k] = $field[$k]; } } } $pform_field['properties'] = property_array_to_db_string($prop_array); $done = orsee_db_save_array($pform_field, "profile_fields", $field_name, "mysql_column_name"); message(lang('changes_saved')); redirect('admin/' . thisdoc() . '?mysql_column_name=' . $field_name); } } if ($proceed) { echo '<center>'; javascript__tooltip_prepare(); echo '<FORM action="' . thisdoc() . '" method="POST">'; echo '<INPUT type="hidden" name="mysql_column_name" value="' . $field_name . '">'; echo '<TABLE class="or_formtable"> <TR><TD colspan="2"> <TABLE width="100%" border=0 class="or_panel_title"><TR> <TD style="background: ' . $color['panel_title_background'] . '; color: ' . $color['panel_title_textcolor'] . '" align="center"> ' . lang('configure_participant_profile_field') . ' ' . $field_name . '