Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
Mug
Apr 26, 2005

SamBishop posted:

It blows my mind that I'm anywhere on this list these days. Work means I only play anything I'm not reviewing with only the lightest (we're talking 20 minutes, tops in most cases) glance. I guess I glance at more stuff than I thought.

Gonna move up a spot, though. Must.

I'm coming for you!

Anyway, I'm working on putting in Moskau's design here.
http://playstationgoons.com/newlook.php

Looks okay so far. Pretty choppy implementation.

anyone want to contribute design ideas for the "Interesting Stats" pages?

Mug fucked around with this message at 09:50 on Mar 16, 2012

Adbot
ADBOT LOVES YOU

Wandle Cax
Dec 15, 2006
Hey I think you have SA name and PSN name mixed up in the column order on the site.

Mug
Apr 26, 2005

Wandle Cax posted:

Hey I think you have SA name and PSN name mixed up in the column order on the site.

I sure do. Fixing now.

I just platinumed Motorstorm on Vita without touching the PS3 version, then booted up the PS3 version and all the trophies including the platinum just popped straight up. I'm uploading a video of it at the moment. Counts as another Platinum. Number 23 for me.

edit: Here's what happens when you do it:
https://www.youtube.com/watch?v=2m3PSRXCoY0

Dunno why the audio is so out of synch.

Mug fucked around with this message at 15:34 on Mar 16, 2012

Moskau
Feb 17, 2011

HEY GUYS DON'T YOU LOVE ANIME?! I LOVE ANIME SO MUCH ESPECIALLY ALL THE PANTY SHOTS AND FAN SERVICE AND MOE MOE MOE! I JUST CAN'T GET ENOUGH!

Mug posted:

I'm coming for you!

Anyway, I'm working on putting in Moskau's design here.
http://playstationgoons.com/newlook.php

Looks okay so far. Pretty choppy implementation.

anyone want to contribute design ideas for the "Interesting Stats" pages?

I was just about to post that I should have time this weekend to deliver HTML + CSS as well, but you beat me to it. :) Still, if you want, I can polish it out and optimize the script output, reduce the amount of generated markup etc (the page is now 730+ KB for just the markup), just drop me a line at samoskau in the gmail system. If the server is getting crowded, I can work off a copy of the php and a db dump too.

Mug
Apr 26, 2005
I've already got pagination working I just haven't put it into the version with the nice new design. That'll fix up the markup size.

Cardboard Fox
Feb 8, 2009

[Tentatively Excited]
drat, only #214? I thought I was hot poo poo with my 3 platinums.

I'm coming for you Policenaut, watch yourself.

Revitalized
Sep 13, 2007

A free custom title is a free custom title

Lipstick Apathy

Mug posted:

I sure do. Fixing now.

I just platinumed Motorstorm on Vita without touching the PS3 version, then booted up the PS3 version and all the trophies including the platinum just popped straight up. I'm uploading a video of it at the moment. Counts as another Platinum. Number 23 for me.

edit: Here's what happens when you do it:
https://www.youtube.com/watch?v=2m3PSRXCoY0

Dunno why the audio is so out of synch.

Just to clarify, I'd have to buy Motorstorm for the ps3 despite having it for free on the Vita right?

