« first day (214 days earlier)      last day (4792 days later) » 

6:00 AM
@TimStone - Is there something wrong with this line:
$filteredData[$key] = mysql_real_escape_string($value);
 
I don't see anything obvious.
 
Hrm...
I've diagnosed that PHP does get the values.
I have one array of values and I loop through them to escape them.
Then I put them into the second array
@TimStone - How about this one:
 
Weren't you going to use PDO or some other database abstraction layer, by the way?
 
$filteredData = array();
Was, but this is simpler.
It works on localhost.
@TimStone I was going to use Doctrine but I couldn't get it working.
 
I'm not sure that simpler is the way to go here given what you're writing this for, but I'll just look the other way on this one...Anyway, there's nothing wrong with that. What does your query statement look like?
 
6:07 AM
Hang on.
@TimStone:
INSERT INTO raffle_entries (first_name, last_name, address, city, state, zip, phone, email, tickets, pledge, cardholder, carrier, num, solicitor, expiry, timestamp) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '5ZGsb8udRryOQZy2Gotg/fLTVTs2VhjuwtLZ5VVnL34zjc7UHq+DT+PxuDZ+biH+n8DeWCAbM3w=', '', '', NOW())
It's not getting the values properly, except for one, which is explicitly set.
So I'm not copying my data over to the filtered array, apparently.
 
Oh, this is the generated query.
 
Yes, it is.
I do this:
foreach($unfilteredData as $key => $value){

	// add escaped data to filtered array
	$filteredData[$key] = mysql_real_escape_string($value);

}
to copy the data over from the original array, which I've confirmed to contain the information.
Now, the CC information is encoded and then add with an explicit key, and it seems to get inserted.
$filteredData['ccNumber'] = $e->encrypt($filteredData['ccNumber'], $key);
$filteredData['ccNumber'] = base64_encode($filteredData['ccNumber']);
And that shows up in the query.
What confuses me is why this works on localhost...
(removed)
 
And what's the code that actually generates the query?
 
foreach($filteredData as $key => $value){
$values = $values . "'". $value ."', ";
}

//Add a MySQL timestamp to the values string
$values = $values . 'NOW()';

echo "<br /><h3>Values: " . $values . "</h3><br />";

//Build the query
$query = "INSERT INTO " . $table_name . " (". $fields . ") VALUES (" . $values . ") ";
The query works on localhost.
Could the mysql_real_escape function be disabled on my server, returning an empty value?
 
6:25 AM
And what's the PHP version on the server?
 
Er, not sure.
Hang on.
 
No, if the function is undefined it'll just die on you.
 
@TimStone It's version 5.2.13
 
Hm, I dunno then. I'd print_r($unfilteredData) and print_r($filteredData) and see what you get.
 
@TimStone then it dies
No return, error message or anything.
 
6:32 AM
Err
 
Could this be relevant?
unset($unfilteredData['expireMonth']);
unset($unfilteredData['expireYear']);
Got it!!!
\O/
\O? -> \O/
 
What was it?
 
I called mysql_real_escape_string($value); before connecting to the database.
 
Oh...I was going to ask about that, but it's supposed to generate an E_WARNING in that case.
 
I just remembered @TheOutOfStarsException telling me that that function causes MySQL to escape the content.
And then I saw that the connection was opened later.
It worked on localhost though... strange.
See, as an iOS dev, I'm used to using as little resources as possible, lazy loading etc.
I left the connection until after the query was built, but then it wouldn't be able to do the escaping...
 
6:39 AM
@Moshe You don't have a password on your root MySQL account on localhost?
 
No
Oh, heh.
That explains it, doesn't it?
 
nods
 
learned quite a lot tonight. Going to sleep on time is not one of them.
Thanks @TimStone.
 
Yep
 
Confirmed, it worked. Tune in tomorrow for "writing an admin panel". :-/
Gnite!
 
6:48 AM
G'night
 
6:58 AM
So much to flag.. sighs
 
you can do it!
 
Hahah. I actually spent so much time going through stuff I got rid of my votes for the day. I've got 7/32 flags left now.
 
