Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - Dragooon
46
Off-topic / MySQL Optimization question
« on September 7th, 2011, 07:11 PM »
I got a simple table having the following fields

Code: [Select]
id int(11) primary key auto increment
wpm_total int(11)
wpm_effective int(11)
time int(11)
duration int(11)
device varchar(20)

Now if I got a few statistical SQL queries
Code: [Select]
SELECT COUNT(*) AS num, device
FROM scores
GROUP BY device
ORDER BY device_total DESC
Code: [Select]
SELECT (AVG(wpp_effective) / AVG(wpp_total)) AS average
FROM scores
WHERE device = :device
GROUP BY :device
Code: [Select]
SELECT AVG(wpp_effective) AS average
FROM scores
WHERE device = :device
GROUP BY :device

What'd be the best way to optimize it(Indexes, etc) so that it doesn't cause heavy lags(Apart from caching)?


47
The Pub / Public repository?
« on August 29th, 2011, 02:12 PM »
Have you guys thought about it? Most open source projects got a fairly public repository, IMO it would be a nice idea.
48
Off-topic / PHP IDE for windows
« on June 23rd, 2011, 03:57 PM »
I'm looking for a new PHP IDE for windows, preferably native(Java ones don't work as beautifully), I've been using phpDesigner but am thinking of moving on. What would you guys suggest?
49
Off-topic / Post-XSS scenarios and database driven sessions
« on June 21st, 2011, 12:45 AM »
I've been running post-xss scenarios and the obvious one is cookie stealing(Perhaps the only use of XSS) and after a cookie is stolen. The common protection is using sessions and I've not been doing that, although can't that too be stolen since it has to be tracked via cookie? So is there a way to protect against a post-cookie stealing scenario?

Also, how do database driven sessions help?
50
Off-topic / htmlspecialchars while inserting into DB
« on June 20th, 2011, 09:59 PM »
Does this make sense? I've been wondering, wouldn't mysql_real_escape be enough while appending to DB?
51
Off-topic / Salary in web development
« on June 15th, 2011, 12:49 PM »
I've been thinking about this over and over, and I've been wondering, if you're a qualified web developer with a proper degree than what is the normal salary one would get? If you got some actual references than that would be great.
52
Off-topic / SMF4Mobile in splitview template
« on June 9th, 2011, 12:44 PM »
For the next version of SMF4Mobile, I was thinking of converting it to the splitview plugin template, it offers enhanced supports  for tablets while maintaining a nice compatibility to mobile devices.
Here's the official demo :

http://asyraf9.github.com/jquery-mobile/

Please let me know what you guys think.

PS : I know this really isn't related to Wedge but I do plan on porting the theme so I guess it is somewhat relevant.
53
Off-topic / Kung Fu Panda 2 (Possible Spoilers)
« on May 27th, 2011, 08:58 PM »
Have you seen this movie? Why, why not? What are your views?

(click to show/hide)
It is a damn good movie in my opinion, much better than POTC: On Stranger Tides in case you are in a dilemma. While maintaining its comedic nature, it manages to deliver a story worth watching. Overall, greatly recommended.
54
Off-topic / Spam
« on April 14th, 2011, 02:39 PM »
Spam.
55
Off-topic / Total War Shogun 2
« on March 29th, 2011, 03:29 PM »
I've been mostly absent due to my exams(Which are going quite good) and because I've been playing this lovely game that came out a day before my exams started, for any kind of strategy fans it is one very nice game to check out. I really recommend it. Its basically a hybrid game of TBS on a grand campaign map where you govern your empire, recruit units, manage cities and diplomacy etc and a RTS part where you can fight real time battles. The game's timeline is set in real 16th century Japan. I even wrote an extensive (official) review for it on Total War Center if anyone's interested.

http://www.twcenter.net/forums/showthread.php?t=435978
56
Off-topic / Restoring my love with iDevices
« on February 10th, 2011, 11:42 AM »
Recently I injured my foot and had to take a bedrest(still am injured, but can move now) so I had nothing better to do than to play with the gadgets I got, I stopped playing with my iPod Touch a few months ago after I got my HTC Desire, although since I got bored of it due to excessively using it I decided to play some games I got on my iTouch(Have over 200$ worth of them :P) and it's a fantastic thing, not that I don't remember how good it used to be its just that I like it more now since I haven't played with them since quite a while. The best thing is playing Fruit Ninja with my sister and father(I own 2 iTouches), basically we use Fruit Ninja's multiplayer compliance with Game Center to play a local match(Not that it really is local, we're just 2 players in this world playing an online match, it just happens to be that we're sitting on the same room) and its a fun experience, we've played over 200 matches in past 2 days. Apart from that I recently got Zombie cafe which's a fine game too, I realised its more real time based rather than serving a few dishes in a few minutes and be jumping a few levels in an hour of gameplay, so its a nice thing for a change. Apart from that Real Racing 2 is also a good game I just bought. Sadly I can't play FPS on iTouch(Just doesn't work for me), tried CoD, Battlefield BC2 and even Modern Combat 2, just didn't work(KB/Mouse FTW!)

Anyway, do anyone of you guys play/own Fruit Ninja(And if not, WHY THE HELL NOT?)? Anyone up for a game? My Game Center name is "Garg S", do tell me if you send me a friend invitation. I'm up for a game 24/7.
57
Off-topic / Git
« on January 7th, 2011, 06:40 PM »
So...I just switched my project to git and so far its been nice(Purchased a 12$ plan over github.com). I added TOX-G's git repository as a submodule to my repository and it actually works well! Branching is surely a lot more sensible than SVN, that and its DCVS is nice for teams. It surely is better than SVN in every way, I'm using Tower for Mac as a client.
58
Off-topic / Do animations help?
« on December 31st, 2010, 07:42 AM »
This is something I've been debating with myself. I've been adding subtle animations in my project lately(For example being, as the user submits the form, the form slides up and the confirmation screen slides down, or if a user changes an option which requires an alternative field to pop up then the current field fades out and the next field fades in), ofcourse this is for eye candy and offers no usability, but it looks good. Do you think it makes a difference?
59
Off-topic / Lightbox
« on December 24th, 2010, 12:28 PM »
I'm looking for a nice and feature-full yet light(< 35KB uncompressed) lightbox for jQuery. Anyone got ideas?
60
Off-topic / What to do with an annoyingly large PNG background?
« on December 22nd, 2010, 01:00 PM »
I got a background(body) png image which is very large(It is about 1964 x 810 and weights 304KB). I am wondering if there's a way to skim it down to a smaller size or if there's a way to send an background image according to the user's screen size?
Link : http://bazaarshotdeals.com/templates/default/graphics/bg.png