- Joined
- Mar 29, 2019
- Messages
- 1,028
- Reaction score
- 1,184
How to Create Clean Databases 92.03/92.04/100.02
Since there's so many dmca´s takedowns for dbs, follow this guide for create both Planet and Shared DB's
Create a database with the name "PlanetDB_2800"
Ejecute the following query on it
Create a database named "SharedDB" and run the following query on it
100.02 ONLY
Create a database named "CollectionDB" and run the following query on it
UPDATE
To make clean dbs for TERA 100.02 replace in PlannetDB version 363898 to 375960 and SharedDB version 347932 to 374749
That's all, when you start the arbiter server it will create every single database and functions
UPDATE 2
How to create clean LogDB Database
1. Create a database named LogDB_2800 in MSSQL
2. Execute the attached query on it
Enjoy
View attachment LogDB_2800_Procedures.txt
Since there's so many dmca´s takedowns for dbs, follow this guide for create both Planet and Shared DB's
Create a database with the name "PlanetDB_2800"
Ejecute the following query on it
Code:
-- ------------------------------ Table structure for DbInfo-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
DROP TABLE [dbo].[DbInfo]
GO
CREATE TABLE [dbo].[DbInfo] ([version] int NULL)
GO
ALTER TABLE [dbo].[DbInfo] SET (LOCK_ESCALATION = TABLE)
GO
-- ------------------------------ Records of DbInfo-- ----------------------------
INSERT INTO [dbo].[DbInfo] ([version]) VALUES (N'363898')
GO
-- ------------------------------ procedure structure for spGetPlanetDatabaseVersion-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[spGetPlanetDatabaseVersion]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
DROP PROCEDURE[dbo].[spGetPlanetDatabaseVersion]
GO
CREATE PROCEDURE [dbo].[spGetPlanetDatabaseVersion]
AS
BEGIN
BEGIN TRY
BEGIN TRAN
SELECT version FROM DbInfo
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION
print ERROR_MESSAGE()
END CATCH
IF @@TRANCOUNT > 0
COMMIT TRANSACTION
END
Create a database named "SharedDB" and run the following query on it
Code:
-- ------------------------------ Table structure for DbInfo-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
DROP TABLE [dbo].[DbInfo]
GO
CREATE TABLE [dbo].[DbInfo] ( [version] int NULL)
GO
ALTER TABLE [dbo].[DbInfo] SET (LOCK_ESCALATION = TABLE)
GO
-- ------------------------------ Records of DbInfo-- ----------------------------
INSERT INTO [dbo].[DbInfo] ([version]) VALUES (N'347932')
GO
-- ------------------------------ procedure structure for spGetPlanetDatabaseVersion-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[spGetPlanetDatabaseVersion]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
DROP PROCEDURE[dbo].[spGetPlanetDatabaseVersion]
GO
CREATE PROCEDURE [dbo].[spGetPlanetDatabaseVersion]
AS
BEGIN
BEGIN TRY
BEGIN TRAN
SELECT version FROM DbInfo
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION
print ERROR_MESSAGE()
END CATCH
IF @@TRANCOUNT > 0
COMMIT TRANSACTION
END
100.02 ONLY
Create a database named "CollectionDB" and run the following query on it
Code:
-- ------------------------------ Table structure for DbInfo-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
DROP TABLE [dbo].[DbInfo]
GO
CREATE TABLE [dbo].[DbInfo] ( [version] int NULL)
GO
ALTER TABLE [dbo].[DbInfo] SET (LOCK_ESCALATION = TABLE)
GO
-- ------------------------------ Records of DbInfo-- ----------------------------
INSERT INTO [dbo].[DbInfo] ([version]) VALUES (N'368275')
GO
-- ------------------------------ procedure structure for spGetPlanetDatabaseVersion-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[spGetPlanetDatabaseVersion]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
DROP PROCEDURE[dbo].[spGetPlanetDatabaseVersion]
GO
CREATE PROCEDURE [dbo].[spGetPlanetDatabaseVersion]
AS
BEGIN
BEGIN TRY
BEGIN TRAN
SELECT version FROM DbInfo
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION
print ERROR_MESSAGE()
END CATCH
IF @@TRANCOUNT > 0
COMMIT TRANSACTION
END
UPDATE
To make clean dbs for TERA 100.02 replace in PlannetDB version 363898 to 375960 and SharedDB version 347932 to 374749
That's all, when you start the arbiter server it will create every single database and functions
UPDATE 2
How to create clean LogDB Database
1. Create a database named LogDB_2800 in MSSQL
2. Execute the attached query on it
Enjoy
View attachment LogDB_2800_Procedures.txt
Attachments
You must be registered for see attachments list
Last edited: