.USERS. replacement in 2 Moons 1.8git

TheAlex · May 5th 2018, 4:07pm

Derzeit versuche ich einen Mod wieder lauffähig zu bekommen, allerdings suche ich nun schon seit einiger Zeit nach der passenden Variable für ".USERS." in der 1.8Git.

Hoffe mir kann da jemand weiterhelfen

Danter14 · May 5th 2018, 4:49pm

replace .USERS. by %%USERS%%

TheAlex · May 6th 2018, 2:36pm

I think the problem is the complete query:

PHP Source Code

($GLOBALS['DATABASE']->countquery("SELECT (SELECT COUNT(*) FROM ".USERS." WHERE `universe` = '".$UNI."' AND `username` = '".$GLOBALS['DATABASE']->sql_escape($UserName)."') + (SELECT COUNT(*) FROM ".USERS_VALID." WHERE `universe` = '".$UNI."' AND `username` = '".$GLOBALS['DATABASE']->sql_escape($UserName)."')") != 0);

how to replace the $globals i know but the probelm is to rebuild the complete Query. Ive tried the %%Variable%% but the query wont work correct.

Danter14 · May 6th 2018, 2:41pm

Yes you had to change the entire sql query with the new 1.8 queries.

TheAlex · May 6th 2018, 2:43pm

can u get me an example with this query, than i know how to change the entire querys in the code.

Its long ago that iam code with 2Moons, so iam out off knowledge^^

Danter14 · May 6th 2018, 4:24pm

I'll do it to you on my way home

TheAlex · May 7th 2018, 10:40am

Thx for youre help

Danter14 · May 7th 2018, 1:01pm

PHP Source Code

$db = Database::get();
$sql = "SELECT (
SELECT COUNT(*)
FROM %%USERS%%
WHERE universe = :universe
AND username = :userName
) + (
SELECT COUNT(*)
FROM %%USERS_VALID%%
WHERE universe = :universe
AND username = :userName
) as count;";
$countUsername = $db->selectSingle($sql, array(
':universe' => Universe::current(),
':userName' => $userName,
), 'count');

Display All

PHP Source Code

PHP Source Code

Share