function module_db_add_field($field_table, $field_name, $field_type, $field_length, $field_attributes, $field_null, $field_default)
{
    //field_table = the table the field will go into, without the prefix, users, comments, votes etc
    //field_name = the name of the field
    //field_type = varchar, text, int etc...
    //field_length = length of the field
    //field_attributes = unsigned etc...
    //field_null = 0=not null, 1=null
    //field_default = default value
    global $db;
    if ($field_table == 'users') {
        $field_table = table_users;
    }
    $fieldexists = checkforfield($field_name, $field_table);
    if (!$fieldexists) {
        $sql = 'ALTER TABLE `' . $field_table . '` ADD `' . $field_name . '` ' . $field_type;
        if ($field_length != '') {
            $sql .= '(' . $field_length . ')';
        }
        if ($field_attributes != '') {
            $sql .= ' ' . $field_attributes;
        }
        if ($field_null == 0) {
            $sql .= ' not null';
        } else {
            $sql .= ' null';
        }
        if ($field_default != '') {
            $sql .= " default '" . $field_default . "'";
        }
        //echo $sql . '<br>';
        $db->query($sql);
    }
}
Пример #2
0
 $fieldexists = checkforfield('category_author_level', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `category_author_level` enum('normal','moderator','admin') NOT NULL default 'normal';";
     $db->query($sql);
 }
 $fieldexists = checkforfield('category_author_group', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `category_author_group` VARCHAR(255) NOT NULL default '';";
     $db->query($sql);
 }
 $fieldexists = checkforfield('category_votes', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `category_votes` VARCHAR(4) NOT NULL default '';";
     $db->query($sql);
 }
 $fieldexists = checkforfield('category_karma', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `category_karma` VARCHAR(4) NOT NULL default '';";
     $db->query($sql);
 }
 $sql = "DELETE FROM " . table_config . " WHERE var_name='enable_show_last_visit'";
 $db->query($sql);
 $sql = "DELETE FROM `" . table_config . "` WHERE `var_name` = 'StorySummary_ContentTruncate';";
 $db->query($sql);
 // Change the default template value to Bootstrap
 $sql = "UPDATE `" . table_config . "` SET `var_defaultvalue` = 'bootstrap' WHERE `var_name` = '{$thetemp}';";
 $db->query($sql);
 // Delete Pageviews and Captcha
 $sql = "DELETE FROM `" . table_config . "` WHERE `var_name` = 'PageViews';";
 $db->query($sql);
 $sql = "DELETE FROM `" . table_config . "` WHERE `var_page` = 'Captcha';";
