[HELP] npc problem me sql

[k00k00]

Kalhmera paides. Exw ena provlima, thelei enas filos na tou vrw kapia npc opws buffer,gk ktlp. Vriskw pu lete alla otan ta vazw mou vgazei error to sql. Exw epilogue L2JServer.

 

Paradeigma me tin buffer

 

[Err] 1054 - Unknown column 'faction_id' in 'field list'
[Err] INSERT INTO npc
   (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`, `ss`, `bss`, `ss_rate`, `AI`, `drop_herbs`)
VALUES
   (212121, 20821, 'Buffer', 1, 'Maniac Moderator', 1, 'NPC.a_casino_FDarkElf', 8.00, 20.00, 70, 'female', 'L2Npc', 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');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

To na ta valw xeirokinita nai kserw alla to na valw tosa polla idios apo gatekeeper einai sxedon adinato... einai PARA polla..

[Jayde]

To Error leei oti den uparxei to Column Faction_id st npc.table mhpws exeis parei gia allo pack -client ta npc?

[k00k00]

  On 6/8/2010 at 12:05 PM, FerikOs™ said:

To Error leei oti den uparxei to Column Faction_id st npc.table mhpws exeis parei gia allo pack -client ta npc?

Oxi gia l2jserver exw parei

[bboycrashmill]

k00k00 prosekse kai t buffer i gk evgales gt s kapia pack ta custom buffer i gatekeeper dn ta pernei

[k00k00]

ta custom npc einai enable apo to general.properties :S

 

Oriste kai ena buffer pou katevasa gia L2jServer

[Err] 1136 - Column count doesn't match value count at row 1
[Err] REPLACE INTO npc VALUES
(555555, 18544, "Buffer", 1, "Rin4a's Custom", 1, "LineageNpcEV.trap_ironcastle", 8, 24, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 278, 0, 333, 0, 0, NULL, 60, 60, "", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "true");
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

 

Ta idia vgazei...

[sakisd]

  On 6/8/2010 at 12:18 PM, k00k00 said:

ta custom npc einai enable apo to general.properties :S

 

Oriste kai ena buffer pou katevasa gia L2jServer

[Err] 1136 - Column count doesn't match value count at row 1
[Err] REPLACE INTO npc VALUES
(555555, 18544, "Buffer", 1, "Rin4a's Custom", 1, "LineageNpcEV.trap_ironcastle", 8, 24, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 278, 0, 333, 0, 0, NULL, 60, 60, "", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "true");
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

 

Ta idia vgazei...

perase to npc manual mono esti 8a kaneis douleia mporei ta teleports na min 8eloun perasma manual

twra an den pernane kai pali ta teleport tote i 8a ta peraseis manual i 8a breis pio colum fteei kai 8a to afereseis apo to sql arxeio

dld ta colum ss,bss,ai,faction id den yparxoun mesa sto table npc ston epiloge ta npc pou peires den einai gia epiloge i exoun pio palio sql arxeio

[k00k00]

vrika ena AIO npc kai entaksi kanei douleia (oxi opws to ithela alla ok) efxaristw olous gia tin voi8eia!

 

lock it please

[Papaditsa]

Prin to kaneis lock perase ta sql xeirokinita !!!! An den xereis pws des to video apo to vesper gm shop mou ;)

[LioNtaraki]

ama katebases tin buffer tou papaditsa to npc sql 212121 pernato xirokinita sto custom npc

[DemoniK®]

kai emena kapies mou to bgazei sto interlude pack alla ta pernaw xeirokinita min variese oute 1 min dn einai ... ;D

[FrozenWarrior]

  On 6/8/2010 at 11:56 AM, k00k00 said:

 

To na ta valw xeirokinita nai kserw alla to na valw tosa polla idios apo gatekeeper einai sxedon adinato... einai PARA polla..

 

liga einai rr apo to na psaxneis kai na psaxneis dn 8a pa8eis kai tpt !