When you are using several instances of kadu/ekg (linux clients of Gadu-Gadu IM, popular in poland) it is inconvenient to search for some old message in distributed history archives. Now you can download two archives into one place, and merge using my tool into one. It works only with linux clients: ekg and kadu (recent versions).
文 件 列 表
kadu-history-merge config.h.in AUTHORS configure.ac man COPYING src Makefile.am README trunk
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001655s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.103930s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.006304s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001373s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001082s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003577s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000887s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003822s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016547s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001281s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 291134 [ RunTime:0.016429s ]
