Personal Log Database

Game: 
Achaea
Client Type: 
MUSHclient

Script File: logdb.xml

Org logs in Achaea poof after 6 days, this plugin reads and maintains a database of these logs on your computer so they stay with you as long as you want. You can search through these logs using keywords and date ranges as well. Have a look at the available aliases to interact with it. I'll add the ability to paginate search results in later versions.

This plugin is written in Python, please see this page to setup Python on your computer: clickey

The following aliases are available:

  • LogDB:readlog <org> [line to begin at] [how many days back]
  • LogDB:search <org> <searchtext> [how many days back]
  • LogDB:search <org> <searchtext> [from:yyyy-mm-dd] [to:yyyy-mm-dd]

The plugin will ask you for a file location on first load, just point it wherever you want your database file to be created. If you get "OperationalError: database is locked" error while trying to add an entry, please delete the .journal file wherever you have your database file to resolve the issue (yay to Gwawr!).

The aliases are not case sensitive, you could probably make your own aliases and Execute() these to make it shorter. 

Please message me in-game for feedbacks and comments! Enjoy!

# I will no longer post updates news here, the above link always points to the latest version on my bitbucket repository. You can see this page to follow along: clickey

10
Your rating: None Average: 10 (2 votes)

Comments

Hmm, I don't have a city/house anymore :| I hope kots people won't mind XD

logdb:search keepers join the clan from:2012-11-05 to:2012-12-05

Searching [the Clan of Keepers of the Song] logs for [join the clan] in the range [2012-11-05] to [2012-12-05]
2012-11-23 02:28:54 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-11-23 17:05:29 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-11-30 15:38:32 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-11-30 16:21:11 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-11-30 16:21:42 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-12-01 04:26:23 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-12-01 15:47:54 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-12-03 22:35:36 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.
2012-12-03 22:46:53 - SomePlayer has asked SomePlayer to join the clan of Keepers of the Song.

Total matches: 9

can Anyplayer join?

even more interestingly, who is Anyplayer?

Nobody quit the clan. Does anyone know why Nobody left us?

Sounds usefull, but I really don't want to install all that other stuff...

I rarely need to go back that far into logs but my hat is off to you for being smart enough to write it!

kudos!

Nice idea. Guess I'll write one for Mudlet!

woot

Seconded!

Impressive script, but this is an extremely OOC way to keep information. This makes every little thing written into stone. Some things should be forgotten after a while.

It may be ooc the way you play and invision your character. It doesn't have to be OOC for other people. People keep records, people write things down. It is actually more OOC to think that an org makes a record and it magically disapears 6 days later.

It's actually very useful.

Updated to version 1.1, changed the way database is handled coz Kalvon and Gwawr said so. Ehh it's useful for ministers and secretaries who have to compile yearly reports from logs, also, we forgot why we enemied a lot of people because nobody wants to read those reports heh.

Updated to version 1.2, added indexes and forgien keys to database model. Thanks to Gwawr and Kalvon for going through it! <3

Wish I could write this kinds of stuffs!

Nice

oh awesome! I'd love this for mudlet!!

hehehe

reminds me of a verse I remember from when I was little: "Now I am an elephant, and an elephant never forgets."

cool

This looks very nice. Would use for sure if I used mush

When elite credits tick off every month and you see a lot of +3 credits in city logs, do they all have the same timestamp to the very last second? I can't check it myself right now, a zombie dragon drowned my city >_<

 

Because.. If two or more log notes have the same timestamp and message then the plugin will record only one instance to avoid duplicity.

Interesting...

scary stuff

Liike it. Never played with databases in Mudlet but we'll see. Just need an org that I'd be interested in enough to check logs.

That would be really useful for those with houses and cities.

yes

yes