Question to Events-Developer

Extensions / Customization for JoomLeague 1.6.
User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Question to Events-Developer

Postby Trubadix » Fri Mar 09, 2012 1:34 pm

Is it possible to get the right round_pos by constructing on using existing stored data?
round_pos=(x+y)%7+1

I tried with round_id but that's not the right one.
I think a developer is be able to say use x,y or no it's impossible.
Hopefully it's possible :p

Image
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Question to Events-Developer

Postby timoline » Fri Mar 09, 2012 2:34 pm

Dont knwo what you want here....round_pos? and that meanS?
And what if there are 20 or 40 or + rounds?
Joomla 1.5.x
Joomleague 1.5.....latest git version

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Fri Mar 09, 2012 3:45 pm

Dont knwo what you want here....round_pos?

Needed for special sportarts like shooting.

and that meanS?

Player can have a start on round 3 and on round 7, so therefore I need the position to place the event right.
See Picture. 1. Player starts on round 3. (for this example)


And what if there are 20 or 40 or + rounds?

for shooting impossible, only 7 possible.
So I'm working on an own extension for that.


More questions about?
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Fri Mar 09, 2012 7:19 pm

I have to say: I understood nothing.
Could you think about us like idiots and give us super simple explanation?
There are my questions:
1.Rounds go from 1 to 7, or from 7 to 1?
2.Which player starts on round 3?
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Fri Mar 09, 2012 7:49 pm

OK I try it on pictures example:
On each game on this divison only 3 players per team starts for a round.
For next round come.in/out possible.
player Brakhage starts up from 3.Runde, for him starts on round 1 and 2 player Schütte.
So Brakahges Evenst must be start on position 3.Runde
Now the users are confused, for each round only 3 players possible but 4 in the column with result because the placement for the event-result is wrong. All players starting 1.Runde but thats not true. A player can have his starts also on 2.Runde and 5.Runde so I need the event-results exactly on that column.

Better I can't explain into english, hopefully It's bit more clear as before.
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Fri Mar 09, 2012 9:41 pm

ok, now it's clear for me.
My next questions:
3."Round" on picture means "matchdays"?
4.Is this view from jl, or from your extension? Could you give a link for "better understanding" events assigment?
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Fri Mar 09, 2012 10:05 pm

3."Round" on picture means "matchdays"?

Yes It's the matchday.

Is this view from jl, or from your extension? Could you give a link for "better understanding" events assigment?


It's my try of extention ;)
Yes a link of my signature brings you to the testpage, and there use "Setzliste" from topmenue.
or
Use this one to the pictures example.
and
There you will find the event-details for each round
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Sat Mar 10, 2012 1:12 am

Oh by the way, I think what i need is the roundcode of joomleague_round :)
But how to get the turn from _match_event->match->round, to use roundcode :confused:
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Sat Mar 10, 2012 9:15 am

I have to say that your site is not clear for me :confused:

http://www.schuetzen-ligaverwaltung.shg ... Itemid=123
Here I see that Shulenburg win 2:1 with Einbeck.
Where could I see HOW Shulenburg got this "2"? What does mean "2"? Where are there events?
Nevermind ...

But how to get the turn from _match_event->match->round, to use roundcode

:bash:
Maybe use rounds model in matchreport model? Or in your_extension_model?
sth like:

Code: Select all

$mdlRounds = JModel::getInstance("Rounds","JoomleagueModel");
$mdlRounds =->setProjectId($project->id);
...

Or U have to forgot about my words ... :confused:
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Sat Mar 10, 2012 8:33 pm

Here I see that Shulenburg win 2:1 with Einbeck.
Where could I see HOW Shulenburg got this "2"? What does mean "2"? Where are there events?
Nevermind ...


I try to explain on an easy example:
team-a player of lineup-1(296) across team-b player of lineup-1(291)
team-a player of lineup-2(298) across team-b player of lineup-2(296)
team-a player of lineup-3(296) across team-b player of lineup-3(299)
So teamresult is 2:1


Maybe use rounds model in matchreport model? Or in your_extension_model?

