« first day (44 days earlier)      last day (3768 days later) » 
00:00 - 17:0017:00 - 00:00

12:02 AM
@Manish Look now.
@Undo I added a Dev place for Manish with a link to Appease Manish page with a broken link. Good?
 
@hic Awesome!
Problem: you're showing it to everyone except Manish :P
@hichris ^
 
@Undo ?
if ($_SESSION['Username'] == "Manishearth")
 
Should be !=
 
@Undo Why?
 
Because you're blanking it out if it is Manish
 
12:10 AM
@Undo Oh, well I guess it doesn't work, since I'm not seeing it...
 
Huh.
I'll look into it when I get home. I might be looking at it wrong.
Gtg, have fun teasing Manish.
 
Okay.
@Undo When you're home, tell me how you do the date-stamps. I want to do the comments/day stats.
 
1:16 AM
@hichris123 What about them?
 
@Undo Like where you store them, is it a Date-Time attribute, etc.
 
Ah
Just a minute.
@hichris123 On every handled flag there is a handleDate field that's a TIMESTAMP
 
@Undo What table is this in?
 
@hichris123 Every site table.
 
@Undo So Select handleDate from stackoverflow, etc?
 
1:19 AM
Yup
 
Oh, @Undo, did you see my new stats page?
 
@hichris123 Yep!
Looks good.
 
Manish fixed part of it for me. :)
 
;)
 
@Undo What's the easiest way to check if a comment was handled today?
 
