function SplitCVS(CVSLine, splitter) {
    var result_array = new Array();
    var cnt;
    var is_start = false;
    var str_tmp = '';
    var fld = false;

    for(var i=0; i<CVSLine.length; i++) {
        if(CVSLine.charCodeAt(i) == 34) {       // the " char
            if(fld){
                result_array.length++;
                result_array[result_array.length-1] = str_tmp;
                str_tmp = '';
            }
            fld = !fld;
        } else {
            if(fld) str_tmp += CVSLine.substr(i,1);
        }
    }

    return result_array;
}


/*
function SplitCVS(CVSLine, splitter) {
    var result_array = new Array();
    var cnt;
    var is_start = false;
    var str_tmp = '';
    for(var i=0; i<CVSLine.length; i++) {
        if(CVSLine.charCodeAt(i) == 34) !fld;
        if(CVSLine.charAt(i) == splitter){
            result_array.length++;
            result_array[result_array.length-1] = str_tmp;
            str_tmp = '';
        } else {
            if(CVSLine.charCodeAt(i) != 34){        // the " char
                str_tmp += CVSLine.substr(i,1);
            }
        }
    }
    result_array.length++;
    result_array[result_array.length-1] = str_tmp;
    return result_array;
}
*/

function DBFactory() {
    this.tbl_faq = new Array();
    this.tbl_domain = new Array();
    this.tbl_users = new Array();
    this.tbl_rank = new Array();

    this.init = false;
}

DBFactory.prototype.InitDBTables = function() {
    if(this.init) return;
    this.init = true;
    this.file_faq = X_table_faq;
    this.file_domain = X_table_domain;
    this.file_rank = X_table_rank;
//  this.file_users = 'users.csv';
    this.count_line_faq = 0;
    this.count_line_domain = 0;
    var file_obj;
    var default_ranks;

    this.CSVObj = Server.CreateObject("Scripting.FileSystemObject");

    if(this.CSVObj.FileExists(Server.MapPath(this.file_faq))) {
        this.FileObject = this.CSVObj.OpenTextFile(Server.MapPath(this.file_faq));
        while(!this.FileObject.AtEndOfStream) {
            this.CSVLine = this.FileObject.readline();
            if(trim(this.CSVLine) != '') {
              this.tbl_faq.length++;
              this.tbl_faq[this.tbl_faq.length-1] = SplitCVS(this.CSVLine, ';');
            }
        }
        this.FileObject.Close();
    } else {
        try {
            file_obj = this.CSVObj.CreateTextFile(Server.MapPath(this.file_faq),false);
            file_obj.Close();
        } catch(e) {
            return throwError('500');
        }
    }

    if(this.CSVObj.FileExists(Server.MapPath(this.file_domain))) {
        this.FileObject = this.CSVObj.OpenTextFile(Server.MapPath(this.file_domain));
        while(!this.FileObject.AtEndOfStream) {
            this.CSVLine = this.FileObject.readline();
            if(trim(this.CSVLine) != '') {
              this.tbl_domain.length++;
              this.tbl_domain[this.tbl_domain.length-1] = SplitCVS(this.CSVLine, ';');
            }
        }
        this.FileObject.Close();
    } else {
        try {
            file_obj = this.CSVObj.CreateTextFile(Server.MapPath(this.file_domain),false);
            file_obj.Close();
        } catch(e) {
            return throwError('500');
        }
    }

    if(this.CSVObj.FileExists(Server.MapPath(this.file_rank))) {
        this.FileObject = this.CSVObj.OpenTextFile(Server.MapPath(this.file_rank));
        while(!this.FileObject.AtEndOfStream) {
            this.CSVLine = this.FileObject.readline();
            if(trim(this.CSVLine) != '') {
              this.tbl_rank.length++;
              this.tbl_rank[this.tbl_rank.length-1] = SplitCVS(this.CSVLine, ';');
            }
        }
        this.FileObject.Close();
    } else {
        try {
            file_obj = this.CSVObj.CreateTextFile(Server.MapPath(this.file_rank),false);
            default_ranks = '"4";"Very Good"'+ '\r\n';
            default_ranks += '"3";"Good"'+ '\r\n';
            default_ranks += '"2";"Quite"'+ '\r\n';
            default_ranks += '"1";"Slightly"';
            file_obj.WriteLine(default_ranks);
            file_obj.Close();
        } catch(e) {
            return throwError('500');
        }
    }
}

