Fair Compensation and Website Security

Just throwing a question out there. What would you deem fair compensation if somebody found a security exploit in your website?

This particular exploit that I discovered offered access to half of a members credit card number, as well as personal information [i.e. - full name, address, etc] for every order on their [e-commerce] website.

Since first finding the exploit, I have also been able to exploit the download section of the website. I can gain access to every file on the site, without having to purchase them. I am still waiting on a return phone call on this particular issue.

What do you think [a] I was offered and [b] what I should have been offered?

Nick

Using JQuery to clear a div [or an element]

JQuery continues to make things easy on us. The following code will remove all of the children elements from the parent.

$('#idOfElement').empty();

Now, that was easy, eh?

Nick

Using ORDER BY with UPDATE

Yep, you read the title correctly. This problem presented itself when I needed a quick and dirty way to update an auto_increment [a_i] field in a database. I wanted to move the a_i field up by n, where a_i > x. The query looked like this:

UPDATE table_name SET id = (id + n) WHERE id > x ORDER BY id DESC

To see why one must do it this way, try to do the query without the ORDER BY.

Nick

Yet another example of the ‘perks’ of Socialism

OK, fine, full-blown Socialism does not exist in the UK; however, the UK is definitely more socialized than here in the States. Below, you will find a great ‘perk’ of trying to work with more-socialized countries:

Q: How come other services are not blocked?

We can only really speak for ourselves on this one. There are two rules we follow: to abide by standing copyright laws, and to pay artists fairly.

In the UK, to be a licensed service for all the music we want to play on Pandora, we are being asked to pay per track/stream rates which equate to over 80% of our gross revenues. This licensing framework does not enable any entity to grow an economically viable ad-supported Internet radio business. These rates apply to all Internet radio, or so we have been told. You would have to ask those other companies about how they are still streaming to the UK.

That is from www.pandora.com, one of [if not the] best free-streaming-radio websites available online.

Nick

mysqli_num_rows() functionality

Warning: mysqli_num_rows() [function.mysqli-num-rows]: Function cannot be used with MYSQL_USE_RESULT

Does this error look familiar? Yeah, weird that even though you are using mysqli_, it says MYSQL_; trust me, I know. Instead of using mysqli_use_result(), try mysqli_store_result(). Problem sloved.

Nick