try =sumproduct(b1:b10;a1:a10) and put the $ where appropriate. If the syntax isn't right, google SUMPRODUCT for exactly how it works in ooo.

looks to be working nicely, cheers

hmm, on further inspection it's not quite working as intended, will have to play some more with it

actually, it probably ought to work, but there's something fundamentally wrong with the spreadsheet. if i'm doing a simple sum of a row which has nothing negative in it whatsoever, and the first figure is 10000, it really ought not to come up with a result of 200

lol for fourth post in a row, but i've kind of worked out what the problem may be, an awful, awful lot of the entries i've made have rendered themselves as text, rather than as a number, which is an unbelievable pain in the arse. and oddly it seems to be completely at random how it's been done. jesus ****ing christ

I found something today that I can't explain, and Google isn't helping me much.

I was asked to change some pictures on the company website that are only able to be changed on the raw files. The request also included changing the name of the photos because the previous name for the photo was head-scratching. Not that the really matters, but I figured "eh, why not?"

Every page is built with PHP files, and just about every page on the site ends in .php.

One of the pages in question ends in .html, but there were no .html files in the file system, so I decided to investigate further on the assumption that the page name was changed via htaccess.

I did find something that looked like this (comments in the file confirmed there was renaming):

.(*).-words-.(*).pagename.php """"" .html

Hopefully that sort of illustrates what is happening. Well, I don't know what the (*) does, but I assume it is some sort of concatenation from the includes connected to the page.

So the fake webpage in question is ...../mycoolpage-words-pagename.html while the php file the information is on is pagestuff.php.

The question is: Why did they a) change a .php page name to .html, and b) why would they do a rename like this, where instead of letting the page simply change to .html, they had to add extra text to the middle of it and c) why would they only choose to change certain page names and not all of them?

I know that they really should just be dropping all the extensions, but that's not really the question here. Just wondering if there's some sort of security / historical reason for something like this to happen.

As for the image: I just deleted the old images and renamed the new ones to the old names. I wasn't in the mood to trace a bunch of include files and other stuff.

Seen when signing up for a VPS:



uh... security number, I guess?

that's a good one for friday error'd on thedailywtf.

A couple of random theories.
- .robots is blocking all .php and allowing .html
- Some external sites (or internal pages) have links to now-renamed content.

rethinkvps is a pretty bad. the owner tries to open a bunch VPS and just shuts them down and they have horrible uptime

so prolly why their security question thing is all messed up. if you want cheap try alienvps, also i post offers on a website i own: http://www.lowendbox.com/

lol at you knowing the VPS provider by that

i just use it for squid proxies (i have alienvps too, along with like 15 other VPSes)

i'll check out yours! (currently just using WHT VPS offers)

oh yea i gotta "review" them which just means look at their website and determine if its scammy enough to reject their advertising money and i remember that

alien has a nice deal until midnight, 190 ram, 19 gb storage 190 gb transfer $14/year or a 512 meg ram 512 swap, 20 gb disk, 500 gb transfer for $4/month

these budget ones would never put like a real application or site on because none are that reliable and use cheap equipment, but i do use them to host some static website that make not a lot of money or to run scripts that would destroy resources on my main servers so i'd rather they destroy less ram but take longer.

rather pay them $4/month for a vps with root than $5 on shared hosting

yeah exactly

i run a bunch of squid instances for reasons you can probably surmise, so that's basically all i use the cheap/scammy ones for. if they ship a ton of IPs for $1/IP (bonus: different c blocks) then i'll sign up for them and slap my install script on there

nothing too exciting though with the mlb stuff gehrig and i are working on i find myself with a bunch of VPSes with no CPU/RAM load and a bunch of applications w/ blocking code that are easily converted (sort of) to asynchronous/distributed stuff

I've seen some people bring up SEO in here so I figured I'd ask this here.

website/?q=searchterm

vs

website/searchterm


does it really matter?

does it matter to whom? to me? not really (though i prefer the second one). to an indexing robot? perhaps.

alienvps has been down since my post abotu them. awesome timing IMO

This made my day https://www.google.com/search?q=recursion

Recursion
If you still don't get it, see "Recursion".

semi programming related since i assume lots of you are on your computers all day: keyboard suggestions?

got a Logitech K800 keyboard a week ago and have decided to return it. it has these weird rounded keys that constantly cause me to mistype or my fingers to slip off the keys.

in general i really like laptop keyboards and until this logitech k800 i havent used a traditional keyboard in god knows how long, but now i have to get one. does anyone have any laptop-esque keyboards they love using 8 hours a day?

I think a Razer Lycosa is pretty much exactly what you're looking for: http://store.razerzone.com/store/raz...ctID.169417800

It has rubbery and very flat keys, almost a mixture between desktop and laptop keys. I've been using mine for years now, without a problem.

I guess it's pretty much the opposite of a laptop-keyboard, but I don't understand why anyone would use anything but the curved ergonomic keyboards, like the logitech K350 or similar.

They allow your arms/hands/wrists to be angled much more naturally and the only downside is that when you have to use a 'normal' keyboard, they feel really cramped and uncomfortable.

Mechanical keyboard IMO.
http://www.daskeyboard.com/images/products/keyboard.jpg

http://www.cherrycorp.com/english/keyboards/index.htm

Sadly, I spilt tea on my last one and fried it

I was desperate and needed a replacement quick so got a ****ty Logitech thing from PC world (which I typo about every 3rd word on thanks to the keys being mad of marsh mallows...).

Juk

I use the Apple wireless keyboards on all my Macs as much as possible, pretty much the same as the lappy keyboard but you don't have to put your wrists on the hot laptop body.

I have a noob html question. I just started html programming a couple days ago and I'm trying to fill an element vertically for the whole page.
So i have something like this:

<style>
div.element {
width: 150px;
height:100%;
background-color:red;
margin-right:auto;
margin-left:auto;
}
</style>

This code works when I haven't declared a doctype but as soon as i declare a doctype the height only covers the text area. Everything else about the program works fine so I don't think there's anything wrong with the rest of the syntax. It’ll work if I set the positioning to absolute but I would like it to stay in the center of the page. The searching i've done makes it seem like there should be nothing wrong with it.

A simple answer like, “you’re not using the right doctype” will suffice.