« first day (2048 days earlier)      last day (3213 days later) » 

Ben
Ben
00:57
I need a favour.. anyone familiar with SQL reports? (.rpt format)?
as in MSSQL*
@Ben Yes, but a bit rusty
Ben
Ben
0
Q: Edit multiple rows in MSSQL ".rpt" file

BenI have a report from MSSQL, that has been exported to an .rpt format. I have installed the necessary addons to open and edit the file in excel, however one such report has come out strangely. For some reason, the file has exported to place all the columns into 1 column, rather than their individ...

One report came out fine, the other one did this... I have no idea what caused it.
@Adeptus any ideas?
hey there @Ben
Ben
Ben
@Shalvenay Hey man
I missed you on the weekend
@Ben Yep. I put an answer on the Q
01:13
@Ben sorry about that -- had to hit the sack before you responded on my Fri night and didn't see you at all on my Sat night
Ben
Ben
@Adeptus Just as I found another solution haha. I'll likely choose your answer, because it answers the question I asked.
@Shalvenay Yeah sorry man, got pretty busy on Sunday (your Sat)
@Ben np, given what day it was....
02:10
BESW's Great Big Post o' Pre-Made Comments, v 2.0, in case anyone finds that useful.
(sidenote: ugh, someone pointed a camera at the screen while they played a YouTube video, then posted the result on YouTube)
03:03
@heathenJesus hi!
03:22
@BESW heh, caught me lurkin, huh?
Also, hi!
Glad to see you!
I'm actually in a clinic right now, so chatting will be erratic, but thanks again for that answer about approaches.
Thanks!
I got a bit grumpy and defensive at first, but it became a much, much better answer
I'm running an Umdaar game next weekend and will try to keep it in mind.
Yeah, I've been kicking Fate around in my head a lot, lately. Only just started to really grok it. Playing it actually didn't help me wrap my head around it, which is a little strange
And, yeah, it can be off-putting to be on the receiving end of that process. Especially since comments encourage brevity over nicety.
I've found that reading and playing different flavors of Fate helps, as does playing entirely different games for comparison and contrast.
03:27
It's surprisingly difficult to not take things personally on the internet. It's silly and irrational, but so are humans I guess? ¯_(ツ)_/¯
Yup. [grin]
I think mostly I was too trained for other types of systems that I didn't realize all of the ways I was trying to just use Fate to be not-Fate
Yes, that. I'm still working on the code-switching involved.
But, personally, I like to research—especially for creative things—so I dove pretty deep down the rabbit-hole of Fate
Sometimes we play something like Roll For Shoes or Great Ork Gods for a session, as a kind of pallete cleanser.
03:29
It's all starting to fit in my head, now... and the most frustrating part is that it's basically just all of the clichés people hurl at you
I just actually understand them now
I know, right. There's a hurdle, after which we understand but have trouble explaining.
It's like in rock climbing, everyone tells you "It's all about the legs" and "pay more attention to your feet" but that's all just noise until one day you just realize "oh my god, I just used my legs, I should just do that"
I'm starting to get near the "can also explain" hurdle. I think.
Ditto—or so it seems. At least, with a little struggling and prompting, anyway :)
And then I find something in a new World of Adventure, or a dev interview, which tumbles everything again.
Atomic Robo character creation makes so much more sense now.
03:33
Sure! And of course, you learn both things about how the system itself works, but also how the system works for you, which can be two different things, but both important
We always understood that Fate supports half-made PCs that get filled in during play, but never embraced it so fully before.
I'm actually GMing a pick-up one-shot next weekend, total blank slate
... Though I've been telling others to do it for years.
Going to use the Spark in Fate Core world/chargen system
@BESW hah!
Cool. I haven't actually poked Spark much. What do you like about it?
(If I vanish suddenly, the doc showed up.)
03:36
TBH I haven't played/read any Spark—just the crossover chargen instructions I specifically mentioned 😳
But I like the way that it provides a little structure, and also has mechanics for keeping a balance of idea sources, so introverts don't get dominated during game creation
My group uses mostly a homebrew hack of Atomic Robo, but we also love Umdaar, and I've had success with running Doctor Who in FAE.
I've played a handful of Fate Core, but never actually any FAE... hope that doesn't invalidate my answer D:
but I've been turning it over in my head so much lately that I felt I could legitimately provide an answer to that question
Dresden Files has some interesting ideas, but the setting doesn't work for us: it's balanced on a knife's edge which means PCs can't change the world much without destroying it.
yeah, Dresden Files did have that little issue
I have also had trouble "making" characters as we go, but it seems to so far be working well for Brooklyn
In our current campaign, we've put an artificial Moon in the sky, sent Shatner into space to film a Star Trek reality show, and unplugged all of Hollywood. And that's the last five sessions.
@heathenJesus it seems to have worked!
03:56
Thanks! Hopefully that means I'm ready for Sunday's game :)
Keep dialogue open, don't roll for the sake of rolling, keep the Fate points moving.
Everything else is, in my experience, just about making the tools work for your group.
And that's what the open dialogue is for.
04:16
I just want to hug this guy for anticipating a problem - "We've got this dynamic, and it seems like it might be a bad time in an RPG context." So often we have questions where the best answer is "you probably should have done XYZ months ago/be playing a different game entirely."
Especially in group-dynamics. Most people don't realize there's a problem until it's probably too late.
05:06
@SirTechSpec Unfortunately, many attempts to head off that kind of problem at the pass are met with resistance to the idea that anticipated problems should be mediated beforehand.
05:38
@heathenJesus Have you seen the Majestic 12 "Mission Briefing" mechanics?
They're toward the bottom of this page, and have a similar "light structure to help everyone participate equally" dynamic to them, but for adventures instead of campaigns.
05:50
Hmmm, I like that
Haven't had a chance to read through ARRPG yet, but everyone speaks so highly of it
It has certain strong points for sure
It's pretty well written, provides more crunch than Core with better coherence and direction than Dresden Files, and has better solutions to some topics than Core.
Probably won't get much traction with this particular group though—we played some Fate Core, but skills and stunts really tripped them up. Mostly new-to-RPG players, loved the roleplaying and worldbuilding, but they weren't really grokking those level of mechanics, so I think megastunts etc are right out
But I feel like they'll be able to wrap their heads around approaches more readily
Like, it tosses out Refresh.
If you want more stunts than you have free slots, the GM gets another NPC fate point for each one instead of you losing your starting Fate points.
That means instead of your awesomeness staying roughly even, the GM gets the tools to throw more awesome at you because you can handle it.
Still, I think the less crunch I can run on, the better, for this table. I'll have to save for a different group
05:57
Agreed.
or maybe this group, but after they've gotten how Fate works
I feel the "no Refresh" hack takes out crunch where it's not needed.
Yeah, but it mostly just means more stunts
and stunts were a big stumbling block. There's a lot of questions you need to know the answers to to write stunts
How do these work? What should I build on? What's important? How do I know if this is a good stunt?
Well, it means no conversion between stunts and fate points when you're starting out: you just have a flat number of starting fate points, and a flat number of stunts, and it only gets more complex when you want it too.
Stunts are weird.
Definitely one of the more complex pieces
05:59
Here, have some Doctor Who FAE part-pre-made PCs I designed for new players.
Lots of little bits of balance hidden in them
Yeah, I like the more limited, structured stunts of Accelerated
Especially for noobies!
There are a couple of PCs in there with "break a rule" stunts.
Ah, I guess my comment got purged.
Adric, Ace, and the Brig.
I designed them for people who might be new to Doctor Who AND to Fate, or who at least only know about New Who.
@BESW True, but they don't have to be. If you've never written a stunt, having a framework is a nice thing.
06:02
So they're classic companions and a generic-ish Doctor, with enough filled in to give a sense of the characters but also let the players make 'em their own.
@heathenJesus Aye.
Yeah, the start-em-half-written approach is great. Think you called that out earlier, too :)
I also really like the Worlds of Adventure like Umdaar which give a lot of example stunts with a lot of solid flavour.
Yeah! Examples are good, especially same-flavored ones like that
> Magical Weapon (Forceful/Flashy): You have a magical weapon or minor artifact that can deal damage. Once per scene, when you Forcefully or Flashily attack, you may loudly call out the name of the weapon, granting you +2.
06:03
That stunt right there tells you exactly the sort of genre you're in.
Totally
Our Atomic-Robo-ish game had its characters visit Umdaar for one "volume" of our campaign, and we picked up a new PC there.
Mixing crunchy-heavy Core-ish PCs with light FAE PCs actually worked just fine, with some light number tweaking.
Yeah, the big thing there is the lower ranges on FAE characters
but it's all still Fate
06:32
Bam, edited my answer.
 
