Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Development
You last visited: Today at 19:04

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Creating Custom Character with Money at First Only

Discussion on Creating Custom Character with Money at First Only within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2015
Posts: 11
Received Thanks: 3
Creating Custom Character with Money at First Only

Need help...
I have a code where he creates the first character by adding money, when creating the second he will not have money.
The problem is that by deleting all characters, he adds money back to the first character.
I want only the first character of the account to be added money.
Follows the code:
[usp_Create_Char_R]
ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 1
SET @Point = 0
SET @ = 5

-- Status
IF @Job = 0
BEGIN
SET @ = 14
END
ELSE IF @Job = 1
BEGIN
SET @rec = 12
END
ELSE IF @Job = 2
BEGIN
SET @dex = 19
END
ELSE IF @Job = 3
BEGIN
SET @luc = 13
END
ELSE IF @job = 4
BEGIN
SET @int = 15
END
ELSE IF @job = 5
BEGIN
SET @ = 14
END

END

SET @CharName = LTRIM(RTRIM(@CharName))
SET @ = 0

SET @Money = 1000000

/* First we declare our variable selecting all of our characters from our specified useruid - making sure the character is alive aswell */
DECLARE @charselect int = (Select COUNT(*) FROM PS_GameData.dbo.Chars WHERE UserUID=@UserUID AND Del=0)
/* Then we say if it has more than one character we will return an error not allowing it to be created. */
IF @charselect > 0
BEGIN
SET @Money = 0
END
erasmojosepzo is offline  
Old 08/09/2019, 22:39   #2
 
elite*gold: 260
Join Date: Sep 2011
Posts: 487
Received Thanks: 360
You have to remove Del=0
SnickQ is offline  
Thanks
1 User
Reply

Tags
shaiya 2019, shaiya 6.3


Similar Threads Similar Threads
[CUSTOM SALE] PokeMMO! Custom Bots, Exp Leveling Bot, Shiny Catcher! [CUSTOM SALE]
04/08/2014 - Trading - 90 Replies
Update: 2013-05-20 BOT IS NOW FULLY AIO SUPPORTS ALL LOCATIONS IN POKEMMO!! Auto-leveling bot: Supports PP healing Supports Death pokemon healing Supports death pokemon switching Supports walking to healing Fully flawless & catches shinies!!!
[BETA]Beta-Max Online ~ 120 CAP ~ D13 ~ Custom Events ~ Custom Quests ~ Custom Areas
03/25/2012 - SRO PServer Advertising - 109 Replies
Hello there, I would like to announce the BETA opening of Astro Server, We are here for the community not for competition. We don't care if we are #1 or #1001. The BETA will last one week, to find any small bugs that may still exist. During this time users will receive 5000 Wonga as soon as you register this is part of the BETA test. Also users will be rewarded for helping when we go live, Which you can find more information on this at the forum. Please be aware after the BETA ends...
Beta-Max Online ~ 120 CAP ~ D13 ~ Custom Events ~ Custom Quests ~ Custom Areas
03/19/2012 - SRO PServer Advertising - 6 Replies
Fantastic Server. If reliablility is what you want then Beta-Max is for you. Unique PVP Battles - Pets - Items - Quests - Jobs - Wonga and so much more Server Details: Level Cap: 120 Skill Cap: 120 Chinese Mastery Cap: 360 European Mastery Cap: 240 Item Degree: 13th Degree Active Areas: All (Including Jupiter)



All times are GMT +1. The time now is 19:06.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.