Also the exp bars are nice but I also liked the percentage for those really close rankings. (I just moved up to #38 by 1% :madmax:)

Mug
Apr 26, 2005

Revitalized posted:

Just to clarify, I'd have to buy Motorstorm for the ps3 despite having it for free on the Vita right?

Also the exp bars are nice but I also liked the percentage for those really close rankings. (I just moved up to #38 by 1% :madmax:)

Yeah, In Australia Motorstorm wasn't free for Vita. You buy it on Vita and got it free on PS3 or visa-versa.

Yeah, I'll add the percentages back in somewhere.

edit: Some bastard pushed me down to #10. Damnit, Jharrek!

My name aint Jerry
Sep 4, 2011

Good job with notjerry.org, Not Jerry. Here is not-a-trophy for you.

Mug posted:

edit: Some bastard pushed me down to #10. Damnit, Jharrek!

I'm not even trying. I'm just playing games, damnit.

:smug:

Moskau
Feb 17, 2011

HEY GUYS DON'T YOU LOVE ANIME?! I LOVE ANIME SO MUCH ESPECIALLY ALL THE PANTY SHOTS AND FAN SERVICE AND MOE MOE MOE! I JUST CAN'T GET ENOUGH!

Mug posted:

Yeah, I'll add the percentages back in somewhere.

You could use alt/title text for the exp bar images, for ex. <img src... alt='99 %' title='99 %' />. The percentages would then be easily available by just hovering on the bar, with no extra clutter.

Mug
Apr 26, 2005

Moskau posted:

You could use alt/title text for the exp bar images, for ex. <img src... alt='99 %' title='99 %' />. The percentages would then be easily available by just hovering on the bar, with no extra clutter.

The XP bars are background images on table data cells. I'll work something out.

Moskau
Feb 17, 2011

HEY GUYS DON'T YOU LOVE ANIME?! I LOVE ANIME SO MUCH ESPECIALLY ALL THE PANTY SHOTS AND FAN SERVICE AND MOE MOE MOE! I JUST CAN'T GET ENOUGH!

Mug posted:

The XP bars are background images on table data cells. I'll work something out.

Ok, I figured you'd be stretching the image instead of using tables. Tables work, but here are some tips how this could be handled with CSS to cut down on markup, increase script maintainability, and stop table abuse :). Just throw one element in there with a background, and stretch the image:

.exp { display: block; width: 100px; height: 16px; background: url('style/progress-fill.gif') repeat-x; }

<div class='exp'><img src='style/progress-fill.gif' width='90' height='16' /></div>
<div class='exp'><img src='style/progress-fill.gif' width='80' height='16' /></div>
<div class='exp'><img src='style/progress-fill.gif' width='70' height='16' /></div>

Instead of:

<table width="75px" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="width: 90px; background-image:url('./style/progress-fill.gif'); background-repeat:repeat-x; height: 15px">
</td><td style="width: 10px; background-image:url('./style/progress-empty.gif'); background-repeat:repeat-x; height: 15px"></td></tr></tbody></table>
<table width="75px" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="width: 80px; background-image:url('./style/progress-fill.gif'); background-repeat:repeat-x; height: 15px">
</td><td style="width: 20px; background-image:url('./style/progress-empty.gif'); background-repeat:repeat-x; height: 15px"></td></tr></tbody></table>
<table width="75px" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="width: 70px; background-image:url('./style/progress-fill.gif'); background-repeat:repeat-x; height: 15px">
</td><td style="width: 30px; background-image:url('./style/progress-empty.gif'); background-repeat:repeat-x; height: 15px"></td></tr></tbody></table>

---

Something for the trophy counts, you can specify multiple classes. If "data" has definitions you need, you can also add "gold" or whatever for extra definitions.

.plat { background: url('style/data-plat.gif'); }
.gold { background: url('style/data-gold.gif'); }
.silver { background: url('style/data-silver.gif'); }
.bronze { background: url('style/data-bronze.gif'); }

<td class="data plat">0</td>
<td class="data gold">0</td>
<td class="data silver">0</td>
<td class="data bronze">0</td>
<td class="data plat">0</td>
<td class="data gold">0</td>
<td class="data silver">0</td>
<td class="data bronze">0</td>

Instead of (you could add something to the CSS to account for the spans as well if necessary):

<td class="data" style="background-image:url('./style/data-plat.gif')"><span style="margin: 0 10 0 10;">0</span></td>
<td class="data" style="background-image:url('./style/data-gold.gif')"><span style="margin: 0 10 0 10;">0</span></td>
<td class="data" style="background-image:url('./style/data-silver.gif')"><span style="margin: 0 10 0 10;">0</span></td>
<td class="data" style="background-image:url('./style/data-bronze.gif')"><span style="margin: 0 10 0 10;">0</span></td>
<td class="data" style="background-image:url('./style/data-plat.gif')"><span style="margin: 0 10 0 10;">0</span></td>
<td class="data" style="background-image:url('./style/data-gold.gif')"><span style="margin: 0 10 0 10;">0</span></td>
<td class="data" style="background-image:url('./style/data-silver.gif')"><span style="margin: 0 10 0 10;">0</span></td>
<td class="data" style="background-image:url('./style/data-bronze.gif')"><span style="margin: 0 10 0 10;">0</span></td>

Mug
Apr 26, 2005
Can I just give you access to the server and you do whatever you want? You seem to actually know what you're doing.

My job is PHP, and I just know enough markup to actually show results on screen rather than do nice designs. You can tell my HTML was all learned in 1999.

What's your email address?

...!
Oct 5, 2003

I SHOULD KEEP MY DUMB MOUTH SHUT INSTEAD OF SPEWING HORSESHIT ABOUT THE ORBITAL MECHANICS OF THE JAMES WEBB SPACE TELESCOPE.

CAN SOMEONE PLEASE TELL ME WHAT A LAGRANGE POINT IS?
Better yet, Moskau, if you're going to do this then I'd advise that you wait a couple of days for my version of the PHP script. I'm doing a lot of modification to the actual PHP code to add a lot of functionality, but much like Mug I'm pretty poo poo at page layout and design.

Mug
Apr 26, 2005
Yeah, basically, my baby in this whole thing is just the actual trophy scraper and the database with all the trophy data in it. If goons want to access the data and develop stuff with it, I'm happy for that. Wanna make it into something cool and we have the domain playstationgoons.com to do whatever we want with.

Mug
Apr 26, 2005
Re-added the Progress percentage. Hover mouse over to see it.
Also you can now "Sort" by clicking on trophy headers.

edit: I'm eager to get back to the stuff I really enjoy, which is the database. I'm going to make the information more time-bound so we can see how many trophies each person is getting each week so we can have a much more active community. The top 10 are pretty much untouchables, but if we could have a clean slate each week and show "Who got the most trophies this week" and "Who got the most this month" etc ongoing, I think that would really encourage us to all waste more time playing video games.

edit 2: This database is gonna end up huge.

Mug fucked around with this message at 09:06 on Mar 19, 2012

id107
Aug 1, 2004
put optional title text here
He Mug,

I can move the goon database over to the new domain/your server as well. Ps3goons runs php and mysql as well. This way we can have an active group of developers and everything combined. Lets talk further on IRC, for instance what the index page should be.

Mug
Apr 26, 2005

id107 posted:

He Mug,

I can move the goon database over to the new domain/your server as well. Ps3goons runs php and mysql as well. This way we can have an active group of developers and everything combined. Lets talk further on IRC, for instance what the index page should be.

Yeah baby let's do this thing.
I'm always in #vita either on my work account or home account so jump in and we'll make beautiful music together.

I just finished the timebound trophy database. It grabs everyone's trophies every day so we can run queries like "Trophies this week" "Platinums this week" etc. This should make for a much more engaging competition. It's only starting as of tonight, so we can't look back into the past. It should update fast enough to grab about 1500 goons a day, so we're nowhere near capacity yet.

everyone remember to synch your trophies!

edit: pagination is done.

Mug fucked around with this message at 11:07 on Mar 19, 2012

...!
Oct 5, 2003

I SHOULD KEEP MY DUMB MOUTH SHUT INSTEAD OF SPEWING HORSESHIT ABOUT THE ORBITAL MECHANICS OF THE JAMES WEBB SPACE TELESCOPE.

CAN SOMEONE PLEASE TELL ME WHAT A LAGRANGE POINT IS?
After some reflection, I've decided that I need to end my participation in this project. Because of some miscommunication(maybe it was my fault; I don't know) I've basically spent several hours duplicating work that was already being done by someone else. That's a big deal for someone who can't sit in front of a computer without pain. I can't risk it happening again. Everything looks like it's coming along well without my input anyway. Sorry and good luck. :)

Mug
Apr 26, 2005
Yeah sorry about this, I think it's a bit different when you're in a situation where taking a seat and working on the code is actually causing pain for you, where I can just bang out code throughout the day between work.

Get back to earning some trophies.

Mug
Apr 26, 2005
After fixing the last stupid bug, the weekly trophies are now tracking and will appear on the page on the left.

Go synch some trophies, everyone. It can take up to 6 hours for them to appear on the site at at the current set up. Need some people to synch a few hopefully while I sleep tonight so when I get up I can see some people in the leaderboard and work on making it a nicer design.

Mug
Apr 26, 2005
What would peoples' opinions be on maybe having a bit of a monthly competition with some crappy giveaways like an old game or something or a PSN voucher?

limaCAT
Dec 22, 2007

il pistone e male
Slippery Tilde

Mug posted:

What would peoples' opinions be on maybe having a bit of a monthly competition with some crappy giveaways like an old game or something or a PSN voucher?

Nah, don't overdo it...
I mean, the monthly leaderboard is ok, but don't get in the drama of "Mug, my prizes! Where are they?"

BloodWulfe
Mar 18, 2003
This is really cool, thank you for sharing. :) It's win/win for me too because I didn't realize the PS3 Goon Database even existed.

