Beispiel #1
0
/**
* log Import events for importing files
* @param string $csv_file
* @param boolean $Pass
* @param string $Description
* @param string $ImportFlag
*/
function fun_Log_Import($csv_file, $Pass, $Description, $ImportFlag = 0)
{
    global $conn, $intTimeStamp;
    preg_match("/ftp:\\/\\/(.*)/i", $Site, $arMatch);
    //just get the URL
    $Site = $arMatch[1];
    //record to log to mysql for web page monitoring
    $HostID = 1;
    $Name = "Import {$csv_file}";
    $Description = "{$Description}";
    $CategoryID = 1033;
    $Success = $Pass;
    //1=yes, 0=no
    $DateCreated = $intTimeStamp;
    $LastUpdated = $intTimeStamp;
    //$ImportFlag	= 1; //this is to notify the next stage that we are ready to move data
    //check to see if we need to insert or update?
    $query = "SELECT MonitorID FROM monitor WHERE (HostID='{$HostID}') AND (Name = '{$Name}')";
    $field = "MonitorID";
    $rsMonitorID = fun_SQLQuery2($query, $field);
    if ($rsMonitorID) {
        $query = "UPDATE monitor SET LastUpdated = '{$LastUpdated}', Success='{$Success}', ImportFlag='{$ImportFlag}', CategoryID='{$CategoryID}'\n\t\t\t WHERE (MonitorID='{$rsMonitorID}'); ";
    } else {
        $query = "INSERT INTO monitor (DateCreated, HostID, Name, Description, Success, CategoryID) \n\t\t\t  VALUES ('{$DateCreated}', '{$HostID}', '{$Name}', '{$Description}', '{$Success}', '{$CategoryID}');";
    }
    //run the query
    if ($query) {
        fun_SQLQuery($query, $WantRC = 0, $WantLID = 1, $rtnRC = "", $rtnLID = "", $arVar = "");
        $ImportID = $rtnLID;
    }
    return $ImportID;
}
/**
* get a record like arData[field] = value
* @param string $DB
* @param stinrg $Table
* @param string $ID
*
* @returns array $arData  like arData[field] = value
*/
function fun_SQLQuery_InArray($DB, $Table, $ID, $OtherDBConn = "", $OtherIDName = "")
{
    global $conn;
    //debug
    //echo "\nfun_SQLQuery_InArray[[Table($Table)";
    if ($Table) {
        if (!$OtherIDName) {
            $PriKeyName = fun_Mysql_getPrimaryKeyColumn($DB, $Table, $OtherDBConn);
            //get primary id name
        } else {
            $PriKeyName = $OtherIDName;
        }
        $query = "SELECT * FROM `{$DB}`.`{$Table}` WHERE ({$PriKeyName} = '{$ID}')";
        //debug
        //echo "query:($query)";
        $arColumns = fun_Mysql_getColumns($Table, $DB);
        //get columns
        $result = fun_SQLQuery($query, $WantRC = 0, $WantLID = 0, $rtnRC = "", $rtnLID = "", $OtherDBConn, $arVar = "");
        while ($row = mysqli_fetch_object($result)) {
            foreach ($arColumns as $field) {
                $arData[$field] = $row->{$field};
            }
        }
        //end while(rs)
    }
    //if query
    //debug
    //echo "]]fun_SQLQuery_InArray\n";
    return $arData;
}
Beispiel #3
0
 public function fun_Merge_Status_Directory_Files()
 {
     //put all files in active
     $query = "SELECT * FROM nwmls.image_index WHERE Path like '%sold%'";
     $result = fun_SQLQuery($query, $WantRC = 0, $WantLID = 0, $rtnRC = "", $rtnLID = "", $OtherDBConn = "", $arVar = "");
     while ($row = mysqli_fetch_object($result)) {
         $rsPath = $row->Path;
         $FileName = $row->Name;
         $rsPath = ereg_replace("/mnt/sas", "", $rsPath);
         //new directory to move to
         $LocalBaseDir = $this->LocalBaseDir;
         $subDirL = $this->fun_getSubDir($FileName, $Remote = 1);
         $local_file = $LocalBaseDir . $subDirL . "/{$FileName}";
         //move file
         $cmd = "mv {$rsPath} {$local_file}";
         echo "{$cmd}\n";
         exec($cmd);
         //update path
         $query = "UPDATE nwmls.image_index SET Path = '{$local_file}' WHERE (Name = '{$FileName}') ";
         fun_SQLQuery($query, $WantRC = 0, $WantLID = 0, $rtnRC = "", $rtnLID = "", $OtherDBConn = "", $arVar = "");
     }
 }
/**
* transform date into unix timestamp and update the mysql field
* @author Brandon Donnelson sept 4 2007
*
* @param string $DB
* @param string $Sample_Table mysql table
* @param string $New_Table_ID 
*
* @returns bol true
*/
function fun_Mysql_Optimize_Date($DB, $Sample_Table, $New_Table_ID, $Column, $OtherDBConn = "")
{
    if (!$New_Table_ID) {
        $New_Table_ID = fun_Mysql_getPrimaryKeyColumn($DB, $Sample_Table, $OtherDBConn);
    }
    $query = "SELECT {$New_Table_ID}, {$Column} FROM `{$DB}`.`{$Sample_Table}`";
    $result = fun_SQLQuery($query, $WantRC = 0, $WantLID = 0, $rtnRC = "", $rtnLID = "", $OtherDBConn = "", $arVar = "");
    while ($row = mysqli_fetch_object($result)) {
        $rsID = $row->{$New_Table_ID};
        $rsColumn = $row->{$Column};
        $rsColumn = strtotime($rsColumn);
        $query = "UPDATE `{$DB}`.`{$Sample_Table}` SET {$Column} = '{$rsColumn}' WHERE ({$New_Table_ID} = '{$rsID}')";
        echo "DatesToInteger:{$rsColumn} -> {$query}\n";
        fun_SQLQuery($query, $WantRC = 0, $WantLID = 0, $rtnRC = "", $rtnLID = "", $OtherDBConn = "", $arVar = "");
    }
    return TRUE;
}
Beispiel #5
0
/**
* get 1 row of data by unique id in array
* @author Brandon Donnelson sept 4 2007 2:12am
* @param string $DB
* @param string $Table table to get row of data from
* @param string $ID unique id that designates the row
* @returns array $arData['key'] and $arData['value']
*
*/
function fun_Mysql_getRowData($DB, $Table, $ID)
{
    //debug
    //echo "fun_Mysql_getRowData: $DB, $Table, $ID\n";
    $Name_ID = fun_Mysql_getPrimaryKeyColumn($DB, $Table, $OtherDBConn);
    $arColumns = fun_Mysql_getColumns($Table, $DB);
    $query = "SELECT * FROM `{$DB}`.`{$Table}` WHERE ({$Name_ID} = '{$ID}')";
    $result = fun_SQLQuery($query, $WantRC = 0, $WantLID = 0, $rtnRC = "", $rtnLID = "", $OtherDBConn = "", $arVar = "");
    while ($row = mysqli_fetch_object($result)) {
        foreach ($arColumns as $Field) {
            $arData[$Field] = $row->{$Field};
        }
    }
    return $arData;
}