Raised This Month: $12 Target: $400
 3% 

[L4D1 & L4D2] DragoStats Coop


Post New Thread Reply   
 
Thread Tools Display Modes
Dragokas
Veteran Member
Join Date: Nov 2017
Location: Ukraine on fire
Old 12-16-2019 , 09:42   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #11

Actually, all positive aspects of using MySQL here is to decrease server's loading, since usually MySQL installed on separate server.
These benefits are lost when you install database on the same machine.
So, it's better to have separate hosting with MySQL (with option allowing external connections).

I could append plugin with option to use sqlite driver (database in local files).
But, it require significant additions and testing.
__________________
Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch & FreeZone)
[My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]
Dragokas is offline
tlch0324
Senior Member
Join Date: Jan 2007
Old 12-21-2019 , 01:27   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #12

Quote:
Originally Posted by Dragokas View Post
Actually, all positive aspects of using MySQL here is to decrease server's loading, since usually MySQL installed on separate server.
These benefits are lost when you install database on the same machine.
So, it's better to have separate hosting with MySQL (with option allowing external connections).

I could append plugin with option to use sqlite driver (database in local files).
But, it require significant additions and testing.
ok, thanks
tlch0324 is offline
ur5efj
Member
Join Date: Jan 2006
Old 12-22-2019 , 04:51   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #13

Плагин работает неделю на сервере L4D2. У лидеров статистики уже более 1000 очков. В базе данных в столбцах Infected и Witch у всех ноли. Начисление очков по умолчанию. Готов оказать помощь в проверке работы плагина.

translate.google.com
The plugin works for a week on the L4D2 server. The statistics leaders have over 1000 points. In the database, the Infected and Witch columns all have zeros. Scoring by default. Ready to assist in checking the plugin.
ur5efj is offline
Dragokas
Veteran Member
Join Date: Nov 2017
Location: Ukraine on fire
Old 12-22-2019 , 08:00   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #14

Спасибо за извещение. Я свяжусь с вами чуть позже.

Thank you for report. I'll contact you later.
__________________
Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch & FreeZone)
[My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]
Dragokas is offline
ur5efj
Member
Join Date: Jan 2006
Old 12-22-2019 , 12:53   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #15

Вдогонку. При включении DEBUG в чате пишет про всех убитых кроме common infected и witch.
Установленный плагин https://forums.alliedmods.net/showthread.php?t=114210 считает common infected.
Установленный плагин https://forums.alliedmods.net/showthread.php?t=222674 выдает щит за ведьму.

translate.google.com
Following up. When you turn on DEBUG in a chat, it writes about all those killed except common infected and witch.
The installed plugin https://forums.alliedmods.net/showthread.php?t=114210 considers it common infected.
The installed plugin https://forums.alliedmods.net/showthread.php?t=222674 gives a shield for a witch.
ur5efj is offline
Dragokas
Veteran Member
Join Date: Nov 2017
Location: Ukraine on fire
Old 12-24-2019 , 09:07   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #16

Updated.

Quote:
1.0.7 (24-Dec-2019)
- Fixed double-save points on player disconnect caused no points are saved at all (in L4D2).
- Fixed 'Witch' and 'Commons' points are not counted (in L4D2).
- 'Description of points' screen is splitted into 2 parts (for L4D2), because they doesn't fit in one.
- "Rank of other player" is now displayed in correct (requestor) language.
- Added command: "sm_hx_delplayer" <SteamId> - delete statistics of this player completely.
- Added command: "sm_hx_delold" <days> - delete players who didn't join for more than <days> ago (it is recommnded to use with `sm_hx_backup` first)
- Added ability to disable some fields in statistics (you just need to set '0' points in ConVars where you want).
- Added ability to hide some players from statistics (requested by Re:Creator).
See "l4d_hxstat_hide_flag" ConVar. Offline players are not supported. They should join the server at least once to populate database.

* DataBase Table version is now 2.3. Use "sm_hx_upgrade" to upgrade.

* Web-site files (index.php) are updated!
__________________
Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch & FreeZone)
[My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]

Last edited by Dragokas; 12-24-2019 at 09:07.
Dragokas is offline
ur5efj
Member
Join Date: Jan 2006
Old 12-26-2019 , 12:18   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #17

hx_stats.phrases.txt:
Code:
"Phrases"
{
	"Infected+"
	{
		"#format"	"{1:i},{2:i}"
		"ru"		"{1} Зомби {orange}+{2}"
		"en"		"{1} Zombie {orange}+{2}"
	}
Все эти сообщения в чат идут белые. Цвет не изменяется.

translate.google.com
All these chat messages go white. Color does not change.

Last edited by ur5efj; 12-26-2019 at 16:20. Reason: add
ur5efj is offline
Dragokas
Veteran Member
Join Date: Nov 2017
Location: Ukraine on fire
Old 12-26-2019 , 15:27   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #18

???
__________________
Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch & FreeZone)
[My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]
Dragokas is offline
ur5efj
Member
Join Date: Jan 2006
Old 01-08-2020 , 09:56   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #19

Нашел в логах:
Code:
L 01/06/2020 - 00:42:14: SourceMod error session started
L 01/06/2020 - 00:42:14: Info (map "c1m1_hotel") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20200106.log")
L 01/06/2020 - 00:42:14: [SM] Exception reported: Invalid time/Некорректное время (604800)
L 01/06/2020 - 00:42:14: [SM] Blaming: vip\VIP_Core.smx
L 01/06/2020 - 00:42:14: [SM] Call stack trace:
L 01/06/2020 - 00:42:14: [SM]   [0] ThrowNativeError
L 01/06/2020 - 00:42:14: [SM]   [1] Line 467, vip/API.sp::Native_SetClientAccessTime
L 01/06/2020 - 00:42:14: [SM]   [3] VIP_SetClientAccessTime
L 01/06/2020 - 00:42:14: [SM]   [4] Line 2211, l4d2_hx_stats.sp::GiveVIP
L 01/06/2020 - 00:42:14: [SM]   [5] Line 1263, l4d2_hx_stats.sp::Timer_GiveAwardVIP
L 01/06/2020 - 00:44:29: Error log file session closed.
L 01/06/2020 - 00:45:06: SourceMod error session started
L 01/06/2020 - 00:45:06: Info (map "c1m2_streets") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20200106.log")
L 01/06/2020 - 00:45:06: [SM] Exception reported: Invalid time/Некорректное время (604800)
L 01/06/2020 - 00:45:06: [SM] Blaming: vip\VIP_Core.smx
L 01/06/2020 - 00:45:06: [SM] Call stack trace:
L 01/06/2020 - 00:45:06: [SM]   [0] ThrowNativeError
L 01/06/2020 - 00:45:06: [SM]   [1] Line 467, vip/API.sp::Native_SetClientAccessTime
L 01/06/2020 - 00:45:06: [SM]   [3] VIP_SetClientAccessTime
L 01/06/2020 - 00:45:06: [SM]   [4] Line 2211, l4d2_hx_stats.sp::GiveVIP
L 01/06/2020 - 00:45:06: [SM]   [5] Line 1263, l4d2_hx_stats.sp::Timer_GiveAwardVIP
L 01/06/2020 - 00:56:38: Error log file session closed.
L 01/06/2020 - 00:57:14: SourceMod error session started
L 01/06/2020 - 00:57:14: Info (map "c1m3_mall") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20200106.log")
L 01/06/2020 - 00:57:14: [SM] Exception reported: Invalid time/Некорректное время (604800)
L 01/06/2020 - 00:57:14: [SM] Blaming: vip\VIP_Core.smx
L 01/06/2020 - 00:57:14: [SM] Call stack trace:
L 01/06/2020 - 00:57:14: [SM]   [0] ThrowNativeError
L 01/06/2020 - 00:57:14: [SM]   [1] Line 467, vip/API.sp::Native_SetClientAccessTime
L 01/06/2020 - 00:57:14: [SM]   [3] VIP_SetClientAccessTime
L 01/06/2020 - 00:57:14: [SM]   [4] Line 2211, l4d2_hx_stats.sp::GiveVIP
L 01/06/2020 - 00:57:14: [SM]   [5] Line 1263, l4d2_hx_stats.sp::Timer_GiveAwardVIP
L 01/06/2020 - 01:02:37: [SM] Exception reported: Invalid time/Некорректное время (604800)
L 01/06/2020 - 01:02:37: [SM] Blaming: vip\VIP_Core.smx
L 01/06/2020 - 01:02:37: [SM] Call stack trace:
L 01/06/2020 - 01:02:37: [SM]   [0] ThrowNativeError
L 01/06/2020 - 01:02:37: [SM]   [1] Line 467, vip/API.sp::Native_SetClientAccessTime
L 01/06/2020 - 01:02:37: [SM]   [3] VIP_SetClientAccessTime
L 01/06/2020 - 01:02:37: [SM]   [4] Line 2211, l4d2_hx_stats.sp::GiveVIP
L 01/06/2020 - 01:02:37: [SM]   [5] Line 1263, l4d2_hx_stats.sp::Timer_GiveAwardVIP
L 01/06/2020 - 01:06:00: Error log file session closed.
L 01/06/2020 - 01:06:33: SourceMod error session started
L 01/06/2020 - 01:06:33: Info (map "c1m4_atrium") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20200106.log")
L 01/06/2020 - 01:06:33: [SM] Exception reported: Invalid time/Некорректное время (604800)
L 01/06/2020 - 01:06:33: [SM] Blaming: vip\VIP_Core.smx
L 01/06/2020 - 01:06:33: [SM] Call stack trace:
L 01/06/2020 - 01:06:33: [SM]   [0] ThrowNativeError
L 01/06/2020 - 01:06:33: [SM]   [1] Line 467, vip/API.sp::Native_SetClientAccessTime
L 01/06/2020 - 01:06:33: [SM]   [3] VIP_SetClientAccessTime
L 01/06/2020 - 01:06:33: [SM]   [4] Line 2211, l4d2_hx_stats.sp::GiveVIP
L 01/06/2020 - 01:06:33: [SM]   [5] Line 1263, l4d2_hx_stats.sp::Timer_GiveAwardVIP
L 01/06/2020 - 01:06:42: [SM] Exception reported: Invalid time/Некорректное время (604800)
L 01/06/2020 - 01:06:42: [SM] Blaming: vip\VIP_Core.smx
L 01/06/2020 - 01:06:42: [SM] Call stack trace:
L 01/06/2020 - 01:06:42: [SM]   [0] ThrowNativeError
L 01/06/2020 - 01:06:42: [SM]   [1] Line 467, vip/API.sp::Native_SetClientAccessTime
L 01/06/2020 - 01:06:42: [SM]   [3] VIP_SetClientAccessTime
L 01/06/2020 - 01:06:42: [SM]   [4] Line 2211, l4d2_hx_stats.sp::GiveVIP
L 01/06/2020 - 01:06:42: [SM]   [5] Line 1263, l4d2_hx_stats.sp::Timer_GiveAwardVIP
L 01/06/2020 - 01:11:23: Error log file session closed.
Это моя ошибка с разными вип группами?
ur5efj is offline
Dragokas
Veteran Member
Join Date: Nov 2017
Location: Ukraine on fire
Old 01-09-2020 , 04:05   Re: [L4D1/2] HxStats Coop Remastered
Reply With Quote #20

Updated.

Quote:
1.0.10 (09-Jan-2020)
- Fixed error in log and disabled 'win' message for client with permanent VIP status (thanks to ur5efj for report).
- VIP_GROUP define is replaced by new "l4d_hxstat_vip_group" ConVar (for easy update).
- BASE_MENU define is replaced by new "l4d_hxstat_base_menu" ConVar (for easy update).

1.0.9 (03-Jan-2020)
- Potential fix: to prevent SQL query cache cause move week points twice (I hope).
- Disabled DB disconnection on round end.

1.0.8 (26-Dec-2019)
- Fixed chat messages are displayed even if points are disabled.
Use e.g. Cfg Updater to add new ConVars to your config automatically.
__________________
Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch & FreeZone)
[My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]

Last edited by Dragokas; 01-09-2020 at 04:07.
Dragokas is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:39.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode