Mgccl's blog

Chat log database, pidginlog

Mgccl — Thu, 02 Jul 2009 05:30:32 +0000

I developed a simple chat logging database from the Pidgin html log parser.
It's one of those things I put in mgccl's google codes repository.
I call it pidginlog for now.
While it is called chat log, it is intended to log IM's instead of IRC or group chat logs.

You can find the download here, or check the SVN.

If you don't get how to use it, read the code, logic should be pretty clear. This requires you to run pidgin and a PHP server on the same machine.
You also have to use cron job or other kind of schedule service to run the script once in a while to make this thing actually useful.

If you don't understand the code or have no idea of what I just talked about, chose a user friendly alternative like IM-history, Dexrex or Web Pidgin.

In the future I will make a web front end to this program...or not. phpmyadmin is powerful enough for a front end.

Pidgin html log parser

Mgccl — Wed, 01 Jul 2009 02:12:42 +0000

I wish to put my chat logs in a database, then I can do a lot of fun operation on it. I wrote this php script so read Pidgin's html logs. I will write something separate to put it in a database.
I use html instead of text log so there is no ambiguous expressions (for example, someone copied a chat log and sent to you), and provided all information(which nickname is the user? one that's colored blue.).

To achieve what I really want, it's much better to wrote a plugin for Pidgin. I heard there was a Remote Logging plugin(which is exactly what I needed) but never saw anything come out from it. I hope there is someone who want to revive the project.

Some notes:
1. Pidgin can change the format anytime and render this not usable.
2. This is only useful in 1 on 1 IM's. in conversations, it can only record if you said something vs someone else said something.
3. the log will not be parsed if it's not complete(which means it didn't end in html end tag)

//this script reads a pidgin log html file.
//Configuration!!!!
//Logs to check
//The directory to the log file, without the last slash
$f = 'C:\Documents and Settings\UserXP\Application Data\.purple\logs';
//$s is an array of service name
//$u is an array of usernames
 
$s[]  = 'aim';
$u[] = 'mgcclx';
 
//use html or not
$html = 1;
//if use html, which html tags are allowed
$html_allow = '<br/><span><font><p><a>';
 
 
//Write your own logging function
//For every message, it call this function once
function logging_function($service,$user,$other,$user_or_other,$time,$speaker,$content){
	return true;
}
 
for($i=count($s)-1;$i>-1;$i--){
	$o = scandir($f.'/'.$s[$i].'/'.$u[$i]);
	for($j=count($o)-1;$j>1;$j--){
		$d[$j] = $f.'/'.$s[$i].'/'.$u[$i].'/'.$o[$j].'/';
		$files = file_list($d[$j],'html');
		for($k=0;$k<count($files);$k++){
			$log = parse_log($d[$j].$files[$k],$html,$html_allow);
			if($log===FALSE){
				continue;
			}
			for($l=0;$l<count($log);$l++){
				logging_function($s[$i],$u[$i],$o[$j],$log[$l][0],$log[$l][1],$log[$l][2],$log[$l][3]);
			}
		}
	}
}
 
function parse_log($file_name,$html=0,$html_allow = '<br/><span><font><p><a>'){
	$line = file($file_name);
	$c = count($line);
	if(rtrim($line[$c-1])!='</body></html>'){
		return FALSE;
	}
	preg_match("@Conversation with (.*?) at (.*?) (.*?) on (.*?) \((.*?)\)@u", $line[0], $match);
	$date=$match[2];
	$prev = 'AM';
 
	for($i=1;$i<$c;$i++){
		if(preg_match('@<font color="#(.*?)"><font size="2">\((.*?)\)</font> <b>(.*?):</b></font> (.*)<br/>@u', $line[$i], $match)==1){
			if($match[1]=="16569E"){
				$match[1]=1;
			}else{
				$match[1]=0;
			}
			if(substr($match[2],-2)=='AM'&&$prev=='PM'){
				$t = explode('/',$date);
				$date = gmdate("n/j/Y", gmmktime(0,0,0,$t[0],$t[1],$t[2])+86401);
			}
			$prev = substr($match[2],-2);
			$match[2] = $date.' '.$match[2];
			if(strpos($match[3],' &lt;AUTO-REPLY&gt;')!== FALSE){
				$match[3] = str_replace(' &lt;AUTO-REPLY&gt;','',$match[3]);
				$match[4] = '&lt;AUTO-REPLY&gt; '.$match[4];
			}
			if($html){
				$match[4] = strip_tags($match[4],'<br/><span><font><p><a>');
			}else{
				$match[4] = str_replace('<br/>',"\n",$match[4]);
				$match[4] = strip_tags($match[4]);
			}
			$log[] = array($match[1],$match[2],$match[3],$match[4]);
		}
	}
	return $log;
}
 
