Results 1 to 10 of 14

Thread: Register mysql problem

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    Private First Class
    Join Date
    Mar 2016
    Posts
    134
    Thanks
    48
    Thanked 11 Times in 10 Posts
    I granted to my user all rights.
    --

    my _mysql.gsc file:
    PHP Code:
    init() 

        
    //get your host, user, pass, db, port here 
        
    level.JH_mysql mysql_reuse_connection(); 
        if(!
    isDefined(level.JH_mysql)) 
            
    level.JH_mysql initMySQL("MYIP""USER""PW""COD"3306); 
        
    initAsyncMySQL("MYIP""USER""PW""COD"3306); 


    query(query

        if(!
    isDefined(level.JH_mysql)) 
            return 
    undefined
        
    result mysql_query(level.JH_mysqlquery); 
        
    resettimeout(); 
        if(
    result
        { 
            
    printf("Error in " query "\n"); 
            return 
    undefined
        } 
        
    result mysql_store_result(level.JH_mysql); 
        
    rows getRows(result); 
        return 
    rows


    queryNosave(query

        if(!
    isDefined(level.JH_mysql)) 
            return 
    undefined
        
    result mysql_query(level.JH_mysqlquery); 
        
    resettimeout(); 
        if(
    result
        { 
            
    printf("Error in " query "\n"); 
            return 
    undefined
        } 
        return []; 


    getRows(result

        if(!
    isDefined(result)) 
            return []; 
        
    rowcount mysql_num_rows(result); 
        
    fields = []; 
        
    field mysql_fetch_field(result); 
        while(
    isDefined(field)) 
        { 
            
    fields[fields.size] = field
            
    field mysql_fetch_field(result); 
        } 
        
    rows = []; 
        for(
    0rowcounti++) 
        { 
            
    row mysql_fetch_row(result); 
            
    rows[rows.size] = []; 
            for(
    0fields.sizej++) 
                
    rows[rows.size 1][fields[j]] = row[j]; 
        } 
        
    mysql_free_result(result); 
        return 
    rows


    asyncQuery(query, function, args

        
    printf("query: %\n"query);
        
    id mysql_async_create_Query(query); 
        
    task spawnstruct(); 
        
    task.query query
        
    task.invoker self
        
    task.function = function; 
        
    task.args args
        
    level.JH_mysqlAsync["" id] = task


    asyncQueryNosave(query, function, args

        
    printf("querynosave: %\n"query);
        
    id mysql_async_create_Query_Nosave(query); 
        
    task spawnstruct(); 
        
    task.query query
        
    task.invoker self
        
    task.function = function; 
        
    task.args args
        
    level.JH_mysqlAsync["" id] = task


    initAsyncMySQL(hostuserpassdbport

        
    mysql_async_initializer(hostuserpassdbport4); 
        
    level.JH_mysqlAsync = []; 
        
    thread loopAsyncMySQL(); 


    loopAsyncMySQL() 

        while(
    true
        { 
            list = 
    mysql_async_GetDone_List(); 
            for(
    0< list.sizei++) 
            { 
                
    result mysql_async_getresult_and_free(list[i]); 
                if(!
    isdefined(result)) 
                    continue; 
                if(
    result == 0
                    
    result undefined
                
    task "" + list[i]; 
                if(
    isDefined(level.JH_mysqlAsync[task])) 
                { 
                    if(
    isDefined(level.JH_mysqlAsync[task].function)) 
                    { 
                        if(
    isDefined(level.JH_mysqlAsync[task].invoker)) 
                        { 
                            
    rows getRows(result); 
                            
    level.JH_mysqlAsync[task].invoker thread [[level.JH_mysqlAsync[task].function]](rowslevel.JH_mysqlAsync[task].args); 
                        } 
                        else if(
    isDefined(result)) 
                            
    mysql_free_result(result); 
                    } 
                    else if(
    isDefined(result)) 
                        
    mysql_free_result(result); 
                } 
                else if(
    isDefined(result)) 
                    
    mysql_free_result(result); 
                
    level.JH_mysqlAsync[task] = undefined
            } 
            
    wait .05
        } 


    initMySQL(hostuserpassdbport

        
    mysql mysql_init(); 
        
    ret mysql_real_connect(mysqlhostuserpassdbport); 
        if(!
    ret
        { 
            
    printf("errno=" mysql_errno(mysql) + " error= " mysql_error(mysql) + "\n"); 
            
    mysql_close(mysql); 
            return 
    undefined
        } 
        return 
    mysql

    stripString(string) 

        if(
    isDefined(level.JH_mysql)) 
            return 
    mysql_real_escape_string(level.JH_mysqlstring); 
        return 
    ""

    Is that what you're looking for?

  2. The Following User Says Thank You to suck000 For This Useful Post:

    kubislav23 (16th April 2017)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •