TCreatechar

[jibi1996]

Those are usefull functions that will make your start of game faster.

It is to be added before

RETURN @@ERROR

Dodge Skill 80%

-- INSERT DODGE SKILL 80% --
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 37, 3, 0)

Sturdy Sacks

-- INSERT STURDY SACK 5-UNITS --
INSERT INTO TINVENTABLE(dwCharID, bInvenID, wItemID, dEndTime, bELD)
    VALUES(@dwCharID, 0, 7625, '1900-01-01 00:00:00', 0)
INSERT INTO TINVENTABLE(dwCharID, bInvenID, wItemID, dEndTime, bELD)
    VALUES(@dwCharID, 1, 7625, '1900-01-01 00:00:00', 0)
INSERT INTO TINVENTABLE(dwCharID, bInvenID, wItemID, dEndTime, bELD)
    VALUES(@dwCharID, 2, 7625, '1900-01-01 00:00:00', 0)
INSERT INTO TINVENTABLE(dwCharID, bInvenID, wItemID, dEndTime, bELD)
    VALUES(@dwCharID, 3, 7625, '1900-01-01 00:00:00', 0)
INSERT INTO TINVENTABLE(dwCharID, bInvenID, wItemID, dEndTime, bELD)
    VALUES(@dwCharID, 4, 7625, '1900-01-01 00:00:00', 0)

-- INSERT ALL ARCHER SKILLS --
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 300, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 302, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 304, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 305, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 306, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 307, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 308, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 309, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 310, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 311, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 312, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 313, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 315, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 317, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 318, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 319, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 321, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 324, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 325, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 326, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 327, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 328, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 329, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 331, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 332, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 333, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 334, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 335, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 336, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 337, 4, 0)

-- INSERT ALL WARRIORS SKILLS --
IF (@bClass = 0)
BEGIN
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 100, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 101, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 102, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 103, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 104, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 106, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 108, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 109, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 110, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 111, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 112, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 113, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 114, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 115, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 116, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 117, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 118, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 120, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 122, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 123, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 124, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 125, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 126, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 127, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 128, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 130, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 132, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 133, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 134, 5, 0)
END
-- INSERT ASSASSIN SKILLS --
IF (@bClass = 1)
BEGIN
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 200, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 201, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 202, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 205, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 208, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 209, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 211, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 213, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 214, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 216, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 217, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 218, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 219, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 220, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 221, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 223, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 225, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 227, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 228, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 229, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 231, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 232, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 233, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 234, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 235, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 236, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 237, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 238, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 239, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 240, 5, 0)
END
-- INSERT ALL WIZZARD SKILLS --
IF (@bClass = 3)
BEGIN
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 400, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 402, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 404, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 405, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 407, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 408, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 409, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 410, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 412, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 413, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 414, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 415, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 416, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 418, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 419, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 422, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 423, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 424, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 427, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 428, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 429, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 430, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 431, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 432, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 433, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 434, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 435, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 436, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 437, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 438, 3, 0)
END
-- INSERT ALL PRIEST SKILLS --
IF (@bClass = 4)
BEGIN
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 500, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 501, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 502, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 503, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 504, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 505, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 506, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 507, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 508, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 509, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 510, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 511, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 512, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 513, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 514, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 515, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 516, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 518, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 519, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 520, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 521, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 524, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 525, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 526, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 528, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 530, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 531, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 532, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 533, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 534, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 536, 4, 0)
END
-- INSERT ALL SUMMONER SKILLS --
IF (@bClass = 5)
BEGIN
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 634, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 635, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 636, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 637, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 640, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 600, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 602, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 604, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 605, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 606, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 608, 4, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 611, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 612, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 613, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 614, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 615, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 616, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 617, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 618, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 619, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 620, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 623, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 624, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 625, 1, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 628, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 629, 7, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 630, 3, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 631, 5, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 632, 6, 0)
INSERT INTO TSKILLTABLE(dwCharID, wSkillID, bLevel, dwRemainTick)
    VALUES(@dwCharID, 633, 3, 0)
END

[Sicarium]

make another procedure... so.. you have the TCreateChar free and clear

[jibi1996]

Originally Posted by Sicarium

make another procedure... so.. you have the TCreateChar free and clear

ah just put on it, comment after if you don't need, it's the same

[Konst™]

That is already public in Waynes database..

[jibi1996]

Originally Posted by Konst™

That is already public in Waynes database..

Which database? o.O

[Konst™]

FreeWay or Wayne already released a database where is that functions public.

[fares31]

Link?

[jibi1996]

Originally Posted by Konst™

FreeWay or Wayne already released a database where is that functions public.

I don't know the existence of such databases ...

- update

all class skill tree added.