Jump to content
  • 0

Q>Delete SQL Item


GM Winter

Question


  • Group:  Members
  • Topic Count:  176
  • Topics Per Day:  0.14
  • Content Count:  666
  • Reputation:   9
  • Joined:  12/04/20
  • Last Seen:  

hello guys i would like to ask how to delete specific item in the SQL , in my case one of my Player Get bug in wearing one item so it means he wear it then after he wear it he get crash and he cant login in the game so i would like to ask how to delete the item he is wearing so he can login in the game thank in advance more power rathena Team!!!

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  477
  • Reputation:   269
  • Joined:  06/13/17
  • Last Seen:  

Edit the Equip value of the item to 0 from the inventory table.. 

  • Love 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  176
  • Topics Per Day:  0.14
  • Content Count:  666
  • Reputation:   9
  • Joined:  12/04/20
  • Last Seen:  

hello sir i try to search its item id in the inventory table but its nothing there it is just a simple item but cause the player bug  item monocle item id 2239 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1599
  • Reputation:   246
  • Joined:  08/03/12
  • Last Seen:  

1 hour ago, chadness said:

hello sir i try to search its item id in the inventory table but its nothing there it is just a simple item but cause the player bug  item monocle item id 2239 

then go to inventory table in your database/mysql/phpmyadmin then find/search for itemid 2239. delete it.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  255
  • Reputation:   234
  • Joined:  07/24/13
  • Last Seen:  

6 hours ago, chadness said:

hello guys i would like to ask how to delete specific item in the SQL , in my case one of my Player Get bug in wearing one item so it means he wear it then after he wear it he get crash and he cant login in the game so i would like to ask how to delete the item he is wearing so he can login in the game thank in advance more power rathena Team!!!

Also when you delete items (only if it is headgear or robe) from inventory you should update `char` table: set value 0 for head_top, head_mid, head_bottom, robe.

SELECT * FROM `inventory` WHERE char_id = <char id> AND equip > 0;
UPDATE `char` SET head_top = 0, head_mid = 0, head_bottom = 0, robe = 0 WHERE char_id = <char id>;

 

Edited by Balfear
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...