projectinfinity / reportrts Goto Github PK
View Code? Open in Web Editor NEWReport - Realtime Ticket System
Home Page: http://ci.regularbox.com/job/ReportRTS/
License: GNU Lesser General Public License v3.0
Report - Realtime Ticket System
Home Page: http://ci.regularbox.com/job/ReportRTS/
License: GNU Lesser General Public License v3.0
Today I tried to switch from sqlite to MySQL, set the MySQL-option in the config.yml to true and entered the login-details, also I made sure that the database-access works, everything seemed to run smooth from my side.
After reloading the plugin (/reportrts reload) it gave me this error-message: http://pastebin.com/PJn6KfUR and fell back to sqlite. It did not write anything into the database.
I cant find the permission that notify the staff members when have open requests
Is it possible you could add a /comment command for other staff members to comment on a modreq.
I am sure i missed it somewhere in the changelog but it seems the ability to see comments on closed tickets has been removed from everywhere. is this another intentional change?
it accepts the comments and even shows them being add in the console in debug, but you can no longer see any of the comments on closed tickets in game or on the console.
also it picks up the last digit of the ticket number and adds it to the comment, as seen here in the database. : http://imgur.com/GDptmR6
http://ci.nixium.com/view/Manual%20Builds/job/ReportRTS/1/console I could set this up properly if you want to get an account I'll assign you the correct permissions etc.
Running: http://ci.regularbox.com/job/ReportRTS/33/
Upon server reboot, messages.yml is re-written with the default config. If I chmod the file so that no write access it allowed, it keeps my settings.
While I'm here, would you consider converting to a more simple color code formatting using the ampersand codes? (&). Thanks!
this is a test
Put a setting in the config that will allows to limit how many tickets a player can have open at once. This way new players cannot spam the ticket system by making multiple ones, and instead just wait for their stuff to get resolved.
I'd love to be able to search for the different staff and see how many tickets they've completed etc. I'd also like to be able to search for all tickets completed and filled by specific players.
Maybe as part of the check command : eg: '/check completed semajand' will list all tickets completed by Semajnad and '/check created Semajnad' will show all tickets created by Semajnad.
Would it be possible to impliment the option to put a time for your /reportrts ban?
example syntax /reportrts ban notch 10m
One thing I often use is VanishNoPacket to watch players and see if they're following the rules, but if they type /modlist they can see me on the list. Would it be possible to implement the isVanished API into ReportRTS?
It would be great to be able to assign a permission to a group or individuals to have tickets sorted based on priority...maybe even color coded.
So say for donators I could assign a reportrts.priority flag to their group and wheneven they submit a request, their request is coloured differently than other requests and sorted to be displayed first before any tickets from people without that flag.
Basicly you can't seem to check the pages of what requests there is currently on hold.
see stack below
so i can complete tickets via the console but from purpleirc i can not. i get the following error:
An error occurred. Reference: Unable to mark request #2 as complete
this is the latest build with the latest spigot
From bukkitdev:
What is the enhancement in mind? How should it look and feel?
Hi, I have a VERY important feature request which the old ModTRS lacked. The idea is simple. Make tickets expire and auto delete/close after X amount of time in the config. This is so important for us, as we have a lot of players and the tickets that don't get answered just build up. Therefore by the time we get to them, they are 3 days old and obsolete. A simple auto cleanup feature would do wonders for us.
Please provide any additional information below.
I know you might say "just answer the tickets" or "delete them from the database" but this is all about ease of use. And by having old tickets clogging up the system, it can be quite daunting for moderators to see 300-400 tickets when really half of them was just new players "testing" the command.
I've subscribed to your plugin, im really interested in your work :)
Upgraded from a few month old build on an existing database and am presented with the following error whenever attempting to close a ticket.
I'm able to comment on the ticket and people are able to submit them, but I cannot close them.
Migrate player.getName() calls to player.getUniqueID() before all hell breaks loose.
I have run this against a current database imported to my test server. This database has over 2800 rows and goes pretty far back in time. But this update should still work, so I have included my entire test server log for you to look at. The update starts but never gets past 33% before it errors. Also UUID i guess is not working properly for me because I get the same error after boot up at the top of the logs.
Errors -=- http://hastebin.com/yomirobudi.txt
EDIT: I am using the latest dev build #182
Please add the ability to complete tickets from the console so ReportRTS can be interacted with custom console scripts and other plugins.
/mod-broadcast -o Please notice that where is an event at ***, please notify the administrator if you have time.
Just an example.
I should be able to run all commands against the console regardless of permissions please.
complete 1 test
[11:22:45 INFO]: You need permission to do that: reportrts.command.complete or reportrts.command.complete.self
EDIT: Featured on my blog ! http://jkrau.se/2014/01/the-chronicles-of-the-bong-cord-integration-project-46/
If you are wondering if you have permission to pull the BungeeCord code from CraftedMiner's ReportRTS repository, you now have my permission. I'm not sure if you have permission on behalf of Sway, but that won't matter and here's why:
The reason I'm making such decision is because everybody would not only benefit such feature, but I am also not engaged in Minecraft anymore as I'm now too busy to update and manage such code. I'm also more interested in Starbound than trying to figure out a game that has been digging it's own gravestone since 1.3. The game's community has also gone to shit since then, and there's no point since I've lost so much interest.
If you want, I can pull the code out of it and make a Pull Request, but it would take some time to do so.
If you also need the source in question, you can go to:
https://bitbucket.org/craftedminers/reportrts
This took nearly a week to do and it took up most of my personal time. If I'm not going to get much out of this anytime soon, I might as well make it open source so people can get it.
I'm sorry Sway if you're reading this, but this is for the best of me to just simply get the message across and give the support to everybody. Besides, there were builds being passed to other higher-up popular server owners and I still haven't received much credibility (to my knowledge since I've disappeared for a while).
I updated to the latest dev build on one of my servers and it got into an endless loop.
[07:58:12 INFO]: [ReportRTS] ----------------------------
[07:58:12 INFO]: [ReportRTS] Updated 0 player entries.
[07:58:12 INFO]: [ReportRTS] Progress: 549/550 99.82%
[07:58:12 INFO]: [ReportRTS] ----------------------------
[07:58:12 INFO]: [ReportRTS] Updated 0 player entries.
[07:58:12 INFO]: [ReportRTS] Progress: 549/550 99.82%
[07:58:12 INFO]: [ReportRTS] ----------------------------
[07:58:12 INFO]: [ReportRTS] Updated 0 player entries.
[07:58:12 INFO]: [ReportRTS] Progress: 549/550 99.82%
[07:58:12 INFO]: [ReportRTS] ----------------------------
[07:58:12 INFO]: [ReportRTS] Updated 0 player entries.
[07:58:12 INFO]: [ReportRTS] Progress: 549/550 99.82%
.... TO INFINITY AND BEYOND ...
I checked the data and found the issue.
SELECT COUNT(name
) FROM reportrts_user
WHERE uuid
IS NULL OR uuid
= '';
+---------------+
| COUNT(name
) |
+---------------+
| 1 |
+---------------+
1 row in set (0.00 sec)
SELECT * FROM reportrts_user
WHERE uuid
IS NULL OR uuid
= '';
+----+----------+------+--------+
| id | name | uuid | banned |
+----+----------+------+--------+
| 37 | bluesfan | NULL | 1 |
+----+----------+------+--------+
1 row in set (0.00 sec)
(cindy_k) The account Bluesfan (3019cb4fda72432db4045e288657baa4, legacy) exists. It is NOT a paid account.
So this account somehow got into my database, even though it wasn't paid and caused the issue.
I updated it by hand for now.
update reportrts_user set uuid
= "3019cb4f-da72-432d-b404-5e288657baa4" where id = 37;
You need to check for failed returns from mojang and probably make an exception table or something. Thanks!
I upgraded, and that didnt go well because of some old IGNs without UUIDs. So I dropped the tables and decided to start fresh, but now it can not create the reportrts_user table and reportrts does not work.
[11:08:52 INFO]: [ReportRTS] Enabling ReportRTS v1.2.0-b175
[11:08:52 WARN]: [ReportRTS] BungeeCord support enabled, but server name is not set yet. Scheduling a name-update task.
[11:08:52 INFO]: [ReportRTS] Connecting to MySQL.
[11:08:52 INFO]: [ReportRTS] Created reportrts_request table.
[11:08:52 INFO]: [ReportRTS] Created reportrts_user table.
[11:08:52 WARN]: [ReportRTS] Could not access MySQL tables.
[11:08:52 ERROR]: Encountered an error while attempting to connect to the database. Disabling...
[11:08:52 INFO]: [ReportRTS] Disabling ReportRTS v1.2.0-b175
[11:08:52 ERROR]: Error occurred while enabling ReportRTS v1.2.0-b175 (Is it up to date?)
java.lang.NullPointerException
at com.nyancraft.reportrts.persistence.SQLDB.populateRequestMap(SQLDB.java:122) ~[?:?]
at com.nyancraft.reportrts.RTSFunctions.sync(RTSFunctions.java:90) ~[?:?]
at com.nyancraft.reportrts.ReportRTS.reloadPlugin(ReportRTS.java:211) ~[?:?]
at com.nyancraft.reportrts.ReportRTS.onEnable(ReportRTS.java:107) ~[?:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) ~[spigot.jar:git-Spigot-1487]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324) [spigot.jar:git-Spigot-1487]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [spigot.jar:git-Spigot-1487]
at co.technius.PluginManager.PMCommandExecutor.reloadCmd(PMCommandExecutor.java:710) [PluginManager.jar:?]
at co.technius.PluginManager.PMCommandExecutor.onCommand(PMCommandExecutor.java:499) [PluginManager.jar:?]
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) [spigot.jar:git-Spigot-1487]
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:180) [spigot.jar:git-Spigot-1487]
at org.bukkit.craftbukkit.v1_7_R3.CraftServer.dispatchCommand(CraftServer.java:726) [spigot.jar:git-Spigot-1487]
at org.bukkit.craftbukkit.v1_7_R3.CraftServer.dispatchServerCommand(CraftServer.java:713) [spigot.jar:git-Spigot-1487]
at net.minecraft.server.v1_7_R3.DedicatedServer.aB(DedicatedServer.java:319) [spigot.jar:git-Spigot-1487]
at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:284) [spigot.jar:git-Spigot-1487]
at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:583) [spigot.jar:git-Spigot-1487]
at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:489) [spigot.jar:git-Spigot-1487]
at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [spigot.jar:git-Spigot-1487]
Firstly sorry if this was the wrong place to post requests/suggestions however couldn't get hold of anyone in the IRC to check.
Was just a small suggestion with the stats system, would love it to be able to check the stats between two given dates or since a given date, for example;
/reportrts stats notch 01/01/2015
Would check the stats since that date and;
/reportrts stats notch 01/01/2015 07/01/2015
Would check the stats between those dates.
The only other thing i'd like to suggest is being able to run a stats check on all people at once, thanks for your time. Great plugin and keep up the good work!
my reportRTS provides me no stack error. However, none of the commands seem to work, while they did previously when i updated t spigot 1.7.10 (protocolhack 1.8).
Ive tried removing and re-adding the system, but to no avail. Any advise?
A problem we often have with our players is that they are unaware that their ticket has been closed, so they simply file another one. This can happen 3 or 4 times before a user finally sees that their ticket has been answered and what the answer was. If they could check the closed items, it'd be EXTREMELY helpful.
Thanks :)
Re-Query the tickets displayed on /check every time /check is run or there is an announce interval. Hooking ReportRTS up to 2 servers using the same database causes collisions that make ticket states open and close on each server.
Only one entry is shown when 400 should have been. Stats work fine.
Please add the feature to view a ticket-list in a minecraft-scoreboard on the side.
A help menu should be added for when you execute /ticket without any arguments, or with an incorrect subcommand.
This would increase usability a great deal. Thanks.
Not sure what this is, I can complete requests and I can check old requests, but whenever I do I get an error and severe lag spike on the server.
10:38:24 PM CONSOLE: [SEVERE] java.sql.SQLException: [SQLITE_BUSY] The database file is locked (database is locked)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.DB.newSQLException(DB.java:383)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.DB.newSQLException(DB.java:387)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.DB.throwex(DB.java:374)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.NativeDB.prepare(Native Method)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.DB.prepare(DB.java:123)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.PrepStmt.(PrepStmt.java:42)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.Conn.prepareStatement(Conn.java:404)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.Conn.prepareStatement(Conn.java:399)
10:38:24 PM CONSOLE: [SEVERE] at org.sqlite.Conn.prepareStatement(Conn.java:383)
10:38:24 PM CONSOLE: [SEVERE] at com.nyancraft.reportrts.persistence.SQLDB.getUserId(SQLDB.java:78)
10:38:24 PM CONSOLE: [SEVERE] at com.nyancraft.reportrts.command.ModreqCommand.onCommand(ModreqCommand.java:54)
10:38:24 PM CONSOLE: [SEVERE] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
10:38:24 PM CONSOLE: [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:186)
10:38:24 PM CONSOLE: [SEVERE] at org.bukkit.craftbukkit.v1_4_R1.CraftServer.dispatchCommand(CraftServer.java:514)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.PlayerConnection.handleCommand(PlayerConnection.java:980)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.PlayerConnection.chat(PlayerConnection.java:898)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.PlayerConnection.a(PlayerConnection.java:853)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.Packet3Chat.handle(Packet3Chat.java:44)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.NetworkManager.b(NetworkManager.java:290)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.PlayerConnection.d(PlayerConnection.java:113)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.ServerConnection.b(SourceFile:39)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.DedicatedServerConnection.b(SourceFile:30)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.r(MinecraftServer.java:598)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.DedicatedServer.r(DedicatedServer.java:224)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.q(MinecraftServer.java:494)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.run(MinecraftServer.java:427)
10:38:24 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.ThreadServerApplication.run(SourceFile:849)
From bukkitdev:
What is the enhancement in mind? How should it look and feel?
Say a couple of moderators are online. They get a modreq come through asking for an area to be worldedited. But moderators don't have high enough permission to do worldedit, they need to transfer the ticket to the Admins. So they can /assign .
Please provide any additional information below.
Command: /Assign
Alias: /transfer
The only downside is that a ticket that is assigned to an offline member of staff will make the player think their ticket is being dealt with right now, so maybe make a different message saying "Your ticket has been transferred. Please continue to wait." Or something along them lines...
2012-11-17 12:08:34 [INFO] [ReportRTS] Enabling ReportRTS v1.0.0-b110
2012-11-17 12:08:34 [INFO] [ReportRTS] Connecting to SQLite.
2012-11-17 12:08:34 [SEVERE] java.lang.UnsatisfiedLinkError: /tmp/sqlite-3.7.2-libsqlitejdbc.so: /tmp/sqlite-3.7.2-libsqlitejdbc.so: failed to map segment from shared object: Operation not permitted
2012-11-17 12:08:35 [INFO] [ReportRTS] Created reportrts_request table.
2012-11-17 12:08:35 [INFO] [ReportRTS] Created reportrts_user table.
2012-11-17 12:08:35 [INFO] [ReportRTS] Vault and a compatible permissions manager was found. Using Vault for permissions.
add a function that allows staff to teleport to the location the ticket was opened
Error: http://paste2.org/0ACnNIj3
Using the latest dev version of ModReq (1.2 I believe) and 1.7.9 craftbukkit.
I would like to have a mail-system included in the plugin (Offline-msg support).
Staff should be able to communicate with a player even though a ticket is still opened. Messages should be assigned to tickets and should be visible in a tickets history.
Command-suggestions:
/ticket msg [id] [msg] => Send a message to the ticket-creator
/ticket read [id] => Shows message history as well?
Is there a way to do this? I'd love to use it for my server, but I don't have a MySQL database. If there is a way to do this and I'm just being an idiot, please tell me. If not, I'd love to see this option added. :)
I am wondering if it is possible to add a command like /elevate?
For example,
There are 2 ranks of moderators on my server, and 2 ranks of admin.
Mini-Mod,
Senior-Mod,
Admin,
Head-Admin,
What i am requesting is as follows,
/modreq Spawn is griefed and all around it is stray lava blocks
Modreq 2347 has been created. A staff should be with you shortly.
(Mini-Mod) I dont have access to build at spawn, I better evevate this modreq.
/elevate 2347
(Senior-Mod) Wow, This is serious, I better contact admin right away.
/elevate 2347
(Admin)
/claim 2347
Wow, spawn has been griefed. I am going to fix this.
/done 2347
And that is it. Do you understand what i am asking?
The best place to reach me is at:
http://plugins.enjin.com/profile/1895278
if you cant reach me there, then you can try my email. But i do not check it very often.
See my stack below
http://pastebin.com/up4HBMd7
not sure if its just my client but the tooltips dont wrap and go off the side of the screen
Hi
/mb komand for staff chat have unworking permissions
I add my staff reportrts.command.brodcast and they can only write /mb message but they don't see it and from others
I use PEX
last 1.4.5 build of bukkit
the same is when i add reportrts.* for staff they still don't see it only op
so with things like buycraft and minecraftmarket when someone buys a pack we want them to have a ticket opened, when i try to sudo the command to open a ticket, however when we try to sudo {name} ticket open blag blah i bought blah
nothing happens the same is true when we try to manually sudo <ign> modreq i need some help
nothing happens
not sure why, it used to work before the new ticket command system, is there a way to fix this so we can sudo tickets for people?
EDIT: even in game i can not "sudo" a modreq or ticket open command, basically nothing happens, no errors or anything, sudo iirc is a essentials command.
It's supposed to be in descending order.
Edit: Only affects rewrite.
Every so often this happens. ReportRTS simply doesnt work. Majority of commands like /done, /claim and others just result in an error.
Also note that in my plugin folder for ReportRTS another file appears by the name of: ReportRTS.db-journal
Deleting it usually solves the problem. Not sure if its my host or the plugin.
Version: Newest (v0.43)
Type: SQLite
Heres Error log:
A lot of server hosts are still using mysql 5.1. That means it doesnt support utf8mb4 so I can't run your plugin. Could you maybe change it or add mysql 5.1 support :)?
Thank you.
Hello,
If a staff member has vanish with VanishNoPacket or Essentials /vanish and once they go into Vanish and given a user to the permission node reportrts.command.modlist - Permission to show online moderators.
Users can see staff online that are in vanish.
Regards,
Cory
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.