Resolved SQL help needed

[murdocmurat]

any can write me query for

i want to change level 80 to 255 on all npc

also in item template

 

[laurczt]

I suppose you want to do this to a TrinityCore 3.3.5a (or any other 3.3.5a), if so.. the query should be like this.

UPDATE `creature_template` SET `minlevel` = '255', `maxlevel` = '255' WHERE `minlevel` = '80' AND `maxlevel`  = '80';

This will update all levels of all creatures that are level 80 (all factions and all type of npcs, bosses, vendors, trainers and so on..)
This query will apply for creatures that are already spawned.

Cheers!

 

[murdocmurat]

I suppose you want to do this to a TrinityCore 3.3.5a (or any other 3.3.5a), if so.. the query should be like this.

UPDATE `creature_template` SET `minlevel` = '255', `maxlevel` = '255' WHERE `minlevel` = '80' AND `maxlevel`  = '80';

This will update all levels of all creatures that are level 80 (all factions and all type of npcs, bosses, vendors, trainers and so on..)
This query will apply for creatures that are already spawned.

Cheers!

Thanks buddy

 

[laurczt]

Thanks buddy

You welcome

 

[Instadev]

Chatgpt

 

[Kearu]

any can write me query for

i want to change level 80 to 255 on all npc

also in item template

If you haven’t gotten the item_template changed

UPDATE `item_template` SET `RequiredLevel` = '255' WHERE `RequiredLevel` = '80'

 

[murdocmurat]

If you haven’t gotten the item_template changed

UPDATE `item_template` SET `RequiredLevel` = '255' WHERE `RequiredLevel` = '80'

ok mate