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