• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 13:03
CEST 19:03
KST 02:03
  • 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
Team Liquid Map Contest #22 - The Finalists14[ASL21] Ro16 Preview Pt1: Fresh Flow9[ASL21] Ro24 Preview Pt2: News Flash10[ASL21] Ro24 Preview Pt1: New Chaos0Team Liquid Map Contest #22 - Presented by Monster Energy21
Community News
2026 GSL Season 1 Qualifiers11Maestros of the Game 2 announced32026 GSL Tour plans announced10Weekly Cups (April 6-12): herO doubles, "Villains" prevail1MaNa leaves Team Liquid20
StarCraft 2
General
Team Liquid Map Contest #22 - The Finalists Weekly Cups (April 6-12): herO doubles, "Villains" prevail MaNa leaves Team Liquid Oliveira Would Have Returned If EWC Continued 2026 GSL Tour plans announced
Tourneys
2026 GSL Season 1 Qualifiers Sparkling Tuna Cup - Weekly Open Tournament Master Swan Open (Global Bronze-Master 2) SEL Doubles (SC Evo Bimonthly) $5,000 WardiTV TLMC tournament - Presented by Monster Energy
Strategy
Custom Maps
[D]RTS in all its shapes and glory <3 [A] Nemrods 1/4 players [M] (2) Frigid Storage
External Content
Mutation # 521 Memorable Boss The PondCast: SC2 News & Results Mutation # 520 Moving Fees Mutation # 519 Inner Power
Brood War
General
ASL21 General Discussion BGH Auto Balance -> http://bghmmr.eu/ Pros React To: Tulbo in Ro.16 Group A RepMastered™: replay sharing and analyzer site BW General Discussion
Tourneys
Escore Tournament StarCraft Season 2 [ASL21] Ro16 Group B [Megathread] Daily Proleagues Small VOD Thread 2.0
Strategy
Simple Questions, Simple Answers What's the deal with APM & what's its true value Any training maps people recommend? Fighting Spirit mining rates
Other Games
General Games
General RTS Discussion Thread Nintendo Switch Thread Battle Aces/David Kim RTS Megathread Stormgate/Frost Giant Megathread Starcraft Tabletop Miniature Game
Dota 2
The Story of Wings Gaming Official 'what is Dota anymore' discussion
League of Legends
G2 just beat GenG in First stand
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
Vanilla Mini Mafia Mafia Game Mode Feedback/Ideas TL Mafia Community Thread Five o'clock TL Mafia
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread YouTube Thread Canadian Politics Mega-thread
Fan Clubs
The IdrA Fan Club
Media & Entertainment
Anime Discussion Thread [Req][Books] Good Fantasy/SciFi books [Manga] One Piece Movie Discussion!
Sports
2024 - 2026 Football Thread McBoner: A hockey love story Formula 1 Discussion Cricket [SPORT]
World Cup 2022
Tech Support
[G] How to Block Livestream Ads
TL Community
The Automated Ban List
Blogs
Reappraising The Situation T…
TrAiDoS
lurker extra damage testi…
StaticNine
Broowar part 2
qwaykee
Funny Nicknames
LUCKY_NOOB
Iranian anarchists: organize…
XenOsky
ASL S21 English Commentary…
namkraft
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1616 users

[Patch 3.05.2: April Fools] League of Legends General Disc…

Forum Index > LoL General
Post a Reply
Prev 1 99 100 101 102 103 113 Next
AsmodeusXI
Profile Blog Joined July 2007
United States15536 Posts
April 09 2013 03:59 GMT
#2001
On April 09 2013 12:20 Sufficiency wrote:
Show nested quote +
On April 09 2013 12:13 obesechicken13 wrote:
On April 09 2013 12:07 Sufficiency wrote:
I need some help on something totally unrelated to LoL. Can anyone help? I am sure there are computer science majors here:

+ Show Spoiler +
I want to learn some SQL (just the basic stuff, such as SELECT * FROM TABLE), but I also want to be able to test the commands out. What kind of DBMS should I get? I downloaded mySQL and it seems so complicated that I don't know how to get it working.

You'd get more responses on the big programming thread but MySQL is fine and easier to learn than some of the other SQLs. If you're installing the server locally then setup should be fairly straightforward iirc.

http://www.teamliquid.net/forum/viewmessage.php?topic_id=134491&currentpage=281#5618

Disclaimer: I have to do a google before every one of my SQL queries.