@TimStone Wow, hrmp... now that I actually take care to look at the close tab in tools, my close votes disappears very quickly
It was gone 5 hours after the new GMT day yesterday
 
Good morning!
I love early sunday mornings, so peaceful and quiet
Everybody curing their hangover
 
Ah yeah, I really need to get to 10K so I can see that. I don't come across a terrible lot of stuff that needs to be closed that isn't already closed, heh.
'Ello @Pekka. Hahahah :P
 
7:06 AM
3 hours ago, by mootinator
It's cheaper to enroll in a Photoshop class at an accredited university and buy the student edition than it is to buy the full edition of Photoshop. Interesting.
Hahahahahaha!
So true
Sadly, it's not a viable option because you're not allowed to do commercial work with those editions.
 
Ugh, yeah, I don't even want to think back to how much I paid for Web Premium CS3 and then the CS5 upgrade.
 
@TimStone I can pipe some of the questions to the Regulator HQ if you want :P
 
Feel free, I've got close votes to burn. ;)
 
@TimStone It's crazy. I bought CS1 back in the day, and managed to sell it four years later for just €100 less
 
I happen to have access to the student edition :P
 
7:08 AM
They are very stable in value, like Macs
 
Adobe keeps harassing me with these surveys...You give me a discount next time, and we'll talk.
 
@TimStone agreed
"Please take this twenty-minute survey for free, so we can charge you even more for the next version"
 
Heheh, exactly.
 
7:29 AM
@GeoffDalgas Be honest, you actually don't use cookies because @RebeccaChernoff stole them for the Town Hall chats:
2
 
Heheh. Now I'm hungry, hmm..
 
that seems...random.
 
I got done looking for stuff to clean up on SO and headed over to read stuff on Meta.
 
7:33 AM
And, in my usual fashion, I carried my thought over into chat with absolutely zero context. :p
 
7:49 AM
 
Hah :P
 
@balpha More like a concurrency issue
 
What, have we still not deactivated @YiJiang's wise-cracking owl mode?
I'm 10 minutes out of bed, my vocabulary hasn't warmed up yet :)
 
@balpha I... never knew I was a wise-cracking owl
 
@balpha That code is heavily optimized with a huge warning comment about touching it above.
 
7:53 AM
only difference?
var YiJiang = new GenericPerson(wiseCrackingOwlMode: true);
var MichaelMrozek = new GenericPerson(wiseCrackingOwlMode: false);
 
@balpha It is more fun when the last editor shown on the page isn't the most recent revision shown on the revisions page.
 
@balpha Well, at least you won the edit race
 
I also liked my revision comment better :\
 
Some people just don't have any creativity, what can you do?
 
imagines @balpha going into the db deleting any traces of that previous edit
 
8:01 AM
> When he was 3, he asked if 5 was even. I told him, "No, even means you can cut it in half." Long pause.... "But 5 is 2 1/2 plus 2 1/2." He's been like this ever since he could talk. His mother worries about his dating prospects, however. – Fixee ↵ 8 hours ago
3
 
@balpha Saw that, very cute
 
Is that something resembling humor/fun on math.se?
4
 
@RebeccaChernoff [fun] is synomyn'd to [recreational-mathematics], so no I guess
 
Ah, recreational maths, exciting stuff.
 
8:06 AM
math.se itself isn't too bad. it's meta.math where the werewolves live
 
Yes, that is true.
 
Hmm, I wonder what I should be working on..
 
do we need a wheel of tasks? (:
 
Might be helpful, yeah. ;)
 
@RebeccaChernoff We should, though 'chat on Meta' would take up 90% of the space
The other 10% would be 'Making fun of @RebeccaChernoff', of course
 
8:14 AM
s/RebeccaChernoff/MichaelMrozek/
 
Oy little blue mod girl, which way does the procrastinating smilies go today?
3
 
scratches head
 
Right, so what should go on the Wheel of Tasks?
 
Well, my problem right now is that I don't even know the list of things I have to work on, so :P
 
