• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 20:11
CET 02:11
KST 10:11
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
TL.net Map Contest #21: Winners11Intel X Team Liquid Seoul event: Showmatches and Meet the Pros10[ASL20] Finals Preview: Arrival13TL.net Map Contest #21: Voting12[ASL20] Ro4 Preview: Descent11
Community News
Weekly Cups (Nov 3-9): Clem Conquers in Canada3SC: Evo Complete - Ranked Ladder OPEN ALPHA8StarCraft, SC2, HotS, WC3, Returning to Blizzcon!45$5,000+ WardiTV 2025 Championship7[BSL21] RO32 Group Stage4
StarCraft 2
General
Mech is the composition that needs teleportation t Craziest Micro Moments Of All Time? Weekly Cups (Nov 3-9): Clem Conquers in Canada SC: Evo Complete - Ranked Ladder OPEN ALPHA RotterdaM "Serral is the GOAT, and it's not close"
Tourneys
Constellation Cup - Main Event - Stellar Fest Tenacious Turtle Tussle Sparkling Tuna Cup - Weekly Open Tournament $5,000+ WardiTV 2025 Championship Merivale 8 Open - LAN - Stellar Fest
Strategy
Custom Maps
Map Editor closed ?
External Content
Mutation # 499 Chilling Adaptation Mutation # 498 Wheel of Misfortune|Cradle of Death Mutation # 497 Battle Haredened Mutation # 496 Endless Infection
Brood War
General
FlaSh on: Biggest Problem With SnOw's Playstyle BW General Discussion BGH Auto Balance -> http://bghmmr.eu/ [ASL20] Ask the mapmakers — Drop your questions Where's CardinalAllin/Jukado the mapmaker?
Tourneys
[BSL21] RO32 Group D - Sunday 21:00 CET [BSL21] RO32 Group C - Saturday 21:00 CET [ASL20] Grand Finals [Megathread] Daily Proleagues
Strategy
Current Meta PvZ map balance How to stay on top of macro? Soma's 9 hatch build from ASL Game 2
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread Should offensive tower rushing be viable in RTS games? Path of Exile Dawn of War IV
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread SPIRED by.ASL Mafia {211640}
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine Canadian Politics Mega-thread The Games Industry And ATVI
Fan Clubs
White-Ra Fan Club The herO Fan Club!
Media & Entertainment
[Manga] One Piece Anime Discussion Thread Movie Discussion! Korean Music Discussion Series you have seen recently...
Sports
Formula 1 Discussion 2024 - 2026 Football Thread NBA General Discussion MLB/Baseball 2023 TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
SC2 Client Relocalization [Change SC2 Language] Linksys AE2500 USB WIFI keeps disconnecting Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Dyadica Gospel – a Pulp No…
Hildegard
Coffee x Performance in Espo…
TrAiDoS
Saturation point
Uldridge
DnB/metal remix FFO Mick Go…
ImbaTosS
Reality "theory" prov…
perfectspheres
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1351 users

Off-Topic General Discussion - Page 1877

Forum Index > The Shopkeeper′s Inn
Post a Reply
Prev 1 1875 1876 1877 1878 1879 5162 Next
Slayer91
Profile Joined February 2006
Ireland23335 Posts
Last Edited: 2014-05-06 17:51:07
May 06 2014 17:48 GMT
#37521
On May 07 2014 02:41 Scip wrote:
Show nested quote +
On May 07 2014 02:36 Slayer91 wrote:
my reaction to roffles perm ban
+ Show Spoiler +



As a reaction you became a goat


like that taylor swift song "I knew you were a goat"
in a somewhat unrelated note a guy got shot 8 times like 15 mins up the road from where I live lol
its 15 minutes toward the bad side of town sure. Apparently a senior drug gang member. In my mind though, he was the roffles of the drug gang.
he was shot a bit before roffles got banned though I think
Kyrie
Profile Joined June 2013
1594 Posts
May 06 2014 17:48 GMT
#37522
http://www.teamliquid.net/forum/league-of-legends/427971-patch-311-general-discussion?page=323#6456

