TechnocratTechnocrat’s Random Thoughts

So I have tested all my first set of indexes and after realizing that going overboard was a bad idea.  But I have some more that have really helped.  This will probably be my last set of them.

ALTER TABLE `nuke_stories_cat` ADD INDEX ( `title` );
ALTER TABLE `nuke_donators` ADD INDEX ( `dondate` );
ALTER TABLE `nuke_downloads_downloads` ADD INDEX ( `hits` );
ALTER TABLE `nuke_downloads_downloads` ADD INDEX ( `active` );
ALTER TABLE `nuke_evo_userinfo` ADD INDEX ( `active` );
ALTER TABLE `nuke_modules` ADD INDEX `active_inmenu_catid` ( `active` , `inmenu` , `cat_id` );
ALTER TABLE `nuke_modules_cat` ADD INDEX ( `pos` );
ALTER TABLE `nuke_modules` ADD INDEX ( `inmenu` );
ALTER TABLE `nuke_users` ADD INDEX ( `user_level` );

Over the last few days I have been expanding my knowledge on MySQL indexes along with other useful tidbits.  I am not super strong on SQL.  I know enough to get by but it’s an area I would like to know more about.

Anyways after reading some good articles I began to find areas where we can improve both phpBB-Evolution and Nuke-Evolution.  One of which is the lack of proper indexing.  Nuke is a villain when it comes to this.  The indexing in its piss poor to put it nicely.  So I figured it would be a good place to implement some of the ideas I have found.  No better place to do it than the NE site….right!?

So I started going through and making better indexing.  I started with the core files and I just got done.  I have to say the difference is extremely noticeable.  I can already tell the page is loading much faster in many areas.  I also turned off the optimizing so I can see what tables get overhead and I can use that as a key as to what needs fixing.  So we shall see what the effects are long term but so far it has been positive.

If you are interested I have been keeping note on what I have done.  So give it a try if you want.

