How to make a list of all players from all projects?

you will find here.
raffael
.
Posts: 51
Joined: Thu Aug 16, 2007 12:25 am

How to make a list of all players from all projects?

Postby raffael » Mon Mar 10, 2008 11:54 pm

I'd like to display all players from joomleague projects on one page, with such filters like Nationality, Position, A-Z and optionally with search input included. I have stored about 500 players, so it would be really nice if such feature would be available. Any hints?

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

Re: How to make a list of all players from all projects?

Postby comraden » Tue Mar 11, 2008 1:11 pm

Hi.
Example:
http://www.miastobasketu.pl/index.php?o ... &Itemid=86
http://www.llk.pl

Any filters included; version 0.91;
I could send U my file.... (only www.llk.pl)
...
ehhh, znalazłem twój post na polskim forum, możemy normalnie pogadać... a podobny wątek jest już u nas...
pozdro
Last edited by comraden on Tue Mar 11, 2008 1:24 pm, edited 1 time in total.
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

fistersn
.
Posts: 39
Joined: Wed Aug 15, 2007 5:11 pm
Contact:

Re: How to make a list of all players from all projects?

Postby fistersn » Fri Mar 14, 2008 5:02 pm

I also wants a list over all players from all projects.
Joomleague 0.93b
Joomla 1.0.15 at Homepage: http://sulkesligaen.no
TEST SYSTEM
Joomla 1.5.14
JoomLeague 1.5.03a at Homepage: http://erlend.sulkesligaen.no

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

Re: How to make a list of all players from all projects?

Postby comraden » Fri Mar 14, 2008 6:14 pm

Here You are file:
http://www.joomleague.de/forum/polish_f ... 392.0.html

Atention: version 0.91, not tested in 0.92 (mayby should work fine >:D)
Some garbage inside....I don't have a time, sorry.
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

fistersn
.
Posts: 39
Joined: Wed Aug 15, 2007 5:11 pm
Contact:

Re: How to make a list of all players from all projects?

Postby fistersn » Fri Mar 14, 2008 11:18 pm

How do I install this script? I can't read polish  :biggrin:
Joomleague 0.93b
Joomla 1.0.15 at Homepage: http://sulkesligaen.no
TEST SYSTEM
Joomla 1.5.14
JoomLeague 1.5.03a at Homepage: http://erlend.sulkesligaen.no

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

Re: How to make a list of all players from all projects?

Postby comraden » Sat Mar 15, 2008 1:51 am

1. Install plugin JUMI (or other...)
2. Add article and put in: {jumi [includes/league/players.php]}
3. Put the file players.php in /includes/league/
4. Change the sql query (from which project You want the players get):
    "where (j.id >4) and (j.id<10)" mean U want players from project ID 5, 6, 7, 8, 9.
5. For example U want project ID 1, 5, 12:
    "where (j.id=1) or (j.id=5) or (j.id=12)"
6. Some question? post here... and pleeeeease show me your site if U need help. >:D
Last edited by comraden on Sat Mar 15, 2008 2:03 am, edited 1 time in total.
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

fistersn
.
Posts: 39
Joined: Wed Aug 15, 2007 5:11 pm
Contact:

Re: How to make a list of all players from all projects?

Postby fistersn » Sat Mar 15, 2008 9:16 am

I got it work.  :biggrin:. Thanks for the help.

There seems to be some errors, some of the players does not exist and some of the links are linked to wrong players.

By the way is there a way to sort them after letters?

sulkesligaen.net/index.php?option=com_content&task=view&id=174&Itemid=160
Last edited by fistersn on Sat Mar 15, 2008 9:22 am, edited 1 time in total.
Joomleague 0.93b
Joomla 1.0.15 at Homepage: http://sulkesligaen.no
TEST SYSTEM
Joomla 1.5.14
JoomLeague 1.5.03a at Homepage: http://erlend.sulkesligaen.no

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

