.USERS. replacement in 2 Moons 1.8git

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • .USERS. replacement in 2 Moons 1.8git

      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
    • replace .USERS. by %%USERS%%
      2moons 2.0 OPEN Demo
      Thank you to send by ticket or message or via the forum in the part made for this purpose for all problems.

      Download version 2.0 here
      Shop Mods and Games HERE

      -------------------------------------------------------
      My personal game
      OUnivers - Open
      Xterium - Comming Soon - No code is taken from available versions
    • I think the problem is the complete query:

      PHP Source Code

      1. ($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.
    • Yes you had to change the entire sql query with the new 1.8 queries.
      2moons 2.0 OPEN Demo
      Thank you to send by ticket or message or via the forum in the part made for this purpose for all problems.

      Download version 2.0 here
      Shop Mods and Games HERE

      -------------------------------------------------------
      My personal game
      OUnivers - Open
      Xterium - Comming Soon - No code is taken from available versions
    • I'll do it to you on my way home
      2moons 2.0 OPEN Demo
      Thank you to send by ticket or message or via the forum in the part made for this purpose for all problems.

      Download version 2.0 here
      Shop Mods and Games HERE

      -------------------------------------------------------
      My personal game
      OUnivers - Open
      Xterium - Comming Soon - No code is taken from available versions
    • PHP Source Code

      1. $db = Database::get();
      2. $sql = "SELECT (
      3. SELECT COUNT(*)
      4. FROM %%USERS%%
      5. WHERE universe = :universe
      6. AND username = :userName
      7. ) + (
      8. SELECT COUNT(*)
      9. FROM %%USERS_VALID%%
      10. WHERE universe = :universe
      11. AND username = :userName
      12. ) as count;";
      13. $countUsername = $db->selectSingle($sql, array(
      14. ':universe' => Universe::current(),
      15. ':userName' => $userName,
      16. ), 'count');
      Display All
      2moons 2.0 OPEN Demo
      Thank you to send by ticket or message or via the forum in the part made for this purpose for all problems.

      Download version 2.0 here
      Shop Mods and Games HERE

      -------------------------------------------------------
      My personal game
      OUnivers - Open
      Xterium - Comming Soon - No code is taken from available versions