p server issues and resolve

[VladimirR]

Originally Posted by ironhammer500

Just type in game001

connect auth and it should reconnect

Hi!

from my original post:

Originally Posted by VladimirR

i've tried to use "connect auth", but it says i'm already connected (no, i'm not)

regards,
VladimirR

[ironhammer500]

Originally Posted by VladimirR

Hi!

from my original post:



regards,
VladimirR

ok then it doesnt need it sorry, if ur still getting all rdy logged on then u need to edit the accounts but going in auth and looking for a loged in setting

give me 5mins and ill find that info



Ok try this go into mssql studio and go to Auth database

Edit top on accounts.dbo
then find the row labeled auth_ok and set to 0 then set to 1

you can try use a query for this im stil noob to queries so try google or the microsoft tutors.

If that doesnt work then try the block row.

[VladimirR]

Originally Posted by ironhammer500

ok then it doesnt need it sorry, if ur still getting all rdy logged on then u need to edit the accounts but going in auth and looking for a loged in setting

give me 5mins and ill find that info



Ok try this go into mssql studio and go to Auth database

Edit top on accounts.dbo
then find the row labeled auth_ok and set to 0 then set to 1

you can try use a query for this im stil noob to queries so try google or the microsoft tutors.

If that doesnt work then try the block row.

Hi,

seems like you've misunderstood me
i'm getting the "already connected" message from the gameserver (game001 by default), when i'm trying to enter the "connect auth" command (either in the gameserver's window, or via the admin console)

it has nothing to do with the auth database (which i have no access btw, neither do i to the auth server)

btw the query you're talking about looks like this:
UPDATE [Auth].[dbo].[Accounts] SET [auth_ok] = X;
where X is the value you want to set the field to

regards,
VladimirR

[ironhammer500]

Originally Posted by VladimirR

Hi,

seems like you've misunderstood me
i'm getting the "already connected" message from the gameserver (game001 by default), when i'm trying to enter the "connect auth" command (either in the gameserver's window, or via the admin console)

it has nothing to do with the auth database (which i have no access btw, neither do i to the auth server)

btw the query you're talking about looks like this:
UPDATE [Auth].[dbo].[Accounts] SET [auth_ok] = X;
where X is the value you want to set the field to

regards,
VladimirR

yes i thought telling the auth to ban all account then unban would trick it into thinking u all logged out.

Sadly u need to reboot game server

[VladimirR]

Hi,

it doesn't work for me (neither the plaintext, nor the md5), i'm still getting "AUTH DB INIT ERROR : Login failed for user 'username'."

regards,
VladimirR

[Anime Creature]

Originally Posted by VladimirR

Hi,

it doesn't work for me (neither the plaintext, nor the md5), i'm still getting "AUTH DB INIT ERROR : Login failed for user 'username'."

regards,
VladimirR

you need to change in mssql studio the owner of the databases Auth, Arcadia and Telecaster to "sa" with [BLANK] password (just leave password empty)
and also check authserver.opt for the same (any changes made to .opt files have to be compressed with rappelzcompress.exe, run this tool and drag the .opt file onto it)
the auth server needs sa and a blank password to connect to the auth database, like the error message says =)

[VladimirR]

Originally Posted by Anime Creature

you need to change in mssql studio the owner of the databases Auth, Arcadia and Telecaster to "sa" with [BLANK] password (just leave password empty)
and also check authserver.opt for the same (any changes made to .opt files have to be compressed with rappelzcompress.exe, run this tool and drag the .opt file onto it)
the auth server needs sa and a blank password to connect to the auth database, like the error message says =)

Hi,

no, it does not require the default superadmin user, i've already changed that, and it works just fine, and it can be used with a password protected user, but you have to encode the password
i just need the algorithm to encode with (which is not the md5)

regards,
VladimirR

[wisp66]

Originally Posted by VladimirR

Hi,

no, it does not require the default superadmin user, i've already changed that, and it works just fine, and it can be used with a password protected user, but you have to encode the password
i just need the algorithm to encode with (which is not the md5)

regards,
VladimirR

the password is in des there was a program posted by pyrok on our forum sometime back.
if he chooses to post it here or not is his choice.
if you want tho pm me the word u want as password and i can send you the des hash not sure that how much that helps you or not
ive helped a couple people out like this.

[naxkarri]

This is not the first Pserver i have messed with. so im not a complete noob, however.. i know you have said that the
#insert_item(.....) was broken.. and to use the direct mssql query..

but im having issues with everything coming out as a broken item and am unable to remove them from my inventory.. what am i doing wrong?

I cannot give myself anything in game.

i have managed to add things to the game. but its a situation where i have changed the flags enchant level. item id's and i cannot figure it out.

does anyone know if that merchant editor works? and if so does it need to be in a specific dir? im truly lost at this point!

[Anime Creature]

Originally Posted by naxkarri

This is not the first Pserver i have messed with. so im not a complete noob, however.. i know you have said that the
#insert_item(.....) was broken.. and to use the direct mssql query..

but im having issues with everything coming out as a broken item and am unable to remove them from my inventory.. what am i doing wrong?

I cannot give myself anything in game.

i have managed to add things to the game. but its a situation where i have changed the flags enchant level. item id's and i cannot figure it out.

does anyone know if that merchant editor works? and if so does it need to be in a specific dir? im truly lost at this point!

yes it works and it doesnt matter in wich directory you unzip the merchant modder, as it uses the database directly

[Ranma014]

Originally Posted by naxkarri

This is not the first Pserver i have messed with. so im not a complete noob, however.. i know you have said that the
#insert_item(.....) was broken.. and to use the direct mssql query..

but im having issues with everything coming out as a broken item and am unable to remove them from my inventory.. what am i doing wrong?

I cannot give myself anything in game.

i have managed to add things to the game. but its a situation where i have changed the flags enchant level. item id's and i cannot figure it out.

does anyone know if that merchant editor works? and if so does it need to be in a specific dir? im truly lost at this point!

You can try to add all items you want ingame to a new shop, just dont add the shop to any npc ingame, but open it with #open_market('shop_name','char_name')
the shops are in [arcadia].[dbo].[MarketResource] and arent that hard to understand.

[Levelz]

anyone found a fix for r7 gear buffs such as voidwarp ? sucks that they still don't work

[sixpackraw]

I want to set the lvl from one of my chars to 120-ok it works but when i kill a mob iam right back lvl 300.

[lawlywood]

Originally Posted by sixpackraw

I want to set the lvl from one of my chars to 120-ok it works but when i kill a mob iam right back lvl 300.

Yea cuase you have to set the EXP down aswell otherwise rappelz will recalculate your level if your exp changes.

[tontoepfer]

i wanted to create a p server on my windows server 2008 version. My problem right now is that the game server chrash and restart and after each restart is crashes. I dont know why cause there is no problem O_O all the ports are allowed and the ip's are inserted in the right way. i dont get any errors. only the restarter said server crashed after loadding is complet.

So if anyone can help me thank you ;D