Ejemplo n.º 1
0
 function executa($sql, $prepared = 0)
 {
     $this->dados = null;
     //	$show_sql = 1;
     if (substr(TRIM(STRTOUPPER($sql)), 0, strpos(TRIM(STRTOUPPER($sql)), " ")) == "SELECT") {
         //select
         $select = 1;
         $this->res = $this->pdo->query($sql);
         $this->nrw = $this->res->rowCount();
     } else {
         if ($prepared == 1) {
             $stmt = $this->pdo->prepare($sql);
             //$stmt->bindParam(":val", $prepared, PDO::PARAM_STR);
             if ($stmt->execute()) {
                 $this->res = true;
                 $this->dados = $stmt->fetch(PDO::FETCH_ASSOC);
             } else {
                 $this->res = false;
             }
         } else {
             //others
             $this->res = $this->pdo->exec($sql);
             //$a =  $this->pdo->fetchAll(); var_dump($a);
         }
     }
     if ($show_sql) {
         echo "\n BBBBBB " . $sql;
     }
     //	var_dump($this->res);
     if ($this->res > 0) {
         //if ($select == 1)
         //	$this->navega(0);
         //else
         return true;
     } else {
         return false;
     }
 }
Ejemplo n.º 2
0
 public function FileReceptor($fullFileName, $userdata)
 {
     // userdata is the same passed via widget config.
     $path_parts = pathinfo($fullFileName);
     if (rename($fullFileName, $path_parts['dirname'] . DIRECTORY_SEPARATOR . $userdata . '.' . $path_parts['extension'])) {
         $ruta_imagen = $fullFileName;
         $miniatura_ancho_maximo = 200;
         $miniatura_alto_maximo = 200;
         $info_imagen = getimagesize('materiales' . DIRECTORY_SEPARATOR . $userdata . '.' . $path_parts['extension']);
         $imagen_ancho = $info_imagen[0];
         $imagen_alto = $info_imagen[1];
         $imagen_tipo = $info_imagen['mime'];
         $proporcion_imagen = $imagen_ancho / $imagen_alto;
         $proporcion_miniatura = $miniatura_ancho_maximo / $miniatura_alto_maximo;
         if ($proporcion_imagen > $proporcion_miniatura) {
             $miniatura_ancho = $miniatura_ancho_maximo;
             $miniatura_alto = $miniatura_ancho_maximo / $proporcion_imagen;
         } else {
             if ($proporcion_imagen < $proporcion_miniatura) {
                 $miniatura_ancho = $miniatura_ancho_maximo * $proporcion_imagen;
                 $miniatura_alto = $miniatura_alto_maximo;
             } else {
                 $miniatura_ancho = $miniatura_ancho_maximo;
                 $miniatura_alto = $miniatura_alto_maximo;
             }
         }
         switch ($imagen_tipo) {
             case "image/jpg":
             case "image/jpeg":
                 $imagen = imagecreatefromjpeg('materiales' . DIRECTORY_SEPARATOR . $userdata . '.' . $path_parts['extension']);
                 break;
             case "image/png":
                 $imagen = imagecreatefrompng('materiales' . DIRECTORY_SEPARATOR . $userdata . '.' . $path_parts['extension']);
                 break;
             case "image/gif":
                 $imagen = imagecreatefromgif('materiales' . DIRECTORY_SEPARATOR . $userdata . '.' . $path_parts['extension']);
                 break;
         }
         $lienzo = imagecreatetruecolor($miniatura_ancho, $miniatura_alto);
         imagecopyresampled($lienzo, $imagen, 0, 0, 0, 0, $miniatura_ancho, $miniatura_alto, $imagen_ancho, $imagen_alto);
         imagejpeg($lienzo, 'materiales' . DIRECTORY_SEPARATOR . $userdata . '.' . STRTOUPPER($path_parts['extension']), 50);
     } else {
     }
 }
