public
static
function
GetCharactersList
(
$user
,
$pass
)
{
if
(
Auth
:
:
IsValidLogin
(
$user
,
$pass
)
)
{
global
$config
;
$accountId
=
Auth
:
:
GetAccountId
(
$user
)
;
$finalArray
=
array
(
)
;
// Define a mapping of class names to numeric values
$classMapping
=
array
(
"Warrior"
=
>
1
,
"Mage"
=
>
8
,
// Add more mappings for other classes if needed
)
;
foreach
(
$config
[
'mysqli'
]
[
'realms'
]
as
$realm
)
{
$mysqli
=
mysqli_connect
(
$realm
[
'hostname'
]
,
$realm
[
'user'
]
,
$realm
[
'pass'
]
,
$realm
[
'database'
]
,
$realm
[
'port'
]
)
;
mysqli_set_charset
(
$mysqli
,
"utf8"
)
;
if
(
$query
=
$mysqli
-
>
prepare
(
"SELECT
                ac.characterName AS name,
                dl.additional_data AS class
            FROM
                account_character AS ac
            LEFT JOIN
                data_logs AS dl ON ( dl.account_id = ac.accountId AND dl.source_oid = ac.characterId )
            WHERE
                ac.accountId = ? AND dl.data_name = 'CHARACTER_CREATED'"
)
)
{
$query
-
>
bind_param
(
'i'
,
$accountId
)
;
$query
-
>
execute
(
)
;
$query
-
>
bind_result
(
$charName
,
$charClass
)
;
$realmArray
=
array
(
)
;
while
(
$query
-
>
fetch
(
)
)
{
$rowArray
[
'realm'
]
=
$realm
[
'name'
]
;
$rowArray
[
'name'
]
=
$charName
;
$row_array
[
'race'
]
=
$charRace
;
// Check if the class exists in the mapping array
if
(
array_key_exists
(
$charClass
,
$classMapping
)
)
{
$rowArray
[
'class'
]
=
$classMapping
[
$charClass
]
;
}
else
{
// If class is not found in mapping, keep the original class name
$rowArray
[
'class'
]
=
$charClass
;
}
array_push
(
$realmArray
,
$rowArray
)
;
}
if
(
!
empty
(
$realmArray
)
)
array_push
(
$finalArray
,
$realmArray
)
;
$query
-
>
close
(
)
;
}
}
if
(
!
empty
(
$finalArray
)
)
{
echo
json_encode
(
$finalArray
,
JSON_PRETTY_PRINT
)
;
}
}
}