Yango tango can probably help you more or some of the other computer buffs. What are you going to be using the SQL for?


Oh thanks that's a much better place to ask for that kind of kind X_X

I just want to know how to do SELECT * FROM TABLE, tbh. I am not looking for fancy stuff.


Über basics (which I also constantly refer to): http://www.w3schools.com/sql/
WriterTL > RL. BNet: Asmodeus#1187 - LoL: DJForeclosure - Steam: asmodeusxi | www.n3rddimension.com
jcarlsoniv
Profile Blog Joined January 2010
United States27922 Posts
April 09 2013 04:22 GMT
#2002
On April 09 2013 12:07 Sufficiency wrote:
I need some help on something totally unrelated to LoL. Can anyone help? I am sure there are computer science majors here:

+ Show Spoiler +
I want to learn some SQL (just the basic stuff, such as SELECT * FROM TABLE), but I also want to be able to test the commands out. What kind of DBMS should I get? I downloaded mySQL and it seems so complicated that I don't know how to get it working.


At my internship they're teaching me a lot of SQL because half of what my department does is rooted in databases.

I've been using Microsoft SQL Server Management Systems.

I have the added benefit of having terabytes worth of databases to play with, as well as a few good programmers to help me out when I get stuck.
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
FakeSteve[TPR]
Profile Blog Joined July 2003
Valhalla18444 Posts
April 09 2013 04:30 GMT
#2003
Ah, Travian, or How I Paved NeoIllusion's Path to Glory. YOU'RE WELCOME

+ Show Spoiler +
half-senile hindsight OP
Moderatormy tatsu loops r fuckin nice
Craton
Profile Blog Joined December 2009
United States17281 Posts
Last Edited: 2013-04-09 04:48:21
April 09 2013 04:47 GMT
#2004
Get WAMP.

Basic SQL should take about one day to learn and a week to memorize. Advanced SQL will take substantially longer because syntax becomes precipitously less important than efficient design.

PL/SQL is my day job.
twitch.tv/cratonz
Shikyo
Profile Blog Joined June 2008
Finland33997 Posts
Last Edited: 2013-04-09 05:04:36
April 09 2013 05:03 GMT
#2005
Hm so why does no one ever build Wit's End on anyone? I've heard that it's gotten terribly nerfed and so on but looking at its stats and considering the increase in prices of both MR and aspd(especially aspd), Wit's End has actually become relatively better than it used to be, especially after the MR buff. So what's the deal? Are the newer items just better? Or maybe because everyone goes mass HP the passive isn't that good ...



Plz don't report for actually talking about LoL.
League of Legends EU West, Platinum III | Yousei Teikoku is the best thing that has ever happened to music.
ticklishmusic
Profile Blog Joined August 2011
United States15977 Posts
Last Edited: 2013-04-09 05:20:57
April 09 2013 05:16 GMT
#2006
On April 09 2013 14:03 Shikyo wrote:
Hm so why does no one ever build Wit's End on anyone? I've heard that it's gotten terribly nerfed and so on but looking at its stats and considering the increase in prices of both MR and aspd(especially aspd), Wit's End has actually become relatively better than it used to be, especially after the MR buff. So what's the deal? Are the newer items just better? Or maybe because everyone goes mass HP the passive isn't that good ...



Plz don't report for actually talking about LoL.


It does a decent amount of on-hit magic damage, but there's better options generally speaking-- cost efficient, but not particularly slot efficient? Getting a recurve bow is kind of weird, dropping a whole 1k at once on attack speed. Instead, you could go for Bork which builds out of daggers.

Also, attack speed and mpen are two stats that usually don't go together. Some guys use hybrid runes, but its a little weird past that.

There's a couple guys I like it on, like jungle Cho. I play a pretty low-cost tanky/ support Cho with like Golem, Tabi, Aegis, Locket, Wits and wards. Doesn't really affect ganking power, and makes him a terror in midgame fights.
(╯°□°)╯︵ ┻━┻
TheLink
Profile Joined January 2011
Australia2725 Posts
April 09 2013 05:17 GMT
#2007
Blade of the Ruined King straight up replaced Wits End from what I can tell. I've bought it once in S3 and that was just so I could go quad null-mantle on Irelia v 2-0 Rumble.
Only the weak link is strong enough to break the chain.
Amarok
Profile Joined August 2010
Australia2003 Posts
April 09 2013 05:19 GMT
#2008
On April 09 2013 14:16 ticklishmusic wrote:
There's a couple guys I like it on, like jungle Cho. I play a pretty low-cost tanky/ support Cho with like Golem, Mercs, Aegis, Locket, Wits and wards.


