[2called-chaos]

Hi,

I just tried out the beta and therefore I tried the SQL version.

This is a sample error in the logs:

L 02/13/2010 - 11:42:46: [gungame_with_sql.amxx] Could not execute query [SELECT wins,name,points,streak,wins_tp,points_tp,str eak_tp FROM `gg_stats` WHERE authid='BOT' AND serverip='88.198.XXX.XXX:27015' LIMIT 1;] -- err #1054 [Unknown column 'name' in 'field list'] ..._with_sql.amxx] Could not execute query [SELECT wins,name,points,streak,wins_tp,points_tp,str eak_tp FROM `gg_stats` WHERE authid='STEAM_0:0:160XXXXX' AND serverip='88.198.XXX.XXX:27015' LIMIT 1;] -- err #1054 [Unknown column 'name' in 'field list']

The strikes will be saved but the stats doesn't work. The gg_players table is also empty.

Whats wrong?


Chaos

[XxAvalanchexX]

Hello,

Thanks for reporting this! Let's see if we can fix it.

As for gg_players, it only gets updated whenever someone wins a round. It only includes some information about the players who were playing when the win occurred, like what team they were on, how many points they got, etcetera, so that you can make your own custom MOTD win screen using SQL.

It's the gg_stats table that should include all of the meaty stats data. Do you have a way to view the structure of the table (like phpMyAdmin)? Can you verify that it really has a column named 'name' (it should)? When you switched to GG 2.13, did you use the website to convert your stats file to a SQL query to populate your database?

[viktor6]

Originally Posted by XxAvalanchexX Hello, Thanks for reporting this! Let's see if we can fix it. As for gg_players, it only gets updated whenever someone wins a round. It only includes some information about the players who were playing when the win occurred, like what team they were on, how many points they got, etcetera, so that you can make your own custom MOTD win screen using SQL. It's the gg_stats table that should include all of the meaty stats data. Do you have a way to view the structure of the table (like phpMyAdmin)? Can you verify that it really has a column named 'name' (it should)? When you switched to GG 2.13, did you use the website to convert your stats file to a SQL query to populate your database?

[Min2liz]

With gg_players table, same to me. It's empty and nothing. gg_strikes everything working, but with gg_player - not.

Oh and:

Originally Posted by 2called-chaos Hi, I just tried out the beta and therefore I tried the SQL version. This is a sample error in the logs: The strikes will be saved but the stats doesn't work. The gg_players table is also empty. Whats wrong? Chaos

These errors from older GunGame mod SQL, because before GunGame SQL used: lastname and this version don't create new column name or just don't rename it (don't know why) I self with phpMyAdmin create these colums:

• streak_tp
• streak
• wins_tp
• points_tp

And rename lastename to name

But gg_players same to me - empty all the time

Sorry for bad English.

[XxAvalanchexX]

Thanks, Min2liz, that's probably it! So if you delete your old gg_stats table or run this query to fix it, it should work:

ALTER TABLE `gg_stats`
CHANGE `authid` `authid` VARCHAR(31),
CHANGE `wins` `wins` SMALLINT(6) DEFAULT 0,
CHANGE `lastname` `name` VARCHAR(31) NOT NULL,
CHANGE `timestamp` `timestamp` INT(10) UNSIGNED DEFAULT 0,
CHANGE `points` `points` MEDIUMINT(9) DEFAULT 0,
ADD `streak` SMALLINT(6) DEFAULT 0 AFTER `points`,
ADD `wins_tp` SMALLINT(6) DEFAULT 0 AFTER `streak`,
ADD `points_tp` MEDIUMINT(9) DEFAULT 0 AFTER `wins_tp`,
ADD `streak_tp` SMALLINT(6) DEFAULT 0 AFTER `points_tp`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`authid`,`serverip`),
ADD INDEX (`wins`),
ADD INDEX (`points`),
ADD INDEX (`wins_tp`),
ADD INDEX (`points_tp`);

As for gg_players, I just looked into it. It looks like I wrote it so that it only bothers updating gg_players if you have a custom MOTD webpage for gg_winner_motd, as that is what it was designed for. Do you think I should have it update anyway? It's basically only the information you can find on the MOTD.

[Min2liz]

About gg_players: In real maybe don't need to update because same information I can find in gg_stats if I correct understand, but if you can explain why gg_players exists and when/what it's writing on it.

And have question about gg_streaks. yesterday i looked into it, and was 5 or 7 rows, now just 2. How I understand type = 0R that's mean record? But Record was 6 done by Jurgen, now it's 3 by vmf. So at this point i confused. Can you explain what thats mean:

0C and 0R and how it's work.

Thanks XxAvalanchexX

P.S. Trying to create own web stats, but I just confused in some points

[2called-chaos]

Thanks a lot, it works


Mfg

Chaos

[edward0810]

I am running non-SQL but it only logs streaks.
Stats file is always empty.
Can anyone fix this,also?

[XxAvalanchexX]

Hi edward0810,

I assume you are using the beta? Could you please post your gungame.cfg? Also, does there exist a "gungame.stats" file that is empty, or does the file not exist at all?

Thanks,

Ava

[edward0810]

Originally Posted by XxAvalanchexX Hi edward0810, I assume you are using the beta? Could you please post your gungame.cfg? Also, does there exist a "gungame.stats" file that is empty, or does the file not exist at all? Thanks, Ava

Sorry I fixed that.
I created a empty file and it logs properly.