Skip to content

Instantly share code, notes, and snippets.

@septor

septor/admin_config.php

Created January 11, 2014 23:52
Show Gist options
  • Save septor/8378568 to your computer and use it in GitHub Desktop.
Save septor/8378568 to your computer and use it in GitHub Desktop.
Download ZIP
another attempt at a solution for issue #15 that works for e107 v1.0.4
Raw
admin_config.php
<?php
/*
+---------------------------------------------------------------+
| e107 website system
| survey_config.php
|
| Released under the terms and conditions of the
| GNU General Public License (http://gnu.org).
+---------------------------------------------------------------+
*/
require_once("../../class2.php");
if(!getperms("P")){header("location:".e_BASE."index.php"); exit; }
require_once(e_ADMIN."auth.php");
require_once(e_HANDLER."form_handler.php");
require_once(e_HANDLER."userclass_class.php");
include_lan(e_PLUGIN."survey/languages/".e_LANGUAGE.".php");
foreach($_POST as $k => $v){
if(preg_match("/down_(\d*?)_x/",$k,$matches)){
$movedown=$matches[1];
}
if(preg_match("/up_(\d*?)_x/",$k,$matches)){
$moveup=$matches[1];
}
}
for($i = 1;$i<=20;$i++){
$x="ADLAN_SURTYPE_".$i;
if(defined($x)){
$fieldtypes[$i]=constant($x);
}
}
$message="";
function survey_erase($survey_num){
global $sql, $message;
if($sql -> db_Select("survey_results","*","results_survey_id={$survey_num}")){
}
}
class myform extends form {
function form_select($form_name,$form_options,$form_value){
$ret = "\n<select name='".$form_name."' class='tbox'>";
$form_options[0]=ADLAN_SUR30;
foreach($form_options as $key => $val){
$sel = ($key == $form_value) ? " SELECTED" : "";
$ret .= "\n<option value='{$key}' {$sel}>{$val}</option>";
}
$ret .= "\n</select>";
return $ret;
}
}
$tt=new textparse;
if($_POST['delete']){
if($_POST['tick']){
$sql -> db_Delete("survey","survey_id='{$_POST['existing']}' ");
$sql -> db_Delete("survey_results","results_survey_id='{$_POST['existing']}' ");
$message = ADLAN_SUR2;
} else {
$message = ADLAN_SUR3;
}
}
if($_POST['createcopy']){
if($sql -> db_Select("survey","*","survey_id='{$_POST['existing']}' ")){
$row = $sql -> db_Fetch();
extract($row);
$sql -> db_Insert("survey","0,'Copy of: {$survey_name}',{$survey_class},{$survey_once},{$survey_viewclass},{$survey_editclass},'{$survey_mailto}',{$survey_forum},{$survey_save_results},'','{$survey_parms}','{$survey_message}','{$survey_submit_message}',{$survey_lastfnum} ");
$message = ADLAN_SUR72." [Copy of: {$survey_name}]";
}
}
if($_POST['add'] || isset($moveup) || isset($movedown) || $_POST['update']){
$survey_name=$_POST['survey_name'];
$survey_class=$_POST['survey_class'];
$survey_once=$_POST['survey_once'];
$survey_viewclass=$_POST['survey_viewclass'];
$survey_editclass=$_POST['survey_editclass'];
$survey_mailto=$_POST['survey_mailto'];
$newMailText = array();
$checkLinks = explode(" ", $_POST['survey_message']);
foreach($checkLinks as $convertLink)
{
if(preg_match("/\bhttp\b/i", $convertLink))
{
if(isImage($convertLink))
{
$convertLink = "<img src='".$convertLink."' />";
}
}
array_push($newMailText, $convertLink);
}
$survey_forum=$_POST['survey_forum'];
$survey_save_results=$_POST['survey_save_results'];
$survey_message= implode(" ", $newMailText);
$survey_submit_message=$_POST['survey_submit_message'];
if($survey_once && $survey_class != e_UC_PUBLIC){
$survey_save_results=1;
}
}
if($_POST['add']){
if(!$_POST['survey_name']){
$message=ADLAN_SUR4;
$_POST['create']=1;
} else {
$sql -> db_Insert("survey","0,'{$survey_name}',{$survey_class},{$survey_once},{$survey_viewclass},{$survey_editclass},'{$survey_mailto}',{$survey_forum},{$survey_save_results},'','','{$survey_message}','{$survey_submit_message}',0 ");
$sql -> db_Select("survey","*","survey_name ='{$survey_name}'");
$row = $sql -> db_Fetch();
$_POST['existing']=$row['survey_id'];
$_POST['edit']=1;
}
}
if($_POST['update'] || isset($moveup) || isset($movedown)){
$message=ADLAN_SUR33;
$i=0;
foreach($_POST['field_type'] as $key => $val){
if($_POST['field_text'][$key]){
// echo "[".$_POST['field_number'][$key]."]";
$fields[$i]['field_number']=$_POST['field_number'][$key];
$fields[$i]['field_text']=$tt -> formtpa($_POST['field_text'][$key]);
$fields[$i]['field_req']=$tt -> formtpa($_POST['field_req'][$key]);
$fields[$i]['field_hidden']=$tt -> formtpa($_POST['field_hidden'][$key]);
$fields[$i]['field_type']=$tt -> formtpa($_POST['field_type'][$key]);
$fields[$i]['field_choices']=$tt -> formtpa($_POST['field_choices'][$key]);
$i++;
}
}
if(isset($moveup)){
$movefield=$moveup;
$tempdata=array();
$tempdata=$fields[$movefield-1];
$fields[$movefield-1]=$fields[$movefield];
$fields[$movefield]=$tempdata;
survey_erase($_POST['existing']);
}
if(isset($movedown)){
$movefield=$movedown;
$tempdata=array();
$tempdata=$fields[$movefield+1];
$fields[$movefield+1]=$fields[$movefield];
$fields[$movefield]=$tempdata;
survey_erase($_POST['existing']);
}
$ser=serialize($fields);
$parms="survey_name='{$survey_name}',";
$parms.="survey_class='{$survey_class}',";
$parms.="survey_once='{$survey_once}',";
$parms.="survey_viewclass='{$survey_viewclass}',";
$parms.="survey_editclass='{$survey_editclass}',";
$parms.="survey_mailto='{$survey_mailto}',";
$parms.="survey_forum='{$survey_forum}',";
$parms.="survey_save_results='{$survey_save_results}',";
$parms.="survey_parms='{$ser}',";
$parms.="survey_message='{$survey_message}',";
$parms.="survey_submit_message='{$survey_submit_message}'";
if($_POST['field_text'][$_POST['newfield']]){
$incr=", survey_lastfnum=survey_lastfnum+1 ";
}
$sql -> db_Update("survey",$parms.$incr." WHERE survey_id={$_POST['existing']}");
unset($fields);
$_POST['edit']=$_POST['existing'];
}
if($message){
$ns -> tablerender("","<div style='text-align:center;'>{$message}</div>");
}
function survey_existing_dropdown($name,$cur_survey){
$sql2 = new db;
$f = new myform;
$ret = "";
if($sql2 -> db_Select("survey") > 0){
$ret .= $f -> form_select_open($name);
while($row = $sql2 -> db_Fetch()){
extract($row);
$sel = ($cur_survey == $survey_id) ? 1 : 0 ;
$ret .= $f -> form_option($survey_name,$sel,$survey_id);
}
$ret .= $f -> form_select_close();
} else {
$ret="";
}
return $ret;
}
//existing survey dropdown
$f=new myform;
$text = "<div style='text-align:center'>".
$f -> form_open("POST",e_SELF)."
<table class='fborder' style='width:95%'><tr><td class='forumheader3' style='text-align:center;'>".ADLAN_SUR9.": ";
$survey_dropdown = survey_existing_dropdown("existing",$_POST['existing']);
if($survey_dropdown){
$text .= $survey_dropdown;
} else {
$text.="<div style='text-align:center;'>".ADLAN_SUR5."</div>";
}
$text .= "<br />";
if($survey_dropdown){
$text .= $f -> form_button("submit","edit",ADLAN_SUR6);
}
$text .= $f -> form_button("submit","create",ADLAN_SUR7);
if($survey_dropdown){
$text .= $f -> form_button("submit","delete",ADLAN_SUR8);
$text .= "<span class='defaulttext'>".$f -> form_checkbox("tick","del_confirm")." ".ADLAN_SUR29."</span>";
}
$text .= "</td></tr></table>".$f -> form_close()."</div>";
$ns -> tablerender(ADLAN_SUR9,$text);
if($_POST['create'] || $_POST['edit']){
$sql -> db_Select("forum","*","forum_parent != 0");
while($row = $sql -> db_Fetch()){
extract($row);
$forumList[$forum_id]=$forum_name;
}
if(!$_POST['add']){
$survey_name="";
$survey_class=0;
$survey_mailto="";
$survey_save_results=0;
}
if($_POST['edit']){
$sql -> db_Select("survey","*","survey_id =".intval($_POST['existing']));
$row = $sql -> db_Fetch();
extract($row);
}
$text="<div style='text-align:center;'>".
$f -> form_open("POST",e_SELF)."
<table class='fborder' style='width:95%'>";
$fnum=0;
if($_POST['edit']){
$survey_url = preg_replace("/_config/", "", SITEURLBASE.e_PLUGIN_ABS."survey/")."survey.php?{$_POST['existing']}";
$text .= "<tr><td colspan='4' class='forumheader' style='text-align:center'>".ADLAN_SUR28." <a class='smalltext' href='{$survey_url}'>{$survey_url}</a></td></tr>";
$text .= "<tr><td colspan='4'>
<div class='spacer'>
<div class='fcaption' style='text-align: center; width:100%; cursor: pointer; cursor: hand' onClick='expandit(this);' >&raquo;&raquo; ".ADLAN_SUR69." &laquo;&laquo;</div>
<span style='display:none' style=&{head}; id='mainconfig'><br />";
$text .= "<table style='width:100%'><tr><td>";
}
if($_POST['create']){
$survey_dropdown = survey_existing_dropdown("existing","");
if($survey_dropdown){
$text .= "<tr><td colspan='4' style='width:100%' class='forumheader3'><table style='width:100%'><tr><td class='fcaption'>".ADLAN_SUR70.":</td><td class='forumheader3'>".$survey_dropdown."
</td><td class='forumheader3'><input class='tbox' type='submit' name='createcopy' value='".ADLAN_SUR71."' /></td></tr><tr><td colspan='3' style='width:100%'><hr width='100%' /></td></tr></table></td></tr>";
}
}
$text .= "<tr><td class='forumheader3'>".ADLAN_SUR10."</td><td class='forumheader2'>".$f -> form_text("survey_name",20,$survey_name,40)."</td>";
$text .= "<td class='forumheader3'>".ADLAN_SUR11."</td><td class='forumheader2'>".r_userclass("survey_class",$survey_class)."</td></tr>";
$text .= "<tr><td class='forumheader3'>".ADLAN_SUR15."</td><td class='forumheader2'>".$f -> form_text("survey_mailto",30,$survey_mailto,80)."</td>";
$text .= "<td class='forumheader3'>".ADLAN_SUR12."</td><td class='forumheader2'>";
$text .= $f -> form_select_open("survey_once");
$sel = ($survey_once == 1) ? "Selected" : "";
$text .= "<option value='1' ".$sel.">".ADLAN_SUR13;
$sel = ($survey_once == 0) ? "selected" : "";
$text .= "<option value='0' ".$sel.">".ADLAN_SUR14;
$text .= "</td></tr>";
$text .= "<tr><td class='forumheader3'>".ADLAN_SUR16."</td><td class='forumheader2'>";
$text .= $f -> form_select("survey_forum",$forumList,$survey_forum);
$text .= "</td>";
$text .= "<td class='forumheader3'>".ADLAN_SUR17."</td><td class='forumheader2'>";
$text .= $f -> form_select_open("survey_save_results");
$sel = ($survey_save_results == 1) ? "Selected" : "";
$text .= "<option value='1' ".$sel.">".ADLAN_SUR13;
$sel = ($survey_save_results == 0) ? "selected" : "";
$text .= "<option value='0' ".$sel.">".ADLAN_SUR14;
$text .= "</td></tr>";
$text .= "<tr><td class='forumheader3'>".ADLAN_SUR18."</td><td class='forumheader2'>".r_userclass("survey_viewclass",$survey_viewclass)."</td>";
$text .= "<td class='forumheader3'>".ADLAN_SUR68."</td><td class='forumheader2'>".r_userclass("survey_editclass",$survey_editclass)."</td></tr>";
$submit_name="add";
$submit_value=ADLAN_SUR19;
if($_POST['edit']){
$text .= $f -> form_hidden("existing",$_POST['existing']);
$text .= "<tr><td colspan='2' class='forumheader3'>".ADLAN_SUR20."</td><td colspan='2' class='forumheader2'>";
$text .= $f -> form_textarea("survey_message",45,5,$survey_message);
$text .= "</td></tr>";
$text .= "<tr><td colspan='2' class='forumheader3'>".ADLAN_SUR21."</td><td colspan='2' class='forumheader2'>";
$text .= $f -> form_textarea("survey_submit_message",45,5,$survey_submit_message);
$text .= "</td></tr>";
$text .= "</td></tr></table></span></div></td></tr>";
$text .= "<tr><td colspan='4'>";
$text .= "<table>";
$text .= "<tr><td class='fcaption'>&nbsp;</td>";
$text .= "<td class='fcaption'>".ADLAN_SUR22."</td>";
$text .= "<td class='fcaption'>".ADLAN_SUR23."</td>";
$text .= "<td class='fcaption'>".ADLAN_SUR34."</td>";
$text .= "<td class='fcaption'>".ADLAN_SUR24."</td>";
$text .= "<td class='fcaption'>".ADLAN_SUR25."</td>";
$text .= "</tr>";
$fields=unserialize($survey_parms);
if($survey_parms){
for($i=0;$i<count($fields);$i++){
$text .= "<tr><td class='forumheader3' style='text-align:right;'>";
if($i){
$text .= "<input class='button' type='image' name='up_{$i}' value='{$i}' src='images/up.png' style='border:0px; vertical-align:bottom;' />";
}
if($i && $i < count($fields)-1){
$text .= "<input class='button' type='image' name='down_{$i}' value='{$i}' src='images/down.png' style='border:0px; vertical-align:bottom;' />";
}
// $text .= "{".$fields[$i]['field_number']."}";
$text .= "</td><td class='forumheader3' style='white-space:nowrap;'>";
$text .= $f -> form_hidden("field_number[{$fnum}]",$fields[$i]['field_number']);
$text .= "[".$fields[$i]['field_number']."]";
$text .= $f -> form_text("field_text[{$fnum}]",25,$fields[$i]['field_text']);
$text .= "</td>";
$text .= "<td class='forumheader3'>".$f -> form_checkbox("field_req[{$fnum}]","1",$fields[$i]['field_req'])."</td>";
$text .= "<td class='forumheader3'>".$f -> form_checkbox("field_hidden[{$fnum}]","1",$fields[$i]['field_hidden'])."</td>";
$text .= "<td class='forumheader3'>";
$text .= $f -> form_select_open("field_type[{$fnum}]");
foreach($fieldtypes as $ftnum => $ftval){
$sel = ($ftnum == $fields[$i]['field_type']) ? 1 : 0;
$text .= $f -> form_option($ftval,$sel,$ftnum);
}
$text .= "</td><td class='forumheader3'>";
$text .= $f -> form_text("field_choices[{$fnum}]",40,$fields[$i]['field_choices']);
$text .= "</td>";
$text .= "</tr>";
$fnum++;
}
}
$text .= "<tr><td colspan='6' class='forumheader3' style='text-align:center;'>".ADLAN_SUR26."<br /></td></tr>";
$text .= "<tr>";
$text .= "<td colspan='2' class='forumheader3'>";
$text .= $f -> form_text("field_text[{$fnum}]",25,"");
$text .= $f -> form_hidden("field_number[{$fnum}]",$survey_lastfnum+1);
$text .= $f -> form_hidden("newfield",$fnum);
$text .= "</td>";
$text .= "<td class='forumheader3'>".$f -> form_checkbox("field_req[{$fnum}]","1")."</td>";
$text .= "<td class='forumheader3'>".$f -> form_checkbox("field_hidden[{$fnum}]","1")."</td>";
$text .= "<td class='forumheader3'>";
$text .= $f -> form_select_open("field_type[{$fnum}]");
foreach($fieldtypes as $ftnum => $ftval){
$text .= $f -> form_option($ftval,0,$ftnum);
}
$text .= "</td><td class='forumheader3'>";
$text .= $f -> form_text("field_choices[{$fnum}]",40,"");
$text .= "</td>";
$text .= "</tr>";
$submit_name="update";
$submit_value=ADLAN_SUR27;
$text .= "</table></td></tr>";
}
$text .= "<tr><td colspan='5' class='forumheader' style='text-align:center;'>";
$text .= $f -> form_button("submit",$submit_name,$submit_value);
$text .= "</td></tr>";
$text .= "</table>";
$text .= $f -> form_close()." </div>";
$ns -> tablerender($survey_name,$text);
require_once(e_ADMIN."footer.php");
exit;
}
require_once(e_ADMIN."footer.php");
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment