Junior Spellweaver
- Joined
- Nov 19, 2014
- Messages
- 132
- Reaction score
- 12
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
You have to add this to end of this procedure (atum2_db_1 > programmabilitty > [dbo].[atum_CreateCharacter]) and press f5
Code:
IF ( [USER=523252]Unit[/USER]Kind = 1) -- B-Gear
BEGIN
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7800019,GETDATE(),NULL) --\cFire Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7800029,GETDATE(),NULL) --\cMissile Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7800037,GETDATE(),NULL) --\cConcentration\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7800049,GETDATE(),NULL) --\cGround Bombing Mode\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7800058,GETDATE(),NULL) --\cMultitarget Mode\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7800066,GETDATE(),NULL) --\cCharge Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7800077,GETDATE(),NULL) --\cAir Bombing Mode\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7801017,GETDATE(),NULL) --\cDefense Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7801027,GETDATE(),NULL) --\cEvasion Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7801039,GETDATE(),NULL) --\cReduce Damage\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7801047,GETDATE(),NULL) --\cDeploy Chaffs\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7802013,GETDATE(),NULL) --Back Move Mach
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7802023,GETDATE(),NULL) --Turnaround
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7803011,GETDATE(),NULL) --Selling Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7803021,GETDATE(),NULL) --Purchasing Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7803031,GETDATE(),NULL) --\mInvisible\m
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7803044,GETDATE(),NULL) --\rBig Boom\r
END
ELSE IF ( [USER=523252]Unit[/USER]Kind = 16) -- M-Gear
BEGIN
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7810019,GETDATE(),NULL) --\cFire Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7810029,GETDATE(),NULL) --\cMissile Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7810037,GETDATE(),NULL) --\cConcentration\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7810048,GETDATE(),NULL) --\cElevation\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811017,GETDATE(),NULL) --\cDefense Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811027,GETDATE(),NULL) --\cEvasion Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811039,GETDATE(),NULL) --\cHealing Field\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811049,GETDATE(),NULL) --\cHeal Target\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811059,GETDATE(),NULL) --\cEnergizing Field\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811069,GETDATE(),NULL) --\cEnergize Target\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811079,GETDATE(),NULL) --\cRaging Fire\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811089,GETDATE(),NULL) --\cRaging Defense\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811099,GETDATE(),NULL) --\cRaging Evasion\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7811101,GETDATE(),NULL) --\mInvincible\m
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7812021,GETDATE(),NULL) --Reverse Engine
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813013,GETDATE(),NULL) --Fuel Replenish
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813023,GETDATE(),NULL) --Smart SP
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813031,GETDATE(),NULL) --Call of Hero
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813041,GETDATE(),NULL) --Selling Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813051,GETDATE(),NULL) --Purchasing Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813061,GETDATE(),NULL) --Scanning
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813074,GETDATE(),NULL) --\rFull Recovery\r
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813081,GETDATE(),NULL) --\mPurify\m
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7813181,GETDATE(),NULL) --Release
END
ELSE IF ( [USER=523252]Unit[/USER]Kind = 256) -- A-Gear
BEGIN
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7820019,GETDATE(),NULL) --\cFire Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7820029,GETDATE(),NULL) --\cMissile Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7820037,GETDATE(),NULL) --\cConcentration\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7820059,GETDATE(),NULL) --\cSiege Mode\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7820066,GETDATE(),NULL) --\cAir Siege Mode\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7821017,GETDATE(),NULL) --\cDefense Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7821027,GETDATE(),NULL) --\cEvasion Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7821031,GETDATE(),NULL) --Collision Absorption
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7821044,GETDATE(),NULL) --\cSiege Defense\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7821057,GETDATE(),NULL) --\cRemedy\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7821061,GETDATE(),NULL) --Barrier
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7822013,GETDATE(),NULL) --Ground Accelerator
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7823013,GETDATE(),NULL) --Snare Shot
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7823021,GETDATE(),NULL) --Selling Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7823031,GETDATE(),NULL) --Purchasing Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7823041,GETDATE(),NULL) --\mCamouflage\m
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7823051,GETDATE(),NULL) --\mShield Paralyze\m
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7823064,GETDATE(),NULL) --\rHyper Shot\r
END
ELSE IF ( [USER=523252]Unit[/USER]Kind = 4096) -- I-Gear
BEGIN
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7830019,GETDATE(),NULL) --\cFire Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7830029,GETDATE(),NULL) --\cMissile Shot\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7830039,GETDATE(),NULL) --\cFrenzy\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7830047,GETDATE(),NULL) --\cConcentration\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7831017,GETDATE(),NULL) --\cDefense Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7831027,GETDATE(),NULL) --\cEvasion Up\c
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7832014,GETDATE(),NULL) --Back Move Mach
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7832024,GETDATE(),NULL) --Turnaround
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7832031,GETDATE(),NULL) --Overbooster
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7832041,GETDATE(),NULL) --\mChain Rolling\m
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7833011,GETDATE(),NULL) --Hyper Moving
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7833021,GETDATE(),NULL) --Selling Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7833031,GETDATE(),NULL) --Purchasing Shop
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7833041,GETDATE(),NULL) --Silence
INSERT INTO [dbo].[td_StoreSkill] VALUES(@AccountUniqueNumber , [USER=2000184350]Unique[/USER]number,99,7833054,GETDATE(),NULL) --\rBerserker\r
END
Last edited: