[Timiditas]

I am currently pondering a completely new database layout. Tho I have difficulties to finally engage development in that direction since I don't know much about sqlite and the differences in the capabilities of sqlite and mysql. Supporting both is a self-defined handicap.

You may already see improvements in speed with 0.6.2beta, if the stalls don't originate from the database engine, respectively the database contents itself.

[d_duck]

How to make it 'explosion kill' change to score.
...
when any kill someone with explosion or incredible damage, not recognize default kill.
get 0 score.

is this originally ?

please help.

[Timiditas]

See posting #10
Since I didn't get any reaction about that at all, I am ignoring that fact for now.

[d_duck]

Originally Posted by Timiditas See posting #10 Since I didn't get any reaction about that at all, I am ignoring that fact for now.

sometimes, add a kill in score,

but sometimes, not added.

[d_duck]

ok, thats problem can fix myself.
but I found other problem.
show strange text when chat 'top'
users are named almost use Korean.
originally, it show '이름'
but real text in game be such '　　　' or '　????'

i will take a picture about this.


see this, I darg the text cause problem.

[PabloP]

I dont know if you still wanted wats in dignatio.log but here is a few lines of the 1600

L 08/12/2010 - 22:11:48: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:9321223'' at line 1
L 08/12/2010 - 22:11:48: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:0:9321223'
L 08/12/2010 - 22:18:58: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:20160254'' at line 1
L 08/12/2010 - 22:18:58: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:0:20160254'
L 08/12/2010 - 22:42:13: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:1:29129432'' at line 1
L 08/12/2010 - 22:42:13: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:1:29129432'
L 08/12/2010 - 22:44:08: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:19661609'' at line 1
L 08/12/2010 - 22:44:08: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:0:19661609'
L 08/12/2010 - 22:53:43: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:19661609'' at line 1
L 08/12/2010 - 22:53:43: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:0:19661609'
L 08/12/2010 - 22:58:24: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:5676401'' at line 1
L 08/12/2010 - 22:58:24: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 
L 08/12/2010 - 22:59:29: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:156157'' at line 1
L 08/12/2010 - 22:59:29: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:0:156157'
L 08/12/2010 - 23:09:52: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:156157'' at line 1
L 08/12/2010 - 23:09:52: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:0:156157'
L 08/12/2010 - 23:22:18: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:1:17725970'' at line 1
L 08/12/2010 - 23:22:18: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:1:17725970'
L 08/12/2010 - 23:22:19: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:0:5298401'' at line 1
L 08/12/2010 - 23:22:19: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 
L 08/12/2010 - 23:22:20: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1 WHERE steamId = 'STEAM_0:1:29129432'' at line 1

btw it works great from what i can tell

[PabloP]

OK i have a question, I would like to have a feature where people get points for winning gungame, NOT THE SM VERSION. No, i run the real version. I'm sure this could be done but do you think you could give me some pointers in the right direction?

[Timiditas]

Originally Posted by d_duck ok, thats problem can fix myself. but I found other problem. show strange text when chat 'top' users are named almost use Korean. originally, it show '이름' but real text in game be such '　　　' or '　????' i will take a picture about this. see this, I darg the text cause problem.

I will keep this in mind and will check into that, though I have to say that I never noticed problems recording special characters before.

@PabloP
Of course, always keep them logs coming.

This specific bug that pops up a thousand time in your logs is the same that d_duck mentioned, they occur when the game does not supply any weapon information in the occuring event (which mostly happens when other plugins deal no specific or additional damage, you will see the skull icon top right when a player dies like that).
A fix for that will be included in 0.6.2beta BUT I still don't know how to treat these special cases, since there is no way to tell how the damage was caused apart from the dealing player index.

I currently see two possible solutions for this. Either cache the last weapon used for all players and use the last weapon for this special case OR add another point cvar for damage without weapon info. Maybe both and let the admin decide what method to use.

Concerning your question about Gungame, it would need to supply any sort of event or something that an SM plugin could intercept. GG:SM provides a Forward for it, I don't know how your 'real' version handles that. Please provide a link so I can take a look at it.

[PabloP]

haha yeah i have another sm plugin that changes suicides into knife kill by the last person that attacked them, not sure how that would affect that.

My 'real' :] gungame will put this in log when someone wins.

01:02:13 L 08/29/2010 - 02:01:50: "jbob<267><STEAM_0:0xxxxxx><TERRORIST>" triggered "gg_win"

would that work?

here is file that controls that

//----------------------------------------------------------------------------
// gg_stats_logging.txt -- Events to log.
//
// This file defines all the events to log for use with third-party
// statistic applications. (e.g. HLstatsX, PsychoStats, etc.)
//
// Note: Any alteration of this file requires a server restart or a reload of
//       GunGame.
//
// Note: gg_stats_logging must be loaded for events to be logged.
//----------------------------------------------------------------------------

gg_levelup
gg_leveldown
gg_knife_steal
gg_win
gg_multi_level

cvar is gg_stats_logging 1

thank you sir

[Timiditas]

Originally Posted by PabloP My 'real' :] gungame will put this in log when someone wins. 01:02:13 L 08/29/2010 - 02:01:50: "jbob<267><STEAM_0:0xxxxxx><TERRORIST>" triggered "gg_win"

Think that'll work.
I presume you are using this, correct?
Need to run tests on it.

~Crap! ES page is down