Re: Pangya Season 4.9 Server Files and Database
@Darkknight you have to have the procedure first before you can alter it.
Code:
USE [Pangya_S4_TH]
GO
/****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_LOAD_S4] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[USP_CHAR_EQUIP_LOAD_S4] (
@UID INT
)
AS
BEGIN
SET NOCOUNT ON
IF ( @UID > 0 ) BEGIN
SELECT X.ITEM_ID
, TYPEID
/* new */
, ITEMID_PARTS_1
, ITEMID_PARTS_2
, ITEMID_PARTS_3
, ITEMID_PARTS_4
, ITEMID_PARTS_5
, ITEMID_PARTS_6
, ITEMID_PARTS_7
, ITEMID_PARTS_8
, ITEMID_PARTS_9
, ITEMID_PARTS_10
, ITEMID_PARTS_11
, ITEMID_PARTS_12
, ITEMID_PARTS_13
, ITEMID_PARTS_14
, ITEMID_PARTS_15
, ITEMID_PARTS_16
, ITEMID_PARTS_17
, ITEMID_PARTS_18
, ITEMID_PARTS_19
, ITEMID_PARTS_20
, ITEMID_PARTS_21
, ITEMID_PARTS_22
, ITEMID_PARTS_23
, ITEMID_PARTS_24
/* new */
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) X
INNER JOIN
(
SELECT
ITEM_ID
, ITEMID_PARTS_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN ITEMID ELSE 0 END)
FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) A
LEFT OUTER JOIN
(
SELECT CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM
FROM TD_CHAR_EQUIP_S4 WITH (NOLOCK)
WHERE UID = @UID
--AND ITEMID > 0
AND USE_YN = 'Y'
) B
ON A.ITEM_ID = B.CHAR_ITEMID
GROUP BY ITEM_ID
) Y
ON X.ITEM_ID = Y.ITEM_ID
END
END
can anyone help me with my Server list? i can't seem to see any servers on it.
Re: Pangya Season 4.9 Server Files and Database
I don't know about log when select loading server
2010-12-03 21:27:33 1 Pang-CB Server 7 [N_ITEM] TotalCNT : Parts(0), Clubset(1)
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(9), CmdID(3)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(10), CmdID(4)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(11), CmdID(10)
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(12), CmdID(11)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(13), CmdID(9)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(14), CmdID(15)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(15), CmdID(17)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(16), CmdID(14)
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 1 Pang-CB Server 7 [N_LOGIN] Disconnect : Pang( 3000 )
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
fasa2008
Talk to me on msn ... You've got my just do not know
Unfortunately I have your msn fasa2008.
I had some personal problems and a lack of time ended up doing some things with it, I just losing touch with everyone.
I believe that there can be no transfer of emails here at the forum.
I would like to get back in touch with you.
Manda by Mp in Rzbr?
Users = ShadowGames
Re: Pangya Season 4.9 Server Files and Database
@darkknight use this
Code:
USE Pangya_S4_TH;
GO
ALTER DATABASE Pangya_S4_DB
ADD FILEGROUP filegroup name here
GO
can anyone help with the files to add to the file group? Anyone need Item Database?
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
chiosin2
@darkknight use this
Code:
USE Pangya_S4_TH;
GO
ALTER DATABASE Pangya_S4_DB
ADD FILEGROUP filegroup name here
GO
can anyone help with the files to add to the file group? Anyone need Item Database?
Sure thing!
Fire up your enterprise console or management studio, open the properties window of your Pangya_S4_TH database and select files.
Since I am assuming you already have created the file groups the procedure is pretty simple. Add three new entries by clicking "Add".
The names of the entries should correspond with the name of the file groups you added earlier (Pangya_S4_TH_Card, Pangya_S4_TH_gLog, Pangya_S4_TH_Item), scroll to the last column "Filename" and set the value to Pangya_S4_TH_Card.mdf, Pangya_S4_TH_gLog.mdf and Pangya_S4_TH_Item.mdf. Assign the correct filegroup by using the File Group column.
Close the dialog by clicking OK, the tool will probably complain about the files already existing - doesn't matter though. If you want to make sure you get up to par open up the Pangya_S4_TH.sql query again and re-run it to get the missing parts. That should allow you to at least see the server.
If that's not the case check the gameserver logs for any E_ messages, it's likely you're still missing critical stored procedures.
2 Attachment(s)
Re: Pangya Season 4.9 Server Files and Database
Doesn't work for me. i have created the file groups by in the query, but does this have a script or something? i cant even edit the values for "Filename"
EDIT:
no i don't have any E_ in the gameserver logs..
Re: Pangya Season 4.9 Server Files and Database
@ Fasa2008
Personal message sent in the Br
@ Topic
Desconbriu where someone already adds and changes:
- Cookies
- Rates
- Experience
- And other
Re: Pangya Season 4.9 Server Files and Database
i got it to connect ^^ thanks.. Tsukasa. hmm now for the channels..
Re: Pangya Season 4.9 Server Files and Database
chiosin2, glad to hear it works!
I was just in the middle of wiring up a bootstrapper query for you. Since I believe it may be of interest to other people as well, here it is:
Code:
USE [master]
GO
/*******************************************
* Pangya Server 4.9 Database Bootstrapper *
* *
* Use at your own risk! *
* *
* Please edit the @DBUSER_PASSWORD for *
* your server. Leaving the default simply *
* isn't cool. *
* *
* USAGE: *
* 1. Run this query *
* 2. Run INI3_BILLDB.sql *
* 3. Run INI3_PY_ACCOUNT.sql *
* 4. Run Pangya_S4_TH.sql *
* 5. ??? (Add/Alter procedures, etc.) *
*******************************************/
DECLARE @DBUSER_PASSWORD VARCHAR(256)
DECLARE @DBUSER_CREATE_SQL NVARCHAR(256)
SET @DBUSER_PASSWORD = N'Password'
/* =========== Create users =========== */
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'ini3web')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3web] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3web already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'ini3gamebr')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3gamebr] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3gamebr already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'ini3webstat')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3webstat] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3webstat already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'pangya')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [pangya] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangya already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'Pangya_TH')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [Pangya_TH] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Pangya_TH already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'Biller')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [Biller] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Biller already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'pangyaclub')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [pangyaclub] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangyaclub already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'payletter')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [payletter] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User payletter already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'yogurting')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [yogurting] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User yogurting already exists, skipping creation...'
/* For people using the modified database we need a user Monk */
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'Monk')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [Monk] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Monk already exists, skipping creation...'
/* =========== ini3_py_account =========== */
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'ini3_py_account')
BEGIN
ALTER DATABASE [ini3_py_account] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [ini3_py_account] SET ONLINE
DROP DATABASE [ini3_py_account]
END
/* -- Recreate Database -- */
CREATE DATABASE [ini3_py_account]
GO
/* =========== INI3Bill_DB =========== */
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'INI3Bill_DB')
BEGIN
ALTER DATABASE [INI3Bill_DB] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [INI3Bill_DB] SET ONLINE
DROP DATABASE [INI3Bill_DB]
END
/* -- Recreate Database -- */
CREATE DATABASE [INI3Bill_DB]
GO
/* =========== Pangya_S4_TH =========== */
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'Pangya_S4_TH')
BEGIN
/* -- Close all connections and drop the database -- */
ALTER DATABASE [Pangya_S4_TH] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [Pangya_S4_TH] SET ONLINE
DROP DATABASE [Pangya_S4_TH]
END
/* -- Recreate Database -- */
CREATE DATABASE [Pangya_S4_TH]
DECLARE @DATABASE_PATH VARCHAR(256)
SELECT @DATABASE_PATH = physical_name
FROM sys.master_files
WHERE name = N'Pangya_S4_TH'
SET @DATABASE_PATH = REPLACE(@DATABASE_PATH, 'Pangya_S4_TH.mdf', '')
PRINT 'Pangya_S4_TH database resides at: ' + @DATABASE_PATH
/* --- Add File Groups and Files to the database Pangya_S4_TH --- */
DECLARE @ADDFILE_CARD_SQL varchar(256)
DECLARE @ADDFILE_GLOG_SQL varchar(256)
DECLARE @ADDFILE_ITEM_SQL varchar(256)
DECLARE @ADDFILE_MAIL_SQL varchar(256)
SET @ADDFILE_CARD_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_Card, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_Card.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_Card'
SET @ADDFILE_GLOG_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_gLog, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_gLog.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_gLog'
SET @ADDFILE_ITEM_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_Item, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_Item.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_Item'
SET @ADDFILE_MAIL_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_Mail, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_Mail.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_Mail'
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Card;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_gLog;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Item;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Mail;
EXEC(@ADDFILE_CARD_SQL)
EXEC(@ADDFILE_GLOG_SQL)
EXEC(@ADDFILE_ITEM_SQL)
EXEC(@ADDFILE_MAIL_SQL)
GO
The query will create the users, the databases, file groups and files. You'll have to run it before the 3 original queries coming with the server package.
Re: Pangya Season 4.9 Server Files and Database
Re: Pangya Season 4.9 Server Files and Database
Thank Tsukasa
some question
Please edit the @DBUSER_PASSWORD for *
* your server. Leaving the default simply *
* isn't cool.
@DBUSER_PASSWORD do you mean sa password ?
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
darkknight
Thank Tsukasa
some question
Please edit the @DBUSER_PASSWORD for *
* your server. Leaving the default simply *
* isn't cool.
@DBUSER_PASSWORD do you mean sa password ?
Nope, simply replace 'Password' in the line SET @DBUSER_PASSWORD = N'Password' with your own password. Doesn't really matter, though. You can also leave it as 'Password' since you'll most likely use the 'sa' user for access to the database anyway. Basically we only create these users to satisfy the queries from the server package, not to actually use them :laugh: .
A word of warning here: If you already have a running setup, executing this will throw you back to the very beginning since it drops databases! It is, however, very useful if you played around too much and want to start off clean or if you are setting up the server for the first time.
Re: Pangya Season 4.9 Server Files and Database
anyone fixed the channel log in yet?
Re: Pangya Season 4.9 Server Files and Database
@Tsukasa
About your bootstrapper query... Everytime I run the query, I always got "Incorrect syntax near 'LOGIN'."
I used MSSQL 2005 btw.
Re: Pangya Season 4.9 Server Files and Database
@Tsukasa
If not bothered, could you please post a copy of its databases, for which I am not able to login here.
