<?php
/************************************
*                                   *
*            VortexCMS              *
*          -------------            *
*     Author: Adam N. Viðarsson     *
*     E-mail: contact@adamnv.com    *
*     Phone: (+354)7704299          *
*                                   *
************************************/

    $ip = $_SERVER['REMOTE_ADDR'];
    global $usernamecheck;

    if($core = '1') // ArcEmu
    {
        define("IP_CHECK", "SELECT * FROM accounts WHERE lastip = '$ip'");
        define("USERNAME_AVI", "SELECT * FROM accounts WHERE login = '$_POST[accname]'");
        define("PLAYERS_ONLINE", "SELECT online FROM characters WHERE online = '1'");
        define("EMAIL_AVI","SELECT * FROM accounts WHERE email = '$_POST[accmail]'");
        define("CREATE_ACCOUNT","INSERT INTO accounts SET login = '$_POST[accname]', password = '$_POST[pword]', gm = '0', banned = '0', email = '$_POST[accmail]', flags = '24'");
        define("LOGIN_QUERY","SELECT * FROM accounts WHERE login = '$_POST[loginuser]' and password = '$_POST[loginpass]'");
        define("NEW_PASS","UPDATE accounts SET password = '$_POST[newPass]' WHERE login = '$_SESSION[login]' LIMIT 1");
        define("NEW_EMAIL","UPDATE accounts SET email = '$_POST[newMail]' WHERE login = '$_SESSION[login]' LIMIT 1");
        define("FORGOT_PW","SELECT * FROM accounts WHERE login = '$_POST[fpname]' LIMIT 1");
    }

    if($core = '2') // TrinityCore
    {
        define("IP_CHECK", "SELECT * FROM account WHERE last_ip = '$ip'");
        define("USERNAME_AVI", "SELECT * FROM account WHERE username = '$_POST[accname]'");
        define("PLAYERS_ONLINE", "SELECT online FROM characters WHERE online = '1'");
        define("EMAIL_AVI","SELECT * FROM account WHERE email = '$_POST[accmail]'");
        define("CREATE_ACCOUNT","INSERT INTO account SET username = '$_POST[accname]', sha_pass_hash = '$sha_pass', email = '$_POST[accmail]', expansion = '2', locked = '0'");
        define("LOGIN_QUERY","SELECT * FROM account WHERE username = '$_POST[loginuser]' and sha_pass_hash = '$_POST[loginpass]'");
        define("NEW_PASS","UPDATE account SET sha_pass_hash = '$sha_pass' WHERE username = '$_SESSION[login]' LIMIT 1");
        define("NEW_EMAIL","UPDATE account SET email = '$_POST[newMail]' WHERE username = '$_SESSION[login]' LIMIT 1");
        define("FORGOT_PW","SELECT * FROM account WHERE username = '$_POST[fpname]' LIMIT 1");
    }

    if($core = '3') // MaNGOS
    {
        define("IP_CHECK", "SELECT * FROM account WHERE last_ip = '$ip'");
        define("USERNAME_AVI", "SELECT * FROM account WHERE username = '$_POST[accname]'");
        define("PLAYERS_ONLINE", "SELECT online FROM characters WHERE online = '1'");
        define("EMAIL_AVI","SELECT * FROM account WHERE email = '$_POST[accmail]'");
        define("CREATE_ACCOUNT","INSERT INTO account SET username = '$_POST[accname]', sha_pass_hash = '$sha_pass', gmlevel = '0', locked = '0', email = '$_POST[accmail]', expansion = '2'");
        define("LOGIN_QUERY","SELECT * FROM account WHERE username = '$_POST[loginuser]' and sha_pass_hash = '$_POST[loginpass]'");
        define("NEW_PASS","UPDATE account SET sha_pass_hash = '$_POST[newPass]' WHERE username = '$_SESSION[login]' LIMIT 1");
        define("NEW_EMAIL","UPDATE account SET email = '$_POST[newMail]' WHERE username = '$_SESSION[login]' LIMIT 1");
        define("FORGOT_PW","SELECT * FROM account WHERE username = '$_POST[fpname]' LIMIT 1");
    }
?>