Ejemplo n.º 3
0
function BrowseModuleTaskACL($module)
{
    $db = $GLOBALS['db'];
    $module_id = $GLOBALS['module_id'];
    /* SETUP THE INITIAL MODULE DIRECTORY */
    $dir = $GLOBALS['dr'] . "modules/" . $module . "/modules/";
    /* CHECK THAT THE MODULE EXISTS */
    if (!file_exists($dir)) {
        return "No such directory";
    }
    /* LOOP THE PHP FILES IN EACH MODULE */
    $dir_arr[] = "";
    if ($handle = opendir($dir)) {
        while (false !== ($file = readdir($handle))) {
            if ($file != "." && $file != ".." && substr($file, -4) == ".php") {
                $dir_arr[] = substr($file, 0, -4);
            }
        }
        closedir($handle);
    }
    /* SORT THE ARRAY INTO ALPHABETICAL ORDER */
    sort($dir_arr, SORT_REGULAR);
    /**** THIS IS THE SUBMIT FORM PART WHICH WE PUT IN HERE BECAUSE THIS PAGE IS LOADED FROM MANY LOCATIONS ****/
    if (isset($_POST['submit_form'])) {
        for ($i = 1; $i < count($dir_arr); $i++) {
            /* GRAB ALL THE ROLES SINCE WE DO NOT SIMPLY UPDATE WHATEVER CAME FROM THE FORM */
            $sql = "SELECT crm.role_id,crm.role_name\n\t\t\t\t\t\tFROM " . $GLOBALS['database_prefix'] . "core_workspace_role_master crm\n\t\t\t\t\t\tWHERE crm.workspace_id = " . $GLOBALS['ui']->WorkspaceID() . "\n\t\t\t\t\t\tORDER BY crm.role_name\n\t\t\t\t\t\t";
            //echo $sql."<br>";
            $result = $db->Query($sql);
            if ($db->NumRows($result) > 0) {
                while ($row = $db->FetchArray($result)) {
                    $post_var = $dir_arr[$i] . "_" . $row['role_id'];
                    if (isset($_POST[$post_var]) && $_POST[$post_var] == "y") {
                        $access = "y";
                    } else {
                        $access = "n";
                    }
                    /* SINCE NEW TASKS AND ROLES CAN BE ADDED WE MAKE SURE THE RECORD EXISTS */
                    CheckCreateACLTaskExists($row['role_id'], $module_id, $dir_arr[$i]);
                    $sql = "UPDATE " . $GLOBALS['database_prefix'] . "core_space_task_acl\n\t\t\t\t\t\t\t\tSET access = '" . $access . "'\n\t\t\t\t\t\t\t\tWHERE role_id = " . $row['role_id'] . "\n\t\t\t\t\t\t\t\tAND module_id = '" . $module_id . "'\n\t\t\t\t\t\t\t\tAND task = '" . $dir_arr[$i] . "'\n\t\t\t\t\t\t\t\tAND workspace_id = " . $GLOBALS['workspace_id'] . "\n\t\t\t\t\t\t\t\tAND teamspace_id " . $GLOBALS['teamspace_sql'] . "\n\t\t\t\t\t\t\t\t";
                    //echo $sql."<br>";
                    $success = $db->Query($sql);
                }
            }
        }
    }
    /**** END FORM SUBMITTING ****/
    /* DISPLAY EACH */
    $c = "<table class='plain' border='0'>\n";
    $c .= "<form method='post' name='acl' action='index.php?module=" . $module . "&task=acl'>\n";
    for ($i = 1; $i < count($dir_arr); $i++) {
        $c .= "<tr class='alternatecell2'>\n";
        $c .= "<td colspan='3'>" . STRTOUPPER($dir_arr[$i]) . "</td>\n";
        $c .= "</tr>\n";
        /* DISPLAY ALL THE ROLES*/
        $sql = "SELECT crm.role_id,crm.role_name\n\t\t\t\t\t\tFROM " . $GLOBALS['database_prefix'] . "core_workspace_role_master crm\n\t\t\t\t\t\tWHERE crm.workspace_id = " . $GLOBALS['ui']->WorkspaceID() . "\n\t\t\t\t\t\tORDER BY crm.role_name\n\t\t\t\t\t\t";
        //echo $sql."<br>";
        $result = $db->Query($sql);
        if ($db->NumRows($result) > 0) {
            while ($row = $db->FetchArray($result)) {
                if (CheckAccess($row['role_id'], $module_id, $dir_arr[$i])) {
                    $selected = "checked";
                } else {
                    $selected = "";
                }
                $c .= "<tr>\n";
                $c .= "<td><li></td>\n";
                $c .= "<td>" . $row['role_name'] . "</td>\n";
                $c .= "<td><input type='checkbox' value='y' name='" . $dir_arr[$i] . "_" . $row['role_id'] . "' {$selected}>\n";
                $c .= "</tr>\n";
            }
        }
        /* END */
    }
    $c .= "<tr class='alternatecell2'>\n";
    $c .= "<td colspan='3'><input type='submit' name='submit_form' value='Save' class='buttonstyle'></td>\n";
    $c .= "</tr>\n";
    $c .= "</form>\n";
    $c .= "</table>\n";
    return $c;
}
Ejemplo n.º 4
0
        $tampilurut = 'Saldo Akhir';
    }
    if ($urut == 'harga') {
        $tampilurut = 'Harga';
    }
    $bg = " bgcolor=#DEDEDE";
    $brdr = 1;
    $tab .= 'Mutasi Stock ' . $unit . ' ' . $tahun . '<br>';
    $tab .= 'Opsi: ' . $kelompok . ' ' . $mayor . ' ' . $pilih . '<br>';
    $tab .= 'Urut: ' . $tampilurut . ' ' . $asc;
} else {
    $bg = "";
    $brdr = 0;
}
$tab .= "<table cellpadding=1 cellspacing=1 border=" . $brdr . " class=sortable style='width:100%;'><thead><tr>\r\n<td rowspan=1 align=center " . $bg . ">No.</td>";
$tab .= "<td align=left " . $bg . ">" . STRTOUPPER($_SESSION['lang']['kodebarang']) . "<br>" . STRTOUPPER($_SESSION['lang']['namabarang']) . "<br>" . STRTOUPPER($_SESSION['lang']['satuan']) . "</td>";
$tab .= "<td align=left " . $bg . "></td>";
for ($i = 1; $i <= 12; $i++) {
    if (strlen($i) == 1) {
        $ii = '0' . $i;
    } else {
        $ii = $i;
    }
    $per = $tahun . "-" . $ii;
    $tab .= "<td align=center " . $bg . ">" . $per . "</td>";
    // periode
}
$tab .= "<td align=center " . $bg . ">" . $tahun . "</td>";
// total setahun
$tab .= "</tr>";
$tab .= "</thead><tbody>";
Ejemplo n.º 5
0
function InitCap($v)
{
    return STRTOUPPER(SUBSTR($v, 0, 1)) . SUBSTR($v, 1);
}
Ejemplo n.º 6
0
         //echo strstr(strstr($tipodato,")",true),"(");
         $longitud = substr_replace(strstr(strstr($tipodato, ")", true), "("), '', 0, 1);
         //echo $longitud;
     }
 }
 echo "<input type='text' size='4' maxlength='4' name='longitudCol' value='{$longitud}'/>";
 echo "<input type='text' size='1' maxlength='1' name='precisionCol' value='{$precision}'/>";
 echo "<input type='checkbox' name='noNulo'";
 if (STRTOUPPER($valSQL['IS_NULLABLE']) == 'NO') {
     echo " checked";
 }
 echo ">No Nulo";
 echo "<input type='checkbox' name='default'";
 $default = "";
 $tipoDato = $valSQL['DATA_TYPE'];
 if (STRTOUPPER($valSQL['COLUMN_DEFAULT']) != NULL) {
     echo " checked";
     $default = $valSQL['COLUMN_DEFAULT'];
     /*if($tipoDato=="BIT" || $tipoDato=="TINYINT" || $tipoDato=="SMALLINT" || $tipoDato=="MEDIUMINT"
     		|| $tipoDato=="INT" || $tipoDato=="DOUBLE" || $tipoDato=="FLOAT" || $tipoDato=="NUMERIC"){
     			$default=$valSQL['COLUMN_DEFAULT'];
     		}else{
     			$default="'".$valSQL['COLUMN_DEFAULT']."'";
     		}
     		*/
 }
 echo ">default";
 echo "<input type='text' size='30' maxlength='30' name='defaultVal' value='{$default}'/>";
 echo "<input type='submit' value='ModificarColumna'/>";
 echo "</tr>";
 echo "<br>";
