[Help Thread] Please post your questions here.

[ThunderNikk]

Have you worked with port forwarding to your router/modem?

[TheSonicIQ]

Yes, and i have made servers before but i've switched routers since then and now i can't figure out what's wrong

EDIT: Changed my WAN Interface now it works

[3lloosh]

Hello all, I need [Auto Notice] in script (LUA) ... I found it, but unfortunately the link doesn't work .. ( )

could anyone help me with it please

[InkDevil]

Originally Posted by 3lloosh

Hello all, I need [Auto Notice] in script (LUA) ... I found it, but unfortunately the link doesn't work .. ( )

could anyone help me with it please

Does this one work for you?

(Just linked the attachment of that thread into this url)

[Exterminator-[Fury]]

You need to open ports in your Router/modem from your network provider.
good luck!

Originally Posted by TheSonicIQ

Hey, im trying to allow external connections to my server which works perfectly fine in LAN connections.. I am having problems connecting to the Auth, don't know about game server yet. but it seems like something is completely blocking my ports from being opened(?) at least i think it is the issue :/ i've tried messing around with the config ip's but nothing worked.. also tried switching all the ports to different ports and open them aswell.. am i missing something obvious? all settings are now default as of the 9.1 guide and
S:io.ip_addressEXTERNAL_IP) is the only thing i changed. tried using Hamachi as well but nothing seemed to work with it.

Tried:
adding inbound / outbound ports in firewall / disabling it completely,
shutting down any anti-virus softwares running,
starting server on a fresh pc start - without other programs running.

[3lloosh]

Originally Posted by LamiaCore

Does this one work for you?

(Just linked the attachment of that thread into this url)

Actually I mean the link of the attachment doesn't work
If you have the script, could you send it to me please?

[Exterminator-[Fury]]

This?

 Spoiler

-- Auto Notice by Mongreldogg

-- Format:
-- Put an interval when notice must appear (in seconds), then a notice text after comma, as in example.

-- Installation
-- Put this row into on_login, on_player_dead, npc contact script whatever:
-- auto_notice_check()
auto_notices_array = {

-- Example:

1300, "Посетите наш веб-сайт , чтобы следить за новостями, обновлениями или получить информацию о серверах",
1300, "Visit our website: to look up for news, updates and get additional info about servers",

1500, "Никогда не давайте сомнительным лицам логин аккаунта или пароль и не используйте никакие сервисы, которые предусматривают ввод логина и пароля вашего аккаунта на серверах кроме нашего веб-сайта! mourikite.net/rz",
1500, "Never give to anyone your login or password if you dont trust this person. Also don't use services that requires your account information, except our website! mourikite.net/rz"

}

function auto_notice_check()
for i = 1, table.getn(auto_notices_array) / 2 do
if get_global_variable( i .. "_autonotice_last_time" ) == "" then
set_global_variable( i .. "_autonotice_last_time", get_os_time() )
notice( auto_notices_array[i * 2] )
elseif get_os_time() - get_global_variable( i .. "_autonotice_last_time" ) > auto_notices_array[i * 2 - 1] then
set_global_variable( i .. "_autonotice_last_time", get_os_time() )
notice( auto_notices_array[i * 2] )
end
end
end

Originally Posted by 3lloosh

Actually I mean the link of the attachment doesn't work
If you have the script, could you send it to me please?

[3lloosh]

Originally Posted by exter16

This?

 Spoiler

-- Auto Notice by Mongreldogg

-- Format:
-- Put an interval when notice must appear (in seconds), then a notice text after comma, as in example.

-- Installation
-- Put this row into on_login, on_player_dead, npc contact script whatever:
-- auto_notice_check()
auto_notices_array = {

-- Example:

1300, "Посетите наш веб-сайт , чтобы следить за новостями, обновлениями или получить информацию о серверах",
1300, "Visit our website: to look up for news, updates and get additional info about servers",

1500, "Никогда не давайте сомнительным лицам логин аккаунта или пароль и не используйте никакие сервисы, которые предусматривают ввод логина и пароля вашего аккаунта на серверах кроме нашего веб-сайта! mourikite.net/rz",
1500, "Never give to anyone your login or password if you dont trust this person. Also don't use services that requires your account information, except our website! mourikite.net/rz"

}

