[ncdb] Useful SQL edits

[drunk3nrabbit]

I think that It would be a good idea to have a thread that contains some useful SQL edits, not major updates, just some things to make the game play more enjoyable.

Here's to start off,

This one will remove the cooldowntime reqirement for ALL items

UPDATE `items` SET `spellcategorycooldown_1`='0';
UPDATE `items` SET `spellcategorycooldown_2`='0';
UPDATE `items` SET `spellcategorycooldown_3`='0';
UPDATE `items` SET `spellcategorycooldown_4`='0';
UPDATE `items` SET `spellcategorycooldown_5`='0';
UPDATE `items` SET `spellcooldown_1`='0';
UPDATE `items` SET `spellcooldown_2`='0';
UPDATE `items` SET `spellcooldown_3`='0';
UPDATE `items` SET `spellcooldown_4`='0';
UPDATE `items` SET `spellcooldown_5`='0';

This one will increase all stackable items to 999, while leaving non stackable items at 1

UPDATE `items`
SET `maxcount`='999'
where `maxcount`>'1';

Hope this will help some people

[MentaL]

[seg]

thank you ... usefull :D

[grandmst20]

These are geared toward fun servers. I wouldn't use these. Good ideas though man.

[drunk3nrabbit]

yeah, i run a fun server, but thanks for the support. if anyone else has some funserver updates, please share

[Kiljaden]

n00b question: how do I apply these?

[Eradicator]

n00b question: how do I apply these?

All you have to do is open Notepad, Wordpad, or your own preferred text editor. Then copy the code above, paste it into your text editor and save it as an SQL. EG. File Save As > 'stacks999.sql'. Then you need to open SQLyog, right click on your character database if you are running Ascent, or right click your mangosd database if you are running MaNGOS and click 'Restore from SQL Dump'. Navigate to the SQL file and click 'Execute'. Then restart your server and it is done.

Regards,
Krysk
<The-Eradicator>

[Kiljaden]

Thanks for explaining :flag_aust

[Eradicator]

Thanks for explaining :flag_aust

No problem at all.

PS: Your name is spelled wrong, its supposed to be Kil'jaeden. :wink_1:

Regards,
Krysk
<The-Eradicator>

[Kiljaden]

Off: I know but since the game doesn't allow me to make it Kil'jaeden I'm using the same name on forums/etc. Eredar rulez :P

[drunk3nrabbit]

if you're using sqlyog, you can just paste the code in the field in the top right and right click>execute query>exequte all queries

[seg]

This will add to every character that is created a sack of GOLD. If you sell it to a vendor you will get 100 g :D

4 FUN-SERVERS:

insert into `playercreateinfo_items` (`indexid`,`protoid`,`slotid`,`amount`) values (1,500000,0,1),(2,500000,0,1),(3,500000,0,1),(4,500000,0,1),(5,500000,0,1),(6,500000,0,1),(7,500000,0,1),(50,500000,0,1),(9,500000,0,1),(10,500000,0,1),(11,500000,0,1),(12,500000,0,1),(13,500000,0,1),(14,500000,0,1),(15,500000,0,1),(16,500000,0,1),(17,500000,0,1),(18,500000,0,1),(19,500000,0,1),(20,500000,0,1),(21,500000,0,1),(22,500000,0,1),(23,500000,0,1),(24,500000,0,1),(25,500000,0,1),(26,500000,0,1),(27,500000,0,1),(28,500000,0,1),(29,500000,0,1),(30,500000,0,1),(31,500000,0,1),(32,500000,0,1),(33,500000,0,1),(34,500000,0,1),(35,500000,0,1),(36,500000,0,1),(37,500000,0,1),(38,500000,0,1),(39,500000,0,1),(40,500000,0,1),(41,500000,0,1),(42,500000,0,1),(43,500000,0,1),(44,500000,0,1),(45,500000,0,1),(46,500000,0,1),(47,500000,0,1),(48,500000,0,1),(50,500000,0,1),(50,500000,0,1),(50,500000,0,1),(50,500000,0,1),(50,500000,0,1),(50,500000,0,1),(50,500000,0,1);