[Help Thread] Please post your questions here.

Quote:

Originally Posted by .BlackCat. If you don't have dbo.IPLog Table on your Auth , create it using : Code: USE [Auth] GO /****** Object: Table [dbo].[IPLog] Script Date: 22/02/2014 08:28:23 ******/ DROP TABLE [dbo].[IPLog] GO /****** Object: Table [dbo].[IPLog] Script Date: 22/02/2014 08:28:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[IPLog]( [account_id] [int] NULL, [account_name] [nvarchar](32) NOT NULL, [ip] [nvarchar](50) NOT NULL, [login_date] [date] NOT NULL, [login_time] [time](7) NOT NULL ) ON [PRIMARY] GO INSERT [dbo].[IPLog] ([account_id], [account_name], [ip], [login_date], [login_time]) VALUES (8715, N'BlackCat', N'127.0.0.1', CAST(0x23380B00 AS Date), CAST(0x076099F554520000 AS Time)) & smp_account like that : Code: USE [Auth] GO /****** Object: StoredProcedure [dbo].[smp_account] Script Date: 22/02/2014 08:26:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[smp_account] @IN_ACCOUNT nvarchar(31), @IN_GAMECODE nvarchar(50), @IN_PASSWORD nvarchar(32) AS SET NOCOUNT ON DECLARE @THIS_ACCOUNT_ID INT SELECT @THIS_ACCOUNT_ID=account_id FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT INSERT INTO dbo.IPLog( account_id, account_name, ip, login_date, login_time )VALUES( @THIS_ACCOUNT_ID, @IN_ACCOUNT, @IN_GAMECODE, GETDATE(), GETDATE() ) SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT AND password = @IN_PASSWORD RETURN @@ERROR If you don't have "Accounts" table like mine . EDIT THE SMP .

Quote:

Originally Posted by MrStubborn this for old Auth it's not work with Auth V2 EDIT: i have try to change columns name but still give an ERROR message in Authserver

Quote:

Originally Posted by TRTeta HOW CAN I ADD NPC , JP menu When I click the menu at the NPC, NPC Give jp This is not true .. dlg_menu( "<#F7E920>JP", "sv("jp",500000)" ) What is the true how can i add ? what is the code

dlg_menu("JP","Test_JP()")

test_jp()

function Test_JP()
sv("jp",500000)
end

Quote:

Originally Posted by TRTeta I use Royal repack , When I opened a new account, hidden village passport comes automatically reserved.How do I stop coming. [Only registered and activated users can see links. Click Here To Register...]

Quote:

