Hello
Why is it not working? I tried tracking the training camp when you register a new char, and I found two tables. I'm trying to register in the academy by creating a character, but for some reason, it's not working. Any ideas?
Why is it not working? I tried tracking the training camp when you register a new char, and I found two tables. I'm trying to register in the academy by creating a character, but for some reason, it's not working. Any ideas?
Code:
Insert into dbo._TrainingCamp (CreationDate,Rank,GraduateCount,EvaluationPoint,LatestEvaluationDate,CommentTitle,Comment) values (GetDate(),5,0,0,GETDATE(),'','')
INSERT INTO dbo._TrainingCampMember (
CampID, CharID, RefObjID, CharName, JoinDate,
MemberClass, CharJoinedLevel, CharCurLevel,
CharMaxLevel, HonorPoint
)
VALUES (
(SELECT TOP 1 ID FROM _TrainingCamp ORDER BY ID DESC),
(SELECT TOP 1 CharID FROM _Char ORDER BY CharID DESC),
[MENTION=1326241]REF[/MENTION]CharID,
[MENTION=3898309]charname[/MENTION],
GETDATE(),
0, 110, 110, 110, 0
);