[Trinity] Merge sql file to Trinity. ( read ) menu

User Tag List

Results 1 to 3 of 3
  1. #1
    Hyldran0's Avatar Contributor
    Reputation
    118
    Join Date
    Nov 2008
    Posts
    374
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Trinity] Merge sql file to Trinity. ( read )

    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~
    Last edited by Hyldran0; 02-08-2012 at 02:59 PM.
    Shit's Gone Real

    [Trinity] Merge sql file to Trinity. ( read )
  2. #2
    Thunderofnl's Avatar Elite User C# / Java / PHP Programmer
    Authenticator enabled
    Reputation
    491
    Join Date
    May 2008
    Posts
    1,033
    Thanks G/R
    20/20
    Trade Feedback
    6 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Could you tell us the error you get when Importing?

  3. #3
    Hyldran0's Avatar Contributor
    Reputation
    118
    Join Date
    Nov 2008
    Posts
    374
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Error Msg Added..

    Edit: problem Solved!
    Thanks anyways!

    ~Hyldran0~
    Last edited by Hyldran0; 02-08-2012 at 03:15 PM.
    Shit's Gone Real

Similar Threads

  1. Command To Merge SQL Files?
    By Ickybad in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 06-13-2008, 06:11 PM
  2. Executing multiple SQL files at once
    By roguesownu in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 10-21-2007, 07:51 AM
  3. SQL file not working help please
    By n7e7b7 in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 09-22-2007, 10:40 PM
  4. Exporting custom vendor to a sql file?
    By Seldom in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 09-04-2007, 03:19 PM
  5. Requesting Lots Of New Weapons And Armor In Sql Files :p
    By heijheija in forum WoW ME Questions and Requests
    Replies: 1
    Last Post: 08-25-2007, 06:10 PM
All times are GMT -5. The time now is 06:18 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search