Golem AND Mercs?

I always wanted to try Lizard Elder on jungle Cho (spikes proc the burn afaik) but it's been nerfed so many times now.
Fighting for peace is like screwing for virginity
thenexusp
Profile Joined May 2009
United States3721 Posts
April 09 2013 05:20 GMT
#2009
On April 09 2013 14:03 Shikyo wrote:
Hm so why does no one ever build Wit's End on anyone? I've heard that it's gotten terribly nerfed and so on but looking at its stats and considering the increase in prices of both MR and aspd(especially aspd), Wit's End has actually become relatively better than it used to be, especially after the MR buff. So what's the deal? Are the newer items just better? Or maybe because everyone goes mass HP the passive isn't that good ...



Plz don't report for actually talking about LoL.

When I want AS and an on-hit effect, I think botrk; when I want MR, I think of hexdrinker or some pure defensive item like spirit visage. I barely even remember wit's end still exists...
ticklishmusic
Profile Blog Joined August 2011
United States15977 Posts
Last Edited: 2013-04-09 05:26:40
April 09 2013 05:20 GMT
#2010
On April 09 2013 14:19 Amarok wrote:
Show nested quote +
On April 09 2013 14:16 ticklishmusic wrote:
There's a couple guys I like it on, like jungle Cho. I play a pretty low-cost tanky/ support Cho with like Golem, Mercs, Aegis, Locket, Wits and wards.


Golem AND Mercs?

I always wanted to try Lizard Elder on jungle Cho (spikes proc the burn afaik) but it's been nerfed so many times now.


