Still a beginner

02/07/2015 01:26 victors1995#1

Hi,
I am still a beginner in creating SRO servers , i wanna open a server on the end of the year.

I made 2 NPCs right now and i just wanna ask a question!
What am i supposed to learn at the beginning ?
Please number somethings to start learning
Easy to hard please ^_^
Thanks.

02/07/2015 01:31 Memoirs#2

First you need to learn how server files works, how database is connected with client, these are basics.
Next steps database editing / client editing.
Last thing you'll need to learn to write sql query's.

02/07/2015 01:43 victors1995#3

Quote:

Originally Posted by Memoirs

First you need to learn how server files works, how database is connected with client, these are basics.
Next steps database editing / client editing.
Last thing you'll need to learn to write sql query's.

1.First you need to learn how server files works -->DONE

2.How database is connected with client --> DONE

3.Next steps database editing / client editing. --> This is the thing i need so that i can open a good but not perfect server i guess.

4.Last thing you'll need to learn to write sql query's. --> It looks like coding with Visual Basic i guess it will be easy for me but i wont try something like that untill i can edit DB/media peacefully

02/07/2015 01:45 Exo#4

First of all, if you want to learn simply forget opening a server for now.

I was once told that I should put a goal and start working on it.
Decide your project and try to do it.
I'd recommend learning some SQL at first as you can't do anything w/o it.

02/07/2015 06:15 Syloxx#5

Quote:

Originally Posted by victors1995

4.Last thing you'll need to learn to write sql query's. --> It looks like coding with Visual Basic i guess it will be easy for me but i wont try something like that untill i can edit DB/media peacefully

he is talking about write new procedures and don't edit existing tables

Examples:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

actually SQL is pretty easy if you just wanna get things to work... every idiot can write new procedures.

the hard thing is make the readable, don't lost performance with your procedures.

on the examples you can take a look on my SQL history :D