Training Camp

[hneko]

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?

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
);