Results 1 to 10 of 69

Thread: Saving a variable client-side (persistently)

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    ... connecting
    Join Date
    Mar 2017
    Location
    Manchester
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    you mean this ?
    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(host, user, pass, db, port);
        initAsyncMySQL(host, user, pass, db, port);
    }
    
    query(query)
    {
        if(!isDefined(level.JH_mysql))
            return undefined;
        result = mysql_query(level.JH_mysql, query);
        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_mysql, query);
        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(i = 0; i < rowcount; i++)
        {
            row = mysql_fetch_row(result);
            rows[rows.size] = [];
            for(j = 0; j < fields.size; j++)
                rows[rows.size - 1][fields[j]] = row[j];
        }
        mysql_free_result(result);
        return rows;
    }
    
    asyncQuery(query, function, args)
    {
        id = mysql_async_createQuery(query);
        task = spawnstruct();
        task.query = query;
        task.invoker = self;
        task.function = function;
        task.args = args;
        level.JH_mysqlAsync["" + id] = task;
    }
    
    asyncQueryNosave(query, function, args)
    {
        id = mysql_async_createQueryNosave(query);
        task = spawnstruct();
        task.query = query;
        task.invoker = self;
        task.function = function;
        task.args = args;
        level.JH_mysqlAsync["" + id] = task;
    }
    
    initAsyncMySQL(host, user, pass, db, port)
    {
        mysql_async_initializer(host, user, pass, db, port, 4);
        level.JH_mysqlAsync = [];
        thread loopAsyncMySQL();
    }
    
    loopAsyncMySQL()
    {
        while(true)
        {
            list = mysql_async_GetDoneList();
            for(i = 0; i < list.size; i++)
            {
                result = mysql_async_getResultAndFree(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]](rows, level.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(host, user, pass, db, port)
    {
        mysql = mysql_init();
        ret = mysql_real_connect(mysql, host, user, pass, db, port);
        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_mysql, string);
        return "";
    }
    and in my gametype gsc ive got
    Code:
    Callback_StartGameType()
    {
    	//MYSQL
    	maps\mp\gametypes\_mysql::init();
    shouldn't that be initializing it ?

    //////////////////////////////

    Ive got STD folder in main

    Heres My DB tables shouldnt be an issue
    Click image for larger version. 

Name:	mydb.png 
Views:	64 
Size:	51.8 KB 
ID:	1359

    i get this error
    Code:
    *****@ubuntu:~/cod2$ ./startserver.sh
    > [LIBCOD] Compiled for: CoD2 1.3
    > [LIBCOD] Compiled Aug  4 2017 18:22:39 using GCC 4.8.4
    > [PLUGIN LOADED]
    CoD2 MP 1.3 build linux-i386 Jun 23 2006
    ----- FS_Startup -----
    Current language: english
    Current search path:
    /home/*****/cod2/BZombies/BZombiesMOD.iwd (24 files)
    /home/*****/cod2/BZombies
    /home/*****/cod2/main/iw_15.iwd (85 files)
    /home/*****/cod2/main/iw_14.iwd (4038 files)
    /home/*****/cod2/main/iw_13.iwd (22624 files)
    /home/*****/cod2/main/iw_12.iwd (1016 files)
    /home/*****/cod2/main/iw_11.iwd (1462 files)
    /home/*****/cod2/main/iw_10.iwd (1936 files)
    /home/*****/cod2/main/iw_09.iwd (2142 files)
    /home/*****/cod2/main/iw_08.iwd (2723 files)
    /home/*****/cod2/main/iw_07.iwd (3384 files)
    /home/*****/cod2/main/iw_06.iwd (990 files)
    /home/*****/cod2/main/iw_05.iwd (928 files)
    /home/*****/cod2/main/iw_04.iwd (698 files)
    /home/*****/cod2/main/iw_03.iwd (26 files)
    /home/*****/cod2/main/iw_02.iwd (40 files)
    /home/*****/cod2/main/iw_01.iwd (16 files)
    /home/*****/cod2/main/iw_00.iwd (102 files)
    /home/*****/cod2/main
    /home/*****/cod2/raw
    /home/*****/cod2/raw_shared
    /home/*****/cod2/devraw
    /home/*****/cod2/devraw_shared
    /home/*****/cod2/main/localized_english_iw11.iwd (1 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw10.iwd (414 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw09.iwd (98 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw08.iwd (8 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw07.iwd (1014 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw06.iwd (3110 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw05.iwd (5310 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw04.iwd (6240 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw03.iwd (6580 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw02.iwd (6404 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw01.iwd (5510 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw00.iwd (4764 files)
        localized assets iwd file for english
    
    File Handles:
    ----------------------
    81687 files in iwd files
    execing default_mp.cfg
    couldn't exec language.cfg
    execing config_mp_server.cfg
    fs_homepath is write protected.
    fs_game is write protected.
    fs_basepath is write protected.
    Opening IP socket: localhost:28960
    Hostname: ubuntu
    IP: 127.0.1.1
    --- Common Initialization Complete ---
    fs_homepath is write protected.
    fs_game is write protected.
    net_port is write protected.
    fs_basepath is write protected.
    execing BZombiesServer.cfg
    couldn't exec mysql.cfg
    sv_cheats is write protected.
    net_ip is write protected.
    net_port is write protected.
    '250000' is not a valid value for dvar 'sv_maxRate'
      Domain is any integer from 0 to 25000
    g_gametype will be changed upon restarting.
    execing zombi3s.cfg
    map_rotate...
    
    "sv_mapRotation" is:"gametype zom map mp_carentan"
    
    "sv_mapRotationCurrent" is:""
    
    Setting g_gametype: zom.
    Setting map: mp_carentan.
    ------ Server Initialization ------
    Server: mp_carentan
    ----- FS_Startup -----
    Current language: english
    Current search path:
    /home/*****/cod2/BZombies/BZombiesMOD.iwd (24 files)
    /home/*****/cod2/BZombies
    /home/*****/cod2/main/iw_15.iwd (85 files)
    /home/*****/cod2/main/iw_14.iwd (4038 files)
    /home/*****/cod2/main/iw_13.iwd (22624 files)
    /home/*****/cod2/main/iw_12.iwd (1016 files)
    /home/*****/cod2/main/iw_11.iwd (1462 files)
    /home/*****/cod2/main/iw_10.iwd (1936 files)
    /home/*****/cod2/main/iw_09.iwd (2142 files)
    /home/*****/cod2/main/iw_08.iwd (2723 files)
    /home/*****/cod2/main/iw_07.iwd (3384 files)
    /home/*****/cod2/main/iw_06.iwd (990 files)
    /home/*****/cod2/main/iw_05.iwd (928 files)
    /home/*****/cod2/main/iw_04.iwd (698 files)
    /home/*****/cod2/main/iw_03.iwd (26 files)
    /home/*****/cod2/main/iw_02.iwd (40 files)
    /home/*****/cod2/main/iw_01.iwd (16 files)
    /home/*****/cod2/main/iw_00.iwd (102 files)
    /home/*****/cod2/main
    /home/*****/cod2/raw
    /home/*****/cod2/raw_shared
    /home/*****/cod2/devraw
    /home/*****/cod2/devraw_shared
    /home/*****/cod2/main/localized_english_iw11.iwd (1 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw10.iwd (414 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw09.iwd (98 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw08.iwd (8 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw07.iwd (1014 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw06.iwd (3110 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw05.iwd (5310 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw04.iwd (6240 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw03.iwd (6580 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw02.iwd (6404 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw01.iwd (5510 files)
        localized assets iwd file for english
    /home/*****/cod2/main/localized_english_iw00.iwd (4764 files)
        localized assets iwd file for english
    
    File Handles:
    ----------------------
    81687 files in iwd files
    ------- Game Initialization -------
    gamename: Call of Duty 2
    gamedate: Jun 23 2006
    
    ******* script compile error *******
    uninitialised variable 'port'
    ************************************
    Sys_Error: Error during initialization:
    script compile error
    (see console for details)
    
    > [PLUGIN UNLOADED]
    *****@ubuntu:~/cod2$
    if i change port to 3306 , it just shows uninitialised variable '3306' as so on
    Last edited by box3r; 5th August 2017 at 06:01.

Posting Permissions

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