[Request] Query.

[~ViVo~]

~ViVo~
This post is edited to fit my current request..

Spamming uncontrollably in my console is ascentlogon.playercooldowns' Doesn't exist..
Fix?!?! :*(

[latruwski]

~ViVo~

Ok, I'm having trouble with this..
I need a query that will remove all items (Tokens) Needed to buy items.
I also need a query that will remove arena points..
Manually was difficult on my old server.. Now its near impossible..
I'm pretty good at sql, these seem to stump me.
Thanks.

update items set itemextendedcost = 0

will remove all the tokes from items (no more tokens needed to buy item)

Update Characters set arenapoints = 0

will remove arenapoints from all characters...


grtz

[~ViVo~]

lolwut
Nice, Thanks..
I was doing a whole bunch of crap.
look lol

update `Items` set ItemExtendedCost= ' ' where Itemextendedcost=0;

I had no clue lol.
I'm going to make a thread on these.

[latruwski]

lolwut
Nice, Thanks..
I was doing a whole bunch of crap.
look lol

update `Items` set ItemExtendedCost= ' ' where Itemextendedcost=0;

I had no clue lol.
I'm going to make a thread on these.

i saw you release about arenapoints... if you wnt to remove arena rank requirement of items use this query:

update items set arenarankrequirement = 0

grtz

[TheSpidey]

Oh why didn't you ask me this 3 days ago? I made a query to remove all limits on items, including faction and race. Not including class though :P

[~ViVo~]

Grats On Contributer Spidey!!!
Edit: Can I get that code too?

[TheSpidey]

I don't have it anymore, I used it once and deleted it :P
Figured no point in keeping a query i'll never use again

[~ViVo~]

Oh ok, Thanks anyway.. I'mma pm you so be ready

[~ViVo~]

Bump UPDATE