DBFactory.prototype.GetNextID = function(array_name) {
    var max_id = new Number(0);
    var cur_id;
    var array_obj = eval('this.tbl_' + array_name);
    for(var i=0; i<array_obj.length; i++){
        cur_id = new Number(array_obj[i][0]);
        if(cur_id > max_id) max_id = cur_id;
    }
    max_id=max_id+1;
    return max_id;
}

DBFactory.prototype.WriteCSVFile = function(array_name) {
    var line_out = '';
    var file_obj;
    var array_obj = new Array();
    var rank_array0;
    var rank_array1;
//  var file_name = array_name + '.csv';
//  var file_name = eval('X_table_' + array_name);
    var file_name = '';

    var make_change = true;

    if(array_name == 'rank'){
        file_name = X_table_rank;
    }
    if(array_name == 'domain'){
        file_name = X_table_domain;
    }
    if(array_name == 'faq'){
        file_name = X_table_faq;
    }

    array_obj = eval('this.tbl_' + array_name);

    if(array_name == 'rank'){
        rank_array = new Array(array_obj.length);
        while(make_change){
            make_change = false;
            for(var i=0; i<array_obj.length-1; i++){
                if(array_obj[i][0] < array_obj[i+1][0]) {
                    rank_array0 = array_obj[i][0];
                    rank_array1 = array_obj[i][1];
                    array_obj[i][0] = array_obj[i+1][0];
                    array_obj[i][1] = array_obj[i+1][1];
                    array_obj[i+1][0] = rank_array0;
                    array_obj[i+1][1] = rank_array1;
                    make_change = true;
                }
            }
        }
    }

    try {
        if(this.CSVObj.FileExists(Server.MapPath(file_name))) this.CSVObj.DeleteFile(Server.MapPath(file_name));

        file_obj = this.CSVObj.CreateTextFile(Server.MapPath(file_name),false);

        for(var i=0; i<array_obj.length; i++){
            line_out = '';
            for(var j=0; j<array_obj[i].length; j++){
                if(j > 0) line_out += ';';
                line_out += '"'+array_obj[i][j]+'"';
            }
            file_obj.WriteLine(line_out);
        }
        file_obj.Close();
    } catch(e) {
        return throwError('500');
    }
}

// Rank table
DBFactory.prototype.GetRankName = function(id_rank) {
    var result = '';
    for(var i=0; i<this.tbl_rank.length; i++){
        if(this.tbl_rank[i][0] == id_rank){
            result = this.tbl_rank[i][1];
            break;
        }
    }
    return result;
}


DBFactory.prototype.GetRankItems = function() {
    var result = new Array();
    for(var i=0; i<this.tbl_rank.length; i++){
        result.length++;
        result[i] = this.tbl_rank[i][0];
    }

    return result;
}

DBFactory.prototype.DeleteRankItem = function(id_rank) {
    var result = new Array();
    for(var i=0; i<this.tbl_rank.length; i++){
        if(this.tbl_rank[i][0] != id_rank){
            result.length++;
            result[result.length-1] = this.tbl_rank[i];
        }
    }
    this.tbl_rank = result;
    this.WriteCSVFile('rank');
}

DBFactory.prototype.SetRankItem = function(id_rank, rank_name) {
    for (var i=0; i<this.tbl_rank.length; i++){
        if (this.tbl_rank[i][0] == id_rank){
            this.tbl_rank[i][1] = rank_name;
            break;
        }
    }
    this.WriteCSVFile('rank');
}

