Table 'tellque' missing

[Zothen]

Got a world error this morning, when tell-chatting with a buddy of mine. The world window reports "[...] peq.tellque doesnt exist." and it is actually right. There is no such table, but in the source code there are 3 sql commands for it.

Is there an update script for that table or could someone just post the columns so I can add it manually?

Thanks in advance!

[trevius]

I haven't ever messed with it, but judging by the source related to it, I would think the table would be something like this:

CREATE TABLE `tellque` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `date` varchar(65) NOT NULL default '',
  `receiver` varchar(65) NOT NULL default '',
  `sender` varchar(65) NOT NULL default '',
  `message` varchar(256) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

I only looked at the source for it briefly, but as far as I can tell, the tellque doesn't actually get sent to clients automatically after they finish zoning. They would have to run the #viewmessage command.

Though, it seems like messages could be checked and automatically sent during the finishing zoning process.

[Zothen]

Thanks for the sql, mate!

It must be automatically, cause my buddy does not even know the #viewmessage command, nor do I

[trevius]

Well yeah, it gets inserted into the table automatically when someone is zoning and is sent a tell. The command would be for retrieving the message after zoning is completed, as I didn't see any way that automatically sends the messages.

Though, all I did was search Google SVN for "tellque" and got this result:

http://www.google.com/codesearch?q=t...G=Search+Trunk

Searching the SVN often misses entries for whatever reason, so maybe support for sending them automatically is already in.

[trevius]

Looks like that table basically works, though the timestamp field doesn't record the timestamp properly.

I was at least able to confirm that it does not automatically send the queued tells after the receiver finishes zoning. It puts them into the table and you have to get them manually using the #viewmessage command. Seems like it might not be all that hard to implement the rest of it and then add the table to the SVN for updates that everyone can get. Though, I would like to know the correct way to set the date field for sure before that.

It would probably also need some sort of cleanup step to empty out the table upon server reset or something.

[dcosper]

I had a similar time stamp problem, the sql and server wants a UNIX timestamp and i cant find a way in sql to make that, so instead i did a int 11 to hold the UNIX_TIMESTAMP date, seems to work fine, but i am just a novice.

[trevius]

Yeah, if it is unix timestamp, then int(11) is what it wants. I just thought it was supposed to be a timestamp, since it looks to be using asctime() to make it a string in this snippet from the source:

time_t rawtime;
struct tm * timeinfo;
time ( &rawtime );
timeinfo = localtime ( &rawtime );
char *telldate=asctime(timeinfo);
....
if (database.RunQuery(query, MakeAnyLenString(&query, "INSERT INTO tellque (Date,Receiver,Sender,Message) values('%s','%s','%s','%s')",telldate,scm->deliverto,scm->from,scm->message), errbuf, &result))

Looks like it just needs to be varchar, so I updated the SQL I posted previously. Tested it and it worked fine.

[sorvani]

would be awesome if this gets finished.