/**
  * Connects to database
  *
  * @param array $db_info
  */
 public function __construct($db_info = null)
 {
     // Database config can be overwritten on construction.
     if (!is_null($db_info) && is_array($db_info)) {
         foreach ($db_info as $k => $v) {
             if (inarray($k, array('db_host', 'db_user', 'db_pass', 'db_base'))) {
                 $this->{$k} = $v;
             }
         }
     }
     try {
         $this->dbh = new PDO(sprintf('mysql:host=%s;dbname=%s', $this->db_host, $this->db_base), $this->db_user, $this->db_pass);
         $this->dbh->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
     } catch (PDOException $e) {
         echo $e->getMessage();
     }
 }
Exemple #2
0
     message_die(GENERAL_ERROR, "Couldn't obtain guest user/online information.", "", __LINE__, __FILE__, $sql);
 }
 $onlinerow_guest = $db->sql_fetchrowset($result);
 $sql = "SELECT forum_name, forum_id\n\t\tFROM " . FORUMS_TABLE;
 if ($forums_result = $db->sql_query($sql)) {
     while ($forumsrow = $db->sql_fetchrow($forums_result)) {
         $forum_data[$forumsrow['forum_id']] = $forumsrow['forum_name'];
     }
 } else {
     message_die(GENERAL_ERROR, "Couldn't obtain user/online forums information.", "", __LINE__, __FILE__, $sql);
 }
 $reg_userid_ary = array();
 if (count($onlinerow_reg)) {
     $registered_users = 0;
     for ($i = 0; $i < count($onlinerow_reg); $i++) {
         if (!inarray($onlinerow_reg[$i]['user_id'], $reg_userid_ary)) {
             $reg_userid_ary[] = $onlinerow_reg[$i]['user_id'];
             $username = $onlinerow_reg[$i]['username'];
             if ($onlinerow_reg[$i]['user_allow_viewonline'] || $userdata['user_level'] == ADMIN) {
                 $registered_users++;
                 $hidden = FALSE;
             } else {
                 $hidden_users++;
                 $hidden = TRUE;
             }
             if ($onlinerow_reg[$i]['user_session_page'] < 1) {
                 switch ($onlinerow_reg[$i]['user_session_page']) {
                     case PAGE_INDEX:
                         $location = $lang['Forum_index'];
                         $location_url = "index.{$phpEx}?pane=right";
                         break;
                }
                $url = URL::to('videos/' . $cd . '/' . $entry);
                $vid = false;
                $type = 'insert_drive_file';
                //$ext = explode('.',$entry);
                if (inarray($entry, $video)) {
                    $type = 'play_arrow';
                    $vid = true;
                } else {
                    if (inarray($entry, $images)) {
                        $type = 'image';
                    } else {
                        if (inarray($entry, $pdfs)) {
                            $type = 'picture_as_pdf';
                        } else {
                            if (inarray($entry, $subs)) {
                                $type = 'subtitles';
                            }
                        }
                    }
                }
                if ($vid) {
                    $con = '<a id="caca" href="' . $url_target . '"><span class="title">' . $entry . '</span>
							      </a><p>' . $file_size . '</p>';
                } else {
                    $con = '<span id="caca2" class="title">' . $entry . '</span>
							      <p>' . $file_size . '</p>';
                }
                $text = '<li class="ellipsis collection-item avatar">
							      <i class="material-icons circle red">' . $type . '</i>' . $con . '<a download href="' . $url . '" class="secondary-content"><i class="material-icons">file_download</i></a>
							    </li>';
Exemple #4
0
function sidebar($o)
{
    if ($o['disable_in_mms'] !== false) {
        if ($_GET['mms'] == 'X') {
            return array();
        }
    }
    //set a few variables I'll use to 0 or blank or their default correct size
    global $sidebar_left;
    global $sidebar_right;
    $left_pull = '';
    $main_push = '';
    $main_size = 12;
    $eh_class = '';
    $eh_group = '';
    //Set up Equal Heights if need be
    $accepted_ehl_types = array('interger', 'double');
    if ($equal_height != '') {
        if ($o['equal_height_group'] == '') {
            $error .= 'Please give the sidebar function an equal height group, or disable equal height.<br />';
        }
        //Make sure EHL is a number.  If it is, set it.  If not, set it to 990px
        if (gettype(!inarray(gettype($o['equal_height_limit'])), $accepted_ehl_types)) {
            $equal_height = '990';
        } else {
            $equal_height = $o['equal_height_limit'];
        }
        $equal_height_class = ' equal-height ';
        $equal_height_group = ' data-group="' . $equal_height_group . '" data-to="' . $equal_height . '" ';
    }
    //set sizes of sidebars back to zero if the sidebar does not exist for the current page, then set main size
    if ($sidebar_left == '0') {
        $left_size = 0;
    }
    if ($sidebar_right == '0') {
        $right_size = 0;
    }
    //Check for default sidebar.  If one exists and the left/right counterpart is blank, set the left/right data to point to the default sidebar
    //echo '<!-- oLS: '.$o['left_sidebar'].' | SL: '.$sidebar_left.' | oDSL: '.$o['default_sidebar_left'].' | oDSLS: '.$o['default_sidebar_left_source'].' -->';
    if ($o['left_sidebar'] == true && ($sidebar_left == '0' || $sidebar_right == '') && $o['default_sidebar_left'] == true) {
        $sidebar_left = $o['default_sidebar_left_source'];
        //echo '<!-- here! -->';
    }
    if ($o['right_sidebar'] == true && ($sidebar_right == '0' || $sidebar_right == '') && $o['default_sidebar_right'] == true) {
        $sidebar_right = $o['default_sidebar_right_source'];
    }
    //Check for pixel/percentage size vs column size, set main_size based on columns or percentages, create sidebar
    if ($o['left_sidebar'] == true && $sidebar_left != '0') {
        if (strlen($o['left_sidebar_columns']) > 0) {
            $left_size_c = 'col-md-' . $o['left_sidebar_columns'];
            $main_size = 12;
        } elseif (strlen($o['left_sidebar_size']) > 0) {
            $left_size_p = $o['left_sidebar_percent'];
            $left_size_c = '';
            $main_size = 100;
        } else {
            $error .= "Please set a size for the left sidebar.<br />";
        }
        $SBL = file_get_contents($sidebar_left);
        echo '<!-- SBL: ' . $sidebar_left . ' oSBL: ' . $o['default_sidebar_left_source'] . ' -->';
        $sb_left = '<div id="sidebar-left" ' . $left_size_p . ' class="' . $left_size_c . ' ' . $left_pull . ' ' . $equal_height_class . ' ' . $o['left_adtl_classes'] . ' user" ' . $eh_group . '>' . $SBL . '</div>';
    }
    if ($o['right_sidebar'] == true && $sidebar_right != '0') {
        if (strlen($o['right_sidebar_columns']) > 0) {
            $right_size_c = 'col-md-' . $o['right_sidebar_columns'];
            $main_size = 12;
        } elseif (strlen($o['left_sidebar_size']) > 0) {
            $right_size_p = $o['left_sidebar_percent'];
            $right_size_c = '';
            $main_size = 100;
        } else {
            $error .= "Please set a width for the right sidebar.<br />";
        }
        $SBR = file_get_contents($sidebar_right);
        echo '<!-- SBR: ' . $sidebar_right . ' oSBR: ' . $o['default_sidebar_right_source'] . ' -->';
        $sb_right = '<div id="sidebar-right" ' . $right_size_p . ' class="' . $right_size_c . ' ' . $right_pull . ' ' . $equal_height_class . ' ' . $o['right_adtl_classes'] . ' user" ' . $eh_group . '>' . $SBR . '</div>';
    }
    echo '<!-- here -->';
    //Do the math and set the main size
    $main_size = $main_size - $left_size - $right_size;
    if ($o['left_sidebar_columns'] != '' || $o['right_sidebar_columns'] != '') {
        $main_size_c = 'col-md-' . $main_size;
        $main_size_p = '';
    } else {
        $main_size_c = '';
        $main_size_p = ' width="' . $main_size . '%" ';
    }
    //create Main div with push and correct size if need be
    $main_div = '<div ' . $main_size_p . ' class="' . $main_size_c . ' main-col ' . $main_push . ' ' . $eh_class . '" ' . $eh_group . ' >';
    //set the return and return it
    $return = array('left' => $sb_left, 'right' => $sb_right, 'main_size' => $main_size, 'left_size' => $left_size, 'right_size' => $right_size, 'main' => $main_div);
    if ($error == '') {
        return $return;
    } else {
        echo $error;
    }
}
                 $changes[] = " ADD {$field} " . $create_def[$table][$field];
             } else {
                 $changes[] = " CHANGE {$oldfield} {$field} " . $create_def[$table][$field];
             }
         }
         $alter_sql .= join(',', $changes);
         unset($changes);
         unset($current_fields);
         $sql = "SHOW INDEX \n\t\t\t\t\tFROM {$table}";
         $result = query($sql, "Couldn't get list of indices for table {$table}");
         unset($indices);
         while ($row = $db->sql_fetchrow($result)) {
             $indices[] = $row['Key_name'];
         }
         while (list($key_name, $key_field) = each($key_def[$table])) {
             if (!inarray($key_name, $indices)) {
                 $alter_sql .= $key_name == 'PRIMARY' ? ", ADD PRIMARY KEY ({$key_field})" : ", ADD INDEX {$key_name} ({$key_field})";
             }
         }
         query($alter_sql, "Couldn't alter table {$table}");
         print "<span class=\"ok\"><b>OK</b></span><br />\n";
         flush();
     }
     end_step('convert_forums');
 case 'convert_forums':
     $sql = "SELECT * \n\t\t\t\tFROM " . FORUMS_TABLE;
     $result = query($sql, "Couldn't get list with all forums");
     while ($row = $db->sql_fetchrow($result)) {
         print " * Converting forum '" . $row['forum_name'] . "' :: ";
         flush();
         // forum_access: (only concerns posting)
Exemple #6
0
<?php

session_start();
ob_start();
if (!isset($_SESSION["user_id"])) {
    header("Location:/login/");
}
if (!isset($_GET["edit"])) {
    if (!inarray($_GET["edit"], array("profile", "payment"))) {
        header("Location:/user/info");
    }
}
require_once "../../inc/config.php";
require_once ROOT_PATH . "inc/database.php";
$user = getUser($_SESSION["user_id"]);
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (password_verify($_POST["old_password"], $user["password"])) {
        // process the form
        if ($_GET["edit"] == "profile") {
            // process the profile information update
            if (empty($_POST["new_password"])) {
                $password = false;
            } else {
                $password = password_hash($_POST["new_password"], PASSWORD_DEFAULT);
            }
            $update = updateUser($user["user_id"], $_POST["fname"], $_POST["lname"], $_POST["email"], $_POST["add1"], $_POST["add2"], $_POST["city"], $_POST["state"], $_POST["zip"], $password);
            if ($update) {
                $_SESSION["profile-updated"] = true;
            }
            header("Location:/user/info/");
        } elseif ($_GET["edit"] == "payment") {
Exemple #7
0
<?php

$xml = domxml_open_file("../xml/keywords.xml");
$root = $xml->root();
$keywordList = split(",", "XML, HTML");
print_r($keywordList);
if (count($keywordList) > 0) {
    foreach ($keywordList as $kw) {
        $node_array = $root->get_elements_by_tagname("keyword");
        for ($i = 0; $i < count($node_array); $i++) {
            $node = $node_array[$i];
            if (inarray($node->get_attribute("term"), $keywordList)) {
            }
        }
    }
}
function extractText($array)
{
    if (count($array) <= 1) {
        //we only have one tag to process!
        for ($i = 0; $i < count($array); $i++) {
            $node = $array[$i];
            $value = $node->get_content();
        }
        return $value;
    }
}