8:23 AM
@TimStone Right, then clearly its time to make fun of @RebeccaChernoff.
 
abort mission |:
 
Heh :P
Hmm, there's not really anything on the userscript issue list. We need more users to complain!
 
Hi! :)
@TimStone which userscript?
 
SE (Chat)? Modifications.
 
8:40 AM
SE\s?(Chat)?\s?Modifications
 
you need to escape parenthesis btw :D
 
No, it's a capturing group. :P
 
I have given myself to the werewolves:
0
Q: A property of subsets of topological spaces

balphaBack in college I tried to find characterizations of compact (metric) spaces that make use of Lebesgue's Covering Lemma. During the course of this, I defined the following (pretty arbitrarily named) property of subsets of topological spaces: If $X=(X,\mathcal{O})$ is a topological space and $...

 
@TimStone \O?
 
@balpha we'll come after you and save you \o/
 
8:48 AM
@Fosco, @Zypher, @drachenstern, when you get this, there should be a TestFlight email in your inbox.
 
@RebeccaChernoff I dunno, that's Maths country...look at the size of those words.
 
should be asleep
 
@balpha you can smite them with your dev powers if they give you a hard time.
 
I doubt they would :) Mathematicians are usually quite nice, in their own way
 
Or you could give them the carrot: Offer them to restore the old way comments used to work in exchange for niceness and cooperation
@balpha yeah, that's my experience too. At least the real-life experience
0
Q: Search on specific sites only

PekkaApologies if I'm overlooking something blindingly obvious, but is there a way to perform a network-wide search query on certain sites only? Like for example, searching for "mySQL vulnerability" on SO, SF, and security.SE. (pulling this out of my arse, my question is about the generic approach to...

Anybody happen to know the answer to that off the top of their heads?
 
9:04 AM
:O
I wonder why do I get a captcha if I don't have any links in my answer?
And the captcha…
 
@Pekka SO dominates these results but it is searching.
 
@Rebecca ah, wasn't aware of the OR. That will work, thanks!
@Rebecca should I delete the question, or leave it in place? Might be useful to have around
 
