Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 20:41

  • Please register to post and access all features, it's quick, easy and FREE!

 

Lil tip for junior ADM

Reply
 
Old   #1
 
elite*gold: 30
Join Date: Mar 2012
Posts: 633
Received Thanks: 287
Thumbs up Lil tip for junior ADM

Hello!
Just wanna say that it will be very helpful if you read this book:
Martin Gruber - Understanding SQL.
You can find many diferrent translations in the Net. Use your search=)
Admin, share it please in download center=)



mongreldogg is offline  
Old   #2


 
elite*gold: 30
Join Date: May 2011
Posts: 4,805
Received Thanks: 3,185
I don't even see a sence of reading a book about MS SQL.
If you are able do understand English, you'll understand MS SQL (Rappelz-Stuff!) without a problem.


Xijezu is offline  
Old   #3
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
Quote:
Originally Posted by Xijezu View Post
I don't even see a sence of reading a book about MS SQL.
If you are able do understand English, you'll understand MS SQL (Rappelz-Stuff!) without a problem.
+1 for this

i just learnt from looking at queries , its very simple
Strange2010 is offline  
Old   #4
 
elite*gold: 30
Join Date: Mar 2012
Posts: 633
Received Thanks: 287
True, but book contains not a lot info and very easy for learnin'.
And book contains info that you really want=)


mongreldogg is offline  
Old   #5


 
elite*gold: 30
Join Date: May 2011
Posts: 4,805
Received Thanks: 3,185
Quote:
Originally Posted by mongreldogg View Post
And book contains info that you really want=)
When you just are working with Rappelz, which info's do you want?
sys-sp's? Casts/converts?
You only need the knowledge of SELECT, INSERT, UPDATE, DELETE and sometimes for some queries JOIN, but well, in this sections are hundrets of those Queries to understand those.
Xijezu is offline  
Old   #6
 
elite*gold: 30
Join Date: Mar 2012
Posts: 633
Received Thanks: 287
Quote:
Originally Posted by Xijezu View Post
When you just are working with Rappelz, which info's do you want?
sys-sp's? Casts/converts?
You only need the knowledge of SELECT, INSERT, UPDATE, DELETE and sometimes for some queries JOIN, but well, in this sections are hundrets of those Queries to understand those.
Right, but many things may be useful=)
For example queries inside queries, sorting of data (useful if you creating any top pages), executing queries by using yr handmade program (info about this exists) and so=)
mongreldogg is offline  
Old   #7
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
Quote:
Originally Posted by Xijezu View Post
When you just are working with Rappelz, which info's do you want?
sys-sp's? Casts/converts?
You only need the knowledge of SELECT, INSERT, UPDATE, DELETE and sometimes for some queries JOIN, but well, in this sections are hundrets of those Queries to understand those.
is creating stored procedures (smps) hard ? i hava a missing one and i know all the (@IN_XXX) values in it
Strange2010 is offline  
Old   #8
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Xijezu View Post
I don't even see a sence of reading a book about MS SQL.
If you are able do understand English, you'll understand MS SQL (Rappelz-Stuff!) without a problem.
It's NEVER a bad idea to learn something about SQL since it is used in lots of working fields...

And i could cry if i see those guys rightclicking on the table selecting "edit top 200 rows". Or if i get questions like "how to edit lines which are not in the first 200 lines..."

Because of that 80% of this community should read something about SQL. This will eliminate about 70% of noob questions...If you don't know how to write stored procedures...you should google a bit or look through the other smps^^ SMPs are SQL Statements nothing more...
c1ph3r is offline  
Thanks
1 User
Old   #9


 
elite*gold: 30
Join Date: May 2011
Posts: 4,805
Received Thanks: 3,185
Quote:
Originally Posted by c1ph3r View Post
It's NEVER a bad idea to learn something about SQL since it is used in lots of working fields...
I was basing on Rappelz-Stuff.
Xijezu is offline  
Old   #10
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by c1ph3r View Post
It's NEVER a bad idea to learn something about SQL since it is used in lots of working fields...

And i could cry if i see those guys rightclicking on the table selecting "edit top 200 rows". Or if i get questions like "how to edit lines which are not in the first 200 lines..."

Because of that 80% of this community should read something about SQL. This will eliminate about 70% of noob questions...If you don't know how to write stored procedures...you should google a bit or look through the other smps^^ SMPs are SQL Statements nothing more...
^this is based on my experiences with people trying to get an rappelz pserver running.

To correct myself:

Some people should google SQL at least before starting to create an pserver...it won't hurt and too much knowledge haven't killed someone till now
c1ph3r is offline  
Thanks
1 User
Old   #11
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
I didnt googled it and got the basic´s into my Head. <.<
TheOnlyOneRaskim is offline  
Old   #12
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by TheOnlyOneRaskim View Post
I didnt googled it and got the basic´s into my Head. <.<
If your brain is healthy, present for 99% and your mother didn't throw you on the ground after your birth...you can learn by yourself otherwise you should google :P

Example:

If you are trying to edit the tables via "rightclick -> edit top 200 rows" start to google and stop spam around in the forum with n00b threads...
c1ph3r is offline  
Old   #13
 
elite*gold: 30
Join Date: Mar 2012
Posts: 633
Received Thanks: 287
LAZY BONEZ xD
mongreldogg is offline  
Old   #14
 
elite*gold: 0
Join Date: Apr 2012
Posts: 453
Received Thanks: 781
you can also change options to have "edit all rows"

the big problem with SQL is that every servers has different syntax (but yes we can only use mssql with rappelz)

and yes SQL is really easy, even without any knowledge it's easy to understand queries, else MSDN is where to find all information needed


glandu2 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Trading €30 Junior PSC for €20 +18 PSC
Exactly what the title says: Trading €30 Junior PSC for €20 +18 PSC
2 Replies - Trading
Free GFX by Junior
Hey Com Da ich längere Zeit keine Signaturen/Avatare gemacht habe und etwas eingerostet bin,deswegen Übungen brauche biete ich über kürzere Zeit...
21 Replies - Freebies
.Junior - GFX & More
Hey Com Hiermit biete ich einen kleinen GFX-Shop an Preise: Leistung|Preis Avatar|5 E*Gold Signatur|7 E*Gold
19 Replies - elite*gold Trading
To aLL juniOr mEmbER!!!!
:p:ptO aLL oF juniOr memBer!!!! Stop PoStinG hacks iF noT woRking ANd cOntain viRus specially keylogger!!!to avoiD ban!!!and foR the ELiTevPerS...
23 Replies - Soldier Front Philippines
junior
hi ya http://www.elitepvpers.com/forum/images/smilies/biggrin.gif
0 Replies - Say Hello



All times are GMT +1. The time now is 20:41.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.