Save ID script command

[uDe]

Hello guys..

 

May I request a sql command to save Players info into sql table (create new table) after they received items from NPC?

 

Example of SQL table :

 

- Char ID

- Account ID

- Item

- Time

- Date

- Map

 

I'm using eAthena 3ceAM

Edited March 10, 2014 by uDe

[sandbox]

Check out my script http://rathena.org/board/files/file/3118-gm-reward-giver/

[uDe]

Check out my script http://rathena.org/board/files/file/3118-gm-reward-giver/

 

An internal error occurred. Please contact an administrator

Need Help?

• Our help documentation
• Contact the community administrator

 

Let me see first..

Seems like I can't understand sql query very well.. Can you please help me with this?

Edited March 10, 2014 by uDe

[sandbox]

GM rewards a player > player receives item > script logs the transaction in evt_prize table

[uDe]

/*
CREATE TABLE reward_backup
(
char_id varchar(255),
acc_id varchar(255),
item_id varchar(255),
amount varchar(255),
time varchar(255),
map varchar(255)
);
*/

map,x,y,4	script	reward_backup	111,{

.....
.....
.....
set .@Rew_CharID$,getcharid(0);
set .@Rew_AccID$,getcharid(3);
set .@Rew_ITEM??$;
set .@Rew_ITEMAMOUNT$??;
set .@Rew_Time$,gettimestr("%Y-%m/%d %H:%M:%S",21);
set .@Rew_Map$,getmap??;
query_sql "INSERT INTO `reward_backup` VALUES('"+@Rew_CharID$"','"+@Rew_AccID$+"','"+.@Rew_ITEM?$+"','"+@Rew_ITEMAMOUNT$?$+"','"+.@Rew_Time$+"','"+.@Rew_Map$+"')";
getitem 11111,10;
close;
}

Like this? I want to combine it with my personal WoE Reward script. I'm so sorry for not share the whole WOE Reward Script. I can't do that..

But, I had give some example like above..

[sandbox]

yep, it should work properly. make sure to backup!

[uDe]

yep, it should work properly. make sure to backup!

I don't know what to use for item, item amount and map variable..

For item, there's 3 different item will be given according the woe day.. Sunday item id is 11111, Wednesday item id is 11112 and Saturday item id is 11113. Amount of item is 1. For map, it should be new_zone02.