mirror of
https://github.com/PretendoNetwork/friends.git
synced 2025-04-02 11:01:46 -04:00
42 lines
1 KiB
Go
42 lines
1 KiB
Go
package database_wiiu
|
|
|
|
import (
|
|
"database/sql"
|
|
|
|
"github.com/PretendoNetwork/friends/database"
|
|
"github.com/PretendoNetwork/nex-go/v2/types"
|
|
friends_wiiu_types "github.com/PretendoNetwork/nex-protocols-go/v2/friends-wiiu/types"
|
|
)
|
|
|
|
// GetUserMii returns the users Mii
|
|
func GetUserMii(pid uint32) (friends_wiiu_types.MiiV2, error) {
|
|
mii := friends_wiiu_types.NewMiiV2()
|
|
|
|
var name string
|
|
var unknown1 uint8
|
|
var unknown2 uint8
|
|
var data []byte
|
|
var datetime uint64
|
|
|
|
row, err := database.Manager.QueryRow(`SELECT name, unknown1, unknown2, data, unknown_datetime FROM wiiu.mii WHERE pid=$1`, pid)
|
|
if err != nil {
|
|
return mii, err
|
|
}
|
|
|
|
err = row.Scan(&name, &unknown1, &unknown2, &data, &datetime)
|
|
if err != nil {
|
|
if err == sql.ErrNoRows {
|
|
return mii, database.ErrPIDNotFound
|
|
} else {
|
|
return mii, err
|
|
}
|
|
}
|
|
|
|
mii.Name = types.NewString(name)
|
|
mii.Unknown1 = types.NewUInt8(unknown1)
|
|
mii.Unknown2 = types.NewUInt8(unknown2)
|
|
mii.MiiData = types.NewBuffer(data)
|
|
mii.Datetime = types.NewDateTime(datetime)
|
|
|
|
return mii, nil
|
|
}
|