[Guide] Lots of usefull things V2

[Spartansp]

Ok again i make a compile of all usefull things i found in guides... (sorry for not giving credits but there are lots of people so i will give credit to MMOwned comunity and other emus forums)

NPC LUA Cast spell:

function MOBNAME(Unit)
if Unit:GetHealthPct() < X then
Unit:CastSpell(SPELL)
Unit:SendChatMessage(Type, LANG, "WHATEVER")

The red things are the ones you eed to change ill explain one by one:

MOBNAME=self explanatory
X= MOB HEALTH PERCENTAGE
SPELL= spell ID *sigh*
Type= 1 normal chat message, 12 yell mesagge (there are more but dont remember well)
LANG= just use 0 for universal language
"Whatever"= what you mob will say when casting

here is an example:

function Custom MOB (Unit)
if Unit:GetHealthPct() < 75 then
Unit:CastSpell(37669)
Unit:SendChatMessage(12, 0, "Taste MY Holy nova!!!")

This will make my mob when he is 75 or less percentage cast a holy nova and say "Taste my holy nova!!!"

How to execute .sql batch files with navicat:

Ok this is reaaaaaally easy just right click into your main database and click n the option that says execute batch file and thats all

How to make a backup of your database:
right click on the whole database or in the specific table you want a backup and click on the "dump sql file" option and voila!! lol

How can i make custom MOBS???:

Its easy you need to fill acordingly all columns in a new entry in creature_names and creature_proto tables just remember to use same ID in creature proto as the creature_names.


How to spawn gameobjects in ascent?

just search for the entry ID of the gameobject you want to spawn in your gameobject_names table and remember it, then go in game and type the following:

.go spawn entryID 1 that 1 is to make it stay forever and not disapearing on restart :P

Ascent basic commands for new users:

[ASCENT] Server
------------------------
Within the databse used for Ascent servers, you will find a table called "accounts". this table is normally located under your character databse, but could be in your world if only using a single database. Within the accounts table, there is a field that says GM. the following codes show which letter needs to be present for the function to work. Apparently putting "az" (without quatation marks) is the equivalent to a-z, therefore enabling all commands valid on that account.


Banstick Commands [b]
banchar: Bans character x with or without reason
This command is confirmed to work. Givign a reason seems pointless because the other player does not see the reason. Possibly useful in GM tickets or for GM's to see?

unbanchar: Unbans character x
Confirmed to work.

kick: Kicks player from server, with or without reason
confirmed to work. Takes 5 seconds.

paralyze: Roots/Paralyzes the target.
confirmed to work. Player can twist, sit, withdrawl weapon, and talk. No jumping or moving. Dueling is allowed but player can not move, but can attack back.

unparalyze: Unroots/Unparalyzes the target.
confirmed to work.

Chat Control [c]
allowwhispers: Allows whispers from player <s> while in gmon mode.
blockwhispers: Blocks whispers from player <s> while in gmon mode.

