L2J_CE

Вы хотите отреагировать на этот пост ? Создайте аккаунт всего в несколько кликов или войдите на форум.
L2J_CE

L2J_CE Server


Участников: 2

    Помогите с sql запросом

    plavik
    plavik
    plavik


    Сообщения : 184
    Дата регистрации : 2010-03-08
    Возраст : 32
    Откуда : Дагестан
    • Сообщение 1

    Помогите с sql запросом Empty Помогите с sql запросом

    Сообщение  plavik Ср Апр 21, 2010 7:34 pm

    Нужно залить в базу npc sql запрос забыл как ето зделать просто sql сам большой запрос
    Код:

    ('7','7','Birthday Cake','0','','0','Branch.br_xmas08_sled','13.00','13.00','85','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','0','0','0','30','132','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('11','16051','Buffer L2J Brasil','1','_::Gracia Final::_','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','20.00','70','female','L2NpcBuffer','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1004','18715','Donator Shop','1','~Gracia-Final~','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','41.00','70','female','L2Merchant','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1501','1501','Majo Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1502','1502','Gold Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1503','1503','Black Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1504','1504','Plaipitak Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1505','1505','Baby Panda Agathion','0','','0','LineageNPC2.br_agathion_bpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1506','1506','Bamboo Panda Agathion','0','','0','LineageNPC2.br_agathion_mpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1507','1507','Sexy Panda Agathion','0','','0','LineageNPC2.br_agathion_wpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1508','1508','White Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1509','1509','Dark Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1510','1510','White Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1511','1511','Black Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1512','1512','Brown Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1513','1513','One-Eyed Bat Drove Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1514','1514','Pegasus Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1515','1515','Yellow-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1516','1516','Blue-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1517','1517','Green-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1518','1518','Bugbear Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1519','1519','Red Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1520','1520','Blue Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1521','1521','Great Sumo Match Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1522','1522','Button-Eyed Bear Doll','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1523','1523','God of Fortune','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    короч надо весь sql запрос под 1 запись поставить а то 18к строчек очень нудно закидывать потипово
    INSERT INTO `npc` VALUES ('1523','1523','God of
    Fortune','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')


    Помню был запрос забыл просто уже (((
    INSERT INTO `npc` VALUES блаблабла
    и потом идет мой запрос
    Код:
    ('7','7','Birthday Cake','0','','0','Branch.br_xmas08_sled','13.00','13.00','85','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','0','0','0','30','132','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('11','16051','Buffer L2J Brasil','1','_::Gracia Final::_','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','20.00','70','female','L2NpcBuffer','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1004','18715','Donator Shop','1','~Gracia-Final~','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','41.00','70','female','L2Merchant','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1501','1501','Majo Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1502','1502','Gold Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1503','1503','Black Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1504','1504','Plaipitak Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1505','1505','Baby Panda Agathion','0','','0','LineageNPC2.br_agathion_bpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1506','1506','Bamboo Panda Agathion','0','','0','LineageNPC2.br_agathion_mpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1507','1507','Sexy Panda Agathion','0','','0','LineageNPC2.br_agathion_wpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1508','1508','White Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1509','1509','Dark Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1510','1510','White Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1511','1511','Black Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1512','1512','Brown Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1513','1513','One-Eyed Bat Drove Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1514','1514','Pegasus Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1515','1515','Yellow-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1516','1516','Blue-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1517','1517','Green-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1518','1518','Bugbear Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1519','1519','Red Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1520','1520','Blue Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1521','1521','Great Sumo Match Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1522','1522','Button-Eyed Bear Doll','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1523','1523','God of Fortune','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    помогите)
    • Вернуться к началу
    plavik
    plavik
    plavik


    Сообщения : 184
    Дата регистрации : 2010-03-08
    Возраст : 32
    Откуда : Дагестан
    • Сообщение 2

    Помогите с sql запросом Empty Re: Помогите с sql запросом

    Сообщение  plavik Чт Апр 22, 2010 12:59 am

    plavik пишет:Нужно залить в базу npc sql запрос забыл как ето зделать просто sql сам большой запрос
    Код:

    ('7','7','Birthday Cake','0','','0','Branch.br_xmas08_sled','13.00','13.00','85','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','0','0','0','30','132','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('11','16051','Buffer L2J Brasil','1','_::Gracia Final::_','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','20.00','70','female','L2NpcBuffer','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1004','18715','Donator Shop','1','~Gracia-Final~','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','41.00','70','female','L2Merchant','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1501','1501','Majo Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1502','1502','Gold Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1503','1503','Black Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1504','1504','Plaipitak Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1505','1505','Baby Panda Agathion','0','','0','LineageNPC2.br_agathion_bpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1506','1506','Bamboo Panda Agathion','0','','0','LineageNPC2.br_agathion_mpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1507','1507','Sexy Panda Agathion','0','','0','LineageNPC2.br_agathion_wpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1508','1508','White Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1509','1509','Dark Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1510','1510','White Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1511','1511','Black Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1512','1512','Brown Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1513','1513','One-Eyed Bat Drove Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1514','1514','Pegasus Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1515','1515','Yellow-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1516','1516','Blue-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1517','1517','Green-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1518','1518','Bugbear Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1519','1519','Red Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1520','1520','Blue Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1521','1521','Great Sumo Match Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1522','1522','Button-Eyed Bear Doll','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1523','1523','God of Fortune','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    короч надо весь sql запрос под 1 запись поставить а то 18к строчек очень нудно закидывать потипово
    INSERT INTO `npc` VALUES ('1523','1523','God of
    Fortune','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')


    Помню был запрос забыл просто уже (((
    INSERT INTO `npc` VALUES блаблабла
    и потом идет мой запрос
    Код:
    ('7','7','Birthday Cake','0','','0','Branch.br_xmas08_sled','13.00','13.00','85','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','0','0','0','30','132','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('11','16051','Buffer L2J Brasil','1','_::Gracia Final::_','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','20.00','70','female','L2NpcBuffer','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1004','18715','Donator Shop','1','~Gracia-Final~','1','LineageNPCsTex2.event_birth_alegria.event_birth_alegria','8.00','41.00','70','female','L2Merchant','40','3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','50','120','NULL','0','1','0','LAST_HIT','0','0','0','fighter','false')
    ('1501','1501','Majo Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1502','1502','Gold Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1503','1503','Black Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1504','1504','Plaipitak Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1505','1505','Baby Panda Agathion','0','','0','LineageNPC2.br_agathion_bpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1506','1506','Bamboo Panda Agathion','0','','0','LineageNPC2.br_agathion_mpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')('1507','1507','Sexy Panda Agathion','0','','0','LineageNPC2.br_agathion_wpanda','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1508','1508','White Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1509','1509','Dark Cupid Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1510','1510','White Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1511','1511','Black Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1512','1512','Brown Maneki Neko Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1513','1513','One-Eyed Bat Drove Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1514','1514','Pegasus Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1515','1515','Yellow-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1516','1516','Blue-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1517','1517','Green-Robed Tojigong Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1518','1518','Bugbear Agathion','0','','0','LineageNPC2.Agathion_CL','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1519','1519','Red Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1520','1520','Blue Sumo Wrestler Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1521','1521','Great Sumo Match Agathion','0','','0','Monster.pet_wolf','13.00','11.50','80','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1522','1522','Button-Eyed Bear Doll','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    ('1523','1523','God of Fortune','0','','0','Monster.pet_wolf','13.00','11.50','15','male','L2Npc','40','2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','3907','0','0','24','125','NULL','0','0','0','LAST_HIT','0','0','0','balanced','false')
    помогите)

    просмотров 230 и никто не поможет?
    • Вернуться к началу
    ArtiShok
    ArtiShok
    ArtiShok


    Сообщения : 1144
    Дата регистрации : 2010-03-10
    • Сообщение 3

    Помогите с sql запросом Empty Re: Помогите с sql запросом

    Сообщение  ArtiShok Чт Апр 22, 2010 1:23 am

    plavik пишет:

    INSERT INTO `npc` VALUES
    (1,1,'Thomas D. Turkey',0,'Misguided Holiday Scrooge',0,'Branch.br_crazy_turkey',22,32,85,'male','L2Npc',40,751,331,2.37,1.53,80,80,80,80,80,80,0,0,88,119,37,112,282,0,5000,0,0,0,30,132,'NULL',0,0,0,
    'LAST_HIT',0,0,0,'fighter','false'),
    (2,2,'',0,'',0,'Branch.br_crazy_turkey',22,32,85,'male','L2Npc',40,751,331,2.37,1.53,80,80,80,80,80,80,0,0,88,119,37,112,282,0,5000,0,0,0,30,132,'NULL',0,0,0,
    'LAST_HIT',0,0,0,'fighter','false')
    ;
    если я правильно понял то ты такое ждал
    • Вернуться к началу
    plavik
    plavik
    plavik


    Сообщения : 184
    Дата регистрации : 2010-03-08
    Возраст : 32
    Откуда : Дагестан
    • Сообщение 4

    Помогите с sql запросом Empty Re: Помогите с sql запросом

    Сообщение  plavik Чт Апр 22, 2010 1:39 am

    ArtiShok пишет:
    plavik пишет:

    INSERT INTO `npc` VALUES
    (1,1,'Thomas D. Turkey',0,'Misguided Holiday Scrooge',0,'Branch.br_crazy_turkey',22,32,85,'male','L2Npc',40,751,331,2.37,1.53,80,80,80,80,80,80,0,0,88,119,37,112,282,0,5000,0,0,0,30,132,'NULL',0,0,0,
    'LAST_HIT',0,0,0,'fighter','false'),
    (2,2,'',0,'',0,'Branch.br_crazy_turkey',22,32,85,'male','L2Npc',40,751,331,2.37,1.53,80,80,80,80,80,80,0,0,88,119,37,112,282,0,5000,0,0,0,30,132,'NULL',0,0,0,
    'LAST_HIT',0,0,0,'fighter','false')
    ;
    если я правильно понял то ты такое ждал

    ты щас имеешь виду запрос на тупо заливание базы
    а вот если у тя колонки базы переставлены или добавил колонки тогда что будешь делать?
    СУЩЕСТВУЕТ запрос Который Добавляет Чисто По колонкам Блин забыл я его (((( В Етом запросе не будут ошибки )
    • Вернуться к началу
      Текущее время Пт Окт 04, 2024 1:29 pm