[draft]

Im having plugin that is storing a lot of events in file to cache them and send in one array at end of map. For example, it writes information about every frag (killer, victim, distance, headshot etc)
So, at the end of map Im reading the file with fgets and making a huge query
INSERT INTO (...) VALUES (file_line1),(file_line2) ...
But the problem is that the file can be huge and small depending on number of lines (line length is about 100 symbols) and i dont know how can i send this data with Sql_ThreadQuery?
For now, Ive created array[40000], read everything in that array, but sometimes its not enough big if game has a lots of frags but im pretty scared to make array of 1 million cells.
Im thinking of using dynamic array, but how can i send it fully as query[] in Sql_ThreadQuery?
native DoNotUse:ArrayGetStringHandle(Array:which, item); looks like will not work for my situation. Any ideas?

[Sylwester]

If you are sending it in plugin_end then use non-threaded queries. You don't need very big array, just keep adding file_lines until you run out of space, send the query and repeat.

Why are you storing it in a file? Can't you send it with SQL_ThreadQuery while the server is running?

[draft]

Originally Posted by Sylwester If you are sending it in plugin_end then use non-threaded queries. You don't need very big array, just keep adding file_lines until you run out of space, send the query and repeat.

Thanks for hint, i forgot about non-threaded query!

Why are you storing it in a file? Can't you send it with SQL_ThreadQuery while the server is running?

The thing is that this plugin works on about 200 game servers (and will be more) that are putting every event in one table making it hard-locked and working slowly + a lot of connects. Thats why i realized that better is to store all info locally in file and send it at the end of map.

[draft]

Again i dont know what to do.

PHP Code:

p_readfile = fopen(action_file, "r")
if(p_readfile)
{
    while(fgets(p_readfile, text, 127))
    {                    
        ArrayPushString(frag_query,text)
    }            
}
fclose(p_readfile)
        
Query = SQL_PrepareQuery(SqlConnection, "^nINSERT INTO mix_stats_action (time, mixid, userid, userid2, action, info, info2, floatinfo) \
VALUES %a", ArrayGetStringHandle(frag_query, item)) 


So, the thing is that I must somehow put all items , how it is possible to do?

[Sylwester]

like this:

PHP Code:

public function(){
    new fh = fopen(path, "rt")
    if(!fh || feof(fh)){
        log_amx("Could not open file or no data in file (%s)", path)
        return
    }
    new cache[2048], pos, text[128], len, error[256]

    do{
        len = fgets(fh, text, sizeof(text)-1)
        trim(text)
        
        if(pos+len+2 >= sizeof(cache)){
            pos = 0
            if(!SQL_SimpleQuery(SqlConnection, cache, error, sizeof(error)-1)){
                log_amx("SQL Error: %s", error)
            }
        }
        
        if(pos == 0){
            pos = formatex(cache, sizeof(cache)-1, "INSERT INTO mix_stats_action (time, mixid, userid, userid2, action, info, info2, floatinfo) VALUES %s", text)
        }else{
            pos += formatex(cache[pos], sizeof(cache)-pos-1, ", %s", text)
        }
    }while(!feof(fh))
    
    if(!SQL_SimpleQuery(SqlConnection, cache, error, sizeof(error)-1)){
        log_amx("SQL Error: %s", error)
    }
    
    fclose(fh)
}