Which language do I need to study?

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Which language do I need to study?

Postby ThisisJP » Tue Jan 24, 2023 7:22 pm

Which language is needed to study to do advanced stats and report filters?
for example:
[...] exists(select 1 from tourney_hand_player_statistics hero where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero and hero.position = 9) [...]

thanks
ThisisJP
 
Posts: 16
Joined: Thu Apr 07, 2011 9:43 am

Re: Which language do I need to study?

Postby Flag_Hippo » Wed Jan 25, 2023 6:44 am

That is a subquery used for 'vs Hero' custom statistics. These types of query are used if you want information about a player different from the one the stat is written for however using these types of queries means that the database cache cannot be used. For more on how SELECT works see here and from there you can also access further PostgreSQL documentation.
Flag_Hippo
Moderator
 
Posts: 13016
Joined: Tue Jan 31, 2012 7:50 am

Re: Which language do I need to study?

Postby ThisisJP » Fri Jan 27, 2023 1:28 am

Thanks.
So mostly I should study postgreSql queries, that I can find on that documentation.
ThisisJP
 
Posts: 16
Joined: Thu Apr 07, 2011 9:43 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 2 guests

cron
highfalutin