Posts by King Nothing

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

King Nothing · Oct 24th 2016

actualluy I'm making EffNet its loosely based on Vornet, so if you want to butt heads and collaborate its up to you.

King Nothing · Oct 24th 2016

thank you , I never know I could define variables outside an event

King Nothing · Oct 24th 2016

what I am trying to do is

type /XXXX and an editable text field with an OK button pops up

I set the ok button to clickable, but I need the "onGuiElementClickEvent" in order for it to work, I am confused on how to do this.

Code

public void onCommand(PlayerCommandEvent event){
 if(cmd[0].equals("/pm"))
        {
           if(cmd.length > 1){
        //Create a panel
        GuiPanel panel = new GuiPanel(0.5f, 0.25f, true, 400, 50, false);
        panel.setPivot(PivotPosition.Center);  //centered element
        panel.setColor(0x000000BB);  //rgba int color, transparent black
        //Get the player object (the player who connects)
GuiTextField label = new GuiTextField(0.5f, 0.25f, true, 1.5f, 1.5f,true);
GuiLabel okbutton = new GuiLabel("ok",0.5f,1.0f,true);
label.setEditable(true);
p.setMouseCursorVisible(true);
label.setText("Default");
label.setClickable(true);
okbutton.setClickable(true);
label.setBackgroundPreset(0);
label.setColor(0x000000BB);
        label.setPivot(PivotPosition.Center);
        panel.addChild(label);
        p.addGuiElement(panel);
        p.addGuiElement(label);
        }
}

Display More

King Nothing · Oct 24th 2016

I tried Adding a Text Field and all i got was a white Screen
I tried Adding a database, that gave me errors
What I am trying to do is NOT possible or the API is full of bugs.

Code

//Get the player object (the player who connects)
GuiTextField label = new GuiTextField(0.5f, 0.25f, false, 0.5f, 0.5f,false);
label.setEditable(true);
label.setText("Default");
label.setClickable(true);
label.setBackgroundPreset(0);
label.setColor(0x000000BB);
        label.setPivot(PivotPosition.Center);
        panel.addChild(label);
        p.addGuiElement(panel);
        p.addGuiElement(label);
    }

Display More

This Code should NOT make the Screen Completly White

if any one can chat with me on steam, feel free.

King Nothing · Oct 23rd 2016

I'm assuming this is Normal when you add a text Field? i scaled it down and i get a big white screen

Code

GuiPanel panel = new GuiPanel(0.5f, 0.25f, true, 400, 50, false);


        panel.setPivot(PivotPosition.Center);  //centered element


        panel.setColor(0x000000BB);  //rgba int color, transparent black
        //Get the player object (the player who connects)
GuiTextField label = new GuiTextField(0.5f, 0.25f, false, 0.5f, 0.5f,false);
label.setEditable(true);
label.setText("Default");
label.setClickable(true);
label.setBackgroundPreset(0);
panel.setColor(0x000000BB);
        label.setPivot(PivotPosition.Center);


        panel.addChild(label);
        p.addGuiElement(panel);


        p.addGuiElement(label);
    }

Display More

King Nothing · Oct 23rd 2016

Quote from yahgiggle

heres a color chart that may help http://www.nthelp.com/colorcodes.htm

thank you. i've been googling the color codes with NO luck.

King Nothing · Oct 23rd 2016

thanks and sorry for the caps, I was just getting frustrated because my database won't work so now I'm working on a different Project and this GUI Thing is getting on my nerves

and when I think of RGBA I think of
this: rgba(255, 0, 0, 0.3)

I don't know where you are coming up with (Oox000000BB) it looks like an extended version of the hexadecimal colors.

King Nothing · Oct 23rd 2016

I read and pulled apart Red's Guestbook Plugin and of course it didn't show up in the game.

all I Want is to place a simple Box on the screen so the player can enter info..

any help would be appreciated.

King Nothing · Oct 23rd 2016

the above code SHOULD work and update the record.

King Nothing · Oct 21st 2016

the VALUES are variables, not fixed values.

King Nothing · Oct 21st 2016

Java