//this function found on http://us3.php.net/manual/en/function.scandir.php
//by phpdotnet at lavavortex dot com
function file_list($d,$x){
	foreach(array_diff(scandir($d),array('.','..')) as $f)if(is_file($d.'/'.$f)&&(($x)?ereg($x.'$',$f):1))$l[]=$f;
	return $l;
}

Infinite loop

Mgccl — Thu, 25 Jun 2009 20:40:23 +0000

I saw this joke.

Boss to Secretary: I want to go to Beijing for a few days. Come with me.
secretary to husband: I have to go to Beijing with the boss.
husband to mistress: my wife won't be at home for a few days.
mistress to student: I won't be teaching you for a few days.
student to grandpa(boss): I don't have classes for a few days, let's have a fishing trip.

so, now, as you can see, the reverse happens, where boss->secretary->husband->mistress->student change their plans...
How can this problem be resolved?

Maybe one of them had enough with this and chose to do one thing anyway.

Maybe one of them become scientific and start investigate.

I don't know...

Edit: Helie offered a solution!

Obviously, the solution is to go fishing IN BEIJING

List of things I did, great idea

Mgccl — Thu, 25 Jun 2009 01:29:54 +0000

I saw this "Everyday I do" page, it's a list of dates and what the blog owner did on that day. It's like a dairy, but minimal amount of words to present all the information one need to know.
Nice. A list of things one did everyday... I need that so I can analyze and program my future according to my previous actions.
I should do something like that, posting stuff like that on Google Calendar. So it record all the things I did that I think useful to record.
Yep, it's like what twitter is intended to do. but easier to use for this purpose.
Google can export things into iCalendar.
and iCalendar have a core module that support journal entries, which I found amazing for record what one does everyday.

Of course someone can write a program that convert twitter twits and put in the Google Calendar... but I can't be bothered to search for it.

Here is the "things I did" page.

I made crab casserole

Mgccl — Wed, 24 Jun 2009 20:21:32 +0000

Crab casserole!
AWESOME!
I made it!
A picture:

Tasty.

The reason one get hurt is because one cares

Mgccl — Fri, 19 Jun 2009 23:39:47 +0000

My mom's view:
Mathematicians are crazy people.
I want to be one so I am also crazy.
But I fails more because I'm still not a mathematician and I go to Stony Brook which she considers fails.
I fail to even fail, that's fail in the epic proportion.
I will die in poverty because a CS + math major gets no jobs especially I'm in a university she consider as crap.

Maybe I will be happier if I study pre-med, and be the person she want me to be, instead of be a loser she believe I always am.

Nah... I'm absorbed in my own self so I chose to stop caring about what she thinks. That might be the better way to deal with this.

I rarely get angry. I don't know how rare is rare. I get angry like once per year. The last time was around July last year. 90% of the time, the person making me angry is my mom. How interesting. When I'm really angry. I have the desire to break objects. I think I have anger management issues.

Ha, she want me to commute to Stony Brook after the freshman year.
No way.
I guess I have no choice but to transfer to other schools. Even if it means I will not like it there.

