| Forum Index > LoL General |
AsmodeusXI
United States15536 Posts
On April 09 2013 12:20 Sufficiency wrote: 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/ | ||
|
jcarlsoniv
United States27922 Posts
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. | ||
FakeSteve[TPR]
Valhalla18444 Posts
+ Show Spoiler + half-senile hindsight OP | ||
|
Craton
United States17250 Posts
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. | ||
|
Shikyo
Finland33997 Posts
Plz don't report for actually talking about LoL. | ||
|
ticklishmusic
United States15977 Posts
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
Australia2725 Posts
| ||
|
Amarok
Australia2003 Posts
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. | ||
|
thenexusp
United States3721 Posts
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
United States15977 Posts
On April 09 2013 14:19 Amarok wrote: 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
France45622 Posts
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. | ||
|
Tommie
China658 Posts
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 ) | ||
|
Shikyo
Finland33997 Posts
It's just something I've read and it tbh makes no sense, must test. | ||
|
JonGalt
Pootie too good!4331 Posts
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? | ||
|
wei2coolman
United States60033 Posts
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. | ||
|
sob3k
United States7572 Posts
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. | ||
|
AsnSensation
Germany24009 Posts
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
United States60033 Posts
| ||
|
ExoFun
Netherlands2041 Posts
On April 09 2013 16:37 AsnSensation wrote: 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
United States10796 Posts
| ||
| ||
StarCraft 2 StarCraft: Brood War Britney Dota 2  35067Calm  5326Sea  3130Horang2 2922Shuttle 2702Flash 1681ggaemo 1365hero 1092EffOrt 1020Barracks 1008[ Show more ] Counter-Strike Other Games singsing2406 B2W.Neo1486 hiko978 crisheroes417 Fuzer  275mouzStarbuck174 XaKoH  167Happy138 ArmadaUGS73 QueenE39 rGuardiaN32 FunKaTv  24ZerO(Twitch)15 |
|
RotterdaM Event
OSC
WardiTV Summer Champion…
WardiTV Summer Champion…
PiGosaur Monday
WardiTV Summer Champion…
Stormgate Nexus
uThermal 2v2 Circuit
The PondCast
WardiTV Summer Champion…
[ Show More ] |
|
|
EPT