function auto_notice_check()
for i = 1, table.getn(auto_notices_array) / 2 do
if get_global_variable( i .. "_autonotice_last_time" ) == "" then
set_global_variable( i .. "_autonotice_last_time", get_os_time() )
notice( auto_notices_array[i * 2] )
elseif get_os_time() - get_global_variable( i .. "_autonotice_last_time" ) > auto_notices_array[i * 2 - 1] then
set_global_variable( i .. "_autonotice_last_time", get_os_time() )
notice( auto_notices_array[i * 2] )
end
end
end

Yup I think so .. thank u very much ❤
I really appreciated

[ht2k9]

hello guys, I know this have been asked before (i saw some replies) but still cant find the asnwer... my problem starts when edited a monster stats, saved sql and hashed to resource, loged to game but then the skills removed from bars and got ????????? yellow message.. when deleted characters and reseted db everything went back to how it was.
but now when I edit the MonsterResource in arcadia it doesnt save even after hashing to resource. The only error I can see is from auth tool:

 Spoiler

2017-08-07 12:25:08 ERROR ODBC: SQLExecute: error:
2017-08-07 12:25:08 ERROR ODBC: 42S02:1:208:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'account'.
2017-08-07 12:25:08 ERROR ODBC: 42000:2:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

[ThunderNikk]

The skills disappearing from the bars could be related to the billing fixes not being executed from the guide.

The yellow question marks could be that the database is still set using a string resource that is of a different language than your launch arguments. (By default the files have been released using the Arabic string resource.)

Not sure about your monster resource edits.

For your auth error change the sql query in the auth.opt where it says "account" change it to "accounts"

[Exterminator-[Fury]]

To fix hotkeys



Monsterresource use this tool.

Originally Posted by ht2k9

hello guys, I know this have been asked before (i saw some replies) but still cant find the asnwer... my problem starts when edited a monster stats, saved sql and hashed to resource, loged to game but then the skills removed from bars and got ????????? yellow message.. when deleted characters and reseted db everything went back to how it was.
but now when I edit the MonsterResource in arcadia it doesnt save even after hashing to resource. The only error I can see is from auth tool:

 Spoiler

2017-08-07 12:25:08 ERROR ODBC: SQLExecute: error:
2017-08-07 12:25:08 ERROR ODBC: 42S02:1:208:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'account'.
2017-08-07 12:25:08 ERROR ODBC: 42000:2:8180:[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

[ht2k9]

Originally Posted by thndr

For your auth error change the sql query in the auth.opt where it says "account" change it to "accounts"

I fixed the yellow text and the skill bars...
I tried replacing account with accounts but still same problem, here is the auth/ common opt:
and when replaced db_account with db_accounts or db_Accounts i couldn't log in.

 Spoiler

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:
auth.db.salt:


#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
auth.clients.port:58422
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=127.0.0.1
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

auth:

 Spoiler

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:auth
auth.db.accounts:sa

auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_accounts.column.serveridxoffset:server_list _mask

#include config in common.opt
%include:common.opt

Monsterresource use this tool.

I am already using Glandu2's tool, I hash the sql db with it, I tried deleting monsters at first and it worked but later on when I tried to edit, no changes at all (and I didn't change the game server .opt)

[ThunderNikk]

auth.db.account:sa

Do not change that one.

auth.db.account:sa

Just the query.

sql.db_account.query:SELECT * FROM accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

Is how it should be if your auth.dbo.accounts is what your account table is named.

[TheSonicIQ]

How do i make a new skill i added to dbo.SkillResource visible in-game? the new skill is using already existing models effects and stat effects, but can't be seen in-game and i couldn't find a file in resource folder for it :/

Do i have to add a line for it in dbo.SkillResource_check as well?

[ht2k9]

Update (from previous replies): I think the problem that the resource not changing, whatever db i change then hash to resource folder, in game it does nothing, at first it was ok, changing data will result changes in game. Now it does nothing when i change stuff in db.I may be missing stuff from galdu2 tool.