Query to Modify Anything in Any Column of Any Table in Any DB

[shoree]

Damn this post was old already but it helped me alot, in fact not only helped me but also I'm a bit less nub in query stuff thanks to the advises that you guys gave me in the comments and thanks to my hard work (it will seem not hard for you but I guess you guys will understand what I'm saying) . Well those 2 query mean nothing compared to the changes I made at this one grabing what everyone said in comments here specialy what nubness said here my ty to you friend. Anyway here is the true query that can make all the stuff written in the tittle of this old thread I hope you like it guys

 Spoiler

UPDATE PS_Gamedefs.dbo.MobItems
SET Grade = 13, DropRate = 50
WHERE MobID in (2011) AND ItemOrder in (1)

This time the explanation goes out of the Spoiler because I learned that XD. Well as you guys can see its not really dificult to understand this query if me that i'm nub in this can understand than those who don't well idk what to say than.

here goes first you put the DB where are the tables and columns you want to change you put here "UPDATE PS_Gamedefs" than you put the table here ".db.MobItems" its important that you know what is a DB and a table first. After that you can use 1 or many columns that you want at "SET Grade = 13" this if you want to change only 1 column and put the "," without the quotes after "SET Grade = 13" if you want to change more than 1 column. Now last step of the query is the conditions that you want them to have so the change can happen, just imagine you go to a shop and ask for a candy and you say I want a candy "only" if it has Orange taste, well in this part of the query the meaning of "conditions" is exact the same as the candy example so the line "WHERE MobID in (2011) AND ItemOrder in (1)" its exacly the same as "change those grades and droprates only if MobID is (2011) and ItemOrder is (1)". If you want to use more MobID and ItemOrder just put example (2011,103,104 etc..) in MobID and (1,2,3,4 etc...) in this case maximum is 9 per MobID in ItemOrder. Well here is my new work please give a thanks if you like and comment if you like too or feel that something isn't right or can be better. Ty guys.

Credits to: nubness + all members that already comented this post + me

[nubness]

this.Genius = true;
Like();
Share();
Comment();
Respect++;

[TeddyBear94]

well this should be common sense actually. If you plan on creating a shaiya server you should know atleast a few sql.
but yet still a good for the ones that completly start new.

[shaiyadeveloper]

This should definitely be categorized under "common sense." If you don't know how to change multiple rows with a simple UPDATE statement like in these text files on your own, you definitely shouldn't be blindly trusting another user's scripts.

A better alternative to this, would be a tutorial for SQL such as

That's a decent site for references to SQL commands, and gives you a basic understanding of the process of crafting an SQL statement suited for your needs, such as a change to multiple rows of a database.

Lastly, the line "Where MobID in (list)" should have IN capitalized as it is an SQL operator. Just formatting quirks that make things easier to read.

[nubness]

Actually, SQL isn't a case sensitive language, which means IN = In = iN = in.

Also, for the #1 post, you can write this:

UPDATE PS_Gamedefs.dbo.MobItems
SET Grade = 0
UPDATE PS_Gamedefs.dbo.MobItems
SET DropRate = 0

in a less redundant way:

UPDATE PS_GameDefs.dbo.MobItems
SET Grade = 0, DropRate = 0

[shoree]

tnx guys I apreciate you're advice in this since I'm nub yet but I'm learning what I can so thanks for any helps that already came and it may still come. Well that post I allways thought that there was no Query to edit moob drops that was what many DEV's told me when I started DEV in Shaiya so now that I created one or maybe 2 looks like 2 Query, I thought about posting here for those that are having the same question that I had which is "Is there any Query to edit the drops" now we can say YES

[shaiyadeveloper]

Originally Posted by nubness

Actually, SQL isn't a case sensitive language, which means IN = In = iN = in.

It's not case sensitive, no, but it's formatting that makes things easier to read. You don't want people writing code without indentation and incorrect capitalizing all over the place, that makes it a struggle to understand.

[tadjer]

Guys pls im make the server but How can i make it online I really need help add me on ur skype : cold.wind3 Plssssss . ty

[shaiyadeveloper]

Originally Posted by tadjer

Guys pls im make the server but How can i make it online I really need help add me on ur skype : cold.wind3 Plssssss . ty

I will not give you links to answer your question, and I hope that others reading this also refrain from giving them out.

All the answers you need are on this site. In the process of finding your answer, you will also find reasons NOT to make your server public until you are ready for it. When you have a public server, you open yourself up to being hacked and exploited, and if you don't know how to setup your server for public access, then you definitely don't know how to protect yourself from attackers.

Keep browsing the forums, reading and learning from guides, and you'll find your answer. And a lot of other answers you didn't even know you needed

[sominus]

The right question is not "Is there any Query to edit the drops", but (once you learn where to edit a drop) "how to update a table in sql server", which can be easily found on google.

[shoree]

I made this and right now I didn't knew how to do it XD but the good news is that in some hours I'll put my 1st server online and yes I just used the search tool here in epvp because I already know how this site works.

[nubness]

[shoree]

look at the edited thread guys if you like the new stuff

[kollegga]

tell me you are trolling with this topic, please.

[shoree]

why would I been trolling? O.o