Sorry had no idea to use "get rounds", where blind :whistling:
Trying to construct whild things instead of using the simple things :motz:
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Sat Mar 10, 2012 10:45 pm

Trubadix wrote:I try to explain on an easy example:
team-a player of lineup-1(296) across team-b player of lineup-1(291)
team-a player of lineup-2(298) across team-b player of lineup-2(296)
team-a player of lineup-3(296) across team-b player of lineup-3(299)
So teamresult is 2:1


kill me, could I see this in link:
http://www.schuetzen-ligaverwaltung.shg ... Itemid=123
:bash:
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Sun Mar 11, 2012 9:06 am

That crapped view is developers part, mean developer has to make her homework :whistling:
On this link you can see proper results of that game
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Sun Mar 11, 2012 9:50 am

1 lineup: A(296)-(291)B
2 lineup: A(298)-(296)B
3 lineup: A(296)-(299)B

What about this view? is it possible?
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Sun Mar 11, 2012 1:09 pm

Yes, means Team A win's 2:1
any result between 0-300 is possible on this liga/divison.
If result is even like 295:295 a shoot off ist starting and only ends when a winner is determined.
There, Völkersen-Döhlbergen-Rieda, you will find an example for hard shoot off
or
Ohr <-> Bennigsen on this link
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Sun Mar 18, 2012 2:36 pm

Now I found time to follow the Idea of get_round.
But that function only supports project but all my leagues are division-leagues.

So I starts to handle it with a SQL including the merge.
SELECT SUM(rd_me.event_sum) as rd_team_sum,
AVG(rd_me.event_sum) AS rd_schnitt,
rd_me.event_sum AS rd_round_sum,
rd_me.match_id AS rd_match_id,
rd_ma.round_id AS rd_round_id,
rd_tm.id AS rd_tid,
rd_pl.id AS rd_pid,
rd_ra.name AS rd_name,
rd_ra.roundcode AS rd_pos
FROM lgv_joomleague_match_event AS rd_me
INNER JOIN lgv_joomleague_team_player AS rd_tp ON rd_tp.id = rd_me.teamplayer_id
INNER JOIN lgv_joomleague_match AS rd_ma ON rd_ma.id = rd_me.match_id
INNER JOIN lgv_joomleague_person AS rd_pl ON rd_tp.person_id = rd_pl.id
INNER JOIN lgv_joomleague_project_team AS rd_pt ON rd_pt.id = rd_tp.projectteam_id
INNER JOIN lgv_joomleague_team AS rd_tm ON rd_tm.id = rd_pt.team_id
INNER JOIN lgv_joomleague_round AS rd_ra ON rd_ra.id = rd_ma.round_id
WHERE rd_me.event_type_id=1
AND rd_pl.published =1
AND rd_pt.project_id=19
AND rd_pt.division_id=159
GROUP BY rd_me.id
ORDER BY rd_tm.id, rd_pl.id, rd_me.match_id ASC


But what a surprise, it only works for divison-leagues who has no more then 5 rounds.
If they are playing more then 5 rounds it goes fully wrong by assign 2 results to the same round but that's not true.
Example echo of non working 7 round result:
Nanko, Bernd '09-15-064-0000'
Match- 661 RoundId-109 Pos- 1 Text: 1. DG LGA RdPos-1 Round_Sum-295/
Match- 666 RoundId-108 Pos- 2 Text: 2. DG LGA RdPos-2 Round_Sum-295/
Match- 670 RoundId-107 Pos- 3 Text: 3. DG LGA RdPos-3 Round_Sum-297/
Match- 672 RoundId-107 Pos- 3 Text: 3. DG LGA RdPos-3 Round_Sum-296/

Match- 680 RoundId-104 Pos- 5 Text: 5. DG LGA RdPos-5 Round_Sum-297/
Match- 684 RoundId-105 Pos- 6 Text: 6. DG LGA RdPos-6 Round_Sum-294/
Match- 688 RoundId-103 Pos- 7 Text: 7. DG LGA RdPos-7 Round_Sum-298/


