<?php $modid=21; $mod_name = 'actions'; require_once("AMP/Base/DB.php"); $MM_listtable= ( isset( $_GET['MM_listtable']) && $_GET['MM_listtable']) ? $_GET['MM_listtable'] : "lists"; // *** Update Record: set variables if ( ((isset($_REQUEST['MM_update'])) && (isset($_REQUEST['MM_recordId'])) ) or (isset($_REQUEST['MM_insert'])) or ((isset($_REQUEST['MM_delete'])) && (isset($_REQUEST['MM_recordId']))) ) { $enddate = DateConvertIn($enddate); $MM_editTable = "action_text"; $MM_editColumn = "id"; $MM_recordId = "" . $_REQUEST['MM_recordId'] . ""; $MM_editRedirectUrl = "sendfax_list.php"; $MM_fieldsStr ="title|value|introtext|value|shortdesc|value|subject|value|text|value|firstname|value|lastname|value|prefix|value|position|value|actiontype|value|email|value|fax|value|uselist|value|list1|value|list2|value|list3|value|list4|value|enddate|value|tellfriend|value|tf_subject|value|tf_text|value|thankyou_title|value|thankyou_text|value|bcc|value|faxaccount|value|faxsubject|value"; $MM_columnsStr = "title|',none,''|introtext|',none,''|shortdesc|',none,''|subject|',none,''|text|',none,''|firstname|',none,''|lastname|',none,''|prefix|',none,''|position|',none,''|actiontype|',none,''|email|',none,''|fax|',none,''|uselist|',none,''|list1|',none,''|list2|',none,''|list3|',none,''|list4|',none,''|enddate|',none,''|tellfriend|',none,''|tf_subject|',none,''|tf_text|',none,''|thankyou_title|',none,''|thankyou_text|',none,''|bcc|',none,''|faxaccount|',none,''|faxsubject|',none,''"; require ("../Connections/insetstuff.php"); require ("../Connections/dataactions.php"); ob_end_flush(); } $fax__MMColParam = "90000000"; if ( isset( $_REQUEST['id']) && $_REQUEST["id"]) {$fax__MMColParam = $_REQUEST["id"];} $fax=$dbcon->Execute("SELECT * FROM action_text WHERE id = " . ($fax__MMColParam) . "") or DIE($dbcon->ErrorMsg()); $list=$dbcon->Execute("SELECT id, name from $MM_listtable ORDER BY name ASC") or DIE($dbcon->ErrorMsg()); $list_numRows=0; $list__totalRows=$list->RecordCount(); ?><?php include("header.php"); ?>
// *** Edit Operations: declare Tables $MM_editAction = $PHP_SELF; if ($QUERY_STRING) { $MM_editAction = $MM_editAction . "?" . $QUERY_STRING; } $MM_abortEdit = 0; $MM_editQuery = ""; // *** Insert Record: set Variables if (isset($MM_update) && isset($MM_recordId) or isset($MM_insert) or isset($MM_delete) && isset($MM_recordId)) { //Delete cached versions of output file // $MM_editConnection = MM__STRING; $MM_editTable = "calendar2"; $MM_editColumn = "id"; $MM_recordId = "" . $MM_recordId . ""; $MM_editRedirectUrl = "calendar_gxlist2.php"; $startdate = DateConvertIn($startdate); if ($nonstateregion != 1) { $region = $_POST[lstate]; } $MM_fieldsStr = "type|value|startdate|value|time|value|event|value|description|value|longdescription|value|organization|value|contact|value|email|value|phone1|value|url|value|location|value|city|value|lstate|value|lcountry|value|laddress|value|lzip|value|endorse|value|publish|value|repeat|value|student|value|fpevent|value|fporder|value|region|value|section|value"; $MM_columnsStr = "typeid|none,none,NULL|date|',none,''|time|',none,''|event|',none,''|shortdesc|',none,''|fulldesc|',none,''|org|',none,''|contact1|',none,''|email1|',none,''|phone1|',none,''|url|',none,''|location|',none,''|lcity|',none,''|lstate|',none,''|lcountry|',none,''|laddress|',none,''|lzip|',none,''|endorse|',none,''|publish|none,1,0|repeat|none,1,0|student|none,1,0|fpevent|none,1,0|fporder|',none,''|region|',none,''|section|',none,''"; require "../Connections/insetstuff.php"; require "../Connections/dataactions.php"; ob_end_flush(); } $state = $dbcon->Execute("SELECT * FROM states") or die($dbcon->ErrorMsg()); $state_numRows = 0; $state__totalRows = $state->RecordCount(); $eventtype = $dbcon->Execute("SELECT * FROM eventtype order by name asc") or die($dbcon->ErrorMsg()); $eventtype_numRows = 0; $eventtype__totalRows = $eventtype->RecordCount();
include "AMP/BaseTemplate.php"; include "AMP/BaseModuleIntro.php"; include_once "AMP/System/Email.inc.php"; // *** Edit Operations: declare Tables $MM_editAction = $PHP_SELF; if ($QUERY_STRING) { $MM_editAction = $MM_editAction . "?" . $QUERY_STRING; } $MM_abortEdit = 0; $MM_editQuery = ""; // *** Insert Record: set variables if (isset($MM_insert)) { // $MM_editConnection = $MM__STRING; $MM_editTable = "articles"; $MM_editRedirectUrl = "index.php"; $date = DateConvertIn($date); $MM_fieldsStr = "type|value|class|value|select3|value|uselink2|value|uselink|value|publish|value|titlex|value|subtitle|value|html|value|article|value|textfield|value|author|value|linktext|value|date|value|usedate|value|doc|value|radiobutton|value|link|value|linkuse|value|new|value|actionitem|value|actionlink|value|piccap|value|picture|value|usepict|value|morelink|value|usemore|value|ID|value|pageorder|value"; $MM_columnsStr = "type|none,none,NULL|class|none,none,NULL|catagory|none,none,NULL|fplink|none,1,0|uselink|none,1,0|publish|none,1,0|title|',none,''|subtitile|',none,''|html|none,1,0|test|',none,''|shortdesc|',none,''|author|',none,''|linktext|',none,''|date|',none,NULL|usedate|none,1,0|doc|',none,''|doctype|',none,''|link|',none,''|linkover|none,1,0|new|none,1,0|actionitem|none,1,0|actionlink|none,none,NULL|piccap|',none,''|picture|',none,''|picuse|none,none,NULL|morelink|',none,''|usemore|none,1,0|enteredby|none,none,NULL|pageorder|none,none,NULL"; mail("{$MM_email_usersubmit}", "user submited article", "{$article}", "From: " . AMPSystem_Email::sanitize($author) . "\nX-Mailer: My PHP Script\n"); require "Connections/insetstuff.php"; } require "Connections/dataactions.php"; $typelab = $dbcon->Execute("SELECT id, type FROM articletype ORDER BY type ASC") or die($dbcon->ErrorMsg()); $typelab_numRows = 0; $typelab__totalRows = $typelab->RecordCount(); $sublab = $dbcon->Execute("SELECT id, subname FROM articlesubtype") or die($dbcon->ErrorMsg()); $sublab_numRows = 0; $sublab__totalRows = $sublab->RecordCount(); $catagory = $dbcon->Execute("SELECT * FROM catagory ORDER BY catname ASC") or die($dbcon->ErrorMsg()); $catagory_numRows = 0; $catagory__totalRows = $catagory->RecordCount();
$MM_editAction = $PHP_SELF; if ($QUERY_STRING) { $MM_editAction = $MM_editAction . "?" . $QUERY_STRING; } $MM_abortEdit = 0; $MM_editQuery = ""; // *** Insert Record: set Variables if (isset($_POST['MM_update']) && isset($_POST['MM_recordId']) or isset($_POST['MM_insert']) or isset($_POST['MM_delete']) && isset($_POST['MM_recordId'])) { //Delete cached versions of output file // $dbcon->Execute("DELETE FROM cachedata WHERE CACHEKEY LIKE '%calendar%';")or DIE($dbcon->ErrorMsg()); // $MM_editConnection = MM__STRING; $MM_editTable = "calendar"; $MM_editColumn = "id"; $MM_recordId = "" . $_POST['MM_recordId'] . ""; $MM_editRedirectUrl = "calendar_gxlist.php"; $startdate = DateConvertIn($_REQUEST['startdate']); if ($nonstateregion != 1) { $region = $_POST['lstate']; } $MM_fieldsStr = "type|value|startdate|value|time|value|event|value|description|value|longdescription|value|organization|value|contact|value|email|value|phone1|value|url|value|location|value|city|value|lstate|value|lcountry|value|laddress|value|lzip|value|endorse|value|publish|value|repeat|value|student|value|fpevent|value|fporder|value|region|value|section|value"; $MM_columnsStr = "typeid|none,none,NULL|date|',none,''|time|',none,''|event|',none,''|shortdesc|',none,''|fulldesc|',none,''|org|',none,''|contact1|',none,''|email1|',none,''|phone1|',none,''|url|',none,''|location|',none,''|lcity|',none,''|lstate|',none,''|lcountry|',none,''|laddress|',none,''|lzip|',none,''|endorse|',none,''|publish|none,1,0|repeat|none,1,0|student|none,1,0|fpevent|none,1,0|fporder|',none,''|region|',none,''|section|',none,''"; require "../Connections/insetstuff.php"; require "../Connections/dataactions.php"; ob_end_flush(); } $state = $dbcon->Execute("SELECT * FROM states") or die($dbcon->ErrorMsg()); $state_numRows = 0; $state__totalRows = $state->RecordCount(); $eventtype = $dbcon->Execute("SELECT * FROM eventtype order by name asc") or die($dbcon->ErrorMsg()); $eventtype_numRows = 0; $eventtype__totalRows = $eventtype->RecordCount();
// *** Update Record: set variables if ( ((isset($_REQUEST['MM_update'])) && (isset($_REQUEST['MM_recordId'])) ) or (isset($_REQUEST['MM_insert'])) or ((isset($_REQUEST['MM_delete'])) && (isset($_REQUEST['MM_recordId']))) ) { $getimgset=$dbcon->Execute("SELECT thumb, optw, optl FROM sysvar where id =1") or DIE($dbcon->ErrorMsg()); if ($_FILES['file']['name']) { $image2 = upload_image('',$getimgset->Fields("optw"),$getimgset->Fields("optl"),$getimgset->Fields("thumb")); } if (!$_REQUEST['MM_insert']) { $MM_editRedirectUrl = "edittypes.php";} $MM_editTable = "articletype"; $MM_editColumn = "id"; $MM_recordId = "" . $_REQUEST['MM_recordId'] . ""; $date2 = DateConvertIn($date2); $MM_fieldsStr = "type|value|url|value|image|value|checkbox|value|cap|value|up|value|description|value|uselink|value|linkurl|value|order|value|usetype|value|usenav|value|image2|value|css|value|flash|value|templateid|value|parent|value|listtype|value|date2|value|searchbar|value|secure|value|header|value"; $MM_columnsStr = "type|',none,''|url|',none,''|image|',none,''|useimage|none,1,0|imgcap|',none,''|up|',none,''|description|',none,''|uselink|none,1,0|linkurl|',none,''|textorder|',none,''|usetype|none,1,0|usenav|none,1,0|image2|',none,''|css|',none,''|flash|',none,''|templateid|none,none,NULL|parent|',none,''|listtype|',none,''|date2|',none,''|searchbar|none,1,0|secure|none,1,0|header|none,1,0"; require ("../Connections/insetstuff.php"); require ("../Connections/dataactions.php"); if ($MM_insert) { $getid=$dbcon->Execute("select id from articletype order by id desc limit 1") or DIE($dbcon->ErrorMsg()); $MM_editTable = "articles"; $MM_editRedirectUrl = "edittypes.php"; $newsec = $getid->Fields("id"); $MM_fieldsStr = "type|value|description|value|newsec|value|classxx|value|publishxx|value"; $MM_columnsStr = "title|',none,''|test|',none,''|type|',none,''|class|none,none,8|publish|none,none,1"; require ("../Connections/insetstuff.php"); require ("../Connections/dataactions.php");