Jump to content

  • Log in with Facebook Log in with Twitter Log In with Steam Log In with Google Sign In
  • Create Account
Photo

Roster getting sexy

* * * * * 2 votes

  • Please log in to reply
17 replies to this topic

#1
Dixus

Dixus

    L4: Apprentice

  • Honored Veteran
  • 412 posts
3
Unknown at this point
  • Server:None
A made a simple request. Update your location in your profile! :)
Because many didnt (including founders!!!) and dare also asked for such a functionality, i uploaded 100.000 rows of ip ranges in our database. this took about 5 hours! I needed to install a local php server with a php sql script to get this running lol. (server timeouts..)

The rows look like this:

"3739574272","3739680767","JP","JPN","JAPAN"

so if someone has an IP in this a range means he comes from japan. Also the country codes are in there :) We need this lookup table because it would be tooooo slow to make a kind of whois every time.

I found some nice flags images that are named by the country code! So i can render the images without any trouble by the country code that i get from the database for everybodies ip.

So if someone didnt add a location... i add the country automatically. And its flag.

We also have now a complete overview from which countries our members come from. You can read the total count at the bottom of the page.

I made the roster W3C XHTML strict so there shouldnt be any problems in any browsers anymore!

click =F|A= Roster on upper right or use the direct link: http://www.fearless-...sins.com/roster


Its a bit slow at the moment. I imported the country data twice by accitent. I need to fix that and create some indexes. Should be faster then.

Also new. The navigation at the top. Here we have a overview about our ranks and teams.

For now Enjoy!



AND Ryan! You are from Barbados! I hate you for that lol. I want to live there too!


Click here to login or here to register to remove this ad, it's free!

#2
Yama310

Yama310

    L5: Journeyman

  • Inactive Member
  • 713 posts
12
A step in the right direction
  • Admin:11
  • Server:None
Good job for flags ;).

#3
PHANTASM

PHANTASM

    L8: Grand Teacher

  • Regular User
  • 1,963 posts
90
On the road to fame
  • Admin:XIII
  • Server:Jay2
Contributor
I thought there was going to be sexy girls on this thread.
:hmm

#4
hobbit

hobbit

    L10: Grand Master

  • Regular User
  • 3,246 posts
286
Will become famous
  • Admin:0
  • Server:None
  • Steam ID:pvtforrestgump
Contributor
Great job but maybe add scrim team members as well? If it wouldn't be too much work?

#5
Dixus

Dixus

    L4: Apprentice

  • Honored Veteran
  • 412 posts
3
Unknown at this point
  • Server:None

Great job but maybe add scrim team members as well? If it wouldn't be too much work?


scrim team is there... http://fearless-assa...tion=Scrim Team

if you arent listed talk with your master. your level isnt set correctly... or arent you a clan member? your profile says just "member" which means forum member..

#6
F257

F257

    L8: Grand Teacher

  • Honored Veteran
  • 1,569 posts
33
Getting Better
  • Admin:12
  • Server:None
lol very nice work dix :)

#7
daredevil

daredevil

    Profiler

  • Administrators
  • 25,166 posts
14,967
Guardian of the faith
  • Xbox Live:hellreturn
  • EvolveHQ:hellreturn
  • Admin:21
  • Server:None
  • Alias:hellreturn
  • T-M:1-0
Contributor

Great job but maybe add scrim team members as well? If it wouldn't be too much work?



http://fearless-assa...private-access/

No replies :P

Dixus that flags are awesome :D :thanks

#8
Mobby

Mobby

    L4: Apprentice

  • Regular User
  • 476 posts
15
A step in the right direction
  • Admin:11
  • Server:COD4 #2
n1 one dixus!!!! :thanks

#9
Dixus

Dixus

    L4: Apprentice

  • Honored Veteran
  • 412 posts
3
Unknown at this point
  • Server:None
:) your welcome. was a funny little project.
The scripts are still running. It will be much more faster tomorrow. Hopefully lawl

#10
-=Medic=-

-=Medic=-

    L10: Grand Master

  • Honored Veteran
  • 3,148 posts
178
On a distinguished road
  • Admin:14
  • Server:Jay1
  • Alias:-=Medic=-
Contributor
WOW big brother you doing a great ART work over there :thanks

#11
Dixus

Dixus

    L4: Apprentice

  • Honored Veteran
  • 412 posts
3
Unknown at this point
  • Server:None
muhaha. yw! :)

the index is created. works faster now.

I need to update the IP / country lookup table. I still wait for a bugfix in the current one. (emlocker is the only one that got no flag). They have some missing ranges for South Africa.

fixed soon.

#12
Cranky:>

Cranky:>

    L3: Novice

  • Regular User
  • 303 posts
-21
I should be left alone; I bite
  • Admin:3
Woah, nice one :blink:

#13
Dixus

Dixus

    L4: Apprentice

  • Honored Veteran
  • 412 posts
3
Unknown at this point
  • Server:None
ty for the flowers guys.

some news. i changed the roster genearation. I create now pure html files to minimize db traffic. it is pretty fast now. i also testing with cache stuff.

I will set up a cronjob that regenerates the roster files daily. The generation can be started by a url :)

#14
-=Medic=-

-=Medic=-

    L10: Grand Master

  • Honored Veteran
  • 3,148 posts
178
On a distinguished road
  • Admin:14
  • Server:Jay1
  • Alias:-=Medic=-
Contributor
WOW it is fast now, this afternoon at work was really hard to load the roster page I thought it was the pc cos it's old one, now I'm at home it's completely different when hit roster it's load faster then the forum :blink:

#15
Duckie

Duckie

    L8: Grand Teacher

  • Banned
  • 1,736 posts
58
Getting Better
  • Admin:0
  • Server:None
very nice!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users