func GetPlayerByUserId(partnerId, serverId int, userId string) (playerObj *player.Player, exists bool, err error) { var id string var name string var lv int var exp int var vipExp int var diamond int var gold int err = dal.GameDB.QueryRow(getPlayerByUserIdCommand, partnerId, serverId, userId).Scan(&id, &name, &partnerId, &serverId, &userId, &lv, &exp, &vipExp, &diamond, &gold) if err != nil { if err == sql.ErrNoRows { // 重置err,使其为nil;因为这代表的是没有查找到数据,而不是真正的错误 err = nil return } else { dal.WriteScanError(getPlayerByUserIdCommand, err) return } } playerObj = player.New(id, name, partnerId, serverId, userId, lv, exp, vipExp, diamond, gold) exists = true return }
func GetList() (systemConfigMap map[string]*systemConfig.SystemConfigItem, err error) { rows, err := dal.GameModelDB.Query(getListCommand) if err != nil { return } defer rows.Close() systemConfigMap = make(map[string]*systemConfig.SystemConfigItem) for rows.Next() { var configKey string var configValue string if err = rows.Scan(&configKey, &configValue); err != nil { dal.WriteScanError(getListCommand, err) return } systemConfigMap[configKey] = systemConfig.New(configKey, configValue) } return }
func GetList() (nameAndIdMap map[string]string, err error) { rows, err := dal.GameDB.Query(getListCommand) if err != nil { return } defer rows.Close() nameAndIdMap = make(map[string]string) for rows.Next() { var name string var id string if err = rows.Scan(&name, &id); err != nil { dal.WriteScanError(getListCommand, err) return } nameAndIdMap[name] = id } return }
func GetList(serverGroupId int) (config *serverGroupSetting.ServerGroupSettingConfig, exists bool, err error) { var promotionIfOpen int var requestLogIfOpen int var saasUrl string var appErrorLevel int var marqueeInterval int err = dal.GameModelDB.QueryRow(getListCommand, serverGroupId).Scan(&serverGroupId, &promotionIfOpen, &requestLogIfOpen, &saasUrl, &appErrorLevel, &marqueeInterval) if err != nil { if err == sql.ErrNoRows { // 重置err,使其为nil;因为这代表的是没有查找到数据,而不是真正的错误 err = nil return } else { dal.WriteScanError(getListCommand, err) return } } config = serverGroupSetting.New(serverGroupId, promotionIfOpen, requestLogIfOpen, saasUrl, appErrorLevel, marqueeInterval) exists = true return }