SELECT * FROM `catalog_items` WHERE `item_id` = 'ID HERE';
You can find the ID HERE value by checking inside the furniture table for that specific item's ID.
This week has been slightly slow just due to Alex being in holiday and myself doing side work and working a full-time job, but in my free time I've been slowly working towards creating a self-hosted imager to handle all of the assets for the client (Kinda like a CDN I suppose). I've recently had...
You'll want to add the namecolors such as the link Adrian sent and then add them to the catalog purchase packet so when an item with a color is bought it will change the color of their chat. You don't need a color command unless you want to allow them to swap between colors that they've...
You'll want to first login to the VPS using an SSH client (I recommend PuTTY -- https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html). If you're unsure about how to do this a quick Google search of "how do I connect to a Linux server using SSH CLIENT HERE" will almost always do the...
We are currently using MySQL as a database server, however the library we utilize for the database side of things (Bookshelf) has compatibility for PostgreSQL and SQLite3 so those are both options as well. I debated going the MongoDB route but changed my mind due to simplicity down the road with...
Updated.
With retro owners these days that can't even be trusted not to take part in malicious events using passwords/IP's found within their database, the last thing I'd be doing would be downloading a client and allowing them to run on my computer. Hell, you can hardly trust some of the...
As JMG said you'd just need to run an insert query to insert the furniture into the database if they're offline and you'd also probably want to use RCON to give them the item if they are online.
My favorite part is "Basic support will still be available but will be limited to:" and then goes on to say "Basic Support needs"
Isn't that the same thing as what's already listed because he has defined what a basic support need would be, lol.