it was foretold many patch cycles ago
mordek
Profile Blog Joined December 2010
United States12705 Posts
May 06 2014 17:50 GMT
#37523
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
Gahlo
Profile Joined February 2010
United States35162 Posts
May 06 2014 17:50 GMT
#37524
On May 07 2014 02:48 Kyrie wrote:
http://www.teamliquid.net/forum/league-of-legends/427971-patch-311-general-discussion?page=323#6456

it was foretold many patch cycles ago

Curse of the fall.
mordek
Profile Blog Joined December 2010
United States12705 Posts
May 06 2014 17:51 GMT
#37525
On May 07 2014 02:48 Kyrie wrote:
http://www.teamliquid.net/forum/league-of-legends/427971-patch-311-general-discussion?page=323#6456

it was foretold many patch cycles ago

He giveth and he taketh away.
Ho 1:21
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
jcarlsoniv
Profile Blog Joined January 2010
United States27922 Posts
Last Edited: 2014-05-06 17:52:40
May 06 2014 17:52 GMT
#37526
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >


Isn't the wildcard for Access "%"?

edit: wait, you don't need wildcard, what are the "#" for? (I almost never use Access, as it is the devil)
Soniv ||| Soniv#1962 ||| @jcarlsoniv ||| The Big Golem ||| Join the Glorious Evolution. What's your favorite aminal, a bear? ||| Joe "Don't call me Daniel" "Soniv" "Daniel" Carlsberg LXIX ||| Paging Dr. John Shadow
mordek
Profile Blog Joined December 2010
United States12705 Posts
Last Edited: 2014-05-06 17:55:43
May 06 2014 17:53 GMT
#37527
On May 07 2014 02:52 jcarlsoniv wrote:
Show nested quote +
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >


Isn't the wildcard for Access "%"?

edit: wait, you don't need wildcard, what are the "#" for? (I almost never use Access, as it is the devil)

I believe it's so it knows I'm specifying a date. I use this once a month and MIS class was like 5 years ago :O
I'm just moving everything to Excel where things make sense
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
wei2coolman
Profile Joined November 2010
United States60033 Posts
May 06 2014 17:54 GMT
#37528
Anyone watch the new 24? I feel so lost since I only watched season 1, and never bother watching the other season. Also, hollywood plz stop the "I got caught on purpose!" trope.
liftlift > tsm
arb
Profile Blog Joined April 2008
Noobville17921 Posts
May 06 2014 17:54 GMT
#37529
I dont understand what I'm doing wrong on Kotor, i switched sides to kill the black guy with the fake eyes, but him and his bitch just one shot everyone.
ZZZ
Artillery spawned from the forges of Hell
jcarlsoniv
Profile Blog Joined January 2010
United States27922 Posts
Last Edited: 2014-05-06 17:58:04
May 06 2014 17:55 GMT
#37530
On May 07 2014 02:53 mordek wrote:
Show nested quote +
On May 07 2014 02:52 jcarlsoniv wrote:
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >


Isn't the wildcard for Access "%"?

edit: wait, you don't need wildcard, what are the "#" for? (I almost never use Access, as it is the devil)

I believe it's so it knows I'm specifying a date. I use this once a month and MIS class was like 5 years ago :O


what happens if you remove the octothorpes?

edit: also, if Create Date is a datetime, is your query only looking for Date data? Do you have to do something to make it look for datetime? This has sometimes caused issues in BusinessObjects queries
Soniv ||| Soniv#1962 ||| @jcarlsoniv ||| The Big Golem ||| Join the Glorious Evolution. What's your favorite aminal, a bear? ||| Joe "Don't call me Daniel" "Soniv" "Daniel" Carlsberg LXIX ||| Paging Dr. John Shadow
Zess
Profile Joined July 2012
Adun Toridas!9144 Posts
May 06 2014 17:58 GMT
#37531
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >

I know 0 things about Access because I use SQL and noSQL like a real person, but unless you have a transcription error to TL you have mistmatched # signs in your query
Administrator@TL_Zess
| (• ◡•)|八 (❍ᴥ❍ʋ)
Tooplark
Profile Joined October 2008
United States3977 Posts
May 06 2014 17:59 GMT
#37532
On May 07 2014 02:54 arb wrote:
I dont understand what I'm doing wrong on Kotor, i switched sides to kill the black guy with the fake eyes, but him and his bitch just one shot everyone.
ZZZ

