package Test;
import java.sql.ResultSet;
import java.sql.SQLException;
import net.risingworld.api.Plugin;
import net.risingworld.api.Server;
import net.risingworld.api.Timer;
import net.risingworld.api.database.Database;
import net.risingworld.api.events.EventMethod;
import net.risingworld.api.events.Listener;
import net.risingworld.api.events.player.PlayerCommandEvent;
import net.risingworld.api.events.player.PlayerSpawnEvent;
import net.risingworld.api.gui.Font;
import net.risingworld.api.gui.GuiElement;
import net.risingworld.api.gui.GuiLabel;
import net.risingworld.api.gui.PivotPosition;
import net.risingworld.api.objects.Player;



public class Test extends Plugin implements Listener{
   protected Database db	= null;
   private final String Money_Money = "";


        public static void main(String[] args) {
    }

    public void onEnable() {
        this.registerEventListener((Listener)this);
        System.out.println("EffNet has beeen Loaded!");
        Database db = this.getSQLiteConnection(this.getPath() + "/users/Money.db");
        db.execute("CREATE TABLE IF NOT EXISTS 'Money' ('player_name' CHAR(64) NOT NULL DEFAULT ('[NoName]'), 'Player_money' INTEGER NOT NULL DEFAULT ( 0 ));");
    }


	public void onDisable()
	{
		if (db != null)

			db.close();
	}
    @EventMethod

            public void onPlayerSpawnEvent(PlayerSpawnEvent event) {
     Player player = event.getPlayer();
        String Playername = player.getName();
        player.sendTextMessage("Welcome " + Playername + "! Hope you will like EffNet");

    }

//String query = "INSERT INTO Money ('player_name', 'Player_money') VALUES ('"+playerName+"', 2000);";


@EventMethod
  public void onCommand(PlayerCommandEvent event) throws SQLException
          {
                if (db == null) {
            db= this.getSQLiteConnection(getPath() + "/users/Money.db");
        }
      Player p = event.getPlayer();
       String playerName = p.getName();

 if (p.getAttribute("money")== null){
    String setmoney = "0";
    p.setAttribute("money", setmoney);
    }
     String command = event.getCommand();
    Server server = getServer();
    String[] cmd = command.split(" ");
    if (cmd[0].equals("/help"))
    {
      String helpme = command.substring(6);
      if (cmd.length > 1) {
        if (helpme.equals("mail"))
        {
          p.sendTextMessage(helpme);
          int money =(int)p.getAttribute("Money_Money");
          //int moola=88;
        // db.executeUpdate("UPDATE Money SET player_name = '"+playerName+"', Player_money='"+moola+"' WHERE player_name = '"+playerName+"'");

          p.sendTextMessage("/mail (To player) - will allow you to Write a Message to a player");
          p.sendTextMessage("/read Reads your messages)");
        }
        else if (helpme.equals("Effnet"))
        {
          p.sendTextMessage("/en Drink Will Quench Your Thirst for 50 EffBucks");
          p.sendTextMessage("/en FeedMe will Fill your Hunger for 50 EffBucks");
          p.sendTextMessage("/en Daylight - Will give you daylightt (150 EB)");
          p.sendTextMessage("@user will send a Private Message to a user)");
          p.sendTextMessage("/transfer xx to player will Transfer xx Amt of Effbucks to that Plsyer.");
           p.sendTextMessage("/sethome Sets Your Home (Free Service)");
           p.sendTextMessage("/home Will Take you Home (Free Service)");
          p.sendTextMessage("         EFFNET TAXI SERVICE");
          p.sendTextMessage("/tx Skylark -- Taxi to Skylark City(Spawn Area) (25 EB)");
        }
      }
    }
    else if (cmd[0].equals("/en"))
    {
      String ECmd = command.substring(4);
      p.sendTextMessage(ECmd);
      if (cmd.length > 1) {
        if (ECmd.equals("Drink"))
        {
                   try {
                ResultSet result3 = db.executeQuery("SELECT * FROM Money WHERE 'player_name' = '" + p.getName() + "'");
                int num = 50;
                int num2 = 20;

                while (result3.next()) {
                    String PlayersName = result3.getString("player_name");
                     int PlayersMoney= result3.getInt("Player_money");
                    server.broadcastTextMessage("Money: "+PlayersMoney);

                   //int PlayersMoney=503;
               db.executeUpdate("UPDATE Money SET player_name = '"+playerName+"', Player_money='"+PlayersMoney+"' WHERE player_name = '"+playerName+"'");


                                     }


                db.close();
            }
            catch (SQLException e) {
                e.printStackTrace();
            }

          server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Drinks up!");


          //db.executeUpdate ("INSERT INTO EffNet ('Player_user','Player_money') VALUES ('"+playerName+"','"+totalmoney+"');");
          p.setThirst(100);
         // p.sendTextMessage(WDP);
        }
        else if (ECmd.equals("FeedMe"))
        {
          p.sendTextMessage("Yummy!g!");
          server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Odered a Pizza From Mario's Perfect Pizza!");
          p.setHunger(100);
        }
        else if (ECmd.equals("Daylight")){
          server.setGameTime(9, 0);
        }
      }
    }
    else if (cmd[0].equals("/tx"))
    {
        String ECmd = command.substring(4);
        if (cmd.length>1){
            if (ECmd.equals("Skylark")){
                p.sendTextMessage("teleport");
                server.broadcastTextMessage("[#6DE31F]Who Needs Uber when you got Effnet's Taxi Service!!!!");
              float x = Float.parseFloat("3342");
                float y = Float.parseFloat("62.72");
                float z = Float.parseFloat("269.17");
        p.setPosition(x, y, z);
    }
}
    }      }
        }