Pangya Season 4.9 Server Files and Database

[chiosin2]

@Darkknight you have to have the procedure first before you can alter it.

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.

[darkknight]

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 )

[sandro_adm]

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

[chiosin2]

@darkknight use this

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?

[Tsukasa]

@darkknight use this

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.

[chiosin2]

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

[sandro_adm]

@ Fasa2008
Personal message sent in the Br

@ Topic
Desconbriu where someone already adds and changes:
- Cookies
- Rates
- Experience
- And other

[chiosin2]

i got it to connect ^^ thanks.. Tsukasa. hmm now for the channels..

[Tsukasa]

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:

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.

[crashbufao]

some1 know where add Gm?

[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 ?

[Tsukasa]

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 .

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.

[chiosin2]

anyone fixed the channel log in yet?

[tulang3587]

@Tsukasa
About your bootstrapper query... Everytime I run the query, I always got "Incorrect syntax near 'LOGIN'."
I used MSSQL 2005 btw.

[ragezonersonexa]

@Tsukasa

If not bothered, could you please post a copy of its databases, for which I am not able to login here.