CSstatsX SQL - Page 4

quLeryuzz · 06-25-2016 , 19:17 Re: CSstatsX SQL

I agree edg about server name, current players and others.. For example, I added killassist to CSstatsX for myself. Can you add killassist for the next version? Thank you.

My adding kill assist is Assists for Counter Strike 1.6 v2.1 By RuleBreaker

PHP Code:


			
public Ham_Killed_player(iVictim, iAttacker, shouldgib) {
    new i=0
    do {
        if(i!=iAttacker) {
            if(damage2[i][iVictim]>30) {
                assist(i, iVictim)
            }
        }
        i+=1
    } while (i<33)
    
}
public assist(attacker, victim) {
    damage2[attacker][victim]=0
    //assists[attacker]+=1
    
    player_data[attacker][PLAYER_STATS3][STATS3_ASSISTS]++
    
    set_hudmessage(0, 255, 0, 0.79, 0.24, 0, 6.0, 12.0)
    show_hudmessage(attacker, "+Assist")
}
public fwHamPlayerSpawnPost(iPlayer) {
    new i=0
    do {
        damage2[iPlayer][i]=0
        i+=1
    } while(i<33)
}
public fw_takedamage(victim, inflictor, attacker, Float:damage, bits) {
      damage2[attacker][victim]+=damage
}  
public deletedmg(id) {
    new i1 = 0
    do {
        new i2=0
        do {
            if(damage2[i1][i2]>0) {
                damage2[i1][i2]-=1
            }
            i2+=1
        } while (i2<33)
        i1+=1
    } while (i1<33)
    set_task(1.0, "deletedmg")
}

it's working

GordonFreeman (RU) · 07-09-2016 , 02:42 Re: CSstatsX SQL

Update 0.7.4 :p

Added weapon stats. New cvar csstats_sql_weapons.
Added match history stats. New cvar csstats_sql_maps.
Added round and connect stats.
Added assist stats. New cvar csstats_sql_assisthp and new forward client_assist_sql.
Added autoclean function. New cvar csstats_sql_autoclear.
Added autoreset function. New cvar csstats_sql_autoclear_day.
Improved cached usage. New cvar csstats_sql_cachetime.
Fixed bugs with get_stats and get_stats2 natives.
Removed is_user_connected check for get_user_stats natives.
Updated API.
New natives: get_sestats_*, get_user_stats3, get_stats3, get_stats2, get_user_stats2, get_user_firstjoin_sql, get_user_lastjoin_sql.
Fixed problem with cvar reading.
Fixed random bugs.

Hamartia · 07-31-2016 , 14:31 Re: CSstatsX SQL

Hi,

I am waiting for the release to be stable so that I can start using it. Whats your opinion about the current stage, is it stable enough or more rapid releases to be expected ?

GordonFreeman (RU) · 08-01-2016 , 11:09 Re: CSstatsX SQL

rapidly stable

Its should work fine if you are know how to install it xd
Currently most (90%) ~~admins~~ users of this plugin are faced problem that its hard to install and use.

I'm tested and retested it with hlds 6153, amxx 1.8.2 with local database (both mysql and sqlite).

Common problems:

rehlds with amxx 1.8.3, client_disconnected forward, fixing by googling error log.
may cause higher load time for top15 (OMG ITS TAKE 4-5 SECONDS TO OPEN TOP15 MOTD)
there is cache function for this case, but its still can take same time for top15, if you are using many sql plugins with many sql queries.
someone report random crash with remote database on shared hosting. i tried to check this moment, but failed to reproduce it with remote mysql db with ~150 ping.
you can't use it if you are don't know how your server is working.
"I KNOW MORE THAT DEVELOPER" problem.

Plugin can work separately with your csx module. So if you want check it without interrupt csx stats you can install it and watch plugin stats in sql table.

Hamartia · 08-01-2016 , 15:34 Re: CSstatsX SQL

Quote:

Originally Posted by GordonFreeman (RU)

rapidly stable

Its should work fine if you are know how to install it xd
Currently most (90%) ~~admins~~ users of this plugin are faced problem that its hard to install and use.

I'm tested and retested it with hlds 6153, amxx 1.8.2 with local database (both mysql and sqlite).

Common problems:

rehlds with amxx 1.8.3, client_disconnected forward, fixing by googling error log.
may cause higher load time for top15 (OMG ITS TAKE 4-5 SECONDS TO OPEN TOP15 MOTD)
there is cache function for this case, but its still can take same time for top15, if you are using many sql plugins with many sql queries.
someone report random crash with remote database on shared hosting. i tried to check this moment, but failed to reproduce it with remote mysql db with ~150 ping.
you can't use it if you are don't know how your server is working.
"I KNOW MORE THAT DEVELOPER" problem.

Plugin can work separately with your csx module. So if you want check it without interrupt csx stats you can install it and watch plugin stats in sql table.

Thanks for the info. I ll try it out.

Bleeding Warrior · 11-07-2016 , 09:47 Re: CSstatsX SQL

Quote:

Originally Posted by GordonFreeman (RU)

rapidly stable

Its should work fine if you are know how to install it xd
Currently most (90%) ~~admins~~ users of this plugin are faced problem that its hard to install and use.

I'm tested and retested it with hlds 6153, amxx 1.8.2 with local database (both mysql and sqlite).

Common problems:

rehlds with amxx 1.8.3, client_disconnected forward, fixing by googling error log.
may cause higher load time for top15 (OMG ITS TAKE 4-5 SECONDS TO OPEN TOP15 MOTD)
there is cache function for this case, but its still can take same time for top15, if you are using many sql plugins with many sql queries.
someone report random crash with remote database on shared hosting. i tried to check this moment, but failed to reproduce it with remote mysql db with ~150 ping.
you can't use it if you are don't know how your server is working.
"I KNOW MORE THAT DEVELOPER" problem.

Plugin can work separately with your csx module. So if you want check it without interrupt csx stats you can install it and watch plugin stats in sql table.

Hello , I have a problem , I have set cvars properly but still my server is not picking up host IP, i tried hardcoding it but still same problem !!
Also i have added same IP in aes.cfg and sql.cfg as well , still same problem !
https://s12.************/b25mnb65p/image.jpg