Jump to content
  • 0

Loop reward for guild


Dissidia

Question


  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  535
  • Reputation:   23
  • Joined:  11/19/11
  • Last Seen:  

R> Loop reward for 1 guild. please help. thank you..

 

input guild name then getitem to 1 guild

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2351
  • Joined:  10/28/11
  • Last Seen:  

mes "Enter Guild Name";
input .@guild_name$;
query_sql( "SELECT `guild_id` FROM `guild` WHERE `name` LIKE '"+escape_sql( .@guild_name$ )+"' LIMIT 1",.@gid );
if ( .@gid ) {
	mes "Reward sent.";
	close2;
	addrid(3,0,.@gid);
	getitem 512,1;
	getitem 512,2;
	getitem 512,3;
	mes "Gained Guild Rewards.";
}
close;

something like this...

  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  535
  • Reputation:   23
  • Joined:  11/19/11
  • Last Seen:  

yes thats it. you help me so much 

Emistry

 

btw. it is possible to send via mail box? the reward sir?

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  1268
  • Reputation:   382
  • Joined:  02/03/12
  • Last Seen:  

15 hours ago, Dissidia said:

btw. it is possible to send via mail box? the reward sir?

Kinda but it's dodgy because the SQL server has to be updated and I think it would require a server restart. I do believe there is a mod that allows mail to be sent from script floating around somewhere not sure if it works for the current revision of rAthena though.

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2351
  • Joined:  10/28/11
  • Last Seen:  

18 hours ago, Dissidia said:

btw. it is possible to send via mail box? the reward sir?

npc/custom/woe_controller.txt#L178-L181

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  1268
  • Reputation:   382
  • Joined:  02/03/12
  • Last Seen:  

1 hour ago, Emistry said:

Ok so they only need to re-log that would make sense. I feel like I've tested these things before but I just keep forgetting.

Edited by Skorm
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...