1. Easiest way to do it:
Code:
USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_set_guild_block_time] Script Date: 29.06.2012 15:37:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_set_guild_block_time
ALTER PROCEDURE [dbo].[smp_set_guild_block_time]
@IN_PLAYER_SID INT,
@IN_GUILD_BLOCK_TIME DATETIME
AS
SET NOCOUNT ON
--update Character set guild_block_time = @IN_GUILD_BLOCK_TIME where sid = @IN_PLAYER_SID
2. Easiest way in your .lua
Add
Code:
set_guild_block_time(0)
guildblocktime will set to 0 on relog.
3. Write a function for one NPC.
If you want to do this for rupees. You have to add it to a NPC like the Guild Master. It's not really hard there are several tutorials discribing how to edit the NPCs.