I always want to be a rational person, but I still get emotional from time to time. Irony. But it's inevitable, I am still human.

Saw this mortgage calculator contest

Mgccl — Fri, 19 Jun 2009 20:00:08 +0000

I saw this contest named as "Super Sexy" mortgage calculator contest.
I know there are people who read my blog might interested in this, you can go and create something for them. Maybe learn something about mortgage too. xD.

Friended by Pelle

Mgccl — Tue, 16 Jun 2009 02:46:45 +0000

Pelle is not some famous person, it's just a friend of mine who refuse to friend me on Facebook just for fun.

That's what I get for been annoying him that "You should get a Facebook and add me" for months. xD.

So today I suddenly have the idea to get people to help me ask Pelle to add me as friend.
We succeeded(at least friend for 29 days)! Thx to everyone who have helped.

His facebook wall was flooded with posts saying "add Chao". I lol'd so bad.

Here is the picture I took of the wall's larger version.

Math debate

Mgccl — Mon, 15 Jun 2009 18:32:44 +0000

During the drive to bowling last night(I won the first round!), there was a discussion of the pun "math debate". so I wrote a news like thing just to poke fun of it. Yeah, we are immature and can be amused easily. This is not a parody of anything even close to real life even if it sounds like some other competition.

Phat Kaoke, a junior in Betalpha High School recently become the star of his school as he was chosen to be part of the US Math Debate team to compete in International Mathematical Debate Olympiad(IMDO),
Kaoke was excited and surprised to hear the news. "I never thought this would happen to me," said Kaoke, "When I entered the competition I just want to have fun." He have gone though 3 different level of selections, the last one chose 36 students out of over half million competitors.
Even though math debate is a team sport, most debaters likes to do it alone. "I like to take matter at my own hands. I don't work well in teams."
The competitions are judged by duration and volume. "Duration as how long one can debate, while the volume is the amount of information they use. A common misconception is volume is the loudness of the sound they make, which cause inexperienced competitors screaming while they math debate" explained Dr. Baron, the team leader of US math debate team.
Opposing to popular belief, math debaters doesn't have to be fluent in English or any other language, Kaoke is famous for his Engrish in school. "As lone as me could let teh other persons understands, its okiy," expressed Kaoke in his broken English.
IMDO is the largest on site math debate competition. Over 9 thousand top high school math debaters in the world gathers in a host city every year and spend 6 hours total on 6 math debate sessions. "Imagine, thousands of math debaters gathers in one large site, each math debating furiously for their team. There will be sweat of the passion to win. Until the 6 hour event came to an conclusion." said Dr. Baron.
"I'm so happy, this year the competition is held on Beijing. The main event will be held in the Olympic swimming pool. I always want to come there," nodded Kaoke. "The pool will be filled with our intense result from the debate," he added.
The Chinese have always performed extremely well in the competition, but Kaoke is determined to win this year. "It's hard to hold out long, especially against the Chinese team. They usually have unusually strong debaters that crush our material with theirs. We will see, the summer camp will greatly increase my skill to prepare for debating materials," said Kaoke. "Believe it or not, China have a special training program for people who got selected when they are still young. They get locked inside a room filled with nothing but math textbooks for 6 hours per day. It is brutal, but their performance is amazing, they mastered slow, fast and Gauss debating techniques," said Dr. Baron.
Great math debaters always have a place in great colleges. "I got accepted into MIT, but I'm still a junior," laughed Kaoke.

Facebook Username

Mgccl — Sat, 13 Jun 2009 04:20:45 +0000

My Facebook username is chao.xu. Which can be accessed with or without the dot. Or the dot at any place, like c.haoxu also works. This might not work in the future. So use the original just for safe.
I was thinking of mgccl for my username. I wonder if it will change later.

Because Facebook are connecting people I know in real life, which knows me as Chao Xu, so it is strange to use Mgccl.

The mgccl username will be used for a page I created feature Mgccl. but it need 1000 fans first.