Charcoal HQ

Undo

6:59 PM

@ManishEarth Almost done!

2

ManishEarth

Linky?

Oh, local server. Nvm.

Undo

I'm uploading it now :)

ManishEarth

@Undo Do you use GTalk?

Undo

@ManishEarth Nope.

ManishEarth

ah

Undo

7:01 PM

You think you could make your modifications with it residing on my server, PHP and all? It would greatly simplify a few things.

I know you're king of userscripts :)

ManishEarth

@Undo As in? jQuery stuff---probably.

Undo

Ok, yeah.

ManishEarth

PHP--nope :P

Undo

:P

Let me try a few things.

ManishEarth

@Undo You're probably right about loading the context comments realtime. We could jquery a POST request that does the requisite SQL query

Undo

7:03 PM

or even just use the SE api, was what I was thinking.

ManishEarth

Or that. Yes. That.

Will still require server side PHP-fu because of #$%& CORS.

Undo

I'll get you access to the code. Don't worry about that :)

ManishEarth

hah

You could GitHub it or something. If you need I can make 5 private repos (but then I have to host it), because of student magic.

Undo

Nah - I'm thinking an SSH account on my server? Is there a way to restrict it to only one directory?

ManishEarth

@Undo that works. Yes.

Undo

7:07 PM

k

ManishEarth

Umm, you are root, right?

Undo

Yup.

ManishEarth

If so, you just give me ownership of the files.

Or wait, no, easy: you recursively chmod a+rw them

That should work

Undo

darnit, how do I run a MySQL update query from PHP? I feel soo dumb right now.

ManishEarth

@Undo there are three ways, one of which is not recommended.

Use the mysqli_* commands or the PDO commands

Undo

7:10 PM

Ok.

ManishEarth

pdo is better

but you may not have it by default

Undo

pdo is also hard.

ManishEarth

hah

Undo

there, made it update without a page reload.

AJAX is soooo fun!

ManishEarth

AJAX woooooo

Undo

7:13 PM

Now, how should we do authentication? Plain old login screen?

ManishEarth

@Undo sure.

Also, want to move this to a different room?

Undo

Sure. Lemme make it.

ManishEarth

wait, I can migrate messages and make simultaneously

Undo

Ok.

ManishEarth

← 46 messages moved from The h Bar

Undo

7:15 PM

That's better!

Now, to scp the stuff up to my little molucule in the cloud.

ManishEarth

room parent site changed to chemistry.stackexchange.com

Undo

Chem?

ManishEarth

Less clutter. I always make my rooms on Chem because chem chat isn't used anyway

otherwise this room shows up in the sidebar of phys

Undo

Oh. yeah, that's better

What should the URL be? erwaysoftware.com/....

/phys?

ManishEarth

sure

You may wanna turn of directory listing in Apache. Not a big hole, but can be used to find other vulns

> MySQL Error: Access denied for user 'physics'@'localhost' (using password: YES)

Undo

7:19 PM

You're already poking at my site, aren't you?

:)

ManishEarth

yes

Undo

yup, mysql not set up yet.

ManishEarth

boooooooootstraaaaaaaaap

Undo

:D

Thats a good thing, right?

ManishEarth

nooo you index.phpd it now i can't poke around

Undo

7:20 PM

lol

Exporting local phys table

And I shall connect to my server.

Add a comments db

ManishEarth

Undo

Import the export.

ManishEarth

Export. ALL THE THINGS.

Undo

Dangit, someone's watching a streaming video on my connection :(

Woo! Everything made it across.

Opening Le 1Password.

ManishEarth

@Undo you can kill that you know. Wireshark 'em and kill their connectionz

Undo

7:24 PM

Really?

ManishEarth

Well, depending on where you are, that can be illegal on a residential network.

But yes, theoretically, you can do that

Undo

If I own the network?

ManishEarth

If you're behind a NAT then you can do pretty much everything unless you piss the sysad off