I'll submit missing games to the main goon DB, for what little bit it helps. I saw quite a few (maybe 3/4 of 'em "obscure" titles though) when I went to add my games, so I'll add them in there for completeness sake. Too bad there isn't some resource available listing all PS3 games with an API -- that would help even more with the automation.

Cardboard Fox posted:

I thought I was hot poo poo with my 3 platinums.

You and me both! I have four platinum trophies, and I thought that was pretty drat :cool:. None of them were work -- I had fun getting all of them -- but they definitely took some time to get.

Compared to the guys with 60+ platinum trophies though my whopping four don't seem to shine as brightly. :(

Yechezkel
Oct 5, 2004

Fun Shoe
I agree with limacat. Keep it casual, don't give away prizes.

abagofcheetos
Oct 29, 2003

by FactsAreUseless
Is the March leaderboard only counting trophies that were obtained in March after the leaderboard was made?

Mug
Apr 26, 2005

abagofcheetos posted:

Is the March leaderboard only counting trophies that were obtained in March after the leaderboard was made?

Yep. Started tracking March 19th.

Anyone who has any graphical ideas to not make the monthly leaderboard look awful, I'd be happy to implement anything you can draw.

id107
Aug 1, 2004
put optional title text here

Mug posted:


Anyone who has any graphical ideas to not make the monthly leaderboard look awful, I'd be happy to implement anything you can draw.

