PDA

View Full Version : Basic Points Stats v1.4.0

kwpd
08-07-2013, 12:01
BASIC POINTS STATS
DescriptionBasically, statistics mysql version is to connect multiple servers and each server can perform the query player data.
Peeking Web Test
View full page. ===> http://playespa.com/ <===

http://i.imgur.com/lVVUeOP.png

Requirements- CS 1.6
- Metamod
- Module(s) mysql
- Module(s) cstrike
- Module(s) csx
- Module(s) engine
- Module(s) fakemeta
- Module(s) hamsandwich
- AMX Mod X 1.8.3 or higher. (Last dev build see http://www.amxmodx.org/snapshots.php)
- Mysql 5.x http://www.mysql.com/downloads/mysql/
- navicat http://www.navicat.com/en/download/download.html
- Web Hosting
- Steam server.Clients Command
.stats View your Stats
.stats pug View Stats pug
.toppug See the top pug players
.resetstats Restart your stats
Command Console
bps_sql_host "localhost"
bps_sql_user "root"
bps_sql_pass "password"
bps_sql_db "SkillPointsBeta"

bps_sql_db_1 "basicpointsstats"
bps_sql_db_2 "basicweapomstats1"
bps_sql_db_3 "basicweapomstats2"
bps_sql_db_4 "basicversusstats"
bps_sql_temp_db "skillpoints_pug1"
pug_web_top_pug "http://you-web/?go=Ranking/ranking/index"
pug_web_temp_pug "http://you-web/stats_pug_temp1.php"
pug_end_stats Show all stats temp. Recommended.! use when a match ends

pug_stats_enable 0=Disable 1=Enable (Enables or disables the stats)
pug_stats_temp_enable 0=Disable 1=Enable (Enables or disables view .stats pug)

amx_remove_stats_pug Delecte stats temp. use before changing the map
pug_leave_points 0=Disable 1=Enable (When a player leaves the server loses karma)
bps_give_pugend = +1 karma all
amx_bps_ctwin = CT win
amx_bps_twin = T win
amx_bps_tie = Ties
pug_stats_restart 0=Disable 1=Enable (Enables or disables the reset stats)


/!\ important /!\[INDENT]Multiple servers.? Please change the record cvar.!
Server 1 = bps_sql_temp_db "skillpoints_pug1"
Server 2 = bps_sql_temp_db "skillpoints_pug2"
Server 3 = bps_sql_temp_db "skillpoints_pug3"

Change host, root, password ==> scripting/BasicPointsStats.sma
amx_remove_stats_pug Delecte stats temp. use before changing the map
InstallationBasicPointsStats.amxx ==> cstrike/amxmodx/plugins/
BasicPointsStats.txt ==> cstrike/amxmodx/data/lang/
Copy the text BasicPointsStats.amxx ==> cstrike/addons/amxmodx/config/plugins.ini
Web All fire ==> www.youwebsite.com (http://forums.alliedmods.net/showthread.php?t=222866)
Web Ranking\config.php ==> change settings. "localhost", "root", "password", "DataBase"Multi Server Test
http://cache.www.gametracker.com/server_info/200.124.13.114:27015/b_350_20_FFAD41_E98100_000000_591F11.png (http://www.gametracker.com/server_info/200.124.13.114:27015/) http://cache.www.gametracker.com/server_info/200.124.13.114:27016/b_350_20_FFAD41_E98100_000000_591F11.png (http://www.gametracker.com/server_info/200.124.13.114:27016/)
Version 1.0.0
* Initial Release 24 -november-2012
https://forums.alliedmods.net/showthread.php?t=201742
----------------------------------------------------------------------------------------------------------
@_@ A little help for people who are using the plugin pug mod xt
https://forums.alliedmods.net/showpost.php?p=2225846&postcount=335

expected to learn to inject this command
kwpd
08-07-2013, 12:02
Change log WEB

Next update
*

Version 1.0.5
* integrate search (ranking index.php)

Version 1.0.4
* Add Player search
* Remove All php Ranking-temporal
* Rewrites all pug stats in just 1 php file (stats_pug_temp1.php)

Version 1.0.3
* design changes.
* Add stats temp + pug_temp.php new design. temporal statistics.
* fix index.php

Version 1.0.2
* BETA 3
* Added GunGame Stats -> Change Host, user, mysql - gungame / config.php
* Check Add Adr.

Version 1.0.1
* Private release
* BETA 2

Version 1.0.0
* Public release
* BETA 1
Change log SQL

Next update
*

Version 1.0.3
* Public release
* Add 5 sql install basicpointsstas, basicversusstats, basicweapomstats1,
basicweapomstats2, BPS Full Install.
Change log BPS

Next update
*

Version 1.4.0
* Add wait to load statistics (.stats)
* Fix Duplicated ! set_task( 3.0, "Test_bps_players", id + CONNECT_TASK2 )
* Fix disconnected player ignored (id 0)
* Fix Join_team
* Fix -->
* Optimizing .stats
* Supports language [EN], [ES],

[B]Version 1.3.9
* Add players disconnect Temp_g_szPoints_group[id]=6
pug_stats_enable 0=disable 1=enable
enable -> all players leaving the pug. are recorded. 6 = leaving group
disable -> players leaving the pug. not recorded. 6 = leaving group
* Fix g_iCurrentKills_v[id]++
* Fix change map = reset stats
* Change in registration mode for new players.

Version 1.3.8
* Fix save stats (bps_players[id] = 1)

Version 1.3.7
* checking if everything is in order. Ctrl+i
* mode change. Load stats.
* Mini Fix kill_v (not add up. fire friends)
* Fix statistical duplicate to new players.
* add comand deleted stats temp.
* fix weapon stats
* adds. temporal statistics. command (. stats pug)
* adds. versus detection. 1v 2v 3v 4v v5
* fix. (v2 = 2k. v3 = 3k. v4 = 4k. v5 = 5k)
* new format equipment. 1-2 is changed to T-CT
* adds. player leave. enter number 6 and will be hidden.

Version 1.3.6
* Compiling amxmodx 1.8.3-dev-git4058

Version 1.3.5
* FIX SavePointsAtRoundEnd()

Version 1.3.4
* Changes SavePointsAtRoundEnd()
* Changes points_all_pugend()

Version 1.3.3
* FIX v1 v2 v3 v4 v5

Version 1.3.2
* Add v1 v2 v3 v4 v5
* Changes EventRoundEnd ()

Version 1.3.1
* Mini array if (g_iCurrentKills [i]> = 5 ~> if (g_iCurrentKills [i] == 5

Version 1.3.0
* Changes "" public EventRoundEnd () ""
* Changes "" public SavePointsAtRoundEnd () ""

Version 1.2.9
* Fix bug "get_user_info"

Version 1.2.8
* Changes set_task (1.0, "SavePointsAtRoundEnd") -> SavePointsAtRoundEnd ()
* Changes CheckLevelAndSave1 (i) -> set_task (0.7 "CheckLevelAndSave1")
* Changes CheckLevelAndSave2 (i) -> set_task (0.8 "CheckLevelAndSave2")
* Changes CheckLevelAndSave3 (i) -> set_task (0.9, "CheckLevelAndSave3")
* Changes CheckLevelAndSave4 (i) -> set_task (1.0, "CheckLevelAndSave4")

Version 1.2.7
* Fix (set_task 1.0)
1 second. to ensure that you record all information.

Version 1.2.6
* Fix Round Recorder

Version 1.2.5
* Fix CheckLevelAndSave1
* Fix CheckLevelAndSave2
* Fix CheckLevelAndSave3
* Fix CheckLevelAndSave4
* Fix Maps Change. bug ... name -> AP '# hehehehe
* Pause client_putinserver

Version 1.2.4
* Fix name -> AP '# hehehehe
* Various internal improvements.

Version 1.2.3
* Fix. Resetstats
* Various internal improvements.

Version 1.2.2
* Various internal improvements.

Version 1.2.1
* Fix task_exists "Duplicate"
* Various internal improvements.

Version 1.2.0
* Added reset stats "pug_stats_restart"
* Add FCVAR_PROTECTED "host cvar"
* Added cvar bps_sql_host, bps_sql_user, bps_sql_pass, bps_sql_db
* Modification include.! basicstatsconnect.inc

Version 1.1.9
* Public release
* Fix g_szPoints_d is repeated 3 t

Version 1.1.8
* Public release
* Fix pug_stats_enable 0

Version 1.1.7
* Public release
* Add. Top10
* Fix Name PLUGIN
* TOP TEN colors will be white and black letters.

Version 1.1.6
* Public release
* Fix. Stats Rank% i of% i (Frag)

Version 1.1.5
* Public release
* Elimination my password xD

Version 1.1.4
* Public release
* Add Web Beta 1

Version 1.1.3
* Private release
* Special Edition v2.0.0 BSP synchronization
* Disposal V1 V2 V3 V4 V5
* Auto Disposal Installation SQL.

Version 1.1.2
* Private release
* Upgrade Basic skillpoints Special Edition v2.0.0
* Massive Change Code

Version 1.1.1
* Private release
* Changes by INT BIGINT
since amxmodx not support BIGINT

Version 1.1.0
* Private release
* Fix Registry W.L.T
* Fix Registry Weapom 2
* Fix Registry Versus
* Web Beta Weapom Add 2 Stats

Version 1.0.9
* Private release
* Disposal (Basicstats, weapomstats, versusstats)
* Disposal sql (Basicstats, weapomstats, versusstats)
* Disposal host cvar BD Pass.
* Add 1 single sma "BasicPointsStats.sma"
* Add host include Connection
* Add loads sql Multiples
* Add full sql installation
* Fix W. L. T. (It crashed)
* Changes sql int to bigint
* Beta Weapom Web Stats
* Web Add config.php
* Various internal improvements.

Version 1.0.8
* Private release
* Fix Stadistica of weapons
* Fix versus
* 3 new sma (Basicstats, weapomstats, versusstats)

Version 1.0.7
* Private release
* Add 3 type sql
1 = kill, Death, Assists, BP, BD, W, L, D, ADR, FPR, HSP, KARMA
2 = 2K, 3K, 4K, 5K, v1, v2, v3, v4, v5
3 = usp, clock, deagle, ak47, m4, ect ect ect ect ect
* Various internal improvements.

Version 1.0.6
* Private release
* Adds v1 v2 v3 v4
* Adds stats ect ect ect m4 ak47
* Error correcting planted bomb.

Version 1.0.5
* Private release
* Sql_host cvar changes ect ...
* Changes SteamID for more than 32 characters
* In a small case .. is to cast a FOR
* Changes registry to keep more than 32 players (32/32)

Version 1.0.4
* Auto installation stats.sql
* Fix 50dmg minimum damage to count as attendance.
* Optimization pug_dmg
* Changes stats.sql
kill, Death, Assists, BP, BD, HE G., KNIFE, 5K Aces, ADR, FPR, HSP, KARMA

Version 1.0.3
* Added Assistance minimum of 50 damage
* Added minimum to activate Online Player Stats
* Changes stats.sql
kill, Death, Assists, BP, BD, HE G., KNIFE, 5K Aces, KARMA

Version 1.0.2
* Prevention stats 0 "round record stats"

Version 1.0.1
* Arregro winner Group ID

Version 1.0.0
* Initial Release 24-november-2012
[B][B]Old versions ( DO NOT USE )
sami_spt
08-07-2013, 12:04
English is needed .. please change it.
I can translate it to english, but...
where is the plugin?
YamiKaitou
08-07-2013, 12:04
Where is the plugin?
sami_spt
08-07-2013, 12:36
He posted it.
what new thing did you do ?

Tell us what is different from these plugins:
http://forums.alliedmods.net/showthread.php?t=191708
http://forums.alliedmods.net/showthread.php?t=74175
http://forums.alliedmods.net/showthread.php?t=131720

-some parts in the webpart isnt english. try to fix that.
^SmileY
08-07-2013, 13:32
Hey, the correct g_szPoints_v1 is wrong..
in this case will count as 2k, 3k, 4k and others.

For check if is 1v1 1v2 1v3 etc. situations, you need check if the player is alone not?
kwpd
08-07-2013, 22:58
next updates
FIX
v1 v2 v3 v4 v5 + 2k 3k 4k 5k
quilhos
10-03-2013, 12:47
Web Stuff have a few bugs I will try to fix it and will upload it
Robotron
11-04-2013, 19:50
where can download the pug mod?
PoLiCe
11-07-2013, 10:52
http://i.imgur.com/FXU9iYy.png
when i saw this i thought it's a troll post or something xD.
Anyways. great plugin :) Gj :D
pupil0888
07-06-2014, 22:32
[AMXX] Plugin says: Host '23.89.199.91' is not allowed to connect to this MySQL server
YamiKaitou
07-06-2014, 23:52
[AMXX] Plugin says: Host '23.89.199.91' is not allowed to connect to this MySQL server

You need to allow that IP access to your SQL server. If you don't know how, contact your SQL Host
kruger
09-16-2014, 13:00
The plugin works but there are some columns in the database that I don't understand...

Can anyone explain me what is the meaning of the following:

table basicpointsstats: pug_adr, pug_fpr, pug_hsp, pug_rws

table basicversusstats: pug_2k, pug_3k, pug_v1, pug_v2

???
kruger
10-11-2014, 07:11
After some time some of the players "vanish" from the ranks and they start again from zero (just one or two an it seems random...) - especially if they change nick but this should not happen since the data from the players is registered by steamid...

Is this a bug?
kwpd
10-12-2014, 01:17
After some time some of the players "vanish" from the ranks and they start again from zero (just one or two an it seems random...) - especially if they change nick but this should not happen since the data from the players is registered by steamid...

Is this a bug?
it is a registry error. when the server changes map. The error usually happens when the player first enters the load to SQL .. I'll see if I get internet connection to my database. to verify that moment passes that error ..
by google translator xD
pupil0888
10-13-2014, 17:40
[AMXX] Plugin says: Access denied for user 'root'@'ip_local(localhost)' (using password: YES)

no me deja conectarme a ningun host sql, ya lo he hecho de manera local y remota quito el password del root y nada me sigue diciendo lo mismo no tiene acceso por ningun lado. cree la base de datos y un user nuevo root sin password y de cualquier servidor y nada!
pupil0888
10-13-2014, 17:52
why?
( 27) Error: Access denied for user 'root'@'mi-server-ip' (using password: YES)
gonzalosor
10-13-2014, 21:15
why?
( 27) Error: Access denied for user 'root'@'mi-server-ip' (using password: YES)

Me daba el mismo error, incluso peores que ese, lo que hice fue desinstalar MySQL e instalar XAMP y me fue muchisimo mejor... Te lo recomiendo! por cierto si el server es local también te puedo recomendar usar 127.0.0.1

kwpd hermanazo por favor la liberación de tu ultima modificación por privado, dime si necesitas algún donativo
zmd94
10-14-2014, 04:39
Please use English. ;)
kruger
10-17-2014, 02:25
Do you have an update on the problems that I reported???
kwpd
11-03-2014, 14:32
why?
( 27) Error: Access denied for user 'root'@'mi-server-ip' (using password: YES)
is your mysql host settings with your HLDS server


Do you have an update on the problems that I reported???patience. the next version is almost ready .. I'm just checking something.
kruger
11-04-2014, 12:31
patience. the next version is almost ready .. I'm just checking something.

Great!

I thought that you abandoned the plugin development.
gonzalosor
11-04-2014, 18:38
Yessssssss BasicPointsStats for the win!!!
kruger
11-06-2014, 05:27
Where is the plugin???
HamletEagle
11-06-2014, 10:36
Last edited by kwpd; Today at 01:39 AM.

Maybe he is updating it, just wait.
GinNNy
11-06-2014, 11:26
Hes not updating any plugin he just removed all of the attachments he attached.
kwpd
11-06-2014, 18:45
I'm looking for players. to verify whether they are registering the expected statistical .. after velificar compress the file and upload it.
by translate google :D
gonzalosor
11-07-2014, 21:41
kwpd, change "Flags" -> "Frags".... using command .stats
kwpd
11-07-2014, 21:58
a moment and saw a small bug.
when players enter the server. the stats of other players doubles .. I will be making some changes to avoid this little mistakes happen.

kwpd, change "Flags" -> "Frags".... using command .stats

FIXED
len += format(Info[len], 1500-len,"<left><font color=^"#000000^"><B>Flags:</B><font color=^"#000000^">%i</color></left>^n", g_szPoints_k[id]);--->
len += format(Info[len], 1500-len,"<left><font color=^"#000000^"><B>Frags:</B><font color=^"#000000^">%i</color></left>^n", g_szPoints_k[id]);
kruger
11-08-2014, 04:58
I tried to compile your test version - 1.3.7 - and I received the following errors:


Error: Undefined symbol "pug_panama" on line 1737
Warning: Symbol is never used: "SQL_TABLE1" on line 1944
Warning: Symbol is never used: "SQL_TABLE2" on line 1944
Warning: Symbol is never used: "SQL_TABLE3" on line 1944
Warning: Symbol is never used: "SQL_TABLE4" on line 1944
kwpd
11-08-2014, 13:28
I tried to compile your test version - 1.3.7 - and I received the following errors:
which version you are using amxmodx? and tested with version 1.8.2 and 1.8.3

http://i.imgur.com/dED2m0D.png

the version you are using is a test.
I would not recommend using it. because I and not yet made the problem arregrar stats doubles. with the image below and you will know what I mean.
kruger
11-09-2014, 05:05
You are right - I was using the old 1.8.1 version after an update now it compiles O.K.

About the duplicates as an workaround you can hide them in php or mysql as duplicate records based on steamid but, of course, this is just a dirty workaround and not a fix...
kruger
11-11-2014, 05:08
Could you please give an English explanation of what some of the columns in database means if not all of them???

For example: pug_rp, pug_adr, pug_a, tmp_group (what 1,2 ,6 means???), tmp_rp, tmp_a???
kwpd
11-11-2014, 12:26
Could you please give an English explanation of what some of the columns in database means if not all of them???

For example: pug_rp, pug_adr, pug_a, tmp_group (what 1,2 ,6 means???), tmp_rp, tmp_a???

pug_rp = Round Play
pug_adr = All Damage per Round
pug_a = Assistance
tmp_group = 1=Terroris 2=CSts 6=Spect
kruger
11-11-2014, 19:23
pug_rp = Round Play
pug_adr = All Damage per Round
pug_a = Assistance
tmp_group = 1=Terroris 2=CSts 6=Spect

Thanks a lot!
You rock!
kruger
11-14-2014, 12:25
One thing that I noticed:

In your screenshots "pug_rws" is a floating point value but in the sql script for the database install you define pug_rws as integer: "pug_rws` int(11) DEFAULT NULL" - ???
gonzalosor
11-14-2014, 14:25
any update? :)
kwpd
11-14-2014, 20:43
One thing that I noticed:

In your screenshots "pug_rws" is a floating point value but in the sql script for the database install you define pug_rws as integer: "pug_rws` int(11) DEFAULT NULL" - ???
previously he had already tried to do. but I saw amxx engines are very limited. I'll try once more. "pug_rws` FLOAT(11,2)
would have to change all three files. sql php and sma

any update? :)
The latest is 1.3.8
If I can write well chafing. "pug_rws` FLOAT (11,2)
version 1.3.9 is updated
gonzalosor
11-15-2014, 19:12
Is there a way you can change theese 3 values, it would look a bit nicer :).

Also, how would BSP plugin know when the match ends so it will popup the temp motd?
kwpd
11-18-2014, 01:42
Is there a way you can change theese 3 values, it would look a bit nicer :).

