There this common problem =.=;

[mrNickname]

Please read attachment. Something's wrong with that missing dbo, need a fix. Could someone help? =.=;

[MentaL]

[Kimsangchul]

you need to create the odbs

[mrNickname]

Create it in PANGYA_S4_TH database or? And do i need to add some information into the table etc?

[dboycool]

you need to create the odbc

[mrNickname]

Ah the ODBC, i misread the first reply. Anyway should i create in User DNS or System DNS?

And must i change the default database to those 3 pangya databases?

Sorry i'm newb to MSSQL setup =.= hopefully i can learn more if i can get this right.

EDIT: Well nvm i fixed the problems by reading the server ini file, now how can i create new account and make the Client connect to my server? The game client with the 127.0.0.1 hex still report as "Please reinstall or run the updater" etc..

[Tsukasa]

mrNickName, you have to bootstrap the client a bit when using offline updates only.

Run the following batch file and you should be fine:

@echo off
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v Patcher /t REG_EXPAND_SZ /d "update.exe"
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v PatchNum /t REG_EXPAND_SZ /d "185"
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v IntegratedPak /t REG_EXPAND_SZ /d "projectg500+.pak"
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v Ver /t REG_EXPAND_SZ /d "TH.R4.583.02"

[mrNickname]

Whoow! That's a big help Tsukasa, i skipped using updater.exe just launch ProjectG.exe and boot to login screen. But lagged badly due to running USPangya and private client together.

With database, servers and client running 100% the final question would be how to create usernames and make it admin or GM?

[Tsukasa]

Please see the newly-created Common beginner questions thread.

[mrNickname]

Thanks again, i needed more info on that Create User area that i have no idea what to fill in properly.

(See Attachment)

[Tsukasa]

idcard: I treat this as an increasing int, starting from 1 I always increase the value by 1 for every account.
sex: 0 = Male, 1 = Female
birthday: Necessary, format is YYYYMMDD, i.e. 19801224
zipcode: 00000 sounds like a great area to live in ;)
id: The account login name, i.e. tsukasa or mrnickname
pswd: No explanation necessary...

[mrNickname]

Fail, even deleted the entire databases and re-create everything and still having this same issue.

I tried to edit Visa_Ref but the options are greyed out.

[Tsukasa]

As stated in the linked post you need to alter the table.

- Generate the CREATE TABLE statement for Ini3_UserLogin
- Edit the CREATE TABLE statement for Ini3_UserLogin, replace the NOT NULL statements with NULL statements for the problematic fields
- Drop Ini3_UserLogin
- Run the edited CREATE TABLE query to regenerate the table

[mrNickname]

Thanks Tsukasa, i actually went to eat, got so hungry working on it for 6 hrs xD From your procedures it seems confusing, but during my exploration i found out:

1. Right click on dbo.Ini3_UserLogin's 'Columns' folder and 'New Columns'.
2. Add new Column name 'Visa_Ref2', same data type and Allow Null and save.
3. Delete the original un-editable 'Visa_Ref' and rename Visa_Ref2 to Visa_Ref.

Voila~ Now i'm able to create username and activated with no error. Next i logged in but no Channel ROFLMAO RAWR! I read from your 'wikipedia' that says retry will work, i'll try a few more times if nothing works imma come back with my long face ;P

[Kimsangchul]

Create it in PANGYA_S4_TH database or? And do i need to add some information into the table etc?

To create the user runs this query she had created all user

USE [master]
GO

/*******************************************
Pangya Server 4.9 Database * * Bootstrapper
*
* Use at your own risk! *
*
Please edit the @ * is * DBUSER_PASSWORD
* 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 WHERE name = dbo.syslogins N'ini3web ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3web] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3web already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'ini3gamebr ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3gamebr] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3gamebr already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'ini3webstat ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3webstat] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3webstat already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'pangya ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [pangya] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangya already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'Pangya_TH ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [Pangya_TH] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Pangya_TH already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'Biller ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [Biller] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Biller already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'pangyaclub ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [pangyaclub] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangyaclub already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'payletter ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [payletter] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User payletter already exists, skipping creation ...'

IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'yogurting ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [yogurting] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User yogurting already exists, skipping creation ...'

/ * For people using the database we need a modified Monk user * /
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'Monk ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [Monk] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'Monk User already exists, skipping creation ...'

/ * =========== =========== Ini3_py_account * /
IF EXISTS (SELECT name FROM WHERE name = sys.databases 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 WHERE name = sys.databases 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 WHERE name = sys.databases 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 reside 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 (Pangya_S4_TH_Card NAME =, 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 (Pangya_S4_TH_gLog NAME =, 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 (Pangya_S4_TH_Item NAME =, 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 (Pangya_S4_TH_Mail NAME =, 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

[mrNickname]

Thanks Kim that is for creating the databases and i got that installed. But from now the channel won't show up no matter how i edit the Server.ini, there no showing any error on the consoles where could the problem be...