AP per minute $ stat points per level

05/21/2010 13:53 Shaiya Xtreme#1

1. We are getting 1 AP point per minute does anyone know where to change that?

2. What changes would have to take place to increase the stat points for UM from 11 points to 15 points

3. or increase the lvl cap from 60 to 65

Any feedback is appreciated, thanks.

05/24/2010 11:22 Polypropylen#2

#moved

06/09/2010 22:16 lilprohacker#3

I would like to know if anyone knows how to fix the AP per min issue?

06/10/2010 02:17 nafiz#4

lilprohacker
plz chnage ur download to a full client instead of a 4 part thing.
its really causing probs in my pc and i wana play shaiya exile

06/10/2010 06:59 lilprohacker#5

Quote:

Originally Posted by nafiz

lilprohacker
plz chnage ur download to a full client instead of a 4 part thing.
its really causing probs in my pc and i wana play shaiya exile

working on it...

06/10/2010 10:29 KillerBK#6

To hunt for bugs use SQL Profiler. This tool is in SQL Server.
In real-time displays the work of all the procedures and values.

Example search deadlock with SQL Profiler
[Only registered and activated users can see links. Click Here To Register...]

SQL Profiler - Sniffer for reverse engin..ng

and post here...

06/14/2010 16:16 ProfNerwosol#7

Quote:

Originally Posted by lilprohacker

I would like to know if anyone knows how to fix the AP per min issue?

Most likely it is a stored procedure ran every minute. Express version of MSSQL doesn't allow that but with Enterprise you can set a something like a schedule that runs selected procedure when you want.

That tool in the above post seems usefull or just go through all the procedures stored in PS_UserData and PS_GameData. It should be in one of these databases.

06/29/2011 23:13 aboldijar2#8

Anyone found a solution for that ?

06/29/2011 23:16 Bаne#9

Quote:

Originally Posted by aboldijar2

Anyone found a solution for that ?

Yes, 2 years ago infact...just search through the DB like pro said, that's all there is too it.

06/29/2011 23:16 aboldijar2#10

Quote:

Originally Posted by ProfNerwosol

Most likely it is a stored procedure ran every minute. Express version of MSSQL doesn't allow that but with Enterprise you can set a something like a schedule that runs selected procedure when you want.

That tool in the above post seems usefull or just go through all the procedures stored in PS_UserData and PS_GameData. It should be in one of these databases.

I am using Express Edition and it still raises AP per Min...

06/29/2011 23:24 RebeccaBlack#11

Don't necro though, make a new most @_@

Anyways, this is how you fix it.

Code:

BEGIN
	Update PS_userdata.dbo.Users_Master
	SET point=point+@LastPlayTime/2
	WHERE useruid=@useruid
	INSERT INTO PS_userdata.dbo.UserOnlineTimeLog(UserUid,OldPoint,Addpoint,LoginTime,LogoutTime,SessionID)
	values(@UserUid,@OldPoint,@LastPlayTime,@LoginTime,@LogTime,@SessionID)
end

You see the "SET point=point+@LastPlayTime/2" in that? Change that to SET point=point
then execute. *It's in PS_UserData.dbo.usp_Try_GameLogout_R*

06/29/2011 23:31 aboldijar2#12

Thanks Tyler :) Though it says completed with errors it gonna work? Alright done it :D Thank you again..

06/29/2011 23:54 RebeccaBlack#13

Depends, what's the errors?