// -----------------------------------------------------------------------------------
    // UCE_Load_WorldEvents
    // -----------------------------------------------------------------------------------
    public void UCE_Load_WorldEvents()
    {
#if _MYSQL && _SERVER
        var table = ExecuteReaderMySql("SELECT `name`, `count` FROM uce_worldevents");
        foreach (var row in table)
        {
            string name  = (string)row[0];
            int    count = (int)row[1];

            if (!string.IsNullOrWhiteSpace(name) && count != 0)
            {
                NetworkManagerMMO.UCE_SetWorldEventCount(name, count);
            }
        }
#elif _SQLITE && _SERVER
        var table = connection.Query <uce_worldevents>("SELECT `name`, `count` FROM uce_worldevents");
        foreach (var row in table)
        {
            string name  = row.name;
            int    count = row.count;

            if (!string.IsNullOrWhiteSpace(name) && count != 0)
            {
                NetworkManagerMMO.UCE_SetWorldEventCount(name, count);
            }
        }
#endif
    }
Example #2
0
    // -----------------------------------------------------------------------------------
    // UCE_Load_WorldEvents
    // -----------------------------------------------------------------------------------
    public void UCE_Load_WorldEvents()
    {
#if _MYSQL
        var table = ExecuteReaderMySql("SELECT `name`, `count` FROM uce_worldevents");
        foreach (var row in table)
        {
            string name  = (string)row[0];
            int    count = (int)row[1];

            if (!string.IsNullOrWhiteSpace(name) && count != 0)
            {
                NetworkManagerMMO.UCE_SetWorldEventCount(name, count);
            }
        }
#elif _SQLITE
        var table = ExecuteReader("SELECT `name`, `count` FROM uce_worldevents");
        foreach (var row in table)
        {
            string name  = (string)row[0];
            int    count = Convert.ToInt32((long)row[1]);

            if (!string.IsNullOrWhiteSpace(name) && count != 0)
            {
                NetworkManagerMMO.UCE_SetWorldEventCount(name, count);
            }
        }
#endif
    }
    // -----------------------------------------------------------------------------------
    // UCE_Load_WorldEvents
    // -----------------------------------------------------------------------------------
    public void UCE_Load_WorldEvents()
    {
        var table = connection.Query <worldevents>("SELECT `name`, `count` FROM uce_worldevents");

        foreach (var row in table)
        {
            string name  = row.name;
            int    count = row.count;

            if (!string.IsNullOrWhiteSpace(name) && count != 0)
            {
                NetworkManagerMMO.UCE_SetWorldEventCount(name, count);
            }
        }
    }