Resetting Items

How can I reset items in my Metro 2033 server?

The economy totally flunked and we need an item reset.

 

delete all the characters on the sql

 

That's not how you delete items, that's how you delete characters, who happen to have items.

Very different things.

 

Go through your SQL database and individually remove the items from each character, I'd talk you through it but you have a tendency to ignore me.

 

This is also very bad advice.

Not only will this be EXTREMELY time consuming, but you can use a simple lua script to remove items. No need for SQL at all.

 

Unless you can provide one for FayZ, he's going to need to go through the database himself.

 

Ya, I have no clue where to start with that.

"go into mysql and delete"

yep thanks.

 

I recall you calling yourself a coder.
It's not too hard, empty the Inventory table.

 

It's not that hard, you don't even have to do it manually. Just shift-click and replace the entire inventory column in the characters table with the empty inventory preset. I personally wouldn't blank out the entire line, as I recall that causing problems back in Nexus.

 

How to get into mysql.

LOL sorry I have no idea how to do this, just because you can code doesn't mean you know how to do this...

 

I rarely recommend messing with SQL at all, but whatever, try executing this as an SQL query.

Code:

UPDATE characters SET _Inventory = ''

 

where to put that lol.

 

Execute it as an SQL query.

 

how to execute as sql query

 

I dunno if you rent a server or anything, but if you've got remote access to your database, you can use a client like SQLyog, navicat, MySQL query browser (free I believe). If you don't have remote access, you can probably access it through phpMyAdmin at your server control panel.