AP per minute $ stat points per level

[Shaiya Xtreme]

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.

[Polypropylen]

#moved

[lilprohacker]

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

[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

[lilprohacker]

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...

[KillerBK]

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


SQL Profiler - Sniffer for reverse engin..ng


and post here...

[ProfNerwosol]

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.

[aboldijar2]

Anyone found a solution for that ?

[Bаne]

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.

[aboldijar2]

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...

[RebeccaBlack]

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

Anyways, this is how you fix it.

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*

[aboldijar2]

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

[RebeccaBlack]

Depends, what's the errors?