I'm answering. I wasn't sure it would work at first, so was testing. (:
 
@RebeccaChernoff typo. it's security.stackexchange.com, not securitystackexchange.com
Hmm, though this searches in MSO, too :/
 
@Nyuszika7H yeah, that is probably unavoidable
Unless Google allow for AND NOT?
 
9:09 AM
site:stackoverflow.com site:serverfault.com site:security.stackexchange.com -site:meta.stackoverflow.com -site:meta.serverfault.com -site:meta.security.stackexchange.com mysql vulnerability
It actually works. No, it doesn't. :/
 
you need AND for those -site:
 
I guess Google automatically adds AND…
Ah, my fault, I didn't add OR between the included sites.
 
yeah, OR for includes, and AND for excludes, imho
 
@badpssockpuppet I don't understand your comment
 
9:23 AM
@balpha For all zero neighborhoods of the non-existant boundary the property would be valid, so it'd be boundless and relatively finite?
I haven't studied topology really :P
(A for all statement is true by default if the "selector" doesn't "match" anything)
 
well, first of all, every topological space is boundless (is that even a word?)
because the whole space is open and closed at the same time
 
is there a difference between bound and boundary?
 
I don't know, I'm ESL just like you :)
 
I guess I'd have to study the topic first :)
 
1
Q: Animations with vanilla JS

Nyuszika7HI've used jQuery for a long time, and now I'm going to do some animations with vanilla JS. Here's my code so far: var box = document.getElementById('box'), a1end, a2end, cdend, a3end, a4end, animate1 = setInterval(function() { if (box.style.top === (window.innerHe...

Anyone?
 
9:31 AM
Hah, so a bound(ary)less space is finite :D
I knew I was missing something
chucks the vocabulary out of the window
 
I wish /\s{Infinity}(.*?)\s{Infinity}/ would work.
 
@badpssockpuppet boundless = has no bounds = infinite?
 
@RebeccaChernoff That's what one'd assume, I guess
 
but you said boundless = finite |:
 
boundary (in the topological sense) and bound (with regard to sequences or metric spaces) have nothing to do with each other
e.g. the open interval (0, 1) in the real line has the boundary {0, 1}, but it has no boundary if the interval itself is the whole space
 
10:01 AM
 
 
1 hour later…
11:17 AM
Oh goddamnit
Computer security: Wed 1615-1815, Thu 1415-1615
Data mining: Mon 1415-1615, Thu 1415-1615
Numerical Analysis: Mon 1415-1615, Thu 1415-1615
What the fucking hell!
Is that some sort of protection preventing people from following too many interesting courses?
 
0
Q: Don't use image flairs on the profile accounts page

Yi JiangThe profile accounts page always annoys me a lot because of the huge amount of time it takes to load. The problem with the page using image flairs for each account is that for devs and active users (who have accounts on a large number of sites) the page takes forever to load, sometimes with one o...

I don't know why I didn't post this earlier, but this problem has been annoying me for far too long
 
@YiJiang HTML flair is obsolescent, so it wouldn't make sense for them to use it while they tell everybody else not to.
 
@badpssockpuppet I didn't say replace it with HTML flair, I simply said that the same info can be better presented with plain HTML
No need for images, which takes annoyingly long amount of time to load
 
status-norepro
(and I have 31 accounts now :P)
 
@badpssockpuppet I tried @RebeccaChernoff - 48 accounts, with at least 4 or 5 not loading
 
11:29 AM
actually, speaking of @RebeccaChernoff
sizing fail? :(
 
My combined rep is 1k :)
 
Anyway I think my university is sending me a message
They need better timetabling software
desperately
 
11:52 AM
hello
 
 
1 hour later…
1:11 PM
@badpssockpuppet that is in order to prevent people from becoming hackers who can 1. break systems 2. extract actual delicious info from the stolen data.
 
1:24 PM
@Pekka and 3. answer on StackOverflow questions about 0.1
 
 
1 hour later…
2:31 PM
> TIP: To view this exercise without ads, click on the printer icon near the top of the page.
Why do website authors undermine their own advertisement strategy? :|
 
@YiJiang Users don't read anyway.
 
> TIP: To view the solution for free, put google.com into your Referer HTTP header
 
@balpha Solution?
 
> then scroll alllllllll the way down.
 
@badpssockpuppet I couldn't agree more. Printer cartridges are outrageously expensive these days.
Wait, what did you say again?
 
2:34 PM
@Pekka I said, "if woodchucks could chuck wood would they?"
 
EE?
 
@Pekka Waffles.
 
Yay! I have support for arbitrary block ciphers!
 
I'd see a doctor about that
 
Now, to implment Blowfish and DES...
(to start)
Now, if only I can find implementation details on them
 
2:44 PM
http://www.google.com/#hl=en&sugexp=ldymls&xhr=t&q=1.3+%C2%A3/l+in+%24/gallon&c­p=3&qe=MS4zIKMvbCBpbiAkL2dhbGxvbg&qesig=Ae8NZu-1zw4IrfxconJh6Q&pkc=AFgZ2tlBLYe7MEr-PXObSVPx2IclkKzR80N4--YbLyJS2WFDUva6fb2b235QkBLZF5MwnfusoeEJDG9ZrRNZjX-H6o8JD4afBw&pf=p&sclient=psy&qscrl=1&aq=f&aqi=&aql=&oq=1.3+%C2%A3/l+in+%24/gallo­n&pbx=1&bav=on.2,or.&fp=369c8973645261b8
those Google URLs are scary, let me tell ya
 
gallon?
ahh
 
Somebody must have made some kind of script that sanitizes those URLs removing all those mistery meat parameters.
 
Hmm, now EE doesn't even show the solutions for Googlebot!
Hmm, I guess we need IP spoofing, too, because my IP address remains the same, even though the user agent is Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) according to Live HTTP Headers.
 
wait. MCrypt as a library hasn't been updated since 2003?
 
3:24 PM
Two Stack Overflow users in a bar.

