Skip to content

Instantly share code, notes, and snippets.

@septor

septor/admin_config.php

Created January 11, 2014 23:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save septor/8378568 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save septor/8378568 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. septor created this gist Jan 11, 2014.
    375 changes: 375 additions & 0 deletions admin_config.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,375 @@
    <?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");
    ?>