NewChar Problem, help me please.

[wilber1414]

When I creat a char lvl 1 appear with 630M of Exp. How can I change it to 0?

[szokersonik]

UPDATE _Char SET ExpOffset = 0 WHERE _Char.CharID = @NewCharID

Paste this at the bottom(not exactly at end) of your "_AddNewChar" Procedure(and execute), u can find it in SRO_VT_SHARD(if u have same DB names) in Programmability @Stored Procedures.

Enjoy!

[​Goofie​]

Originally Posted by szokersonik

UPDATE _Char SET ExpOffset = 0 WHERE _Char.CharID = @NewCharID

Paste this at the bottom(not exactly at end) of your "_AddNewChar" Procedure(and execute), u can find it in SRO_VT_SHARD(if u have same DB names) in Programmability @Stored Procedures.

Enjoy!

You are retarded. He should check where it's giving EXP instead of resetting it to 0.

[wilber1414]

How can i edit that ?

[szokersonik]

Originally Posted by ​Goofie​

You are retarded. He should check where it's giving EXP instead of resetting it to 0.

How can I change it to 0?

ammmm Do You see difference between WHERE and HOW ?
He dont ask WHERE , He ask HOW.

instead of resetting it to 0.

How can I change it to 0?

...thats enough?

By the way , what is the difference between updating that vaule or setuping it earlier?

How can i edit that ?

@wilber1414

Just show us your _AddNewChar procedure , and the problems will gone.

[wilber1414]

Originally Posted by szokersonik

ammmm Do You see difference between WHERE and HOW ?
He dont ask WHERE , He ask HOW.





...thats enough?

By the way , what is the difference between updating that vaule or setuping it earlier?

And you know guys ? how i can repair that ?

[szokersonik]

1. Go to Your Datbase... My called SRO_VT_SHARD
Open IT, Find Programmability , Find StoredProcedures,
Find dbo._AddNewChar , with right mouse button click once on it and then with left button click on the menu where you see "Modify", in the right part of window , you will see something like this

 Spoiler

PHP Code:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 02/20/2016 18:28:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER   PROCEDURE [dbo].[_AddNewChar]    
@UserJID   INT,    
--@CharSlot   INT,    
@RefCharID   INT, 
  
@CharName   varchar (64),    
@CharScale   tinyINT,    
@StartRegionID  INT,    
@StartPos_X   real,    
@StartPos_Y   real,    
@StartPos_Z   real,    
@DefaultTeleport INT,    
@RefMailID   INT,    
@RefPantsID   INT, 


Move your cursor over there , and click on it once with left mouse button,
then press CTRL + A , and then CTRL + C, and then make here new post with your procedure (CTRL + V) :P

enough.

[wilber1414]

Problem Solve it! Please Any Mod that Close this post.