Ejemplo n.º 7
0
               <tr valign="baseline">
            <td nowrap align="right"><span class="label"><?php 
echo $lang["lang_front"];
?>
</span><br>
            <span class="info"><?php 
echo $lang["lang_front_note"];
?>
</span></td>
            <td><select name="lang_front" size="1" style="width: 70px;">
                   <?php 
$dp = opendir('../lang/');
while (false !== ($file = readdir($dp))) {
    $ext = explode('.', $file);
    if ($file != '.' && $file != '..' && $ext[1] == 'php') {
        $name = STRTOUPPER($ext[0]);
        $value = STRTOLOWER($ext[0]);
        $selected = $ext[0] == $langfront ? 'selected' : '';
        echo '<option value="' . $value . '" ' . $selected . '>- ' . $name . ' -</option>';
    }
}
closedir($dp);
?>
             </select><br><br>
             </td>
             </tr>
              <tr valign="top">
            <td align="right" valign="top" nowrap><span class="label"><?php 
echo $lang["wysiwyg"];
?>
</span><br>
Ejemplo n.º 8
0
//case "F" : Echo "The String Begins with a Consonant";Break;
//case "G" : Echo "The String Begins with a Consonant";Break;
//case "H" : Echo "The String Begins with a Consonant";Break;
//case "I" : Echo "The String Begins with a Vowel";Break;
//case "J" : Echo "The String Begins with a Consonant";Break;
//case "K" : Echo "The String Begins with a Consonant";Break;
//case "L" : Echo "The String Begins with a Consonant";Break;
//case "M" : Echo "The String Begins with a Consonant";Break;
//case "N" : Echo "The String Begins with a Consonant";Break;
//case "O" : Echo "The String Begins with a Vowel";Break;
//case "P" : Echo "The String Begins with a Consonant";Break;
//case "Q" : Echo "The String Begins with a Consonant";Break;
//case "R" : Echo "The String Begins with a Consonant";Break;
//case "S" : Echo "The String Begins with a Consonant";Break;
//case "T" : Echo "The String Begins with a Consonant";Break;
//case "U" : Echo "The String Begins with a Vowel";Break;
//case "V" : Echo "The String Begins with a Consonant";Break;
//case "X" : Echo "The String Begins with a Consonant";Break;
//case "Y" : Echo "The String Begins with a Consonant";Break;
//case "Z" : Echo "The String Begins with a Consonant";Break;
//}
$F = STRTOUPPER(substr($string, 0, 1));
if ($F == "A" || $F == "E" || $F == "I" || $F == "O" || $F == "U") {
    echo "The String Begins with a Vowel";
}
if ($F == "B" || $F == "C" || $F == "D" || $F == "F" || $F == "G" || $F == "H" || $F == "J" || $F == "K" || $F == "L" || $F == "M" || $F == "N" || $F == "P" || $F == "Q" || $F == "R" || $F == "S" || $F == "T" || $F == "V" || $F == "W" || $F == "X" || $F == "Y" || $F == "Z") {
    echo "The String Begins with a Consonant";
}
?>
</body>
</html>
Ejemplo n.º 9
0
 function login($params)
 {
     $success = 1;
     if (empty($params)) {
         return false;
     }
     if (empty($params['username'])) {
         output_message('alert', 'You did not provide your username');
         $success = 0;
     }
     if (empty($params['password'])) {
         output_message('alert', 'You did not provide your password');
         $success = 0;
     }
     $res = $this->DB->selectRow("\n\t\t\t\tSELECT `account`.`id`,`username`,`sha_pass_hash`,`active`,`locked`, `gmlevel` FROM account\n\t\t\t\tLEFT JOIN account_banned ON (account_banned.id=account.id AND account_banned.active=1)\n                WHERE account.username = ?", $params['username']);
     if ($res['id'] < 1) {
         $success = 0;
         output_message('alert', 'Bad username or password');
     }
     if ($res['active'] > 0) {
         output_message('alert', 'Your account is currently banned');
         $success = 0;
     }
     if ($res['activation_code'] != null) {
         output_message('alert', 'Your account is not active');
         $success = 0;
     }
     if ($success != 1) {
         return false;
     }
     $res['sha_pass_hash'] = strtoupper($res['sha_pass_hash']);
     if ($res['sha_pass_hash'] == strtoupper($this->gethash(strtoupper(trim($params['username'])) . ":" . strtoupper(trim($params['password']))))) {
         $this->user['id'] = $res['id'];
         $this->user['name'] = $res['username'];
         $this->user['level'] = $res['gmlevel'];
         $uservars_hash = serialize(array($res['id'], STRTOUPPER($res['sha_pass_hash'])));
         setcookie($this->config['site_cookie'], $uservars_hash, time() + 60 * 60 * 24 * 365, $this->config['site_href'], $this->config['site_domain']);
         // expires in 365 days
         if ($this->config['onlinelist_on']) {
             $this->onlinelist_delguest();
         }
         return true;
     } else {
         output_message('alert', 'Your password is incorrect');
         return false;
     }
 }
