Kick Off 2 signature generator LOOKING FOR ANOTHER DEVELOPER

Talk about EVERYTHING related to Kick Off 1 + 2.

Moderator: Moderators

User avatar
alkis21
Moderator
Moderator
Posts: 15014
Joined: Wed Jul 04, 2001 12:00 am
Location: Athens, Greece
Contact:

Postby alkis21 » Fri Nov 24, 2006 9:10 pm

YES!!! Finally, the signature is accurate!! As a stats freak, it killed me that everyone had a bunch of wrong stats as their signature just because it looked cool.

Image

Luigi, can I give you a better picture of the joystick I use? Just tell me how you want it (dimensions, angle etc.).
Remember, remember, the 4th and the 3rd of November
Image
User avatar
gdh82
6000+ Poster!
6000+ Poster!
Posts: 6197
Joined: Fri May 26, 2006 8:16 pm
Location: Birmingham, England

Postby gdh82 » Fri Nov 24, 2006 9:54 pm

Nice one guys for straightening out the Team A/B/N results clash on the database and signature. Much appreciated! :D
All the goals, the stats, the stories & more from the KO2 WC 2011 - please click here

And click here for everything you'll ever need to know about KO2!
User avatar
Il_Maestro
Newbie
Newbie
Posts: 395
Joined: Sat Jan 18, 2003 12:00 am
Location: Italy
Contact:

Postby Il_Maestro » Sat Nov 25, 2006 8:34 am

alkis21 wrote:Luigi, can I give you a better picture of the joystick I use? Just tell me how you want it (dimensions, angle etc.).

Suuure. Every image i have, to fit into the banner has to be 43*44: if it isn't, the program resize it automagically. The best should be an image of that proportion, almost a square, with a white or at least pretty light background for the shot.
Just to give you an example, look at the greek stick or competitionpro. :wink:
Image
Image
User avatar
Abyss
Moderator
Moderator
Posts: 5901
Joined: Wed Sep 18, 2002 12:00 am
Location: Athens, Greece
Contact:

Postby Abyss » Sat Nov 25, 2006 10:45 am

Just noticed the percentages next to the "scores for" and "scores against" (should really be "goals for" and "goals against" Luigi).

They are funny, e.g.
Luigi F
Goals for 1013 (66.86%)
Goals against 502 (33.14%)
User avatar
Il_Maestro
Newbie
Newbie
Posts: 395
Joined: Sat Jan 18, 2003 12:00 am
Location: Italy
Contact:

Postby Il_Maestro » Sat Nov 25, 2006 11:47 am

Abyss wrote:Just noticed the percentages next to the "scores for" and "scores against" (should really be "goals for" and "goals against" Luigi).

This is my awful english. Btw, Robert pointed it some post before and i fixed it everywhere but (...) in the regeneration routine.
Now it should be fine....after CTRL+F5.
Image

Image
User avatar
Il_Maestro
Newbie
Newbie
Posts: 395
Joined: Sat Jan 18, 2003 12:00 am
Location: Italy
Contact:

Postby Il_Maestro » Mon Dec 04, 2006 2:25 pm

Just updated with december rankings. Ctrl+F5.
Image

Image
User avatar
Tripod
2000+ Poster!
2000+ Poster!
Posts: 2728
Joined: Sun Apr 21, 2002 12:00 am
Location: Berlin, Germany
Contact:

Postby Tripod » Mon Dec 04, 2006 4:57 pm

For the first time I see the signatures with my brandnew TFT display. Oh, the picture is just so much sharper! I can now read everything easily (even though it's now smaller at 1280x1024 to previous 1024x768). I'm very happy with this monitor! (But I still suggest changing the layout a little :)).
WC Performances 2003: 28/31 - 2004: 14/43 - 2005: 17/63 - 2006: 31/50 - 2008: 12/41 - 2009: 14/34 - 2010: 24/46
User avatar
alkis21
Moderator
Moderator
Posts: 15014
Joined: Wed Jul 04, 2001 12:00 am
Location: Athens, Greece
Contact:

Postby alkis21 » Mon Dec 04, 2006 5:10 pm

Spyros, is there a way for the signature generator to show the active rankings instead of the total ones? I just noted that Alex's ranking in his signature is #127 instead of #55. Can this information be extracted from the database?
Remember, remember, the 4th and the 3rd of November
Image
User avatar
Abyss
Moderator
Moderator
Posts: 5901
Joined: Wed Sep 18, 2002 12:00 am
Location: Athens, Greece
Contact:

Postby Abyss » Mon Dec 04, 2006 10:47 pm

alkis21 wrote:Spyros, is there a way for the signature generator to show the active rankings instead of the total ones? I just noted that Alex's ranking in his signature is #127 instead of #55. Can this information be extracted from the database?


Of course it can be extracted from the db. How could the Stats Analyser display it otherwise?

Here is the sub that shows the rankings.

Code: Select all

