n00bfest
http://n00bfest.com/phpBB3/

Forum Update: Custom Profile Fields
http://n00bfest.com/phpBB3/viewtopic.php?f=98&t=31238
Page 1 of 1

Author:  Gman [ Mon Jan 18, 2010 2:28 pm ]
Post subject:  Forum Update: Custom Profile Fields

I've added a spot in everyones profile for Xbox 360 Gamertag and PSN Username. The SteamID option has been there for a while, but most of you haven't updated it.

Please take this time to go into your profile and update your information.

To do this, click on User Control Panel and go to the "Profile" link on the left-hand side.

Attachment:
customprofilefields.PNG
customprofilefields.PNG [ 8.91 KiB | Viewed 6292 times ]

Author:  Hooker [ Mon Jan 18, 2010 2:36 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Console gamers are inferior.

Author:  Genocide [ Mon Jan 18, 2010 2:45 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Sweet, nice work Gman.


ah this used to be true but look at Modern Warfair 2, first of its kind where the console version is better than the pc version.

Author:  Tazzaler [ Mon Jan 18, 2010 2:47 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Hooker wrote:
Console gamers are inferior.

True...but I do enjoy doing Third Person shit on console.

Author:  Garrett [ Mon Jan 18, 2010 2:50 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Nice

Author:  Montreal [ Mon Jan 18, 2010 2:55 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Cool Gman, I was thinking about getting a PS3 too..

Hooker wrote:
Console gamers are inferior.


I remember once in PC Gamer they hosted a tournament against, I believe, their Xbox counterpart, and it was mice (mouses?) vs controllers and the PC Gamers won. I just dont think you can beat the quick reflex shots of a mouse.

Author:  dirkdeagler [ Mon Jan 18, 2010 3:34 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Excellent.

Console FPS's are inferior, even when I'm using the mouse I got to try and compensate.

However, nothing in the world beats a good racing game/simulator on the PS platforms. From twisted metal 2 on the PSOne thru Gran Turismo on the ps3. Amazing stuff.

I guarantee that if the next twisted metal is at all good and supports multiplayer, we cs addicts will be drawn to it like flies. It's like CS, but you're driving cars with rockets and lasers while doing sweet jumps and destroying terrain.

Author:  EnV [ Mon Jan 18, 2010 7:09 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

This is sick, now is there a way of searching these? Like say i wanted to search everybody that updated their profile with a PSN network name

Author:  doublesven [ Mon Jan 18, 2010 7:18 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Once xbox's get cheeper I might pick on up just for madden and ncaa crap. Other wise I will never play fps one a console again.

Author:  Gman [ Mon Jan 18, 2010 8:46 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

EnV wrote:
This is sick, now is there a way of searching these? Like say i wanted to search everybody that updated their profile with a PSN network name


Unfortunately, not at this time.

Author:  mossyoak [ Mon Jan 18, 2010 9:46 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Gman wrote:
EnV wrote:
This is sick, now is there a way of searching these? Like say i wanted to search everybody that updated their profile with a PSN network name


Unfortunately, not at this time.


That would be hawt.
Anyways nice job G.

Author:  EnV [ Mon Jan 18, 2010 10:04 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

I approve of this =D gj

Author:  -Purple- [ Mon Jan 18, 2010 10:44 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

awesome Gman. very awesome. thank you!

Author:  Coach [ Tue Jan 19, 2010 4:45 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Updated, good stuff.

Author:  Spyda [ Tue Jan 19, 2010 11:42 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

We could just have 2 threads in the console forum that people post their username for the console and then just update it when someone posts and delete their post after its added to the list.

Author:  Gman [ Wed Jan 20, 2010 12:11 am ]
Post subject:  Re: Forum Update: Custom Profile Fields

Code:
SELECT u.username, pfd.pf_gamertag, pfd.pf_psn
FROM phpbb_profile_fields_data pfd
JOIN phpbb_users u ON u.user_id = pfd.user_id
WHERE pfd.pf_gamertag IS NOT NULL
OR pfd.pf_psn IS NOT NULL
LIMIT 500


Attachment:
2010-01-20 CPF.PNG
2010-01-20 CPF.PNG [ 27.86 KiB | Viewed 6185 times ]

Author:  DeathTaker [ Wed Jan 20, 2010 3:44 am ]
Post subject:  Re: Forum Update: Custom Profile Fields

sw00t!

Author:  Gman [ Wed Jan 20, 2010 1:10 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Wonder why it pulled stuff that is blank...

Author:  fomenta [ Wed Jan 20, 2010 1:39 pm ]
Post subject:  Re: Forum Update: Custom Profile Fields

Cause its "not null" -- I was lazy with the query -- it means they changed it at one point but then blanked it and SQL doesn't treat empty strings as NULLs -- you could also check for that but w/e

Page 1 of 1 All times are UTC - 6 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/