Inactive [Inactive][FUN] NPCX + Civilizations! [1.8] Everquest style BOTS, paths, aggro, loot, guard, shops,.

Discussion in 'Inactive/Unsupported Plugins' started by mixxit, Mar 19, 2011.

  1. Offline

    mixxit

    npcx!
    Version: See thread title for bukkit compatibility (usually RB)
    Test Server: world.soliniaonline.com:25565

    [​IMG]

    Implements everquest style npc spawngroups using the npc library allowing you to make persistent npcs/rare npcs spawn around your map. Npcs will fight back if attacked and even talk on right click. They will sell items and can even have loot assigned and be given factions and paths to walk and npc trading

    Install / Changelog / Commands / README

    All of this has now moved to http://soliniaonlinemc.wordpress.com/2011/09/24/npcx/

    Addendum

    I will be updating NPCX in the future with a rewrite for 1.9 bot functionality
     
  2. Offline

    SolarLunar

    is it possible to use BOSEconomy for this? ._. i really think BOS is better than iConomy :oops: theres not as many commands and things you can do with iConomy D: but with this id have to give up BOS for iconomy
     
  3. a little DB improvement idea: add prefix, clearer when you have other tables on the same DB ;)
     
  4. Offline

    Zero1

    Hi mixxit
    is there any chance to get a command which has the ability to give the player an item/or money automatic,maybe when i said the right word or use npc command [give] to give the npc an item? That would be very important to make quests that don't end with opening only a locked chest.
    I like this plugin very much and that is the only thing i miss.
    sry for bad english:)
     
  5. Offline

    White Sheep

    How to make quests in npcx?
     
  6. Offline

    Caedes

    Why any NPC can't get damage when I attack it? ... Sorry for my English.
     
  7. Offline

    DrBowe

    Also, not sure if this is mentioned anywhere already, but there's a fairly large bug with NPC Merchants:
    Buy and Sell prices are reversed when setting up merchants. I'm glad I caught this early, because this could have messed up server economy QUITE a lot.
     
  8. Offline

    Meiun

    what happens when someone with the same name as the npc tries to log in?
     
  9. Offline

    PsychoNecrosis

    That's a point of perspective, the database is written from the merchant's perspective, ie buy is how much the merchant will buy for from the player, and sell is for how much they will sell at.

    There's a quest table within NPCX's database, so I have a feeling the plugin developer will include them at some point.
     
  10. Offline

    Deathlysteve-

    true... i DID notice that before... well I just hope it comes out soon :p :)
     
  11. Offline

    Jcraft-servers

    I run a rather large server that is mainly pvp/creative but we are loooking to expand into role playing, so when i stumbled across your plugin i got rather excited.

    Now my friend and i have spent half of the night trying to get this to work, we have followed the same steps and done everything exactly the same, his works and mine doesn't, the error message i receive is:

    Console Dump (open)

    "2011-04-21 02:12:06 [INFO] Starting minecraft server version Beta 1.4
    2011-04-21 02:12:06 [INFO] Loading properties
    2011-04-21 02:12:06 [INFO] Starting Minecraft server on *:25565
    2011-04-21 02:12:06 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-659-gc210f22-b684jnks (MC: 1.4)
    2011-04-21 02:12:07 [INFO] Preparing level "world"
    2011-04-21 02:12:07 [INFO] Preparing start region
    2011-04-21 02:12:07 [INFO] 144 recipes
    2011-04-21 02:12:08 [INFO] Preparing spawn area: 61%
    2011-04-21 02:12:08 [INFO] npcx : load settings (0.464) begun
    2011-04-21 02:12:08 [INFO] jdbc:mysql://localhost:3306/npcx?autoReconnect=true
    2011-04-21 02:12:08 [INFO] npcx : initialising database connection
    2011-04-21 02:12:08 [INFO] npcx : loadsettings() ended
    2011-04-21 02:12:08 [INFO] npcx : registering monitored events
    2011-04-21 02:12:08 [INFO] npcx : Checking for DB Updates from DBVersion:2.1
    2011-04-21 02:12:08 [INFO] **********************************************
    2011-04-21 02:12:08 [INFO] * Your DB is currently out of sync with your *
    2011-04-21 02:12:08 [INFO] * version of NPCX *
    2011-04-21 02:12:08 [INFO] **********************************************
    2011-04-21 02:12:08 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.player_faction' doesn't exist
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.myUniverse.loadPlayerFactions(myUniverse.java:1421)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1307)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:08 [INFO] npcx : Error loaded research.
    2011-04-21 02:12:08 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.zone' doesn't exist
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.myUniverse.loadZones(myUniverse.java:1870)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1310)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:08 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.merchant' doesn't exist
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:08 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.myUniverse.loadMerchants(myUniverse.java:1741)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1311)
    2011-04-21 02:12:08 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:08 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:08 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:08 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.faction_list' doesn't exist
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:08 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadFactions(myUniverse.java:1924)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1312)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:09 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.faction_entries' doesn't exist
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadFactionEntries(myUniverse.java:1957)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1313)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:09 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.pathgroup' doesn't exist
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadPathgroups(myUniverse.java:1678)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1314)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:09 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.loottables' doesn't exist
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadLoottables(myUniverse.java:1624)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1315)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:09 [INFO] npcx : ERROR - spawngroup loading cancelled!
    2011-04-21 02:12:09 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.spawngroup' doesn't exist
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadSpawngroups(myUniverse.java:1515)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1316)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:09 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'npcx.player' doesn't exist
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-21 02:12:09 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadPlayers(myUniverse.java:1327)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.myUniverse.loadData(myUniverse.java:1317)
    2011-04-21 02:12:09 [SEVERE] at net.gamerservices.npcx.npcx.onEnable(npcx.java:706)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-21 02:12:09 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-21 02:12:09 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-21 02:12:09 [INFO] npcx: Matching players
    2011-04-21 02:12:09 [INFO] npcx version 0.464 enabled.
    2011-04-21 02:12:09 [INFO] Permission system not detected, defaulting to OP
    2011-04-21 02:12:09 [INFO] Done (0.211s)! For help, type "help" or "?" "


    From what i can tell the DB isn't uploading/installing the tables :/ I use wamp 2.1 and i dont see how it could be out of sync with the plugin.

    Any and all help is wanted and appreciated :) thanks the Jcraft team :)
     
  12. Offline

    PsychoNecrosis

  13. Offline

    RomaClanServer

    Is there a way to permanently delete spawngroups? When I do it in game, they come back when I restart and if I try to do it in the database, it says I can't delete it because it is a parent value to fk_spawngroupid and I can't figure out how to edit that table.
     
  14. Offline

    afmiller

    So are you able to set up guards to protect areas from mobs? Are you able to give them armor / have their health regen?
     
  15. Offline

    DrBowe

    While that may be technically true, it's very confusing for my players to type 'list' and receiver B:5 S:10

    It may be working as intended, but if thats the case, I highly suggest that he flip the two to make it more user friendly.
     
  16. Offline

    PsychoNecrosis

    Go into the DB and find the table spawngroup_entries and delete from there

    THEN delete from Spawngroup table

    Health can be changed in the database, and they will auto attack hostile mobs that enter their line of sight.

    Armour can be applied as laid out in the readme. it will not effect NPC health/survivability.
     
  17. Offline

    RomaClanServer

    I did this but it is still giving me the same error. Do I need to do something to make it realize that those values don't exist?

    Edit: This error specifically:
    Code:
    [B]SQL query:[/B]
             DELETE  FROM  `cstosznpcx`.`spawngroup`  WHERE  `spawngroup`.`id`  =38
         [B]MySQL said: [/B][URL='http://dev.mysql.com/doc/mysql/en/error-messages-server.html'][IMG]http://www.db4free.net/phpMyAdmin/themes/original/img/b_help.png[/IMG][/URL]
      #1451 - Cannot delete or update a parent row: a foreign key constraint  fails (`cstosznpcx`.`spawngroup_entries`, CONSTRAINT `fk_spawngroupid`  FOREIGN KEY (`spawngroupid`) REFERENCES `spawngroup` (`id`) ON DELETE NO  ACTION ON UPDATE NO ACTION)
    
     
  18. Offline

    Phealoon

    is Mixxit (Missing In Action)? I have emailed him and been on his server many times, and I have not been able to speak with him. I even offered to pay him to finish the Quest part of NPCx but I have not yet heard back.
     
  19. Offline

    hakre1

    Anyone else having problems with random blackscreens?
    It seems to happen when I look at a recently added spawngroup and the only solution is to delete it or reload a database backup and re-create it.... Very annoying btw.
     
  20. Offline

    Jcraft-servers

    @ PsychoNecrosis

    I run my mysql server via wamp server and that is all updated i was running big brother off it before and it ran fine.

    May i ask what you use? That way i might be able to get it to work :)

    Once again any help is good :)

    Jcraft team
     
  21. Offline

    Deathlysteve-

    now I dont know if im the only one but I just tried the TEST 689 Bukkit Build... and when I started server NPCX had no problems... but when I Logged into the server... this error came up on the CMD screen:
    Code:
    20:29:00 [SEVERE] Exception in thread "Timer-0"
    20:29:00 [SEVERE] java.lang.NoSuchFieldError: a
    20:29:00 [SEVERE]       at net.gamerservices.npclibfork.CHumanNpc.<init>(CHumanN
    pc.java:27)
    20:29:00 [SEVERE]       at net.gamerservices.npclibfork.NpcSpawner.SpawnBasicHum
    anNpc(NpcSpawner.java:70)
    20:29:00 [SEVERE]       at net.gamerservices.npcx.myNPC.Spawn(myNPC.java:1146)
    20:29:00 [SEVERE]       at net.gamerservices.npcx.npcx.think(npcx.java:381)
    20:29:01 [SEVERE]       at net.gamerservices.npcx.Tick.run(Tick.java:16)
    20:29:01 [SEVERE]       at java.util.TimerThread.mainLoop(Unknown Source)
    20:29:01 [SEVERE]       at java.util.TimerThread.run(Unknown Source)
    I dont know if this could be a quick fix or if it needs to be fixed in the next update but yeh can someone just tell me what this means at least?
     
  22. Offline

    PsychoNecrosis

    A couple of posts back, he said he was taking some time off the plugin because he was getting angry. I don't blame him, after reading 38 pages of people crying about not being able to install MYSQL for their Locally hosted servers :p

    Online servers are different, you guys have my sympathies. I don't look forwards to doing that myself.

    I'm running it on a local machine, so I don't have to deal with any middle man software between the database and my MC server- I was just going by what your error message said and noticed the version difference between my setup and yours :p. Sorry I can't be much more help.


    This plugin is written to work on 670, and works on 677. It's not a great idea to expect things to work when you're both using a test build AND one that wasn't released when the plugin was :p

    Roll back to 677 ;)
     
  23. Offline

    RomaClanServer

    I may be too much of a noob with MYSQL to get what the added difficulty is for online servers. But for me, db4free.net is even easier than locally hosting a database.
     
  24. Offline

    tha d0ctor

    I can create NPCs and SPawn groups but when I try to put an NPC to a spawngroup it say it is created and then an error occurred...?
     
  25. Offline

    darkm3tr01d

    Merchants should be able to deal in non integer values like 0.50 ect.
     
  26. Offline

    PsychoNecrosis

    Creating an npc and adding it

    Code:
    /npcx spawngroup create spawngroup name
    Console: Spawngroup name created with ID[1]
    /npcx npc create npcname
    Console: npc npcname created with ID[1]
    /npcx spawngroup add 1 1
    Console: NPC npcname added to spawngroup name
    
    This is how your entry and console output should look.

    the first 1 is the spawngroup, the second is the npc

    Always spawngroup then NPC to add to spawngroups.
    Hope that helped.
     
  27. Offline

    relik0fages

    I had this problem when I </npcx npc weapon 1 0> sets the weapon to nothing. It kept crashing. Perhaps it has to do with something like that
     
  28. Offline

    Phealoon

    Yes, if you set the weapon to 0 (air) and look at the NPC, it will crash.
     
  29. Offline

    Jcraft-servers

    @ PsychoNecrosis​
    Any chance u could let me know the basics of your DB or the name so i can find my self a tutorial online?​
     
  30. Offline

    DrBowe

    Quick Feature Request: (may already be implemented)

    Make it so that Merchants can be 'buy only' or 'sell only' merchants. Easiest way to do this would to be the 'buy' or 'sell' price while setting up to '-1', which would disable buying/selling the item, depending on where you placed the -1

    Please and thank you.
     
  31. Offline

    hakre1

    Thanks for the info, I am using a custom made User Interface to add my npc's and I think it might have been setting weapons to zero instead of NULL, I will test this.
    It would sure be nice to have some sort of error though instead of an instant lock-up.

    EDIT: Looks like those columns are set to int, meaning NULL isn't an option
     

Share This Page