Example #1
0
<?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"); ?>
Example #2
0
// *** 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();
Example #3
0
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();
Example #4
0
$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();
Example #5
0
  // *** 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");