• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 23:57
CET 05:57
KST 13:57
  • 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
RSL Revival - 2025 Season Finals Preview8RSL Season 3 - Playoffs Preview0RSL Season 3 - RO16 Groups C & D Preview0RSL Season 3 - RO16 Groups A & B Preview2TL.net Map Contest #21: Winners12
Community News
ComeBackTV's documentary on Byun's Career !3Weekly Cups (Dec 8-14): MaxPax, Clem, Cure win2Weekly Cups (Dec 1-7): Clem doubles, Solar gets over the hump1Weekly Cups (Nov 24-30): MaxPax, Clem, herO win2BGE Stara Zagora 2026 announced15
StarCraft 2
General
ComeBackTV's documentary on Byun's Career ! Weekly Cups (Dec 8-14): MaxPax, Clem, Cure win Did they add GM to 2v2? RSL Revival - 2025 Season Finals Preview Weekly Cups (Dec 1-7): Clem doubles, Solar gets over the hump
Tourneys
RSL Offline Finals Info - Dec 13 and 14! Master Swan Open (Global Bronze-Master 2) Winter Warp Gate Amateur Showdown #1: Sparkling Tuna Cup - Weekly Open Tournament $5,000+ WardiTV 2025 Championship
Strategy
Custom Maps
Map Editor closed ?
External Content
Mutation # 504 Retribution Mutation # 503 Fowl Play Mutation # 502 Negative Reinforcement Mutation # 501 Price of Progress
Brood War
General
FlaSh on: Biggest Problem With SnOw's Playstyle How Rain Became ProGamer in Just 3 Months BGH Auto Balance -> http://bghmmr.eu/ [BSL21] RO8 Bracket & Prediction Contest BW General Discussion
Tourneys
[BSL21] WB SEMIFINALS - Saturday 21:00 CET [Megathread] Daily Proleagues [BSL21] RO8 - Day 2 - Sunday 21:00 CET [ASL20] Grand Finals
Strategy
Game Theory for Starcraft Current Meta Simple Questions, Simple Answers Fighting Spirit mining rates
Other Games
General Games
Stormgate/Frost Giant Megathread Path of Exile General RTS Discussion Thread Dawn of War IV Nintendo Switch Thread
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
Mafia Game Mode Feedback/Ideas Survivor II: The Amazon Sengoku Mafia TL Mafia Community Thread
Community
General
The Games Industry And ATVI Russo-Ukrainian War Thread US Politics Mega-thread Things Aren’t Peaceful in Palestine YouTube Thread
Fan Clubs
White-Ra Fan Club
Media & Entertainment
Anime Discussion Thread [Manga] One Piece Movie Discussion!
Sports
2024 - 2026 Football Thread Formula 1 Discussion
World Cup 2022
Tech Support
Expert Legal Assistance for Corporate Law Concepts Computer Build, Upgrade & Buying Resource Thread
TL Community
TL+ Announced Where to ask questions and add stream?
Blogs
How Sleep Deprivation Affect…
TrAiDoS
I decided to write a webnov…
DjKniteX
James Bond movies ranking - pa…
Topin
Thanks for the RSL
Hildegard
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1268 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 States17274 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
Next event in 5h 3m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RuFF_SC2 219
StarCraft: Brood War
Sea 3254
Rain 1504
JulyZerg 44
Bale 42
GoRush 32
Mong 23
ggaemo 20
ZergMaN 19
Noble 18
Icarus 6
Dota 2
monkeys_forever361
NeuroSwarm106
League of Legends
JimRising 698
C9.Mang0425
Other Games
summit1g12952
WinterStarcraft380
Mew2King121
Trikslyr60
ViBE52
Organizations
Other Games
gamesdonequick1098
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 14 non-featured ]
StarCraft 2
• practicex 44
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• masondota21633
League of Legends
• Lourlo1110
• HappyZerGling109
Upcoming Events
The PondCast
5h 3m
WardiTV 2025
8h 3m
Cure vs Creator
Solar vs TBD
herO vs Spirit
Scarlett vs Gerald
Rogue vs Shameless
MaNa vs ShoWTimE
Nice vs TBD
WardiTV 2025
1d 6h
OSC
1d 9h
CranKy Ducklings
2 days
SC Evo League
2 days
Ladder Legends
2 days
BSL 21
2 days
Sziky vs Dewalt
eOnzErG vs Cross
Sparkling Tuna Cup
3 days
Ladder Legends
3 days
[ Show More ]
BSL 21
3 days
StRyKeR vs TBD
Bonyth vs TBD
Replay Cast
4 days
Monday Night Weeklies
4 days
WardiTV Invitational
6 days
Liquipedia Results

Completed

Acropolis #4 - TS3
RSL Offline Finals
Kuram Kup

Ongoing

C-Race Season 1
IPSL Winter 2025-26
KCM Race Survival 2025 Season 4
YSL S2
BSL Season 21
Slon Tour Season 2
WardiTV 2025
META Madness #9
eXTREMESLAND 2025
SL Budapest Major 2025
ESL Impact League Season 8
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22

Upcoming

CSL 2025 WINTER (S19)
BSL 21 Non-Korean Championship
Acropolis #4
IPSL Spring 2026
Bellum Gens Elite Stara Zagora 2026
HSC XXVIII
Big Gabe Cup #3
OSC Championship Season 13
ESL Pro League Season 23
PGL Cluj-Napoca 2026
IEM Kraków 2026
BLAST Bounty Winter 2026
BLAST Bounty Winter Qual
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.