woods, brain fart. meant tabi probably, haha. fixed it anyways. (edit: wow, i said woods, i'm tired)

i finish it off with a sv usually, though sometimes randuins and chug blue pots. i just realized this build (now) has triple kindlegems, im such a baller.

they do proc it, but all it does is make chogath a true damage monster (which really isnt as good as it sounds). i think adding wits or something adds more damage, the burn is actually fairly poor. i think wits is better b/c it gives a little tankiness, adds as much damage to his basic attacks and the increased speed/ap actually make his vorpals do more than they would with lizard burn.
(╯°□°)╯︵ ┻━┻
Alaric
Profile Joined November 2009
France45622 Posts
April 09 2013 05:32 GMT
#2011
I build it on jungle Vi whenever I'm not against double AP (I'll generally either rush it if fed, or go for aegis first in that case), and rather late (if I get fed enough I'll buy an early recurve bow, otherwise I'll sit on the phage/stinger/tabi core with a NMM if I need MR, complete a belt item (randuin's or mallet), and then finish the Wit's if I need more defense).
A lot of games are decided before I actually build it, thus. On Jax I prefer SV because it gives CDR (reducing E's cd is so important to duelling carries lategame), and I haven't played Irelia in awhile.
Cant take LMS hipsters serious.
Tommie
Profile Blog Joined September 2010
China658 Posts
April 09 2013 06:51 GMT
#2012
Like the spirit of the ancient golem change. I always built locket after spirit stone, may look into golem spirit now that it builds out of a kindlegem. This also gives you more options for tier 2 boots since you don't necessarily need tenacity on the boots anymore.
With the giants belt the build path was so bad. I used to finish Locket, Aegis, Merc threads and sometimes bulwark even before finishing the spirit of the ancient golem ( on tanky/utility junglers like nasus )
Being a ho doesn't automatically make you "immoral" or a bad person, but it does make you a ho.
Shikyo
Profile Blog Joined June 2008
Finland33997 Posts
Last Edited: 2013-04-09 07:19:10
April 09 2013 07:16 GMT
#2013
Apparently Ravenous Hydra's active procs BotRK passive effect and Black Cleaver in the AoE.. <_< So using the active also would apply 2 stacks of BC to everyone hit.

It's just something I've read and it tbh makes no sense, must test.
League of Legends EU West, Platinum III | Yousei Teikoku is the best thing that has ever happened to music.
JonGalt
Profile Joined February 2013
Pootie too good!4331 Posts
April 09 2013 07:31 GMT
#2014
"@sedicius: Current KR Allstar #1 votes: Top Maknoon 32.6%, Mid Ambition 37.5%, Bot Pray 33.9%, Support Madlife 76.4% (lmao), Jungle Insec 53.9%"

For those interested. I don't know too much about the scenes other than NA and EU but that looks like a pretty beast KR Allstar team.

Also, without watching vods or streams, how can I get more informed on the KR/SEA/TW/CN scenes?
LiquidLegends StaffWho is Jon Galt?
wei2coolman
Profile Joined November 2010
United States60033 Posts
Last Edited: 2013-04-09 07:33:41
April 09 2013 07:33 GMT
#2015
On April 09 2013 16:16 Shikyo wrote:
Apparently Ravenous Hydra's active procs BotRK passive effect and Black Cleaver in the AoE.. <_< So using the active also would apply 2 stacks of BC to everyone hit.

It's just something I've read and it tbh makes no sense, must test.

Not like that would be even feasible in the game; there's no way you can get away as a melee champ and afford 3 pure damage item.

With exception of assassins.
liftlift > tsm
sob3k
Profile Blog Joined August 2009
United States7572 Posts
Last Edited: 2013-04-09 07:35:10
April 09 2013 07:33 GMT
#2016
On April 09 2013 14:03 Shikyo wrote:
Hm so why does no one ever build Wit's End on anyone? I've heard that it's gotten terribly nerfed and so on but looking at its stats and considering the increase in prices of both MR and aspd(especially aspd), Wit's End has actually become relatively better than it used to be, especially after the MR buff. So what's the deal? Are the newer items just better? Or maybe because everyone goes mass HP the passive isn't that good ...



Plz don't report for actually talking about LoL.


Well BOTRK stole its niche and is a better item efficiencywise and slotwise, plus it has a way better build path. Wits is actually really good though still just for its massive power spike at 2200 gold as opposed to 3200 for BOTRK, if you can just buy it decently fast its really freaking good, 350 gold for 42 magic damage is a fantastic deal, and stacked you get it more than free, its just a ton of damage.

I still definitely buy it if I'm facing a decent amount of magic damage and am planning on going more tanky (IE not going to invest 3200 in pure offensive stats) and can get it fast. Really good item just got overshadowed by BOTRK and its sexy buildup with cutlass.

mostly though people dont think about any of that, they just saw it got nerfed and never build it ever again because they are dumb.
In Hungry Hungry Hippos there are no such constraints—one can constantly attempt to collect marbles with one’s hippo, limited only by one’s hippo-levering capabilities.
AsnSensation
Profile Joined April 2011
Germany24009 Posts
April 09 2013 07:37 GMT
#2017
On April 09 2013 16:31 JonGalt wrote:
"@sedicius: Current KR Allstar #1 votes: Top Maknoon 32.6%, Mid Ambition 37.5%, Bot Pray 33.9%, Support Madlife 76.4% (lmao), Jungle Insec 53.9%"

For those interested. I don't know too much about the scenes other than NA and EU but that looks like a pretty beast KR Allstar team.

Also, without watching vods or streams, how can I get more informed on the KR/SEA/TW/CN scenes?


madlife 72% LOL

also, looks like our fellow gtrs still went with deezer for his team
wei2coolman
Profile Joined November 2010
United States60033 Posts
April 09 2013 07:45 GMT
#2018
That KR lineup is stupid beastly.
liftlift > tsm
ExoFun
Profile Joined August 2010
Netherlands2041 Posts
Last Edited: 2013-04-09 07:46:59
April 09 2013 07:46 GMT
#2019
On April 09 2013 16:37 AsnSensation wrote:
Show nested quote +
On April 09 2013 16:31 JonGalt wrote:
"@sedicius: Current KR Allstar #1 votes: Top Maknoon 32.6%, Mid Ambition 37.5%, Bot Pray 33.9%, Support Madlife 76.4% (lmao), Jungle Insec 53.9%"

For those interested. I don't know too much about the scenes other than NA and EU but that looks like a pretty beast KR Allstar team.

Also, without watching vods or streams, how can I get more informed on the KR/SEA/TW/CN scenes?


madlife 72% LOL

also, looks like our fellow gtrs still went with deezer for his team

Yea and he is now begging the community for 1300 dollar. I really think it's a scumbag move for an organisation to not cover the bills for players.


http://www.reddit.com/r/leagueoflegends/comments/1byxsm/help_velocity_esports_get_a_full_roster_for_the/

The link for the crying of a manager.
Diamond
Profile Blog Joined May 2009
United States10796 Posts
April 09 2013 07:50 GMT
#2020
Velocity using Deezer? Now I know who to root against.
Ballistix Gaming Global Gaming/Esports Marketing Manager - twitter.com/esvdiamond
Prev 1 99 100 101 102 103 113 Next
Please log in or register to reply.
Live Events Refresh
Big Brain Bouts
16:00
#112
Scarlett vs SpiritLIVE!
Serral vs herO
RotterdaM1056
IndyStarCraft 138
Liquipedia
OSC
15:00
King of the Hill #244
Liquipedia
Escore
10:00
Week 3
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RotterdaM 1075
IndyStarCraft 142
StarCraft: Brood War
Mini 415
Soma 349
actioN 189
Hyuk 162
Rush 136
Soulkey 131
ToSsGirL 118
Sexy 112
Dewaltoss 101
Aegong 75
[ Show more ]
PianO 69
Hyun 53
Rock 34
Hm[arnc] 23
Terrorterran 13
eros_byul 1
Dota 2
Gorgc4495
qojqva2356
League of Legends
Reynor97
Counter-Strike
fl0m5826
olofmeister2735
kRYSTAL_35
Super Smash Bros
Mew2King88
Other Games
FrodaN1385
B2W.Neo1341
hiko645
ceh9437
Beastyqt399
ArmadaUGS194
Trikslyr162
KnowMe118
QueenE66
C9.Mang047
sas.Sziky18
MindelVK11
Organizations
Other Games
BasetradeTV395
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 18 non-featured ]
StarCraft 2
• StrangeGG 66
• poizon28 47
• Kozan
• LaughNgamezSOOP
• sooper7s
• AfreecaTV YouTube
• intothetv
• Migwel
• IndyKCrew
StarCraft: Brood War
• FirePhoenix6
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• WagamamaTV427
League of Legends
• Nemesis3499
• TFBlade1489
Other Games
• Shiphtur191
• imaqtpie18
Upcoming Events
Korean StarCraft League
9h 58m
CranKy Ducklings
16h 58m
WardiTV Map Contest Tou…
17h 58m
IPSL
22h 58m
WolFix vs nOmaD
dxtr13 vs Razz
BSL
1d 1h
UltrA vs KwarK
Gosudark vs cavapoo
dxtr13 vs HBO
Doodle vs Razz
Patches Events
1d 4h
CranKy Ducklings
1d 6h
Sparkling Tuna Cup
1d 16h
WardiTV Map Contest Tou…
1d 17h
Ladder Legends
1d 21h
[ Show More ]
BSL
2 days
StRyKeR vs rasowy
Artosis vs Aether
JDConan vs OyAji
Hawk vs izu
IPSL
2 days
JDConan vs TBD
Aegong vs rasowy
Replay Cast
2 days
Wardi Open
2 days
Afreeca Starleague
2 days
Bisu vs Ample
Jaedong vs Flash
Monday Night Weeklies
2 days
RSL Revival
3 days
Afreeca Starleague
3 days
Barracks vs Leta
Royal vs Light
WardiTV Map Contest Tou…
3 days
RSL Revival
4 days
Replay Cast
5 days
The PondCast
5 days
WardiTV Map Contest Tou…
5 days
Replay Cast
6 days
RSL Revival
6 days
Liquipedia Results

Completed

Proleague 2026-04-16
RSL Revival: Season 4
NationLESS Cup

Ongoing

BSL Season 22
ASL Season 21
CSL 2026 SPRING (S20)
IPSL Spring 2026
KCM Race Survival 2026 Season 2
Escore Tournament S2: W3
StarCraft2 Community Team League 2026 Spring
WardiTV TLMC #16
Nations Cup 2026
IEM Rio 2026
PGL Bucharest 2026
Stake Ranked Episode 1
BLAST Open Spring 2026
ESL Pro League S23 Finals
ESL Pro League S23 Stage 1&2
PGL Cluj-Napoca 2026
IEM Kraków 2026

Upcoming

Escore Tournament S2: W4
Acropolis #4
BSL 22 Non-Korean Championship
CSLAN 4
Kung Fu Cup 2026 Grand Finals
HSC XXIX
uThermal 2v2 2026 Main Event
2026 GSL S2
RSL Revival: Season 5
2026 GSL S1
XSE Pro League 2026
IEM Cologne Major 2026
Stake Ranked Episode 2
CS Asia Championships 2026
IEM Atlanta 2026
Asian Champions League 2026
PGL Astana 2026
BLAST Rivals Spring 2026
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 © 2026 TLnet. All Rights Reserved.