User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara →flour: new section |
imported>Kymara |
||
| Line 193: | Line 193: | ||
<source lang = "sql"> |
<source lang = "sql"> |
||
create table temp_milled_flour |
create table temp_milled_flour |
||
select source, substring_index(param2,';',1) as count, id as gameEvents_id, timedate |
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'; |
|||
'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. |
-- if they didn't pick it up then delete it - oh and they might pick it up between now and the next release too. |
||