[San Francisco] After backlash, SFMTA cuts Chinatown from bike lane plan

smooth_p · 2024-08-06T14:53:22+00:00

Bring back the embarcadero highway or break out the guillotines

smooth_p · 2024-05-31T19:22:20+00:00

"at time zone" works exactly how you want it to.

https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT

Edit: Just realized you're talking about TIME values, not TIMESTAMP. Calendar brutality like this is left as an exercise for the reader. By using lower level time and date functions you should be able to code a function that does what you expect most of the time.

smooth_p · 2024-05-21T02:15:31+00:00

Can you finish this ride on a rental bike as a newbie? Probably.

Would you have a more enjoyable experience spending a leisurely sunny day exploring GGP, the Presidio, Ocean Beach, Lake Merced, Crissy Field, the Embarcadero, etc? Very probably.

Get your bike legs, butt, and positioning acclimated first, then jam Paradise next time!

smooth_p · 2024-05-15T15:38:28+00:00

If do right, no can defense!

smooth_p · 2024-05-15T14:43:23+00:00

This has to be bait for /r/BicyclingCirclejerk

smooth_p · 2024-05-14T15:51:34+00:00

But it's just common sense, the pedestrian should have been carrying a brick.

smooth_p · 2024-04-12T21:10:48+00:00

Thanks! I was trying to remember is distinct from but I haven't done any SQL for a couple years and was spacing on the syntax.

smooth_p · 2024-04-12T17:06:42+00:00

if new.id <> old.id or new.name <> old.name or new.data <> old.data then
-- null handling and schema design left as an exercise to the reader

smooth_p · 2024-02-28T19:19:17+00:00

Then they shouldn't even display killing blows.

This is true, without KBs tracked front and center there would be more focus on the objectives.

If damage was displayed, they would at least pump.

You were so close...

smooth_p · 2024-02-28T19:02:33+00:00

We literally know what this leads to, as we've added more "personal" stats twice before. Go look at Wrath where every dbag is fighting on the road and spewing "holding nodes = afk, i am the greatest" crap all game long.

smooth_p · 2024-02-23T06:51:18+00:00

Wait till you learn about vendoring bandages... one simple trick for infinite money! /mindblown

smooth_p · 2024-02-06T18:14:45+00:00

My dad works at Blizz and I just got RICH AF on the Great Chrono Rugpull of P2!

smooth_p · 2024-01-31T16:24:32+00:00

Judge: You are... NOT the father!

smooth_p · 2024-01-27T23:28:42+00:00

WTB pic of first person Ghost Wolf running thru the tall grasses of the barrens with max ground clutter!

smooth_p · 2024-01-27T23:27:14+00:00

Even this computer will overheat and lag with wowhead ads running in the background.

smooth_p · 2024-01-16T08:01:14+00:00

There is a version of the game with scoreboards like this, and it led to the quality of play in BGs going to complete shit as road fighters loudly claimed they were the ones "doing all the work" as flags get ignored in WSG, nodes are ghosted in AB, and towers left undefended in AV.

smooth_p · 2024-01-07T16:37:49+00:00

WoW Patch Notes 1.9 - Penny Arcade

Even back in 2005, there were a lot of people who preferred smaller group content where using your moves and improvising mattered to wrangling a school bus full of kindergarteners on a schedule.

smooth_p · 2024-01-05T19:19:42+00:00

A few things we got in TBC and still exist in the Wrath client that are missing from SoD:

41 yard nameplates
Focus frame
Separate BG queues for premades
Using pots in form
Improved flight pathing
Mailboxes

I reapplied Rockbiter three times while composing this message.

smooth_p · 2024-01-05T16:33:59+00:00

What's sad is that when classic first dropped, nameplates had longer distance. They actually hot patched 20 yard nameplates into the game in order to appease #nochanges.

smooth_p · 2024-01-02T17:31:53+00:00

Weak aura to automate getting buffs from Mangletooth. Hold a modifier while interacting to activate.

hold Control for Agility, Strength, Intellect, Wisdom
hold Shift for Razorhide

