Linux 下服务器程序

#usage mysql -u socketchat -psocketchat socketchat < action.txt CREATE TABLE sysaction ( actid int default 0 not null, # 编号 name char(40) default '' not null, # 动作名称 action char(40) default '' not null, # 从//后面的开始算 msg1 text default '' not null, # 在适当的位置放入[target] [source] [messsage] 分别代表 信息接受人 说话人 说的信息。 msg2 text default '' not null, # 在适当的位置放入[target] [source] [messsage] 分别代表 信息接受人 说话人 说的信息。 flag enum('Y','N') default 'N' not null,# 作为常用动作 times int default 0 not null, # 使用次数 PRIMARY KEY (actid) ); insert into sysaction (actid,name,action,msg1,msg2) values (1,":(",":(","[source]愁眉苦脸的，一副倒霉样。","[source]对[target]说到：＂怎么每次看见你，你都是愁眉苦脸的，一副倒霉样？＂"); insert into sysaction (actid,name,action,msg1,msg2) values (2,":((",":((","[source]露出了很是难过的表情。","[source]看着[target]，难过得哭了出来。"); insert into sysaction (actid,name,action,msg1,msg2) values (3,":)",":)","[source]的脸上露出了一丝笑容。","[source]对[target]露出了愉快的表情。"); insert into sysaction (actid,name,action,msg1,msg2) values (4,":))",":))","[source]＂哈哈哈＂地大笑了几声。","[source]瞟了[target]一眼，仰天打了个哈哈。"); insert into sysaction (actid,name,action,msg1,msg2) values (5,":)..",":)..","哇！这么诱人呀！","[source]对[target]垂涎三尺，不知道下一步会有何举动了。"); insert into sysaction (actid,name,action,msg1,msg2) values (6,":D",":D","[source]笑得嘴巴都合不起来。","[source]对着[target]不停地笑，笑得嘴巴都合不起来。"); insert into sysaction (actid,name,action,msg1,msg2) values (7,":P","惊讶","[source]惊讶得两眼瞪得贼大","[source]吃惊地看着[target]，嘴巴张大得足以塞进一个麦香猪柳蛋汉堡。"); insert into sysaction (actid,name,action,msg1,msg2) values (8,"?","?","[source]抓了抓头皮，露出迷惑的神情....","[source]很疑惑地看著[target]。"); insert into sysaction (actid,name,action,msg1,msg2) values (9,"??","??","[source]抓呀抓，把头皮都抓破了，也没有想出个所以然来。","[source]对[target]叹道：＂唉，你可真是一块美人胚子，就可惜眼睛小了点！＂"); insert into sysaction (actid,name,action,msg1,msg2) values (10,"@@","@@","[source]眨眨眼！一对会说话的眼睛闪闪动人。","[source]大大的眼睛， 天真的望着[target](@_@)＂"); insert into sysaction (actid,name,action,msg1,msg2) values (11,"ack","惊叫","[source]惊叫一声，吓了别人一大跳！","[source]对[target]惊叫一声：＂啊！你真是的！吓坏我了。＂"); insert into sysaction (actid,name,action,msg1,msg2) values (12,"addoil","加油","[source]使劲给自己加油。","[source]憋足了劲大喊：“[target]！加油！加油！下面就是宝贝了！”"); insert into sysaction (actid,name,action,msg1,msg2) values (13,"admire","崇拜","[source]抱拳团团一拜，讨好地说道：敝人对各位的景仰之情，有如涛涛江水连绵不绝。","[source]讨好地对[target]说道：敝人对您的景仰之情，有如涛涛江水连绵不绝。"); insert into sysaction (actid,name,action,msg1,msg2) values (14,"agree","同意","[source]说：你们大家都对，行了吧？","[source]完全同意[target]的看法。"); insert into sysaction (actid,name,action,msg1,msg2) values (15,"ah","惊讶","[source]惊讶地“啊！”了一声，重重地拍了一下自己的脑袋，“我怎麽没想到？！”。","[source]对着[target]惊讶地「啊！」了一声。"); insert into sysaction (actid,name,action,msg1,msg2) values (16,"ai","爱","[source]高叫道：我爱SocketChat！！！","[source]对[target]哼哼道：喔－喔喔－喔－－－耶．．．．，爱你在心口难开．．．"); insert into sysaction (actid,name,action,msg1,msg2) values (17,"angry","生气","[source]很生气地撅了撅嘴。","[source]很生气地看着[target]。"); insert into sysaction (actid,name,action,msg1,msg2) values (18,"applaud","鼓掌","[source]鼓掌喝采！","[source]对[target]鼓掌赞许！"); insert into sysaction (actid,name,action,msg1,msg2) values (19,"bad","坏","[source]很生气地撅了撅嘴：“坏坏，你欺负人！”","[source]生气的撅了撅嘴说：“[target]你坏坏欺负人！”"); insert into sysaction (actid,name,action,msg1,msg2) values (20,"bear","熊","[source]往洞里一躺，嘟咙到：“熊熊我要冬眠了，你们不要打搅我。”。",""); insert into sysaction (actid,name,action,msg1,msg2) values (21,"benger","指","[source]用手指弹了一下自己的脑门儿。","[source]在[target]的头上弹了个清脆的脑崩儿，[target]的脑门儿上立刻长出了个小臌包。"); insert into sysaction (actid,name,action,msg1,msg2) values (22,"birth","生日","[source]又再想：今天是谁的生日呢？","[source]和在场的人一起向[target]致以衷心的祝福，祝[target]生日快乐，大家一起唱：“祝你生日快乐，祝你生日快乐...“"); insert into sysaction (actid,name,action,msg1,msg2) values (23,"birthday","生日1","[source]逢人就打招呼：“大家好，今天是我的生日！请吃糖！ 请吃糖！“","[source]清了清嗓子，说道：“祝[target]生日快乐， 献花！”"); insert into sysaction (actid,name,action,msg1,msg2) values (24,"bite","咬","[source]磨了磨牙。","[source]想狠狠地咬[target]一口。"); insert into sysaction (actid,name,action,msg1,msg2) values (25,"blink","眨眼","[source]天真地眨了眨眼睛！","[source]对[target]眨了眨眼"); insert into sysaction (actid,name,action,msg1,msg2) values (26,"blush","脸红","[source]脸都红了，恨不得有个地洞，好钻进去躲起来~~。","[source]看着[target]，脸「唰」的一下红了起来。"); insert into sysaction (actid,name,action,msg1,msg2) values (27,"bored","无聊","[source]打了个哈欠，觉得无聊极了。","[source]对着[target]打了个大哈欠．．，[target]这人真无聊．．． "); insert into sysaction (actid,name,action,msg1,msg2) values (28,"boss","头来了","[source]匆忙道：头来了！开溜……","[source]对着[target]惊呼：头来了！开溜……"); insert into sysaction (actid,name,action,msg1,msg2) values (29,"bow","鞠躬","[source]弯下身鞠躬。","[source]拱手作揖，很谦逊地跟[target]说：在下[source]，请多指教！"); insert into sysaction (actid,name,action,msg1,msg2) values (30,"brag","侮辱","[source]双眼一翻：“大丈夫可杀不可辱……“","[source]把胸脯拍得噼啪响，对[target]咆哮：“武林中拳头大的说话，有种的上来比划比划！“"); insert into sysaction (actid,name,action,msg1,msg2) values (31,"brother","万福","[source]弯弯腰，道了个万福“各位大哥，有礼了！”",""); insert into sysaction (actid,name,action,msg1,msg2) values (32,"bud","膜拜","[source]趴在地下，对空膜拜个不停。","在这一瞬间，[source]觉得[target]简直跟神一样。"); insert into sysaction (actid,name,action,msg1,msg2) values (33,"bug","害虫","[source]嘴角一撇，狞笑道：“我是害虫我怕谁？！“。","[source]大叫“[target]，你这条臭虫！“..."); insert into sysaction (actid,name,action,msg1,msg2) values (34,"bye","白","[source]向在场的人道别：走咯！我会想你们的．．．","其时明月在天，清风吹叶，树巅乌鸦呀啊而鸣，[source]再也忍耐不住，望着[target]的背影，泪珠夺眶而出。"); insert into sysaction (actid,name,action,msg1,msg2) values (35,"byebye","再见","[source]回眸一笑，一切尽在不言中...","[source]轻轻吻了[target]一下，低声说：“我走了，有缘的，我们会再见。“"); insert into sysaction (actid,name,action,msg1,msg2) values (36,"ca","擦","[source]以一个优雅的动作拨了下头发...","[source]拿出一块破抹布，一脸妩媚地给[target]擦鞋..."); insert into sysaction (actid,name,action,msg1,msg2) values (37,"care","痛哭","[source]孤独寂寞地躲在角落痛哭~~>_<~~。","[source]轻轻抚摸[target]..."); insert into sysaction (actid,name,action,msg1,msg2) values (38,"careful","小心","[source]叹了口气，叹道：＂这世道．．．","[source]忽然叹道：“人在江湖还是收敛一点好，否则下场难免要和[target]一样，死了都还不知道是谁下的手！“"); insert into sysaction (actid,name,action,msg1,msg2) values (39,"cat","猫","[source]叫了声：“喵~~~~...”。","[source]像只小猫般地依偎在[target]的怀里撒娇。"); insert into sysaction (actid,name,action,msg1,msg2) values (40,"chitchat","天气真好","[source]笑呵呵地对大伙一抱拳，说道：今天这个，... 这个天气真好！","[source]朝着[target]一抱拳，说道：哈哈哈，这个，今天，... 这个天气真好！"); insert into sysaction (actid,name,action,msg1,msg2) values (41,"club","木棒","[source]晃动着手中的木棒，到处寻找目标。","[source]手舞木棒，对准[target]的后脑一记闷棍，[target]哼也没哼一声，软软的摔倒在地。"); insert into sysaction (actid,name,action,msg1,msg2) values (42,"coffin","棺材","[source]长叹了一口气,