Hello,
I have to sql files that i wanna merge to latest trinity.
I don't realy know how to do it.
I'v make them on WoW-V.com ( Trinity ).
But it seems like it's outdated...
Number 1:
Code:
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`) VALUES
('50500','41630','0'),
('50500','41617','0'),
('50500','41832','0'),
('50500','41898','0'),
('50500','41881','0'),
('50500','40976','0'),
('50500','40881','0'),
('50500','41070','0'),
('50500','41051','0'),
('50500','41235','0'),
('50500','41640','0'),
('50500','41625','0'),
('50500','41840','0'),
('50500','40983','0'),
('50500','40889','0'),
('50500','41909','0'),
('50500','41893','0'),
('50500','41065','0'),
('50500','41060','0'),
('50500','41225','0'),
('50500','41635','0'),
('50500','41621','0'),
('50500','41836','0'),
('50500','40977','0'),
('50500','40882','0'),
('50500','41075','0'),
('50500','41055','0'),
('50500','41230','0'),
('50500','41903','0'),
('50500','41885','0'),
('50500','42071','0'),
('50500','42073','0'),
('50500','42069','0'),
('50500','42072','0'),
('50500','42070','0'),
('50500','42074','0'),
('50500','42075','0'),
('50500','42037','0'),
('50500','42039','0'),
('50500','42036','0'),
('50500','42040','0'),
('50500','42038','0'),
('50500','46373','0'),
('50500','42034','0'),
('50500','42035','0'),
('50500','42116','0'),
('50500','42117','0'),
('50500','42589','0'),
('50500','42584','0'),
('50500','42579','0'),
('50500','42853','0'),
('50500','42615','0'),
('50500','42621','0'),
('50500','42608','0'),
('50500','42603','0'),
('50500','42598','0');
Number 2:
Code:
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`) VALUES
('50501','45954','0'),
('50501','45950','0'),
('50501','45953','0'),
('50501','45949','0'),
('50501','45961','0'),
('50501','45962','0'),
('50501','45967','0'),
('50501','45969','0'),
('50501','45952','0'),
('50501','45951','0'),
('50501','45957','0'),
('50501','45968','0'),
('50501','45963','0'),
('50501','45956','0'),
('50501','45960','0'),
('50501','45970','0'),
('50501','45964','0'),
('50501','45938','0'),
('50501','45939','0'),
('50501','45971','0'),
('50501','45937','0'),
('50501','45955','0'),
('50501','45958','0'),
('50501','45966','0'),
('50501','45948','0'),
('50501','45965','0'),
('50501','45959','0'),
('50501','49666','0'),
('50501','42514','0'),
('50501','42364','0'),
('50501','42281','0'),
('50501','42323','0'),
('50501','42233','0'),
('50501','42209','0'),
('50501','42318','0'),
('50501','42385','0'),
('50501','44422','0'),
('50501','42353','0'),
('50501','42333','0'),
('50501','42228','0'),
('50501','42496','0'),
('50501','42266','0'),
('50501','42271','0'),
('50501','42491','0'),
('50501','42256','0'),
('50501','42520','0'),
('50501','42328','0'),
('50501','42276','0'),
('50501','42291','0'),
('50501','42486','0'),
('50501','42261','0'),
('50501','42243','0'),
('50501','42249','0'),
('50501','42286','0'),
('50501','42347','0'),
('50501','42391','0'),
('50501','42503','0'),
('50501','42451','0'),
('50501','44421','0'),
('50501','42238','0'),
('50501','42565','0'),
('50501','42571','0'),
('50501','42560','0'),
('50501','42526','0'),
('50501','42538','0'),
('50501','42532','0');
Error:
Code:
[Err] 1062 - Duplicate entry '50500-41630-0' for key 'PRIMARY'
[Err] INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`) VALUES
it would be really nice! Thanks
~Hyldran0~