Apr 29, 2002, 03:48 AM | |
JDC question
In round 1, what's the difference between the Overall score and the Round score? Do the events not count?
It's confusing, imho. You click the name of the first ranked player on the round list, and you suddenly get stats where the player is suddenly 3rd. It's confusing to me. That probably means I'm not the only one. :P
__________________
Interesting Jazz-related links: Thread: Gameplay Theories - Thread: Make Up Your Own Gametype |
Apr 29, 2002, 11:23 AM | |
I'm changing a couple of things to clear this up. I'll post more about what I do after I change it.
|
Apr 29, 2002, 12:09 PM | |
Bobby explained most of this to me, but I still have another question.
If the point formula is: ((Total Roasts / (Total Roasts + Total Falls)) * 100) + (Number of Duels) won't your score go down if you have a really bad duel? Is this why it is divided into week-long rounds, and round points are added to your total score at the end? Or are they averaged too...
__________________
With our extreme gelatinous apology,
We beg to inform your Imperial Majesty, Unto whom be dominion and power and glory, There still remains that strange precipitate Which has the quality to resist Our oldest and most trusted catalyst. It is a substance we cannot cremate By temperatures known to our Laboratory. ~ E.J. Pratt |
Apr 29, 2002, 12:22 PM | |
Bleh! I dont like it like this way. I duel some guys. I win. I am first... It make no sense.
![]() Ow yeah, when will the battle events will be?
__________________
Bla. |
Apr 29, 2002, 12:24 PM | ||
Okay, I've added a personal page that is for rounds only so people won't get confused. The personal page shows the round details, while the overall has everything.
Quote:
I actually told you a formula that isn't exact cause I wanted to explain your case, but here is the real formula for points. Code:
((SUM(roasts)+SUM(ctf_points)+SUM(2on2_points)) /(SUM(falls)+SUM(ctf_falls)+SUM(2on2_falls)+(SUM(roasts)+SUM(ctf_points)+SUM(2on2_points)))*".roastfallfactor($round_id).") + (sum(opp_quality)/count(opp_quality)*".oppfactor($round_id).") + (count(*) * ".ptsperduel($round_id).") where round_id = '$round_id' group by username having duel_num >= '".duelstoscore($round_id)."' I'll go through the scoring and break it down into parts cause if you don't know the table structure and SQL and my variables it doesn't make sense :P Part one of the points: ((SUM(roasts)+SUM(ctf_points)+SUM(2on2_points)) /(SUM(falls)+SUM(ctf_falls)+SUM(2on2_falls)+(SUM(ro asts)+SUM(ctf_points)+SUM(2on2_points)))*".roastfallfactor($round_id).") Basically, this is getting the total roasts+ctfpoints+2on2points then dividing it by all roasts,falls,ctfpoints/falls and 2on2points/falls. This yields the overall kill:die ratio. Now that I have this kill:die ratio, I multiply it by a factor, generally for this it will be 100, but it can change for every round. Part 2: Next, is the opponent quality which I'm not going to explain right now since it is currently set to 0, meaning that it has no effect on this round. Part 3: (count(*) * ".ptsperduel($round_id).") This statement gets the total number of duels for the round and then multiplies it by the points per duel factor which may change every round. For round one it is set to 1. Other Stuff: duel_num >= '".duelstoscore($round_id)."' This line tell how many duels/2on2s are needed to get points for the round. Currently it is set to 2. *note* All factors used in the points may be found on the main news page. ICQ or reply here if you are not able to follow something, I wrote it in a hurry. |
Apr 29, 2002, 06:27 PM | |
The magical Having clause but of course! ;P
Other Stuff: duel_num >= '".duelstoscore($round_id)."' you need 2 duels for this round to get points for anything in the round. ![]() |
![]() |
«
Previous Thread
|
Next Thread
»
Thread Tools | |
|
|
All times are GMT -8. The time now is 05:22 AM.
Jazz2Online © 1999-INFINITY (Site Credits). Jazz Jackrabbit, Jazz Jackrabbit 2, Jazz Jackrabbit Advance and all related trademarks and media are ™ and © Epic Games. Lori Jackrabbit is © Dean Dodrill. J2O development powered by Loops of Fury and Chemical Beats. Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Original site design by Ovi Demetrian. DrJones is the puppet master. Eat your lima beans, Johnny.