noob questions, might as well put them in one post

[hotandsekc]

Ok heres some few questions i have
How to create custom graveyard? searched... all there is are ascent guides..obviosly i run mangos.
How to add items to an npc loot table.
Add spells to npcs without scripts. But if possible someone could explain how to actually start scripts everyone starts guides off with MAKING script, not where to start. Do i make and put it in a scripts folder in my wow directory? Excute it into the database on a notepad? btw i tryed that and it said i was using the wrong function?
any help would be nice.
Runing Mangos noobpack.

[jewbacca089]

when you execute a file into the databases, it has to be an sql file. you can open them in notepad but it has to be an sql file to execute into the database.

[hotandsekc]

but i dont have to turn on scripts some how? it seemed that way on ascent but i never got it to work. all i do is make a script in notepad, name it xxx.sql and execute it? there isnt certain functions for differnt types of servers are thier?

[jewbacca089]

i dont think you can just name it xxxx.sql and it will be an sql. all i was saying that sql files are what are executed into the databases. I think that the scripts get put in your server folder in the scripts area. not sure if there is something else that you have to do to implement them but you can give it a try.

[hotandsekc]

well see i think it'll work but i asked if there is a certain type of functions i could use on certain servers becuase i get this error:
SQL Error: Your have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function Instanceportal_onEnterRange (pUnit, Even, pM
i dont even know where the "manual" is lol

[jewbacca089]

that manual might be on the mysql website. i dont have a manual so that is my guess

[TheSpidey]

function Instanceportal_onEnterRange (pUnit, Even, pM

This isn't SQL, it's Lua

[hotandsekc]

um ok well im not geting my question answered lol.... lua is scripts yes? and sql isnt? all i want to know where i need to start... im sure i can figure out how to do scripts with 500 guides out there....

[Ickybad]

um ok well im not geting my question answered lol.... lua is scripts yes? and sql isnt? all i want to know where i need to start... im sure i can figure out how to do scripts with 500 guides out there....

Well first anwser LUA is a script. And SQL is kinda a script but not its coding.

Also Top guy talking about LUA if you use mangos you cant use LUA mangos doesn't support LUA.

[hotandsekc]

ok that helps.. some... what kinda coding would i use then?

[TheSpidey]

SQL is the language you use to query the database, not an actual scripting language

[hotandsekc]

could you give me and example of one? i dont quite follow you....

[hotandsekc]

need an example /= need to start scripting! lol