|
|
| (37 intermediate revisions by 3 users not shown) |
| Line 2: |
Line 2: |
| == Server Setup == | | == Server Setup == |
| === Download Files === | | === Download Files === |
| * [magnet:?xt=urn:btih:938C769EC2BEEE7C7F381570B93A861A60BD4FE5&dn=i25Binaries_InsurancePolicy.7z&tr=udp%3a%2f%2ftracker.openbittorrent.com%3a80%2fannounce&tr=udp%3a%2f%2ftracker.opentrackr.org%3a1337%2fannounce i25 Binaries Torrent] | | * [[i25 Downloads]] |
| ** [MD5]43CF2C67D48CDAE9709E785A3EE7DD5E
| | |
| ** [SHA256]B34D398F7E9A06832A9069F7156F59B53EAB395D0CE155D031CEB09DD47BEAB1
| | === Online Tools === |
| * [https://www.microsoft.com/en-gb/sql-server/sql-server-editions-express SQL Express Edition]
| | * [[i25 Online Tools]] |
| * [https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017 SQL Management Studio]
| |
| * [https://pastebin.com/hJFJ1D1r Start Server.bat] | |
| * [https://pastebin.com/MwvdMQNx CreateAccount.php] - Used to generate SQL code for inserting account via SMSS
| |
| * [https://pastebin.com/bThfiqRt Create Account with PowerShell Script]
| |
|
| |
|
| === Setup Local Server === | | === Setup Local Server === |
| # Install SQL Server 2017 Express Edition
| | * [[I25 Server Setup]] |
| # Choose Basic when installing and when given the option choose to install SSMS.
| |
| # Open up wherever you extracted the i25 Binaries folder and navigate to data\server\db
| |
| # Open up chat_server.cfg and account_server.cfg
| |
| #; You will see something like this.
| |
| #: SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=NS319069\SCORE;Uid=sa;Pwd=FinallyFree!;"
| |
| #; Change this to
| |
| #: SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=localhost\SQLEXPRESS;Uid=sa;Pwd=password;"
| |
| #* You can change the password to whatever you would like. For this example I will be just using password.
| |
| #* Now open up server.cfg and change all the ips to localhost (Note : You could also set these to your local ip if you know it.)
| |
| #; At the top of the file you will see this.The IP will be set to whatever you previous set it to.
| |
| #: DBServer 192.168.0.1 18717
| |
| #: ShardName Bree
| |
| #: AuthServer 192.168.0.1 2104
| |
| #: DefaultAccessLevel 0
| |
| #: NoStats 1
| |
| #* Change the ShardName to whatever you would like and add 2 slashes infront of AuthServer. And add UseFakeAuth 1 under NoStats 1
| |
| #; It should now look like this
| |
| #: DBServer localhost 18717
| |
| #: ShardName ShardName
| |
| #: //AuthServer 192.168.0.1 2104
| |
| #: DefaultAccessLevel 0
| |
| #: NoStats 1
| |
| #: UseFakeAuth 1
| |
| # Okay now extract the dbschema.rar found in your i25 folder. We will be using these later.
| |
| # Open up SQL Server Management Studio (SSMS which you installed in the first step). Your one will look slightly different and hit Connect.
| |
| # Now we have to enable SQL logins so that the databases can connect. We need to enable them and the sa login so that user can login to the database.
| |
| # If you look to the left panel you will see the object explorer and your connection. Right click it and enter properties.
| |
| # When this window comes up hit Security to the left and enable sql server and windows authentication. Then click ok.
| |
| # In the same panel you used before navigate to Security -> Logins then right click and enter properties the sa user.
| |
| # In this window set the password to the same password you set back at step 4
| |
| # Once you are done there. Choose Status from the left panel in this same window and set login to enabled and hit ok.
| |
| # Okay now navigate back to your i25 folder and open the dbschema folder I previously had you extract and open up cohauc.sql in SQL Server Management Studio.
| |
| # You will see these 2 lines at the top of the file opened
| |
| #* ( NAME = N'cohauc', FILENAME = N'C:\mssql\MSSQL11.SCORE\MSSQL\DATA\cohauc.mdf' , SIZE = 157440KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
| |
| #* ( NAME = N'cohauc_log', FILENAME = N'C:\mssql\MSSQL11.SCORE\MSSQL\DATA\cohauc_log.ldf' , SIZE = 353216KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
| |
| # What you want to do is set the first part of these directory listings to where your SQL Server is located for example, I set my to D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL because that is where my SQL Server is. So my would become:
| |
| #* ( NAME = N'cohauc', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\cohauc.mdf' , SIZE = 157440KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
| |
| #* ( NAME = N'cohauc_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\cohauc_log.ldf' , SIZE = 353216KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
| |
| # Once done click the Execute button. And do this again for both the cohauth and cohchat.
| |
| # Once you have done that you can now start up your server. Navigate back to your i25 files and start up dbserver and dblauncher
| |
| #* Note : you will have to fix up these shortcuts so they point back to their intended destinations.
| |
| # Go to your City of Heroes folder and make a shortcut of score.exe adding
| |
| #* score.exe -db 127.0.0.1 -console -patchdir score -noversioncheck -project "coh"
| |
| # Login and Enjoy!
| |
|
| |
|
| == Setup Auth Server == | | == Setup Auth Server == |
| # The first thing you are going to want to do is set the ips in server.cfg to your Internal/Local ip. Then you will remove the slashes from the front of authserver and putting them infront of UseFakeAuth 1 and that is nolonger necessary.
| | * [[I25_Server_Setup#Setup_Auth_Server]] |
| #* DBServer 192.168.0.48 18717
| |
| #* ShardName Personality
| |
| #* AuthServer 192.168.0.48 2104
| |
| #* DefaultAccessLevel 0
| |
| #* NoStats 1 | |
| #* //UseFakeAuth 1
| |
| # Open up ODBC Data Sources.
| |
| #* Click File DSN then click add to the right.
| |
| #* Choose ODBC Driver 17 for SQL Server. Click Next.
| |
| #* Enter AuthDB into the box and hit next then finish.
| |
| #* It will then say something like ‘Which SQL Server would you like to connect to?’
| |
| #** Type localhost\SQLEXPRESS and hit next.
| |
| #* Choose with SQL Auth enter sa into username and the password you use previously.
| |
| #* Tick choose change default database to and select cohauth and hit next.
| |
| #* After this hit finish then ‘Test Data source’ this will test the auth database connection to your main database if it successful congrats :D
| |
|
| |
|
| == Setup Auction Server == | | == Setup Auction Server == |
| # Create auction_server.cfg in C:\COH\data\server\db.
| | * [[I25_Server_Setup#Setup_Auction_Server]] |
| #* ShardIp 127.0.0.1
| |
| #* SqlDbName cohauc
| |
| #* SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=localhost\SQLEXPRESS;Uid=sa;Pwd=YOURL33TPASS;"
| |
| # Start AuctionServer64.exe | |
|
| |
|
| == Setup == | | == Setup using Virtual Server Image == |
| == Setup ==
| | * [[i25 Community Virtual Machine]] |
|
| |
|
| == Port Forwards == | | == Port Forwards == |
| === Port 11228(TCP) ===
| | * [[I25_Server_Setup#Port_Forwards]] |
| === Port 18718(UDP) ===
| |
| === Port 18717(UDP) ===
| |
|
| |
|
| == Common Questions == | | == Common Questions == |
| === How do I create an account? ===
| | * [[I25 FAQ]] |
| * You can use the PowerShell script in downloads or execute a query against the database manually. | |
| * Create NEW USER: test / password
| |
| ** INSERT INTO cohauth.dbo.user_account (account, uid, forum_id, pay_stat) VALUES ('test', 1, 1, 1014);
| |
| ** INSERT INTO cohauth.dbo.user_auth (account, password, salt, hash_type) VALUES ('test', CONVERT(BINARY(128),'46ffce3efcfe83bfa205b076d7c2084b9dcf04cdb26f9019103cde29779d26a85216b2c0f43ba1a8fb9b7fa22f05a949bf4edc314af27629e8fc23014e77a24d'), 0, 1);
| |
| ** INSERT INTO cohauth.dbo.user_data (uid, user_data) VALUES (1, 0x0080C2E000D00B0C000000000CB40058);
| |
| ** INSERT INTO cohauth.dbo.user_server_group (uid, server_group_id) VALUES (1, 1)
| |
| | |
| === How do I make a GM Character? ===
| |
| * UPDATE [cohdb].[dbo].[Ents] SET [AccessLevel] = 10 WHERE [Name] = 'charnamehere'
| |
| * Login to the game and type /mmm to bring up an admin menu. All commands are also listed in Commands.cfg
| |
| | |
| === Why does my server show offline? ===
| |
| * First make sure you've added your server into the database. You can do so with the code below.
| |
| ** INSERT INTO cohauth.dbo.server (id, name, ip, inner_ip, ageLimit, pk_flag, server_group_id) VALUES (1, 'Bree', '127.0.0.1', '127.0.0.1', 0, 0, 1);
| |