bool ChatHandler::HandlePVPCommand(const char * args)
{
	Player *chr = m_session->GetPlayer();

    if(chr->isInFlight())
    {
        SendSysMessage(LANG_YOU_IN_FLIGHT);
        return true;
    }

    if(chr->isInCombat())
    {
        SendSysMessage(LANG_YOU_IN_COMBAT);
        return true;
    }

	if (!*args)
    {
        SendSysMessage("Usage - .pvp enter or .pvp leave");
        return true;
    }

    std::string argstr = (char*)args;

	if (argstr == "enter")
	{
    
//add check to see if player has left arena
	QueryResult *result = sDatabase.PQuery("SELECT `in_arena` FROM `pvp_cmd_data` WHERE `id` = '%d'", chr->GetGUIDLow());
    if(result)
    {
		Field *fields = result->Fetch();
		uint32 inarena = fields[0].GetUInt32();
		if (inarena == 1)
		{
		sDatabase.PExecute( "UPDATE SET `time` =%d `in_arena` =0 WHERE `playerid`= %d", time(NULL), chr->GetGUIDLow());
		/*sDatabase.PExecute( "UPDATE SET `in_arena` =0 WHERE `playerid`= %d", chr->GetGUIDLow());*/
        SendSysMessage("You did not leave the arena, resetting cooldown");
        return true;
		}

    PSendSysMessage("Teleporting you to STV Arena");
    sDatabase.PExecute( "DELETE FROM `pvp_cmd_data`  WHERE `playerid`= %d", chr->GetGUIDLow());
    sDatabase.PExecute( "INSERT INTO `pvp_cmd_data`  VALUES(%d, %d, 1, %f, %f, %f, %d)", chr->GetGUIDLow(), time(NULL), chr->GetPositionX(), chr->GetPositionZ(), chr->GetPositionY(), chr->GetMapId());
	chr->TeleportTo(0, -13228.1, 227.833, 32.8926, 0);
    return true;
	}

	else if (argstr == "leave")
	{
    Player* _player = m_session->GetPlayer();
    
	QueryResult *result = sDatabase.PQuery("SELECT `in_arena` `myx` `myy` `myz` `mymap` FROM `pvp_cmd_data` WHERE `id` = '%d'", chr->GetGUIDLow());
	if(result)
		{
		Field *fields = result->Fetch();
		uint32 inarena = fields[0].GetUInt32();
		uint32 MyX = fields[1].GetUInt32();
		uint32 MyY = fields[2].GetUInt32();
		uint32 MyZ = fields[3].GetUInt32();
		uint32 MyMap = fields[4].GetUInt32();
		if (inarena == 0)
		{
		SendSysMessage("You are not in the arena");
        return true;
		}
		else
		{
    PSendSysMessage("Teleporting you out of Arena");
    chr->TeleportTo(MyMap, MyX, MyY, MyZ, 0);
    return true;
		}
	}
	
	else
        SendSysMessage("Usage - .pvp enter or .pvp leave");
    return true;
}