p server issues and resolve

[mhtjaber]

help (~_~)

[xyoyx]

Hello
Just one question
how change the gold rate ?
in gameserver . opt but do not work
please help me :'(

[darkman1001]

need help here

[acrv158]

I forgot the login and password in Sql Server Managment
Studio

help me

how can i get it back?
or
what should I do?
.................................................. ................................................
Sql Server Managment Studio انا نسيت الباس في برنامج

كيف أسترجعها؟
أو
ماذا أفعل؟

[lawlywood]

Originally Posted by acrv158

I forgot the login and password in Sql Server Managment
Studio

help me

how can i get it back?
or
what should I do?
[Some bullshit here]

Quit crossposting

[MAD--KSA]

Originally Posted by mhtjaber

help (~_~)

Just disable your fire wall and try it again

__________________________________________________ _


Hey guys does anyone know how to fix my problem ^_^

The problem is when I enter ("#insert_item") in (game001) didn't work ?

I make a serch and I found that

--------------------------------------------------
Add item for those who "#insert_item" doesn't work.
Spoiler:

Go on telecaster, right click on tables, "New Query"
Paste the text of the spoiler below.

USE [Telecaster]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[smp_insert_item]
@IN_SID = 1, --Change this Per Item
@IN_OWNER_ID = 1, --Char ID
@IN_ACCOUNT_ID = 0,
@IN_SUMMON_ID = 0,
@IN_AUCTION_ID = 0,
@IN_KEEPING_ID = 0,
@IN_CODE = 910037, --Item Code
@IN_IDX = 100, --Place in Inv (doesnt seem to matter)
@IN_FLAG = 0,
@IN_CNT = 1, --How Many you want
@IN_LEVEL = 1, --Item Level
@IN_ENHANCE = 0, -- Item +
@IN_ENDURANCE = 100,
@IN_GCODE = 1,
@IN_REMAIN_TIME = 0,
@IN_ELEMENTAL_EFFECT_TYPE = 0,
@IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 11:00:00.000',
@IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
@IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0

SELECT 'Return Value' = @return_value

-------------------------------------------------------------------

But Idon't get it

Could anyone help me please ?

[ironhammer500]

For the insert cmd do this


#sv(lv, level u want, "NAME")
#learn_all_skill("NAME")
#Insert_item(id , enchant , level , flag , "NAME")




For the mssql query u need to start a new query copy and paste this in and fill out the details, u will need to know item codes your character sid number. Probaly good idea to know what your doing to.
Also make sure your logged out for the Query one.

 Spoiler

USE [Telecaster]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[smp_insert_item]
@IN_SID = 1, --Change this Per Item
@IN_OWNER_ID = 1, --Char ID
@IN_ACCOUNT_ID = 0,
@IN_SUMMON_ID = 0,
@IN_AUCTION_ID = 0,
@IN_KEEPING_ID = 0,
@IN_CODE = 910037, --Item Code
@IN_IDX = 100, --Place in Inv (doesnt seem to matter)
@IN_FLAG = 0,
@IN_CNT = 1, --How Many you want
@IN_LEVEL = 1, --Item Level
@IN_ENHANCE = 0, -- Item +
@IN_ENDURANCE = 100,
@IN_GCODE = 1,
@IN_REMAIN_TIME = 0,
@IN_ELEMENTAL_EFFECT_TYPE = 0,
@IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 11:00:00.000',
@IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
@IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0

SELECT 'Return Value' = @return_value

[MAD--KSA]

Originally Posted by ironhammer500

For the insert cmd do this


#sv(lv, level u want, "NAME")
#learn_all_skill("NAME")
#Insert_item(id , enchant , level , flag , "NAME")




For the mssql query u need to start a new query copy and paste this in and fill out the details, u will need to know item codes your character sid number. Probaly good idea to know what your doing to.
Also make sure your logged out for the Query one.

 Spoiler

USE [Telecaster]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[smp_insert_item]
@IN_SID = 1, --Change this Per Item
@IN_OWNER_ID = 1, --Char ID
@IN_ACCOUNT_ID = 0,
@IN_SUMMON_ID = 0,
@IN_AUCTION_ID = 0,
@IN_KEEPING_ID = 0,
@IN_CODE = 910037, --Item Code
@IN_IDX = 100, --Place in Inv (doesnt seem to matter)
@IN_FLAG = 0,
@IN_CNT = 1, --How Many you want
@IN_LEVEL = 1, --Item Level
@IN_ENHANCE = 0, -- Item +
@IN_ENDURANCE = 100,
@IN_GCODE = 1,
@IN_REMAIN_TIME = 0,
@IN_ELEMENTAL_EFFECT_TYPE = 0,
@IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 11:00:00.000',
@IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
@IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0

SELECT 'Return Value' = @return_value

OK

The three first letters insert it to captinharlockserver (game001)

And all the stuff in the spoiler put it in New Query

Thanks alot man

[Sextus]

#de-pinned

[mtbl0w]

hi i need help i created my server yesterday.and i cant see any servers in server list. pls help -_-

[Yunchen]

did u write in auth window "set game.open_external 1 and start_service" ?

[mtbl0w]

yeah i write start_service it says bla bla bla ok and i write set game.open_external 1 it isnt say anything

ok i solve problem but i have an other problem :/ when i select the server it gives this error

[strampy]

i have a question i have all the server rdy to go but when i launch PrincessAuroraServer its comes up with the error: AUTH DB INIT ERROR: Login failed for the user 'sa'. The user is not associated with the trused SQL Server connection,,,,,, if any1 can get back to me quickly would be nice ty

[mtbl0w]

delete sa's password in sql studio

[rappelzfan01]

Originally Posted by mtbl0w

yeah i write start_service it says bla bla bla ok and i write set game.open_external 1 it isnt say anything

ok i solve problem but i have an other problem :/ when i select the server it gives this error
<image>

I had this problem awhile ago. I fixed it by checking all the IP addresses in every settings file. The server is very nitpicky about IP addresses.