Re: How to make a list of all players from all projects?

Postby comraden » Sat Mar 15, 2008 8:58 pm

These errors are from version 0.92 (I guess..)
I'll do it tonight, please wait.
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: 1291
Joined: Thu Aug 16, 2007 2:27 pm
Location: Poland, Lublin
Contact:

Re: How to make a list of all players from all projects?

Postby comraden » Sun Mar 16, 2008 3:26 am

// version 0.10
// file generating list of players from all joomleague project
// joomleague 0.92 & joomla 1.5.1 & Jumi plugin 1.02 for joomla 1.5.x
// Templates/Player_information/Show_player_history set YES in all projects

New version.
Wishes post here.
Sort after letters? hmmm, give mi 3 days..... and send me Your database.
I support only Joomla_1.5.1, Joomleague_0.92.
How it look? Here:
http://212.182.64.1/~joomla3/index.php? ... 1&Itemid=3

[gelöscht durch Administrator]
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

dnaef
Newbie
Posts: 2
Joined: Thu Jul 02, 2009 11:20 am
Contact:

Re: How to make a list of all players from all projects?

Postby dnaef » Fri Jul 03, 2009 8:28 pm

I gone reanimate this thread, sorry ;-) The little trick you offered seems a good starting point for what I wanna do:

I'd like to have a list of all players from all projects with all the stats from all the events showing. Clear so far? As a said, inlcuding player.php with Jumi gives me a list of all players. And now, how can I get the stats? I'm sorry but I only understand the most basic php-commands ...

I hope you can help me  :help:

URL: http://wyss2.2simmen.ch -> it would be the menu point "Teamstatistiken"
Joomleague 0.93, Joomla 1.0.15

Thanks a lot in advance!

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

Re: How to make a list of all players from all projects?

Postby comraden » Fri Jul 03, 2009 9:35 pm

I've made something like this:
http://llk.pl/index.php?option=com_cont ... &Itemid=90
This show only 50 players by default, but could all.....
Send U file? >:D

edit:
Link from player name & team name doesn't work, beta version....he he.
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

dnaef
Newbie
Posts: 2
Joined: Thu Jul 02, 2009 11:20 am
Contact:

Re: How to make a list of all players from all projects?

Postby dnaef » Fri Jul 03, 2009 10:10 pm

Thanks for the fast response! Looks good. Can it be modified in a simple way to show all stats at once? The limitation to 50 players wouldn't be any problem at all ;-)

To point out my idea a bit better:
On the player's profil page you got in the section Stats history the career total of all events of a player. The only thing to do would be to list these career totals from every player and sort them by some criteria ...

Sending the file would be great --> I made my address visible I think ...

Thanks again!

nova_13
Newbie
Posts: 6
Joined: Wed Nov 03, 2010 1:06 pm

Re: How to make a list of all players from all projects?

Postby nova_13 » Wed Jun 08, 2011 2:11 pm

Hi Guys

I am also interested in creating a list with all players and over all projects or seasons.
We play Futsal wich is Indoor Soccer. So its not like, Basketball and Tennis. So its all about Goals, Red Cards, Yellow cards and so on.

All I need is the same you have when you look at the stats for a single player all on the bottom. There you have a "carreer stats".

I would like to get a list exactly with these figures.

Lets say:

Player 1: 12 Matches, 2 Goals, 3 Red Cards ...
Player 2: 10 Matches, 0 Goals, 0 Red Cards ...

Maybe Player 1 played in 2009 and Player 2 in 2010. No Problem, Its a historical thing.

Can you help me creating such a file?

Thanks,
Nova

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

Re: How to make a list of all players from all projects?

Postby comraden » Wed Jun 08, 2011 3:40 pm

it's a ooooooold topic...
last post was 2009 :whistling:
version, link to your www :knuppel:
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 “Tips, Tricks, SourceCodeChanges”

Who is online

Users browsing this forum: No registered users and 1 guest

cron