If you're the sysad? Boom.

Undo

It's up now. Please don't do anything yet, though... not everything works 100%

ManishEarth

poke

Undo

7:28 PM

zaps finger with stun gun

ManishEarth

takes stun gun back, puts in mod holster, and reprimands for theft of mod equipment

Stack Exchange

ManishEarth has added Undo to the list of this room's owners.

ManishEarth

(no particular reason)

Anyway, got to study, catch ya later!

Undo

Ok! Will work when you get back - your username & password are below.

ManishEarth

@Undo there's a reason why public key auth was invented. But nevermind, I'll change the password once it opens up

Undo

7:35 PM

Yup.

ManishEarth

ssh @which server?

Undo

Not yet :)

ManishEarth

oh ah

Undo

It'll be erwaysoftware.com once I get you a pass made.

ManishEarth

ping me, I'm still leaving chat open so the bong will catch my attention

Undo

7:36 PM

k

Undo

8:38 PM

@ManishEarth Ok, the site should be up and running, you should be able to login with ManishEarth as a username, the same password as above. I'm working on the change password feature.

ManishEarth

@Undo You can just email me a pass

Undo

Also, I'm winning:

ManishEarth

hah

Undo

@ManishEarth Email?

gotit

ManishEarth

Logged in, but it takes forever to load

Undo

8:41 PM

Your password updated.

And yes, I'm working on the load times.

ManishEarth

aight

@Undo Hmm, it hasn't loaded yet. Is it loading properly for you?

Undo

@ManishEarth Yes.

ManishEarth

hum

Undo

A little sluggish, but barely noticeable.

Can you get to just plain erwaysoftware.com?

Are you using your new password?

ManishEarth

it loaded.

Undo

8:46 PM

Woohoo!

ManishEarth

@Undo So, what happens if I click "valid"?

Undo

@ManishEarth The 'flag' goes away, it gets marked helpful by my system, and your name gets attached to it.

But it stays in my system.

I'm planning to analyze the results of my little experiment, play with the algo a bit.

(which right now is shortest comments first)

ManishEarth

@Undo ah. So I have to delete it on Phys.SE myself. I can do that

Undo

Ya.

ManishEarth

I'll try to come up with some jquery for this later

Undo

8:48 PM

Sounds good.

And if your mod buddies want in, I can certainly give them accounts :)

ManishEarth

hah

probably not. Though comment clearing is something DZ likes to do, he's busy these days

Undo

Well, send him here if he wants in.

I hope it does some good!

/me out.

ManishEarth

/me is out too

ManishEarth

9:11 PM

Leaving API link here so that I can find it later: api.stackexchange.com/docs/…

Undo

9:31 PM

working on implementing context-droppy-downy.

wow, i'm going to have to make a php backend to circumvent CORS, methinks :(

/me hates CORS.

ManishEarth

@Undo does the SE API support JSONP?

Undo

not sure.

ManishEarth

@Undo Also, you may want to batch requests. Make the expandy thingy load comments for like the next 10 items. They stay collapsed but loaded. That way the API limit isn't reached

Undo

> All API responses are JSON, we do support JSONP with the callback query parameter. Every response in the API is returned in a common "wrapper" object, for easier and more consistent parsing.

^ Boom.

ManishEarth

ah, PHP backend it is

→ 24 messages moved to Trashcan

Undo

9:50 PM

aarg, since when does cmd-w close the whole chrome window instead of just one tab?

pouts

third time that got me today.

whoa, @ManishEarth, does the /comments/id/delete method in the API work for mods?

api.stackexchange.com/docs/delete-comment

ManishEarth

@Undo probably, the POST endpoint is the same

Undo

evil laugh

ManishEarth

But best not to use it. Either way, I'm not OAuthing with the app :P

Undo

Oh. yeah.

Undo

10:15 PM

(currently working on a PHP issue in the PHP chatroom)

Transcript for