Navicat

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
heaton123
Nivel 1

Nivel 1
Mesaje: 98
Membru din: 21 Feb 2015, 13:36
Server: Metin2 Cataclysm
Regat: Jinno
Aprecieri: 0
Mulţumiri: 0
Medalii

De ce nu mai pot băga query-ul in navicat...? Le fac cu mt2 Manager

Cod: Selectaţi tot

[SQL]INSERT INTO item_proto SET vnum='51510', name='Vesmant Demonic+0', locale_name='Vesmant Demonic+0', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51511', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='1000', applytype1='37', applyvalue1='10', applytype2='0', applyvalue2='0', value0='0', value1='300', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
[Err] 1062 - Duplicate entry '51510' for key 'PRIMARY'
Eroarea....

Query :

Cod: Selectaţi tot

INSERT INTO item_proto SET vnum='51510', name='Vesmant Demonic+0', locale_name='Vesmant Demonic+0', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51511', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='1000', applytype1='37', applyvalue1='10', applytype2='0', applyvalue2='0', value0='0', value1='300', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51511', name='Vesmant Demonic+1', locale_name='Vesmant Demonic+1', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51512', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='91', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='1556', applytype1='37', applyvalue1='13', applytype2='0', applyvalue2='0', value0='0', value1='338', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51512', name='Vesmant Demonic+2', locale_name='Vesmant Demonic+2', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51513', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='2111', applytype1='37', applyvalue1='16', applytype2='0', applyvalue2='0', value0='0', value1='377', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51513', name='Vesmant Demonic+3', locale_name='Vesmant Demonic+3', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51514', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='93', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='2667', applytype1='37', applyvalue1='18', applytype2='0', applyvalue2='0', value0='0', value1='416', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51514', name='Vesmant Demonic+4', locale_name='Vesmant Demonic+4', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51515', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='3222', applytype1='37', applyvalue1='21', applytype2='0', applyvalue2='0', value0='0', value1='455', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51515', name='Vesmant Demonic+5', locale_name='Vesmant Demonic+5', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51516', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='95', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='3778', applytype1='37', applyvalue1='24', applytype2='0', applyvalue2='0', value0='0', value1='494', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51516', name='Vesmant Demonic+6', locale_name='Vesmant Demonic+6', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51517', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='4333', applytype1='37', applyvalue1='27', applytype2='0', applyvalue2='0', value0='0', value1='533', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51517', name='Vesmant Demonic+7', locale_name='Vesmant Demonic+7', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51518', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='97', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='4889', applytype1='37', applyvalue1='29', applytype2='0', applyvalue2='0', value0='0', value1='572', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51518', name='Vesmant Demonic+8', locale_name='Vesmant Demonic+8', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='51519', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='5444', applytype1='37', applyvalue1='32', applytype2='0', applyvalue2='0', value0='0', value1='611', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='51519', name='Vesmant Demonic+9', locale_name='Vesmant Demonic+9', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='99', limittype1='0', limitvalue1='0', applytype0='1', applyvalue0='6000', applytype1='37', applyvalue1='35', applytype2='0', applyvalue2='0', value0='0', value1='650', value2='0', value3='51510', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
Avatar utilizator
P. Ionut
Nivel 1

Nivel 1
Mesaje: 72
Membru din: 12 Aug 2015, 12:59
Server: M2NewStar.com
Regat: Jinno
Aprecieri: 0
Mulţumiri: 1  
 Contact:
Medalii

Exista deja acest cod, inceraca sa pui alt cod
Imagine
Afișează semnătura
Avatar utilizator
KinKade
Membru Club

Membru Club
Mesaje: 1224
Membru din: 10 Mar 2014, 19:39
Server: Quirin2
Regat: Jinno
Aprecieri: 132  
Mulţumiri: 55  
Discord: Copiază ID
 Contact:
Medalii

corect exista codul dar data viitoare cand mai va da erori cititi mah baieti ce scrie acolo in eroare.
Duplicate entry '51510' oare ce o vrea sa zica ca ai prea multi mobi in server:) sau ca ai codul ala inca odata........
Discord: Koshmar#3873
Afișează semnătura
Avatar utilizator
Alex.es
Miracolul Crăciunului

Miracolul Crăciunului
Mesaje: 1283
Membru din: 26 Mar 2014, 19:05
Server: Da
Regat: Chunjo
Aprecieri: 66  
Mulţumiri: 18  
 Contact:
Medalii

Autorul nu a mai raspuns de 3 zile, arhivat.
Închis
Răspunsuri
7
Vizualizări
582
Răspunsuri
7
Vizualizări
705
Răspunsuri
0
Vizualizări
109

Înapoi la “Arhivă Probleme şi Întrebări”

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 128 vizitatori