need more Con
What's your main character like at this point? Also, which planet are you on?
WHAT POW'R ART THOU WHO FROM BELOW HAST MADE ME RISE UNWILLINGLY AND SLOW
arb
Profile Blog Joined April 2008
Noobville17921 Posts
May 06 2014 18:00 GMT
#37533
On May 07 2014 02:59 Tooplark wrote:
Show nested quote +
On May 07 2014 02:54 arb wrote:
I dont understand what I'm doing wrong on Kotor, i switched sides to kill the black guy with the fake eyes, but him and his bitch just one shot everyone.
ZZZ

need more Con
What's your main character like at this point? Also, which planet are you on?

I picked a soldier, he's lvl 5ish or something. I've killed all the enemies ive came across, fixed all the robots etc, and i'm on Taris atm.

I'm stuck with that Twi'lek and the Wookie atm
Artillery spawned from the forges of Hell
jcarlsoniv
Profile Blog Joined January 2010
United States27922 Posts
Last Edited: 2014-05-06 18:01:38
May 06 2014 18:01 GMT
#37534
On May 07 2014 02:58 xes wrote:
Show nested quote +
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >

I know 0 things about Access because I use SQL and noSQL like a real person, but unless you have a transcription error to TL you have mistmatched # signs in your query


I assumed this was just a copy/paste issue :3

Would be nice if that's the fix though lol
Soniv ||| Soniv#1962 ||| @jcarlsoniv ||| The Big Golem ||| Join the Glorious Evolution. What's your favorite aminal, a bear? ||| Joe "Don't call me Daniel" "Soniv" "Daniel" Carlsberg LXIX ||| Paging Dr. John Shadow
Dandel Ion
Profile Joined November 2010
Austria17960 Posts
May 06 2014 18:07 GMT
#37535
you mean the hidden bek guy right?

I can't remember anything beyond focussing down the bitch first and then killing the black guy after.

Should be doable IIRC


Man it's been too long, too bad kotor always crashes on my PC now ;_;
A backwards poet writes inverse.
arb
Profile Blog Joined April 2008
Noobville17921 Posts
May 06 2014 18:09 GMT
#37536
On May 07 2014 03:07 Dandel Ion wrote:
you mean the hidden bek guy right?

I can't remember anything beyond focussing down the bitch first and then killing the black guy after.

Should be doable IIRC


Man it's been too long, too bad kotor always crashes on my PC now ;_;

Ya the hidden bek guy, i got her low spamming grenades but he jumps from member to member fucking them in the ass and its real gay
Artillery spawned from the forges of Hell
TheYango
Profile Joined September 2008
United States47024 Posts
Last Edited: 2014-05-06 18:11:41
May 06 2014 18:11 GMT
#37537
What's your party, at that point in the game you should just be able to yolo everything.

+ Show Spoiler +
Though the Sith Governor is kind of annoying if you deliberately choose to hold level-ups for when you become a Jedi.
Moderator
Dandel Ion
Profile Joined November 2010
Austria17960 Posts
May 06 2014 18:11 GMT
#37538
Sorry I can't remember exactly but I'm pretty sure that he's never went around one-shotting my team.
maybe your levels/equip is really bad I dunno
A backwards poet writes inverse.
mordek
Profile Blog Joined December 2010
United States12705 Posts
May 06 2014 18:11 GMT
#37539
On May 07 2014 03:01 jcarlsoniv wrote:
Show nested quote +
On May 07 2014 02:58 xes wrote:
On May 07 2014 02:50 mordek wrote:
Hi smart people. I hate Access. I have a simple query to get all the complaints created from a certain date to a certain date
-> Between #2/1/2013# And #4/30/2014 in criteria for the field "Created Date"
It turns up nothing and i've quintuple checked Created Date is in the Date/Time format >

I know 0 things about Access because I use SQL and noSQL like a real person, but unless you have a transcription error to TL you have mistmatched # signs in your query