Example echo for an working 5 round result:
Schmidt, Herbert '09-23-008-0000'
Match- 1897 RoundId-147 Pos- 1 Text: 1. DG 09-23-KrsLi LG/LP/LGA RdPos-11 Round_Sum-318/
Match- 1902 RoundId-149 Pos- 3 Text: 3. DG 09-23-KrsLi LG/LP/LGA RdPos-13 Round_Sum-333/
Match- 2011 RoundId-150 Pos- 4 Text: 4. DG 09-23-KrsLi LG/LP/LGA RdPos-14 Round_Sum-327/
Match- 2103 RoundId-151 Pos- 5 Text: 5. DG 09-23-KrsLi LG/LP/LGA RdPos-15 Round_Sum-314/


So I'm fully confused!
Are my match_event-table wrong or my SQL bullshit?
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Mon Mar 19, 2012 1:58 am

I didn't test it, but only one question:
How many matches were in your round (for example round_id=107)?
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Mon Mar 19, 2012 5:42 am

Hope It's what you requested.
joomleague_round
107 19 3 3. DG LGA spietag-3 2011-11-19 2011-11-19

joomleague_match
669 107 NULL 214 318 NULL 2011-11-19
670 107 NULL 212 215 NULL 2011-11-19
671 107 NULL 318 215 NULL 2011-11-19
672 107 NULL 214 212 NULL 2011-11-19

joomleague_match_event
15622 669 214 595 0 1 289
15623 669 214 594 0 1 286
15624 669 214 593 0 1 289
15625 669 318 905 0 1 297
15626 669 318 908 0 1 288
15627 669 318 907 0 1 292
15628 670 212 920 0 1 292
15629 670 212 588 0 1 291
15630 670 212 589 0 1 297
15631 670 215 918 0 1 287
15632 670 215 597 0 1 285
15633 670 215 598 0 1 286
15634 671 318 905 0 1 297
15635 671 318 908 0 1 289
15636 671 318 907 0 1 287
15637 671 215 918 0 1 289
15638 671 215 597 0 1 286
15639 671 215 598 0 1 292
15640 672 214 595 0 1 288
15641 672 214 594 0 1 289
15642 672 214 593 0 1 289
15643 672 212 920 0 1 293
15644 672 212 589 0 1 296
15645 672 212 922 0 1 286
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Mon Mar 19, 2012 1:27 pm

The 5 round View
Image

The 7 round View
Image
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Mon Mar 19, 2012 11:26 pm

I have to say, hard to follow your ext without example data ...
My priority is finish treerank ext now, so maybe later.
By the way: in treerank admin could choose rounds for ranking calculation.
But, as I said, without data I'm blind.....
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Tue Mar 20, 2012 12:03 am

Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Sun Mar 25, 2012 9:11 am

Could U send me export file of this project (admin@llk.pl)? I'll test it with treerank ..
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
Trubadix
.
Posts: 338
Joined: Fri Oct 24, 2008 4:35 pm
Joomleague version: 2.0.x
Location: 31542
Contact:

Re: Question to Events-Developer

Postby Trubadix » Sun Mar 25, 2012 2:33 pm

Please have a look above to "Tables of my leagues"
JLG-Files on the way.
Last edited by Trubadix on Sun Mar 25, 2012 2:46 pm, edited 1 time in total.
Life-System : Joomla 2.5.28 auf Strato, Joomleague 2.0.x
http://www.shootingleague.de/
Test-System: Joomla 3.6.x auf Strato, Joomleague 3.0.x
http://ligatest.ksv-nesselblatt.de/

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Sun Mar 25, 2012 2:36 pm

But there is sql dump ...
Please send me *jlg file as a EXPORT project
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum

User avatar
comraden
Joomleague Core Developer
Joomleague Core Developer
Posts: 1284
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: Question to Events-Developer

Postby comraden » Thu Mar 29, 2012 9:11 am

done (only as pure html)
landesliga
team->Etelsen
event->Gesamt
You do not have the required permissions to view the files attached to this post.
http://llk.pl::jl_1.6 | jl_2.x | jl_3.x testing/production enviroment
samiec alfa koncernu 'Cham_Burak_Prostak' || proved: the most annoying person on the forum


Return to “Extensions / Customizations”

Who is online

Users browsing this forum: No registered users and 1 guest

cron