통합트레이너 추가 구문인데요 먼가 잘못됫다고 저장이 안되네요

Go down

통합트레이너 추가 구문인데요 먼가 잘못됫다고 저장이 안되네요

올리기 by ssessd on 2008-12-01, 6:20 pm

INSERT INTO trainer_spells (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES
(400010, 1847, 10000, 0, 0, 0, 0, 0, 0),
(400010, 2020, 1000, 0, 0, 0, 0, 0, 0),
(400010, 2021, 10000, 0, 164, 50, 0, 0, 0),
(400010, 2154, 10000, 0, 165, 50, 0, 0, 0),
(400010, 2155, 1000, 0, 0, 0, 0, 0, 0),
(400010, 2275, 1000, 0, 0, 0, 0, 0, 0),
(400010, 2280, 10000, 0, 171, 50, 0, 0, 0),
(400010, 2372, 1000, 0, 0, 0, 0, 0, 0),
(400010, 2373, 10000, 0, 182, 50, 0, 0, 0),
(400010, 2551, 1000, 0, 0, 0, 0, 0, 0),
(400010, 2552, 25000, 0, 185, 125, 0, 0, 0),
(400010, 2581, 1000, 0, 0, 0, 0, 0, 0),
(400010, 2582, 10000, 0, 186, 50, 0, 0, 0),
(400010, 3279, 1000, 0, 0, 0, 0, 0, 0),
(400010, 3280, 10000, 0, 129, 50, 0, 0, 0),
(400010, 3412, 10000, 0, 185, 50, 0, 0, 0),
(400010, 3465, 25000, 0, 171, 125, 0, 0, 0),
(400010, 3539, 25000, 0, 164, 125, 0, 0, 0),
(400010, 3568, 25000, 0, 186, 125, 0, 0, 0),
(400010, 3571, 25000, 0, 182, 125, 0, 0, 0),
(400010, 3812, 25000, 0, 165, 125, 0, 0, 0),
(400010, 3911, 1000, 0, 0, 0, 0, 0, 0),
(400010, 3912, 10000, 0, 197, 50, 0, 0, 0),
(400010, 3913, 25000, 0, 197, 125, 0, 0, 0),
(400010, 4039, 1000, 0, 0, 0, 0, 0, 0),
(400010, 4040, 10000, 0, 202, 50, 0, 0, 0),
(400010, 4041, 25000, 0, 202, 125, 0, 0, 0),
(400010, 7414, 1000, 0, 0, 0, 0, 0, 0),
(400010, 7415, 10000, 0, 333, 50, 0, 0, 0),
(400010, 7416, 25000, 0, 333, 125, 0, 0, 0),
(400010, 7733, 1000, 0, 0, 0, 0, 0, 0),
(400010, 7734, 10000, 0, 356, 50, 0, 0, 0),
(400010, 7736, 25000, 0, 356, 125, 0, 0, 0),
(400010, 7925, 25000, 0, 129, 125, 0, 0, 0),
(400010, 8615, 1000, 0, 0, 0, 0, 0, 0),
(400010, 8619, 10000, 0, 393, 50, 0, 0, 0),
(400010, 8620, 25000, 0, 393, 125, 0, 0, 0),
(400010, 9786, 50000, 0, 164, 200, 0, 0, 0),
(400010, 10249, 50000, 0, 186, 200, 0, 0, 0),
(400010, 10663, 50000, 0, 165, 200, 0, 0, 0),
(400010, 10769, 50000, 0, 393, 200, 0, 0, 0),
(400010, 10847, 50000, 0, 129, 200, 0, 0, 0),
(400010, 11612, 50000, 0, 171, 200, 0, 0, 0),
(400010, 11994, 50000, 0, 182, 200, 0, 0, 0),
(400010, 12181, 50000, 0, 197, 200, 0, 0, 0),
(400010, 12657, 50000, 0, 202, 200, 0, 0, 0),
(400010, 13921, 50000, 0, 333, 200, 0, 0, 0),
(400010, 15983, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15984, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15985, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15986, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15987, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15988, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15989, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15991, 25000, 0, 0, 0, 0, 0, 0),
(400010, 15992, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15994, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15995, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15996, 10000, 0, 0, 0, 0, 0, 0),
(400010, 15997, 10000, 0, 0, 0, 0, 0, 0),
(400010, 18249, 50000, 0, 356, 200, 0, 0, 0),
(400010, 18261, 50000, 0, 185, 200, 0, 0, 0),
(400010, 25245, 1000, 0, 0, 0, 0, 0, 0),
(400010, 25246, 10000, 0, 755, 50, 0, 0, 0),
(400010, 26791, 100000, 0, 197, 275, 0, 0, 0),
(400010, 27029, 100000, 0, 129, 275, 0, 0, 0),
(400010, 28030, 100000, 0, 333, 275, 0, 0, 0),
(400010, 28597, 100000, 0, 171, 275, 0, 0, 0),
(400010, 28696, 100000, 0, 182, 275, 0, 0, 0),
(400010, 28896, 25000, 0, 755, 125, 0, 0, 0),
(400010, 28899, 50000, 0, 755, 200, 0, 0, 0),
(400010, 28901, 100000, 0, 755, 275, 0, 0, 0),
(400010, 29355, 100000, 0, 186, 275, 0, 0, 0),
(400010, 29845, 100000, 0, 164, 275, 0, 0, 0),
(400010, 30351, 100000, 0, 202, 275, 0, 0, 0),
(400010, 32550, 100000, 0, 165, 275, 0, 0, 0),
(400010, 32679, 100000, 0, 393, 275, 0, 0, 0),
(400010, 33100, 100000, 0, 356, 275, 0, 0, 0),
(400010, 33361, 100000, 0, 185, 275, 0, 0, 0),
(400010, 33389, 900000, 0, 0, 0, 0, 0, 0),
(400010, 33392, 6000000, 0, 762, 50, 0, 0, 0),
(400010, 34092, 8000000, 0, 762, 125, 0, 0, 0),
(400010, 34093, 50000000, 0, 762, 200, 0, 0, 0);

SQLite Error 1 - near ","; syntax error

이게 뜨는데요 무슨말인지 ;;

그리고 긴 구문같은거 검사하는 프로그램은 없을까요?

ssessd

게시물 갯수 : 12
Registration date : 2008-11-18

사용자 정보 보기

위로 Go down

Re: 통합트레이너 추가 구문인데요 먼가 잘못됫다고 저장이 안되네요

올리기 by arcemu.aio on 2008-12-01, 6:33 pm

ArcEmu-AIO에서 사용하고 있는 SQLite3 DB 엔진은 다중 INSERT 쿼리를 지원하지 않습니다.
, 로 구분된 복수의 괄호를 전부 잘라낸 다음 앞부분에 INSERT INTO ~ VALUES 까지를 붙여주시고, 뒷부분에 ; 붙여주시면 됩니다.
그리고 `` 로 구분된 필드명의 경우 `` 를 삭제하거나 " " 로 변경하셔야 합니다.
INSERT INTO trainer_spells (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES
(400010, 1847, 10000, 0, 0, 0, 0, 0, 0),
(400010, 2020, 1000, 0, 0, 0, 0, 0, 0),
(400010, 2021, 10000, 0, 164, 50, 0, 0, 0),
(400010, 2154, 10000, 0, 165, 50, 0, 0, 0),
[이하 생략...]
이렇게 되어 있는 쿼리라면
INSERT INTO trainer_spells (entry, cast_spell, spellcost, reqspell, reqskill, reqskillvalue, reqlevel, deletespell, is_prof) VALUES
(400010, 1847, 10000, 0, 0, 0, 0, 0, 0);
INSERT INTO trainer_spells (entry, cast_spell, spellcost, reqspell, reqskill, reqskillvalue, reqlevel, deletespell, is_prof) VALUES
(400010, 2020, 1000, 0, 0, 0, 0, 0, 0);
INSERT INTO trainer_spells (entry, cast_spell, spellcost, reqspell, reqskill, reqskillvalue, reqlevel, deletespell, is_prof) VALUES
(400010, 2021, 10000, 0, 164, 50, 0, 0, 0);
INSERT INTO trainer_spells (entry, cast_spell, spellcost, reqspell, reqskill, reqskillvalue, reqlevel, deletespell, is_prof) VALUES
(400010, 2154, 10000, 0, 165, 50, 0, 0, 0);
[이하 생략...]
이런 형태로 바꾸셔야 합니다.

arcemu.aio
Admin

게시물 갯수 : 314
Registration date : 2008-09-13

사용자 정보 보기 http://arcemu.wowwars.net

위로 Go down

Re: 통합트레이너 추가 구문인데요 먼가 잘못됫다고 저장이 안되네요

올리기 by ssessd on 2008-12-01, 6:45 pm

알켜주신대로 햇는데
이제는

SQLite Error 19 - trainer_spells.learn_spell may not be NULL

이라는 에러 매새지가 떠요 ;;

ssessd

게시물 갯수 : 12
Registration date : 2008-11-18

사용자 정보 보기

위로 Go down

Re: 통합트레이너 추가 구문인데요 먼가 잘못됫다고 저장이 안되네요

올리기 by ssessd on 2008-12-01, 6:50 pm

아 ;; 알겟네요 SQLiteSpy 게속 쳐다보니 ;;
그 learn_spell 이라는 구문이 빠져잇네요 .
옛날 구문이라 그런가봐요.;;
최신거 찾아봐야겟네요 ;

ssessd

게시물 갯수 : 12
Registration date : 2008-11-18

사용자 정보 보기

위로 Go down

Re: 통합트레이너 추가 구문인데요 먼가 잘못됫다고 저장이 안되네요

올리기 by Sponsored content


Sponsored content


위로 Go down

위로


 
Permissions in this forum:
답글을 올릴 수 없습니다