Ejemplo n.º 10
0
function LIST_ZIP($NODE)
{
    global $encabezado;
    $CURRENT_FILE = BUILD_PATH($NODE);
    $REAL_FILE = str_replace(DIRECTORY_SEPARATOR . DIRECTORY_SEPARATOR, DIRECTORY_SEPARATOR, DIRNAME($_SESSION['Server_Path'])) . DIRECTORY_SEPARATOR . $CURRENT_FILE;
    // the real full filename of the directory
    if (empty($BGC)) {
        $BGC = "BLACK";
    }
    if (empty($FGC)) {
        $FGC = "YELLOW";
    }
    $fp = @fopen($REAL_FILE, 'rb');
    if (!$fp) {
        return;
    }
    fseek($fp, -22, SEEK_END);
    // Get central directory field values
    $headersignature = 0;
    do {
        // Search header
        $data = fread($fp, 22);
        list($headersignature, $numberentries, $centraldirsize, $centraldiroffset) = array_values(unpack('Vheadersignature/x6/vnumberentries/Vcentraldirsize/Vcentraldiroffset', $data));
        fseek($fp, -23, SEEK_CUR);
    } while ($headersignature != 0x6054b50 && ftell($fp) > 0);
    // Go to start of central directory
    fseek($fp, $centraldiroffset, SEEK_SET);
    // Read central dir entries
    PAGE_HEADER("FILE FUNCTIONS - DIRTREEVIEW", "LIST ZIP CONTENTS OF " . STRTOUPPER(basename($REAL_FILE)), $BGC, $FGC);
    echo "<p><CENTER><table border='' bgcolor={$BGC} cellpadding='0' cellspacing='0' class=td>";
    echo "\r\n    <tr bgcolor={$BGC}>\r\n        <td>&nbsp</td>\r\n       <td>\r\n          <H3><b><font color={$FGC}>FileName</font></b></H3>\r\n       </td>\r\n       <td ALIGN=RIGHT>\r\n          <H3><b><font color={$FGC}>Size</font></b></H3>\r\n       </td>\r\n       <td>&nbsp</td>\r\n       <td>&nbsp</td>\r\n       <td>&nbsp</td>\r\n       <td>\r\n          <H3><b><font color={$FGC}>Date:Time</font></b></H3>\r\n       </td>\r\n        <td>&nbsp</td>\r\n    </tr>";
    for ($i = 1; $i <= $numberentries; $i++) {
        // Read central dir entry
        $data = fread($fp, 46);
        list($arcfiletime, $arcfiledate, $arcfilesize, $arcfilenamelen, $arcfileattr) = array_values(unpack("x12/varcfiletime/varcfiledate/x8/Varcfilesize/Varcfilenamelen/x6/varcfileattr", $data));
        $filenamelen = fread($fp, $arcfilenamelen);
        $arcfiledatetime = MSDOS_TIME_TO_UNIX($arcfiledate, $arcfiletime);
        echo "<tr BGCOLOR={$FGC}>";
        echo "<td>&nbsp</td>";
        // Print FileName
        if ($arcfileattr == 16) {
            echo "<td><font color='{$BGC}'>";
            echo "<b>" . $filenamelen . "</b>";
            echo "</td></font>";
        } else {
            echo "<td ><font color='{$BGC}'>";
            echo "...." . basename($filenamelen);
            echo "</font></td>";
        }
        // Print FileSize column
        if ($arcfileattr == 16) {
            echo "<td><font color='{$BGC}'>";
            echo "<B>Folder</B>";
            echo "</td><td>&nbsp</td><td>&nbsp</td><td>&nbsp</td>";
        } else {
            echo "<td align=right><font color='{$BGC}'>";
            if ($arcfilesize > 0) {
                if (!isset($_SESSION['Display_Size'])) {
                    $_SESSION['Display_Size'] = "";
                }
                switch ($_SESSION['Display_Size']) {
                    case 2:
                        echo NUMBER_FORMAT($arcfilesize / (1024 * 1024), 2, ',', '.');
                        $DES_BYTES = "mb";
                        break;
                    case 1:
                        echo NUMBER_FORMAT($arcfilesize / 1024, 1, ',', '.');
                        $DES_BYTES = "kb";
                        break;
                    default:
                        echo NUMBER_FORMAT($arcfilesize, 0, ',', '.');
                        $DES_BYTES = "bytes";
                }
                // switch
            } else {
                echo "&nbsp";
                $DES_BYTES = "";
            }
            echo "</Td>";
            echo "<Td>&nbsp</Td>";
            echo "<td ALIGN=left><Font COLOR={$BGC}>{$DES_BYTES}</Td>";
            echo "<Td ALIGN=right><Font COLOR={$BGC}>&nbsp</Td>";
        }
        echo '</td></font>';
        // Print FileDate column
        echo "<td><font color={$BGC}>";
        if ($arcfileattr == 16) {
            echo "<B>" . date("d/m/y H:i", $arcfiledatetime) . "</B>";
        } else {
            echo date("d/m/y H:i", $arcfiledatetime);
        }
        echo '</td></font>';
        echo "<td>&nbsp</td>";
        echo '</tr>';
    }
    echo "\r\n    <tr bgcolor={$BGC}>\r\n        <td VALIGN=middle COLSPAN=8><CENTER>\r\n            <a href=" . $_SERVER['PHP_SELF'] . "?ACTION=expand&NODE=" . $NODE . "&FILE_EXTENSION=" . $_SESSION['File_Extension'] . "{$encabezado}><B><Font COLOR={$FGC}><H3>BACK</H3>\r\n            </Font></B></A>\r\n        </Td>\r\n    </tr>";
    echo '</table></p>';
    fclose($fp);
    PAGE_FOOTER($BGC, $FGC);
    exit;
}