Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Skill Points! need help

Experienced Elementalist
Joined
Jul 11, 2014
Messages
274
Reaction score
2
Can some One Help about this !

How to add automaticaly SWord point and Magic point :(

REMOVED
 
Skilled Illusionist
Joined
Feb 26, 2013
Messages
346
Reaction score
57
if u actually just added skill rank use bega tool to add points also or add it in SQL db manually in dbo.character_table
 
Upvote 0
Experienced Elementalist
Joined
Jul 11, 2014
Messages
274
Reaction score
2
but how to deal with that what is the query?



USE [server01]
GO
/****** Object: StoredProcedure [dbo].[cabal_sp_newchar] Script Date: 01/02/2015 07:46:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_newchar]
(
name VARCHAR(16),
CharacterIdx INT,
StYle INT,
Stylemastery INT
)
AS
BEGIN
SET NOCOUNT ON


DECLARE @CR_SUCCESS INT
DECLARE @CR_DATABRK INT
DECLARE @CR_NAMEDUP INT
DECLARE @CR_BADWORD INT


SET @CR_SUCCESS = 0xA0
SET @CR_DATABRK = 0x02
SET @CR_NAMEDUP = 0x03
SET @CR_BADWORD = 0x04


IF NOT Stylemastery BETWEEN 1 AND 6
BEGIN
SELECT @CR_DATABRK
RETURN
END


IF EXISTS (SELECT * FROM cabal_badwoard WHERE badword = name )
BEGIN
SELECT @CR_BADWORD
RETURN
END


IF EXISTS (SELECT * FROM cabal_character_table WHERE Name = name)
BEGIN
SELECT @CR_NAMEDUP
RETURN
END


IF EXISTS (SELECT * FROM cabal_character_table WHERE CharacterIdx = CharacterIdx)
BEGIN
SELECT @CR_DATABRK
RETURN
END



SET XACT_ABORT ON
BEGIN TRAN


INSERT INTO cabal_character_table
(
CharacterIdx, Name,
LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
WorldIdx, [Position], Style,
HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation
)
SELECT
CharacterIdx, name,
100, [EXP], 200, 200, 200, 10, Rank, 100000,
WorldIdx, Position, StYle +152,
HP, MP, SP, 1000, 1000, RankEXP, Flags, 4095, 4095, 10000000
FROM cabal_new_character_data
WHERE ClassType = Stylemastery


IF @@ROWCOUNT <> 1
BEGIN
ROLLBACK TRAN
SELECT @CR_DATABRK
RETURN
END


INSERT INTO cabal_inventory_table (CharacterIdx, Data)
SELECT CharacterIdx, InventoryData FROM cabal_new_character_data
WHERE ClassType = Stylemastery


INSERT INTO cabal_equipment_table (CharacterIdx, Data)
SELECT CharacterIdx, EquipmentData FROM cabal_new_character_data
WHERE ClassType = Stylemastery


INSERT INTO cabal_skilllist_table (CharacterIdx, Data)
SELECT CharacterIdx, SkillData FROM cabal_new_character_data
WHERE ClassType = Stylemastery


INSERT INTO cabal_quickslot_table (CharacterIdx, Data)
SELECT CharacterIdx, QuickSlotData FROM cabal_new_character_data
WHERE ClassType = Stylemastery


INSERT INTO cabal_questdata_table (characterIdx, Data, Flags)
SELECT CharacterIdx, QuestData, QuestFlagsData FROM cabal_new_character_data
WHERE ClassType = Stylemastery


EXEC cabal_sp_linked_update_character_count CharacterIdx, 1

SELECT @CR_SUCCESS + Stylemastery




COMMIT TRAN
SET XACT_ABORT OFF

SET NOCOUNT OFF
END




i already edit but no effect in game :(
 
Upvote 0
Banned
Banned
Joined
Aug 2, 2011
Messages
1,427
Reaction score
979
Code:
USE [SERVER01]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_newchar]    Script Date: 02/10/2015 01:17:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_newchar]
(
 [USER=1333344765]name[/USER] VARCHAR(16),
 [USER=1333352388]Character[/USER]Idx  INT,
 [USER=24452]StYle[/USER] INT,
 [USER=862733]Stylemaster[/USER]y INT
)
AS
BEGIN
SET NOCOUNT ON

DECLARE @CR_SUCCESS INT
DECLARE @CR_DATABRK INT		
DECLARE @CR_NAMEDUP INT	
DECLARE @CR_BADWORD INT

SET @CR_SUCCESS = 0xA0
SET @CR_DATABRK = 0x02	
SET @CR_NAMEDUP = 0x03
SET @CR_BADWORD = 0x04

IF NOT [USER=862733]Stylemaster[/USER]y BETWEEN 1 AND 6
BEGIN
	SELECT @CR_DATABRK
	RETURN
END

IF EXISTS (SELECT * FROM cabal_badwoard WHERE badword = [USER=1333344765]name[/USER] )
BEGIN
	SELECT @CR_BADWORD
	RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE Name = [USER=1333344765]name[/USER])
BEGIN
	SELECT @CR_NAMEDUP
	RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE CharacterIdx = [USER=1333352388]Character[/USER]Idx)
BEGIN
	SELECT @CR_DATABRK
	RETURN
END
	

SET XACT_ABORT ON
BEGIN TRAN

INSERT INTO cabal_character_table
(
	CharacterIdx, Name,
	LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
	WorldIdx, [Position], Style, 
	HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField
)
SELECT
 [USER=1333352388]Character[/USER]Idx, [USER=1333344765]name[/USER],
	LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
	WorldIdx, Position, [USER=24452]StYle[/USER] +152,
	HP, MP, SP +1111425024, SwdPNT +1111425024, MagPNT +1111425024, RankEXP, Flags, WarpBField = 4095, MapsBField = 4095
FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y

IF @@ROWCOUNT <> 1
BEGIN
	ROLLBACK TRAN
	SELECT @CR_DATABRK
	RETURN
END

INSERT INTO cabal_inventory_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, InventoryData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y

INSERT INTO cabal_equipment_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, EquipmentData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y

INSERT INTO cabal_skilllist_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, SkillData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y

INSERT INTO cabal_quickslot_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, QuickSlotData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y

INSERT INTO cabal_questdata_table (characterIdx, Data, Flags)
SELECT [USER=1333352388]Character[/USER]Idx, QuestData, QuestFlagsData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y

EXEC cabal_sp_linked_update_character_count [USER=1333352388]Character[/USER]Idx, 1
		
SELECT @CR_SUCCESS + [USER=862733]Stylemaster[/USER]y

COMMIT TRAN
SET XACT_ABORT OFF
	
SET NOCOUNT OFF
END
 
Upvote 0
Back
Top