<? 
$db=array();
$db['host']='localhost';
$db['name']='tdsonlin_TDSMYSQL';
$db['user']='tdsonlin_tds1';
$db['pass']='sqldb11$$$go';


$ftp=array();
/*
$ftp['host']='tdslive.snapfulfil.net';
$ftp['user']='tdslive';
$ftp['pass']='fjV0F13';
*/
$ftp['host']='tdstest.snapfulfil.net';
$ftp['user']='tdstest';
$ftp['pass']='tdstest';
$ftp['uploadDir']='/ToSnap/Transfer/';
$ftp['successDir']='/ToSnap/'; //final move on successfull upload

$clientFolder=dirname(dirname(dirname(__FILE__)))."/";

$pdfLibPath=dirname(dirname(dirname(__FILE__))).'/_html2ps';
$pdfSize="A4";
$pdfMode="portrait"; // landscape
$pdfWidth=986;
?><? 
// Placeholder.php v2.0 
// ~~~~~~~~~~~~~~~~~~~~ 
// This file contains two useful functions to simplify 
// working with SQL queries in PHP and make it more secure. 
// 
// This code is absolutely free. You may modify it as you want. 
// Author would be pleased if you send your changes & notices. 
// 
// (C) 2003-04-09. Moscow - Russia - The Earth - Solar system - The Galaxy. 
// Dmitry Koteroff (chicken@dklab.ru) 
// http://dklab.ru/chicken/30.html 
// 

// On error sql_placeholder_ex() returns message with this prefix. 
@define("PLACEHOLDER_ERROR_PREFIX", "ERROR: "); 

// function sql_compile_placeholder(string $tmpl) 
// Fast-parse template & save positions of all placeholders. 
// Returns: 
// list( 
//   list( 
//     $key,    // key of this placeholder 
//     $type,   // '@'|'%'|'#'|'' 
//     $start,  // placeholder start pos 
//     $length  // placeholder length 
//   ), 
//   $tmpl,     // source template string 
//   $has_named // has this template at least one named placeholder? 
// ) 
function sql_compile_placeholder($tmpl) 
{ 
    $compiled  = array(); 
    $p         = 0;  // current string position 
    $i         = 0;  // placeholder enumerator 
    $has_named = false; 
    while (false !== ($start = $p = strpos($tmpl, "?", $p))) { 
        // Type of placeholder. 
        switch ($c = substr($tmpl, ++$p, 1)) { 
            case '%': case '@': case '#': 
                $type = $c; ++$p; break; 
            default: 
                $type = ''; break; 
        } 
        // Check if it's a key-based placeholder: "?keyname" 
        $len = strcspn(substr($tmpl, $p), " \t\r\n,;()[]/"); 
        if ($len) { 
            $key = substr($tmpl, $p, $len); 
            if ($type != '#') $has_named = true; 
            $p += $len; 
        } else { 
            $key = $i; 
            if ($type != '#') $i++; 
        } 
        // Save compiled entry. 
        $compiled[] = array($key, $type, $start, $p - $start); 
    } 
    return array($compiled, $tmpl, $has_named); 
} 


// bool sql_placeholder_ex(mixed $tmpl, array $args, string &$errormsg) 
// 
// Replace all special characters in $tmpl into SQL-safe values 
// from $args. On error stores the message to $errormsg. 
// 
// Template special characters: 
//   ?  - replace by ONE value. 
//   ?@ - replace by LIST: 'a', 'b', ... (e.g. IN (?@)) 
//   ?% - replace by KEY-VALUE LIST: k1='v1', k2='v2', ... (e.g. SET ?%) 
// 
// After each placeholder a key can be specified: "?k", "?@k", 
// "?%k", that means it's a named placeholder. 
// 
// Argument $tmpl may be already compiled presentation of the template 
// (if your need the fastest way to execute). Use sql_compile_placeholder 
// before if you need. 
// 
// If there are at least one named placeholder in the template, 
// $args must contain exactly one 0=>value, and $args[0] must be 
// the associative array with all the name=>value placeholder mappings. 
// 
// If there was en error while substituting (e.g. type mismatch, 
// invalid key etc.), it inserts the plain error message into the 
// $tmpl, assigns it to $errormsg and returns false. Otherwise 
// returns the template after all substitutions. 
function sql_placeholder_ex($tmpl, $args, &$errormsg) 
{ 
    // Already compiled?.. If not, compile now. 
    if (is_array($tmpl)) { 
        $compiled = $tmpl; 
    } else { 
        $compiled  = sql_compile_placeholder($tmpl); 
    } 

    list ($compiled, $tmpl, $has_named) = $compiled; 

    // If there are at east one named placeholder, use first 
    // function argument as replecement array. 
    if ($has_named) $args = @$args[0]; 

    // Make all the replacements. 
    $p   = 0;       // scan position 
    $out = '';      // resulting string 
    $error = false; // was any error? 

    foreach ($compiled as $num=>$e) { 
        list ($key, $type, $start, $length) = $e; 

        // Pre-string. 
        $out .= substr($tmpl, $p, $start - $p); 
        $p = $start + $length; 

        $repl = '';   // replacement. 
        $errmsg = ''; // error message on THIS substitution 
        do { 
            // Constant-style placeholder? 
            if ($type === '#') { 
                $repl = @constant($key); 
                if (NULL === $repl)  
                    $error = $errmsg = "UNKNOWN_CONSTANT_$key"; 
                break; 
            } 
            // Error handling. 
            if (!isset($args[$key])) { 
                $error = $errmsg = "UNKNOWN_PLACEHOLDER_$key"; 
                break; 
            } 
            // Insert value corresponding to placeholder type. 
            $a = $args[$key]; 

            if ($type === '') { 
                // Scalar-style placeholder. 
                if (is_array($a)) { 
                    $error = $errmsg = "NOT_A_SCALAR_PLACEHOLDER_$key"; 
                    break; 
                } 
                $repl = "'".addslashes($a)."'"; 
                break; 
            } 
            // Array or hash replacement. 
            if (!is_array($a)) { 
                $error = $errmsg = "NOT_AN_ARRAY_PLACEHOLDER_$key"; 
                break; 
            } 
            if ($type === '@') { 
                // List-style placeholder. 
                foreach ($a as $v)  
                    $repl .= ($repl===''? "" : ",")."'".addslashes($v)."'"; 
            } elseif ($type === '%') { 
                // Hash-style placeholder. 
                $lerror = array(); 
                foreach ($a as $k=>$v) { 
                    if (!is_string($k)) { 
                        $lerror[$k] = "NOT_A_STRING_KEY_{$k}_FOR_PLACEHOLDER_$key"; 
                    } else { 
                        $k = preg_replace('/[^a-zA-Z0-9_]/', '_', $k); 
                    } 
                    $repl .= ($repl===''? "" : ", ").$k."='".@addslashes($v)."'"; 
                } 
                // On error makes the reeor message. 
                if (count($lerror)) { 
                    $repl = ''; 
                    foreach ($a as $k=>$v) { 
                        if (isset($lerror[$k])) { 
                            $repl .= ($repl===''? "" : ", ").$lerror[$k]; 
                        } else { 
                            $k = preg_replace('/[^a-zA-Z0-9_-]/', '_', $k); 
                            $repl .= ($repl===''? "" : ", ").$k."=?"; 
                        } 
                    } 
                    $error = $errmsg = $repl; 
                } 
            } 
        } while (false); 
        if ($errmsg) $compiled[$num]['error'] = $errmsg; 
        if (!$error) $out .= $repl; 
    } 
    $out .= substr($tmpl, $p); 

    // If there was an error, re-make the resulting string 
    // ass error message. 
    if ($error) { 
        $out = ''; 
        $p   = 0;       // scan position 
        foreach ($compiled as $num=>$e) { 
            list ($key, $type, $start, $length) = $e; 
            $out .= substr($tmpl, $p, $start - $p); 
            $p = $start + $length; 
            if (isset($e['error'])) { 
                $out .= $e['error']; 
            } else { 
                $out .= substr($tmpl, $start, $length); 
            } 
        } 
        // Last post-string. 
        $out .= substr($tmpl, $p); 
        $errormsg = $out; 
        return false; 
    } else { 
        $errormsg = false; 
        return $out; 
    } 
} 


// function sql_placeholder(mixed $tmpl, $arg1 [,$arg2 ...]) 
// 
// Note: see description of sql_placeholder_ex() above. 
// 
// Returns the template after all substitutions or error message 
// prefixed with "ERROR: " string. 
// 
// If there was en error while substituting (e.g. type mismatch, 
// invalid key etc.), it inserts the plain error message into the 
// $tmpl and returns the string EXACTLY in form of: 
//   "ERROR: template_with_error_messages". 
// It have to raise SQL error when try to execute the query. 
// You may also analyse the return value: if it starts with 
// "ERROR: ", the substitution have been aborted. 
// 
// Instead of using array as the second parameter, you may 
// pass all the arguments one by one. 
// 
// If there are at least one named placeholder in the template, 
// function must take exactly two arguments, and $arg1 must be 
// the associative array with all the name=>value placeholder 
// mappings. 
function sql_placeholder() 
{ 
    $args = func_get_args();  
    $tmpl = array_shift($args); 
    $result = sql_placeholder_ex($tmpl, $args, $error); 
    if ($result === false) return PLACEHOLDER_ERROR_PREFIX.$error; 
    else return $result; 
} 


// function sql_pholder(mixed $tmpl, $arg1 [,$arg2 ...]) 
// 
// Note: see description of sql_placeholder_ex() above. 
// 
// Returns the template after all substitutions or error message 
// prefixed with "ERROR: " string. 
// 
// Instead of using array as the second parameter, you may 
// pass all the arguments one by one. 
// 
// If there are at least one named placeholder in the template, 
// function must take exactly two arguments, and $arg1 must be 
// the associative array with all the name=>value placeholder 
// mappings. 
function sql_pholder() 
{ 
    $args = func_get_args();  
    $tmpl = array_shift($args); 
    $result = sql_placeholder_ex($tmpl, $args, $error); 
    if ($result === false) { 
        $error = "Placeholder substitution error. Diagnostics: \"$error\""; 
        if (function_exists("debug_backtrace")) { 
            $bt = debug_backtrace(); 
            $error .= " in ".@$bt[0]['file']." on line ".@$bt[0]['line']; 
        } 
        trigger_error($error, E_USER_WARNING); 
        return false; 
    } 
    return $result; 
} 

// No newline or space after that! 
?>