ReportRTS

Table of Contents

ReportRTS

Development builds of this project can be acquired at the provided continuous integration server. These builds have not been approved by the BukkitDev staff. Use them at your own risk.

Development Builds

Stats

Commands & Permissions | Follow my progress on Trello | IRC: #ReportRTS (irc.esper.net)

ReportRTS stands for Report - Realtime Ticket System, it is designed to be a easy to use and feature rich support system.

Features

Supports multi-server setups using BungeeCord.
Uses MySQL, this allows you to easily display information from the database.
"Caches" open tickets to reduce access time.

Usage

See Commands & Permissions.

Notes

Metrics

To determine popularity of versions, features, and lingering usage, plugin installs are automatically tracked by the Metrics plugin tracking system and forwarded to mcstats.org for analysis. Basic server information (Version, player count used) is tracked. If you don't want to help or are paranoid, edit plugins/PluginMetrics/config.yml and set opt-out to true.

UUIDFetcher

Does not collect data at all. Simply used to retrieve a player's UUID from Mojang's API if he does not have one in the database prior to ReportRTS version 1.2.0.

Version checking

By default ReportRTS checks dev.bukkit.org for ReportRTS updates, you can disable this by setting versionCheck to false in the configuration.

Developers

I accept pull requests.

Maven repository

<repository>
    <id>projectinfinity-repo</id>
    <name>ProjectInfinity repository</name>
    <url>http://ci.regularbox.com/plugin/repository/everything</url>
</repository>

<dependency>
    <groupId>com.nyancraft.reportrts</groupId>
    <artifactId>ReportRTS</artifactId>
    <version>1.2.3</version>
</dependency>

Support me!

Why support me?

All the more motivation to continue work on this project. During it's two years of existence I have received a total of $270 and promises that never saw the light of day.

Say if I have spent a total of 500 (this is an example number, in reality it is much higher and just keeps increasing) hours working on this project. That gives me a total of $0.54 an hour, compare this to the average wage of a McDonalds worker in the US which is $7.81. Had they worked 500 hours they would have made $3905.

If you find that this project has helped you, please consider donating to this project.

Comments

_ForgeUser9386225
- Join Date: 8/10/2012
- Posts: 91
- Member Details
#271 _ForgeUser9386225

View User Profile

Send Message

Posted Aug 18, 2012
How can you change the /modreq command? I want it to be /ticket and I want /reportrts to be /report. Any simple way? (or could you upload a updated version of this? =))

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#270 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 17, 2012
@PhanaticD

Already exists. /reportrts reset

Rollback Post to Revision RollBack
phanaticd
- Location: NJ
- Join Date: 6/21/2011
- Posts: 434
- Member Details
#269 phanaticd

View User Profile

Send Message

Posted Aug 16, 2012
can i suggest a command that empties the reports database, i manually have to do it now but would be nice to have a command

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#268 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 15, 2012
@HexaDroid

Well, with most of your plugins you probably do not want to change the DATABASE that is being used. That is quite more than just changing a message for instance.

So far, there is only two things that cannot be reloaded live (using /reportrts reload):

Database
Nag timer
Rollback Post to Revision RollBack
_ForgeUser3932112
- Join Date: 1/29/2010
- Posts: 93
- Member Details
#267 _ForgeUser3932112

View User Profile

Send Message

Posted Aug 14, 2012
@ProjectInfinity

Hmm alright. I always do this with my plugins. I think this is the first time its actually required to be off.

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#266 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 13, 2012
@HexaDroid

You need to make sure that the server is off when you tell it to change database type. Your problem is that you set the value when the server is running and expect it to stay that way. At the very least you need to do /reportrts reload after changing a config value, however that will not let you change database TYPE on the fly.

TL;DR: Turn server off, change to enable: false, start server.

Rollback Post to Revision RollBack
_ForgeUser3932112
- Join Date: 1/29/2010
- Posts: 93
- Member Details
#265 _ForgeUser3932112

View User Profile

Send Message

Posted Aug 13, 2012
I keep setting mysql: enable: false

But every time it resets to enable:true when I restart server.

2012-08-13 16:27:50 [INFO] [ReportRTS] Enabling ReportRTS v0.4.2 2012-08-13 16:27:50 [INFO] [ReportRTS] Connecting to MySQL. 2012-08-13 16:27:51 [INFO] [ReportRTS] Successfully connected and checked tables, will use MySQL. 2012-08-13 16:27:51 [INFO] [ReportRTS] Vault and a compatible permissions manager was found. Using Vault for permissions.

So I can't turn off the mysql... and just keep getting the error below when I complete a ticket. Other commands like /check /claim etc work fine

PS sorry for spam

Rollback Post to Revision RollBack
_ForgeUser3932112
- Join Date: 1/29/2010
- Posts: 93
- Member Details
#264 _ForgeUser3932112

View User Profile

Send Message

Posted Aug 13, 2012
@ProjectInfinity

When I complete a ticket it says this.

