Roster Page

[JPDeni]

(I looked at your pages. One of your members has an animated avatar that looks like a teenage mutant ninja turtle.  It's nice to get that kind of a laugh this early in the morning. I may have to go look at that again.)

Heck, Jacob, you could probably do it all with one page!  Hmmmmm. I think we should give it a try. This is really slick. If it works.

At the beginning of the code, right under the "global" line, add

Code Select Expand


if (isset($_GET['rteam']))
  $rteam = ' AND FIND_IN_SET('. $_GET['rteam'] . ',additionalGroups)';
else
  $rteam = '';


Change

Code Select Expand

    WHERE ID_GROUP = '" . $groups[$rank]['id'] . "' ", __FILE__, __LINE__);

to

Code Select Expand

    WHERE ID_GROUP = '" . $groups[$rank]['id'] . "'
             $rteam", __FILE__, __LINE__);


To get your whole roster, link to it in the regular way -- index.php?page=64

To get to your individual teams, put the team number in the URL -- index.php?page=64;rteam=32

Crossing fingers.

[londonhogfan]

I <3 YOU

[JPDeni]

 

I take it that it worked.



Is that slick or what? The coolest thing was when I figured out I could do that with TP. Opened up a whole world of possibilities. I've created my own image gallery and articles database and links manager, all because of that little thing. (I know some of this is coming up in future versions of TP, but this way I could make it my own way.)

I have this "thing" about redundancy. I hate it. If I can make a script do double-duty, I'll get that whip out and force it into line.

I'm really glad it worked for you. You know, I get the same charge out of writing a script that works as I do when I win at gambling. And programming doesn't cost anything. 

[londonhogfan]

yes, it worked great.

It gives me the ability to have more things..

for example we have a little tourney where you can win the "Jack Bauer Award" Its a 1v1 pistol match (Silencer on) and the winner gets the award.  So I have a group setup and each month we add a new winner... Now I can show all previous winners.

Same for recruits, and even a meet the team style page.

Thanks a bunch.

[JPDeni]

I see. Oh, that's wonderful. I ended up making it better than I even thought.

This stuff is just great, isn't it?

I think I'm going to let it be now, though. I could tinker with it some more and maybe cut down on the database calls, but this is working nicely now and I don't want to risk messing it up. If there's anything else you want to add, we can see if we can, but I think I can finally sleep now without worrying about your huge php page. 

[londonhogfan]

yes, Its perfect just the way it is 

[Assistance]

I run a clan site aswell

allthough I didnt get this to work out (no error codes or nothing ) to look like yours
I have learned a few things from this thread.

Not to sure how long I have been trying ( reading/copy/paste/ ) to get this to work

edit.......lol 20 minutes (wow)

anyways,  I got the justs of it figured out

cant wait to see your final code
also works with the custom actions mod ^^ action=roster


I wonder how many clan webmasters would gladly give you a med pack for your work

[JPDeni]

What isn't working for you, Assistance? Can I give you some, uh, assistance?

I think this is the final code. Well, the last one that londonhogfan posted, with my edits to make it work with all the different groups.

I'll have to take a look at that custom actions mod. I might be able to use it for some other things.

[Assistance]

oh if you need to sleep plz go ahead

I need to atleast clean up my code a bit
(set bg class, remove msn, yahoo, etc, add in the flag)

but I do know the avatars are not showing nor is flags, and i do have that mod installed

if your awake in rought 10-20 mins I'll have a better gathering of where I am


yes my name is ironic is it not?
oh and I'm sure you will get use of the custom action mod
specially if you like it to show action=name
instead of using articles

[JPDeni]

I'm definitely awake. It's still in the morning here.

I don't think there are individual avatars in the code I've been working on. There's the "stars" for the group, but not individual avatars. You'd have to add them.

I'm working with the custom action thing now, trying to figure out how to use it.