Posts by yahgiggle

ok this works ive tested it

          // get the connection
          WorldDatabase NPCdatabase = getWorldDatabase(WorldDatabase.Target.Npcs);

          // set the chat command to test
          if (cmd[0].equalsIgnoreCase("/test")) {

          // set the variable
          String Count = "Billy";

          // Query DB
          try (ResultSet Result = NPCdatabase.executeQuery("SELECT COUNT(*) AS count_name FROM npcs WHERE name LIKE '"+Count+"'")) {

          // check for a result   
          if (Result.next()) {
          // output the result to text message 
          int db_count = Result.getInt("count_name");
          player.sendTextMessage("count="+db_count);
          }
          }catch(SQLException sQLException) {}
          }

In the npcs table under names the default is null so doing a count of that if no names are added, will result in a null

Read above made a edit and added more info, sorry i did not see your reply till after i refreshing the forum for some reason oO

Not tested but this should work

// Don't forget to also get the connection to the world database 
WorldDatabase database = getWorldDatabase(WorldDatabase.Target.Npcs);

database.executeQuery("SELECT count(*) FROM `npcs` WHERE 'name' LIKE '"+playernm+"'")) { 

// get the result
int db_count = Result.getInt(1);


}

Bump

Version 4.5

• Whole new UI
• Removed commands - everything is now done in the UI admins and non admin players both use the leftshift + p keys to open the menu
• Added option for Admins to turn on or off the Teleport menu for non admin players - if the option is off - non admins cannot see the non admin teleport menu
• When using the teleport menu to teleport you will now be teleported and rotated facing away from the teleport
  
  
  

Quote from mjminfo

thanks now it's working I was using the console not the chat, in chat the /portals work . It would be good to have some kinda of help to figure out how to set it up for the first time ( some kindof /portalshelp or something like that)

just start hitting buttons lol the text in chat will let you know what to do and each step as you do it.

nice clocks

here is an array list of zones i made so users can select the time zone - you will need to add that option for them but here is my code to upload that list and enter it into a database you are welcome to use the list

database.execute("CREATE TABLE IF NOT EXISTS `AreaZones` (`ID` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `Zones` VARCHAR(64));");
      // add the area zone database
      try (ResultSet result = database.executeQuery("SELECT * FROM `AreaZones` WHERE ID = '1'")) {
      System.out.println("Checking AreaZones DataBase ");
      if (!result.next()){
      System.out.println("AreaZone Table getting added");
      
       String inputString = sendHttpRequest("https://www.yahgiggle.com/zones.txt");
              
              if (inputString != null){
              StringTokenizer getzoneList = new StringTokenizer(inputString, ",");

               int CountList = getzoneList.countTokens();
               String[] stringArray = new String[CountList];

              
               for (int i = 0; i < CountList; i++) {
               stringArray[i] = getzoneList.nextToken();
               }

               for (String zoneList : stringArray) {
              
           database.executeUpdate("INSERT INTO `AreaZones` (Zones) VALUES ('"+zoneList+"');");  
                
               System.out.println("Added area "+zoneList);
               }
               }
      
      
      
      }else{System.out.println("AreaZone Table already added");}
      } catch (SQLException ex) {Logger.getLogger(WorldProtection.class.getName()).log(Level.SEVERE, null, ex);}

Quote from mjminfo

Hi, I'm playing SP and did unzip the archive in the _new version/plugins/portals4.4 folder. Loaded the game in single player and can't seem to be able to get a portal going when I press P or /portals in the console, even when I'm in GM 1 mode. what am I missing ?
--log from server --

[Java] Load 2 possible plugins from D:\Steam\steamapps\common\RisingWorld\_New Version\Plugins

[Java] LOAD PLUGIN FROM JAR: Portals.jar

[Java] - /META-INF/MANIFEST.MF

[Java] - /resources/plugin.yml

[Java] - /resources/plugin.yml.bak

[Java] Plugin portals.Portals (1) main class: class portals.Portals

[Java] Plugin portals.Portals class: class portals.Portals

[Java] Found class: portals.CreateDatabase

[Java] Found class: portals.PortalUI

[Java] Found class: portals.Portals