package Mail;
import static java.awt.SystemColor.text;
import static java.rmi.server.ObjID.read;
import java.sql.Connection;
import java.sql.PreparedStatement;
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.objects.Player;


   public class Mail extends Plugin implements Listener{


        @Override
        public void onEnable(){




              registerEventListener(this);
        }
        @Override
        public void onDisable(){
            //...
        }
        @EventMethod
        public void onCommand(PlayerCommandEvent event) throws SQLException{
        Player player = event.getPlayer();
        String command = event.getCommand();
        Server server = getServer();
        //split the command
        String[] cmd = command.split(" ");
        //check the command
        if(cmd[0].equals("/mail")){


            //check if player Entered a Recipeant
            if(cmd.length > 1){            
             String Recipiant = command.substring(5);  
             String fromwhom = command.substring(2);
             String timestamp = server.getGameTime();
             String body = "I love you." ;
             player.sendTextMessage("Sent to:" + Recipiant); 
             Database db = getSQLiteConnection(getPath() + "/Mail.db");

db.execute("CREATE TABLE IF NOT EXISTS 'MailPeople' ('player_name' CHAR(64) NOT NULL DEFAULT ('[NoName]'),'recipient_name' CHAR(64) NOT NULL DEFAULT ('[NoName]'),'time' CHAR(64) NOT NULL DEFAULT ('[NoName]'),'text' CHAR(64) NOT NULL DEFAULT('[NoTime]'), 'read');");
  //Note: if AutoCommit is set to false on this connection (by default it is set to true),


    //you'll have to call "prep.commit();" to commit the changes




db.executeUpdate(
"INSERT INTO MailPeople ('player_name','recipient_name','time','text','read') VALUES (Recipiant,fromwhom,'booger','Booty Call' ,0);");






            }



    //Note: if AutoCommit is set to false on this connection (by default it is set to true),



   }
}


       }

Display More

Now the console says "Recpiant is a "Column," it is clearly in the VALUES I've tried everything to write a variable, coukd someone please tell me what the heck I am doing wrong?

King Nothing · Oct 21st 2016

Java

package Mail;


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.PlayerSpawnEvent;
import net.risingworld.api.objects.Player;


public class Mail extends Plugin implements Listener
{
	protected Database db	= null;


	@Override
	public void onEnable()
	{
		db = getSQLiteConnection(getPath() + "/Mail.db");
		db.execute("CREATE TABLE IF NOT EXISTS 'MailPeople' ('id' INTEGER PRIMARY KEY, "
			+"'player_name' CHAR(64) NOT NULL DEFAULT ('[NoName]'),"
			+"'recipient_name' CHAR(64) NOT NULL DEFAULT ('[NoName]'),"
			+"'time' CHAR(64) NOT NULL DEFAULT ('[NoTime]'),"
			+"'text' CHAR(64) NOT NULL DEFAULT('[NoText]'),"
			+"'read' INTEGER NOT NULL DEFAULT ( 0 ));");
//		db.close();
		registerEventListener(this);
	}


	@Override
	public void onDisable()
	{
		if (db != null)
			db.close();
	}
/*
	@EventMethod
	public void OnConnect(PlayerConnectEvent event)
	{
	}
*/
	@EventMethod
	public void onSpawn(PlayerSpawnEvent event) throws SQLException
	{
		Player player = event.getPlayer();
		player.sendTextMessage("Checking Your Mailbox...");
		boolean	somethingToRead	= false;
		String query = "SELECT * FROM 'MailPeople' WHERE 'recipient_name' = '" + player.getName()
				+ "' AND 'read' = 0";
		try (ResultSet result = db.executeQuery(query))
		{
			//String fromwhom = result.getString("player_name");
			if(result.next())
			{
				String fromwhom = result.getString("player_name"); 
				String recipient = result.getString("recipient_name");
				String timestamp = result.getString("time");
				String body = result.getString("text");
				int ifread = result.getInt("read");
//				String fromwhom = result.getString("player_name");
				if (ifread == 0)
					somethingToRead = true;
			}
		} catch (SQLException e)
		{
			e.printStackTrace();
		}
		if (somethingToRead)
			player.sendTextMessage("You Got Mail, You Lucky Stiff!");
		else
			player.sendTextMessage("Nothing but Dust and Spiders in your Mailbox");
		Player sender = event.getPlayer();	// ???
		Server server = getServer();		// ???
	}


