Due to the release of EveGate users private contact data is no longer private. Even when and if privacy options are added EveGate will continue to feature bugs, exploits and will always be a target for social engineering attacks on your standings.
This code is a simple solution to maintaining your own private addressbook separate from the Eve Online system.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001263s ]
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.085180s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001150s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002159s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001165s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003667s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000994s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003314s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014704s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001242s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 261366 [ RunTime:0.001290s ]