[Release] - GunZ Jan Server + DB

As the title says, this is the full official Gunz Database including the LogDB which had never been available before (or needed).

Discussion and Download thread: http://server devs.com/gunz-online/773-share-gunz-db-100-complete



Client

Released as promised.

Includes MatchAgent, MatchServer, Locator, Database and all the XML's.

Enjoy

Download: http://server devs.com/file42.html

Discussion: http://server devs.com/gunz-online/2293-share-full-2007-gunz-server

Remove the space between server and devs <3

Enjoy.


NOTE: Do not reupload this on other sharing places, I want to track Downloads T_T

Password: serverdevs .com (with no space)

EDIT ROTANA :

New link: RapidShare: 1-Click Webhosting

o_o Nice.

this db is for the lastest server files.. so i think that u'll have some problems if u try to run it with dic server...

release the matchserver =D

o_O Very nice :p

I'm not having any problems so far running this DB with the Dec. '05 MatchServer.

Omg! You are god!

I love you!

If i mean see it the pass of the rar file is

Quote:

---

server devs.com

---

Quote:

---

Remoce the space between server and devs.com

---

I didn't see it at the first look, needed to select it LOL

If the poster[BoTGoD] dont want it please let an admin/mod remove or edit mine post.

wow.thats mudaf****ing nice!

Edit: Why SQL 2000? Does it works with 2k5?

It's for MSSQL 2005.

You need to make a fresh new DB called GunzDB, open the query, parse it, then execute it. It should work after that, it did for me.

Also worked for me with GunzDB
If you want to make an other DB like GunzDb2 then remove the first rules with
If exist ....
Drop table ...
Then you can make an new database.


BTW. I forgot to thank you for the release. A very good job, we need more of things like this. THANKS

in the download page its written for SQL 2000

Hello:

-Erase my data base and you place the first GunzDB soon and the Log.
-Form the locator as I could

same here for the error, but i fixed it at 50% by forwarding all the ports you see in the XML

I have to mess around with the MatchAgent some more, I'm not 100% sure how it works. It connects, then disconnects for me.

As for the account, you put some of the info in Account table, and the other info in Login table. Check the procs for the tables, they help a lot as far as information goes.

Check the table "Login"

I got it working the first time i start it.

To start it Edit the Matchagent.xml
And change the ip to 127.0.0.1 or your local ip and the port to the port your matchserver uses, standard 6000

Can't query the sql files, i'm using SQL 2005, please help me to solve this problem.

I already explained. You need to parse the file, then execute it on an emtpry DB named GunzDB

Yes, i deleted old GunzDB ad creat a new one, but i can't query the SQL file, have alot of error when execute it.

Quote:

---

Originally Posted by chuot

Yes, i deleted old GunzDB ad creat a new one, but i can't query the SQL file, have alot of error when execute it.

---

Delete the first part of it in the query editor untill you reace the parts of Create Table

rotana fixes what your you said to me and forms matchagent and I remain thus:

<?xml version="1.0" encoding="euc-kr"?>
<XML>
<AGENTCONFIG>
<NAME>MatchServer</NAME>
<MAXCLIENT>1000</MAXCLIENT>
<ADDRESS ip="192.168.1.100" tcpport="6000" udpport="7778"/>
<MATCHSERVERADDRESS ip="192.168.1.100" tcpport="6000"/>
</AGENTCONFIG>
</XML>

now when I open matchagent says to me:

[05/11/07 01:47:47] Command registeration completed
[05/11/07 01:47:47] Match Agent Created (Port:6000)
[05/11/07 01:47:57] Reconnect to MatchServer
[05/11/07 01:48:07] Reconnect to MatchServer

and when i want to try to enter the servant it says "to can't access server."
dbo.login verifies in, thir or, but equal it does not let enter, verifies the server to me you case aout, not as it is the problem

I continue thinking that now the problem is of configuration of dbo, but are many dbo that I do not understand its configuration :S

Quote:

---

<?xml version="1.0" encoding="euc-kr"?>
<XML>
<AGENTCONFIG>
<NAME>MatchServer</NAME>
<MAXCLIENT>1000</MAXCLIENT>
<ADDRESS ip="192.168.1.100" tcpport="6000" udpport="7778"/>
<MATCHSERVERADDRESS ip="192.168.1.100" tcpport="6000"/>
</AGENTCONFIG>
</XML>

---

