[GHID] Implementare armuri posedate

Ghiduri şi tutoriale despre cum să vă îmbunătăţiţi serverul/clientul dv. de metin2.
Avatar utilizator
CRONE
Fost Moderator

Fost Moderator
Mesaje: 1043
Membru din: 06 Aug 2013, 21:02
Aprecieri: 5  
Mulţumiri: 158  
Discord: Copiază ID
 Contact:
Medalii

Salutare!
In tutorialul de mai jos veti afla cum sa implementati celebrele armuri posedate pe propriul vostru server.

Sa incepem:
Pentru inceput deschideti Navicat > player > item_proto

Apasati ctr +q
Iar acolo adaugati urmatoarele coduri:

Cod: Selectaţi tot

INSERT INTO item_proto VALUES ('11310', 0x41726D7572C3A320706F7365646174C3A32B30, 0x41726D7572C3A320706F7365646174C3A32B30, '2', '0', '0', '2', '312', '1', '1', '', '120000', '120000', '11311', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '100', '0', '144', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11311', 0x41726D7572C3A320706F7365646174C3A32B31, 0x41726D7572C3A320706F7365646174C3A32B31, '2', '0', '0', '2', '312', '1', '1', '', '120000', '130000', '11312', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '200', '0', '154', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11312', 0x41726D7572C3A320706F7365646174C3A32B32, 0x41726D7572C3A320706F7365646174C3A32B32, '2', '0', '0', '2', '312', '1', '1', '', '120000', '145000', '11313', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '300', '0', '164', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11313', 0x41726D7572C3A320706F7365646174C3A32B33, 0x41726D7572C3A320706F7365646174C3A32B33, '2', '0', '0', '2', '312', '1', '1', '', '120000', '165000', '11314', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '600', '0', '174', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11314', 0x41726D7572C3A320706F7365646174C3A32B34, 0x41726D7572C3A320706F7365646174C3A32B34, '2', '0', '0', '2', '312', '1', '1', '', '120000', '190000', '11315', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '1200', '0', '184', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
    INSERT INTO item_proto VALUES ('11315', 0x41726D7572C3A320706F7365646174C3A32B35, 0x41726D7572C3A320706F7365646174C3A32B35, '2', '0', '0', '2', '312', '1', '1', '', '120000', '220000', '11316', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '1400', '0', '194', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
    INSERT INTO item_proto VALUES ('11316', 0x41726D7572C3A320706F7365646174C3A32B36, 0x41726D7572C3A320706F7365646174C3A32B36, '2', '0', '0', '2', '312', '1', '1', '', '120000', '265000', '11317', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '1600', '0', '204', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
    INSERT INTO item_proto VALUES ('11317', 0x41726D7572C3A320706F7365646174C3A32B37, 0x41726D7572C3A320706F7365646174C3A32B37, '2', '0', '0', '2', '312', '1', '1', '', '120000', '325000', '11318', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '2000', '0', '224', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
    INSERT INTO item_proto VALUES ('11318', 0x41726D7572C3A320706F7365646174C3A32B38, 0x41726D7572C3A320706F7365646174C3A32B38, '2', '0', '0', '2', '312', '1', '1', '', '120000', '405000', '11319', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '24', '1', '2500', '0', '234', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
    INSERT INTO item_proto VALUES ('11319', 0x41726D7572C3A320706F7365646174C3A32B39, 0x41726D7572C3A320706F7365646174C3A32B39, '2', '0', '0', '2', '312', '1', '1', '', '120000', '515000', '11978', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '30', '1', '3000', '0', '250', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1');
    INSERT INTO item_proto VALUES ('11510', 0x436F7374756D20706F73656461742B30, 0x436F7374756D20706F73656461742B30, '2', '0', '0', '2', '308', '1', '1', '', '120000', '120000', '11511', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '100', '0', '144', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11511', 0x436F7374756D20706F73656461742B31, 0x436F7374756D20706F73656461742B31, '2', '0', '0', '2', '308', '1', '1', '', '120000', '130000', '11512', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '200', '0', '154', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11512', 0x436F7374756D20706F73656461742B32, 0x436F7374756D20706F73656461742B32, '2', '0', '0', '2', '308', '1', '1', '', '120000', '145000', '11513', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '300', '0', '164', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11513', 0x436F7374756D20706F73656461742B33, 0x436F7374756D20706F73656461742B33, '2', '0', '0', '2', '308', '1', '1', '', '120000', '165000', '11514', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '600', '0', '174', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11514', 0x436F7374756D20706F73656461742B34, 0x436F7374756D20706F73656461742B34, '2', '0', '0', '2', '308', '1', '1', '', '120000', '190000', '11515', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '1200', '0', '184', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
    INSERT INTO item_proto VALUES ('11515', 0x436F7374756D20706F73656461742B35, 0x436F7374756D20706F73656461742B35, '2', '0', '0', '2', '308', '1', '1', '', '120000', '220000', '11516', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '1400', '0', '194', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
    INSERT INTO item_proto VALUES ('11516', 0x436F7374756D20706F73656461742B36, 0x436F7374756D20706F73656461742B36, '2', '0', '0', '2', '308', '1', '1', '', '120000', '265000', '11517', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '1600', '0', '204', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
    INSERT INTO item_proto VALUES ('11517', 0x436F7374756D20706F73656461742B37, 0x436F7374756D20706F73656461742B37, '2', '0', '0', '2', '308', '1', '1', '', '120000', '325000', '11518', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '2000', '0', '224', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
    INSERT INTO item_proto VALUES ('11518', 0x436F7374756D20706F73656461742B38, 0x436F7374756D20706F73656461742B38, '2', '0', '0', '2', '308', '1', '1', '', '120000', '405000', '11519', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '24', '1', '2500', '0', '234', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
    INSERT INTO item_proto VALUES ('11519', 0x436F7374756D20706F73656461742B39, 0x436F7374756D20706F73656461742B39, '2', '0', '0', '2', '308', '1', '1', '', '120000', '515000', '11979', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '30', '1', '3000', '0', '250', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1');
    INSERT INTO item_proto VALUES ('11710', 0x506C61746F73C3A320706F7365646174C3A32B30, 0x506C61746F73C3A320706F7365646174C3A32B30, '2', '0', '0', '2', '300', '1', '1', '', '120000', '120000', '11711', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '100', '0', '144', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11711', 0x506C61746F73C3A320706F7365646174C3A32B31, 0x506C61746F73C3A320706F7365646174C3A32B31, '2', '0', '0', '2', '300', '1', '1', '', '120000', '130000', '11712', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '200', '0', '154', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11712', 0x506C61746F73C3A320706F7365646174C3A32B32, 0x506C61746F73C3A320706F7365646174C3A32B32, '2', '0', '0', '2', '300', '1', '1', '', '120000', '145000', '11713', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '300', '0', '164', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11713', 0x506C61746F73C3A320706F7365646174C3A32B33, 0x506C61746F73C3A320706F7365646174C3A32B33, '2', '0', '0', '2', '300', '1', '1', '', '120000', '165000', '11714', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '600', '0', '174', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('11714', 0x506C61746F73C3A320706F7365646174C3A32B34, 0x506C61746F73C3A320706F7365646174C3A32B34, '2', '0', '0', '2', '300', '1', '1', '', '120000', '190000', '11715', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '1200', '0', '184', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
    INSERT INTO item_proto VALUES ('11715', 0x506C61746F73C3A320706F7365646174C3A32B35, 0x506C61746F73C3A320706F7365646174C3A32B35, '2', '0', '0', '2', '300', '1', '1', '', '120000', '220000', '11716', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '1400', '0', '194', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
    INSERT INTO item_proto VALUES ('11716', 0x506C61746F73C3A320706F7365646174C3A32B36, 0x506C61746F73C3A320706F7365646174C3A32B36, '2', '0', '0', '2', '300', '1', '1', '', '120000', '265000', '11717', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '1600', '0', '204', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
    INSERT INTO item_proto VALUES ('11717', 0x506C61746F73C3A320706F7365646174C3A32B37, 0x506C61746F73C3A320706F7365646174C3A32B37, '2', '0', '0', '2', '300', '1', '1', '', '120000', '325000', '11718', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '2000', '0', '224', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
    INSERT INTO item_proto VALUES ('11718', 0x506C61746F73C3A320706F7365646174C3A32B38, 0x506C61746F73C3A320706F7365646174C3A32B38, '2', '0', '0', '2', '300', '1', '1', '', '120000', '405000', '11719', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '24', '1', '2500', '0', '234', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
    INSERT INTO item_proto VALUES ('11719', 0x506C61746F73C3A320706F7365646174C3A32B39, 0x506C61746F73C3A320706F7365646174C3A32B39, '2', '0', '0', '2', '300', '1', '1', '', '120000', '515000', '11981', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '30', '1', '3000', '0', '250', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1');
    INSERT INTO item_proto VALUES ('12010', 0x5665736DC3A26E7420706F73656461742B30, 0x5665736DC3A26E7420706F73656461742B30, '2', '0', '0', '2', '284', '1', '1', '', '120000', '120000', '12011', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '100', '0', '144', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('12011', 0x5665736DC3A26E7420706F73656461742B31, 0x5665736DC3A26E7420706F73656461742B31, '2', '0', '0', '2', '284', '1', '1', '', '120000', '130000', '12012', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '200', '0', '154', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('12012', 0x5665736DC3A26E7420706F73656461742B32, 0x5665736DC3A26E7420706F73656461742B32, '2', '0', '0', '2', '284', '1', '1', '', '120000', '145000', '12013', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '300', '0', '164', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('12013', 0x5665736DC3A26E7420706F73656461742B33, 0x5665736DC3A26E7420706F73656461742B33, '2', '0', '0', '2', '284', '1', '1', '', '120000', '165000', '12014', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '600', '0', '174', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
    INSERT INTO item_proto VALUES ('12014', 0x5665736DC3A26E7420706F73656461742B34, 0x5665736DC3A26E7420706F73656461742B34, '2', '0', '0', '2', '284', '1', '1', '', '120000', '190000', '12015', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '1200', '0', '184', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
    INSERT INTO item_proto VALUES ('12015', 0x5665736DC3A26E7420706F73656461742B35, 0x5665736DC3A26E7420706F73656461742B35, '2', '0', '0', '2', '284', '1', '1', '', '120000', '220000', '12016', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '1400', '0', '194', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
    INSERT INTO item_proto VALUES ('12016', 0x5665736DC3A26E7420706F73656461742B36, 0x5665736DC3A26E7420706F73656461742B36, '2', '0', '0', '2', '284', '1', '1', '', '120000', '265000', '12017', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '1600', '0', '204', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
    INSERT INTO item_proto VALUES ('12017', 0x5665736DC3A26E7420706F73656461742B37, 0x5665736DC3A26E7420706F73656461742B37, '2', '0', '0', '2', '284', '1', '1', '', '120000', '325000', '12018', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '2000', '0', '224', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
    INSERT INTO item_proto VALUES ('12018', 0x5665736DC3A26E7420706F73656461742B38, 0x5665736DC3A26E7420706F73656461742B38, '2', '0', '0', '2', '284', '1', '1', '', '120000', '405000', '12019', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '24', '1', '2500', '0', '234', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
    INSERT INTO item_proto VALUES ('12019', 0x5665736DC3A26E7420706F73656461742B39, 0x5665736DC3A26E7420706F73656461742B39, '2', '0', '0', '2', '284', '1', '1', '', '120000', '515000', '11982', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '30', '1', '3000', '0', '250', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1'); 
Apoi ctr +n save!

Codurile pentru posedate sunt urmatoarele:

Cod: Selectaţi tot

11319
    11519
    11719
    12019 
Atentie ! Aceasta este doar partea de server.
Avatar utilizator
Floryn266
Nivel 1

Nivel 1
Mesaje: 98
Membru din: 02 Feb 2014, 05:09
Server: Server propriu
Regat: Jinno
Aprecieri: 1  
Mulţumiri: 0
Medalii

Cruel scrie:ghidul are 5ani , oricum bravo:D

Cod: Selectaţi tot

[SQL] 
INSERT INTO item_proto VALUES ('11310', 0x41726D7572C3A320706F7365646174C3A32B30, 0x41726D7572C3A320706F7365646174C3A32B30, '2', '0', '0', '2', '312', '1', '1', '', '120000', '120000', '11311', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '100', '0', '144', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
[Err] 1062 - Duplicate entry '11310' for key 1

cum rezolv asta? sau nu e eroare ... am mai incercat o data
bag codu la pose in joc si imi apar invizibile in inventar
Ultima oară modificat 16 Mar 2016, 04:23 de către Stefan, modificat 1 dată în total.
Motiv: aranjat in code
Imagine
Respecta si vei fi Respectat!!!
Afișează semnătura
Avatar utilizator
[Cruel]
Utilizator interzis !

Utilizator interzis !
Mesaje: 250
Membru din: 13 Ian 2014, 14:14
Server: FreakzMetin2
Regat: Jinno
Aprecieri: 0
Mulţumiri: 2  
 Contact:
Medalii

Floryn266 scrie:
Cruel scrie:ghidul are 5ani , oricum bravo:D
[SQL]
INSERT INTO item_proto VALUES ('11310', 0x41726D7572C3A320706F7365646174C3A32B30, 0x41726D7572C3A320706F7365646174C3A32B30, '2', '0', '0', '2', '312', '1', '1', '', '120000', '120000', '11311', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '100', '0', '144', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
[Err] 1062 - Duplicate entry '11310' for key 1


cum rezolv asta? sau nu e eroare ... am mai incercat o data
bag codu la pose in joc si imi apar invizibile in inventar
In eroare spune ca itemul este deja implementat in baza de date.
Eroarea cu nu se vad e de la client.
Imagine
Yahoo Messenger| Afiseaza codul
dead.cruell
Afișează semnătura
Răspunde
Răspunsuri
4
Vizualizări
1003
Răspunsuri
1
Vizualizări
233
Răspunsuri
20
Vizualizări
14330
Răspunsuri
3
Vizualizări
561

Înapoi la “Ghiduri şi Tutoriale”

  • Informaţie
  • Cine este conectat

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