Code:
-- phpMyAdmin SQL Dump
-- version 2.9.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 04, 2006 at 09:11 AM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
--
-- Database: `chatbase`
--
-- --------------------------------------------------------
--
-- Table structure for table `chat`
--
CREATE TABLE `chat` (
`msg_id` int(11) NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`time` time NOT NULL default '00:00:00',
`text` text NOT NULL,
`name` varchar(255) daefault NULL,
`pass` varchar(20) NOT NULL default '',
PRIMARY KEY (`msg_id`),
KEY `date` (`date`,`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;
--
-- Dumping data for table `chat`
--
INSERT INTO `chat` VALUES (13, '2006-10-20', '16:27:58', 'hi\r\nhi\r\nsup?\r\nmaking money :)\r\nhaha\r\nyou?\r\nsame\r\nrofl\r\nits easy to make money\r\nyup\r\nit just takes time\r\nand a high mining level :)\r\nlol\r\nghehe\r\na couple of more rounds and i am off\r\nkk me 2\r\n:)\r\nl8r\r\nbye', 'WT-Fakawi', '');
INSERT INTO `chat` VALUES (15, '2006-10-20', '18:05:01', 'hi man\r\nhi\r\nyou have addy arrows?\r\nno\r\ntoo bad\r\nwhy you need them?\r\nWant to quickly level up\r\nhm, why not use steel arrows?\r\nthey dont give enough damage\r\nreally?\r\nyup\r\nhm ok\r\nI have steel arrows if you like\r\nnah, I will buy from someone\r\nsomewhere\r\nover the rainbow\r\nlol\r\nrofl\r\nok, I gtg\r\nkk ttyl\r\nbye\r\nbye\r\n', 'WT-Fakawi', '');
INSERT INTO `chat` VALUES (16, '2006-10-20', '18:14:45', 'hi\r\nhey\r\ndarn\r\nwhat?\r\nmissed\r\nmissed what?\r\nrock\r\n?\r\nbecause of my eyesight i miss a lot\r\neyesight?\r\nAh you didnt know...\r\nno?\r\nI am nearly blind\r\nreally?\r\nyes very bad eyesight\r\nwow\r\nso i cant really see what i am doing\r\na i understand\r\nso i often mis :/\r\nhaha\r\nyou think thats funny?\r\nnono, i ment, erm...\r\nyes?\r\nWell actually come to think of it...\r\nyes!\r\nI think it is very funny.\r\n... >:<\r\nno really, I am here you are, nearly blind...\r\ngrrr\r\nmissing all sorts of objects! whaha\r\nI will remove you from my friends list\r\nOk go ahead idc you are blind anyways haha\r\nfight me\r\nwhat?\r\nfight me in the wildy!\r\nWhat? Wait, u r blind man!!!\r\ni will own u\r\nyeah sure you will rofl\r\nnow\r\nno way. I am working\r\nremoved\r\nyeahyeahwhatever\r\ndie\r\npfrt\r\n', 'WT-Fakawi', '');
INSERT INTO `chat` VALUES (17, '2006-10-20', '19:08:59', 'hey, did any hw yet?\r\nno, what is it?\r\nsome stupid essay\r\nabout what?\r\nmath\r\nmath what?\r\nabout codes...\r\nwhat? like 010011\r\nim afraid so\r\nforget it\r\nwhy?\r\ni hate math\r\nso do i, but im making it\r\nyou really love school\r\nno i dont\r\nthen dont make the essay\r\ni am making it\r\nwhy?\r\ncause ill like to graduate -_-\r\nSo do i, but this wont matter\r\nHow come?\r\nbecause its an extra\r\nextra?\r\nyes\r\nwhat do you mean?\r\nits not for a grade\r\nyour joking me ?!\r\nnope\r\nhow do you know, you didnt even knew we had it\r\ni asked gary\r\nand you trust gary?\r\nno reason why i shouldnt\r\nno, but he is always lazy\r\ntrue\r\nah man, now you made me doubt\r\nhaha, isnt life hard\r\noh yes it is\r\nwant to work on it tomorrow?\r\ntogether?\r\nyeah\r\nsure\r\nok, i got to go, dinner, cya\r\nbye', 'Sumilion', '');
INSERT INTO `chat` VALUES (18, '2006-10-20', '19:12:43', 'hey\r\nwho are you?\r\nyou were selling willows right?\r\nnot really\r\noh, too bad\r\ni got some other stuff though\r\nlike what?\r\ni got some iron i can sell\r\nno ty\r\nwhy not?\r\ncause i want my firemaking up\r\nfor what?\r\nto become the best ^^\r\ngood luck\r\nwhy? dont think i can do it\r\nno\r\ncause no-one beats zezima ^^\r\ntrue, doesnt hurt to try, does it\r\nno it doesnt\r\ndont you want to be the best ?\r\nyes, but not that much\r\nhow come\r\nill just like to get rich\r\nwhatever, i g2g, cya\r\nbye', 'Sumilion', '');
INSERT INTO `chat` VALUES (19, '2006-10-20', '19:16:35', 'hey\r\nhey, everything cool?\r\nyeah, you?\r\nOh, you know, just mining =(\r\nagain -_-\r\nyou must have a high mining lvl then\r\ni cant complain ;)\r\nshowoff\r\nthnx\r\ni hate it when you do that\r\nthats why i do it ^^\r\nlol\r\nanything else?\r\nnot really\r\nk', 'Sumilion', '');
INSERT INTO `chat` VALUES (20, '2006-10-20', '19:36:06', 'morning\r\nman am i glad your awake\r\nhow come\r\nwell, its very stupid actually\r\nwhat a surprise\r\n>< anyway, i was mining while my head flew off\r\nso? didnt you noticed ?\r\nno, i was watching tv at the same time\r\nwhaahaaahaaaa rofl!\r\nyeaaahhh... can i borrow some cash?\r\nnop, im also low on cash\r\nah man, so i was excited for nothing :(\r\nyup ^^\r\njust you wait when i get some mining lvls\r\nright, like its all so easy\r\nit is, isnt it\r\nnot really, youll see\r\ni hope not actually\r\nwhy?\r\nwell, it seems easy to me so far\r\nhah, your in for a nice surprise\r\nright\r\nwell, continue mining, you make me feel bored\r\nright, cya >', 'Sumilion', '');
INSERT INTO `chat` VALUES (21, '2006-10-20', '19:44:34', 'hey\r\nhiya\r\nso when are you coming\r\nfor what?\r\nfor the movie\r\noh right, oops, forgot\r\ni already thought ill find you here\r\nhow come\r\naddicted...\r\ni am not!\r\ncmon, you practically forgot your own b-day\r\nlittle accident\r\ndont deny it\r\nim not, do you still want me to come or not?\r\nsure i do\r\nok\r\nas long as you dont go talking about rs all the time\r\nlike i would\r\nlike you didnt last time -_-\r\nyou asked for it\r\ni did not\r\nanyway, do i need to take anything with me\r\nyeah!\r\nwhat, *hides from shame*?\r\nhmpf =(\r\nis it that bad\r\nyeah!\r\nhow come?\r\nyou were supposed to buy popcorn...\r\nah right, sry\r\nah man, now we dont have any\r\ni think we still have something in our house\r\ni hope so, ill see you in a couple of minutes\r\nk, bye', 'Sumilion', '');
INSERT INTO `chat` VALUES (22, '2006-10-20', '21:15:40', 'hi\r\nhi\r\nwho are you?\r\nIm selling feathers.\r\nOh.....\r\num, i read your posts on the forums saying you wanted to buy feathers\r\noh, yeah, that....im not selling anymore\r\noh....ok\r\nbye\r\nbye\r\n', 'Ruroken', '');
INSERT INTO `chat` VALUES (23, '2006-10-20', '22:34:08', 'omg, you wont believe this\r\nwhat?\r\nholy cow this is awesome!!!\r\nwhat? tell me!\r\nok ok\r\n....continue\r\nthis guy was fitin a goblin, and he died\r\nwow..that never happens\r\nbut he dropped like all of his stuff\r\nreally?\r\nya, he dropped like full iron\r\nno way, lucky\r\nya, i know :) but thats not even the best part\r\nseriously?\r\nya, he dropped....*drum roll*\r\noh come on just tell me\r\nmith scimmy!!!!!!!!!!!\r\nsweet! thats work like...10k isnt it?\r\ni dunno but im not sellin it\r\nwell, thats pretty awesome, nice find\r\nthanks, I gotta get back to fightin tho\r\nok\r\ngotta get to 20 att so i can use this baby\r\nlol, alright, c ya later\r\nkk, bye', 'weibs', '');
INSERT INTO `chat` VALUES (24, '2006-10-20', '22:42:34', 'im so depressed\r\nwhats wrong?\r\nlike youd care\r\ni do, seriously, whats wrong?\r\nhahahaha, you got sensitive!\r\nshut up\r\nrofl, that made my day!\r\nshut up! thats not funny\r\nyes it is\r\nno, i thought you were serious\r\nawww, you gonna cry cupcake?\r\nshut up\r\nanyways, guess what\r\ni dunt wanna talk to you\r\noh come on, its really cool\r\nfine, what?\r\nalex fell on his face today at school\r\nhaha, hes so dumb\r\nI know, it was hilarious\r\nyou get your homework done?\r\nwhat hw?\r\nam studies, the powernoting?\r\noh, shoot, forgot about that\r\ni know, he always gives so much hw\r\ni hate it too\r\noh well\r\nya, we get to use notes on the test\r\nlol\r\nwhat?\r\nmy cat just jumped over me\r\nover...?\r\nya, she got up on the stool next to me\r\nand jumped over you? how\r\nwell, sorta...she landed on my leg\r\nwell then she cheated\r\nlol\r\nso whats your minin lvl now?\r\nstill not high enough\r\nwhen will it be?\r\nnever\r\nlol, overachever\r\nim bored\r\nya, i better get started on those notes\r\nlol, i almost got those done in a.p.\r\nap?\r\nactivity period, duh\r\noh, i knew that\r\nlol\r\nk, c ya\r\nbye', 'weibs', '');
INSERT INTO `chat` VALUES (25, '2006-10-20', '23:22:51', 'hey\r\nyoh\r\nare you listening at the radio atm?\r\nno, why?\r\nwell, the weather...\r\nwhat?\r\ni dont think we will be able to surf tomo\r\nhmm, shame\r\nyeah, maybe in a couple of weeks or so\r\nmaybe, i wasnt feeling like it anyway\r\nhow come?\r\noh, i got scammed, im earning money now...\r\nah i see, how much?\r\nhow much i got or how much i got scammed for?\r\nboth\r\nwell, i got scammed for 60k\r\nouch\r\nyeah, i already earned it back though\r\nnice! how do you do it? =)\r\nhigh mining lvl and your set.\r\nthats it?\r\nyup, and start mining\r\nah, nice.\r\ni think ill give it a try\r\nright now?\r\nyea\r\nill give you seom equipment later\r\n=O thnx a lot!\r\nnp', 'Sumilion', '');
INSERT INTO `chat` VALUES (26, '2006-10-21', '03:06:01', 'Hi\r\nWhats up?\r\nnothing much\r\nnothing?\r\nwell, no, Im cutting down willow logs\r\nwhy?\r\nto make money someone scamed my rune axe\r\nthat blows\r\nyeah...', 'Bam Bam', '');
INSERT INTO `chat` VALUES (27, '2006-10-21', '03:34:14', 'hey\r\nyo\r\nfinaly we r both online at same time\r\nyeah, I no what u mean\r\ncan you get me more rune chain\r\nno man that was a one time deal\r\naw please ill owe you big time\r\nlol you already owe me :)\r\nyeah thats true\r\nhehehe\r\nI got killed in the wild dumb gang got me. so unfair\r\ni know what you mean\r\nI had that guys number and then wham 7 guys had surounded me\r\nouch\r\nyeah your not kidding\r\ndid you loose much\r\nyeah I was wearing full rune :(\r\nbummer\r\ntell me about it\r\nwell with friends like you i got to get back to work\r\nlol do i cost that much :p\r\nlol yup\r\nkk ttyl\r\nok', 'Flyboy', '');
INSERT INTO `chat` VALUES (28, '2006-10-21', '03:41:35', 'r u buying or selling today?\r\nnope not today\r\nhmmm\r\nwhy\r\nyou know why... I want to get rich lol\r\nhaha yeah we all do\r\nmarketing is the way to go my man... everyone becomes a winner :)\r\nsounds like your going to be selling me something soon\r\nmaybe or buying if you want to get rid of stuff\r\nyou know me always collecting stuff so maybe... just not now\r\nok\r\ntks 4 asking... will let you know when I need to market stuff\r\nsweet\r\nttyl\r\nwill do', 'Flyboy', '');
INSERT INTO `chat` VALUES (29, '2006-10-21', '08:29:15', 'Hello!\r\nHi.\r\nSo.. what happend yesterday?\r\nAh nothing much, teacher got mad.\r\nAh. How un-fortunate.\r\nYes pitty really, I finally though I would get better notes lol.\r\nHaha! So, Still like mining and combat in rs?\r\nYes, how do you know?\r\n I looked up your highscores.\r\nAh ok.\r\nOk well.. I will stop talking for now.. peeps keep stealing my "money".\r\nOk. byebye.\r\nBye!', 'Wizzup?', '');
INSERT INTO `chat` VALUES (30, '2006-10-21', '18:00:17', 'how long did you stay up last nite?\r\nlike 3\r\nonly?\r\nya, when did you go to sleep?\r\nI didnt...hehe\r\noh, cool, I was dead tired\r\ni see, i see\r\nya, so have you gotten ur wcing higher?\r\nnot yet, ive been merchanting lately.\r\noh, I heard thats the best way to make $\r\nyeah, but you have to have a lot of $ 1st\r\nwhy?\r\ncuz cheap items arent good for merching\r\noh\r\nrares are the best\r\noh\r\nwell, i gotta get back to selling\r\nok, ttyl\r\nk', 'weibs', '');
INSERT INTO `chat` VALUES (31, '2006-10-21', '18:08:10', 'hey hey hey\r\nwhy are you so happy\r\nno reason\r\nyou should come over\r\nmaybe\r\nkevin and ben are here\r\nreally?\r\nya\r\nhmm, i might come over in a lil bit\r\nkk\r\ndid you see the fight yesterday?\r\nno, but i heard about it\r\nit was scary\r\nyou saw it?\r\nya, one guy got his head slammed into the locker\r\nholy cow\r\ni know, theres a dent in the locker now :P\r\nlol, how long did it last\r\nabout 5 mins\r\ndidnt the teachers do anything?\r\nthey tried, couldnt get them calmed down\r\noh\r\nbut my english teacher got a hold of one of em\r\nwhat did he do?\r\nheld him back, hes like buff\r\nlol, anyways, i sold all of that coal we got\r\nhow much?\r\n22k\r\nnice\r\nso now we have a total of....\r\n317k?\r\n417k\r\nsweet\r\nya, cant wait till we get to 1 mill\r\nikn that would be awesome\r\nbut that might take a while\r\nunfortunately, yes\r\nbut it will happen someday\r\nsomeday....someday\r\nlol\r\nmeh, im bored\r\ncome over then!\r\nfine, let me ask\r\nkk\r\nhold on\r\n...........\r\nyeah I can\r\nk\r\nill be over in like 5 mins\r\nk, c ya then\r\nyup\r\n', 'weibs', '');
INSERT INTO `chat` VALUES (32, '2006-10-21', '18:10:29', 'another mining lvl!!!\r\ndang, youve gotten a ton today\r\nikn, ikn, im good like that\r\nhaha\r\nnot that far away from another lvl\r\nhow? you just lvled\r\nya, but i mine like crazy\r\nlol\r\nk, gotta get back to minin\r\nalright\r\ni feel another lvl comin\r\nsure..sure\r\nc ya', 'weibs', '');
INSERT INTO `chat` VALUES (33, '2006-10-21', '19:30:40', 'oh man, I dont feel good\r\nyou shouldnt of eaten all that junk\r\nbut it was good at the time :P\r\nlol\r\nseriously, I feel like throwing up\r\nthen go sit by a toilet :P\r\nI think I might just do that\r\nyou should\r\nyup, brb\r\nkk\r\nback, feelin better\r\ndid you throw up\r\nyea\r\neww\r\nikn, ill ttyl\r\nk, bye', 'weibs', '');
INSERT INTO `chat` VALUES (34, '2006-10-21', '20:26:50', 'yo\r\nwhatup\r\ndid you watch the race yesterday?\r\nyeah it rocked\r\nno kidding... i wish i was that good\r\nme too.... someday *sigh*\r\nlol\r\nwhen is the next one\r\nnot sure brb\r\nkk\r\nok, its on next thur on channel 56\r\nsweet thanks\r\nnp\r\nttyl\r\nkk cya', 'Flyboy', '');
INSERT INTO `chat` VALUES (35, '2006-10-21', '21:02:32', 'boring...\r\nwhat?\r\nrunescape\r\nhaha\r\nalways the same thing over and over\r\ni kinda like that\r\nwell, it passes the day :)\r\nit makes time fly\r\ni dont think i can cope with this much longer\r\nhaha, that bad?\r\nyeah\r\nwell, quit for some time, go see the light\r\nha outside you mean?\r\nyeah\r\nbrrr, its cold outside this time of year\r\ntrue\r\nI will switch on some more lamps\r\nhaha thats not what I meant\r\n:)\r\nand?\r\nmuch better thank you\r\n...\r\nNow i can continue playing runescape\r\ngood\r\nyes\r\n:) ty\r\nkk bye\r\nbye\r\n', 'WT-Fakawi', '');
INSERT INTO `chat` VALUES (37, '2006-10-22', '02:36:41', 'have you seen the new capes?\r\ndude i just killed an evil chicken!\r\nwhats your lvl?\r\nwanna go duel?\r\nthis music is really getting on my nerves!\r\ndude where are the red dragons?\r\ni told my mother off today lol!!\r\nwhy do you hate me\r\ni love tomatoes lol\r\nall random lol\r\nim really into this game now...\r\nomgzors im dying! \r\ni died...\r\ndude help me with this quest', 'dwas woot', '');
INSERT INTO `chat` VALUES (38, '2006-10-22', '03:27:58', 'man, noobs are so annoying\r\nlol, what happened?\r\nearlier, this guy kept on following me\r\nand..\r\nasking for free money plz!!\r\nlol, i feel for ya\r\nI even switched worlds, and he found me\r\nlmao\r\noh crap, hes back, g2g\r\nrofl!!! haha, c ya', 'weibs', '');
INSERT INTO `chat` VALUES (39, '2006-10-24', '03:42:34', 'Are you done yet\r\nWhat do u mean\r\nI want to go to the wild soon\r\nin a bit.... just chill\r\nchill- thats imposible...\r\nlol\r\nok let me know when your ready\r\nkk\r\n', 'Flyboy', '');
INSERT INTO `chat` VALUES (44, '2006-10-25', '00:26:45', 'hey, ur phones been busy\r\nyeah, dial up sux.\r\n:P\r\nwhy were you tryin to call me?\r\nto see if you could come to my house\r\ncant, too much hw.\r\nthen why are you playing rs?\r\nidk, lol\r\nwhatever\r\nim just gonna play for a few more hours...\r\nlol\r\nno wonder your failing math :P\r\nlol\r\ncya\r\nbye', 'lardmaster', '');
INSERT INTO `chat` VALUES (45, '2006-10-25', '04:19:46', 'hey guys\r\nsup\r\nyou really like this?\r\nwell if i am playing it i like it\r\nnot always true\r\ni am too dumb to argue that\r\nlol\r\n', 'Rams89', '');
INSERT INTO `chat` VALUES (46, '2006-10-26', '09:17:31', 'hi\r\nhi\r\nits raining.\r\nhaha its sunny over here\r\nwow, what time is it with you?\r\n3 pm\r\nwow, its 11 am here\r\nlol\r\nlol\r\nsee the world spinning round\r\nround round round\r\ncoocoocatchu\r\nlol\r\nrofl\r\nyou like the beatles?\r\nno :)\r\nhaha me 2\r\nlol\r\nI like deathmetal\r\neek\r\nyou dont?\r\nno\r\now\r\nnvm\r\nl8r\r\nl8r\r\nbye', 'WT-Fakawi', '');
INSERT INTO `chat` VALUES (47, '2006-10-27', '22:46:53', 'u kno wat my favorite song is?\r\ndont really care\r\nugh, fine\r\ngood\r\ni guess i wont tell you\r\nok....\r\ncomon guess\r\nnah\r\nyoure a loser, u kno that?\r\nfine by me\r\nman, thats annoying\r\nwhatever\r\ndo you hate me or something?\r\neh\r\nok then, i guess ill ttyl\r\nI hope not\r\n:( bye', 'weibs', '');
Also used was a remote command system allowing bot to chat through a private chat command. I always loved standing next to my bots having a public convo.