- Joined
- Jan 7, 2009
- Messages
- 23
- Reaction score
- 1
First of all, i'd like to say that this is my first work for RZ community and this is mostly for EP3. Let's start then!
Map Codes:
This is a compilation of a file from RAN that shows the codes... its useful for us gm's... cause when on the host pc we can't transfer to other map thru portal... here goes!
[0,0] [SG_Campus1F]
[2,0] [SG_Campus]
[****0] [StudyRoom1]
[****0] [StudyRoom2]
[103,0] [StudyRoom3]
[****0] [HistoryCentre]
[****0] [Library]
[106,0] [SocietyRoom]
[107,0] [ScienceCentre]
[102,0] [Dormitory]
[3,0] [SacredGateHole]
[4,0] [MP_Campus1F]
[5,0] [MP_Campus]
[120,0] [StudyRoom2]
[121,0] [StudyRoom1]
[123,0] [ArtCentre]
[122,0] [Library]
[124,0] [StudentCentre1]
[125,0] [StudentCentre2]
[126,0] [Dormitory]
[128,0] [2nd Dormitory]
[6,0] [MysticPeakHole]
[7,0] [PhoenixCampus1F] [8,0] [PhoenixCampus]
[130,0] [StudyRoom2] [131,0] [StudyRoom1]
[136,0] [RenovationCentre]
[135,0] [ScienceCentre]
[137,0] [Laboratory]
[138,0] [PracticeRoom]
[141,0] [SuppliesRoom]
[142,0] [Library]
[134,0] [Dormitory]
[9,0] [PhoenixHole]
[10,0] [LeonineCampus]
[11,0] [LeonineCampus1F]
[12,0] [LeonineCampus2F]
[13,0] [LeonineCampus3F]
[14,0] [LeonineCampusB1]
[15,0] [LeonineCampusB2]
[30,0] [LeonineCampusB3]
[17,0] [SG HolePassage]
[16,0] [TradingHole]
[161,0] [Carpark 1]
[162,0] [Carpark 2]
[18,0] [WharfPassage]
[19,0] [Hangout 1F_Ch1]
[20,0] [Hangout 2F_Ch1]
[21,0] [Hangout 3F_Ch1]
[150,0] [Hangout 1F_Ch2]
[152,0] [Hangout 2F_Ch2]
[154,0] [Hangout 3F_Ch2]
[151,0] [Hangout 1F_Ch3]
[153,0] [Hangout 2F_Ch3]
[155,0] [Hangout 3F_Ch3]
[26,0] [Trading3Passage]
[27,0] [Prison]
[28,0] [Middle Hole]
[29,0] [Root Hole]
[22,0] [MarketPlace]
[23,0] [PracticingYard]
[31,0] [WeddingHall]
//
// [201,0] [SG E-Room Front]
// [211,0] [SG E-Room]
//
// [202,0] [MP E-Room Front]
// [212,0] [MP E-Room]
//
// [203,0] [Pnx E-Room Front]
// [213,0] [Phoenix E-Room]
//
[204,0] [Trd E-Room Front]
[214,0] [Trading E-Room]
//
[***0] [PrisonTestZone]
[33,0] [Labatory7]
//
[46,0] [ep3_saintB_1F]
[35,0] [ep3_saintB_30F]
[36,0] [ep3_saintB_50F]
[37,0] [ep3_saintB_90F]
[38,0] [ep3_saintB_left]
[39,0] [ep3_saintB_right]
[40,0] [ep3_saintB_boss1]
[41,0] [ep3_saintB_boss2]
[42,0] [ep3_saintB_1B]
[43,0] [ep3_another_1]
[44,0] [ep3_another_2F]
[45,0] [ep3_another_3F]
//
[51,0] [ep3_saintB_51F]
[52,0] [ep3_saintB_52F]
Note: GM's can use /m2p command, this map code table is basically for it.
Example: /m2p 0,0,0,0
(This will move you to SacredGate 1F)
Now for the databases...
Links>
SQL Server Express Edition
http://forum.ragezone.com/redirector.php?url=http://go.microsoft.com/fwlink/?linkid=65212
SQL Server Management Studio
http://forum.ragezone.com/redirector.php?url=http://go.microsoft.com/fwlink/?linkid=65110
Quality Databases
I had a little problem when adding databases... When i entered the server it would always says "This name is not avaible" and it would be very annoying... Almost give up, really. But i found a way to make it work. 2 ways i mean.
1. Download a database. If the one you downloaded previously did show some errors, discard it, get a new one.
2. Now go Start>All Programs>Microsoft SQL Server 2005
3. Go to the database files folder and open RanUser.sql
4. Execute it, it will show an enourmous tab of errors, they look meany
:
5. Even if the errors, execute the other databases.
6. After that, right click databases and refresh.
7. Then right click the database you added, go to files.
8. Click on the ... after Owner.
9. Click add.
10. Check sa and press ok.
11. Press ok again.
12. And again.
13. Do it for the other 3 databases.
14. Now you will need to give the permission to another user, it must be there. The user is sa.
15. Expand Security>Logins and Right Click sa and select Properties.
16. At the left side tab, choose Server Roles.
17. Check sysadmin.
18. Click User Mapping.
19. Check all the databases there and all the permissions.
20. Click Status
21. Click on Grant and Enabled.
22. Press Ok.
23. Now try login in your account sa. At login screen, click at Windows Authentication and choose SQL Server Authentication. At username, type sa, at password, type 1234.
24. Open RanGame1 if it's not opened already, and execute.
25. Wait a bit.
26. Then Right Click Databases and click on Refresh. If a new database appeared, you did right!
27. Now do execute the other databases.
If the above solution didn't work, try this one, it's even more simple.
1. Go to your RAN Online server files, go at CFG folder, and at field0.ini, sesion.ini, sagent.ini, slogin.ini look for all the odbc_user_name and odbc_user_pass.
2. At those spaces there should be typed sa and 1234.
3. Remove sa and 1234 from all the username and password spaces. That way you force the RAN server to login on Windows Authentication.
4. Now, open MS SQL Server 2005 (Start>All Programs>Microsoft SQL Server 2005)
5. Login in Windows Authentication.
7. Open the database.
8. Execute it.
9. Right click databases and click on Refresh.
10. Now if a new database appeared, you did right!
11. Now do execute the other databases.
If this didn't help you, sorry, it worked for me.
Thanks alot!
Map Codes:
This is a compilation of a file from RAN that shows the codes... its useful for us gm's... cause when on the host pc we can't transfer to other map thru portal... here goes!
[0,0] [SG_Campus1F]
[2,0] [SG_Campus]
[****0] [StudyRoom1]
[****0] [StudyRoom2]
[103,0] [StudyRoom3]
[****0] [HistoryCentre]
[****0] [Library]
[106,0] [SocietyRoom]
[107,0] [ScienceCentre]
[102,0] [Dormitory]
[3,0] [SacredGateHole]
[4,0] [MP_Campus1F]
[5,0] [MP_Campus]
[120,0] [StudyRoom2]
[121,0] [StudyRoom1]
[123,0] [ArtCentre]
[122,0] [Library]
[124,0] [StudentCentre1]
[125,0] [StudentCentre2]
[126,0] [Dormitory]
[128,0] [2nd Dormitory]
[6,0] [MysticPeakHole]
[7,0] [PhoenixCampus1F] [8,0] [PhoenixCampus]
[130,0] [StudyRoom2] [131,0] [StudyRoom1]
[136,0] [RenovationCentre]
[135,0] [ScienceCentre]
[137,0] [Laboratory]
[138,0] [PracticeRoom]
[141,0] [SuppliesRoom]
[142,0] [Library]
[134,0] [Dormitory]
[9,0] [PhoenixHole]
[10,0] [LeonineCampus]
[11,0] [LeonineCampus1F]
[12,0] [LeonineCampus2F]
[13,0] [LeonineCampus3F]
[14,0] [LeonineCampusB1]
[15,0] [LeonineCampusB2]
[30,0] [LeonineCampusB3]
[17,0] [SG HolePassage]
[16,0] [TradingHole]
[161,0] [Carpark 1]
[162,0] [Carpark 2]
[18,0] [WharfPassage]
[19,0] [Hangout 1F_Ch1]
[20,0] [Hangout 2F_Ch1]
[21,0] [Hangout 3F_Ch1]
[150,0] [Hangout 1F_Ch2]
[152,0] [Hangout 2F_Ch2]
[154,0] [Hangout 3F_Ch2]
[151,0] [Hangout 1F_Ch3]
[153,0] [Hangout 2F_Ch3]
[155,0] [Hangout 3F_Ch3]
[26,0] [Trading3Passage]
[27,0] [Prison]
[28,0] [Middle Hole]
[29,0] [Root Hole]
[22,0] [MarketPlace]
[23,0] [PracticingYard]
[31,0] [WeddingHall]
//
// [201,0] [SG E-Room Front]
// [211,0] [SG E-Room]
//
// [202,0] [MP E-Room Front]
// [212,0] [MP E-Room]
//
// [203,0] [Pnx E-Room Front]
// [213,0] [Phoenix E-Room]
//
[204,0] [Trd E-Room Front]
[214,0] [Trading E-Room]
//
[***0] [PrisonTestZone]
[33,0] [Labatory7]
//
[46,0] [ep3_saintB_1F]
[35,0] [ep3_saintB_30F]
[36,0] [ep3_saintB_50F]
[37,0] [ep3_saintB_90F]
[38,0] [ep3_saintB_left]
[39,0] [ep3_saintB_right]
[40,0] [ep3_saintB_boss1]
[41,0] [ep3_saintB_boss2]
[42,0] [ep3_saintB_1B]
[43,0] [ep3_another_1]
[44,0] [ep3_another_2F]
[45,0] [ep3_another_3F]
//
[51,0] [ep3_saintB_51F]
[52,0] [ep3_saintB_52F]
Note: GM's can use /m2p command, this map code table is basically for it.
Example: /m2p 0,0,0,0
(This will move you to SacredGate 1F)
Now for the databases...
Links>
SQL Server Express Edition
http://forum.ragezone.com/redirector.php?url=http://go.microsoft.com/fwlink/?linkid=65212
SQL Server Management Studio
http://forum.ragezone.com/redirector.php?url=http://go.microsoft.com/fwlink/?linkid=65110
Quality Databases
To view the content, you need to sign in or register
I had a little problem when adding databases... When i entered the server it would always says "This name is not avaible" and it would be very annoying... Almost give up, really. But i found a way to make it work. 2 ways i mean.
1. Download a database. If the one you downloaded previously did show some errors, discard it, get a new one.
2. Now go Start>All Programs>Microsoft SQL Server 2005
3. Go to the database files folder and open RanUser.sql
4. Execute it, it will show an enourmous tab of errors, they look meany
:5. Even if the errors, execute the other databases.
6. After that, right click databases and refresh.
7. Then right click the database you added, go to files.
8. Click on the ... after Owner.
9. Click add.
10. Check sa and press ok.
11. Press ok again.
12. And again.
13. Do it for the other 3 databases.
14. Now you will need to give the permission to another user, it must be there. The user is sa.
15. Expand Security>Logins and Right Click sa and select Properties.
16. At the left side tab, choose Server Roles.
17. Check sysadmin.
18. Click User Mapping.
19. Check all the databases there and all the permissions.
20. Click Status
21. Click on Grant and Enabled.
22. Press Ok.
23. Now try login in your account sa. At login screen, click at Windows Authentication and choose SQL Server Authentication. At username, type sa, at password, type 1234.
24. Open RanGame1 if it's not opened already, and execute.
25. Wait a bit.
26. Then Right Click Databases and click on Refresh. If a new database appeared, you did right!
27. Now do execute the other databases.
If the above solution didn't work, try this one, it's even more simple.
1. Go to your RAN Online server files, go at CFG folder, and at field0.ini, sesion.ini, sagent.ini, slogin.ini look for all the odbc_user_name and odbc_user_pass.
2. At those spaces there should be typed sa and 1234.
3. Remove sa and 1234 from all the username and password spaces. That way you force the RAN server to login on Windows Authentication.
4. Now, open MS SQL Server 2005 (Start>All Programs>Microsoft SQL Server 2005)
5. Login in Windows Authentication.
7. Open the database.
8. Execute it.
9. Right click databases and click on Refresh.
10. Now if a new database appeared, you did right!
11. Now do execute the other databases.
If this didn't help you, sorry, it worked for me.
Thanks alot!
Last edited:
