need minor help in my test server

[darkside4125]

how do i give all users hv, atm i got a few friends working with me making sure we can find and track down every bug possible, however im trying to give everyone hv for 7 or 14 days how would i do so?

[RoflcopterGoesSoiSoiSoi]

create a php script

$select = mssql_query("SELECT id FROM dbo.Character")or die("Cannot select id from dbo.Character. Error: ".mssql_error());
while($row=mssql_select_aray($select)){
//insert item...
}

if you don't know what php is you shouldn't be running a server.

[darkside4125]

yeah i know what php is,

[darkside4125]

btw just so you know you dont have to know php to run a good server, i know php but when i ran my ragnarok server i didnt, an my ragnarok server had over 1000 users online daily and was a top server so.. just to let you know that

[RoflcopterGoesSoiSoiSoi]

php is the best language to work with mssql. it's fast, flexible and efficient to work with.

[thatkiddo]

private server? id be interested to find out some info bout it

[wisp66]

Originally Posted by darkside4125

how do i give all users hv, atm i got a few friends working with me making sure we can find and track down every bug possible, however im trying to give everyone hv for 7 or 14 days how would i do so?

are u asking for a login buff system if so thats lua i can do one for u just tell me what buffs u need . there was one posted for gm buffs as well.
buffs is one thing but actually giveing a pass to hv isnt possable as present

Originally Posted by RoflcopterGoesSoiSoiSoi

php is the best language to work with mssql. it's fast, flexible and efficient to work with.

true

[DaJohnson]

Actually Wisp, i'd be interested in seeing what you have there, I've had a look at the posted on_login LUA, and it looks like it *should* work, however, it doesnt give me a **** buff of any type when i login.

Not bothered to look into it yet, as it's backburner'd while I'm looking into HV access.

Feel free to PM me with it, if you want.

[darkside4125]

yeah wisp im trying to make it so when you login each user gets hv 7 days between certain dates kinda like usa does for events

[wisp66]

ya ill pm but hv acess isnt possable yet buffs are tho

[wisp66]

heres a remake of an exisitng login buff it gives lvl 15 hv buffs*all of them if memory servers me thats the correct lvl's and its for none gm's

 Spoiler

-- Lua ½ºÅ©¸³Æ® ¾ÏÈ£È*
function get_module_name()
return "on_login"
end


function on_login( name )

-- ±¹°¡ ÄÚµå Àоî¿À±â
-- 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 race = get_value( "race" )
local state_code = get_local_info()

if get_value( "permission" ) == 0 then
add_state(1051, 15, 8640000)
add_state(1052, 15, 8640000)
add_state(1053, 15, 8640000)
add_state(1054, 15, 8640000)
add_state(1055, 15, 8640000)
add_state(1056, 15, 8640000)
add_state(1057, 15, 8640000)
return
end

-- Á÷¾÷ÀÌ ¾ø´Â ij¸¯Àº »õ·Î¸¸µç ij¸¯À̹ǷΠÃʱ⼳Á¤
if get_value( "job" ) == 0 then
on_first_login( name )

-- ±âÁ¸ ij¸¯ÅÍÀÏ ¶§, ±¹°¡ ÄÚµå=64(Áß±¹)¸¸ ±¤°í È*¸é Æ˾÷
else
if state_code == 64 then
open_popup("game.advertise_url",0,0)
end
end


-- ±ÍȯÁö¿ª ¾ø´Â Ç÷¹À̾î´Â ±ÍȯÁö¿ª ¼³Á¤.
local temp_rx = get_flag( "rx" )
local temp_ry = get_flag( "ry" )

if temp_rx == "" or temp_ry == "" then

if race == 4 then

-- µ¥¹Ù ±ÍȯÁö¿ª ¼³Á¤
set_flag( "rx", 7250 + math.random(0,100))
set_flag( "ry", 6959 + math.random(0,100))

elseif race == 5 then

-- ¾Æ¼ö¶ó ±ÍȯÁö¿ª ¼³Á¤
set_flag( "rx", 116542 + math.random(0,100))
set_flag( "ry", 58190 + math.random(0,100))

else
-- °¡ÀÌ¾Æ ±ÍȯÁö¿ª ¼³Á¤
set_flag( "rx", 152742 + math.random(0,100))
set_flag( "ry", 77401 + math.random(0,100))

end
end

-- ¿ÀÅä·Î ¼¼ÆÃµÈ Ä³¸¯ÅͶó¸é Àú ¸Ö¸® ³¯·Á ¹ö¸®ÀÚ~
kick_auto_to_another_world()

-- ¼ö·ÃÀÚ ¼¶¿¡ ÀÖ´Â ¿ÀÅäµéÀº º»Åä·Î ³¯·Á ¹ö¸®ÀÚ
local current_x = gv("x")
local current_y = gv("y")

if current_x >= 161280 and current_x <= 177408 then
if current_y >= 48384 and current_y <= 64512 then

local is_auto, quest_count
quest_count, is_auto = anti_auto_quest_check()

if is_auto then

if race == 4 then
RunTeleport_Auto_TO_City( 6625 , 6980 )
elseif race == 5 then
RunTeleport_Auto_TO_City( 116799 , 58205 )
else
RunTeleport_Auto_TO_City( 153506 , 77175 )
end

end -- if is_auto then

end -- if current_y >= 48384 and current_y <= 64512 then
end -- if current_x >= 161280 and current_x <= 177408 then

end

make this in to 92aaf4ae4ee42eb41693728da93f301a.lua then drag in to rappelz compress before u add it to resource>scripts server side and client side.
and to make it easier to grasp why for some of you its not working?

 Spoiler

if get_value( "permission" ) == 0 then

would be changed to

 Spoiler

if get_value( "permission" ) == 1 then

if u wanted it to only function for gms

[DaJohnson]

Wisp, following your steps exactly, this isnt working for me.

Using AoR client, and jw's base pack.

Also, far as I see it, the:

if get_value( "job" ) == 1 then

part is not relevant, that appears to simply check yoru dbo.Character table to see if you've not been assigned a job, ie, perfectly fresh player. If so, it runs the new player scripts which seem to setup your start on TI and run the fancy animation when you first login.

Prehaps you meant to put:

if get_value( "permission" ) == 1 then

which indeed checks to see if its a GM enabled character or not.

*Edit

Also Wisp, take a look at
my post here, regarding a nice temporary fix to access HV.

[wisp66]

ya i corrected that thnx for pointing it out.
typing quick and checking work is a must

[DaJohnson]

Wisp, would you mind packaging up your game_bin ?

I can completely remove my on_login.lua, and all works the same. So mine isnt getting loaded/executed at all for some reason.

I'd like to compare the two, to see what you have that differs from mine, assuming your using the AoR client aswell.

[ktsplayer]

someone know what is the password and username to enter in private server?