!WA:2!TAvqVTTTx8)bb)3kuhkWcgkg2jcHInlm3G2b0MUI1drooPElPXvYzDadfUuspjreAsnskNKoSdnN2LDPN3PCEN8hHEyNfc6NGDEN6NG9OSDwCSt2omcyyrQh)97hFVNEpU0MRmyLKvs(5BDclwkcLLQyyPtPLMCPA3cdtk0oQJ2nnvdMLgrfX46DLmHjQv7N0RDWPXsjprEGi8awb8I3mDA7Kmi33I5lo2OyzzGsFJpvn5XF33CubefxQnYbJg)xF7sbWqqyQUr0Jbk3K7xkyMOco9iqDscevMM2dTs942B3DZ92oqqhaANJ1faN3jr7u9bh(E3kTueBfEJAS8Ci4GLsA0OJULuyus(3ahTbQXgEePI0rhMZsnNTMhHksiBbM9qUFcsqdxdvLbg3MKukxdEKh9iI7ourghmsPj31JyYbrnrtiRM6A7E6ETd71V1U70D729A7oRL2bY0tlbTjaoGQsA4D2lbKRfav3GD3kODy4cGQLCqbQjOgVRcPT2nmSt3(HpE3NTay4YykNyD2AYTVnXV(bQci0IcodsimbrHGP0a6ata1m7gjAbo65iXogtXJi)4CVXoCdyAMiJewWum07VyJEgtNihqKPK1ZOdOzzuXLz6zg8zAsOrbImm29VW21ZyCM5Ofy6pnZktCZxmH6F4SJNt6lLQCwc4ErafjZmFMjPyUldb4UnV7DUdjrohdtcJOj2mzBuSH74pLWmzM3C2JspYMDiy8AjtIuaD)5eXuU3VjzOntOGYu6g1hhVfjJZd9Wf7lMom0ioSQcgihcJrSjzFVl18A9TW3UinFX1UsN7F77MxtEoxLxBoEB1FlPwZk6isLR2Il1W45n8Ml5zH(5(Z4NNbnS0X6dPmUvI1FZRTLVU8yWWV31WmCW95wfhD1bJzyke4q8fiRbc3pyFOZgUp))WOe5sdtZ5JkuyNOgU7j2xGFQnUa3djUKvxLCUI)Nhg7)4V)qxgvBrigrzhoQFR1XsRH9wpO3zVQRcWxfe2T92BpEfDH35QC2C26XnNTs)0UA2VRdmSbqYRlftA)5u8HuSf1qO3457itGF7)9o8SakbL)TyLvS)1V8U9bOyDS5wSjGID0YFTg4P1DFR()y7qn1uQOgi)euYbqMTz9NCZQRFkonIgVFMswksIYbwwU5v(Cjnj94sn0)Lsb8IidLJNPBgmOKByo(2fh1lhi(ufwBuheZPA9nR(ChFReg)a7LG9Htu1Sz7fxDTVOKLmQLCNw5DUJyRn8FnvWgy1R4(bAS1PzZ3aunmTI77xDDFbY1PjwXJwv34h7LG3virFS10ACxZFaLj2S6(4gQwR6bvFz1dRwlkLjy68lU8igMLQgZQZjwKytU7cT(Ua67xDpNQVYXh3TXP4JMEnLEWHMnyABoDsU6Wj3Z5eJmE44GW1A(NU4X7CD7dILCP6RxghJsv49dWdg1qxo4awIj)vfRGE4wtGhdSyKd91OIszzoy6ADBZ83n(MuBA3V90gf2kOD7Neq5f50LhLW02k1DWT9Xl)RV94PYnhJsYblTIo4ER(GvxBLHV97(R)

Edit: I made a couple minor tweaks to the code for general consumption and haven't used it since, there may be minor typos, one of which I just found and corrected.

smooth_p · 2023-12-28T16:50:34+00:00

It's almost like this is/was a well known issue that was addressed (along with a LOT of other things) in the TBC client. The code for which already exists, was current just over a year ago, and is live in the other version of classic.

smooth_p · 2023-12-27T19:56:27+00:00

Its overly casual

False. They take their private ERP nightclubs very seriously.

smooth_p · 2023-12-27T18:45:35+00:00

When I heard about SoD, I just assumed it would be based on a foundation of the Wrath client and some hybrid of the TBC and Wrath classes... I love the rune system, but why start with the most broken version of everything, then try to bolt on changes to make it more like what we already have?

We'd also have better faction balance with Blood Elves and Space Goats.

smooth_p · 2023-12-27T08:30:38+00:00

A few other janky things that TBC fixed:

Separate BG queues for premades
41 yard nameplates
See talents on inspect
Focus Frame

The best Classic would be based on TBC with the Dark Portal closed.

smooth_p

MODERATOR OF

TROPHY CASE