2012-08-13 16:16:05 [SEVERE] java.sql.SQLException: Before start of result set 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:841) 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5656) 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5576) 2012-08-13 16:16:05 [SEVERE] at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616) 2012-08-13 16:16:05 [SEVERE] at com.nyancraft.reportrts.persistence.SQLDB.getUserName(Unknown Source) 2012-08-13 16:16:05 [SEVERE] at com.nyancraft.reportrts.command.CheckCommand.checkId(Unknown Source) 2012-08-13 16:16:05 [SEVERE] at com.nyancraft.reportrts.command.CheckCommand.onCommand(Unknown Source) 2012-08-13 16:16:05 [SEVERE] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40) 2012-08-13 16:16:05 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) 2012-08-13 16:16:05 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:492) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:878) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.NetworkManager.b(NetworkManager.java:276) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.ServerConnection.b(SourceFile:35) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406) 2012-08-13 16:16:05 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#263 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 13, 2012
@mumblerit

I'd be interested to see some server logs from when a ticket that shows "handled by NULL" is completed.

Rollback Post to Revision RollBack
_ForgeUser3945
- Join Date: 2/19/2005
- Posts: 133
- Member Details
#262 _ForgeUser3945

View User Profile

Send Message

Posted Aug 12, 2012
@ProjectInfinity

seeing this occasionally as well.

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#261 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 12, 2012
@HexaDroid

How do you complete it? Through in-game? Then yes it is a bug. It should never say handled by NULL. As that means bukkit itself has returned NULL for your playername.. which is definitely not right.

Rollback Post to Revision RollBack
_ForgeUser3932112
- Join Date: 1/29/2010
- Posts: 93
- Member Details
#260 _ForgeUser3932112

View User Profile

Send Message

Posted Aug 12, 2012
I'm using this with MySQL and every time I complete a ticket and check it. It always says 'handled by null'. Not sure if this is a bug?

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#259 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 12, 2012
@numskull34

There are no plans for any sort of communication system in this plugin.

As for removing completed requests, there are no way of doing this with SQLite. However if you are on MySQL, you can do a query to remove completed request (status = 3). As they are not cached within the plugin.

Rollback Post to Revision RollBack
_ForgeUser3379751
- Join Date: 10/11/2009
- Posts: 44
- Member Details
#258 _ForgeUser3379751

View User Profile

Send Message

Posted Aug 12, 2012
hello there love this plugin however is can you make it so you can remove only completed tickets the only thing i can find atm is "/reportrts reset" which removes everything. also is there or can there be a way to message the person opening the request through the plugin like a "/r-id (claim#) (message)" then be able to have the conversation saved with in the req. for later reference. anyway just a few suggestions. all in all a great plugin

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#257 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 11, 2012
@HexaDroid

It is not designed to do that. HOWEVER!

If you set the plugin to do MySQL, then install something such as ... JSONAPI for instance. You can create PHP scripts that will thanks to the MySQL data, know what data to send over JSONAPI that will run commands on the server.

Sure, everything will be completed as console etc etc. Nothing I can do about that. However it allows to to control it entirely through a PHP script.

Big note though: Do not, and I repeat, do not make any changes to the database and believe that it will be reflected in-game. Quite a few requests are cached and changes made in the MySQL database by third-party software will not be reflected in the plugin. The exception is tickets with the status "3", aka closed.

Rollback Post to Revision RollBack
_ForgeUser3932112
- Join Date: 1/29/2010
- Posts: 93
- Member Details
#256 _ForgeUser3932112

View User Profile

Send Message

Posted Aug 11, 2012
If you could make an editable html page/module it would be awsome. I'd love to answer the basic tickets through my website.

Rollback Post to Revision RollBack
_ForgeUser7986524
- Join Date: 12/1/2011
- Posts: 34
- Member Details
#254 _ForgeUser7986524

View User Profile

Send Message

Posted Aug 10, 2012
Hello, I recently made a tutorial on your plugin awesome plugin, ReportRTS. You can check it out here http://youtu.be/_KJNRg7nwuE If you like it and support what it goes over feel free to include it in your post. Love the plugin! Regards, Kenny Williams

Rollback Post to Revision RollBack
_ForgeUser9160271
- Join Date: 7/9/2012
- Posts: 213
- Member Details
#253 _ForgeUser9160271

View User Profile

Send Message

Posted Aug 10, 2012
@ProjectInfinity

Hey, i may be a flaming homosexual but please can you stop making fun of me about it?

Thanks, and i don't really have a huge problem with you and your server anymore so i'm going to be mature, do us both a favor, and put this behind us, mkay?

Rollback Post to Revision RollBack
_ForgeUser6851956
- Join Date: 5/20/2011
- Posts: 572
- Member Details
#252 _ForgeUser6851956

View User Profile

Send Message

Posted Aug 9, 2012
@zSwayz

I shouldn't help you, but unlike you I value public image.

Read here: http://dev.bukkit.org/server-mods/reportrts/pages/permissions/

Rollback Post to Revision RollBack
_ForgeUser9160271
- Join Date: 7/9/2012
- Posts: 213
- Member Details
#251 _ForgeUser9160271

View User Profile

Send Message

Posted Aug 9, 2012
@ProjectInfinity

cant find PEX perm nodes anywhere bro! Miss u btw ;) you miss me too? LAWL

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Project ID

36853
Created

Feb 23, 2012
Last Released File

Aug 18, 2014
Total Downloads

31,685
License

GNU Lesser General Public Lice...

v1.2.2
Aug 18, 2014
v0.4.3
Sep 5, 2012

Bukkit

ReportRTS

Bukkit Plugins

ReportRTS

Table of Contents

Features

Usage

Notes

Metrics

UUIDFetcher

Version checking

Developers

Maven repository

Support me!

Comments

About This Project

Categories

Members

Recent Files

Bukkit