That 7778 change to 8900
if you no change 7778 - 8900 MatchAgent alway say Reconnect to MatchServer... so just change it~ it will no error msg anymore~^^
i login done~ and dono why my July client cant make a Game~ when create game after loading it hang about 3 secound than close client >.<~ SAD and mlog.txt nth error~
and my Locator dont work for me~ when i double click the locator.exe it nth popup >.< some one help?

Where did you get the MatchAgent?

- Found it..

Quote:

---

Originally Posted by kn95951135

That 7778 change to 8900
if you no change 7778 - 8900 MatchAgent alway say Reconnect to MatchServer... so just change it~ it will no error msg anymore~^^
i login done~ and dono why my July client cant make a Game~ when create game after loading it hang about 3 secound than close client >.<~ SAD and mlog.txt nth error~
and my Locator dont work for me~ when i double click the locator.exe it nth popup >.< some one help?

---

<AGENTCONFIG>
<NAME>MatchServer1</NAME>
<MAXCLIENT>1000</MAXCLIENT>
<ADDRESS ip="127.0.0.1" tcpport="5100" udpport="7778"/>
<MATCHSERVERADDRESS ip="127.0.0.1" tcpport="6000"/>
</AGENTCONFIG>

Dont change the 5100 to 6000 or something.

Quote:

---

Originally Posted by Rotana

<AGENTCONFIG>
<NAME>MatchServer1</NAME>
<MAXCLIENT>1000</MAXCLIENT>
<ADDRESS ip="127.0.0.1" tcpport="5100" udpport="7778"/>
<MATCHSERVERADDRESS ip="127.0.0.1" tcpport="6000"/>
</AGENTCONFIG>

Dont change the 5100 to 6000 or something.

---

but with that therefore to me continues throwing he himself error, tries to put my IP and also I follow with he himself problem

[quote=darkxl;2234519]Hello:

-Erase my data base and you place the first GunzDB soon and the Log.
-Form the locator as I could

omg i've been trying all the things you guys sayed but i always get those very very very frustrating errors:

Code:

---

Msg 2760, Level 16, State 1, Line 3
The specified schema name "game" either does not exist or you do not have permission to use it.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "game.dtproperties" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "game.dtproperties" because it does not exist or you do not have permissions.
Warning! The maximum key length is 900 bytes. The index 'IX_IPtoCountryCode_IPRange_060612' has maximum length of 24000 bytes. For some combination of large values, the insert/update operation will fail.
Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.
Msg 7202, Level 11, State 2, Procedure Account_, Line 6
Could not find server 'SERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Msg 7202, Level 11, State 2, Procedure Login_, Line 6
Could not find server 'SERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

---

what i do:

Delete GunzDB
Create Fresh GunzDB
Open up GunzDB.sql
Remove the first parts until the first Create Table
Parse
Execute

Quote:

---

Originally Posted by kochon

omg i've been trying all the things you guys sayed but i always get those very very very frustrating errors:

Code:

---

Msg 2760, Level 16, State 1, Line 3
The specified schema name "game" either does not exist or you do not have permission to use it.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "game.dtproperties" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "game.dtproperties" because it does not exist or you do not have permissions.
Warning! The maximum key length is 900 bytes. The index 'IX_IPtoCountryCode_IPRange_060612' has maximum length of 24000 bytes. For some combination of large values, the insert/update operation will fail.
Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.
Msg 7202, Level 11, State 2, Procedure Account_, Line 6
Could not find server 'SERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Msg 7202, Level 11, State 2, Procedure Login_, Line 6
Could not find server 'SERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

---

what i do:

Delete GunzDB
Create Fresh GunzDB
Open up GunzDB.sql
Remove the first parts until the first Create Table
Parse
Execute

---

1. Find all instances of [game] and change them to [dbo].
2. Find SERVER and remove it from the code.

===================================
What data Locator requires to work? :cry:

where should i see the [game] things?

Quote:

---

Originally Posted by kochon

where should i see the [game] things?

---

Open GunzDB.sql with SMSE.
Press CTRL+F, put [game] in search promt.

ok thx

is the locator broke this release :P?

Quote:

---

Warning! The maximum key length is 900 bytes. The index 'IX_IPtoCountryCode_IPRange_060612' has maximum length of 24000 bytes. For some combination of large values, the insert/update operation will fail.
Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.

---

I fixed everything else, anyone have any idea whats up wwith that.

Create BD game, execute logDB.sql
Create user game (make him db_owner for Gunz and game db's)
open GunzDB.sql find [server]. and remove it or replace your sql server name
execute
Then go to login table - create login, go to account table and fill by your account

For locator you need to go to BlockCountryCode and type like this
JP 0.0.0.0 0
go to IPtoCountry AND TYPE
0.0.0.0 0.0.0.0 JP JP JP
go to serverstatus
1 0 2000 11.11.2000 "your ip" 6000 Matchserevr1 1 null

All works :) Now i'm trying to add new maps to server, make quests, normal shop and items, web site for new server.

