angelicaaurora

I would also like to know that.

Thanks, delete this topic...

How to enable logging for crashs on Linux?

My server has been suffering many crashs after update to version 3.3.5.

OS: Ubuntu Linux 10.04 X64 Server

Intel® Xeon® CPU E5620 @ 2.40GHz, 16 cores (4x4QUAD)

Real memory 11.75 GB total, 707.62 MB used (12GB)

Local disk space 129.09 GB total, 13.29 GB used ( 146 GB 15K RPM SCSI/SAS HDD)

1000 Mbps Uplink

Players on: +- 150

Thanks!

Now it worked perfectly.

You have assigned permissions to the folders?

sudo chmod -R 777 root /var/www/Your Folder Site

Thank you for the update.

Well, finally I could came to the correct query.

Just replace the

1. and <NEWENTRY> marks in the following query.

UPDATE `item_instance` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 3) AS CHAR), ' ', <NEW ENTRY>, ' ',
CAST(SUBSTRING_INDEX(`data`, ' ', -61) AS CHAR)) WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 4), ' ', -1) AS UNSIGNED) = [list=1];
UPDATE character_inventory SET item_template = <NEWENTRY> WHERE item_template = [list=1];

Here an example

UPDATE `item_instance` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 3) AS CHAR), ' ', 1313, ' ',
CAST(SUBSTRING_INDEX(`data`, ' ', -61) AS CHAR)) WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 4), ' ', -1) AS UNSIGNED) = 75000;
UPDATE character_inventory SET item_template = 1313 WHERE item_template = 75000;

This works with backpacks?

Edit the file "item.dbc" does not work.

Does anyone have any other ideas?