Пример #3
0
            break;
        case 'voted':
            $sql = "SELECT DISTINCT * FROM " . table_links . ", " . table_votes . " WHERE vote_user_id={$userid} AND vote_link_id=link_id AND vote_value > 0  AND (link_status='published' OR link_status='new') ORDER BY link_date DESC LIMIT {$start_up}, {$page_size}";
            $load_page = 1;
            break;
        case 'upvoted':
            $sql = "SELECT DISTINCT * FROM " . table_links . ", " . table_votes . " WHERE vote_user_id={$userid} AND vote_link_id=link_id AND vote_value > 0  AND (link_status='published' OR link_status='new') ORDER BY link_votes DESC LIMIT {$start_up}, {$page_size}";
            $load_page = 1;
            break;
        case 'downvoted':
            $sql = "SELECT DISTINCT * FROM " . table_links . ", " . table_votes . " WHERE vote_user_id={$userid} AND vote_link_id=link_id AND vote_value < 0  AND (link_status='published' OR link_status='new') ORDER BY link_votes ASC LIMIT {$start_up}, {$page_size}";
            $load_page = 1;
            break;
        case 'saved':
            $load_page = 1;
            $fieldexists = checkforfield('saved_privacy', table_saved_links);
            if ($fieldexists) {
                if ($curuserid == $userid) {
                    $sql = "SELECT " . table_links . ".* FROM " . table_saved_links . " \r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . table_links . " ON saved_link_id=link_id\r\n\t\t\t\t\t\t\t\t\tWHERE saved_user_id={$userid} ORDER BY saved_link_id DESC LIMIT {$start_up},{$page_size}";
                } else {
                    $sql = "SELECT " . table_links . ".* FROM " . table_saved_links . " \r\n\t\t\t\t\t\t\t\t\tLEFT JOIN " . table_links . " ON saved_link_id=link_id\r\n\t\t\t\t\t\t\t\t\tWHERE saved_user_id={$userid} and saved_privacy = 'public' ORDER BY saved_link_id DESC LIMIT {$start_up},{$page_size}";
                }
            } else {
                $sql = "SELECT " . table_links . ".* FROM " . table_saved_links . " \r\n\t\t\t\t\t\t\t\tLEFT JOIN " . table_links . " ON saved_link_id=link_id\r\n\t\t\t\t\t\t\t\tWHERE saved_user_id={$userid} ORDER BY saved_link_id DESC LIMIT {$start_up},{$page_size}";
            }
            break;
    }
    $linksum_sql = $sql;
} else {
    if ($page_name == "index" || $page_name == "new" || $page_name == "published") {
        $linksum_sql = $search->sql;
Пример #4
0
function do_stories()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size, $current_user, $cached_links;
    //if ($current_user->user_id == $user->id)
    //{
    $output = '';
    $link = new Link();
    $rows = $db->get_var("SELECT count(*) FROM " . table_saved_links . " WHERE saved_user_id={$user->id}");
    $fieldexists = checkforfield('saved_privacy', table_saved_links);
    if ($fieldexists) {
        if ($current_user->user_id == $user->id) {
            $links = $db->get_results("SELECT * FROM " . table_saved_links . " \r\n\t\t\t\t\t\t\t\tLEFT JOIN " . table_links . " ON saved_link_id=link_id\r\n\t\t\t\t\t\t\t\tWHERE saved_user_id={$user->id} ORDER BY saved_link_id DESC LIMIT {$offset},{$page_size}");
        } else {
            $links = $db->get_results("SELECT * FROM " . table_saved_links . " \r\n\t\t\t\t\t\t\t\tLEFT JOIN " . table_links . " ON saved_link_id=link_id\r\n\t\t\t\t\t\t\t\tWHERE saved_user_id={$user->id} and saved_privacy = 'public' ORDER BY saved_link_id DESC LIMIT {$offset},{$page_size}");
        }
    } else {
        $links = $db->get_results("SELECT * FROM " . table_saved_links . " \r\n\t\t\t\t\t\t\tLEFT JOIN " . table_links . " ON saved_link_id=link_id\r\n\t\t\t\t\t\t\tWHERE saved_user_id={$user->id} ORDER BY saved_link_id DESC LIMIT {$offset},{$page_size}");
    }
    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
            //$output.= $current_user->user_id."<br/>";
            //$output.= $user->id."<br/>";
            $output .= $link->print_summary('summary', true);
        }
    }
    $main_smarty->assign('user_page', $output);
    //}
}
Пример #5
0
 $fieldexists = checkforfield('lft', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `lft` int(11) NOT NULL";
     $db->query($sql);
 }
 $fieldexists = checkforfield('category_enabled', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `category_enabled` int(11) NOT NULL default '1'";
     $db->query($sql);
 }
 $fieldexists = checkforfield('category_order', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `category_order` int(11) NOT NULL default '0'";
     $db->query($sql);
 }
 $fieldexists = checkforfield('category_color', table_categories);
 if (!$fieldexists) {
     $sql = "ALTER TABLE `" . table_categories . "` ADD `category_color` varchar(6) default '000000'";
     $db->query($sql);
     $sql = "ALTER TABLE `" . table_categories . "` DROP INDEX `category_lang`";
     $db->query($sql);
     $sql = "ALTER TABLE `" . table_categories . "` ADD UNIQUE `key` (`category_name`)";
     $db->query($sql);
     $sql = "INSERT INTO `" . table_categories . "` VALUES (0, '" . $dblang . "', 0, 0, 'all', 'all', 0, 0, 2, 0, '000000');";
     $db->query($sql);
     $sql = "UPDATE `" . table_categories . "` SET `category__auto_id` = '0' WHERE `category_name` = 'all' LIMIT 1;";
     $db->query($sql);
 }
 include_once mnminclude . 'dbtree.php';
 rebuild_the_tree();
 ordernew();