[Java] ///////////////////////////////////////////////

* Plugin: Portals

* Version:

* Author: Yahgiggle

* Team:

* Description: Portals plugin

* License:

* Website:

[Java] ADD PLUGIN: Portals 1

[Java] -- PORTALS PLUGIN ENABLED --

[Java] SQLite: D:\Steam\steamapps\common\RisingWorld\_New Version\Plugins\PortalsV4.4/0703/database.db

[Java] -- WorldProtection PLUGIN ENABLED --

[Java] SQLite: D:\Steam\steamapps\common\RisingWorld\_New Version\Plugins\PortalsV4.4/0703/database.db

[Java] Checking DataBase Version

[Java] DataBase Version is up to date v1

[Java] API: REGISTER LISTENER class portals.Portals

[Java] -> Event: net.risingworld.api.events.player.PlayerCommandEvent

[Java] -> Event: net.risingworld.api.events.player.PlayerKeyEvent

[Java] -> Event: net.risingworld.api.events.player.PlayerDisconnectEvent

[Java] -> Event: net.risingworld.api.events.player.PlayerChangeBlockPositionEvent

[Java] -> Event: net.risingworld.api.events.player.PlayerConnectEvent

[Java] -> Event: net.risingworld.api.events.player.ui.PlayerUIElementClickEvent

Starting RW Singleplayer Server...

Starting 2 server chunk worker threads...

Starting 1 server water worker threads (update: 0.05, sync: 0.1)...

[NetworkClient] Start channel 0...

::::CONNECT TO SINGLEPLAYER

Display More

The portals keys have been hold down shift + hit p for some time now, You need to also be an Admin to use that or it wont open, sorry i crossed that off in the main post but its the fact you no longer use p to place each portal, you need to click the menu then use both place portal buttons now, But /portals should still work!! you did enter that command into chat right ?. for all players, non admins can only use the teleport option in that panel, but like i said you may not have added yourself as a admin if its not working,

PS ill be removing the /portals command in my next update altogether everything will be in the shift + p menu

Bump

Version 4.4

Added more options under the UI now can select clear portal - clear = no effect so its invisible apart from the text - also added Settings Place entrance and place exit buttons,
player now exits the portal facing away from the portal in the direction the portal was placed.

Quote from MommaT

I don't think we have to have "flowing water". It's just an illusion after all. Some little special effects animation devices are really all we need. See: Planet Zoo or Coaster for what I mean. The special effects devices produce the illusions of fountains, water flowing on the surface of "static water", jets, waterfalls, bubbles, etc. We did have a "procedural smoke" effect in Java that we could place. So I think this could be done and I'm guessing would be a lot easier than flowing water that likely takes up more processing resources? That way we can be judicious about how much of that animation we put in. Just my 2 cents, and I don't know what I am talking about ....

yeah i like that idea, maybe a prefab effect could be possible already

Some baby animals are already in the unity version, you can spawn them, like spawnnpc piglet

zebra

wildsow

wildpiglet

wildboar

spider

snake

sheepshorn

sheep

rhinoceros

ramshorn

ram

polarbear

piglet

pig

penguin

moosecalf

moosebull

moose

lioness

lion

lamb

horse

hare

goatling

goat

fox

elephant

earthworm

dummy

deerstag

deerred

deercalf

deer

cow

chicken

chick

calf

bull

billygoat

bearmale

bearcub

bear

arcticfox

Quote from Ash_lee

Is there anyway to turn off the poster texture?

there are two types of posters now, one that sticks to everything and takes on there texture and shape, the other is the normal one like we had in the java version, are you using the right one ?

ATM we could make a type of spring that users could place and have flowing water - using the API but that could cause problems with lots of people placing them everywhere so im not that keen on coding it. a more less resourceful meathed needs to be added, so till then its not that practical.

Quote from RunAndHideGamer

On my server I have allowed people to cut down trees when they are outside their area.... what I see is when they pick up the timber messages appear in white on the left side saying they need to own the land to do that...but they can still pick up the wood.

A message for each piece of wood they pick up.... can the messages not display if the area is unlocked allowing people to do things outside of their areas.

I think from the top of my head you also have to allow remove tree or something like that in the same admin tools menu, this should stop the message, but if not let me know

