|
You last visited: Today at 15:23
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
08/06/2017, 19:46
|
#6376
|
Moderator
elite*gold: 1 
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
Have you worked with port forwarding to your router/modem?
|
|
|
|
08/06/2017, 20:10
|
#6377
|
elite*gold: 0
Join Date: Jul 2013
Posts: 22
Received Thanks: 2
|
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
|
|
|
|
|
08/07/2017, 02:54
|
#6378
|
elite*gold: 0
Join Date: May 2017
Posts: 7
Received Thanks: 0
|
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 
|
|
|
|
|
08/07/2017, 03:50
|
#6379
|
elite*gold: 0
Join Date: Sep 2015
Posts: 603
Received Thanks: 1,202
|
Quote:
Does this one work for you?
(Just linked the attachment of that thread into this url)
|
|
|
|
|
08/07/2017, 10:36
|
#6380
|
elite*gold: 15
Join Date: Jul 2010
Posts: 726
Received Thanks: 50
|
You need to open ports in your Router/modem from your network provider.
good luck!
Quote:
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_address  EXTERNAL_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. |
|
|
|
|
|
08/07/2017, 11:25
|
#6381
|
elite*gold: 0
Join Date: May 2017
Posts: 7
Received Thanks: 0
|
Quote:
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?
|
|
|
|
|
08/07/2017, 12:00
|
#6382
|
elite*gold: 15
Join Date: Jul 2010
Posts: 726
Received Thanks: 50
|
This?
-- 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
Quote:
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? |
|
|
|
|
|
08/07/2017, 13:16
|
#6383
|
elite*gold: 0
Join Date: May 2017
Posts: 7
Received Thanks: 0
|
Quote:
Originally Posted by exter16
This?
-- 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
|
|
|
|
|
08/07/2017, 14:26
|
#6384
|
elite*gold: 0
Join Date: Dec 2012
Posts: 8
Received Thanks: 0
|
Editing monsters
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:
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.
|
|
|
|
|
08/07/2017, 15:12
|
#6385
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
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"
|
|
|
|
|
08/07/2017, 15:32
|
#6386
|
elite*gold: 15
Join Date: Jul 2010
Posts: 726
Received Thanks: 50
|
To fix hotkeys
Monsterresource use this tool.
Quote:
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:
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.
|
|
|
|
|
|
08/07/2017, 16:45
|
#6387
|
elite*gold: 0
Join Date: Dec 2012
Posts: 8
Received Thanks: 0
|
Quote:
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.
#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:
#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
Quote:
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)
|
|
|
|
|
08/07/2017, 18:31
|
#6388
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
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.
|
|
|
|
|
08/07/2017, 19:53
|
#6389
|
elite*gold: 0
Join Date: Jul 2013
Posts: 22
Received Thanks: 2
|
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?
|
|
|
|
|
08/07/2017, 20:49
|
#6390
|
elite*gold: 0
Join Date: Dec 2012
Posts: 8
Received Thanks: 0
|
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.
|
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +1. The time now is 15:24.
|
|
![[Help Thread] Please post your questions here.](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-thread-please-post-your-questions-here_ltr.gif){kind=small}
![Exterminator-[Fury]'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar2601769_8.gif){kind=avatar}
