Need Help Plz

[sxymxd84]

Hey everyone. i followed the guide step by step all the way up till this part

RUN your SQL Server Agent

3. lin2world Database - lin2world_20040609_all.sql Analyze Query,than press save and next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

4. lin2comm Database - lin2comm_new.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

5. lin2log Database - lin2log_20040416.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

6. lin2report Database - lin2report_20040416.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

7. lin2db Database - lin2db_AuthDBSchema.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

8. lin2db Database - lin2db_update.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

9. petition Database - petition.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.

IMPORTANT!!!

lin2db Database -> Table -> Server (open table)

add

id = 1
name = same as the worldname in l2server.ini
ip = your WAN IP
inner_ip = your LAN IP
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777



where and how to do all of this in MS SQL. is it under Enterprise manager or what. im stuck here. please help with any info u can.

[MentaL]

[sxymxd84]

isnt it crazy how no one helps each other here becuase people are lazy and rude? all i asked is how to do that step by step and stuff and asked questions and no answers going on 3 days now. wtf

[hernanpato]

omg ... u didnt read??? sql query analyzer

[theRAGE]

isnt it crazy how no one helps each other here becuase people are lazy and rude? all i asked is how to do that step by step and stuff and asked questions and no answers going on 3 days now. wtf

Isn't is crazy how our "rudeness" is related to the fact no one ever bothers to read?

[Shawnmb]

I believe you'll find it under the tools menu of the enterprise manager, or in the same category on the start menu.

[Stazis]

Step 1st - USE SEARCH !!!!!

[sxymxd84]

hold up guys. i did read. i read matter of fact 2 or 3 times. i open that enterprise manage. create the databases. now. i dont know exactly what to do for the quries tho. i get into query analyzer and i dont see a analyze butto at all. but i do see the green arrow button and what not however. what about the table>server part where ur supposed to add the

lin2db Database -> Table -> Server (open table)

add

id = 1
name = same as the worldname in l2server.ini
ip = your WAN IP
inner_ip = your LAN IP
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777



i searched this on this forum as week a good 3-4 days now and i dont see that file in the enterprise manager and i dont know how to find the server table as ive looked where its supposed to be several times and no server table there to modify. also if i open the db file in query analyzer and go to change them lines. it doesnt have the kind=0
port=7777 on it either and do i edit the txt inside of the brackets [ect] or what. this is what im confused on

[Stazis]

in hick's guide post there are files attached - one of them is DBScript - it contains l2db_update.sql file - this is a addon of server table

[sis]

i give u a good direction... read the manual in MSSQL, you ever tried that?

[Pokky]

hold up guys. i did read. i read matter of fact 2 or 3 times. i open that enterprise manage. create the databases. now. i dont know exactly what to do for the quries tho. i get into query analyzer and i dont see a analyze butto at all. but i do see the green arrow button and what not however. what about the table>server part where ur supposed to add the

lin2db Database -> Table -> Server (open table)

add

id = 1
name = same as the worldname in l2server.ini
ip = your WAN IP
inner_ip = your LAN IP
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777



i searched this on this forum as week a good 3-4 days now and i dont see that file in the enterprise manager and i dont know how to find the server table as ive looked where its supposed to be several times and no server table there to modify. also if i open the db file in query analyzer and go to change them lines. it doesnt have the kind=0
port=7777 on it either and do i edit the txt inside of the brackets [ect] or what. this is what im confused on

When u open Query Analyzer, look on the top bar, there is a l;ist of database. Scroll down this list till lin2db or lin2world...., Load Db Script ( open icon on the top bar ), browse to lin2dbupdate like the guide said, then press Ctrl + F5 ( Parse ), after Parsing, press F5 ( execute ), then save ... Then u done.

[nVidiaFreak]

My opinion is. that if you don't know how. and don't want to read a guide or use search. DON'T MAKE A FUCKING SERVER. t

[theRAGE]

My opinion is. that if you don't know how. and don't want to read a guide or use search. DON'T MAKE A FUCKING SERVER. t

Amen to that!

If you can't logically find a solution to your problem, how do you expect to actually be a GM for your server...? :chair: :chair: :chair:

[BoTGoD]

