Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[HELP]How to connect at MSSQL2005 has distance?

Skilled Illusionist
Joined
Jan 7, 2007
Messages
347
Reaction score
78
How to connect at MSSQL2005 has distance?
Its becose i nned to give accesse to my GM for Event to add item in central bank of the winners ...
 
Custom Title Activated
Member
Joined
Apr 12, 2004
Messages
1,101
Reaction score
0
belette321 - [HELP]How to connect at MSSQL2005 has distance? - RaGEZONE Forums


I haven't tried this, but I think it will work. I'm unsure about the syntax of the Server name field.

You need to have the server owner make you an account on their SQL server. You will also need SQL Server Management Studio Express installed on your computer.
 
Upvote 0
Supreme Arcanarch
Member
Joined
Dec 21, 2006
Messages
957
Reaction score
0
I'm not entirely sure, you can prolly just google "remote connections sql 2005" and get relevant results.
 
Upvote 0
hello
Member
Joined
Jun 24, 2004
Messages
726
Reaction score
158
.. What do you mean?

i think he meant what his GM must to do to work with that db, i think he just may connect via Enterprise Manager by setting an ODBC connection to you with correct login and password.
 
Upvote 0
Custom Title Activated
Member
Joined
Apr 12, 2004
Messages
1,101
Reaction score
0
Thanks You :0
But wath my GM do?

I have never added items via SQL Server Management Studio, but I just figured it all out.

Once connected to the SQL db, do the following:
- Expand GunzDB

- Expand Tables

- Right click dbo.Character > Open Table

- Find the name of the character who's inventory or equipped items you want to edit. Scroll right untill you see the column called CID, it's the number of a particular character. Make note of the CID number for the character you want to edit.

- To edit currently equipped items, continue scrolling right. You will see columns head_itemid, chest_itemid, etc. The numbers in those columns are the itemid's of particular items that are equipped by a character. You can get itemid's from zitem.xml

- If you want to add item's in a character's inventory, close the dbo.character table that you opened.

- Now right click dbo.items > Open Table

- Scroll to the bottom of the table, and insert a new row for each new item you want to add. In the CID column, put the CID of the character you wish to give the item to. In the ItemID column, put the itemid of the item from zitem.xml. And in the CIID column, put the CIID of the row directly above this new row +1.. The CIID's go in numerical order. For example, the first row in this table will have a CIID of 1, second row will have 2, 3rd will have 3, 28th will have 28, etc.

Always remember that to save any changes to a table, you need to right click > Execute SQL.

I hope this helps. :)
 
Upvote 0
Back
Top