GGL Stats and System Upgrade Suggestions

HALO7JET · **Posted:** Wed Oct 05, 2011 10:44 am

Proacejoker wrote:

I got one, a specific player search. So if i don't know what team Crusader plays for but i want his stats I could just type Crusader0102 in a search bar and that will give me his specific stats?

That's already made.

TrueFlyingCow · **Posted:** Wed Oct 05, 2011 6:27 pm

I've got a recommendation to improve the player search. Right now it seems like you need to get the gamertag exactly right. But what if you wanted to search for "taco" and compare all of them? You can do that pretty easily by just changing your query a bit to be more like this:

mysql_query("SELECT somestats FROM yourtables WHERE gamertag LIKE '%$term%'");

Using "like" makes it more flexible, $term is whatever we enter into the search box, after running it through mysql_real_escape_string(), and the percent (%) symbol is a wildcard character; so having it on either side of the search term lets you look for anything that's got the term in it, not matter where it is or what else is around it.

Crusader0102 · **Posted:** Wed Oct 05, 2011 6:56 pm

TrueFlyingCow wrote:

I've got a recommendation to improve the player search. Right now it seems like you need to get the gamertag exactly right. But what if you wanted to search for "taco" and compare all of them? You can do that pretty easily by just changing your query a bit to be more like this:

mysql_query("SELECT somestats FROM yourtables WHERE gamertag LIKE '%$term%'");

Using "like" makes it more flexible, $term is whatever we enter into the search box, after running it through mysql_real_escape_string(), and the percent (%) symbol is a wildcard character; so having it on either side of the search term lets you look for anything that's got the term in it, not matter where it is or what else is around it.

Sounds like a good suggestion to me. I can compare my stats to all the other Crusaders.

eTazedd · **Posted:** Wed Oct 05, 2011 6:58 pm

TrueFlyingCow wrote:

I've got a recommendation to improve the player search. Right now it seems like you need to get the gamertag exactly right. But what if you wanted to search for "taco" and compare all of them? You can do that pretty easily by just changing your query a bit to be more like this:

mysql_query("SELECT somestats FROM yourtables WHERE gamertag LIKE '%$term%'");

Using "like" makes it more flexible, $term is whatever we enter into the search box, after running it through mysql_real_escape_string(), and the percent (%) symbol is a wildcard character; so having it on either side of the search term lets you look for anything that's got the term in it, not matter where it is or what else is around it.

wow that is alot

Proacejoker · **Posted:** Wed Oct 05, 2011 9:09 pm

Quote:

wow that is alot

This wasn't

KiIIerz · **Posted:** Thu Oct 06, 2011 10:32 am

I think you should put the Schedule, Roster, and Division sites on homepage.. Just saying.. Like it was last year..

Mike · **Posted:** Thu Oct 06, 2011 11:09 am

They are. They're on every page. Just look in the menu at the top.

Kalbelgarion · **Posted:** Thu Oct 06, 2011 11:13 am

TrueFlyingCow wrote:

I've got a recommendation to improve the player search. Right now it seems like you need to get the gamertag exactly right. But what if you wanted to search for "taco" and compare all of them? You can do that pretty easily by just changing your query a bit to be more like this:

mysql_query("SELECT somestats FROM yourtables WHERE gamertag LIKE '%$term%'");

Using "like" makes it more flexible, $term is whatever we enter into the search box, after running it through mysql_real_escape_string(), and the percent (%) symbol is a wildcard character; so having it on either side of the search term lets you look for anything that's got the term in it, not matter where it is or what else is around it.

Great idea. I'll add that to the list.

MyrHerder · **Posted:** Thu Oct 06, 2011 5:54 pm

zinger1223 wrote:

wow that is alot

No, this is Alot:

The Alot

KiIIerz · **Posted:** Thu Oct 06, 2011 8:13 pm

Mike wrote:

They are. They're on every page. Just look in the menu at the top.

Oh!! Thanks.

I just remember them being on the right side of the page last year.

H2OGummiBear · **Posted:** Sat Oct 08, 2011 3:17 am

I believe some thumbnail png files for the completed Achieveables would also be a cool thing to add to each teams "profile".

Also the idea that TFC used is good but I think what if you expanded on it a little bit. Allowing for me to type in 1-4 or possibly more players to compare myself with. I don't know the ifs ands or thens...what have you. But it seems doable that all you would need is a compare check mark and you would check the players you want to compare and then click submit. Then you can see side by side instead of scrolling up and down.

Also I think a friend and foe system would be interesting to add as well. Generally we are all friends however a friend and foe system could make things interesting for hubcasts when you learn that two teams have declared foe against each other and are going to be facing each other on the court. Some people may use it some may not but I think it could add a little extra fun factor into the GGL.

MyrHerder · **Posted:** Sat Oct 08, 2011 2:45 pm

On my screen (IE7 at work) the Gamertag field and Team drop-down list on the Stats screen are squished horizontally. The Team drop-down is so squised, in fact, that all I see is the scroll bar and no names. This may be specific to IE7; I haven't checked stats at home on Chrome yet.

Mike · **Posted:** Sat Oct 08, 2011 3:04 pm

Yep, probably IE7 specific. I don't use IE7, I have IE8, so it would be difficult for me to test and correct that. It doesn't surprise me that any iteration of IE would not show certain things properly. It's a pretty lowsy and rather picky browser.

Everything should be fine on Chrome. I would strongly suggest using Firefox 7 or Chrome whenever possible.

With everything else that I have to do it's just impossible for me to make everything work 100% on every browser out there. I'll see about an IE7 fix for the form fields though.

MyrHerder · **Posted:** Sun Oct 09, 2011 10:39 pm

Mike wrote:

Yep, probably IE7 specific. I don't use IE7, I have IE8, so it would be difficult for me to test and correct that... It's a pretty lowsy and rather picky browser... With everything else that I have to do it's just impossible for me to make everything work 100% on every browser out there.

I understand. That's why I specified it was on my work PC- they refuse to upgrade, but it's okay because I don't absolutely have to access the stats at work. Don't change it just for me; only if you have the time/demand.

Speaking of browser-specific: I visited the Hub on my Android, and the links across the top- including the GGL drop-down link- are missing in the mobile-formatted site. Is anyone on iOS having this problem? Is there a way to get these links added to the mobile site? Maybe this is something you have to talk to the forum programmers about.

CJ86751 · **Posted:** Mon Oct 10, 2011 1:23 pm

i have a suggestion. the stat system should be orderd from best to worst so we can find our biggest competitors

Listen

Watch

GGL Stats and System Upgrade Suggestions

Who is online