| 135 |
-: Plugin ad on client connect. |
-: Plugin ad on client connect. |
| 136 |
-: WebMod support since it is a huge security vulnerability. |
-: WebMod support since it is a huge security vulnerability. |
| 137 |
-: Cvars: climb_webmod, climb_stats_path, climb_stats_url, ip_internal, ip_external |
-: Cvars: climb_webmod, climb_stats_path, climb_stats_url, ip_internal, ip_external |
| 138 |
//c: Tweaked semiclip to hopefully eliminate lag problems reported by some people. |
//c: New semiclip, should be flawless now. (not completely done yet) |
|
//c: New semiclip, should be flawless now. |
|
| 139 |
c: Cvar climb_water_nodraw changes take effect without reloading map. |
c: Cvar climb_water_nodraw changes take effect without reloading map. |
| 140 |
c: Database now stores multiple records per map per player. |
c: Database now stores multiple records per map per player. |
| 141 |
c: Cvar climb_db_pass is now protected. |
c: Cvar climb_db_pass is now protected. |
| 268 |
#include <cstrike> |
#include <cstrike> |
| 269 |
#include <cstrike2> |
#include <cstrike2> |
| 270 |
|
|
| 271 |
new const VERSION[ ] = "a3.7.7 Feb 23 18:32 MST" |
new const VERSION[ ] = "a3.7.8 Feb 24 20:55 MST" |
| 272 |
new const TRKCVAR[ ] = "climb_version" |
new const TRKCVAR[ ] = "climb_version" |
| 273 |
|
|
| 274 |
new const DONOTHING[ ] = "donothing" |
new const DONOTHING[ ] = "donothing" |
| 3498 |
{ |
{ |
| 3499 |
new query[501], data[1] |
new query[501], data[1] |
| 3500 |
data[0] = id |
data[0] = id |
| 3501 |
|
//old |
| 3502 |
|
//select distinct p.alias, s.fin_time, s.cps, s.gcs, g.fin_cnt, s.boosts, s.wpns, s.score from climb_scores s join climb_players p on s.user_id = p.user_id join (select user_id, min(score) minscore, count(*) fin_cnt from climb_scores where map_name="clintmo_longjumper" group by user_id, wpns) g on p.user_id=g.user_id where map_name="clintmo_longjumper" and s.score=g.minscore order by s.score limit 20 |
| 3503 |
|
//new |
| 3504 |
|
//select p.alias, s.fin_time, s.cps, s.gcs, g.fin_cnt, s.boosts, s.wpns, s.score, s.score_id from climb_scores s join climb_players p on s.user_id = p.user_id join (select user_id, min(score) minscore, count(*) fin_cnt, score_id from climb_scores where map_name="clintmo_longjumper" group by user_id, wpns) g on g.score_id=s.score_id order by s.score limit 20 |
| 3505 |
formatex( query, 500, |
formatex( query, 500, |
| 3506 |
"select distinct p.alias, s.fin_time, s.cps, s.gcs, g.fin_cnt, s.boosts, s.wpns, s.score from %sscores s join %splayers p on s.user_id = p.user_id join (select user_id, min(score) minscore, count(*) fin_cnt from %sscores where map_name=^"%s^" group by user_id, wpns) g on p.user_id=g.user_id where map_name=^"%s^" and s.score=g.minscore order by s.score limit 20", |
//"select distinct p.alias, s.fin_time, s.cps, s.gcs, g.fin_cnt, s.boosts, s.wpns, s.score from %sscores s join %splayers p on s.user_id = p.user_id join (select user_id, min(score) minscore, count(*) fin_cnt from %sscores where map_name=^"%s^" group by user_id, wpns) g on p.user_id=g.user_id where map_name=^"%s^" and s.score=g.minscore order by s.score limit 20", |
| 3507 |
DB_PREFIX, DB_PREFIX, DB_PREFIX, mapname, mapname ) |
//DB_PREFIX, DB_PREFIX, DB_PREFIX, mapname, mapname ) |
| 3508 |
|
"select p.alias, s.fin_time, s.cps, s.gcs, g.fin_cnt, s.boosts, s.wpns, s.score, s.score_id from %sscores s join %splayers p on s.user_id = p.user_id join (select user_id, min(score) minscore, count(*) fin_cnt, score_id from %sscores where map_name=^"%s^" group by user_id, wpns) g on g.score_id=s.score_id order by s.score limit 20", |
| 3509 |
|
DB_PREFIX, DB_PREFIX, DB_PREFIX, mapname ) |
| 3510 |
|
|
| 3511 |
SQL_ThreadQuery( DB_TUPLE, "hs_handler", query, data, 1 ) |
SQL_ThreadQuery( DB_TUPLE, "hs_handler", query, data, 1 ) |
| 3512 |
ts_hscore = get_systime() |
ts_hscore = get_systime() |
Parent Directory
| 
Revision Log
| 
Patch