2 hours later…
08:47
@BESW So it would seem none of us managed to get to the finals.
@eimyr Oh, well. I got people I don't know telling me they liked it, and people I kinda know who were interested enough to run it with people I don't know. So I feel like I won anyway.
And, heck, even without any of that I got to write something that stretched my brain as a game designer and helped me articulate a notion about imbalanced cultural contact zones that had been bugging me.
well done!
on a side note , this week I'll be running Great Ork Gods.
I'm accepting story seeds.
My default is, Orks have been disproportionately angered by something twee or sweet, Grinch-style.
My group's Orks have been angered by gnomes' campfire songs, and by Santa Claus.
From there, it's just a matter of inventing ridiculously inoffensive things for them to smash/loot/burn, and ridiculously simple obstacles to kill them.
09:04
that's a good idea
what do you normally give Oog for?
Trogdor's first Ork charged down a hill, tripped in a gopher hole, tumbled down the hill, hit a rock, broke his neck, and died.
@eimyr I'm pretty stingy with Oog.
The sample scenario gives Oog for major quest completion and killing enemies
but I'm thinking that there should be other contests of orkiness
well, apart from survival
If you hand out too much Oog, it stops being special and it makes goblin-bonuses cheap.
Well, I'm keener to give 1 Oog more often but let go of 3 Oog bonuses for stuff
And, well, since the group is small there will be frequent self-god Easy rolls and therefore lots of Spite tokens in play.
Fair enough.
I'd be interested to hear how more Oog in play works.
09:11
I also think goblins are quite fun to use.
My players are likely to hog their only goblin if they only get one
True.
Last Friday we played Goblin Quest
I have that from a Bundle, but only glanced at it.
So I'm thinking of linking the plot to parsnips somehow.
It's a bit like KAMB too
Very random.
("185 pages for a one-shot game?" [sets back down])
09:14
(185? Really? I thought it's like 18 at most)
Goblin Quest?
GQ is like 120
what's 185 pages long?
Ah, I have the Special Edition.
Three digits of page numbers is still more than I want for a one-shot.
I see.
We had three quests - to cook calamari, to run around the wizard's tower and to steal Cusson's Pearl.
To do that last thing we needed a bag to put it in. We pored over the map of the area asking each other "Where could a bag be?"
...steal the wizard's pointy hat?
09:18
One of the players suggested going to a gift shop, which after a round of laughter we decided to put on a map, because there should totally be a gift shop in GQ version of Mordor.
Lovely.
I got to roleplay an Ork NPC, who refuses to hand out a bag without a government-sanctioned 5p charge.
 
1 hour later…
10:49
Duel of the Fate Edits.
That is the reference I was making, yes.
I just needed to listen to it. And make everyone around listen to it to.
I've been listening to the pop songs from Ash vs Evil Dead for a day or three now.
I'm obsessed about this now youtube.com/watch?v=zyN2eJpMXHs
10:54
...though I did spend about half an hour on Saturday looping the Gravity Falls theme song.
I feel cheated that I never got to watch it as a kid.
or Adventure Time
I'm content to have grown up with Square 1 TV, Ghostwriter, Reading Rainbow, etc.
(I mean, I also grew up during Batman TAS, Animaniacs, and other awesome cartoons, but I hardly watched those. Didn't have cable in my house.)
I'm from this awkward period where kids TV wasn't yet considered "serious business" but was already running out of classic bedtime story ideas. Also, my TV choices were limited by lagged TV shows and no access to cable/sat TV.
My shows were Disney's Winnie the Pooh, Smurfs and Captain Tsubasa
...I mostly had public broadcast re-runs from five or ten years earlier.
Maybe a bit of Yattaman in my younger days.
same here
And I didn't realise anime was a thing, as I saw some episodes of Dragon Ball and Sailor Moon and thought it's weird, cliched rubbish.
11:02
...I also had this.
I had Polish cartoons.
My friends were big into TMNT and Power Rangers, but from a very young age I was skeptical of anything that seemed like a merchandising ploy.
I didn't care too much about merchandising, but I wanted to see plot continuity, something broadcasters didn't care about (showing, e.g. seasons 2, 3, 1 and 5 in that order)
I feel lucky Mathnet got aired in order most of the time.
To this day, the phrase court stenographer is hilarious to me.
As is the word dodecahedron.
be later
ttfn
11:07
@eimyr I shall. [engages time travel drive]
@doppelgreener The Time Masters won't like that.
Luckily they seem to be quite incompetent.
[time travel drive gearstick is stuck at "1 second per second"]
2
Try putting it in reverse. These old engines sometimes got better mileage at speed in reverse.
the time machine promptly explodes in reverse
there are now two time machines,.. how did this happen?
...that means it's fixed, right?
11:11
I figured it meant there is a copy now
...Scott Pilgrim is so thorough of a zeitgeist of which I'm aware but not a part that I find myself unable to have opinions on it.
Its main function in my life is to make me say, "So this is what kids are into now?" about what's technically my own generation.
@BESW As in you've seen it but didn't enjoy it, or you haven't seen it?
@Miniman I've seen it.
11:43
I saw it, I don't remember being too impressed with it or disliking it all that much
it's a good nerd movie
Not necessarily that I like the characters plot or whatever is in there.
I do appreciate movie workmanship that went into making the experience what it is.
the plot was definitely underwhelming, the action was ok
I like Michael Cera.
I wouldn't say I dislike him,... but a lot of movies he has been cast in were definitely not my style
I have certainly seen the occasional thing he was in that I liked, but I think there has been more of the other kind
I think I liked his performance in Juno for being realistic to the point of annoyance.
11:51
I did like Juno
Superbad was,.... super bad
Didn't see it.
I don't know what else I should have expected really
Well, if I see a movie has Jonah Hill in it and I can't get away from watching it, I don't set my expectations high.
I think you missed nothing important XD
Otherwise I just walk away.
11:54
yeah, unfortunately most of the things he is cast in is immature laugh bait
at least that I personally have seen
I saw 21 Jump street because it was my only option on the plane
Well, he was equally terrible in Wolf of Wall Street (Hill)
@eimyr yeah that is who I meant,... and all the characters in that were terrible people, though I sorta assume you mean his acting
Cera seems like a good actor, who showed great promise, but was typecasted into "awkward teen" one too many times and then went into a Shia LaBoeuf phase. I'm still waiting for Hollywood to recognise this guy's mug and high-pitched laugh is not his only acting asset.
@trogdor I do mean his acting. While it was a movie about a bunch of dishonest gazillionaire addicts, he was the one played for laughs and still wasn't funny.
mm this is a lot of what I mean when I say I don't dislike him (Cera), but a lot of movies he has been in were bad
at the very least to my own taste
I just realised Style Dayne is not Paul Dano.
12:05
I am getting tired, good night for now
ttfn
12:22
0
Q: Should I try to improve my answer even after it was selected?

PunkgeonPretty much as the title. I would like to add more information and edit the organization of the answer I gave and was selected by the asker, is it bad practice? Will my answer lose the selected mark?

 
2 hours later…
14:24
Afternoon all, rpg.stackexchange.com/questions/79881/… or is that comment a new question? Is asking 3 questions about a nebulous aspect of this rule, speculatively, okay, or should I just go with my gut when I'm running it?
I'm just conscious that it'd be 3 similar questions about a fairly minor rule in the same day.
-_-" Dunno
@StuperUser You could add it to the final paragraph of the question as one of your possibilities for what happens.
HELO chat!
@Anaphory Hi!
yo
14:30
@eimyr yo! You back, or still away?
@StuperUser K, I'll edit my answer
back
After the workoliday and running Great Ork Gods this week with Mage (!) campaign (!!!) ripening to start in 4 weeks (!!!!!)
I'll not have many sessions left to play this month, but I'm determined to start something next month in a new place with new people!
heh
I've been persuaded to increase game size from 4+1 to 5+1. There's good interest.
14:45
Brilliant, thanks @Miniman I haven't run too much combat with people using help, but can tell I'm going to have a few questions coming when running it.
 
1 hour later…
16:12
Hey
What's a good source for landscape patterns for making maps in Inkscape?
Swamp, deciduous tree, deciduous forest, coniferous tree, more other trees, etc.?
Poetic map style, not topographic map style.
 
3 hours later…
19:36
0
Q: Can I ask a question about DMing published DND adventures for the first time?

SirTechSpecIn this question I asked a pretty specific question which I think can/will/is generating useful answers. However some of the comments (before they were removed) suggested that, incidentally, Curse of Strahd was a poor choice. I know game-recs are offtopic, so I can't ask "What's a good starting...

20:29
what would you like more "fatigue die" or "depletion die"?
or maybe you have another descriptive name?
depends on what it does
fatigue sounds better to me
well, it basically reduces the number of dice available for actions
hmmmm!
fatigue sounds more in-role
depletion sounds more rule-like
Basically, if you have a maximum of 5, and you get a point of fatigue (or whatever), you can only use 4 if you have one of those special dice in the pool, until you can remove it somehow.
I mean that, fatigue die sounds like it's describing what the character is experiencing, while depletion die sounds more descriptive about what it actually does to the player's dice pool
20:41
the thing is, im struggling with the name since I want it to also apply to robotics
I get your preference though :/
robots don't tire indeed
maybe you need to find a word that fits both an organic being AND a mechanical one
like... depletion
hehehe
you're the GM I assume
Well, I'm writing a rules book, I assume I will GM first
Aaaah
Fate right?
No, its unrelated to common systems
20:47
I'm building something from the grounds up
the system too?
damn that is a colossal task
yeah
it is
but I like it.
(apart from laying it out for a print format shiver)
Though some parts of it already existed in my head for years
I need to write it down, or I will never get it out of my head
can you give me quick glimpse at it?
rules or universe?
EVERYTHING...
I will quote Gul'dan
20:52
XD
ahaha.
okay.
So far, I envisioned a dice pool-based system with degrees of success, using d6's. There are no classic attributes in the way of strength or charisma, instead its all tied to skill groups, like "electronics". Each skill has an experience rating. If you test for an ability, you sum the thrown dice and see whether it is above the minimum success threshold.
However, if the sum is also above the experience rating, you "overestimate" and fail. You can choose how many dice you want to throw depending on the skillgroup the ability belongs to.
If you simply dont reach the threshold, you just fail, without any other side effects.
Behold those who have power, and who are not afraid to wield it. Behold... the warlocks!
@Golokopitenko Boom.
@DoomedMind Stress is a good word for lots of things.
@eimyr yeah, but i feel it doesn't quite catch what I want to model. It would kinda fit, but it feels weird.
21:08
You're trying to model that a certain number of dice are permanent and some are subject to character's current status, aye?
And these some are name dice.
yeah, I guess.
And yet you use a negative (depletion, fatigue) word to describe them, despite them being essentially good, but fragile
yes, because these dice cannot be used, thus basically "clogging" your dice pool
if you have a pool of 5, and one name dice is in it, you can only use the other 4.
but they can if you're not fatigued, is that correct?
hmmm
if you're not fatigued, the name dice would not be in your pool, yes
21:11
could you explain the concept to me some more?
yeah, sure
I'm fine, and I get smacked in the face. I gain 1 Fatigue point and 1 Fatigue dice, which goes into my pool?
What happens if I don't get smacked?
Unless I have it completely backwards it sounds very weird.
I have dice in my pool that I can't roll. And I gain them when something bad happen.
Why wouldn't I just lose dice as I'm more fatigued?
so, I have a "Stamina" pool of 5. There are 3 dice in it, since I previously used 2. I get hit and need 4 dice to have a decent chance to ward off a stagger effect. Since I dont have enough, I can use the three dice, thus emptying my pool. I can now put one fatigue die in the pool, and then fill it to capacity with normal ones.
I now have 4 additional dice to ward off the stagger, at the cost of reducing my effective pool size until I properly get rest.
I see.
Don't call it a die then, my suggestion is.
Using coloured or named dice is just a concept to not have to write everything down.
21:16
a die is something you roll
it's confusing
I understand what you're saying
I think I need something else then though.
maybe a Fatigue Token?
mhh
sounds reasonable
and we come back to your original problem
21:18
you could also find the word you like and then design your wording around that word
let's say you like a word vigor
ah, I see
you can always say that you use one of your vigor slots or vigor points and your dice pool has to be reduced by the number of vigor whatevers used/consumed/bandersnatched
I think clarity, then evocativeness should be priorities here, not the other way around.
But still, I'm not sure what would be the best word for the given situation. Perhaps a native speaker would be more helpful.
I need to think about this more. Or maybe not. This helps alot though, thanks.
I think I need to run a test soon to see whether people understand the rules easily or if they need more explanations, in which case I need to rework what I wrote or redefine the rules to be easier to understand.
I'm not sure why you don't just reduce the number of dice.
@Ringo_StR Hi!
I could. The reason why I didnt go that route is because I dont necessarily want much erasing on the character sheets. Just look at the base value and see how many dice I can use or even fill up to.
21:29
You don't need to erase.
Have the character sheet say the max value, and have the physical pool of dice on the table show how many you've got available.
yes, but the max changes by what I wrote earlier. To symbolize this, I added these "fatigue" whatevers.
I believe it helps keeping track of how fatigued the character is.
19 mins ago, by Doomed Mind
so, I have a "Stamina" pool of 5. There are 3 dice in it, since I previously used 2. I get hit and need 4 dice to have a decent chance to ward off a stagger effect. Since I dont have enough, I can use the three dice, thus emptying my pool. I can now put one fatigue die in the pool, and then fill it to capacity with normal ones.
So the reduced pool size is permanent?
until the character gets a good nights rest
I'm kinda thinking about DRYH.
You might find its over/under mechanic with shifting dice pools useful inspiration.
mhh, thanks for the suggestion, I'll look into it
21:37
Basically: you've got three colours of dice that you add to your pool depending on what you're doing. The more dice you have in your pool, the more likely you are to succeed. But the colour of the successful dice means good or bad things also happen.
EG, there might be "Fatigue" dice that you must always add to your pool. If they come up most successful out of all the colours in your pool, you get another Fatigue die.
(Or you lose a Will die, I honestly can't remember, it's been a while.)
Anyway, it's a dynamic shifting pool where dice are good AND risky.
thats actually quite interesting. :)
thank you :)
I will now sleep over it. maybe some good idea springs to mind :)
I like mechanics which provide something less linear than big fail - little fail - little win - big win.
ttfn
yeah, makes it more interesting
I might use the concept in parts.
good night (or whatever it is for you now) :)
21:54
@Scrollreader Hi!

« first day (2048 days earlier)      last day (3213 days later) »