Anyone help me out?

[zeil]

how would i do this....

Make a query which Moves all NPCs with flag 5 from map ID: 5 to map ID: 10

anyone show me in pastebin? ill rep+2

[stoneharry]

Always back up your database before testing these queries in case you screw it up.

UPDATE `creature_spawns` SET `map` = '10' WHERE `map` = '5' AND `flags` = '5';

Assuming you mean NPC flags and not creature flags:

UPDATE `creature_spawns` SET `map` = '10' WHERE `map` = '5' AND `entry` IN (SELECT `entry` FROM `creature_proto` WHERE `npcflags` = '5');

You may want to update X,Y,Z before the map (otherwise they will appear somewhere not on the map most likely).

Restart your server for changes to take effect.