A to-do plugin

Excuse me if a similar plugin exists, but I am requesting a to-do plugin that can be called with the command /todo

I am requesting this because people on my server have no purpose anymore. I want to restore the cooperation that was there at the genesis of the server.

The syntax, if possible, would be
/todo -> bring up list of to-do items
/todo add [yourplanhere] [priority] -> add plan to list
/todo done [planpriority] -> remove plan which had a priority number

For all this to function correctly, I also want permissions support.
Default [add] and [done] commands to admins, and list viewing to anyone, including guests.

 

I could possibly help you out. Let me see what i can do.

 

Thanks! I'm not good with Java programming. Wait, let me rephrase that. I don't know ANY Java.

I'll help with what I can.

 

I will try to make this, as a first java project. If it is done by the time i get through with it oh well...
*edit* if i make this will i be able to post it publicly? or should i just send it to you?

 

I think that it'd be best done publicly, with feedback & improvement from the community.

In fact, I think that this plugin is much-needed on any server.

 

I like the idea...!
I might make something after MCStats which will involve concepts like this, but it won't be exactly what you're asking for.

 

I don't really have the authority to comment on this but in theory the concept should be easy.

Start off with a MySQL db.

/todo add [plan] [priority]

*incorrect SQL syntax but oh well*

IN TABLE todo ADD ROW '[priority]' WITH CONTENT '[plan]'
IF ROW '[priority]' EXISTS {
'[priorityold]' = '[priorityold+1]'
UNTIL '[priority]' = [EmptyTable]
}

/todo done [priority]

*as usual, totally incorrect syntax*

IN TABLE todo REMOVE ROW '[priority]'
ALL OTHER ROWS = '[priority]' - 1

/todo

*syntax note*

FETCH TABLE todo

Again, no authority at all on programming pointers, just showing you guys the ideas/possible solutions behind the plugin.

 

Yeh, I see. You shouldn't need MySQL for this because you can use SQLite. I'm good with sql syntax so this shan't be too hard.

 

Right. So are you going to do this after MCStats?

 

I'll give this a go

 

Probably not actually. I've got other things I need to work on that are way more important. Even more than MCStats, actually.

 

I understand. I'm 16 and have lots of things to do too.

Awesome! I won't ask for an expected date because... well because to a programmer 10 minutes means 3 hours.

As I have said earlier, I think it's more than just my server that needs this plugin

Edit: P.S. Sorry I don't know how to quote posters...