I assumed this was just a copy/paste issue :3

Would be nice if that's the fix though lol

Yes 100% copy+paste error there. Access actually adds the # back in if you remove it (recognizing MM/DD/YYYY as a date)
It is vanity to love what passes quickly and not to look ahead where eternal joy abides. Tiberius77 | Mordek #1881 "I took a mint!"
gtrsrs
Profile Joined June 2010
United States9109 Posts
May 06 2014 18:18 GMT
#37540
at level 5, you are potentially too low-leveled to face the hidden bek guy. even level 6 might make the difference though. just level up by doing some contract killings with zax or farming rakghouls

i've been playing it with my g/f, we're just a little bit further than you. love this game
i play ... hearthstone =\^.^/= Winterfox
Prev 1 1875 1876 1877 1878 1879 5162 Next
Please log in or register to reply.
Live Events Refresh
Replay Cast
23:00
PiGosaur Cup #55
CranKy Ducklings147
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
ProTech126
Nathanias 90
CosmosSc2 44
trigger 18
StarCraft: Brood War
Artosis 666
Counter-Strike
fl0m761
taco 573
Super Smash Bros
hungrybox1252
AZ_Axe126
Other Games
summit1g12281
shahzam649
Day[9].tv549
ViBE160
Maynarde139
C9.Mang0102
fpsfer 1
Organizations
Other Games
BasetradeTV25
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 18 non-featured ]
StarCraft 2
• Hupsaiya 87
• davetesta13
• IndyKCrew
• sooper7s
• AfreecaTV YouTube
• Migwel
• intothetv
• LaughNgamezSOOP
• Kozan
StarCraft: Brood War
• HerbMon 33
• Azhi_Dahaki16
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• masondota21202
League of Legends
• imaqtpie2607
Other Games
• Scarra817
• Day9tv549
Upcoming Events
Replay Cast
7h 50m
OSC
10h 20m
Kung Fu Cup
10h 50m
Classic vs Solar
herO vs Cure
Reynor vs GuMiho
ByuN vs ShoWTimE
Tenacious Turtle Tussle
21h 50m
The PondCast
1d 8h
RSL Revival
1d 8h
Solar vs Zoun
MaxPax vs Bunny
Kung Fu Cup
1d 10h
WardiTV Korean Royale
1d 10h
PiGosaur Monday
1d 23h
RSL Revival
2 days
Classic vs Creator
Cure vs TriGGeR
[ Show More ]
Kung Fu Cup
2 days
CranKy Ducklings
3 days
RSL Revival
3 days
herO vs Gerald
ByuN vs SHIN
Kung Fu Cup
3 days
IPSL
3 days
ZZZero vs rasowy
Napoleon vs KameZerg
BSL 21
3 days
Tarson vs Julia
Doodle vs OldBoy
eOnzErG vs WolFix
StRyKeR vs Aeternum
Sparkling Tuna Cup
4 days
RSL Revival
4 days
Reynor vs sOs
Maru vs Ryung
Kung Fu Cup
4 days
WardiTV Korean Royale
4 days
BSL 21
4 days
JDConan vs Semih
Dragon vs Dienmax
Tech vs NewOcean
TerrOr vs Artosis
IPSL
4 days
Dewalt vs WolFix
eOnzErG vs Bonyth
Wardi Open
5 days
Monday Night Weeklies
5 days
WardiTV Korean Royale
6 days
Liquipedia Results

Completed

Proleague 2025-11-07
Stellar Fest: Constellation Cup
Eternal Conflict S1

Ongoing

C-Race Season 1
IPSL Winter 2025-26
KCM Race Survival 2025 Season 4
SOOP Univ League 2025
YSL S2
BSL Season 21
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual

Upcoming

SLON Tour Season 2
BSL 21 Non-Korean Championship
Acropolis #4
IPSL Spring 2026
HSC XXVIII
RSL Offline Finals
WardiTV 2025
RSL Revival: Season 3
META Madness #9
BLAST Bounty Winter 2026
BLAST Bounty Winter 2026: Closed Qualifier
eXTREMESLAND 2025
ESL Impact League Season 8
SL Budapest Major 2025
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.