Programmers: I need a program to convert my NPC Types to new

[Ariak]

OLD
INSERT INTO npc_types VALUES (6039,'a_shambling_cube',55,184,1,0,2,2,2,25,0,0,0 ,0,0,0,'','',0,0,0,1,1,1,1,1);


NEW
INSERT INTO npc_types VALUES (6039,'a_shambling_cube',55,184,1,0,2,2,2,25,0,0,0 ,0,0,0,'','',0,0,0,1,1,1,1,1,0,0,0,0,0);

Basically, before the ); it adds the following:
,0,0,0,0,0 and then the );

Sooner I get one, the sooner I can release a working 0.3.1.1+ db

[Lurker_005]

For text editing I use www.ultraedit.com there are many others, but the mail thing is a good search/replace! In this case search for ); and replace with 0,0,0,0,0); and it is all done. that one is easy since ); only occurs once per line.

[Ariak]

Thanks man!