Register for your free account! | Forgot your password?

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

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

Advertisement



Stored procedure that load char details

Discussion on Stored procedure that load char details within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2014
Posts: 119
Received Thanks: 27
Stored procedure that load char details

Hi

I don't find where is the proc that read and load the char detail.

I tried a lot but doesn't work.

Here is my interrogation.

I set money on my char to ' -1 '

And in the game, it show 4billions and more.

I want to add a control (if money<0, set money=0)

i tried on PS_GameData.dbo.usp_Read_Chars_Detail2_R

but don't seems to work.

Thanks for help
Boul27 is offline  
Old 01/26/2015, 21:03   #2
 
wallerus's Avatar
 
elite*gold: 0
Join Date: Apr 2014
Posts: 300
Received Thanks: 473
Try using [usp_Save_Char_Info_E] instead.
wallerus is offline  
Thanks
1 User
Old 01/26/2015, 21:31   #3
 
elite*gold: 0
Join Date: Mar 2014
Posts: 119
Received Thanks: 27
Thank

That solve a part of my problem

I will search a bit more into the Read proc to add one more control
Boul27 is offline  
Reply


Similar Threads Similar Threads
Stored Procedure db.smp_check_purchased_item?
06/23/2013 - Rappelz Private Server - 1 Replies
I've come across an error on the Captain Herlock server while logging on my character. This is the error I get: DB COM ERROR(Thread:2, HRESULT:80040E37, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D):DB_GetC ommercialStorageInfo(dbo.smp_check_purchased_item) : Invalid object name 'billing.dbo.PaidItem'. I've narrowed down the stored procedure and here is the problematic code: dbo.smp_check_purchased_item SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from billing.dbo.PaidItem WHERE...
[SQL] Stored Procedure for TitleUpdating Automatic
05/08/2013 - SRO PServer Guides & Releases - 11 Replies
heya guys, this was made a looooooong time ago when we wanted to make title giving automatic on devias. however, it was never used cuz of lazyness. Just found it again and thought i´d release it. This is to be executed each time a new uniquelog is added. It works like this gets the first charname that killed the MOB "Devias". If you kill devias for the first time u get the title Devias Slayer #1 for the second time Devias Slayer #2 etc.
Hello, I have a problem with a stored procedure when you log into the game.
08/13/2012 - Rappelz Private Server - 5 Replies
Posts Forum on this thread did not help me! Any thoughts about this problem, screen :handsdown: http://s017.radikal.ru/i437/1208/20/992648841219.j pg
[HELP]Res toon stored Procedure
07/23/2010 - Shaiya Private Server - 0 Replies
Hi all, hopefully someone can tell me what i am doing wrong. I am trying to use the dbo.usp_GM_Recovery_Char and it completes without errors but it doesn't res the toon. can anyone tell me how to fix this. I am tired of ressing them manually. thanks alot!!



All times are GMT +1. The time now is 17:01.


Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.