Save Character SQL Item Data

[alkhaleej]

Please help. I want to save a character's item data on sql using script. I searched and found this:

 

http://rathena.org/board/topic/76537-save-character-data/

 

but is not specific to what I would like to happen.

 

The reason I want this is to check a card and delete it on its actual location the same time the script will check for it.

 

Can

*getinventorylist;

do this job? I've read about this inside 

 

trunk/doc/script_commands.txt

[AnnieRuru]

let me guess ...

you are trying to write an utility script which search for all characters with a certain mvp card ID

if the player has the mvp card ID, the gm can then proceed to remove the card

I know how to tackle this

its better to separate your search with online characters and offline characters

in online characters, use addrid and getinventorylist

in offline characters, use query_sql

then there's no need the hassle to update the table which might overwrite the value wrongly when the server do an interval character update

EDIT:

I just recall when I worked on a server ...

that admin used @ban character temporary when he suspect that player is cheating

then @unban when its done

this trick might work too ... lol

Edited January 12, 2014 by AnnieRuru

[alkhaleej]

let me guess ...

you are trying to write an utility script which search for all characters with a certain mvp card ID

if the player has the mvp card ID, the gm can then proceed to remove the card

 

You've guessed it right Annie. I'll try *getinventorylist; instead. Thank you for the reply.