Config.pm 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  1. package OpenSim::UserServer::Config;
  2. use strict;
  3. our %SYS_SQL = (
  4. select_user_by_name =>
  5. "select * from users where username=? and lastname=?",
  6. select_user_by_uuid =>
  7. "select * from users where uuid=?",
  8. create_user =>
  9. "insert into users values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
  10. );
  11. our @USERS_COLUMNS = (
  12. "UUID",
  13. "username",
  14. "lastname",
  15. "passwordHash",
  16. "passwordSalt",
  17. "homeRegion",
  18. "homeLocationX",
  19. "homeLocationY",
  20. "homeLocationZ",
  21. "homeLookAtX",
  22. "homeLookAtY",
  23. "homeLookAtZ",
  24. "created",
  25. "lastLogin",
  26. "userInventoryURI",
  27. "userAssetURI",
  28. "profileCanDoMask",
  29. "profileWantDoMask",
  30. "profileAboutText",
  31. "profileFirstText",
  32. "profileImage",
  33. "profileFirstImage",
  34. );
  35. # copied from opensim
  36. our @classified_categories = (
  37. { category_id => 1, category_name => "Shopping" },
  38. { category_id => 2, category_name => "Land Rental" },
  39. { category_id => 3, category_name => "Property Rental" },
  40. { category_id => 4, category_name => "Special Attraction" },
  41. { category_id => 5, category_name => "New Products" },
  42. { category_id => 6, category_name => "Employment" },
  43. { category_id => 7, category_name => "Wanted" },
  44. { category_id => 8, category_name => "Service" },
  45. { category_id => 9, category_name => "Personal" },
  46. );
  47. our @event_categories = ();
  48. our @event_notifications = ();
  49. our @gestures =();
  50. our @global_textures = (
  51. {
  52. cloud_texture_id => "dc4b9f0b-d008-45c6-96a4-01dd947ac621",
  53. moon_texture_id => "ec4b9f0b-d008-45c6-96a4-01dd947ac621",
  54. sun_texture_id => "cce0f112-878f-4586-a2e2-a8f104bba271",
  55. },
  56. );
  57. our @initial_outfit = (
  58. { folder_name => "Nightclub Female", gender => "female" }
  59. );
  60. our @inventory_lib_owner = ({ agent_id => "11111111-1111-0000-0000-000100bba000" });
  61. our @inventory_lib_root = ({ folder_id => "00000112-000f-0000-0000-000100bba000" });
  62. our @inventory_root = ({ folder_id => "2eb27bc2-22ee-48db-b2e9-5c79a6582919" });
  63. our @inventory_skel_lib = (
  64. {
  65. folder_id => "00000112-000f-0000-0000-000100bba000",
  66. name => "OpenSim Library",
  67. parent_id => "00000000-0000-0000-0000-000000000000",
  68. type_default => -1,
  69. version => 1,
  70. },
  71. {
  72. folder_id => "00000112-000f-0000-0000-000100bba001",
  73. name => "Texture Library",
  74. parent_id => "00000112-000f-0000-0000-000100bba000",
  75. type_default => -1,
  76. version => 1,
  77. },
  78. );
  79. our @inventory_skeleton = (
  80. {
  81. folder_id => "2eb27bc2-22ee-48db-b2e9-5c79a6582919",
  82. name => "My Inventory",
  83. parent_id => "00000000-0000-0000-0000-000000000000",
  84. type_default => 8,
  85. version => 1,
  86. },
  87. {
  88. folder_id => "6cc20d86-9945-4997-a102-959348d56821",
  89. name => "Textures",
  90. parent_id => "2eb27bc2-22ee-48db-b2e9-5c79a6582919",
  91. type_default => 0,
  92. version => 1,
  93. },
  94. {
  95. folder_id => "840b747f-bb7d-465e-ab5a-58badc953484",
  96. name => "Clothes",
  97. parent_id => "2eb27bc2-22ee-48db-b2e9-5c79a6582919",
  98. type_default => 5,
  99. version => 1,
  100. },
  101. {
  102. folder_id => "37039005-7bbe-42a2-aa12-6bda453f37fd",
  103. name => "Objects",
  104. parent_id => "2eb27bc2-22ee-48db-b2e9-5c79a6582919",
  105. type_default => 6,
  106. version => 1,
  107. },
  108. );
  109. our @login_flags = (
  110. {
  111. daylight_savings => "N",
  112. ever_logged_in => "Y",
  113. gendered => "Y",
  114. stipend_since_login => "N",
  115. },
  116. );
  117. our @ui_config = ({ allow_first_life => "Y" });
  118. 1;