[Release] Automatic Final Skills When Character Is Created

[Murat Yereseren]

if you want "Automatic Buy Final Skill When Character Is Created", you can use this.


You have to add this to end of this procedure (atum2_db_1 > programmabilitty > [dbo].[atum_CreateCharacter]) and press f5

IF ( @UnitKind = 1)     --  B-Gear
        BEGIN




                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7800019,GETDATE(),NULL)         --\cFire Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7800029,GETDATE(),NULL)         --\cMissile Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7800037,GETDATE(),NULL)         --\cConcentration\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7800049,GETDATE(),NULL)         --\cGround Bombing Mode\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7800058,GETDATE(),NULL)         --\cMultitarget Mode\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7800066,GETDATE(),NULL)         --\cCharge Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7800077,GETDATE(),NULL)         --\cAir Bombing Mode\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7801017,GETDATE(),NULL)         --\cDefense Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7801027,GETDATE(),NULL)         --\cEvasion Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7801039,GETDATE(),NULL)         --\cReduce Damage\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7801047,GETDATE(),NULL)         --\cDeploy Chaffs\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7802013,GETDATE(),NULL)         --Back Move Mach
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7802023,GETDATE(),NULL)         --Turnaround
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7803011,GETDATE(),NULL)         --Selling Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7803021,GETDATE(),NULL)         --Purchasing Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7803031,GETDATE(),NULL)         --\mInvisible\m
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7803044,GETDATE(),NULL)         --\rBig Boom\r




        END
    ELSE IF ( @UnitKind = 16)    --  M-Gear
        BEGIN




                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7810019,GETDATE(),NULL)         --\cFire Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7810029,GETDATE(),NULL)         --\cMissile Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7810037,GETDATE(),NULL)         --\cConcentration\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7810048,GETDATE(),NULL)         --\cElevation\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811017,GETDATE(),NULL)         --\cDefense Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811027,GETDATE(),NULL)         --\cEvasion Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811039,GETDATE(),NULL)         --\cHealing Field\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811049,GETDATE(),NULL)         --\cHeal Target\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811059,GETDATE(),NULL)         --\cEnergizing Field\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811069,GETDATE(),NULL)         --\cEnergize Target\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811079,GETDATE(),NULL)         --\cRaging Fire\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811089,GETDATE(),NULL)         --\cRaging Defense\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811099,GETDATE(),NULL)         --\cRaging Evasion\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7811101,GETDATE(),NULL)         --\mInvincible\m
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7812021,GETDATE(),NULL)         --Reverse Engine
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813013,GETDATE(),NULL)         --Fuel Replenish
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813023,GETDATE(),NULL)         --Smart SP
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813031,GETDATE(),NULL)         --Call of Hero
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813041,GETDATE(),NULL)         --Selling Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813051,GETDATE(),NULL)         --Purchasing Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813061,GETDATE(),NULL)         --Scanning
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813074,GETDATE(),NULL)         --\rFull Recovery\r
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813081,GETDATE(),NULL)         --\mPurify\m
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7813181,GETDATE(),NULL)         --Release




        END
    ELSE IF ( @UnitKind = 256)     -- A-Gear
        BEGIN




                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7820019,GETDATE(),NULL)         --\cFire Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7820029,GETDATE(),NULL)         --\cMissile Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7820037,GETDATE(),NULL)         --\cConcentration\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7820059,GETDATE(),NULL)         --\cSiege Mode\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7820066,GETDATE(),NULL)         --\cAir Siege Mode\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7821017,GETDATE(),NULL)         --\cDefense Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7821027,GETDATE(),NULL)         --\cEvasion Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7821031,GETDATE(),NULL)         --Collision Absorption
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7821044,GETDATE(),NULL)         --\cSiege Defense\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7821057,GETDATE(),NULL)         --\cRemedy\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7821061,GETDATE(),NULL)         --Barrier
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7822013,GETDATE(),NULL)         --Ground Accelerator
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7823013,GETDATE(),NULL)         --Snare Shot
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7823021,GETDATE(),NULL)         --Selling Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7823031,GETDATE(),NULL)         --Purchasing Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7823041,GETDATE(),NULL)         --\mCamouflage\m
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7823051,GETDATE(),NULL)         --\mShield Paralyze\m
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7823064,GETDATE(),NULL)         --\rHyper Shot\r




        END
    ELSE IF ( @UnitKind = 4096)     --  I-Gear
        BEGIN




                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7830019,GETDATE(),NULL)         --\cFire Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7830029,GETDATE(),NULL)         --\cMissile Shot\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7830039,GETDATE(),NULL)         --\cFrenzy\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7830047,GETDATE(),NULL)         --\cConcentration\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7831017,GETDATE(),NULL)         --\cDefense Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7831027,GETDATE(),NULL)         --\cEvasion Up\c
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7832014,GETDATE(),NULL)         --Back Move Mach
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7832024,GETDATE(),NULL)         --Turnaround
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7832031,GETDATE(),NULL)         --Overbooster
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7832041,GETDATE(),NULL)         --\mChain Rolling\m
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7833011,GETDATE(),NULL)         --Hyper Moving
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7833021,GETDATE(),NULL)         --Selling Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7833031,GETDATE(),NULL)         --Purchasing Shop
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7833041,GETDATE(),NULL)         --Silence
                INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , @Uniquenumber,99,7833054,GETDATE(),NULL)         --\rBerserker\r




        END

[MentaL]

[Aesir]

"[dev]"...

[Murat Yereseren]

"[dev]"...

youre right, i dont know, and i pm to future about this

[Aesir]

youre right, i dont know, and i pm to future about this

Well, i wrote that because on my side i dont consider a so much "elaborated" language the MSSQL (or atleast at those levels), because the only thing required for code it is a pinch of brain and a basic english knowledge, for this i do not exactly know if a post such this can be tagged as a development post.

[Murat Yereseren]

Well, i wrote that because on my side i dont consider a so much "elaborated" language the MSSQL (or atleast at those levels), because the only thing required for code it is a pinch of brain and a basic english knowledge, for this i do not exactly know if a post such this can be tagged as a development post.

youre right again. i just some bored and i wanted share this. and i pm to future because i dont know , this is dev or simple share.
and you are saying this is so simple and this is just simple share.
i guess, future must decide for this

[Future]

Nothing bad about that :v
You never know, maybe someone will somewhere have use for it and wont need to make everything from scratch again!

Btw. this is rather a release as there is nothing to discuss or develop together on. Unless you are looking for some improvement.

Moved it to the release section.