In this DB a lot of stuff for web site, admin, server ...
I think need new Matchserver release + good zitems.xml + shop.xml + gunz.exe

Dont remove server replace server with your server aka USERNAME\SYSTEMNAME

haha, there isnt any gamelist or map list.

i need more explanations on how to create users, i know its in security-users, but the rest is like... pretty new to me...

Okay, Well. There isn't any gamelist or map list, so yeah, we might need to fix that, *cough*

well that's a kind of good point since you won't have like players putting theyre own maps wich the others doesn't have.

Not even default maps are there tho

hmm yeah that is a lil frustrating though, we have to figure out the good settings for successfully adding a map, but i cant help you guys since i still doesnt know how the hell to create a user.


PS: Keiz why you added me on msn?

Security -> user

i know but i dont know how to set it up... i put the name, check db_owner then i press ok but i needs a class or whatever

Why are you mentioning storing maps in the DB? It works just fine with nothing listed in it. I've tested everything myself.

I have no map list or game type, your talking about the dec matchserve,r right

works fine for me, bt i aint using it, my old db has ques and clan and everything my server works damn near finelo, wats so good about this one?

Hello:
I am becoming crazy proving things so that the servant works implementing the new things, but it is IMPOSSIBLE to me, it would be good that BoTGoD explains to us as to implement its works and guides to us…
(sure if it is not much annoyance)

BoTGoD please upload MatchServer and Locator 2007 Version. New MatchServer use dbo.Items for Check Items in Server =)...

No use more itemz.xml =D

hey i have alot of problems with this db...well i wanted to go back to my previous db but i dont know how can anyone tell me how to just open my old db with this new db..its just to much db's in the new ones.

Quote:

---

Originally Posted by SirMaster

BoTGoD please upload MatchServer and Locator 2007 Version. New MatchServer use dbo.Items for Check Items in Server =)...

No use more itemz.xml =D

---

i agree please release them

http://server devs.com/gunz-online/773-share-gunz-db-100-complete

errr, that's the link right? to download coz it says cannot found with google or something T_t please help lol
:winky:

I hate you when i installe it my db bugged and i cant access account i cant change enithing i cant run serverkeeper i need do reboot server my T.T

P.S : My players T.T

Quote:

---

Originally Posted by belette321

I hate you when i installe it my db bugged and i cant access account i cant change enithing i cant run serverkeeper i need do reboot server my T.T

P.S : My players T.T

---

yea same thing happend here.. all i did was just dleted all the previous db's into my msql thing and i just opend lg's db and fixed all the db all over agian it wasnt hard..

Quote:

---

Originally Posted by Reapez

http://server devs.com/gunz-online/773-share-gunz-db-100-complete

errr, that's the link right? to download coz it says cannot found with google or something T_t please help lol
:winky:

---

remove the space...

and i really need help for this i always get like 5 errors, please i need somebody to support me through msn

yeah well.. I still don't have a map list or mode list.

Just stick with your previous DB...

