Posts by King Nothing

King Nothing · Nov 2nd 2016

Stink Bombs --- WHOO HOOO

King Nothing · Nov 1st 2016

I used Miarre's help, Red's help, yahgiggle's help, It will NOT work, it stopped the Null error, that went away, It seems to completely ignore the

if(result.next())

block.

Iwish I knew what the problem is, Everyone has their database working, My plugin doesn;t want to work for some reason

I am at a loss right now, i want to get the basic Mecahincs working so I can move on. if anyone has the time to go line by line and see why it will not work please feel free to do so. i will fix the line at player spwan, that is an easy fix.. pleade help me get this working, it has been a week nd stil getting NOTHING

King Nothing · Nov 1st 2016

Code

String query = "SELECT * FROM Money WHERE 'player_name' = '" + p.getName()+"'";
			try (ResultSet result = db.executeQuery(query))
		{
			//String fromwhom = result.getString("player_name");
			if(result.next())
			{
				String Money_Player = result.getString("player_name"); 
                                 p.sendTextMessage("EB: "+Money_Player);
				int Money_Money = result.getInt("Player_money");
                                p.setAttribute("money",Money_Money);
                                p.setAttribute("Player",Money_Player);
                                p.sendTextMessage("EB: "+Money_Money);
                        }
		} 
                        catch (SQLException e)
		{
			e.printStackTrace();
		}
    String command = event.getCommand();
    Server server = getServer();
    String[] cmd = command.split(" ");
    if (cmd[0].equals("/help"))
    {
      String helpme = command.substring(6);
      p.sendTextMessage(helpme);
      if (cmd.length > 1) {
        if (helpme.equals("mail"))
        {
          p.sendTextMessage(helpme);
        int money =(int)p.getAttribute("Money_Money");
        // int money = (int) (p.getAttribute("money"));

Display More

I Think I set the attribute in line 11, and line 33 is SUPPOSED to retrive it, the database does read the data, I built a simple one and re-wrote code around it. is this Correct? Or do I have to define it somewhere else?

King Nothing · Oct 31st 2016

that's why I'm Cramming everything into one plugin, no sense of making 20 plugins when all you have to do is keep adding featues to the one you currently have, I was going to make a separate mail plugin but that will put into EffNet, along with money and shopping.,

King Nothing · Oct 31st 2016

We are cleaning up and removing defunct areas, i am currently Working out the bugs In EffNet (currency and other Cool Features), We Currently have 5 levels, you can build anywhere you want, you may build roads going to the main roads. we have Admins that are wiling to help you, we will answer any questions you may have.

King Nothing · Oct 31st 2016

I temporalily took that out, i am aware of that, The database works like its supposed to., it reads Writes and updates, I get this error:

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at pluginapi.PluginEventHandler.triggerEvent(SourceFile:166)
at aF.b.a(SourceFile:171)
at aF.b.messageReceived(SourceFile:121)
at k.e.a(SourceFile:109)
at k.c.run(SourceFile:65)

Caused by: java.lang.NullPointerException
at Test.Test.onCommand(Test.java:83)
... 9 more
when i Comment it out, the plugin works, when i put it in, it Errors out.

i looked up the error, how do I set it to null???

There is data in the database, i put some in for testing, i have to check if the user is new that is why onSpawn isn't finished.

King Nothing · Oct 31st 2016

Java

package Test;
import java.sql.ResultSet;
import java.sql.SQLException;
import net.risingworld.api.Plugin;
import net.risingworld.api.Server;
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.objects.Player;




public class Test extends Plugin implements Listener{
   protected Database db	= null;
	@Override
	public void onEnable()
	{

		Database db = getSQLiteConnection(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 ));");
//		db.close();
		registerEventListener(this);


	}
	@Override
	public void onDisable()
	{
		if (db != null)


			db.close();
	}
@EventMethod
public void onSpawn(PlayerSpawnEvent event) throws SQLException
{
        Player p = event.getPlayer();
   String playerName = p.getName(); 
   String query = "INSERT INTO Money ('player_name', 'Player_money') VALUES ('"+playerName+"', 2000);";

    }






@EventMethod
  public void onCommand(PlayerCommandEvent event) throws SQLException
          {
      Player p = event.getPlayer();
       String playerName = p.getName();
    Database db = getSQLiteConnection(getPath() + "/users/Money.db");
    String query = "SELECT * FROM Money WHERE 'player_name' = '"+playerName+"'";
			try (ResultSet result = db.executeQuery(query))
		{
			//String fromwhom = result.getString("player_name");
			if(result.next())
			{
				String Money_Player = result.getString("player_name"); 
                                 p.sendTextMessage("EB: "+Money_Player);
				int Money_Money = result.getInt("player_money");
                                p.setAttribute("money",Money_Money);
                        }
		} 
                        catch (SQLException e)
		{
			e.printStackTrace();
		}


    String command = event.getCommand();
    Server server = getServer();
    String[] cmd = command.split(" ");
    if (cmd[0].equals("/help"))
    {
      String helpme = command.substring(6);
      p.sendTextMessage(helpme);
      if (cmd.length > 1) {
        if (helpme.equals("mail"))
        {
          p.sendTextMessage(helpme);
         int money =(int)p.getAttribute("money");
          p.sendTextMessage("EB: "+money);
          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("@user will send a Private Message to a user)");
          p.sendTextMessage("/transfer xx to player will Transfer xx Amt of Effbucks to that Plsyer.");
        }
      }
    }
    else if (cmd[0].equals("/en"))
    {
      String ECmd = command.substring(4);
      p.sendTextMessage(ECmd);
      if (cmd.length > 1) {
        if (ECmd.equals("Drink"))
        {


          server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Drinks up!");
          db.executeUpdate("UPDATE Money SET player_name = '"+playerName+"', Player_money=666 WHERE player_name = '"+playerName+"'");


          //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);

        }
      }
    }

}


}

Display More

Why is there an error in on 80?

King Nothing · Oct 30th 2016

ok I just used my test code plugin, inserted the command, issued it in RW, it worked, but it completly igorned the IF statement and wrote it anyway. how do I make so it will see the IF statement?

Code

public void onCommand(PlayerCommandEvent event)
  {
    File effdata = new File(getPath() + "/data.txt");        
    //File effdata = new File(getPath() + "/data.txt");
  // boolean content = Utils.FileUtils.writeStringToFile("hi",data);
    Player p = event.getPlayer();
    String WDP = (String)p.getAttribute("whosthePlayer");

    String playerName = p.getName();
    String command = event.getCommand();
    Server server = getServer();
    String[] cmd = command.split(" ");
    if (cmd[0].equals("/help"))
    {
      String helpme = command.substring(6);
      p.sendTextMessage(helpme);
      if (cmd.length > 1) {
        if (helpme.equals("mail"))
        {
          p.sendTextMessage(helpme);
          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("@user will send a Private Message to a user)");
          p.sendTextMessage("/transfer xx to player will Transfer xx Amt of Effbucks to that Plsyer.");
        }
      }
    }
    else if (cmd[0].equals("/en"))
    {
      String ECmd = command.substring(4);
      p.sendTextMessage(ECmd);
      if (cmd.length > 1) {
        if (ECmd.equals("Drink"))
        {
          p.sendTextMessage("I bet that Hit the spot!");
          server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Drinks up!");
          String Plmoney = (String)p.getAttribute("Playermoney");
          int totalmoney = Integer.parseInt(Plmoney)-50;

          boolean content = Utils.FileUtils.writeStringToFile("hi",effdata);

          //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);
        }
      }
    }
  }

Display More

King Nothing · Oct 30th 2016

Code

public void onCommand(PlayerCommandEvent event)
  {

    File effdata = new File(getPath() + "/data.txt");
  // boolean content = Utils.FileUtils.writeStringToFile("hi",data);
    Player p = event.getPlayer();
    String WDP = (String)p.getAttribute("whosthePlayer");

    String playerName = p.getName();
    String command = event.getCommand();
    Server server = getServer();
    String[] cmd = command.split(" ");
    if (cmd[0].equals("/help"))
    {
      String helpme = command.substring(6);
      p.sendTextMessage(helpme);
      if (cmd.length > 1) {
        if (helpme.equals("mail"))
        {
          p.sendTextMessage(helpme);
          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("@user will send a Private Message to a user)");
          p.sendTextMessage("/transfer xx to player will Transfer xx Amt of Effbucks to that Plsyer.");
        }
      }
    }
    else if (cmd[0].equals("/en"))
    {
      String ECmd = command.substring(4);
      p.sendTextMessage(ECmd);
      if (cmd.length > 1) {
        if (ECmd.equals("Drink"))
        {
          p.sendTextMessage("I bet that Hit the spot!");
          server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Drinks up!");
          String Plmoney = (String)p.getAttribute("Playermoney");
          int totalmoney = Integer.parseInt(Plmoney)-50;
          boolean content = Utils.FileUtils.writeStringToFile("hi",effdata);

          //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);
        }
      }
    }

Display More

King Nothing · Oct 30th 2016

ok is there a way to call it from "onCommand"? I'm Tring to make it Write some data after I issue a /command.

King Nothing · Oct 30th 2016

Windows 10, and OK, that was weird, I called it in onSpawn and it wrote the File, I used onCommand and it didn't do anything...

King Nothing · Oct 30th 2016

File data = new File(getPath() + "/data.txt");
boolean content = Utils.FileUtils.writeStringToFile("hi",data);

there is NO file data.txt anywhere

King Nothing · Oct 28th 2016

sorry, it screwed up my plugins, had to take it out

King Nothing · Oct 26th 2016

thank you, I'm, glad it wasn't me This time

King Nothing · Oct 26th 2016

what does it say? Ive been trying clean up My code, he libe numbers have changed dramatically

King Nothing · Oct 26th 2016

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at pluginapi.PluginEventHandler.triggerEvent(SourceFile:166)
at aF.b.a(SourceFile:171)
at aF.b.messageReceived(SourceFile:121)
at k.e.a(SourceFile:109)
at k.c.run(SourceFile:65)
Caused by: java.lang.IllegalStateException: No serializer found for class l.x
at de.jiw.network.serializing.Serializer.getClone(Serializer.java:125)
at k.c.b(SourceFile:51)
at k.e.a(SourceFile:113)
at k.b.send(SourceFile:48)
at k.b.send(SourceFile:43)
at pluginapi.manager.PluginGuiManager.updateGuiTextField(SourceFile:167)
at net.risingworld.api.gui.GuiTextField.updateTextField(GuiTextField.java:201)
at net.risingworld.api.gui.GuiTextField.setText(GuiTextField.java:53)
at EffNet.EffNet.onCommand(EffNet.java:133)
... 9 more

King Nothing · Oct 25th 2016

Thank you, and Sorry for double Posting... I honestly forgot i posted the same Thing, all I wanted was to get this stupid database working. I was on the verge of shooting my Computer. thats how fustrated was

King Nothing · Oct 25th 2016

Java

// Decompiled by DJ v3.12.12.101 Copyright 2016 Atanas Neshkov  Date: 10/23/2016 9:06:16 AM
// Home Page:  http://www.neshkov.com/dj.html - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   EffNet.java


package EffNet;


import static java.awt.Event.INSERT;
import static java.lang.Character.getName;
import java.math.BigInteger;
import java.sql.ResultSet;
import java.sql.SQLException;
import net.risingworld.api.Plugin;
import net.risingworld.api.Server;
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.PlayerConnectEvent;
import net.risingworld.api.events.player.PlayerEvent;
import net.risingworld.api.events.player.PlayerSpawnEvent;
import net.risingworld.api.events.player.gui.PlayerGuiElementClickEvent;
import net.risingworld.api.gui.Font;
import net.risingworld.api.gui.GuiElement;
import net.risingworld.api.gui.GuiLabel;
import net.risingworld.api.gui.GuiPanel;
import net.risingworld.api.gui.GuiTextField;
import net.risingworld.api.gui.PivotPosition;
import net.risingworld.api.objects.Player;
import static sun.audio.AudioPlayer.player;


public class EffNet extends Plugin implements Listener
{


    GuiTextField label = new GuiTextField(0.5f, 0.25f, true, 1.0f, 1.0f,true);
    GuiPanel panel = new GuiPanel(0.5f, 0.25f, false, 400, 100, false);
    public int PMoney;
    protected Database db	= null;


	@Override
	public void onEnable()
	{
		db = getSQLiteConnection(getPath() + "/EffNet.db");
		db.execute("CREATE TABLE IF NOT EXISTS `EffNet` (`Player_user` VARCHAR(64), 'PLayer_money' INTEGER);");


               // db.executeUpdate("INSERT INTO `EffNet` (Player_user, PLayer_money) VALUES ('Bubba', '2000');");


//		db.close();
		registerEventListener(this);

	}


	@Override
	public void onDisable()
	{
		if (db != null)
			db.close();
	}
        @EventMethod


public void onConnect(PlayerConnectEvent event) throws SQLException{
    Player p = event.getPlayer();

 


  String GetPlayer = p.getName();
 String query = "SELECT * FROM EffNet WHERE Player_user = GetPlayer";

		try (ResultSet result = db.executeQuery(query))
		{
			//String fromwhom = result.getString("player_name");
			if(result.next())
			{

                                int PMoney = result.getInt("PLayer_money"); 


                        			}


                        if (event.isNewPlayer()){
                            db.executeUpdate ("INSERT INTO EffNet ('Player_user','PLayer_money') VALUES ('"+GetPlayer+"',2000);");
                                                }


                        else {
                          db.executeUpdate ("INSERT INTO EffNet ('Player_user','PLayer_money') VALUES ('"+GetPlayer+"',2000);");


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



	


   




	
}    @EventMethod
    public void onSpawn(PlayerSpawnEvent event){

        String query = "SELECT * FROM `EffNet` WHERE `Player_user` = 'Bubba'";

		try (ResultSet result = db.executeQuery(query))
		{
			//String fromwhom = result.getString("player_name");
			if(result.next())
			{

                                int PMoney = result.getInt("PLayer_money"); 

                               label.setText("$EB:" + PMoney);
                        			}

                                            // String GetPlayer = player.getName();  
                       // p.setAttribute("whosthePlayer",GetPlayer);



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


   
}
      Player p = event.getPlayer();
        //GuiPanel panel = new GuiPanel(0.5f, 0.25f, true, 400, 50, false);
   // GuiTextField label = new GuiTextField(0.5f, 0.25f, true, 0.5f, 0.5f,true);

  //  label.setText("$EB:" + PMoney);
    p.addGuiElement(panel);
    panel.addChild(label);
 p.addGuiElement(label);
}
public static void main(String[] args) {


	// create 3 BigInteger objects
	BigInteger bi1, bi2, bi3;


	bi1 = new BigInteger("123");
	bi2 = new BigInteger("-123");


	// assign difference of bi1 and bi2 to bi3
	bi3 = bi1.subtract(bi2);


	String str = "Subtraction result: " +bi1+ " - " +bi2+ " = " +bi3;


	// print bi3 value
	System.out.println( str );
   }


@EventMethod
 public void onCommand(PlayerCommandEvent event){
     BigInteger bi1, bi2, bi3;


        bi1 = new BigInteger("2000");
	bi2 = new BigInteger("50");    //this method will be called when the "PlayerCommandEvent" 
            //triggers, i.e. when a player enters a command into chat.

    Player p = event.getPlayer();
        String WDP = (String) p.getAttribute("whosthePlayer"); 

        String playerName = p.getName();
        String command = event.getCommand();
        Server server = getServer();
        String cmd[] = command.split(" ");

        if(cmd[0].equals("/help")){

            String helpme = command.substring(6);
            p.sendTextMessage(helpme);
            if(cmd.length > 1)
            {
                if(helpme.equals("mail"))
                {
                    p.sendTextMessage(helpme);
                    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("@user will send a Private Message to a user)");
                    p.sendTextMessage("/transfer xx to player will Transfer xx Amt of Effbucks to that Plsyer.");
                }
            }
        }
            else if(cmd[0].equals("/en"))
                {
                    String ECmd = command.substring(4);
                    p.sendTextMessage(ECmd);

                    if(cmd.length > 1)
                        if(ECmd.equals("Drink"))
                        {
                            p.sendTextMessage("I bet that Hit the spot!");
                            server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Drinks up!");
                            bi3 = bi1.subtract(bi2);
                           String str = "Subtraction result: " +bi1+ " - " +bi2+ " = " +bi3;
                             p.sendTextMessage(str);
                            p.setThirst(100);

                        } 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);
     }
                   }

 }
}


        //Create a panel
 
       // GuiPanel panel = new GuiPanel(0.5f, 0.25f, true, 400, 100, false);

Display More

and I did reply to my old topic and no one answered

King Nothing · Oct 25th 2016

i used your example in the Javadoc,

i'm just Getting Fustrate and Cannot think straight.. this is really draining me

its still giving me the same EXACT error

King Nothing · Oct 25th 2016

SELECT * FROM XXXXX WHERE Player_user = GetPlayer

db.executeUpdate("INSERT INTO `XXXXX` (Player_user,PLayer_money) VALUES (GetPlayer, 2000);");

(GetPLayer is String GetPlayer = p.getName();)

Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: GetPlayer)
at org.sqlite.DB.newSQLException(DB.java:383)
at org.sqlite.DB.newSQLException(DB.java:387)
at org.sqlite.DB.throwex(DB.java:374)
at org.sqlite.NativeDB.prepare(Native Method)
at org.sqlite.DB.prepare(DB.java:123)
at org.sqlite.Stmt.executeQuery(Stmt.java:121)
at pluginapi.objects.SQLiteDatabaseAPI.executeQuery(SourceFile:57)
at EffNet.EffNet.onConnect(EffNet.java:68)
... 8 more

Posts by King Nothing

Changelog 2016-11-02: Explosive!

Can Red or one of you fine Upstanding People Kindly Explain whan this means? (a bunch or Errors)

Can Red or one of you fine Upstanding People Kindly Explain whan this means? (a bunch or Errors)

Inter Plug-In Communication

EffenDor - Were Back-- and ready to KIck Some RW Butt

Can Red or one of you fine Upstanding People Kindly Explain whan this means? (a bunch or Errors)

Can Red or one of you fine Upstanding People Kindly Explain whan this means? (a bunch or Errors)

Am I using Utils.FileUtils.writeStringToFile Correctly or am I missing something?

Am I using Utils.FileUtils.writeStringToFile Correctly or am I missing something?

Am I using Utils.FileUtils.writeStringToFile Correctly or am I missing something?

Am I using Utils.FileUtils.writeStringToFile Correctly or am I missing something?

Am I using Utils.FileUtils.writeStringToFile Correctly or am I missing something?

[Plugin] AdminTools (Momentan Inaktiv - Muss überarbeitet werden)

Can Red or one of you fine Upstanding People Kindly Explain whan this means? (a bunch or Errors)

Can Red or one of you fine Upstanding People Kindly Explain whan this means? (a bunch or Errors)

Can Red or one of you fine Upstanding People Kindly Explain whan this means? (a bunch or Errors)

Why does this say "NO such Column?"

Why does this say "NO such Column?"

Why does this say "NO such Column?"

Why does this say "NO such Column?"