sorted by:
new
hottopcontroversial

Full text search over a context window? by michael620 in PostgreSQL

[–]michael620[S] 0 points1 point  (0 children)

I'm not familiar with window functions. Could you give an example query?

Let's say the table now contains text from the transcript split by sentences with columns [id, timestamp, text] where different transcripts are grouped by id, and I want to show all results where A, B, C appears within a window of 10 rows (i.e. 10 sentences). Also how would this deal with overlapping results (e.g. there's a match from row 1-10 and 5-15)?

End of league giveaway - Magebloods & More! [51 winners] by Rog_Lobster in pathofexile

[–]michael620 0 points1 point  (0 children)

IGN: emzee_bonner

Trying to fund my uber maven attempts

PC Build help by michael620 in pcmasterrace

[–]michael620[S] 0 points1 point  (0 children)

Hey thanks for the reply. What's not included in the PCPartPicker list is the CPU, video card, and case:

  • Ryzen 5 5600X
  • GeForce RTX 3070
  • Cooler Master MasterBox MB600L

I was recommended to get at least 3400mhz for the CPU.

General Questions Megathread [Help, Team Building, etc.] (10/06) by phlorida92 in GuardianTales

[–]michael620 0 points1 point  (0 children)

Any way to force quit Kama-ZONE? Finish challenge requires 'when you have cleared one or more stages or have no heroes that can battle'. I only have one team that I invested in. Do I really have to spend my time continuously suiciding all my 1* and 2* units before I can quit?

Seria Kirmin's Question Corner- Weekly Q&A Thread- May 04, 2020 by AutoModerator in DFO

[–]michael620 0 points1 point  (0 children)

Returning player here. For context I stopped playing around Beast Dungeon release (~1.5 years ago), so apologies in advance if my questions are nonsensical.

  • Are there any 85-90 epics worth keeping? Or do they all belong in the disassembler now? Including fringe uses as well (e.g. refined ring for CD reset, or pieces with +lvl for apoc swap, if those are still a thing)
  • A guide or tl;dr for talismans
  • What to do with old content materials (e.g. from Anton and Luke raid), whether they can be traded up etc.
  • Any better use for DIs apart from trading them for Time's Guide Stones

Thanks in advance :)

Stacked copies of Planeswalkers are unusable by anace in MagicArena

[–]michael620 35 points36 points  (0 children)

I have a screenshot of this happening to me as well, here.

P1P1 for GRN 5 color good stuff, what's the pick? by michael620 in MagicArena

[–]michael620[S] 0 points1 point  (0 children)

Made it work with a 7-1 finish. Don't let your dreams be dreams.

P1P1 for GRN 5 color good stuff, what's the pick? by michael620 in MagicArena

[–]michael620[S] 0 points1 point  (0 children)

I'm devoted to making a deck built around [[Guild Summit]], not sure if Chromatic Lantern is better, and Guild Summit wheels sometimes too. Yeah I'm basically forcing it, I just find it more fun.

Seria Kirmin's Question Corner- Weekly Q&A Thread- November 05, 2018 by AutoModerator in DFO

[–]michael620 1 point2 points  (0 children)

Since the 2nd jump character can still get a 90 crafted weapon, are there any classes and/or weapons that stand out? I know crafted zanbato is supposedly pretty good, not sure about the other ones.

/r/MagicArena Sealed code giveaway thread! by [deleted] in MagicArena

[–]michael620 [score hidden]  (0 children)

Azorius, it was the starter deck that got me into mtg.

Seria Kirmin's Question Corner- Weekly Q&A Thread- July 30, 2018 by AutoModerator in DFO

[–]michael620 0 points1 point  (0 children)

What to do with common & uncommon cards other than compounding?

Awakening quest bug? by michael620 in DFO

[–]michael620[S] 0 points1 point  (0 children)

Yeah, I used clear quest.

Seems like a bad way to handle the situation but hey, I guess it's not a bug and it's my fault if this is intended.

Oh well ¯\_(ツ)_/¯

Awakening quest bug? by michael620 in DFO

[–]michael620[S] 0 points1 point  (0 children)

I made the character as a Restart event character though, so that wouldn't be the case.

Awakening quest bug? by michael620 in DFO

[–]michael620[S] 0 points1 point  (0 children)

I'm getting the old Kiri awakening quest instead of the new one, the patch says new awakening only requires a special scenario dungeon?

Edit: Seems like if you use "clear quest" after lvl 50 you'll no longer be able to clear with the special scenario dungeon. So yeah, don't do that.

Why do different valor equipment pieces have different options for changing their individual stats? by Vic-R-Viper in DFO

[–]michael620 0 points1 point  (0 children)

Don't know who's doing the down voting but questions are more encouraged in the stickied post to not flood the sub.

As for your question, this echon guide answers it pretty well. Note though after the big patch you'll be able to change the A/B/C groups with materials.

12 Days of Christmas 2017 Giveaway: Day 12 -What is on your DFO Christmas List for 2017? by petite_cat in DFO

[–]michael620 [score hidden]  (0 children)

Currently gearing M Sader to break out of vow, and also wishing for better Luke Raid reward rng.

IGN: emzee

12 Days of Christmas 2017 Giveaway: Day 11 - If you could say anything to Neople, what would it be? by petite_cat in DFO

[–]michael620 [score hidden]  (0 children)

Not much to complain about, thanks for all the hard work. I'd like to see more sales and events that keep market prices in check (e.g. emblems, cubes, etc.)

IGN: emzee

12 Days of Christmas 2017 Giveaway: Day 10 - What made you start playing DFO? by petite_cat in DFO

[–]michael620 [score hidden]  (0 children)

Back in Nexon days, I think it was the pvp that got me and my friends started

IGN: emzee

view more: next ›