It would be nice if the layout could also be used for the ps3goonsdatabase. For this one a two column design with some kind of navigation bar ( i prefer an extra column) would be nice.

Revitalized
Sep 13, 2007

A free custom title is a free custom title

Lipstick Apathy

Mug posted:

What would peoples' opinions be on maybe having a bit of a monthly competition with some crappy giveaways like an old game or something or a PSN voucher?

Have a little visual counter next to people's names that announce the number of times they've been in the top 3 monthly at the end of months! I don't know, just ideas.

Mug
Apr 26, 2005

Revitalized posted:

Have a little visual counter next to people's names that announce the number of times they've been in the top 3 monthly at the end of months! I don't know, just ideas.

Yeah, when we get the GoonDB working, I'll make it store stuff like this in the goondatabase account. In the meantime, you'll be able to scroll back through previous months.

abagofcheetos
Oct 29, 2003

by FactsAreUseless

Mug posted:

Yep. Started tracking March 19th.

Anyone who has any graphical ideas to not make the monthly leaderboard look awful, I'd be happy to implement anything you can draw.

drat! The one month I would ever have a shot at anything, and almost all of it happened before the 19th. Oh well!

(not that I really go crazy for trophies anyway)

Mug
Apr 26, 2005

abagofcheetos posted:

drat! The one month I would ever have a shot at anything, and almost all of it happened before the 19th. Oh well!