Rage lol i remember when you were asking me stuff all the time msn ;)

Of course were friends so... yea nvm im a tard..

[theRAGE]

Rage lol i remember when you were asking me stuff all the time msn ;)

Of course were friends so... yea nvm im a tard..

Yeah well... I asked you personally cause you got your server set up perfectly... I didn't rely on the entire RZ community to answer a few dumb questions :P

[Shawnmb]

Sometimes I wonder if this qualifies as a community...

[theRAGE]

Sometimes I wonder if this qualifies as a community...

Sometimes I wonder why I even gave you the url of this site...

[dudek25]

That part of Hicks' guide confused me too at first.. I found this to be more noob-friendly with the db creation stuff.

<<Setting up Databases>>

Make sure the SQL server is running, Open Service Manager (found in start menu) and if the start/continue button isn't greyed out click it.

Open SQL Server Enterprise Manager (start menu again), double click SQL Server Group, double click (local) the click OK. Double click on databases folder, to make a database right click and select New Database. Make the following databases: lin2world, lin2comm, lin2log, lin2report, lin2db, petition

If you used sa as your account you dont have to give permissions cause they already are set, if you used another account you have to make it and give permissions to the databases (I just used the sa account)

Go to the tools menu, then click SQL Query Analyser.

Change the database drop down menu on the top bar to lin2world. Then click the Load SQL Script button (Also on the top bar). Choose lin2world_20040609_all.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2comm. Then click the Load SQL Script button (Also on the top bar). Choose lin2comm_new.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2log. Then click the Load SQL Script button (Also on the top bar). Choose lin2log_20040416.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2report. Then click the Load SQL Script button (Also on the top bar). Choose lin2report_20040416.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2db. Then click the Load SQL Script button (Also on the top bar). Choose lin2db_AuthDBSchema.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to lin2db. Then click the Load SQL Script button (Also on the top bar). Choose lin2db_update.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Change the database drop down menu on the top bar to petition. Then click the Load SQL Script button (Also on the top bar). Choose petition.sql (Located in the DBScript folder). Click the Parse Query button (blue check mark icon) then once that is done click Execute Query (The green triangle icon). After this is complete go file save.

Close SQL Query Analyzer and open SQL Server Enterprise Manager. Under databases click lin2db then double click the tables icon. Right click on the server table go open table, then select return all rows. Add the following information:
(too add information in for the example id = 1 you would put the number 1 in the id column)
id = 1
name = same as the worldname in l2server.ini
ip = your external IP
inner_ip = your internal IP
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777

Close the SQL Server Enterprise Manager.

taken from here.

Hope this helps

[sxymxd84]

man u know what. i did read. and i did read my manual. and funny u should mention that btw i been gms for many games setup many servers for many games. ha. very easy. wow. i got a different version of ms sql and asked a question since hence it doeesnt look the same like some of them out there where as one says analyze one says parse ect ect. so. dont give me no crap. btw. i went to work came home and in 5 minutes figured it out anyways so. i mean. no need for help on this topic anymore. created my gm charecter and crap. and so forth. now i just gotta get npc server to boot up so i can kill and let others kill.

use search all the time by the way

[Pokky]

man u know what. i did read. and i did read my manual. and funny u should mention that btw i been gms for many games setup many servers for many games. ha. very easy. wow. i got a different version of ms sql and asked a question since hence it doeesnt look the same like some of them out there where as one says analyze one says parse ect ect. so. dont give me no crap. btw. i went to work came home and in 5 minutes figured it out anyways so. i mean. no need for help on this topic anymore. created my gm charecter and crap. and so forth. now i just gotta get npc server to boot up so i can kill and let others kill.

use search all the time by the way

lol, if u manage to create many server game then u must understand what he said ( btw, his guide was really not easy to understand... ). The different between versions of MSSQL is not so much. I dont mean to offend u, but this is not a place to tell u gm many games or something like that cuz many ppl here can do that ...Search is not good at all, cuz it will lead us to somewhere useless...I only try to read sticky guide and its enough. Another topic for question is created by n00b who cant understand and complain about everythings.

[sxymxd84]

nah im not a noob just hell. most servers dont run off of MS SQL so how am i not supposed to be confused ya know.