any ideas ? somebody give me advice plz ... :(

well i tested the DB even if i have errors, andi have the mode and map lists....

hello i fixed the level 11 msg errors but i just cant fix these one pls someone help me

Warning: The table 'IPtoCountry' has been created but its maximum row size (40031) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'id'.
Msg 1779, Level 16, State 0, Line 2
Table 'dtproperties' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Warning! The maximum key length is 900 bytes. The index 'IX_IPtoCountryCode_IPRange_060612' has maximum length of 24000 bytes. For some combination of large values, the insert/update operation will fail.

O.O workkkk... nice release... very good db...

thankxxxx

Don't use this with the december client, because like it doesnt work right.

why the hell isnt this stickied?

BoTGoD asked me not to sticky this until he releases MatchServer and Locator, then just merge all three and stick that. His request.

ok sorry my mistake, sorry if ive been a little rude.

cant wait 'til he release the stuff? do you know when he plan to?
what the...? it's stickied now?

Thanks,,,I hope this db is good

i heard that ijji matchserver has been stolen by one of LG's hacker.

Quote:

---

Originally Posted by Kingston

Thanks,,,I hope this db is good

---

Its the best database thats out.

Released as promised.

Includes MatchAgent, MatchServer, Locator, Database and all the XML's.

Enjoy

Download: http://server devs.com/file42.html

Discussion: http://server devs.com/gunz-online/2293-share-full-2007-gunz-server

Remove the space between server and devs <3

Enjoy.


NOTE: Do not reupload this on other sharing places, I want to track Downloads T_T

Password: serverdevs .com (with no space)

Check my new post for full server :>

P.S. LG didnt hack ijji i shared the server files with him early XD

NOTE 2: Recommended to use Brazil Client fully updated.

well can you relese a good client to work with it?

yea same

Quote:

---

Originally Posted by BoTGoD

Check my new post for full server :>

P.S. LG didnt hack ijji i shared the server files with him early XD

---

o.... those hackers = liars

oh.. you need brazil client

plzzzzz post your client BoTGoD

Go get it from gunzonline.com >>> Brazil Gunz >>> The Duel >> Download

i am brasilian...

my client bugg

use gunz.exe or theduel.exe?

you need to modify the theduel .exe or use a edited launcher to run it. BTW, I cant get locator to work. They dont use Zlocatorlist.xml..... No idea of what they used

I've had this for a while, BoTGoD gave these files to me a few weeks ago but made me not release them. Lol, glad to see he finally released them publicly.

But yeah, you need to use the Brazil client. You'll need to modify the launcher so it checks a blank patch.xml on your own webhost, so it won't download the Brazil files and update to the official files every time you run it. It's a simple hex-edit on the launcher to check the web address it goes to for the patch.xml.

Or you can attempt to disable XTrap and make it into a runnable, though that's a hell of a lot harder.

Quote:

---

Originally Posted by RepublicOfAstra

I've had this for a while, BoTGoD gave these files to me a few weeks ago but made me not release them. Lol, glad to see he finally released them publicly.

But yeah, you need to use the Brazil client. You'll need to modify the launcher so it checks a blank patch.xml on your own webhost, so it won't download the Brazil files and update to the official files every time you run it. It's a simple hex-edit on the launcher to check the web address it goes to for the patch.xml.

Or you can attempt to disable XTrap and make it into a runnable, though that's a hell of a lot harder.

---

Can't access to the server. >_<

Any idea how to emulate xtrap update site? — I wanna work on fixes at home(I don't have Inet at home).

can't open locater =[

Maybe this will help some people out...

The download link for the BR Gunz Client.

http://jogos.download.uol.com.br/lev...l_20070315.exe

Seem MatchAgent not working?? Please check.

Thank you verry much.

MarsNIIT yes sayng:

reconnect to MatchServer


reconnect to MatchServer

reconnect to MatchServer
reconnect to MatchServer
reconnect to MatchServer
reconnect to MatchServer


how i can fix that?

Solved NVM this repley!

i wanna know where i put the password in the db... only have userid,age,regnumb etc... but no password

Nao

gg to you, ;) I'll release a working launcher/client/newitem/etc asap :) Thanks.. This is the one I had btw people.

=P

LG where it is to client/launcher

nice releases man :)

we just need a tut on how to make conection from client to server

Can see my server, but connect to can not connect the server
Please help me, thank

Brazilian client is incompatible with this server, because it requires newest server to run. %)

Gotta find old brazilian client. xD

wow ppl i thought i have bad english ... but its hard for me to follow this conversation

Got it connected with BR-Gunz Client...

I think LGKeiz wanna release it... So dont gone release it. Or LGKeiz must permit me to do it.

Its easier then you think

go ahead o.o;

Quote:

---

Originally Posted by Rotana

Got it connected with BR-Gunz Client...

---

Me too... =)
Just don't enable XTrap check in server settings. %)

2All: Here's unpacked BR GunzLauncher.exe.
Just open it with HEX Editor and replace "gunz.vn.ua" with ur values. =]

in server.ini
[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"

xtrap is allready set to 0, so it's not enabled by default in the packed files ...

so you just replace gunz.vn.ua with your server ip and that's it ?

can this be made to work with an international locale server ? (not that good at spanish) :D

Quote:

---

Originally Posted by rakware

in server.ini
[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"

xtrap is allready set to 0, so it's not enabled by default in the packed files ...

so you just replace gunz.vn.ua with your server ip and that's it ?

can this be made to work with an international locale server ? (not that good at spanish) :D

---

Yup, just replace my values with yours.


Replace strings.xml in system.mrs with strings.xml from etiolated's server. =]

What I don't understand is:
If gunz.vn.us is the ip of the patch update server
Where do I put the IP of the MatchServer ? or .. how to I tell the client to connect to xxx IP ?

Edit:
Hmm I think it's the 200.229.52.6 entry isn't it ? :)