WordsUp

Can i ask/request for a compilation of item sprite with item_db also? much better if there is no script/item effects on the item_db yet thanks in advance

ahh okay thanks i will try that

the query_sql works fine it saves into my sql correctly. the char_id and guild_id i didn't understand sorry.

I have created this code for my server and inserted it on my agit_template.txt file but the problem is everytime the emp is broken it didn't return query_sql "SELECT `char_id` FROM `char` WHERE `char_id` = '"+getcharid(0)+"'",@exist$; if (getarraysize(@exist$) != 0){ query_sql "UPDATE `char` SET `empbreak` = `empbreak` + '1' WHERE `char_id` = '"+getcharid(0)+"'"; end; } query_sql "SELECT `guild_id` FROM `woe_guild_breaks` WHERE `guild_id` = '"+getcharid(2)+"'",@GDExist$; if (getarraysize(@GDExist$) != 0){ query_sql "UPDATE `woe_guild_breaks` SET `id` = `id` + '1' WHERE `guild_id` = '"+getcharid(2)+"'"; } else { query_sql "INSERT INTO `woe_guild_breaks` (`castle_id`, `guild_id`, `id`) VALUES ('15','"+getcharid(2)+"','1')"; end; }

i see OnAgitBreak: on agit_template.txt so i need to put that in there?

i need to attach a player also hmm i will search about that.

getcharid(2) is use to find a guild name right?

it still not recording on my sql

LOL emistry sort of like that hahaha. anyways thanks alot

then if .@ignore is no need then i can make it like this one? if (query_sql("select `guild_id` from `woe_record` where `guild_id` = '"+getcharid(2)+"'")) { query_sql("update `woe_record` set `id` = `id`+1 where `guild_id` = '"+getcharid(2)+"'"); }

is it possible to have 3 random item to choose from?

thanks for helping emistry i will reupdate my files and include you in my script thanks again. btw i want it to be every player can roll 1

thanks for the reply zero but can i ask if this works if i use it? or should i need to change anything for this code to work

well im new at this so i don't know much about it yet. but i will try to change it. still in progress on developing it

A simple script which allow player to gain item using this npc in exchange of event ticket (you can change if you want) Npc give a random item from the list. Players can exchange it using Event ticket this work one time per day you can change it in what you want. find OnHour24: and change it to what you want. OnHour24 is 12:00AM you can check the script for more details. i want to make it 3 random item every roll but i don't know how hahaha. roll machine.txt roll machine(24hours).txt