I like the goFundme idea, and have already talked to red51 on the subject of help, as he said it can take more time getting someone new upto date with all the code it's just not worth it unfortunately.

Bump

Version 3.4

• More bug fix's
  
• Added Blueprint distance limiter - players cannot place blueprints far away - they now need to be 5 or less blocks away
  
• Added Blueprint cost - each blueprint will now cost points much like the areas do, ATM each part of the blueprint costs 1 point, so if you have a blueprint with 5000 parts that will cost 5000 points, if you do not have 5000 points you cannot place the blueprint

Note: i will add a way for admins to adjust the distance and price in an upcoming update

This maybe due to the mask used in unity red51 have you noticed this

AutoBan

This is a plugin that automatically bans known server trouble makers, ATM there is no one added to the list

To get a player banned on all servers running this plugin we all must provided evidence in the forum of screen shots of the damaged caused, that evidence along with the players UID number, Must be posted on this page, once a player has been added they cannot be removed,

however i will be adding soon a option for Admins to allow banned players to still be able to play on there own server, the default will always be banned till they are unbanned by that server owner.

Version 1

• coded the main commutation script to receive the ban list from my own website
• coded auto kick on player connect
• coded /banlist for admins to view the list of UIDs added, if that player has been on your own server it will also show the name of the player
  

Version 1.1

• Coded database for banned players
• Coded /Autoban admin tool for unbanning or re banning banned players on the list

Autoban automatically bans known trouble makers by an updated ban list stored on my own website, once a player has been added to this list every server who has AutoBan plugin installed is automatically protected from this player, the addition of the /AutoBan is so all server owners can then disable a player from been banned on there own server.

I've already coded a simple plugin as James knows, it's working sweet, but very interested in the length of time they get and how that would work due the it using html array list

Quote from Bozbird

I am happy to be part of this community. And I promise to behave accordingly. Everyone deserves a second chance. I ask all server owners to allow me to show that I can do good things one last time. Please lift my bans and accept my apology.

Give it one last chance and see how good I'll be for this community. I am waiting for the response of all server owners. Appreciation is yours, thank you

Well im happy to give you another chance if you own up and admit what you did apology's are good but taking responsibility goes a long way too.

Quote from Bozbird

First of all, since they are talking about me here, I also have the right to defend myself. And I also had the right to say something.

First of all, I am not a hacker. I didn't break any rules. It says in the server rules that I should not damage players' areas. When I entered the game, there was no claim area. All areas were open to everyone, including my area. I didn't even know if the server was abandoned or not.

Who can say that someone has a right to a field that is technically and theoretically open to everyone?

In this game, all kinds of restrictions can be made by software and server administrators. I didn't do any software hacking. I didn't do anything in the game that wasn't allowed.

If it's a game, software problems are always a problem. It is not right to carry out extrajudicial executions. It is impossible for me, as a normal player, to do anything that is not allowed on the server.

Red Baron also wrote on the forum that I have been playing games on my own for a long time. I didn't do anything that was technically prohibited.

It is not written in the game or on the server that the game has faulty codes and even if these errors occur, we should ignore them.

If it was reported that there were errors in the game and that we should treat these errors as if there were no errors, I would act this way.

I have made many friends in this community over the years and played on many servers. I haven't had any problems so far. I've been playing this game for about 5 years. As a result, I am aware that I have upset and annoyed some people. Nobody is perfect. From now on, I ask for forgiveness from all server owners one last time. I promise you that from now on there will be nothing but improving this community and being a good player. I accept that everyone bans me if I make the slightest mistake.

The person who never makes mistakes is the person who does nothing, and the biggest mistake in life is thinking of yourself as mistakeless.

-Yunus Emre

Display More

mistakes are indeed mistakes, but to report that someone had smashed buildings and then that person turns out to be you, then denied doing it, is unacceptable behavior, there are always times when something does not do what its expected todo leaving open vulnerabilities, the fact that you took advantage of them on a server that has been up for a long time with an active Admin leaves you're defense in question, also the fact you have done similar things to other servers including my own, and when i had you up about it you totally denied it. maybe over time you could earn back the respect thats upto you.