Subject: New NTDB Database

Sure, when I say "Form" you can understand all public info on the player:

- Transfer status
- NT cards
- Form
- Wage and value
- Injuries
- First and Current club (for use with the sk@ tool)
- Age


Also, just a little tip:

After you run a complete update, some players (RETIRED FROM SOKKER) are marked as ARCHIVED. Only active players are updated here.
Run it again choosing the ARCHIVED position in order to update info on ARCHIVED players too.
Finally, run your update on ARCHIVED position one time more. You'll see a list of RETIRED players. You can now easily locate and delete them manually.
(edited)

on the players page i have added little hover bars over the players skills. I know some people struggle with what is skill 13 again for example. So now if you hover over the number 13 it will show you the corresponding skill in your corresponding language
(edited)

Great job. It was a very old demand.

;)


I have 2 more ideas, but no time on this moment:

In the Update Form tool (be carefull with versions, I did some changes recently), when a player is retired we could put a link to the player deletion. In this way, people can easily remove them from the DB.

In the manage players page, we could add some jQuery. I think the easiest would be to separate the screen in 2 big DIVs (top, bottom). Then add the .draggable property to each <A> inside of them. Set parameters (FROM/TO as div_in/div_out) and finally add a $.post to the manageplayers.php (if in, add to rolespid - if out remove from rolespid).

Without using jQuery UI, we have also an option. Remove the image and add checkbox to each player. Change the action of images to buttons somewhere (add selected/remove selected/select all/unselect all). In the manageplayers.php page, change the GET(PID) for a LOOP(GET(CHBX)) and finally the insert into, a loop(insert into).

What do you think about? Even if you're also busy now, we can discuss for future changes.

pity its impossible to sort players by form, as they not showed just as other skills (and should be)
i already got 25-30 playwers for every position, so sorting by form would be nice (even if i choose only those with form 14+ its still to much). and selecting only those with 17 form is to restrictive:/

Choosing 14+, and using 16- in red and 18 in green would help? Adding a new column will force some languages to have the page deformed.

well, i know i do that. just asking, if it would be a problem.
anyway good that form is included!

let me look into that mate. I suspect the best way forward for this would be check boxes.

check boxes would be perfect :)

NT DATA BASE BiH
Requirements:
ATT
Primary: Striker (13)
Secondary: Pace + Technique (25)

ATT U21 (U21)
Primary: Striker (10)
Secondary: Pace + Technique (20)

DEF
Primary: Defender (15) / Pace (11)
Secondary: Passing + Technique + Playmaking (25)

DEF MID
Primary: Pace (12) / Defender (12) / Playmaking (9)
Secondary: Technique + Passing (20)

DEF U21 (U21)
Primary: Defender (10) / Pace (9)
Secondary: Technique + Playmaking + Passing (15)

GK
Primary: Keeper (15)
Secondary: Passing + Pace (10)

GK U21 (U21)
Primary: Keeper (10)
Secondary: Pace + Passing (10)

MID
Primary: Playmaking (10) / Passing (11) / Pace (11)
Secondary: Pace + Technique + Defender (30)

MID U21 (U21)
Primary: Playmaking (8) / Passing (8)
Secondary: Pace + Technique + Defender (15)
(edited)

ok doky checkboxes added to the assign players part. Its not exactly fancy but ive never claimed to be arty farty.

extremely useful, thanks :)

i have a question. I have the best 16 years goalkeeper, but i cant show that because in the page still are 17 players in the list of 16 years players. the program should actualize automaticatly in the change of the season to fix this.

What do you think?

Sorry for my english

goto requirements and update form. Enter your sokker username and sokker password. All your players will then get updated (age, form, value) etc

but the it is not for mine, it is for the others that still appears like 16 years player and they dont have it

The Update Form (form, wage, value, cards, injury, transfer status) download public info. So, you can update any player.

@rtg: thx for the solution

What am I doing wrong?

A player is in the DB which fits both the requirements for U21DEF and U21MID. When I go to "players" and select "position" U21DEF or U21MID and I push Update, I don't get any results.