aso ja das hab ich ned gewusst aba danke

ich hab das gefühl das ich denn für 2.4.3 gemacht hab
weil jz hat er selben error mit flag1

kannst du mir vll helfen bis der für 3.0.3 is? weil dann weiß ich wie ich die umbenennen muss und dann muss ich hier im forum auch nima nerven

also hier ist das sript:

REPLACE INTO creature_template
(`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`)
VALUES
(899996, 0, 25951, 25951, 25951, 25951, 'Gewand Verkaeufer', ' Server Vendor', '', 100, 100, 100000, 100000, 100000, 100000, 1, 35, 35, 3968, 1.15, 0, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 0, 1, 0, '');

cool danke aba jz is iwas mit der lootid???

[Err] 1264 - Out of range value for column 'lootid' at row 1
[Err] REPLACE INTO creature_template
(`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`)
VALUES
(899996, 0, 25951, 25951, 25951, 25951, 'Gewand Verkaeufer', ' Server Vendor', '', 100, 100, 100000, 100000, 100000, 100000, 1, 35, 35, 3968, 1.15, 0, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 0, 1, 0, '');