Bartender: Can I offer you a beer?
User 1: That's not a real question.
Bartender: Hm, okay. Our lager is excellent; give it a try!
User 1: Flagged as spam.
Bartender: Well then, would you rather like a pale ale, or is a pilsner more to your taste?
User 1: Subjective and argumentative.
Bartender: I can list all the beer brands we have, if you want.
User 1: Okay, but make it CW.
Bartender: We have Bud light...
User 1: -1
10
Bartender: ...Miller...
User 1: Low quality.
User 2, getting impatient: You should really work on your accept rate.
User 1: Is it my fault that all his suggestions are off-topic?
User 2: Are you saying it's the server's fault?
User 1: (thinks for a moment) Alright, I'll have a Guinness.
Bartender: Okay. Did you get here by car?
User 1: Yes.
Bartender: Then give me your keys please.
User 1: Why?
Bartender: I'm migrating you to Bicycles.
2
 
(yes, I'm bored)
 
lol
 
(yes, I'm bored)
 
I'd like to see a TAS of MSO
Shortest time from 1 rep to Trusted User.
With lots of neck-breaking circling, typing and Reddit spam action.
 
3:39 PM
@badpssockpuppet TAS?
 
@Nyuszika7H I thought they just used a cookie to differentiate browsers from bots.
 
@mootinator because bots can't handle cookies?
 
@Nyuszika7H Or just don't.
 

So two Stack Overflow users walk into a bar...

21 mins ago, 29 seconds total – 4 messages, 1 user, 0 stars

Bookmarked 4 mins ago by Yi Jiang

4
 
3:49 PM
Hahahaha lol
 
@Nyuszika7H Hahahaha!
Jan 12 at 18:53, by Michael Petrotta
comment flags in 10k tools has reintroduced me to the illustrious Col. Shrapnel.
I see he is in the box for a week
About time
 
4:54 PM
I hate when I can't cancel an installation… :/
 
5:08 PM
0
A: Make the mothership shoot its lasers on hover.

badp → → Here's how the mothership could look like when firing its lazers. To compensate for the brightness of the sheer lazers our mothership is equipped with, the remainder of the page should dampen by 90%. This is unfortunate, for the lazers look best against the scanlined effect.

Is that enough lazers?
Maybe I should add spiralling beams of energy
 
s/lazer/laser/ it's an acronym
A laser is a device that emits light (electromagnetic radiation) through a process of optical amplification based on the stimulated emission of photons. The term "laser" originated as an acronym for Light Amplification by Stimulated Emission of Radiation. The emitted laser light is notable for its high degree of spatial and temporal coherence, unattainable using other technologies. Spatial coherence typically is expressed through the output being a narrow beam which is diffraction-limited, often a so-called "pencil beam." Laser beams can be focused to very tiny spots, achieving a very...
 
what's that s/thing1/thing2/ thingy?
 
**L**ight **A**mplification by **S**timulated **E**mission of **R**adiation
@Nyuszika7H It means replace thing1 with thing2 . I think it's substitute and comes from various command line editors like vi
 
@ChrisF vim?
 
@Nyuszika7H Possibly. It's all a long time ago now for me. I've used visual editors for far too long.
 
5:19 PM
@ChrisF And what's your favorite IDE?
 
@Nyuszika7H Well VS2010 isn't my favourite at the moment - but I have to use it at work (Silverlight 4 with RIA Services). VS2008 is pretty good.
 
Nippon: Game of the Weekend Edition
leaves
 
Sup?
 
@ChrisF mine is Notepad++
 
Somebody should go suggest edits to this. q: I think you can suggest edits at least, a couple things are wrong and comparing to SE not SO would be better.
 
5:25 PM
@Nyuszika7H With C# there's too much to remember so I have to have something with Intellisense etc. We've got 4 (yes four) A0 posters on the wall at work with the .NET 2.0 class libraries. .NET 4 has to be twice the size.
 
@ChrisF Intellisense?
 
@RebeccaChernoff You've got to sign in
@Nyuszika7H I think that's the right term - where the IDE gives you the list of what can come next. So you type in a class name (say) and then it gives you the list of methods, properties & events etc.
IntelliSense is Microsoft's implementation of autocompletion, best known for its use in the Microsoft Visual Studio integrated development environment. In addition to completing the symbol names the programmer is typing, IntelliSense serves as documentation and disambiguation for variable names, functions and methods using reflection. Overview Similar to other autocompletion systems, IntelliSense is a convenient way to access descriptions of functions, particularly their parameter lists. It speeds up software development by reducing the amount of name memorization needed and keyboard in...
Autocomplete is a feature provided by many web browsers, e-mail programs, search engine interfaces, source code editors, database query tools, word processors, and command line interpreters. Autocomplete involves the program predicting a word or phrase that the user wants to type in without the user actually typing it in completely. This feature is effective when it is easy to predict the word being typed based on those already typed, such as when there are a limited number of possible or commonly used words (as is the case with e-mail programs, web browsers, or command line interpreters),...
 
@ChrisF yes?
 
Not me!
 
5:28 PM
@RebeccaChernoff OK - I'll sign in with Facebook and then revoke access later
 
Huh, it looked like it was regular user/pass when I looked.
But I figured I'd be lazy and see if I could crowdsource q:
 
@RebeccaChernoff It is, but there's a Facebook sign in too.
I've done a few. No idea how to get it to read Stack Exchange rather than Stack Overflow though
Can someone check if my edits have "stuck"?
 
I still see Feb as last updated
 
Is it possible to use the Stack Exchange engine for my own website?
 
@RebeccaChernoff How about now?
 
5:36 PM
@Garrett I don't think so but… answers.onstartups.com isn't on stackexchange.com, even though it's a SE site (not an 1.0 site)
 
@Ny
@Nyuszika7H thanks
 
@ChrisF no ):
@Nyuszika7H uhhh yes it is
 
@RebeccaChernoff huh?
 
Last update is 2011 Mar 6 17:37:16 for me
 
@RebeccaChernoff I meant it isn't something.stackexchange.com
 
@balpha yep, but it redirects to answers.onstartups.com
 
The reason I asked is for my company - I'm an IT pro and I want to find an issue tracking software that will smartly suggest KB items based on your ticket at creation time
 
Can someone check that my edits to socialcompare.com/en/comparison/… are visible to everyone?
 
@RebeccaChernoff More green for SO now plus I mentioned the whole network in the stuff at the top
 
5:47 PM
Are the top 5 fields un-editable?
 
@ChrisF I can't see it
 
@Nyuszika7H Odd
 
@ChrisF wait, I do see it now…
 
Hm, maybe I'm only seeing your first edit if you say you mentioned the whole network. Will check back, there seems to be a delay...
 
@RebeccaChernoff Looks like it
 
5:49 PM
Anyone want to sanity check an implementation for me? I'm trying to set a parity bit for every 8 bits (the 1 bit in each byte):
 
Ah, there we go.
 
$parts = str_split($stub, 1);
        $new = '';
        foreach ($parts as $part) {
            //Compute Parity
            $set = 0;
            for ($i = 1; $i < 8; $i++) {
                if ($part & (1<<$i)) $set++;
            }
            $result = $set % 2;
            if ($result == 1) {
                $part = $part | 1;
            } else {
                $part = $part & 254;
            }
            $new .= $part;
        }
 
I've just registered, and clicked Sign in while the page was loading… suddenly, that button was moved away and the Facebook sign in button received the click… :/
 
so is there anybody from the stackoverflow team here now?
 
@Garrett @RebeccaChernoff?
 
5:53 PM
just wondering what defines a "large organization" for Stack Exchange Enterprise
 
@ChrisF Hmm, I seem to be able to edit the title, the picture and the URL, too.
 
@Nyuszika7H I saw that after I posted that I couldn't ;) However I didn't think it polite to edit the title, but that's just me.
 
@ChrisF I changed the identity system to OpenID, since it seems that you can't register without an OpenID.
 

« first day (214 days earlier)      last day (4792 days later) »