DBFactory.prototype.AddRankItem = function(id_rank, rank_name) {
    this.tbl_rank[ this.tbl_rank.length ] = new Array(2);
    this.tbl_rank[this.tbl_rank.length - 1][0] = id_rank;
    this.tbl_rank[this.tbl_rank.length - 1][1] = rank_name;
    this.WriteCSVFile('rank');
}


// Domains table
DBFactory.prototype.GetDomainName = function(id_domain) {
    var result = '';
    for(var i=0; i<this.tbl_domain.length; i++){
        if(this.tbl_domain[i][0] == id_domain){
            result = this.tbl_domain[i][1];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetDomainDescription = function(id_domain) {
    var result = '';
    for(var i=0; i<this.tbl_domain.length; i++){
        if(this.tbl_domain[i][0] == id_domain){
            result = this.tbl_domain[i][2];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetDomainItems = function() {
    var result = new Array();
    for(var i=0; i<this.tbl_domain.length; i++){
        result.length++;
        result[i] = this.tbl_domain[i][0];
    }

    return result;
}

DBFactory.prototype.DeleteDomainItem = function(id_domain) {
    var result = new Array();
    for(var i=0; i<this.tbl_domain.length; i++){
        if(this.tbl_domain[i][0] != id_domain){
            result.length++;
            result[result.length-1] = this.tbl_domain[i];
        }
    }
    this.tbl_domain = result;
    this.WriteCSVFile('domain');
}

DBFactory.prototype.SetDomainItem = function(id_domain, domain_name, domain_description) {
    for(var i=0; i<this.tbl_domain.length; i++){
        if(this.tbl_domain[i][0] == id_domain){
            this.tbl_domain[i][1] = domain_name;
            this.tbl_domain[i][2] = domain_description;
            break;
        }
    }
    this.WriteCSVFile('domain');
}

DBFactory.prototype.AddDomainItem = function(domain_name, domain_description) {
    this.tbl_domain[ this.tbl_domain.length ] = new Array(3);
    this.tbl_domain[this.tbl_domain.length - 1][0] = this.GetNextID('domain');
    this.tbl_domain[this.tbl_domain.length - 1][1] = domain_name;
    this.tbl_domain[this.tbl_domain.length - 1][2] = domain_description;
    this.WriteCSVFile('domain');
}


// Users table
DBFactory.prototype.GetUserName = function(id_user) {
    var result = '';
    for(var i=0; i<this.tbl_users.length; i++){
        if(this.tbl_users[i][0] == id_user){
            result = this.tbl_users[i][1];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetUserType = function(id_user) {
    var result = '';
    for(var i=0; i<this.tbl_users.length; i++){
        if(this.tbl_users[i][0] == id_user){
            result = this.tbl_users[i][3];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetUserID = function(user_name, passwd) {
    var result = '-1';
    for(var i=0; i<this.tbl_users.length; i++){
        if(this.tbl_users[i][1] == user_name && this.tbl_users[i][2] == passwd){
            result = this.tbl_users[i][0];
            break;
        }
    }
    return result;
}


// FAQ table
DBFactory.prototype.GetFAQItems = function(start_page, page_size, str_where, order_by) {
    var result = new Array();
    var result2 = new Array();
    var reg_expression;
    var start_indx;
    var stop_indx;
    //var reg_expression_exec;
    var i;

    if(str_where.length > 0) {
        str_where = this.BuildRegExp(str_where);
                
        reg_expression = new RegExp(str_where, "ig");
    }

    for(i=0; i<this.tbl_faq.length; i++){
        if(str_where.length > 0) {
            var str_to_search = this.tbl_faq[i][2] + this.tbl_faq[i][4];
            var reg_expression_exec = str_to_search.match(reg_expression);
        } else {
            var reg_expression_exec = '';
        }

        if(reg_expression_exec != null) {
            result.length++;
            result[result.length-1] = this.tbl_faq[i][0];
        }
    }

    if(start_page > 0 && page_size > 0) {
        start_indx = (start_page - 1)*page_size;
        stop_indx = start_indx + (page_size - 1);
    } else {
        start_indx = 0;
        stop_indx = result.length - 1;
    }
    for(i=start_indx; (i<=stop_indx && i<result.length); i++) {
        result2.length++;
        result2[result2.length-1] = result[i];
    }

    return result2;
}

DBFactory.prototype.GetFAQItemsByDomain = function(start_page, page_size, id_domain, str_where, order_by) {
    var result = new Array();
    var result2 = new Array();
    var reg_expression;
    //var reg_expression_exec;
    var start_indx=new Number();
    var stop_indx=new Number();
    var i;

    if(str_where.length > 0) {
        str_where = this.BuildRegExp(str_where);
       
        reg_expression = new RegExp(str_where,'i');
    }

    for(i=0; i<this.tbl_faq.length; i++){
        if(str_where.length > 0) {
            var str_to_search = this.tbl_faq[i][2] + this.tbl_faq[i][4];
            var reg_expression_exec = str_to_search.match(reg_expression);
        } else {
            var reg_expression_exec = '';
        }

        if(this.tbl_faq[i][1] == id_domain && reg_expression_exec != null) {
            result.length++;
            result[result.length-1] = this.tbl_faq[i][0];
        }
    }

    if(start_page > 0 && page_size > 0) {
        start_indx = (start_page - 1)*page_size;
        stop_indx = start_indx + (page_size - 1);
    } else {
        start_indx = 0;
        stop_indx = result.length - 1;
    }
    for(i=start_indx; (i<=stop_indx && i<result.length); i++) {
        result2.length++;
        result2[result2.length-1] = result[i];
    }

    return result2;
}

DBFactory.prototype.GetDomainFAQCount = function(id_domain, str_where) {
    var result = 0;
    var reg_expression;
    var reg_expression_exec;

    if(str_where == null) str_where = '';
    if(str_where.length > 0) {
        str_where = this.BuildRegExp(str_where);
        reg_expression = new RegExp(str_where,'i');
    }
    for(var i=0; i<this.tbl_faq.length; i++){
        if(str_where.length > 0) {
            var str_to_search = this.tbl_faq[i][2] + this.tbl_faq[i][4];
            var reg_expression_exec = str_to_search.match(reg_expression);
        } else {
            var reg_expression_exec = '';
        }
        if(this.tbl_faq[i][1] == id_domain && reg_expression_exec != null) result++;
    }

    return result;
}

DBFactory.prototype.GetFAQCount = function(str_where) {
    var result = 0;
    var reg_expression;

    if(str_where.length > 0) {
        str_where = this.BuildRegExp(str_where);
        reg_expression = new RegExp(str_where,'i');
        for(var i=0; i<this.tbl_faq.length; i++){
            var str_to_search = this.tbl_faq[i][2] + this.tbl_faq[i][4];
            var reg_expression_exec = str_to_search.match(reg_expression);
            if(reg_expression_exec != null) result++;
        }
    } else result = this.tbl_faq.length;


    return result;
}

DBFactory.prototype.GetFAQQuestion = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][2];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetFAQDescription = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][3];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetFAQAnswer = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][4];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetFAQHits = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][7];
            break;
        }
    }
    if(result == null) result = '0';
    if(isNaN(result)) result = '0';
    if(result.length == 0) result = '0';
    return result;
}

DBFactory.prototype.GetFAQRank = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][6];
            break;
        }
    }
    if(result == null) result = '0';
    if(result.length == 0) result = '0';
    return result;
}

DBFactory.prototype.GetFAQUser = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][5];
            break;
        }
    }
    if(result == null) result = '0';
    if(result.length == 0) result = '0';
    return result;
}