1:25 AM
@hichris123 Should be something like DAY(handleDate)=DAY(somethingtogettoday)
(unless you want PHP)
(then I don't know)
 
@Undo Yeah, I just don't know how to get today's date.
 
Yep.
 
You typed it in before I could type it in. :P
Can you do two Select's at once, like Select TIMESTAMP(Select CURDATE)?
 
1:31 AM
Should just be able to do TIMESTAMP(CURRENT_TIMESTAMP())
 
But then it's the date and time, not just the date.
 
@hichris123 What's wrong with that?
 
Oh, nevermind.
I may not put in the day stuff, since it would involve matching the day, month, and year, and seems to involve converting the TIMESTAMP into a Date.
Well, I guess I can just do Date(handleDate)
@Undo It works!
@Undo You also gave me and you hollow diamonds on the main page.
 
1:55 AM
@hichris123 I did?
Hrmph
@hichris123 Fixed.
 
@Undo I pulled it, seems to work.
 
Yup
@hichris123 Made some formatting modifications to your stats page, how do you like it?
 
@Undo Perfect, you know how to format, I don't. :P
 
Hehe, not really :P
 
@Undo Hmm... any other stats you can think of?
 
2:10 AM
@hichris123 Not right now, we'll think of more.
 
You need to post a database schema, @Undo.
 
I do.
 
Where?
 
I'm about to.
Current DB schema:
Users table:
CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` text,
  `password` text,
  `isDev` int(11) DEFAULT NULL,
  `isVerified` int(11) DEFAULT '1',
  `link` text,
  `apiKey` text,
  `ischarcoalmod` int(11) DEFAULT NULL,
  `isnetworkmod` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
Sites table:
CREATE TABLE `sites` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `siteTableName` text,
  `siteName` text,
  `siteRootURL` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
Single site table:
CREATE TABLE `stackoverflow` (
  `dbid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Id` int(11) DEFAULT NULL,
  `PostId` int(11) DEFAULT NULL,
  `Score` int(11) DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT NULL,
  `UserDisplayName` text,
  `Text` text,
  `UserID` int(11) DEFAULT NULL,
  `wasObsolete` int(11) DEFAULT NULL,
  `handled` int(11) DEFAULT '0',
  `handledBy` int(11) DEFAULT NULL,
  `wasValid` int(11) DEFAULT NULL,
  `handleDate` timestamp NULL DEFAULT NULL,
  `reason` text,
  PRIMARY KEY (`dbid`)
There we go
 
Thanks. :)
 
2:14 AM
np
 
@Undo So what does handledBy store?
 
The user id of the person who handled the flag.
 
2:32 AM
@Undo You up to adding a comment handling history?
 
@hichris123 Right now I'm thinking of adding a user-adding thingy
 
@Undo I hate audits, stackoverflow.com/review/first-posts/3695086#./…, downvoted since it was only code without anything else.
 
Hehe, that's a really borderline case.
 
Yeah. Whatever, it's just an audit.
So how are you going to do the user-adding thingy?
 
On the /cm/users.php page. Probably in a modal gizmo.
 
2:38 AM
How do you add the user via MySQL?
 
Just an INSERT
With a random password sent via email.
 
Is it sad that I've memorized my password?
 
Hmm... yes. Want it changed or something?
 
Well... no.
But I'd memorize the other one. :)
 
Hehe
I'll have to give CMs the ability to change passwords.
Heck, we should give users the ability to change passwords!
 
2:40 AM
Yeah, individual users can change their own passwords.
 
s/can/should be able to
 
Maybe also with the new user thingy automate an email?
 
That's what I'm planning.
There's still the issue of getting the email, but we can fix that too.
Not sure how, but we can.
 
We need a PM system for that.
 
Hehe
 
2:45 AM
We also need a complain to Undo about anything feature.
 
That would be a button that opens a new email pointed to Manish's address :P
 
Hmm... To:Manish Undo you messed up, I hate you.
 
Hahaha
 
Can you pull to main?
 
Sure.
 
2:55 AM
I don't like the unformatted stats page.
 
Done
 
I love your notes on things.
This doesn't really work yet.
 
It's true!
 
What, you thought you would forget and try to add someone with it. :P
 
You must not know me very well: I would try to do it :P
Then get very mad because it doesn't work.
 
2:57 AM
Hmm...
You must be an interesting person to deal with
 
Probably.
 
We did.
 
Should we make a page to determine what's wrong with the invalid's?
 
Not sure.
It wouldn't hurt, though.
@hichris123 Pushed the user-adding ui-without-functionality to /charcoaldev, what do you think?
 
3:06 AM
@Undo The add user button's a little big, other than that it seems fine.
 
Ok
 
Hmm... what's highest priority that you want right now?
 
@hichris123 priority?
 
@Undo What do you want me to work on?
 
Oh, whatever you want.
The handled-flags thing would sure be nice
We could be like real mods.
 
3:11 AM
@Undo What do you mean by handled-flags?
Like the flag-history?
 
@hichris123 Exactly
Global or per-site, whichever you like. per-site might be easier and more useful.
 
Okay, I'll work on it in a bit.
CM menu?
 
Probably.
 
What did you do that you had to fix in your last commit?
 
@hichris123 added an add user link on the stats page :P
 
3:20 AM
Ah.
 
Undo has made a change to the feeds posted into this room
 
prepare for feed flood.
 
posted on January 01, 0001 by Undo1

formatted cm stats page

posted on January 01, 0001 by Undo1

added some user-adding UI without functionality

posted on January 01, 0001 by Undo1

why did I do that?

posted on January 01, 0001 by hichris1234

Add flag history to CM dropdown

posted on January 01, 0001 by hichris1234

Maybe flaghistory shouldn't go to stats.php...

 
Really?
 
There, now we should have a live feed of commits. We'll see if it annoys us.
 
3:31 AM
We need the commits?
 
Undo has made a change to the feeds posted into this room
 
There, now it's a ticker feed. Nice for knowing when to pull on main.
@hichris123 We'll just try it. See how much it annoys us.
(and I hunted around for a GH feed url, and I'm going to use it!)
 
I'll be starting flaghistory.php soon
 
Yay!
I'm really interested to see how it turns out.
 
3:41 AM
Hm...
Should we do it per site?
 
@hichris123 That would be easier and probably more useful.
 
How do I do a site-switcher then?
 
Hmm...
Just use the $_SESSION["Site"] variable for now.
We'll make a proper switcher soon.
 
@Undo Do I need to import anything?
 
@hichris123 Only ../base.php
 
3:49 AM
@Undo Already imported
 
You're all set, then.
 
How do I sort the select by timestamp?
 
order by handleDate desc
should work
 
@Undo I'm going to need you to format everything. I'll commit it in a minute.
 
what Dev tab?
 
3:58 AM
@hichris123 Can do.
 
@Manish The one that's not there because I didn't code it right.
@Undo I need you to format it and also get the body, handleDate, and other stuff in the page. Committed it.
 
@hichris123 Yay!
I've got to go now, further formatting will be done on the history page tomorrow :D
 
4:16 AM
@Undo gimme a diamond so I can help!
 
Okay, see ya!
@Manish Look at the code.
 
I suspect treachery
@hichris123 where?
the hollow diamond?
 
@hichris123 yeah, but I can't test it without having to poke the session variables each time
 
@Manish Right now it's just billions of lines of this:
stackoverflow

total flags handled
flags handled today
 
4:38 AM
@Manish Hehe, now you know how I feel :P
diamond duly dispensed.
 
heh thanks
 
Np
 
@Undo hey, I don't really need the tools, but I'd like to help dev and it's hard to do that when you can't test things :p
I'd end up making UI minus functionality all over again
 
... Much like I don't really need mod tools but I want to help out more and it's hard to do that when you can't gain any privs past 4k/20k :P
 
@Undo ...so you create your own elaborate interfaces for streamlining moderation, like charcoal
heh
I think Charcoal is really, really effective in the hands of mods with the comment collector on
 
4:43 AM
I know... I just kinda don't want to have to create my own interfaces.
 
@Undo true, but either way you can't get a diamond everywhere
@Undo Challenge: There is something paradoxical in the revisions of this post. Find it.
 
@ManishEarth hmm... Not sure.
 
hint 2: look carefully at my profile details
 
How the heck did you do that?
bribe a Dev?
 
@Undo in a sense yes
 
4:50 AM
Please tell.
 
doing
Sklivvz used to own the post. (He was an active member of the site during the beta, before he was a dev). He doesn't participate so much anymore except the occasional meta/main post, and found the constant pings on that post (there was one point where there were like two answers a day) annoying. He was considering deleting it and having someone start a new thread, I asked him to reassociate the owner (CMs/devs have that tool)
 
I need someone to do that for me - I just got an mSO post migrated to m.br.so, and I get daily comment notifications in Portugeez :P
I hope they stop eventually.
 
@Undo nao sao metao
no clue what that means. I just see a lot of naos and saos in Portuguese. with tildes on them, but I can't type that easily
 
@Manish Fluent speaker right there. :)
 
@hichris123 ah. What do all the naos and saos mean?
 
4:57 AM
No, you.
Google translate.
 
I know some Spanish...
 
Ah, nao is not and sao is a form of to be
 
Not to be what?
 
@hichris123 I used to be awesome at Spanish. Then I moved here, and had to switch to French. And with lack of practice, French overwrote it :(
@hichris123 nao=not
 
4:58 AM
What's metao mean?
@manish Why French?
 
Meta
They're using the word all over the place
 
Are you kidding?
 
I have a plan to gain rep on Br.so without knowing a bit of Portugeez.
 
Do tell
 
@hichris123 India was a British colony. The most prominent European language (besides English) is French. Not used by anyone, but if you want to learn a new language that isn't Hindi/English/the state language, you usually do French. So it's easy to find a French teacher, but not a Spanish one
 
5:01 AM
I'm going to browse around the site, pick a random post, run it through Google Translate to English, make grammar changes, run it back through to Portugeez, and submit that as a suggested edit. Rinse wash repeat.
 
In the US Spanish is spoken by 50% of the people. So that's the "important" second language there
 
I said that once in the Tavern and Anna was like, "no please don't, Gabe will kill you"
 
@Undo COUNT DOOKU IS OUT TO GET YOU
 
Haha
I wonder how long it would take for me to get suspended if I ran around appending "dooku" to the end of random posts.
 
The bad word is "ku"
 
5:04 AM
I could add "ku" on the end of every other word.
 
@hichris123 When I moved here I knew Marathi and basic Hindi. And I suck at reading the script. The level of Hindi at the 10th grade is very high, and most native speakers still have issues. It's a compulsory subject too. And I can't read Marathi fast, though I speak it well.
If I wanted to have any chance at passing the board, I would have to take a different language that would be expected to have been taught from the bottom up from the 8th grade, and that would mean taking French or Spanish or something. My school didn't have a teacher for either so we had to find one, and French was more easily found.
@Undo Equivalent of English speakers adding -ass to every word they use
 
Hehe
 
Fun fact: The "ku" sound from ku and culata and all means the same thing in many Indic languages
 
@Manish Board = school?
 
@hichris123 board examinations. Standard exams given by many people. There are multiple boards at each level, and each school teaches the material for some board. You sorta have to give the exams to get admission in high school (called "junior college" here)
 
5:07 AM
Huh. Much different than the US
 
@Undo where? I don't see anything on either site
@hichris123 I know, I used to live in Boston :)
well, Malden, but nobody knows where Malden is.
 
@Manish Why the move?
 
Except those who live in Boston
@hichris123 My grandparents were in India and alone
 
@Manish You must then have a very interesting comparison of the US and India.
 
@Manish Log out and back in,
Huh. Br.so non habet moderadores.
^ combination PT and Latin
 
5:10 AM
¿Por que?
Sorry, don't have accents.
 
Quia lazyus sunt.
 
En ingles, por favor.
 
non industrious, et non habet postus for pro tem moderadores.
Hehe
 
Latin?
 
They don't even have a post for PT nominations that I can see.
@hichris Yeah.
 
5:12 AM
You don't read PT.
 
psuedo-Latin, with English used where I don't know words.
@hichris I searched for moderadores and looked for something that looks like a nomination thread.
 
@Undo oh right. i knew that :p
 
@Undo Put it into Google Translate.
 
> This is UI without functionality. It doesn't work yet.
heh
 
I did go through it using Chrome's auto-translate feature, actually.
@Manish What? It's true :P
 
5:15 AM
@Manish Look at my not-working flag-history thingy.
 
Also, @Undo, there was a certain mod tools feature request you edited today, with ###s i the title. Speak of it to no one.
@hichris123 wut
 
@Manish Uhmm... Why?
 
because diamond
 
CM > Flag History @Manish
 
@hichris123 I know, the wut was after looking at it
@Undo I mean, don't bandy about the existence of the tools mentioned there
 
5:17 AM
Ahh.
 
@Manish If you were on SO, its like 2000 * wut.
 
yep
 
@Manish I did think those tools looked pretty cool... wishes he could use them
 
GH doesn't have good mobile editing, so I'll fix it tomorrow.
 
@Manish Holy crap, did they hit that post with a nuclear bomb or something.
?
it doesn't show up in the 10k tools.
 
5:21 AM
nah, just deleted. By the OP
 
Ah, that's why.
@Manish What about those tools is so sensitive, if you don't mind me asking?
 
sockpuppet tools and all
there was a meta post on one of those tools last year and it was deleted
 
And we don't want the sock puppeteers to know about it?
 
the tool is supposed to be super secret. So secret that there weren't any links to it except from deep within the tool for quite a while :p
yeah
 
Oh, that post.
 
5:24 AM
Basically, if you're ever writing a meta post about mod tools or something, don't mention that one
 
I saw that one...
 
Hehe, okay @Manish
 
Night people
 
Night.
 
'night
 
 
10 hours later…
3:22 PM
@Undo That worked.
 
@hichris123 :D
I was trying to figure out if I should jump in and change it or not.
@hichris123 You might consider putting a LIMIT 100 or something on the history page - we don't need all two billion from SO at once.
 
3:35 PM
@Undo That's true, I'll do it in a bit.
@Undo Did it, we need a way to load more on a scroll down.
 
@hichris123 We can JS that in.
 
@Undo You can format it if you want, otherwise, in terms of info, what do you think?
 
@hichris123 I have a few things I might add in, otherwise, I'll start formatting it :D
 
3:51 PM
@Undo What happened to the commit feed?
 
@hichris123 I dunno.
 
Probably starting another PHP project
already doing two actively, +a wikipedia one that I contribute to occasionally but discuss about a lot
I want my javascript back
 
Hehe
@hichris123 Added a little formatting.
 
4:10 PM
@Undo Looks good.
 
Thanks
 
@Undo Sometimes your fancy formatting doesn't work.
Like this:
Thanks, edited.

marked valid by user1 1 month ago
@Jeremy: edited

marked valid by user1
 
@hichris123 For a while we weren't tracking handle dates.
 
Oh, that makes sense.
And then why's it always user or user1 @Undo?
 
@hichris123 It is?
I don't think it is...
 
4:23 PM
No, nevermind.
I was on SF.
Well, who is user?
See edit above.

marked invalid by user
 
Once we get usernames in there it'll make a lot more sense.
@hichris123 Probably one where it somehow got marked in the DB without getting marked with who handled it.
Might have been me poking the DB manually for some reason.
 
@hichris123 use a JOIN query
I know
I'm going to wait this one out and see if there is a consternation
 
4:38 PM
@Manish JOIN for what?
 
@hichris123 link me to the qury that is outputting user2 for comments
 
@ManishEarth You mean user?
 
marked valid by user1 1 month ago
@Jeremy: edited

marked valid by user1
 
@Manish That one's fine, I was just on SF so most were done by Undo.
 
4:51 PM
@Manish What are you doing?
 
@hichris123 adding a JOIN so the username is visible
 
@Manish Fixed one thing in your query. Going to try it?
 
@Undo @hichris123 enjoy the improved flag history view
 
00:00 - 17:0017:00 - 00:00

« first day (44 days earlier)      last day (3768 days later) »