-- Lua ½ºÅ©¸³Æ® ¾ÏÈ£È* function get_module_name() return "on_first_login" end function on_first_login( name ) -- º»·¡ HP ¼¼ÆÃÇÏ´ø ÀÚ¸® (Ȥ½Ã ¸ô¶ó¼* ±×³É ³ÀµÒ) set_value( "hp" , get_value( "max_hp") ) set_value( "mp" , get_value( "max_mp") ) -- Á¾Á· üũ local state_code = get_local_info() local race = get_value( "race" ) local deva_x, deva_y, asura_x, asura_y, gaia_x, gaia_y, i -- °¢ ¼ö·ÃÀÚÀÇ ¼¶ ½ÃÀÛ ÁöÁ¡ À§Ä¡ deva_x = 164474 deva_y = 52932 asura_x = 168356 asura_y = 55399 gaia_x = 164335 gaia_y = 49510 local start_x, start_y, start_layer, start_channel_no if state_code == 64 then end -- µ¥¹Ù ½ÃÀÛÁöÁ¡ üũ if race == 4 then --½ÃÀÛ À§Ä¡ ¼³Á¤ start_x = deva_x start_y = deva_y -- ¾Æ¼ö¶ó ½ÃÀÛÁöÁ¡ üũ elseif race == 5 then --½ÃÀÛ À§Ä¡ ¼³Á¤ start_x = asura_x start_y = asura_y -- ±×¿Ü(°¡ÀÌ¾Æ 3) ½ÃÀÛÁöÁ¡ üũ else --½ÃÀÛ À§Ä¡ ¼³Á¤ start_x = gaia_x start_y = gaia_y end -- ¼ö·ÃÀÚÀÇ ¼¶(ä³ÎID 1000)¿¡¼* °¡Àå ÀûÀıÇÑ Ã¤³ÎÀ» °ñ¶ó ·¹À̾ ¼¼ÆÃÇÑ´Ù. start_channel_no = get_proper_channel_num( 1000 ) start_layer = get_layer_of_channel( 1000, start_channel_no ) -- ±ÍȯÁö¿ª ¼³Á¤ set_flag( "rx", start_x + math.random(0,60) - 30) set_flag( "ry", start_y + math.random(0,60) - 30) local text text = sconv("@90010092", "#@number@#", tostring( start_channel_no ) ) -- º¯¼ö¸¦ ½ÇÁ¦ °ª(½ºÆ®¸µ)À¸·Î ġȯ ½ÃŲ´Ù. message( text ) -- ½Ã½ºÅÛ ¸Ş¼¼Áö·Î ÇØ´ç ä³ÎID Ãâ·Â. ------=========== ** ½ÃÀÛ¾ÆÀÌÅÛ ¼³Á¤ÇØÁÖ´Â ºÎºĞÀº ¼*¹ö¿¡¼* ±¸Çö ** ============------ -- ¾Æ¼ö¶ó(5)¸é ´õÅ©(´Ü°Ë), µ¥¹Ù¸é ½º¸ô¸ŞÀ̽º, °¡À̾ƴ ¹Ğ¸²µµ¸¦ ÁØ´Ù. -- µğÆúÆ® Á÷¾÷À» ³Ö¾îÁØ´Ù. (µ¥¹Ù:°¡À̵å, ¾Æ¼ö¶ó:½ºÅ×ÆÛ, ±×¿Ü:ÆÄÀÌÅÍ(°¡À̾Æ) ) local race = get_value( "race" ) if race == 4 then -- ÃʱâÁ÷¾÷À» °¡À̵å(200)·Î ¼³Á¤ÇÑ´Ù. set_value( "job" , 200 ) elseif race == 5 then set_value( "job" , 300 ) else set_value( "job" , 100 ) end -- Á÷¾÷ ¼³Á¤ ÈÄ ¼¼ÆÃµÈ ½ºÅÈ¿¡ ¸Â´Â HP·Î ´Ù½Ã ä¿öÁÜ set_value( "hp" , get_value( "max_hp") ) set_value( "mp" , get_value( "max_mp") ) -- ±¹°¡ ÄÚµå Àоî¿À±â -- get_local_info()ÀÇ ¹İȯ°ªµé --LOCAL_INFO_KOREA = 1 --LOCAL_INFO_HONGKONG = 2 --LOCAL_INFO_AMERICA = 4 --LOCAL_INFO_EUROPE = 8 --LOCAL_INFO_JAPAN = 16 --LOCAL_INFO_TAIWAN = 32 --LOCAL_INFO_CHINA = 64 --Àü±¹°¡ °øÅë local state_code = get_local_info() --if state_code = 32 then if race == 4 then if get_env("game.use_auto_trap") == 1 then open_popup("game.caution_url", "game.newbiehelp_deva_url", 0,1) else open_popup("game.newbiehelp_deva_url", 0,1) end elseif race == 5 then if get_env("game.use_auto_trap") == 1 then open_popup("game.caution_url", "game.newbiehelp_asura_url", 0,1) else open_popup("game.newbiehelp_asura_url", 0,1) end else if get_env("game.use_auto_trap") == 1 then open_popup("game.caution_url", "game.newbiehelp_gaia_url", 0,1) else open_popup("game.newbiehelp_gaia_url", 0,1) end -- end --else --±âÁ¸ ´ë¸¸ Á¦°Å --local state_code = get_local_info() --if state_code ~= 32 then -- --if race == 4 then -- --if get_env("game.use_auto_trap") == 1 then -- open_popup("game.caution_url", "game.newbiehelp_deva_url", 0,1) -- else -- open_popup("game.newbiehelp_deva_url", 0,1) -- end -- elseif race == 5 then -- if get_env("game.use_auto_trap") == 1 then -- open_popup("game.caution_url", "game.newbiehelp_asura_url", 0,1) -- else -- open_popup("game.newbiehelp_asura_url", 0,1) -- end -- else -- if get_env("game.use_auto_trap") == 1 then -- open_popup("game.caution_url", "game.newbiehelp_gaia_url", 0,1) -- else -- open_popup("game.newbiehelp_gaia_url", 0,1) -- end -- end end -- ½ÃÀÛÁÂÇ¥ ¼³Á¤ ij¸¯ÅÍ »ı¼ºÀÌ Çѹø¿¡ ¸¹ÀÌ ¹ß»ıÇÏ¸é ¹®Á¦°¡ »ı°Ü¼* ¾Æ·¡·Î À̵¿ set_value( "x" , start_x) set_value( "y" , start_y) set_value( "layer", start_layer ) local annc = "<#8bd1db>ãÑÍÈÇğ Èß "..name.." İí ÇáÓíÑİÑ </#8bd1db>" whisper(name,annc) end