[HELP]How to connect at MSSQL2005 has distance?

[belette321]

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 ...

 

[Bryan1]

how yow saiyd?

 

[gReGiTh]

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.

 

[tabarra]

i dont no what 1 put in login and password field
game:gunz ??

 

[gReGiTh]

i dont no what 1 put in login and password field
game:gunz ??

No. You have to have an account in the SQL database you're trying to connect to. It's not a difficult concept to grasp.

The server owner creating the account can refer to this picture:

 

[RepublicOfAstra]

I'm not entirely sure, you can prolly just google "remote connections sql 2005" and get relevant results.

 

[tabarra]

tnx !

 

[belette321]

Thanks You :0
But wath my GM do?

 

[gReGiTh]

Thanks You :0
But wath my GM do?

.. What do you mean?

 

[danse]

.. 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.

 

[gReGiTh]

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.