Differences

This shows you the differences between two versions of the page.

--- lua:vodurtodo:vodur_s_todo [2015/01/01 00:49] – vodur
+++ lua:vodurtodo:vodur_s_todo [2015/03/03 21:48] (current) – vodur
@@ Line 43: / Line 43: @@
 fix more appropriate CH methods to be globals
-<code lua>
+luaquery menu based version, still spits out full luaq args at the end so you can share or whatev
--- Kain GRALL code for sack of rice
-say("Keep counting kid... We'll work some of that fight out of you.")
+luaquery saved queries (per char or global???)
-emote("puts some bricks on Cloud's back, JUST to make sure he gets a work out.")
--- Kain greet code to start quest
+Tue Mar  3 14:39:04 2015::Dr. Vodur immtalks 'sql is tricky in its own right'\\
-local ricevnum=7326
+Tue Mar  3 14:39:25 2015::Bobble immtalks 'with menu you mean an interactive mode with multiple inputs?'\\
-local qvnum=14800
+Tue Mar  3 14:39:29 2015::Dr. Vodur immtalks 'yes'\\
--- Don't give quest if timer is still running
+Tue Mar  3 14:39:53 2015::Bobble immtalks 'hmm.. not sure I'm so sold on that idea - I kinda like a simple query interface'\\
-if ch:qtimer(qvnum)>0 then
+Tue Mar  3 14:40:03 2015::Dr. Vodur immtalks 'well it will only be an option'\\
-    say("You should give someone else a turn. Come back in %d hours", ch:qtimer(qvnum))
+Tue Mar  3 14:40:20 2015::Bobble immtalks 'nod, just not sure I would be using it much'\\
-    return
+Tue Mar  3 14:40:26 2015::Dr. Vodur immtalks 'and in the end it will spit out a full query syntax that you can share/reuse'\\
-end
+Tue Mar  3 14:40:44 2015::Bobble immtalks 'hmm.. that could be neat for learning I suppose'\\
--- Don't talk them if already gave something
+Tue Mar  3 14:40:56 2015::Commander Astark immtalks 'yea.. I still use "help luaq" often enough'\\
-tracker=tracker or {}
+Tue Mar  3 14:41:12 2015::Dr. Vodur immtalks 'anyway, if you're serious, probably can also add support for select x,y,z from op where a and b and c syntax'\\
-if tracker[ch.name] then return end
+Tue Mar  3 14:41:28 2015::Bobble immtalks 'and it wouldn't be real SQL with nesting, joins or multiple tables..'\\
+Tue Mar  3 14:41:33 2015::Bobble immtalks 'nod'\\
-say("Hey %s! I need some more weights for cloud. Can you bring me a '%s'?",
+Tue Mar  3 14:41:40 2015::Dr. Vodur immtalks 'right, if it was just to that extent, it's not a big deal'\\
-    ch.name,
+Tue Mar  3 14:41:54 2015::Bobble immtalks 'select [list] from [type] where [conditions]'\\
-    getobjproto(ricevnum).shortdescr)
+Tue Mar  3 14:42:26 2015::Bobble immtalks 'almost same as now but with keywords instead of quotation marks'\\
--- End Kain greet code
+Tue Mar  3 14:42:31 2015::Dr. Vodur immtalks 'right'\\
-</code>
+Tue Mar  3 14:43:00 2015::Dr. Vodur immtalks 'gotta support order by and top/bottom probably'\\
+Tue Mar  3 14:43:16 2015::Bobble immtalks 'although could prolly drop the select which is just redundant'\\
+Tue Mar  3 14:43:20 2015::Dr. Vodur immtalks 'and add a keyword for limiting column width'\\
+Tue Mar  3 14:43:40 2015::Bobble immtalks 'we're gonna create our own new language yet ;)'\\
+Tue Mar  3 14:44:23 2015::Bobble immtalks 'hmm.. transformation functions in the select part maybe? like..'\\
+Tue Mar  3 14:45:00 2015::Bobble immtalks 'luaq vnum, substr(name,0,10) from ...'\\
+Tue Mar  3 14:45:10 2015::Dr. Vodur immtalks 'actually it's already supported with current syntax so should be fine'\\
+Tue Mar  3 14:45:38 2015::Dr. Vodur immtalks 'name:sub(1,10) i think would be the syntax'\\
+Tue Mar  3 14:45:48 2015::Bobble immtalks 'yeah, that's even nicer'\\
+Tue Mar  3 14:46:09 2015::Dr. Vodur immtalks 'sounds fun, think i'll mess with it'\\
+Tue Mar  3 14:46:19 2015::Bobble immtalks ':)'\\
+Tue Mar  3 14:46:28 2015::Dr. Vodur immtalks 'would be more intuitive for me as well tbh'