Remove NPC

[3xpl0it3R]

Einai ligo xazos to titlos sto topic mou alla exw ena problhma.Ebala enan buffer sthn db mou,alla twra 8elw na ton bgalw.Dld 8elw na ton bgalw gia na balw enan allo buffer.An mporei kapios na me help 8a htan kalo.

 

PS: Otan exw kanei execute enan buffer mporw na balw akoma enan ?  .Gt ebala enan tou Oneo Dev Team kai otan ei8ela na balw enan allo den mporousa.

[A-error]

file o allos sto sql pou 8eleis na peraseis einai me to idio id pou kaneis spawn tin buffer sou ?

an nai tote mporeis na kaneis  allo..

[3xpl0it3R]

Nai exoun to idio ID.Ti prepei na kanw ?.Prepei na allaksw tpt sto sql file ? gt to anoiksa kai eixe kapia ID 40006 kai 30003 .Na alaksw afta ta ID se ena eleu8ero npc ID ?  

[A-error]

oxi mporeis na peraseis ma fou kai i 2npc exoun to idio sql 40006 mporeis na peraseis kai to html tou buffer tou kainourio kai custom 9999_npcbuffer den 8a exeis kanena problima

[3xpl0it3R]

Ok.Alla to sql den mporw na to perasw.Alla thx gia to help sou.

 

 

Afto to error exw  :

 

[Err] 1136 - Column count doesn't match value count at row 1

[Err] INSERT INTO `npc` VALUES ('40006', '31207', 'Buffer', '1', 'NPC', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'Male', 'L2Npc', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0', 'LAST_HIT');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

[ghostblader]

An dn kano la8os ayto to prob dn exei na kanei me diplo id!an eixes diplo id 8a s elege duplicate entry kai kati tetoia!mallon einai error symvatothtas me tn db!alla mias kai anafer8hke na to sql gia delete:  DELETE FROM npc WHERE id = [edo to id tou npc];

Elpizo na voi8hsa ligaki!

[3xpl0it3R]

Eeeeeee.Den mou lei tpt tetio.Ekoma kai an kanw execute to idio sql, mou bgazei to error pou ebala sto proigoumeno mou post.

 

PS: Otan paw sto Custom_Npc table sto navicat, den mou exei ton buffer.

 

PS 2  : Exw kai ena problhma me to python to buffer mou.Otan to kanw spawn kai paw na parw buffs, mou bgazei auto to error sto Game Server : Emmmm.Den brhka to problhma alla kati mou ebgaze.Merikes fores doulebei o buffer merikes fores oxi.To python to eixa kanei edit kai ebala kati pou eixe pei enas se ena stick guide.

 

PS 3  : Otan les afto to DELETE FROM npc WHERE id =      ..  pou na to balw afto ?  se ena txt arxeio kai meta na to kanw sql kai meta execute  ?

[ghostblader]

Eeeeeee.Den mou lei tpt tetio.Ekoma kai an kanw execute to idio sql, mou bgazei to error pou ebala sto proigoumeno mou post.

 

PS: Otan paw sto Custom_Npc table sto navicat, den mou exei ton buffer.

 

PS 2  : Exw kai ena problhma me to python to buffer mou.Otan to kanw spawn kai paw na parw buffs, mou bgazei auto to error sto Game Server : Emmmm.Den brhka to problhma alla kati mou ebgaze.Merikes fores doulebei o buffer merikes fores oxi.To python to eixa kanei edit kai ebala kati pou eixe pei enas se ena stick guide.

 

PS 3  : Otan les afto to DELETE FROM npc WHERE id =      ..  pou na to balw afto ?  se ena txt arxeio kai meta na to kanw sql kai meta execute  ?

I kaneis paste ayto p s esteila se txt kai meta save as SQL i patas sto navicat query kai kaneis execute apo kei;)Elpizo na voi8hsa

[3xpl0it3R]

Ok thx ghostblader gia to help sou.

 

 

 

To problhma li8ike.Kapios moderator na to lock.