PHP:
if( @thehe = 1 )
begin
INSERT INTO dbo.Character(AccountID, Name, Resets, ResetNBB, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money )
SELECT @AccountID As AccountID, @Name As Name, 10, 10, 400, 1000, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership, 3000000
FROM DefaultClassType WHERE Class = @Class
end
PHP:
, 10, 10, 400, 1000,