• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 07:04
CET 13:04
KST 21:04
  • 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 win3Weekly 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
Weekly Cups (Dec 8-14): MaxPax, Clem, Cure win ComeBackTV's documentary on Byun's Career ! 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
Thoughts on sustainable packaging trends in the UK 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
Tourneys
[Megathread] Daily Proleagues [BSL21] WB SEMIFINALS - Saturday 21:00 CET [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
US Politics Mega-thread Things Aren’t Peaceful in Palestine The Games Industry And ATVI Russo-Ukrainian War Thread 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
Computer Build, Upgrade & Buying Resource Thread
TL Community
TL+ Announced Where to ask questions and add stream?
Blogs
The (Hidden) Drug Problem in…
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: 913 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 56m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
SortOf 252
Lowko152
trigger 66
Rex 42
ForJumy 18
StarCraft: Brood War
Britney 25425
Rain 5423
actioN 1682
GuemChi 1574
Horang2 1313
ZerO 415
Stork 386
Soma 316
Mini 263
Light 260
[ Show more ]
JYJ 243
BeSt 239
Larva 238
Last 208
Hyuk 197
firebathero 183
EffOrt 173
Sharp 155
hero 110
sorry 90
Hyun 87
Pusan 80
Snow 77
Rush 75
Mind 58
Barracks 49
Sea.KH 33
Mong 32
soO 32
Shinee 29
yabsab 22
Terrorterran 21
Sacsri 21
Movie 16
Icarus 15
Shine 13
scan(afreeca) 12
Noble 11
Dota 2
singsing2288
Gorgc2272
Dendi347
XcaliburYe120
League of Legends
C9.Mang0331
rGuardiaN66
Counter-Strike
shoxiejesuss948
x6flipin505
byalli234
allub151
Other Games
olofmeister1798
B2W.Neo963
crisheroes309
Mew2King73
Livibee72
QueenE41
ArmadaUGS27
Trikslyr27
Organizations
StarCraft: Brood War
Kim Chul Min (afreeca) 1103
Other Games
gamesdonequick670
StarCraft: Brood War
UltimateBattle 69
lovetv 8
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 14 non-featured ]
StarCraft 2
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• iopq 8
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• WagamamaTV128
• lizZardDota265
• Noizen32
Upcoming Events
WardiTV 2025
56m
Cure vs Creator
Solar vs TBD
herO vs Spirit
Scarlett vs Gerald
Rogue vs Shameless
MaNa vs ShoWTimE
Nice vs TBD
ComeBackTV 109
Rex42
WardiTV 2025
22h 56m
ByuN vs TBD
Clem vs TBD
OSC
1d 1h
CranKy Ducklings
1d 21h
WardiTV 2025
1d 22h
SC Evo League
2 days
Ladder Legends
2 days
BSL 21
2 days
Sziky vs Dewalt
eOnzErG vs Cross
Sparkling Tuna Cup
2 days
Ladder Legends
3 days
[ Show More ]
BSL 21
3 days
StRyKeR vs TBD
Bonyth vs TBD
Replay Cast
3 days
Wardi Open
3 days
Monday Night Weeklies
4 days
WardiTV Invitational
5 days
Replay Cast
6 days
WardiTV Invitational
6 days
ByuN vs Solar
Clem vs Classic
Cure vs herO
Reynor vs MaxPax
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.