Making your whole server instant cast.

[Equ1N0X]

title says it all, now on with the guide

notice, this will vary from database to database, go intoi the table "spells 112" in your world database and replace the cooldown category with 0 or null for every spell, GL with wastin your life.

OPTION B. pre execution of SQL

1: open database SQL
2: go to notepad>Edit>replace
3: Place name of your cooldown column into replace
4: click replace all
5: now in "replace with" space enter a single space(spacebar)

now when you execute the SQL, the cooldowns will not be insterted, I did this back in patch 2.0.12,and I dont think cooldown has been changed much so it should stiill work, but i cnat test atm cuz parents wont elt me turn on server.



sorry about being unclear, did in 6 minutes and memory's foggy, im being kept away from mysql till tommorow so cnat check if works with modern, but before executing your database, go to notepad and find the "edit" tab. now choose "replace"

now in the first box you enter name of your cooldown/casttime column, and where it says "replace with" type in " " (its just one space)

now you hit "replace all" and save, then execute SQL.

it should work, if not, and someone here finds what im messing up in SQL, please post so i can correct.

[Neer]

wow i must try this xd

[Illidan1]

Very Nice Tinkerfoe, Some one was looking
how to doe this Early on +Rep

[djblade17]

hey does this just cover the cool down of the spell or the actual casting time?

[Illidan1]

This Covers the actual casting time

[djblade17]

Omg thanks i been looking for this everywhere

[djblade17]

im getting confused on the steps well not what to do just where i found a section under my world info that had cooldown labled but i changed them all 2 0 and nothing happened so i dont think that would help im using Wintchman's Ascent Repack 2 and sqlyog if anyone has any ideas

[djblade17]

i am getting stuck on these instructions i open notepad i go to replace type in CastingTimeIndex then i click replace all and it changes 'CastingTimeIndex' to ''
from there im suppose to go down to the next line of replace and put a space.....then no more instructions am i suppse to hit replace again do i save im just alittle lost... i ended up save it and trying to load it and it gives me a error saying '' or ' ' is not a vaild colume name that it cant import here is the line in my notepad i believe im suppose to edit
`CastingTimeIndex` int(100) default '0',

does that seem to be it? any help would be great thanks

[Herzeleid]

Very nice, a valid contribution that will help my future servers and many others.

+Rep

[Equ1N0X]

sorry about being unclear, did in 6 minutes and memory's foggy, im being kept away from mysql till tommorow so cnat check if works with modern, but before executing your database, go to notepad and find the "edit" tab. now choose "replace"

now in the first box you enter name of your cooldown/casttime column, and where it says "replace with" type in " " (its just one space)

now you hit "replace all" and save, then execute SQL.

it should work, if not, and someone here finds what im messing up in SQL, please post so i can correct.

[Illidan1]

Very nice Tinker but if you dont mind im ganna make it Noob Friendly

Step 1 : Open your Database with what ever tool u use

Step 2 : Find the Table Called "Spell112" in Ascent
Or just fin it if your Database are not Sperrated

Step 3 : In the Table "Spell112" Find a Sql Format Called "Cooldown"
Or somthing like that

Step 4 : change it from what it is to "0"

Step 5 : Restart Server

Step 6 : Try and see if it works

I did this at School i canit enter Database i don't
thing that it is called "Cooldown" in the Table "Spell112"
it might be somthign else i will update when i get home :wave:

[djblade17]

hey all just trying to make sure i have this right
the line i believe is it is `CastingTimeIndex` int(100) default '0',
if that sounds correct now i would take that and change it to
`0` int(100) default '0',
so basically the colume is still there just not labeled `CastingTimeIndex`
its now `0` int(100)

[Equ1N0X]

try deleteing the quotes where the :castingtimeindex: was. and one of commas next to it

[djblade17]

can u show me a example of what your talking about please
this is my default

`CastingTimeIndex` int(100) default '0',

[gravestalker]

Nice this is sweet +rep