player.go 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314
  1. package player
  2. import (
  3. "errors"
  4. "gadmin/config"
  5. "gadmin/internal/admin/consts"
  6. "gadmin/internal/gorm/model"
  7. "gadmin/internal/gorm/query"
  8. model2 "leafstalk/covenant/model"
  9. "strconv"
  10. "sync"
  11. "github.com/sirupsen/logrus"
  12. "github.com/spf13/cast"
  13. "gorm.io/gorm"
  14. )
  15. const (
  16. maxMapStoreLimit = 50000
  17. )
  18. var (
  19. AllRoleData = make(map[int]*RoleData, 0)
  20. lock sync.RWMutex
  21. userStampMap = make(map[int64]int32)
  22. userChannelLock sync.RWMutex
  23. userChannelMap = make(map[int64]string, 0)
  24. )
  25. type RoleData struct {
  26. ID int `json:"id"`
  27. Type int `json:"type"`
  28. Evolution int `json:"evolution"`
  29. Level int `json:"level"`
  30. Break int `json:"break"`
  31. }
  32. // GetRoleData 根据角色ID获取角色信息
  33. func GetRoleData(id int) *RoleData {
  34. idx := strconv.Itoa(id)
  35. if len(idx) == 9 {
  36. level, _ := strconv.Atoi(idx[5:8])
  37. role := &RoleData{
  38. ID: id,
  39. Type: cast.ToInt(idx[:1]),
  40. Evolution: cast.ToInt(idx[4:5]),
  41. Level: level,
  42. Break: id % 10,
  43. }
  44. return role
  45. }
  46. if len(idx) == 10 {
  47. level, _ := strconv.Atoi(idx[6:9])
  48. role := &RoleData{
  49. ID: id,
  50. Type: cast.ToInt(idx[:2]),
  51. Evolution: cast.ToInt(idx[5:6]),
  52. Level: level,
  53. Break: id % 10,
  54. }
  55. return role
  56. }
  57. logrus.Warnf("GetRoleData role = nil, id:%+v", id)
  58. return nil
  59. }
  60. func GetUserChannel(userId int64) string {
  61. if userId == 0 {
  62. return "0"
  63. }
  64. //if val, ok := userChannelMap[userId]; ok {
  65. // return val
  66. //}
  67. userChannelLock.RLock()
  68. defer userChannelLock.RUnlock()
  69. u := query.Use(config.DB).PlayerChannel
  70. user, err := u.Where(u.Playerid.Eq(userId)).Select(u.ChannelID).First()
  71. if err != nil && !errors.Is(err, gorm.ErrRecordNotFound) {
  72. logrus.Errorf("GetUserChannel query user failed:%v", err)
  73. return "0"
  74. }
  75. if user == nil {
  76. logrus.Errorf("GetUserChannel 未查到玩家%v渠道ID..\n", userId)
  77. return "0"
  78. } else {
  79. return user.ChannelID
  80. }
  81. //if user == nil {
  82. // userChannelMap[userId] = "0"
  83. //} else {
  84. // userChannelMap[userId] = user.ChannelID
  85. //}
  86. //
  87. //if len(userChannelMap) >= maxMapStoreLimit {
  88. // userChannelMap = make(map[int64]string, 0)
  89. //}
  90. //return userChannelMap[userId]
  91. }
  92. func GetUserStamp(userId int64) int32 {
  93. if val, ok := userStampMap[userId]; ok {
  94. return val
  95. }
  96. if userId == 0 {
  97. return 0
  98. }
  99. var (
  100. user *model.PlayerAttr
  101. err error
  102. )
  103. lock.RLock()
  104. defer func() {
  105. if len(userStampMap) > maxMapStoreLimit {
  106. userStampMap = make(map[int64]int32)
  107. }
  108. lock.RUnlock()
  109. }()
  110. for _, DB := range config.GDBGroup {
  111. u := query.Use(DB).PlayerAttr
  112. user, err = u.Where(u.Playerid.Eq(userId)).Select(u.CreateTime).First()
  113. if err != nil && !errors.Is(err, gorm.ErrRecordNotFound) {
  114. logrus.Errorf("GetUserStamp query user failed:%v", err)
  115. return 0
  116. }
  117. if user == nil {
  118. continue
  119. } else {
  120. userStampMap[userId] = int32(user.CreateTime.Unix())
  121. break
  122. }
  123. }
  124. if user == nil {
  125. //userStampMap[userId] = 0
  126. logrus.Errorf("GetUserStamp 未查到玩家注册时间..")
  127. return 0
  128. }
  129. return userStampMap[userId]
  130. }
  131. // GetServerIDByUserId 通过玩家ID获取所在的数据库
  132. func GetServerIDByUserId(playerId int64) (serverID int32, err error) {
  133. _, lineId := model2.SplitDocId(playerId)
  134. if DB, ok := config.GDBGroup[lineId]; ok && DB != nil {
  135. return int32(lineId), nil
  136. }
  137. var models *model.PlayerAttr
  138. for k, DB := range config.GDBGroup {
  139. logrus.Warnf("GetDBByUserId DB:%+v", k)
  140. var (
  141. q = query.Use(DB).PlayerAttr
  142. m = q.Where(q.Playerid.Eq(playerId))
  143. )
  144. if err = m.Scan(&models); err != nil {
  145. return
  146. }
  147. logrus.Warnf("GetDBByUserId models:%+v", models)
  148. if models != nil {
  149. serverID = int32(k)
  150. break
  151. }
  152. }
  153. if serverID != 0 && models != nil {
  154. return serverID, nil
  155. }
  156. return 0, errors.New("用户不存在")
  157. }
  158. // GetAccIDByUserId 通过玩家ID获取accId
  159. func GetAccIDByUserId(playerId int64) (accID int64, err error) {
  160. var models *model.PlayerAttr
  161. for _, DB := range config.GDBGroup {
  162. var (
  163. q = query.Use(DB).PlayerAttr
  164. m = q.Where(q.Playerid.Eq(playerId))
  165. )
  166. if err = m.Scan(&models); err != nil {
  167. return
  168. }
  169. if models != nil {
  170. break
  171. }
  172. }
  173. if models != nil {
  174. return models.AccID, nil
  175. }
  176. return 0, errors.New("用户不存在")
  177. }
  178. // GetAccIDByOpenId 通过openID获取accId
  179. func GetAccIDByOpenId(openID string) (accID int64, err error) {
  180. var models *model.PlayerAttr
  181. for _, DB := range config.GDBGroup {
  182. var (
  183. q = query.Use(DB).PlayerAttr
  184. m = q.Where(q.OpenID.Eq(openID))
  185. )
  186. if err = m.Scan(&models); err != nil {
  187. return
  188. }
  189. if models != nil {
  190. break
  191. }
  192. }
  193. if models != nil {
  194. return models.AccID, nil
  195. }
  196. return 0, errors.New("用户不存在")
  197. }
  198. // GetAttrByUserId 通过User获取user attr
  199. func GetAttrByUserId(playerId int64) (attr *model.PlayerAttr, err error) {
  200. var models *model.PlayerAttr
  201. for _, DB := range config.GDBGroup {
  202. var (
  203. q = query.Use(DB).PlayerAttr
  204. m = q.Where(q.Playerid.Eq(playerId))
  205. )
  206. if err = m.Scan(&models); err != nil {
  207. return
  208. }
  209. if models != nil {
  210. break
  211. }
  212. }
  213. if models != nil {
  214. return models, nil
  215. }
  216. return nil, errors.New("用户不存在")
  217. }
  218. func GetAccountByAccId(accId int64) (account *model.UserAccount, err error) {
  219. var models *model.UserAccount
  220. q := config.LDB.Scopes(model.UserAccountTable(models, accId)).Where("accId = ?", accId)
  221. if err := q.Scan(&models).Error; err != nil {
  222. return nil, err
  223. }
  224. if models != nil {
  225. return models, nil
  226. }
  227. return nil, errors.New("账号不存在")
  228. }
  229. // GetDBByUserId 通过玩家ID获取所在的数据库
  230. func GetDBByUserId(playerId int64) (Db int, err error) {
  231. serverID, err := GetServerIDByUserId(playerId)
  232. if err != nil {
  233. return 0, err
  234. }
  235. if serverID > 0 {
  236. return GetDBByServerID(int(serverID))
  237. }
  238. return 0, errors.New("用户不存在")
  239. }
  240. // GetDBByServerID 通过serverID获取数据库
  241. func GetDBByServerID(serverID int) (int, error) {
  242. // 目前serverId 和db是对应关系,后面如果不是可以在这里做处理
  243. return serverID, nil
  244. }
  245. // GetDBByPlayerAttr 通过用户信息获取数据库(兼容合服)
  246. func GetDBByPlayerAttr(playerAttr *model.PlayerAttr) (int, error) {
  247. // 目前serverId 和db是对应关系,后面如果不是可以在这里做处理
  248. return int(playerAttr.Line), nil
  249. }
  250. func GetUserFlag(serverID int, userId int64) int32 {
  251. u := query.Use(config.GDBGroup[serverID]).PlayerAttr
  252. user, err := u.Where(u.Playerid.Eq(userId)).Select(u.Flag).First()
  253. if err != nil && !errors.Is(err, gorm.ErrRecordNotFound) {
  254. logrus.Errorf("GetUserFlag query user failed:%v", err)
  255. return 0
  256. }
  257. if user == nil {
  258. return consts.UserFlagOld
  259. } else {
  260. return user.Flag
  261. }
  262. }