User talk:Kymara: Difference between revisions

</source>

== flour ==

<source lang = "sql">

create table temp_milled_flour

select source, substring_index(param2,';',1) as count, id as gameEvents_id, timedate

from gameEvents where event ='quest' and param1 = 'jenny_mill_flour' and param2 <> 'done' and timedate <

'2010-11-24';

-- if they didn't pick it up then delete it - oh and they might pick it up between now and the next release too.

delete FROM stendhal.temp_milled_flour where (select id from gameEvents where event ='quest' and param1 =

'jenny_mill_flour' and param2 = 'done' and temp_milled_flour.source=gameEvents.source and gameEvents.id > gameEvents_id limit 1) is null;

-- repeat? but checking the pickup gets harder.