[2024]Shaiya Database Help

11/03/2024 06:02 $erafin#1
Greetings epvp!

So it's been a decade since the last time I played Shaiya and I decided to come back and set up one.

Before I get into the point of where I needed help exactly, I will share you guys some details about it to avoid confusion.

* I had Microsoft SQL Server 2014 and installed "DATABASE" files properly according to guides and releases.
[Only registered and activated users can see links. Click Here To Register...]


* I have managed "PSMServer_Mgr" to work perfectly.
[Only registered and activated users can see links. Click Here To Register...]


* I already edited "game.exe" IP and everything to run the game as shown below.
[Only registered and activated users can see links. Click Here To Register...]


** NOW **
Let's jump to my actual problem.


* Since I had the game to work, my actual problem is about database.
* I wanted to make an in-game account inside the database via "dbo.Users_Master" to test the game.
(As you can see I already had columns).
[Only registered and activated users can see links. Click Here To Register...]


* When I tried to make an account and open tables;
(PSUserData > Tables > dbo.UsersMaster ( right click ) > Open Tables)
[Only registered and activated users can see links. Click Here To Register...]

..it shows only this (without the columns and part where you manually make an account.)
[Only registered and activated users can see links. Click Here To Register...]




Any suggestions or help please? :confused:
11/03/2024 08:21 MrRoyalT#2
do "edit 200 rows" in this picture you sent
[Only registered and activated users can see links. Click Here To Register...]
not "table"


thank you for such clear and detailed explanation of your issue
most people just say "help can't make account"
11/03/2024 18:04 $erafin#3
Quote:
Originally Posted by MrRoyalT View Post
do "edit 200 rows" in this picture you sent
[Only registered and activated users can see links. Click Here To Register...]
not "table"


thank you for such clear and detailed explanation of your issue
most people just say "help can't make account"

Hello, I just did that tbh and it doesn't really edit anything at all and my DB is clean.
I think the problem is how can I open tables.
[Only registered and activated users can see links. Click Here To Register...]
11/04/2024 07:17 MrRoyalT#4
[Only registered and activated users can see links. Click Here To Register...]

use search function
11/04/2024 08:12 $erafin#5
Quote:
Originally Posted by MrRoyalT View Post
[Only registered and activated users can see links. Click Here To Register...]

use search function
Your reply has nothing to do with my current problem, besides I wouldn't even asked for a help if I found a solution, make sense right? :facepalm:

#THREADCLOSED
#FIXED

I had it fixed. I just have to re-create tables, seems like the existing one had some issue with the database I have downloaded.
Thanks!
11/05/2024 07:16 MrRoyalT#6
well fuck you then
if you're incapable of the most basic things and you have such a fucking rotten attitude