	@EventMethod
	public void onCommand(PlayerCommandEvent event) throws SQLException
	{
		Player player = event.getPlayer();
		Player sender = event.getPlayer();		// never used ???
		String command = event.getCommand();
		Server server = getServer();
		//split the command
		String[] cmd = command.split(" ");
		//check the command
		if(cmd[0].equals("/mail"))
		{
			//check if player Entered a Recipient
			if(cmd.length > 1)
			{
				String recipient = command.substring(5);
				String fromwhom = player.getName();
				String timestamp = server.getGameTime();
				String body = "I love you." ;
				player.sendTextMessage("Sent to:" + recipient);
				String query = "INSERT INTO MailPeople ('player_name','recipient_name','time','text','read') VALUES ('"+fromwhom+"','"+recipient+"','"+timestamp+"','"+body+"' ,0);";
				db.executeUpdate(query);
//				db.close();
			} 
		}
		if(cmd[0].equals("/read"))
		{
//			Database db = getSQLiteConnection(getPath() + "/Mail.db");
//	this happens when an SQL exception occurs. You have to catch this
//	exception. If you just want to print the error, you could call
//	e.printStackTrace();
			String query = "SELECT * FROM 'MailPeople' WHERE 'recipient_name' = '" + player.getName()
					+ "' AND 'read' = 0";
			try (ResultSet result = db.executeQuery(query))
			{
//				if(result.next())
				while(result.next())
				{
					String fromwhom = result.getString("player_name"); 
					String Recipiant = result.getString("recipient_name");
					String timestamp = result.getString("time");
					String body = result.getString("text");			// never used ???
					int ifread = result.getInt("read");				// never used ???
					int id = result.getInt("id");
					player.sendTextMessage("I love: " + fromwhom); 
					player.sendTextMessage("I farted on: " + Recipiant);
					player.sendTextMessage("the time: " + timestamp);
					db.executeUpdate("UPDATE MailPeople SET UPDATE MailPeople SET 'read' = 1 WHERE 'id' = " + id);
					player.sendTextMessage("REad");
//					db.close();
				}
			} catch (SQLException e)
			{
				e.printStackTrace();
			}
		}
	}
}

Display More

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.ArrayIndexOutOfBoundsException: 1
at Commands.Commands.onCommand(Commands.java:79)
... 9 more
Mirrawe helped me and I still cannont figure this out....

King Nothing · Oct 20th 2016

Never mind.. I moved the bracket and it worked

King Nothing · Oct 20th 2016

package Mail;
import net.risingworld.api.Plugin;
import net.risingworld.api.events.EventMethod;
import net.risingworld.api.events.Listener;
import net.risingworld.api.events.player.PlayerCommandEvent;
import net.risingworld.api.objects.Player;
public class Mail extends Plugin implements Listener{
@Override
public void onEnable(){
registerEventListener(this);
}
@Override
public void onDisable(){
//...
}
@EventMethod
public void onPlayerCommand(PlayerCommandEvent event){
Player player = event.getPlayer();
String command = event.getCommand();
//split the command
String[] cmd = command.split(" ");
//check the command
if(cmd[0].equals("/mail")){
//check if player Entered a Recipeant
if(cmd.length > 1){
String towhom = command.substring(5);
player.sendTextMessage("Sent Mail to:" + towhom);
}

}
else{
//inform player that he has to enter the recpiant
player.sendTextMessage("[#FF0000]You Need to Specify Who You are Mailing!");
player.sendTextMessage("[#FF0000]USAGE: /mail UncleBob");

}

It will say "Mail sent to: XXXX" but when I just type in "/mail" it won't see the Else Command, it doesn't say anything i the chat

King Nothing · Oct 19th 2016

I was Informed by Yahgiggle that is Possible to make Your own Vehicle with the api?? all you have to do is lock to your screen. that sounds awesome

King Nothing · Oct 19th 2016

yes the Model, typo

King Nothing · Oct 19th 2016

It unfortuanetly does not work any more, the mode stopped showing up, all I did was edit Red's Guestbook plugin and used my own model, LOL

King Nothing · Oct 19th 2016

Quote from zfoxfire

could you post a link to the 3d model you are trying to import and your plugin source code?

thats what it was, it had too many polys, loaded a different model and it works like a charm

King Nothing · Oct 19th 2016

http://tf3dm.com/3d-model/atm-57251.html
it said Low Poly but i think its High Quality

Posts by King Nothing

Why does this say "NO such Column?"

[Script] VorNet

Calling an Event within an event (i want to type in a /command and a GUI pops up)

Calling an Event within an event (i want to type in a /command and a GUI pops up)

Well Forget everything

can someone pleae POst an example in which a GUI actually WORKS?

can someone pleae POst an example in which a GUI actually WORKS?

can someone pleae POst an example in which a GUI actually WORKS?

can someone pleae POst an example in which a GUI actually WORKS?

More Database Woes - the console spits out an error(see Code)

More Database Woes - the console spits out an error(see Code)

More Database Woes - the console spits out an error(see Code)

More Database Woes - the console spits out an error(see Code)

Can Someone PLEASE tell me why it won't do the Else Command?

Can Someone PLEASE tell me why it won't do the Else Command?

Changelog 2016-10-17: Full release of the new Plugin API

Outdated Video Driver?

Outdated Video Driver?

Outdated Video Driver?

Outdated Video Driver?