[UPDATE] So I went too far with some indexing.  Though it sped up the site it took up to much memory and caused SQL to crash :(  so I had to reboot the server and the site was down for a day.  So I took out the biggest indexes and I am leaving just the ones that I think will help and not cause memory issues.  Enjoy.

ALTER TABLE `nuke_modules` ADD INDEX ( `active` );
ALTER TABLE `nuke_blocks` ADD INDEX `active_weight` ( `active` , `weight` )  ;
ALTER TABLE `nuke_blocks` ADD INDEX `time_bid` ( `time` , `bid` );
ALTER TABLE `nuke_stories` ADD INDEX `topic_ihome_time` ( `topic` , `ihome` , `time` );
ALTER TABLE `nuke_stories` ADD INDEX `topic_sid` ( `topic` , `sid` );
ALTER TABLE `nuke_banner` ADD INDEX `position_active` ( `position` , `active` );
ALTER TABLE `nuke_session` ADD INDEX ( `uname` );
ALTER TABLE `nuke_evolution` ADD INDEX ( `evo_field` );
ALTER TABLE `nuke_bbadvanced_username_color` ADD INDEX `groupid_groupweight` ( `group_id` , `group_weight` );
ALTER TABLE `nuke_bbranks` ADD INDEX `rankspecial_rankmin` ( `rank_special` , `rank_min` );
ALTER TABLE `nuke_bbcategories` ADD INDEX ( `cat_title` );
ALTER TABLE `nuke_themes` ADD INDEX ( `theme_name` );
ALTER TABLE `nuke_nsnst_admins` ADD INDEX ( `password_md5` );
ALTER TABLE `nuke_session` ADD INDEX `guest_uname` ( `guest` , `uname` );
ALTER TABLE `nuke_session` ADD INDEX ( `host_addr` );
ALTER TABLE `nuke_bbadvanced_username_color` ADD INDEX ( `group_name` );

The Daily Show is one of my favorite shows to watch on TV.  I am a huge Jon Steward fan, not because he is funny (which he is), but because he is intelligent and meaningful in what he does.  The show isn’t there to make jokes but to point out situations that you have to make fun of or it will drive you crazy. Sure he hides it in his self deprecating humor some times but in the end you can learn alot by watching it.

I had never seen this clip before but I have to say this is an amazing piece of footage.  By far one of the more touching things on the original 9/11 day.  Bravo, Mr Steward, Bravo!

I have been playing Mercenaries 2 for about 15 hours and according to the game I am 75% done.  So I figured I would drop in a review about it.

First the good, you can blow just about anything up.  It’s fun for awhile to just walk, run, drive, or fly around to different areas and towns and just blow things up.  Dropping ordnance like daisy cutters and artillery on buildings and people is great.

You can also use a number of different vehicles in the game.  Boats, planes, helicopters, cars, APC, etc.  It’s fun for awhile to steal them and try them out.  There are a bunch of guns also.  Though I found really all you need is the AK (or carbine) and the RPG.  You use the AK for far targets and the RPG for buildings and vehicles.  For everything else simply run in a zig zag patter so you don’t get shot as much and then use melee against them.  One hit of that brings them down.  Yeah that’s it.  I rarely shot anyone when not in a vehicle.

The game is entertaining for awhile.  Then it gets repetitive…quickly.

Which brings us to the bad.  First off is the graphics.  Boy are they sub par.  Feels like a game from 2 or 3 years ago.  Though not awful they aren’t great either.  But that’s not the worst part of the game.

That goes to the glitchy bugs and game play.  There are so many bugs and problems with this game it feels like they didn’t have a QA team at all.  Here is a good example, you have to take over a base in the middle of the jungle (get used to it because that’s going to happen a lot but I will come back to it.) by dropping smoke and having the friendly faction fly in a strike team to take over the main building.  All the while you have to kill all the enemies and blow up the other buildings to defend the strike team.  I guess because they are incompetent.

On my first try I took it over but died before I got the contract complete screen.  So I had to do it again.  Yet this time every building was now owned by a the faction I was helping.  But the ground guys were still the enemy faction.  So I just sat back and let them do the hard work until the mission was over.  This is one of MANY example of issues in the game.

I also got stuck, clipped, and glitched out a lot in this game.  More times than I should have.

The AI in this game is mildly retarded.  You can hide or trick them really easily.  It makes the game easy for the most part.  Add to that, that after the first few missions you can beat all the rest by simply bypassing the intended route, the game isn’t that hard at all.

What do I mean?  Well for example there is a mission where you are supposed to take a boat and do a beach landing and then run a gauntlet of enemies, tanks, and enemy structures.  By the way the worst is the structures.  After you play for awhile you will understand what I mean.

So instead of doing that I simply took a helicopter and crashed behind the main building.  The used C4 to blow through the wall and take over the build from behind.  I have done that on almost every mission like that. Or another good trick is when you need to blow a building up simply get close to it and there is usually a wall that blocks you from getting behind it.  Simply toss a smoke grenade for an air stike over the wall and then run.  You usually don’t even have to be close with the smoke.  The bomb will do all the work for you.

That’s why I am so close to being done at only 15 hours.  Add to that I have spent probably 5 or 6 hours messing around.

The game is also very repitive.  There are 4 mission types: take over a structure, blow a building up, kidnap someone, race a vehicles (which is pointless in this game).  Mostly you take over a structure.  At first it’s fun.  Then after a while you start to wonder why they couldn’t think up anything else.

So in the end, rent it if you want a few days of entertainment.  I do mean a few.  But I wouldn’t buy it!

I downloaded Google Chrome a couple of days a go and have been playing with it ever since.  I have to say for being a “beta” it’s VERY nice.

First the good, it’s very fast at rending web pages.  Faster than FireFox and no doubt faster than IE (what isn’t).

It also has a new version of Javascript which is by itself a reason to use it.  Every JS page or widget you use with it is ungodly faster than with any other browser.  I hope to see it in FireFox soon because that is something that should be shared with the masses.

It also gives you more usable space than almost all the other browsers.  So it makes viewing things easier.  The tabs are also more intuitive and can be grouped.  Which is nice.  Supposedly each tab and window is its own instance so it helps improve security.  There is a lot more in there security wise but you can find more on that some where else.  I am just giving you my quick impressions.

Now the bad, some of the ways it displays some things are kind of odd.  Like there is no status bar (this is supposed to change in the future).

There is also the license agreement which has the web world up in arms.  Basically giving Google to much license over you.  This is something that was supposedly a mistake on their part and will be fixed soon.

There have been some complaints about it displaying webpages incorrectly.  So far I haven’t seen that at all.

There are also no addons (yet).  Which is a huge feature in FireFox.

But given time I am sure that this browser has the possibility of being the one to beat and maybe even killing the IE giant.  Only time will tell.

I originally went from Word Press to b2Evolution because I didn’t like the interface and some of the features.  Now 2 and a 1/2 years later the reverse.  In my opinion b2Evolution is just to far behind the times with their themes, addons, support, etc.  It got to the point that I just couldn’t keep working with it anymore.

It’s fantastic if you want to have a site with multiple blogs and bloggers.  It’s very powerful in that regard but not so much for the single blogger.  So to that end I by hand moved over many of the pervious posts.  I did ditch about 1/3 of them as they were no longer needed.

So day 3 starts with still no email of a game being shipped. I did get two emails from them though.

First one saying that I have earned more points and I have a bigger discount now on game purchases. Fuck buying a game! If I wanted to buy games I wouldn’t be using your service assholes. Where the hell is my rental!

I get another email which is about to put me to the point of canceling. “Are you our biggest Super Fan?” Are you kidding me! Seriously!!  It’s about a contest they are having “Show us how insane your love for GameFly”. I should make a video flipping them off and telling them that instead of having stupid contents they should be working on improving their service. Like I dunno, their queue system! Or maybe their poor shipping.

I also realized that Monday is a holiday, so if they shipped one today, which is looking unlikely, I would get it by Wed. So a week and a half. I should stop complaining and just cancel my service. Maybe NetFlix will get the idea and start renting games.

Again you stuck gamefly.com!

Gamefily.com still sucks.

So I mailed Conan back on Monday. I got an email Wed saying they received it. But here I am Thursday afternoon with no email saying anything has shipped.

So lets look at my queue:
Mercenaries 2: World in Flames - Coming Soon
Too Human - Low
Battlefield: Bad Company - Low
Call of Duty 4: Modern Warfare - High
Saints Row - Low
Ninja Gaiden 2 - High
Robert Ludlum’s The Bourne Conspiracy - Medium
Hitman: Blood Money - Low
Perfect Dark Zero - Medium
Condemned: Criminal Origins - High
Crackdown - Low
SoulCalibur IV - Low
Skate - High
Fight Night: Round 3 - Medium

Look at how many of them are low! Almost 50% of them. I don’t think I have a crazy queue either. It’s not like its stacked with that many new releases. How long has Saints Row, Crackdown, and Hitman been out? Long enough I would think.

So which game do you think they will ship me? I am going to go with….Condemned: Criminal Origins. Why? Because it has the lowest game rating. But they should be sending me Call of Duty 4: Modern Warfare. So lets see

Either way at minimum it will take a week for me to get a new game in my hands.

After writing my last blog post about gamefly.com (http://www.techn0crat.com/index.php/2008/07/25/gamefly-review) I was sort of thinking maybe I was too hard on it. So I decided to try it again, make some notes, and be a little more scientific objective about it this time. The results were the same, gamefly still sucks in the same areas that I complained about before.

I turned the my previous game into the local USPS at 8:00am on Monday and setup my game queue with no currently availables at all. Then noted my queue.

So I get an email on Wednesday letting me know Conan was shipping. Again it took two days to get to LA. What are they paying for 3rd class mailing? Seems odd to me that it takes that long but anyways.

Now for my biggest bitch the queue. Conan was a one game that had a high availability level but it was the 3rd game down my list with that level. Plus it was in position 11 of my queue. What the fuck is the point of having a queue when the system ignores it!? I can not really understand stand it skipping low and medium levels I guess. But to skip two other highs!! Why!! This makes no sense and seems stupid as hell. I mean seriously what is the logic behind that? My best guess is they ship you the game they have the most of, which in this case was probably Conan because well the game sucks. But if that’s the case why have positions.

So off rant, I get the game Friday. Again with two days? I guess I am spoiled with Netflix. Really two days isn’t bad I guess.

Then I get an email on Friday saying they have received my previous game. Really!? Where did it go from Wed till then? Maybe it went with all the other games in my queue into some bizarre world where number positions have no purpose and customer service gets get treated like a $5 whore.

GameFly.com get your shit together please! >:XX

A couple of people have pointed out to me that someone has been running their mouth on a clan theme forum site again about me and 2.1.0. I am not going to say their name because really there is no point in talking about them anymore. I could sit here write another big long post proving how wrong and miss informed this person is, how stupid their claims are, post the IMs they used to send to me asking basic PHP questions to point out their amateur skill level, and crush him again. But what’’s the point really?

It’’s like fighting a retard. Sure you will always win, but in the end whats the point you just won against a retard and he is still retarded.

I have better things to do.