DBFactory.prototype.GetFAQDate = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][8];
            break;
        }
    }
    return result;
}

DBFactory.prototype.GetFAQDomain = function(id_faq) {
    var result = '';
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            result = this.tbl_faq[i][1];
            break;
        }
    }
    if(result == null) result = '0';
    if(result.length == 0) result = '0';
    return result;
}

// add FAQ
DBFactory.prototype.AddFAQ = function() {
    var result;
    this.tbl_faq[this.tbl_faq.length] = new Array(9);
    result = this.GetNextID('faq');
    this.tbl_faq[this.tbl_faq.length - 1][0] = result;
    this.WriteCSVFile('faq');

    return result;
}

// SET functions
DBFactory.prototype.SetFAQQuestion = function(id_faq, question) {
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            this.tbl_faq[i][2] = question;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

DBFactory.prototype.SetFAQDescription = function(id_faq, description) {
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            this.tbl_faq[i][3] = description;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

DBFactory.prototype.SetFAQAnswer = function(id_faq, answer) {
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            this.tbl_faq[i][4] = answer;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

DBFactory.prototype.SetFAQHits = function(id_faq, hits) {
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            this.tbl_faq[i][7] = hits;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

DBFactory.prototype.SetFAQRank = function(id_faq, id_rank) {
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            this.tbl_faq[i][6] = id_rank;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

DBFactory.prototype.SetFAQUser = function(id_faq, id_user) {
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            this.tbl_faq[i][5] = id_user;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

DBFactory.prototype.SetFAQNowDate = function(id_faq) {
    var now_date = new Date();
    var now_format;
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            var luna = (now_date.getMonth()+1).toString();
            var ziua = now_date.getDate().toString();
            if(luna.length == 1) luna = '0' + luna;
            if(ziua.length == 1) ziua = '0' + ziua;
            //Response.Write(X_locale);
            now_format = luna + '/' + ziua + '/' + now_date.getFullYear();
            if( X_locale.substr(0,2) != 'en' && X_locale!='' ){
                now_format = ziua + '/' + luna + '/' + now_date.getFullYear();
            }
            this.tbl_faq[i][8] = now_format;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

DBFactory.prototype.SetFAQDomain = function(id_faq, id_domain) {
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] == id_faq){
            this.tbl_faq[i][1] = id_domain;
            break;
        }
    }
    this.WriteCSVFile('faq');
}

// DELETE functions
DBFactory.prototype.DeleteFAQItem = function(id_faq) {
    var result = new Array();
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][0] != id_faq){
            result.length++;
            result[result.length-1] = this.tbl_faq[i];
        }
    }
    this.tbl_faq = result;
    this.WriteCSVFile('faq');
}

DBFactory.prototype.DeleteFAQIemsByDomain = function(id_domain) {
    var result = new Array();
    for(var i=0; i<this.tbl_faq.length; i++){
        if(this.tbl_faq[i][1] != id_domain){
            result.length++;
            result[result.length-1] = this.tbl_faq[i];
        }
    }
    this.tbl_faq = result;
    this.WriteCSVFile('faq');
}

DBFactory.prototype.BuildRegExp = function(str_where) {
		while ( str_where.indexOf("\"") != -1 ) {
		    str_where = str_where.replace("\"","&quot;");
		}
		    
		while ( str_where.indexOf("<") != -1 ) {
		    str_where = str_where.replace("<","&lt;")
		}
		    
		while ( str_where.indexOf(">") != -1 ) {
		    str_where = str_where.replace(">","&gt;")
		}
        str_where = str_where.replace(/\\/ig, "\\\\");
        
        str_where = str_where.replace(/\*/ig, "\\*");
        str_where = str_where.replace(/\+/ig, "\\+");
        str_where = str_where.replace(/\|/ig, "\\|");
        
        str_where = str_where.replace(/\(/ig, "\\(");
        str_where = str_where.replace(/\)/ig, "\\)");
        str_where = str_where.replace(/\[/ig, "\\[");
        str_where = str_where.replace(/\?/ig, "\\?");
        str_where = str_where.replace(/\./ig, "\\.");
        
        return str_where;
}