[Odigos] Pws Na Perasoume Ena .SQL Arxeio Xeirokinita + Eikones

[ExCaLiBuR®]

Geia se ola ta members tou mxc

eipa na ftiaksw auton ton odigo giati se kapoia Npc pou theloume na perasoume ston server mas sto Execute SQL File mas bgazei Error

auto den simainei omws oti to .SQL arxeio einai gia petama

polu apla to pairname xeirokinita kai tote tha douleuei. Ithela na perasw auto edwpera to NPC NPC

kai epeidi sto execute sql file me ebgale error to perasa xeirokinita kai doulepse (se kapoious mporei na bgazei error se kapoious omws oxi)

kai epeidi mporei na bgazei kai se alous error kai den kseroun pws na to pairasoun xeirokinita eipa na ftiaksw ton odigo

 

as arxisoume lupon

 

anoigoume to navicat meta to localhost meta pame sto l2jdb tables kai meta sto npc

 

 

afou patisoume ekei tha mas anoiksei ena kainourio parathuro katw katw exei ena + Insert record legete

 

 

afou patisoume kai sto insert record terma epanw sto parathuro pou exoume anoikto tha mas bgalei mia kainouria sura

 

tha einai etsi

 

 

afou kanoume ta pragmata pou lew parapanw anoigoume to .SQL arxeio me to notepad

 

 

afou anoksoume kai to .SQL arxeio tha exoume 2 parathura anoikta to ena to table npc kai to sql anoigmeno me to notepad

ta kanoume opws mas boleuoun stin epeifania ergasias kai arxeizoume na to pairname

 

http://i54.tinypic.com/wtxhtj.png[/img]

 

kanoume auto edwpera mexri telos

 

afou teleiwsoume patame to Update record

 

http://i54.tinypic.com/152fcxd.png[/img]

 

auto eitan exoume teleiwsei

den einai tpt to duskolo apla kapoia kainouria members mporei na min kseroun isws na tous boeithisw me auton ton odigo

 

xrusimoipoieisa to npc tou BloodDevil

 

o sigkekrimenos odigos den einai mono gia to npc tou BloodDevil einai gia otidipote npc sto opoio mas bgazei Error sto execute sql file

 

credits DragonGr ( me )

 

 

tha ftiaksw kai 1 videaki na balw otan exw xrono

 

 

 

[TheVip]

Brabo file mou polh oreo! kai pollh analathko :D shnexhse etsi :D

[ExCaLiBuR®]

Brabo file mou polh oreo! kai pollh analathko :D shnexhse etsi :D

ty file mou

[Sinova™]

poly swstos file m :)

sinexise etc gia na kratisoume to forum anoixto kai zwntano :)

episis 8a i8ela na pros8esw oti 8a mporouses na kanes edit to title, kai na valeis kai ton aytomato tropo, select db, right-click, execute batch file.

pali well done k kali sinexeia ;)

[ExCaLiBuR®]

poly swstos file m :)

sinexise etc gia na kratisoume to forum anoixto kai zwntano :)

episis 8a i8ela na pros8esw oti 8a mporouses na kanes edit to title, kai na valeis kai ton aytomato tropo, select db, right-click, execute batch file.

pali well done k kali sinexeia ;)

ama to diabaseis olo tha katalabeis oti se merikous to execute sql file den douleuei se olous

kai bgazei kapoios error

 

thanks pantos