p server issues and resolve

help (~_~)

[Only registered and activated users can see links. Click Here To Register...]

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

need help here
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

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 انا نسيت الباس في برنامج

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

Quote:

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

Quote:

Originally Posted by mhtjaber help (~_~) [Only registered and activated users can see links. Click Here To Register...]

Just disable your fire wall and try it again :mofo:

__________________________________________________ _


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 ?

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.

Quote:

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 Code: 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 :)

#de-pinned

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

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

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 :(
[Only registered and activated users can see links. Click Here To Register...]

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

delete sa's password in sql studio

Quote:

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.