- Joined
- Jun 11, 2010
- Messages
- 419
- Reaction score
- 60
# # # # # # #
# # MSSQL
# # # # # # #
- Restore Databases> database ..> From device> ...> Add>
First ACCOUNT_DBF
Third CHARACTER_01_DBF
4th EoCRM_DBF
5th EoCRM_DBF_R
7th LOG_01_DBF
8th LOGGING_01_DBF
9th MANAGE_DBF
11th RANKING_DBF
> Restore hook> select Add Date Bank> Respective database.
- Security> New> Application> Application Name: fill Killerooo> SQL Server Authentication> Password
> Server Roles> All rights give>
> Benuterzuordnung> Assign all DB's are up gennant hook> Rights: db_owner.
- Linked Servers> New Query>
Script:
exec sys.sp_addlinkedserver 'CONNECTION SERVERNAME','', 'SQLNCLI', 'SQL SERVER INSTANCE NAME', null, null, 'DBNAME'
exec sys.sp_serveroption @ server = 'CONNECTION SERVERNAME', @ optname = 'rpc', @ optvalue = 'true'
exec sys.sp_serveroption @ server = 'CONNECTION SERVERNAME', @ optname = 'rpc out', @ optvalue = 'true'
>
LOG01
CHR01
ACCOUNT
RANKING
EoCRM_DBF_R open:
Tables where data must be modified:
dbo.tb_Administration open:
dbo.tb_GameServer
The rest of the tables by watching too.
EoCRM_DBF also look through.
# # # # # #
# # ODBC
# # # # # #
ODBC data sources Open:
User DSN> SQL Server Native Client 10.0> Name: bsp Connection Name: character01
> Server: bsp.KILLEROOO PC \ SERVER KILLER> With integrated Windows authentification when SA canceled
use the previously create login + password.
> Default Database to: bsp.CHARACTER_01_DBF
> Default Language to: English.
Name: character01 DB: CHARACTER_01_DBF
Name: log01 DB: LOGGING_01_DBF
Name: DB login: ACCOUNT_DBF
Name: DB ranking: RANKING_DBF
Name: chdb01 DB: MANAGE_DBF
Name: DB01 DB: EoCRM_DBF_R
# # # # # # # # # # # # # # # # #
# # Create a page
# # # # # # # # # # # # # # # # #
Windows functions> IIS and ASP enabled services.
IIS> Add Website
> Site Name: EoCRM
> Physical Path: C: \ inetpub \ wwwroot \ EoCRM
> Binding:
> Type: http
> Ip address: ROOTIP, Network Ip or 127.0.0.1
> Port: 80
# # # # # # # # # # # # # # # # #
# # # # # # # # # # # # # # # # # # # # #
# # Configure page
# # # # # # # # # # # # # # # # # # # # #
EoCRM> common> asp> config.asp
Data Source = KILLEROOO PC \ SERVER KILLER or 127.0.0.1 or IP network
User Id = MSSQL login name
Password = password MSSQL
Dim cComponyIP: cComponyIP = "IP / Domain ON the panel is"
EoCRM> Open web.config with Notepad
Data Source = KILLEROOO PC \ SERVER KILLER or 127.0.0.1 or IP network
KILLEROOO server = SERVER \ SERVER KILLER or 127.0.0.1 or IP network
User ID = MSSQL login name
Password = password MSSQL
get the panel here: http://forum.ragezone.com/f457/re-release-eocrm-920978/
databases here: http://forum.ragezone.com/f457/re-upload-re-release-v15-920694/
I found this guide in another forum. re posting it here since their is nothing on eocrm for guides. Please remember that you have to modify the panel and the databases more to get more features to work. you need to use IIS. since this is ASP only ISS will work to run the website. If you already have a flyff server installed then you might be able to skip some of the odbc stuff and the database stuff.
credits to misterkid, gpotato for developing this panel, and audisbroder.
NOTE: YOU WILL NOT NEED TO USE ALL THE INFO HERE TO SET IT UP. ODBC ARE NOT REQUIRED TO MAKE THE PANEL WORK.
# # MSSQL
# # # # # # #
- Restore Databases> database ..> From device> ...> Add>
First ACCOUNT_DBF
Third CHARACTER_01_DBF
4th EoCRM_DBF
5th EoCRM_DBF_R
7th LOG_01_DBF
8th LOGGING_01_DBF
9th MANAGE_DBF
11th RANKING_DBF
> Restore hook> select Add Date Bank> Respective database.
- Security> New> Application> Application Name: fill Killerooo> SQL Server Authentication> Password
> Server Roles> All rights give>
> Benuterzuordnung> Assign all DB's are up gennant hook> Rights: db_owner.
- Linked Servers> New Query>
Script:
exec sys.sp_addlinkedserver 'CONNECTION SERVERNAME','', 'SQLNCLI', 'SQL SERVER INSTANCE NAME', null, null, 'DBNAME'
exec sys.sp_serveroption @ server = 'CONNECTION SERVERNAME', @ optname = 'rpc', @ optvalue = 'true'
exec sys.sp_serveroption @ server = 'CONNECTION SERVERNAME', @ optname = 'rpc out', @ optvalue = 'true'
>
LOG01
CHR01
ACCOUNT
RANKING
EoCRM_DBF_R open:
Tables where data must be modified:
dbo.tb_Administration open:
dbo.tb_GameServer
The rest of the tables by watching too.
EoCRM_DBF also look through.
# # # # # #
# # ODBC
# # # # # #
ODBC data sources Open:
User DSN> SQL Server Native Client 10.0> Name: bsp Connection Name: character01
> Server: bsp.KILLEROOO PC \ SERVER KILLER> With integrated Windows authentification when SA canceled
use the previously create login + password.
> Default Database to: bsp.CHARACTER_01_DBF
> Default Language to: English.
Name: character01 DB: CHARACTER_01_DBF
Name: log01 DB: LOGGING_01_DBF
Name: DB login: ACCOUNT_DBF
Name: DB ranking: RANKING_DBF
Name: chdb01 DB: MANAGE_DBF
Name: DB01 DB: EoCRM_DBF_R
# # # # # # # # # # # # # # # # #
# # Create a page
# # # # # # # # # # # # # # # # #
Windows functions> IIS and ASP enabled services.
IIS> Add Website
> Site Name: EoCRM
> Physical Path: C: \ inetpub \ wwwroot \ EoCRM
> Binding:
> Type: http
> Ip address: ROOTIP, Network Ip or 127.0.0.1
> Port: 80
# # # # # # # # # # # # # # # # #
# # # # # # # # # # # # # # # # # # # # #
# # Configure page
# # # # # # # # # # # # # # # # # # # # #
EoCRM> common> asp> config.asp
Data Source = KILLEROOO PC \ SERVER KILLER or 127.0.0.1 or IP network
User Id = MSSQL login name
Password = password MSSQL
Dim cComponyIP: cComponyIP = "IP / Domain ON the panel is"
EoCRM> Open web.config with Notepad
Data Source = KILLEROOO PC \ SERVER KILLER or 127.0.0.1 or IP network
KILLEROOO server = SERVER \ SERVER KILLER or 127.0.0.1 or IP network
User ID = MSSQL login name
Password = password MSSQL
get the panel here: http://forum.ragezone.com/f457/re-release-eocrm-920978/
databases here: http://forum.ragezone.com/f457/re-upload-re-release-v15-920694/
I found this guide in another forum. re posting it here since their is nothing on eocrm for guides. Please remember that you have to modify the panel and the databases more to get more features to work. you need to use IIS. since this is ASP only ISS will work to run the website. If you already have a flyff server installed then you might be able to skip some of the odbc stuff and the database stuff.
credits to misterkid, gpotato for developing this panel, and audisbroder.
NOTE: YOU WILL NOT NEED TO USE ALL THE INFO HERE TO SET IT UP. ODBC ARE NOT REQUIRED TO MAKE THE PANEL WORK.
Last edited: