stored procedures\dbo.NEW_CHAR

General assistance and guidelines for editing the server side of Soma.

stored procedures\dbo.NEW_CHAR

Postby Toshiki » Sun May 26, 2013 1:10 pm

can any one show me how to edit the con on this plz

USE [soma27]
GO
/****** Object: StoredProcedure [dbo].[NEW_CHAR] Script Date: 26/05/2013 13:09:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[NEW_CHAR]
@account varchar(20),
@id varchar(20),
@index smallint,
@newclass smallint,
@newstr int,
@newdex int,
@newint int,
@newcha int,
@newwis int,
@newcon int,
@newgender smallint,
@newhair smallint,
@newhairmode smallint,
@newskin smallint,
@temphp smallint,
@tempmp smallint,
@tempwgt smallint,
@tempstm smallint,
@startStr smallint,
@startDex smallint,
@startInt smallint,
@startCha smallint,
@startWis smallint,
@startCon smallint,
@rand_x smallint,
@rand_y smallint,
@first_z smallint
AS

--Finito Start of Skin Bug Fix
IF (@newclass > 0 AND @newskin > 1)
BEGIN
RETURN
END
ELSE IF (@newclass = 0 AND @newskin > 2)
BEGIN
RETURN
END
--Finito End of Skin Bug Fix

DECLARE @strchar01 varchar(20)
DECLARE @strchar02 varchar(20)
DECLARE @strchar03 varchar(20)
SELECT @strchar01 = strChar01, @strchar02 = strChar02, @strchar03 = strChar03 FROM CHARS WHERE strAccount = @account
IF (@strchar01 IS NULL)
BEGIN
UPDATE CHARS SET strChar01 = @id, dtTime01 = getdate() WHERE strAccount = @account
END
ELSE IF (@strchar02 IS NULL)
BEGIN
UPDATE CHARS SET strChar02 = @id, dtTime02 = getdate() WHERE strAccount = @account
END
ELSE IF (@strchar03 IS NULL)
BEGIN
UPDATE CHARS SET strChar03 = @id, dtTime03 = getdate() WHERE strAccount = @account
END
ELSE
BEGIN
RETURN
END
DECLARE @class smallint
DECLARE @level smallint
DECLARE @exp int
DECLARE @maxexp int
DECLARE @str int
DECLARE @strinc int
DECLARE @dex int
DECLARE @dexinc int
DECLARE @int int
DECLARE @intinc int
DECLARE @cha int
DECLARE @chainc int
DECLARE @wis int
DECLARE @wisinc int
DECLARE @con int
DECLARE @coninc int
DECLARE @sStartStr smallint
DECLARE @sStartDex smallint
DECLARE @sStartInt smallint
DECLARE @sStartCha smallint
DECLARE @sStartWis smallint
DECLARE @sStartCon smallint
DECLARE @hp smallint
DECLARE @maxhp smallint
DECLARE @mp smallint
DECLARE @maxmp smallint
DECLARE @stm smallint
DECLARE @maxstm smallint
DECLARE @wgt smallint
DECLARE @maxwgt smallint
DECLARE @status int
DECLARE @age smallint
DECLARE @playcount int
DECLARE @moral int
DECLARE @gender smallint
DECLARE @hair smallint
DECLARE @hairmode smallint
DECLARE @skin smallint
DECLARE @group smallint
DECLARE @groupreq smallint
DECLARE @fame smallint
DECLARE @magetype smallint
DECLARE @money int
DECLARE @bank int
DECLARE @rank smallint
DECLARE @lz smallint
DECLARE @lx smallint
DECLARE @ly smallint
DECLARE @classwartime int
DECLARE @classpoint int
DECLARE @totclasspoint int
DECLARE @swordexp int
DECLARE @spearexp int
DECLARE @bowexp int
DECLARE @axeexp int
DECLARE @knuckleexp int
DECLARE @staffexp int
DECLARE @weaponexp int
DECLARE @armorexp int
DECLARE @accexp int
DECLARE @potionexp int
DECLARE @cookingexp int
DECLARE @wmagicexp int
DECLARE @bmagicexp int
DECLARE @dmagicexp int
DECLARE @moralcount int
DECLARE @graycount int
DECLARE @eventcount int
DECLARE @partydeny smallint
DECLARE @msgrecv smallint
DECLARE @allchatrecv smallint
SELECT
@class = @newclass,
@level = 1,
@exp = 0,
@maxexp = 2000,
@str = @newstr,
@strinc = 0,
@dex = @newdex,
@dexinc = 0,
@int = @newint,
@intinc = 0,
@cha = @newcha,
@chainc = 0,
@wis = @newwis,
@wisinc = 0,
@con = @newcon,
@coninc = 0,
@sStartStr = @startStr,
@sStartDex = @startDex,
@sStartInt = @startInt,
@sStartCha = @startCha,
@sStartWis = @startWis,
@sStartCon = @startCon,
@hp = @temphp,
@maxhp = @temphp,
@mp = @tempmp,
@maxmp = @tempmp,
@stm = @tempstm,
@maxstm = @tempstm,
@wgt = @tempwgt,
@maxwgt = @tempwgt,
@status = 0,
@age = 14,
@playcount = 0,
@moral = 0,
@gender = @newgender,
@hair = @newhair,
@hairmode = @newhairmode,
@skin = @newskin,
@group = -1,
@groupreq = -1,
@fame = 1,
@magetype = 0,
@money = 10000,
@bank = 0,
@rank = 0,
@lz = @first_z,
@lx = @rand_x,
@ly = @rand_y,
@classwartime = 0,
@classpoint = 0,
@totclasspoint = 0,
@swordexp = 0,
@spearexp = 0,
@bowexp = 0,
@axeexp = 0,
@knuckleexp = 0,
@staffexp = 0,
@weaponexp = 0,
@armorexp = 0,
@accexp = 0,
@potionexp = 0,
@cookingexp = 0,
@wmagicexp = 0,
@bmagicexp = 0,
@dmagicexp = 0,
@moralcount = 120*60*60,
@graycount = 0,
@eventcount = -1,
@partydeny = 0,
@msgrecv = 1,
@allchatrecv = 1
INSERT INTO GAMEUSER VALUES (
@id,
@class,
@level,
@exp,
@maxexp,
@str,
@strinc,
@dex,
@dexinc,
@int,
@intinc,
@cha,
@chainc,
@wis,
@wisinc,
@con,
@coninc,
@sStartStr,
@sStartDex,
@sStartInt,
@sStartCha,
@sStartWis,
@sStartCon,
@hp,
@maxhp,
@mp,
@maxmp,
@stm,
@maxstm,
@wgt,
@maxwgt,
@status,
@age,
@playcount,
@moral,
@gender,
@hair,
@hairmode,
@skin,
@group,
@groupreq,
@fame,
@magetype,
@money,
@bank,
@rank,
@lz,
@lx,
@ly,
@classwartime,
@classpoint,
@totclasspoint,
@swordexp,
@spearexp,
@bowexp,
@axeexp,
@knuckleexp,
@staffexp,
@weaponexp,
@armorexp,
@accexp,
@potionexp,
@cookingexp,
@wmagicexp,
@bmagicexp,
@dmagicexp,
@moralcount,
@graycount,
@eventcount,
@partydeny,
@msgrecv,
@allchatrecv,
NULL,
NULL,
NULL,
NULL,
NULL,
'NEW',
NULL,
'NEW')
INSERT INTO USERITEM VALUES ( @id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL )
Toshiki
SD One Star
SD One Star
 
Posts: 13
Joined: Mon Mar 11, 2013 1:55 pm
Location: Scottish Borders

Re: stored procedures\dbo.NEW_CHAR

Postby phoenixgolden » Sun May 26, 2013 7:28 pm

@class = @newclass,
@level = 1,
@exp = 0,
@maxexp = 2000,
@str = @newstr,
@strinc = 0,
@dex = @newdex,
@dexinc = 0,
@int = @newint,
@intinc = 0,
@cha = @newcha,
@chainc = 0,
@wis = @newwis,
@wisinc = 0,
@con = @newcon,
@coninc = 0,



only edit this bit for starting char's
Phoenix.

Image

Human @Inca SomaDev (retired)
phoenixgolden
SD Pro 5 Star
SD Pro 5 Star
 
Posts: 1170
Joined: Sat Oct 08, 2011 9:24 pm

Re: stored procedures\dbo.NEW_CHAR

Postby Toshiki » Sun May 26, 2013 8:45 pm

Thankyou very much Phoenix much appreciated

so what i had to do was Delete @newcon and in put 18000000 like below :) so simple but was driving me crazy
@class = @newclass,
@level = 1,
@exp = 0,
@maxexp = 2000,
@str = @newstr,
@strinc = 0,
@dex = @newdex,
@dexinc = 0,
@int = @newint,
@intinc = 0,
@cha = @newcha,
@chainc = 0,
@wis = @newwis,
@wisinc = 0,
@con = 18000000,
@coninc = 0,
Toshiki
SD One Star
SD One Star
 
Posts: 13
Joined: Mon Mar 11, 2013 1:55 pm
Location: Scottish Borders


Return to Server Development

Who is online

Users browsing this forum: No registered users and 1 guest

cron