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

CSstatsX SQL


Post New Thread Reply   
 
Thread Tools Display Modes
Hamartia
Member
Join Date: Oct 2015
Old 05-15-2016 , 23:40   Re: CSstatsX SQL
Reply With Quote #11

Great job. Thank you.
__________________
Hamartia is offline
GordonFreeman (RU)
Veteran Member
Join Date: Jan 2010
Location: Uzbekistan
Old 05-16-2016 , 02:21   Re: CSstatsX SQL
Reply With Quote #12

v. 0.7 Dev 2
- Added player connects, team joins and team wins stats.

Update your table by importing csstats_06_to_07.sql.
API for new stats will be added soon.

Currently i'm working on map stats. I'm found how to do map stats without additional queries from plugin. Map stats will be count on mysql/sqlite side by triggers.
Attached Files
File Type: sma Get Plugin or Get Source (csstatsx_sql.sma - 776 views - 86.8 KB)
File Type: zip csstats_06_to_07.zip (288 Bytes, 141 views)
__________________
The functional way is the right way

Last edited by GordonFreeman (RU); 05-16-2016 at 06:06.
GordonFreeman (RU) is offline
GordonFreeman (RU)
Veteran Member
Join Date: Jan 2010
Location: Uzbekistan
Old 05-16-2016 , 05:57   Re: CSstatsX SQL
Reply With Quote #13

I did
Map stats by both mysql and sqlite triggers.

v. 0.7 Dev 3
- Added map stats.

You need update your csstats table again. For map stats you need import csstats_map.sql file and set csstats_sql_maps cvar to 1.
This will create csstats_maps table for map stats and apply stats triggers for csstats table.

API and enhanced statsx plugin will coming soon.
Attached Thumbnails
Click image for larger version

Name:	2016-05-16_15-00-12.png
Views:	764
Size:	60.2 KB
ID:	154736  
Attached Files
File Type: sma Get Plugin or Get Source (csstatsx_sql.sma - 916 views - 88.4 KB)
File Type: zip csstatsx-sql.zip (3.1 KB, 173 views)
__________________
The functional way is the right way

Last edited by GordonFreeman (RU); 05-16-2016 at 06:06.
GordonFreeman (RU) is offline
Hamartia
Member
Join Date: Oct 2015
Old 05-16-2016 , 06:05   Re: CSstatsX SQL
Reply With Quote #14

I am little confused here. Is replacing the csstatsx module necessary or its just optional ? If optional, is there any advantage of replacing the module ?
__________________
Hamartia is offline
GordonFreeman (RU)
Veteran Member
Join Date: Jan 2010
Location: Uzbekistan
Old 05-16-2016 , 06:08   Re: CSstatsX SQL
Reply With Quote #15

Quote:
Originally Posted by Hamartia View Post
I am little confused here. Is replacing the csstatsx module necessary or its just optional ? If optional, is there any advantage of replacing the module ?
Replacing CSX module is optional. Replacement is only need if you don't know/want to edit your stats plugins for use stats from db (How to add support instruction).
__________________
The functional way is the right way
GordonFreeman (RU) is offline
Hamartia
Member
Join Date: Oct 2015
Old 05-16-2016 , 06:14   Re: CSstatsX SQL
Reply With Quote #16

Quote:
Originally Posted by GordonFreeman (RU) View Post
Replacing CSX module is optional. Replacement is only need if you don't know/want to edit your stats plugins for use stats from db (How to add support instruction).
Oh understood. Thank you.
__________________
Hamartia is offline
siriusmd99
Veteran Member
Join Date: Oct 2013
Location: Republic of Moldova
Old 05-25-2016 , 10:43   Re: CSstatsX SQL
Reply With Quote #17

Заебись блядь

Does it have option to edit stats like set_user_stats?
siriusmd99 is offline
GordonFreeman (RU)
Veteran Member
Join Date: Jan 2010
Location: Uzbekistan
Old 05-25-2016 , 13:22   Re: CSstatsX SQL
Reply With Quote #18

Quote:
Originally Posted by siriusmd99 View Post
Does it have option to edit stats like set_user_stats?
Нет, but you can edit db table instead.
I don't saw any plugins using set_user_stats from csxe, so its looks like useless stuff kek.
__________________
The functional way is the right way
GordonFreeman (RU) is offline
siriusmd99
Veteran Member
Join Date: Oct 2013
Location: Republic of Moldova
Old 05-25-2016 , 16:40   Re: CSstatsX SQL
Reply With Quote #19

I saw such a plugin it's named csx extended made by souvikdas95, it has that option.
I experienced a really bad moment when I tried to block death count for zombies on basebuilder server because players weren't attacking humans to not loose rank. And I was needed to recompile source code of the csx module.

But it's OK, I don't think someone else would experience such a necessity to block deaths count or to change frags number.

Good Job, really easy to use.
siriusmd99 is offline
quLeryuzz
Member
Join Date: May 2010
Location: Istanbul
Old 06-17-2016 , 19:12   Re: CSstatsX SQL
Reply With Quote #20

I tried and it is working perfect. Really easy to use.
Thank you.
http://mrgaming.org/serveristatistikleri.php
__________________

csduragi.com
quLeryuzz 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 07:46.


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