Dixus Posted October 12, 2009 Share Posted October 12, 2009 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-assassins.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! Quote Link to comment Share on other sites More sharing options...
Yama310 Posted October 12, 2009 Share Posted October 12, 2009 Good job for flags . Quote Link to comment Share on other sites More sharing options...
PHANTASM Posted October 12, 2009 Share Posted October 12, 2009 I thought there was going to be sexy girls on this thread. Quote Link to comment Share on other sites More sharing options...
hobbit Posted October 12, 2009 Share Posted October 12, 2009 Great job but maybe add scrim team members as well? If it wouldn't be too much work? Quote Link to comment Share on other sites More sharing options...
Dixus Posted October 12, 2009 Author Share Posted October 12, 2009 Great job but maybe add scrim team members as well? If it wouldn't be too much work? scrim team is there... http://fearless-assassins.com/roster/?action=Scrim%20Team 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.. Quote Link to comment Share on other sites More sharing options...
F257 Posted October 12, 2009 Share Posted October 12, 2009 lol very nice work dix Quote Link to comment Share on other sites More sharing options...
Administrators daredevil Posted October 12, 2009 Administrators Share Posted October 12, 2009 Great job but maybe add scrim team members as well? If it wouldn't be too much work? http://fearless-assassins.com/topic/3203-forums-private-access/ No replies Dixus that flags are awesome Quote Link to comment Share on other sites More sharing options...
Mobby Posted October 12, 2009 Share Posted October 12, 2009 n1 one dixus!!!! Quote Link to comment Share on other sites More sharing options...
Dixus Posted October 12, 2009 Author Share Posted October 12, 2009 your welcome. was a funny little project. The scripts are still running. It will be much more faster tomorrow. Hopefully lawl Quote Link to comment Share on other sites More sharing options...
-=Medic=- Posted October 12, 2009 Share Posted October 12, 2009 WOW big brother you doing a great ART work over there Quote Link to comment Share on other sites More sharing options...
Dixus Posted October 13, 2009 Author Share Posted October 13, 2009 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. Quote Link to comment Share on other sites More sharing options...
Cranky:> Posted October 13, 2009 Share Posted October 13, 2009 Woah, nice one Quote Link to comment Share on other sites More sharing options...
Dixus Posted October 13, 2009 Author Share Posted October 13, 2009 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 Quote Link to comment Share on other sites More sharing options...
-=Medic=- Posted October 13, 2009 Share Posted October 13, 2009 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 Quote Link to comment Share on other sites More sharing options...
Duckie Posted October 13, 2009 Share Posted October 13, 2009 very nice! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.