Debug Commands [d]
debug: Main ‘debug’ command table. Usage: .debug <subcommand> <args>
infront: No description entered.
showreact: This seems to send a specified reaction to a character or player. Just need to find react #'s.
aimove: brings selected creature/npc to player.
dist: reveals current distance between player and selected object.
face: function unknown at this time.
moveinfo: Displays information on selected creature, such as is it attacking, what it's facing, and other info.
setbytes: Set fields 1-4 to X X X X. Not sure what differnce things make at the moment.
getbytes: Get bytes for fiels 1-4 in numbers such as X X X X
unroot: confirmed to work, no idea for reason.
root: confirmed to work, no idea for reason.
landwalk: reason unknown.
waterwalk: Allows you to walk on water.
castspell: .castspell <spellid> - Casts spell on target.
castspellne: .castspellne - Casts spell on target (only plays animations, doesnt handle effects or range/facing/etc. Also doesn't play all animations.
celldelete: USE WITH CAUTION! '.celldelete YES' - Removes everything in current cell from game and database. '.celldelete YES YES' removes everything in a range of 1cell.
addrestxp: .addrestxp - Adds x rest XP to player.
generatename: .generatename - Generates name for pet, etc.
attackerinfo: .attackerinfo - Shows selected mob/player's attacker's infomation.
showattackers: .showattackers - Shows selected mob/player's attacker on the minimap.
aggrorange: .aggrorange - Shows aggro Range of the selected Creature.
knockback : .knockback <value> - Knocks you back.
fade : .fade <value> - calls ModThreatModifyer().
threatMod : .threatMod <value> - calls ModGeneratedThreatModifyer().
calcThreat : .calcThreat <dmg> <spellId> - calculates threat.
threatList : .threatList - returns all AI_Targets of the selected Creature.
gettptime: grabs transporter travel time
itempushresult: sends item push result
weather: used ton control weather. ie .debug weather 2 90 to make it rain hard. playing with all #'s
haha 8 10 is snow!

setbit: afraid to test at the moment.
setvalue: afraid to test at the moment.
getpos: Seems to have no function.

Battlegrounds Commands [e]
battleground: Main BG command table. Usage: .battleground <subcommand> <args>
setbgscore: <Teamid> <Score> - Sets battleground score. 2 Arguments.
startbg: Starts current battleground match.
pausebg: Pauses current battleground match.
bginfo: Displays information about current battleground.
battleground: Shows BG Menu
setworldstate: <var> <val> - Var can be in hex. WS Value.
playsound: <val>. Val can be in hex.
setbfstatus: .setbfstatus – Not Yet Implemented.
leave: Leaves the current battleground.

Extended Debug Commands? [f]
killbyplayer: Disconnects the player with name <s>.
killbyaccount: Disconnects the session with account name <s>.
getrate: Gets rate <x>. ?
setrate: Sets rate <x>. ?

GM Ticket Commands [g]
gmTicket: Main GM ticket system command table. Usage: .gmTicket <subcommand> <args>
get: Gets GM Ticket
getId: Gets GM Ticket by ID
delId: Deletes GM Ticket by ID

Invincibility Command [j]
invincible: .invincible - Toggles INVINCIBILITY (mobs won't attack you)

Invisibility Command [i]
invisible: .invisible - Toggles INVINCIBILITY and INVISIBILITY (mobs won't attack you and nobody can see you, but they can see your chat messages)

Guild Commands [l]
createguild: No description entered.

Modify commands [m]
modify: Main stat-modification command table. Usage: .modify <subcommand> <args>
hp: Health Points/HP
mana: Mana Points/MP
rage: Rage Points
energy: Energy Points
armor: Armor
holy: Holy Resistance
fire: Fire Resistance
nature: Nature Resistance
frost: Frost Resistance
shadow: Shadow Resistance
arcane: Arcane Resistance
damage: Unit Damage Min/Max
scale: Size/Scale
gold: Gold/Money/Copper
speed: Movement Speed
nativedisplayid: Native Display ID
displayid: Display ID
flags: Unit Flags:
faction: Faction Template
dynamicflags: Dynamic Flags
talentpoints: Talent Points
loyalty: Loyalty
spirit: Spirit
boundingraidus: Bounding Radius
combatreach: Combat Reach
emotestate: NPC Emote State

More Modify Commands [m]
createaccount: .createaccount - Creates account. Format should be .createaccount username password email
playerinfo: .playerinfo - Displays informations about the selected character (account...)
mount: Mounts into modelid x.
dismount: Dismounts.
start: Teleport's you to a starting location
levelup: No description entered.
additem: No description entered.
removeitem: Removes item %u count %u.
learn: Learns spell
unlearn: Unlearns spell
learnskill: .learnskill <skillid> (optional) <value> <maxvalue> - Learns skill id skillid.
advanceskill: advanceskill <skillid> <amount> - Advances skill line x times..
removeskill: .removeskill <skillid> - Removes skill
increaseweaponskill: .increaseweaponskill <count> - Increase eqipped weapon skill x times (defaults to 1).
removeauras: Removes all auras from target
setmotd: Sets MOTD
additemset: Adds item set to inv.
gotrig: Warps to areatrigger <id>
createinstance: Creates instance on map <map>
goinstance: Joins instance <instance> <x> <y> <z> <optional>
exitinstance: Exits current instance, return to entry point.
dbreload: Reloads some of the database tables
spawnspiritguide: Spawns a spirit guide (params: 1 = horde, 0 = alliance)
advanceallskills: Advances all skills <x> points.
unlockmovement: Unlocks movement for player.
modperiod: Changes period of current transporter.
npcfollow: Sets npc to follow you
follow: Sets npc to not follow anything
formationlink1: Sets formation master.
formationlink2: Sets formation slave with distance and angle
formationclear: Removes formation from creature
playall: Plays a sound to the entire server.
addipban: Bans an ip address <address> <duration>
banaccounts: Bans accounts <name> <duration>
renamechar: Renames character x to y.
forcerenamechar: Forces character x to rename his char next login
getstanding: Gets standing of faction %u.
setstanding: Sets standing of faction %u.

Cheat Commands [m]
cheat: Main cheat command table. Usage: .cheat <subcommand> <args>
status: Shows active cheats.
taxi: Enables all taxi nodes.
cooldown: Enables no cooldown cheat.
casttime: Enables no cast time cheat.
power: Disables mana consumption etc.
god: Sets god mode, prevents you from taking damage.
fly: Sets fly mode
land: Unsets fly mode
explore: Reveals the unexplored parts of the map.
flyspeed: Modifies fly speed.
stack: Enables aura stacking cheat.
morph: Morphs into model id x.
demorph: Demorphs from morphed model.

Honor Modification Commands [m]
honor: Main honor system command table. Usage: .honor <subcommand> <args>
getpvprank: Gets PVP Rank
setpvprank: Sets PVP Rank
addpoints: Adds x amount of honor points/currency
addkills: Adds x amount of honor kills
globaldailyupdate: Daily honor field moves
singledailyupdate: Daily honor field moves for selected player only
pvpcredit: Sends PVP credit packet, with specified rank and points

Pet Commands [m]
pet: Main pet command table. Usage: .pet <subcommand> <args>
createpet: Creates a pet with <entry>.
renamepet: Renames a pet to <name>.
enablerename: Enables pet rename.
addspell: Teaches pet <spell>.
removespell: Removes pet spell <spell>.

NPC Commands [n]
npc: Main NPC command table. Usage: .npc <subcommand> <args>
vendoradditem: Adds to vendor
vendorremoveitem: Removes from vendor.
flags: Changes NPC flags
emote: emote - Sets emote state
run: No description entered.
addweapon: No description entered.
allowmove: No description entered.
addgrave: No description entered.
addspirit: No description entered.
faction: No description entered.
delete: Deletes mob from db and world.
info: Displays NPC information
guid: Shows selected object guid
addAgent: .npc addAgent <agent> <procEvent> <procChance> <procCount> <spellId> <spellType> <spelltargetType> <spellCooldown> <floatMisc1> <Misc2>
delAgent: .npc delAgent <procEvent> <spellId>
listAgent: .npc listAgent
reset: resets npc health/dmg from temp table.
export: Exports the npc to a sql file
say: .npc say <text> - Makes selected mob say text <text>.
yell: .npc yell <Text> - Makes selected mob yell text <text>.
come: .npc come - Makes npc move to your position
return: .npc return - Returns ncp to spawnpoint.
spawn: .npc spawn - Spawns npc of entry <id>
spawnlink: .spawnlink sqlentry
resetreputation: .resetreputation - Resets reputation to start levels. (use on characters that were made before reputation fixes.)
resetlevel: .resetlevel - Resets all stats to level 1 of targeted player. DANGEROUS.
resetspells: .resetspells - Resets all spells to starting spells of targeted player. DANGEROUS.
resettalents: .resettalents - Resets all talents of targeted player to that of their current level. DANGEROUS.
resetskills: .resetskills - Resets all skills.

GameObject Commands [o]
gobject: Main gameobject command table. Usage: .gobject <subcommand> <args>
select: Selects the nearest GameObject to you
delete: Deletes selected GameObject
spawn: Spawns a GameObject by ID
info: Gives you informations about selected GO
activate: Activates/Opens the selected GO.
enable: Enables the selected GO for use.
scale: Sets scale of selected GO
animprogress: Sets anim progress
export: Exports the current GO selected
statelink: .statelink sqlentry, Links a GO state to a Npc

Information Commands [p]
gm: Shows active GM's
gps: Shows Position
info: Server info
uptime: Shows server uptime

Teleport (Recall)Commands [q]
recall: Main teleportation command table. Usage: .recall <subcommand> <args>
list: List recall locations
port: Port to recalled location
add: Add recall location
del: Remove a recall location
portplayer: recall ports player

Life and Death Commands [r]
kill: .kill - Kills selected unit.
revive: Revives you.: 0, 0, 0},
reviveplr: Revives player specified.

Save Commands [s]
save: Save's your character
saveall: Save's all playing characters

GM Tag Commands [t]
fmoff: Sets GM tag off
gmon: Sets GM tag on

Universal Commands [u]
Commands: Shows Commands
help: Shows help for command
announce: Sends Msg To All
wannounce: Sends Widescreen Msg To All


Extended Teleport Commands [v]
appear: Teleports to x's position.
summon: Summons x to your position
worldport: No description entered.

Waypoint Commands [w]
waypoint: waypointCommandTable
add: Add wp at current pos
show: Show wp's for creature
hide: Hide wp's for creature
delete: Delete selected wp
movehere: Move to this wp
flags: Wp flags
waittime: Wait time at this wp
emote: Emote at this wp
skin: Skin at this wp
change: Change at this wp
info: Show info for wp
movetype: Movement type at wp
generateNo description entered.Randomly generate wps
save: Save all waypoints
deleteall: Delete all waypoints

Admin Commands [z]
security: No description entered.
servershutdown: Initiates server shutdown in <x> seconds.
serverrestart: Initiates server restart in <x> seconds.
castall: Makes all players online cast spell <x>
those are the basic ones :P

how to download ascent and databases from SVN source first of all you need to download Tortoise SVN after that you just need to make a new folder and right click inside the folder and click on "SVN checkout" then a window will pop up for you to type the SVN link for ascent type svn://emupedia.com/svn/ascent and for the NCDB (next chapter database) http://projects.emupedia.com/svn/ncdb for both the username is anonymous and password is (blank) so NO PASSWORD leave it as it is :P


How to make custom graveyards

Go to the location of the area you would like to make the graveyard and do .gps to get the coords, then go into your navicat and go to graveyards table, fill out the things acordingly,go back ingame to the place you want the spirit healer, and type .spawnspiritguide and then restart server.

[BrantX]

Cool and Useful stuff +rep

Edit :: I'll +rep once i get the chance...

[C-Death]

sweet, good job, can't rep u again though XD

[Spartansp]

no problem ill get you rep later

[Ellenor]

CooL +rep and stinky!!!!

[Spartansp]

stinky???? you mean this stink?

[Avatori]

CooL +rep and stinky!!!!

I think he meant Sticky :P

[Spartansp]

lol if a mod see this and think this should be stickied then they will meanwhile im glad youguys find it usefull

[abndrew82]

very helpful post, this will hopefully help me in learning more about LUA

[coardoso]

nice guide all works 4 me!!! now i'm waiting u 4 ur post on how to public server ...nice work dudes i'll +Rep u!!!

[nether drake]

a Question , about npc spell cast

so when he reach 80 (example) he will cast the spell but for once or till he die ? and will the spell have a CD ?

[Spartansp]

very helpful post, this will hopefully help me in learning more about LUA

Glad you found it usefull

nice guide all works 4 me!!! now i'm waiting u 4 ur post on how to public server ...nice work dudes i'll +Rep u!!!

maybe ill do it later thanks for rep

a Question , about npc spell cast

so when he reach 80 (example) he will cast the spell but for once or till he die ? and will the spell have a CD ?

ok i dont understand your question... i think you are saying about the lua script he will cast it depending on the miliseconds you put...