(not that I really go crazy for trophies anyway)

I got the Motorstorm double-platinum earler this month, too. That was like 15 Golds and 2 Plats. I would have been smashing it.

MarioTeachesWiping
Nov 1, 2006

by XyloJW
Fresh off my tenth platinum, and headed for another. Still in the top 25!

Parkingtigers
Feb 23, 2008
TARGET CONSUMER
LOVES EVERY FUCKING GAME EVER MADE. EVER.
The new layout looks really good, but functionally it is a massive step back from what there was before. It shows the top 25, and needs to be paged through 25 entries at a time. This is ... yeah that's really bad. I don't care about the top of the leaderboard, because I'm not there and never will be. I care about where I am on the leaderboard, any change and any point in looking at the board will be about the local rivalry that I have with the goons directly above and below me.

As it stands, I now need to individually page through to where I am on the board. There's no way to sign in and have it show me automatically, there's no search function to go straight to my username, no numbered pages so that I can skip multiple pages, and no option to display more than 25 goons per page.

Ugly as it was before, it was a case of loading up a single page and CRTL-F to jump to my position. The current version just is so lacking in basic functionality that it takes too long to actually be worth checking. When you need to reload the page at least nine times, and manually look for your own name because you don't know where you are on the list (which is the point of having a list), then something is very wrong.

You guys in the top 50 won't notice it so much. Down in the 200s the layout is really hampering. Nothing that can't easily be fixed with a bit of minor tweaking though. It shouldn't take longer for me to see when I am on the list than the person in 26th place though.

My name aint Jerry
Sep 4, 2011

Good job with notjerry.org, Not Jerry. Here is not-a-trophy for you.

Parkingtigers posted:

The new layout looks really good, but functionally it is a massive step back from what there was before. It shows the top 25, and needs to be paged through 25 entries at a time.

You can edit the URL to modify the number of entries shown. It's the "perpage" parameter.

Mug, have you uploaded the source of the site somewhere ? Not so much the scrapper, but the database schema and the PHP code for the main page. I'm curious about it and would be happy to lend a hand adding feature, if that's ok.

Mug
Apr 26, 2005
I'll add "Search" for user today if you're lucky. I've just got another site that I have to launch today for work so it might not get done.

I liked it better when it was just one absolutely massive list but everyone complained that it took too long to load and needed pagination, which is done now. I just need to add username searching in.

Mechanigma
Apr 17, 2007

ur already ded

Mug posted:

I got the Motorstorm double-platinum earler this month, too. That was like 15 Golds and 2 Plats. I would have been smashing it.

Yeah, I also got platinums for House of the Dead Overkill and Sonic Generations earlier in the month, but oh well. I just platted Saints Row 3 a couple of days ago. This has probably been my biggest trophy month in ages.

Mug
Apr 26, 2005
Search has been added. Just does exact match for SA name or SEN name at the moment. No wildcards or anything.

Parkingtigers
Feb 23, 2008
TARGET CONSUMER
LOVES EVERY FUCKING GAME EVER MADE. EVER.
Well that was a quick fix, certainly can't complain about the service here.

And now I find that I'm listed with zero trophies again, along with some other goons. Seems the previous fix you did for me got unfixed somewhere. I did try and log into the PS3 goons page to fiddle with my username as you said, but it rejects every password I try and give it.

I'm beginning to think it's just me. Grrr, the sites just hate me. Ah well, I should put more time into playing than into epeen measuring anyway. Cool to see the page developing nicely though, it's improving step by step.

Adbot
ADBOT LOVES YOU

Static Rook
Dec 1, 2000

by Lowtax
Just got in on this and the goon database. #294. Thanks for making all this, Mug!

This is gonna make me finish up some of the older games I'm only 1 or 2 trophies away from platting. Like that drat "use all the moves in a combo" trophy from Arkham Asylum :argh:

  • Locked thread