Private Sub ShowRankings(Optional month As String = "")
    Dim sSql As String
    Dim sSQLWhere As String
    Dim iRow As Integer
    Dim sMonth As String
    Dim sPrevMonth As String
    Dim sTmp As String
    Dim dTmp As Date
    Dim sPrevPos()
    Dim i As Integer
    Dim n As Integer
    If giInitDone = 0 Then Exit Sub
    ReDim sPrevPos(UBound(gsPlayers))
    If month = "" Then
        sMonth = gsRankMonth
    Else
        sMonth = month
    End If
    sTmp = "01/" & Mid(sMonth, 2, 2) & "/" & Mid(sMonth, 4, 2)
    dTmp = DateAdd("m", -1, sTmp)
    sTmp = "R" & Format(dTmp, "mmyy")
    sPrevMonth = sTmp
    If sPrevMonth = "R1001" Then sPrevMonth = ""
   
    grdRankings.Visible = False
    grdRankings.Rows = 1
    sSql = "select player, " & sMonth & ", country from rankings where " & sMonth & " <>-1 "
   
    sSQLWhere = ""
    If giRankLimit = 1 Then sSQLWhere = " and (select count(player) from tables where player=rankings.player)  > 1 and activity<=24 "
    If cmbRankingFilter.ListIndex <> 0 Then
        sSQLWhere = sSQLWhere & " and country='" & cmbRankingFilter.List(cmbRankingFilter.ListIndex) & "'"
    End If
    sSql = sSql & sSQLWhere & " order by " & sMonth & " desc"
    gRes.Open sSql, oCon, 0, 1
    iRow = 1
    While Not gRes.EOF
        grdRankings.Rows = grdRankings.Rows + 1
        grdRankings.TextMatrix(grdRankings.Rows - 1, 0) = iRow
        grdRankings.TextMatrix(grdRankings.Rows - 1, 2) = gRes.fields("player")
        grdRankings.TextMatrix(grdRankings.Rows - 1, 3) = gRes.fields("country")
        grdRankings.TextMatrix(grdRankings.Rows - 1, 4) = gRes.fields(sMonth)
        gRes.movenext
        iRow = iRow + 1
    Wend
    gRes.Close
    If sPrevMonth <> "" Then
        gRes.Open "select player, " & sPrevMonth & ", " & sMonth & " from rankings where " & sMonth & "<>-1 " & sSQLWhere & " order by " & sPrevMonth & " desc", oCon, 0, 1
        iRow = 0
        While Not gRes.EOF
            iRow = iRow + 1
            For i = 0 To UBound(gsPlayers)
               
                If gsPlayers(i) = gRes.fields("player") Then
                    sPrevPos(i) = iRow
                    If gRes.fields(sPrevMonth) = "-1" Then sPrevPos(i) = "N"
                    'If gRes.fields(sPrevMonth) = "1000" Then sPrevPos(i) = "N"
                End If
            Next
            gRes.movenext
        Wend
        gRes.Close
        For i = 0 To UBound(gsPlayers)
            For n = 1 To grdRankings.Rows - 1
                If grdRankings.TextMatrix(n, 2) = gsPlayers(i) Then
                    If sPrevPos(i) <> "N" Then
                        grdRankings.TextMatrix(n, 1) = IIf(sPrevPos(i) - n <> 0, sPrevPos(i) - n, "-")
                    Else
                        grdRankings.TextMatrix(n, 1) = "New"
                    End If
                End If
            Next
        Next
        grdRankings.Col = 1
        For i = 1 To grdRankings.Rows - 1
            grdRankings.Row = i
            grdRankings.CellAlignment = 7
        Next
    End If
    grdRankings.Visible = True
End Sub



You are interested in the line

Code: Select all

If giRankLimit = 1 Then sSQLWhere = " and (select count(player) from tables where player=rankings.player)  > 1 and activity<=24 "


Append this to the sql query, iterate through the records and use a counter and increase it by one in each iteration to get each player's position. Thanks.
User avatar
Il_Maestro
Newbie
Newbie
Posts: 395
Joined: Sat Jan 18, 2003 12:00 am
Location: Italy
Contact:

Postby Il_Maestro » Tue Dec 05, 2006 6:45 am

Well, i could implementi this too: should i limit the signature to active players or put somewhere something to show if the player is active or not?
Probably i'm keen to the second one.
Image

Image
User avatar
alkis21
Moderator
Moderator
Posts: 15014
Joined: Wed Jul 04, 2001 12:00 am
Location: Athens, Greece
Contact:

Postby alkis21 » Tue Dec 05, 2006 11:05 am

The only difference between an active and an active player will be that the inactive player won't have his ranking displayed (like the #10 in your signature). The Rankings points and everything else can still be there.
Remember, remember, the 4th and the 3rd of November
Image
Freshmaker
Moderator
Moderator
Posts: 12025
Joined: Sat Apr 06, 2002 12:00 am
Location: Humlebæk, Denmark
Contact:

Postby Freshmaker » Tue Dec 05, 2006 12:02 pm

Well... I think the signature should be correct according to the official rankings.

Btw, I really appreciate all the work you guys are doing on this.
-----------------------------
Jørn F.M.
Founding member of FÖKOF (and FAKO).
The Aftertouch Podcast.
Wayne's and Nick's Carreer Ender
Manager of The People's Lockout!
Il portiere è mongoloide!
User avatar
Beckite
3000+ poster!
3000+ poster!
Posts: 3513
Joined: Wed Jun 27, 2001 12:00 am
Location: Glasgow,Scotland
Contact:

Postby Beckite » Tue Dec 05, 2006 12:43 pm

What Winston said.
“I drink too much. Will you tell me one great actor who doesn't drink?”


Robert Shaw

1927-1978

Who is online

Users browsing this forum: No registered users and 3 guests