Also, how would BSP plugin know when the match ends so it will popup the temp motd?
no need to change the registry. That depends on how the query is done by php

next update web 1.0.4
change change change

<?php
require 'Ranking/config.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Stats pug</title>
<style type="text/css">
<!--
.style3 {
font-size: 12px;
color: #000000;
}
.style4 {
font-size: 12px;
color: #333333;
}
.style5 {
font-size: 12px;
color: #517099;
}
.style43 {font-size: 12px}
.style46 {font-family: "Times New Roman", Times, serif; font-weight: bold; font-size: 14; color: #000000; }
.style47 {font-size: 12px; color: #000000; }
.style1 {color: #666666}
.style44 {color: #148234;
font-weight: bold;
font-size: 12px;
}
.style48 { font-size: 12px;
color: #517099;
}
-->
</style>
</head>
<body>
<table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#B8B8B8">
<tr>
<td><table border="1" cellpadding="0" cellspacing="5" bordercolor="#F0F0F0">
<tr>
<td height="30" bgcolor="#F0F0F0"><strong class="style43">Match Awards:</strong></td>
</tr>
<tr>
<td><table border="1" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0">
<tr>
<td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Deadly</span></td>
<td align="left" valign="top">
<?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players1[]=$b;
}
?><table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players1 as $player1){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player1["nick"]?></span></td>
</tr>
<?php }?>
</table>
</td>
</tr>
<tr>
<td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Professional</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players2[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players2 as $player2){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player2["nick"]?></span></td>
</tr>
<?php }?>
</table>
</td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Most Honorable</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players3[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players3 as $player3){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player3["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
<tr>
<td align="left" valign="middle" class="style47">&nbsp;</td>
<td width="400" align="left" valign="middle">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Most Dishonorable</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players4[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players4 as $player4){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player4["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Most Cowardly</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players5[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players5 as $player5){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player5["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Mostly Harmless</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players6[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players6 as $player6){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player6["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table border="0" cellspacing="5" cellpadding="0">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
<tr>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30"><span class="style43"><strong>Team A Statistics</strong></span></td>
</tr>
</table></td>
</tr>
</table></td>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
<tr bordercolor="#F0F0F0">
<th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
</tr>
<?php
$busca="1";
if($busca!="2"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
<?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
</table>
<p></p></td>
</tr>
<tr>
<td><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
<tr>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30"><span class="style43"><strong>Team B Statistics</strong></span></td>
</tr>
</table></td>
</tr>
</table></td>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
<tr bordercolor="#F0F0F0">
<th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
</tr>
<?php
$busca="2";
if($busca!="1"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
<?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
</table>
<p>&nbsp;</p></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html><?php
require 'Ranking/config.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Stats pug</title>
<style type="text/css">
<!--
.style3 {
font-size: 12px;
color: #000000;
}
.style4 {
font-size: 12px;
color: #333333;
}
.style5 {
font-size: 12px;
color: #517099;
}
.style43 {font-size: 12px}
.style46 {font-family: "Times New Roman", Times, serif; font-weight: bold; font-size: 14; color: #000000; }
.style47 {font-size: 12px; color: #000000; }
.style1 {color: #666666}
.style44 {color: #148234;
font-weight: bold;
font-size: 12px;
}
.style48 { font-size: 12px;
color: #517099;
}
-->
</style>
</head>
<body>
<table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#B8B8B8">
<tr>
<td><table border="1" cellpadding="0" cellspacing="5" bordercolor="#F0F0F0">
<tr>
<td height="30" bgcolor="#F0F0F0"><strong class="style43">Match Awards:</strong></td>
</tr>
<tr>
<td><table border="1" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0">
<tr>
<td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Deadly</span></td>
<td align="left" valign="top">
<?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players1[]=$b;
}
?><table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players1 as $player1){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player1["nick"]?></span></td>
</tr>
<?php }?>
</table>
</td>
</tr>
<tr>
<td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Professional</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players2[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players2 as $player2){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player2["nick"]?></span></td>
</tr>
<?php }?>
</table>
</td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Most Honorable</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players3[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players3 as $player3){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player3["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
<tr>
<td align="left" valign="middle" class="style47">&nbsp;</td>
<td width="400" align="left" valign="middle">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Most Dishonorable</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players4[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players4 as $player4){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player4["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Most Cowardly</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players5[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players5 as $player5){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player5["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
<tr>
<td align="left" valign="middle" class="style43"><span class="style46">Mostly Harmless</span></td>
<td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {
$players6[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
<tr></tr>
<?php $i=0;foreach($players6 as $player6){$i++;?>
<tr>
<td align="left" valign="top"><span class="style5"><?php print $player6["nick"]?></span></td>
</tr>
<?php }?>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table border="0" cellspacing="5" cellpadding="0">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
<tr>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30"><span class="style43"><strong>Team A Statistics</strong></span></td>
</tr>
</table></td>
</tr>
</table></td>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
<tr bordercolor="#F0F0F0">
<th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
</tr>
<?php
$busca="1";
if($busca!="2"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
<?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
</table>
<p></p></td>
</tr>
<tr>
<td><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
<tr>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30"><span class="style43"><strong>Team B Statistics</strong></span></td>
</tr>
</table></td>
</tr>
</table></td>
<td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
<tr bordercolor="#F0F0F0">
<th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
<th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
</tr>
<?php
$busca="2";
if($busca!="1"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
<?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
</table>
<p>&nbsp;</p></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
kruger
11-20-2014, 09:41
The bug with some random player resetting its stats and starting from zero is still present...
Steam player - not changing his in game nick ==> everything O.K.

Steam player = changing his nick in game ==> the next time that he/she connects the stats starts from zero...

This happens only if the players changes his nick while in game, if he enters with a changed nick everything is O.K.
kwpd
11-20-2014, 22:42
The bug with some random player resetting its stats and starting from zero is still present...
Steam player - not changing his in game nick ==> everything O.K.

Steam player = changing his nick in game ==> the next time that he/she connects the stats starts from zero...

This happens only if the players changes his nick while in game, if he enters with a changed nick everything is O.K.
only when the nick change? I will observe mysql gimme a little time to check.
4-7 days
kruger
11-21-2014, 03:35
only when the nick change? I will observe mysql gimme a little time to check.
4-7 days

Steam player: If the player changes his nick the statistics for him are back to zero, if he doesn't modify his nick then everything is O.k. and since the records are by steam this should not be happening...

I'm not sure if this is the trigger but I noticed that the statistics are back to zero only for players than change their nick.
kwpd
11-21-2014, 13:05
Steam player: If the player changes his nick the statistics for him are back to zero, if he doesn't modify his nick then everything is O.k. and since the records are by steam this should not be happening...

I'm not sure if this is the trigger but I noticed that the statistics are back to zero only for players than change their nick.
what they failed to understand.
because sometimes you write repeated steam player?

21/NOV/2014
I have the error ... the error is not the nickname. is something else. I'll be rewriting aa few things and to try uploading the file.
I take a little more time checking out the file.

22/NOV/2014
Tested: when it comes to stats server (see your statistics) when you exit and enter the server. Loading cancera but the load.! changes the map server and boom remains stats 0 0 0 0 0 0 0 xD
the cause of this error is here .. public client_authorized (id) I'll patiently re-edit it to avoid this error.
thanks for your report ..

22/NOV/2014
release version 1.3.9

By translate.google.com
kruger
11-22-2014, 07:15
I keep repeating about STEAM because there is a bad practice on allied modders: whenever there is a problem with a plugin some forum admins jump at you about having steam - so I wanted this to be clear for the admins here...

Sorry about that and thank you for the fix.

There is really need for a database statistics plugin for cs 1.6 other than hlstats which is a pain to install and configure.

You're doing a great job for the cs 1.6 community!
YamiKaitou
11-22-2014, 08:14
I keep repeating about STEAM because there is a bad practice on allied modders: whenever there is a problem with a plugin some forum admins jump at you about having steam - so I wanted this to be clear for the admins here...

The AM Staff will only do that if there is proof of such, not just randomly.
kruger
11-23-2014, 03:49
Still resetting some player stats to zero at change map with this kind of errors in log:

L 11/22/2014 - 21:29:07: [AMXX] Displaying debug trace (plugin "BasicPointsStats.amxx")
L 11/22/2014 - 21:29:07: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 11/22/2014 - 21:29:07: [AMXX] [0] BasicPointsStats.sma::RegisterClient_Temp (line 1716)
L 11/22/2014 - 21:29:07: [MySQL] Thread worker was unable to start.
L 11/22/2014 - 21:29:07: [AMXX] Displaying debug trace (plugin "BasicPointsStats.amxx")
L 11/22/2014 - 21:29:07: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 11/22/2014 - 21:29:07: [AMXX] [0] BasicPointsStats.sma::RegisterClient4 (line 1651)
L 11/22/2014 - 21:29:07: [MySQL] Thread worker was unable to start.
L 11/22/2014 - 21:29:07: [AMXX] Displaying debug trace (plugin "BasicPointsStats.amxx")
L 11/22/2014 - 21:29:07: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 11/22/2014 - 21:29:07: [AMXX] [0] BasicPointsStats.sma::RegisterClient3 (line 1590)
L 11/22/2014 - 21:29:07: [MySQL] Thread worker was unable to start.
L 11/22/2014 - 21:29:07: [AMXX] Displaying debug trace (plugin "BasicPointsStats.amxx")
L 11/22/2014 - 21:29:07: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 11/22/2014 - 21:29:07: [AMXX] [0] BasicPointsStats.sma::RegisterClient2 (line 1519)
L 11/22/2014 - 21:29:07: [MySQL] Thread worker was unable to start.
L 11/22/2014 - 21:29:07: [AMXX] Displaying debug trace (plugin "BasicPointsStats.amxx")
L 11/22/2014 - 21:29:07: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 11/22/2014 - 21:29:07: [AMXX] [0] BasicPointsStats.sma::RegisterClient1 (line 1461)
L 11/22/2014 - 22:38:47: Start of error session.
L 11/22/2014 - 22:38:47: Info (map "de_mjolby3") (file "addons/amxmodx/logs/error_20141122.log")
L 11/22/2014 - 22:38:47: [AMXX] Displaying debug trace (plugin "BasicPointsStats.amxx")
L 11/22/2014 - 22:38:47: [AMXX] Run time error 4: index out of bounds
L 11/22/2014 - 22:38:47: [AMXX] [0] BasicPointsStats.sma::client_infochanged (line 398)
L 11/22/2014 - 22:38:47: [AMXX] Displaying debug trace (plugin "BasicPointsStats.amxx")
L 11/22/2014 - 22:38:47: [AMXX] Run time error 4: index out of bounds
L 11/22/2014 - 22:38:47: [AMXX] [0] BasicPointsStats.sma::client_infochanged (line 398)


It's actually worst than 1.3.8...
kwpd
11-23-2014, 12:17
We are in version 1.3.9 plus I'm on my smartphone.. I will be reviewing tomorrow.
kwpd
11-23-2014, 18:54
Still resetting some player stats to zero at change map with this kind of errors in log:



It's actually worst than 1.3.8...

That PROSEDE error not locate your SQL
kruger
11-24-2014, 02:49
Yes, sometimes it looses connection - I have the same problem with advanced bans (my hosting plan more specifically is the problem) but is this the reason why some players are resetting their stats to 0???
Shouldn't be better to keep the stats in a buffer until the map finishes and transfer them at change map??? This way if the connection is lost the old stats remains in place.
I tested now the latest version (1.3.9) and the issue with players resetting their stats from 0 is more frequent than in version 1.3.8.
kwpd
11-24-2014, 13:20
Yes, sometimes it Loses connection - I have the same problem with Advanced bans (my hosting plan more Specifically is the problem) but is this the reason why some players are resetting Their stats to 0 ???due to loss of connection .. The player enters the server. and loss of connection. the server inserts LOADSTATS and fails to locate. the player registers as a new user.


Should not be better to keep the stats in a buffer Until the map finishes and transfer them at change map ???I can not do that. because the statistics are multiple server .. if you save buffer and enters another server etadistica you rewind to previous ..
gonzalosor
11-29-2014, 07:49
Please try to improve the ".stats" so it can load faster, maybe you can use something like calling a php url with that stats.
kwpd
11-29-2014, 14:14
Please try to improve the ".stats" so it can load faster, maybe you can use something like calling a php url with that stats.
can improve load (.stats) depending on the connection between HLDS and MYSQL
there are 2 forms
Internal .stats = depending on connection speed HLDS & MYSQL
External .stats = The load is faster. and only depending on the speed of the web page

I'm busy optimizing. MOD PUG YAP.
when you have time. I will optimize .stats
and think how to create a autolocate of stats. to avoid what they are registered. error of slow connections between HLDS and MYSQL
BPS fails to locate etadistica time. I recorded as new players.
pupil0888
12-22-2014, 17:18
me pasa esto padre?

I passed this because?

http://i.imgur.com/e8BjC8q.png
kwpd
12-22-2014, 18:46
This is because your mysql connection and configuration
require 'Ranking/config.php'you must configure
<?php
ob_start();
error_reporting(E_ERROR | E_WARNING | E_PARSE);
ini_set("display_errors", 1);

$dbc = mysql_connect("localhost", "root", "password");
if (!$dbc) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("SkillPointsBeta");
?>
the file must be this way. as indicated routes.
www.youweb.com\Ranking\config.php
Remove
12-29-2014, 13:10
Hello web not working and plugin not work fines plugin loging to mysql perfect but server concole take this

20:00:38: [AMXX] Plugin ("BasicPointsStats.amxx") is setting itself as failed.
L 12/29/2014 - 20:00:38: [AMXX] Plugin says: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 12/29/2014 - 20:00:38: [AMXX] Run time error 1 (plugin "BasicPointsStats.amxx") - forced exit

not working plugin comands mysql info ok but not work fine
gonzalosor
12-29-2014, 17:24
Hello web not working and plugin not work fines plugin loging to mysql perfect but server concole take this

20:00:38: [AMXX] Plugin ("BasicPointsStats.amxx") is setting itself as failed.
L 12/29/2014 - 20:00:38: [AMXX] Plugin says: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 12/29/2014 - 20:00:38: [AMXX] Run time error 1 (plugin "BasicPointsStats.amxx") - forced exit

not working plugin comands mysql info ok but not work fine

- AMX Mod X 1.8.3 or higher. (Last dev build see http://www.amxmodx.org/snapshots.php)
3nf
05-14-2015, 22:50
hello help problem with web
error

Warning: require(Ranking/config.php): failed to open stream: No such file or directory in C:\xampp\htdocs\stats\Ranking\ranking\index.p hp on line 6
pupil0888
02-21-2016, 19:43
http://i.imgur.com/qfPgOwg.jpg
jonatat
01-05-2018, 12:55
L 01/05/2018 - 19:50:45: [AMXX] Run time error 4: index out of bounds
L 01/05/2018 - 19:50:45: [AMXX] [0] BasicPointsStats.sma::Ham_Killed_player (line 672)
kwpd
09-07-2020, 00:36
L 01/05/2018 - 19:50:45: [AMXX] Run time error 4: index out of bounds
L 01/05/2018 - 19:50:45: [AMXX] [0] BasicPointsStats.sma::Ham_Killed_player (line 672)

sorry. I'm still recovering from COVID19
I'm seeing that the compatibility
I will take some time to read and study the changes amxx 1.9 api
https://wiki.alliedmods.net/AMX_Mod_X_1.9_API_Changes

:V