Gm server need help

[Flo8]

Okay well ive made the GM server World of Game Mastas and yes its not working out atm. Peaple spawn npc's everywhere. My guess is they are coming from other servers and jelous our rank is going up fast. Im just wondering if anyone knows how to make it so i disable .npc spawn

Ive figured out how to disable ban u need to insert

cegijlmnopqrstuv into the GM column in sql.
please help

[Flo8]

Please help

[Lakelog]

I'm not sure if there is a way to disable GM commands. Just make sure they aren't spam players trying to ruin your server by asking them around before making their account GM

[Barlas the Death Knight]

Off topic: Hiya Flo! It's BarlasTheDeathKnight! From your server

On Topic: Hmm. I actually WOULDN'T take the powers away from everyone. I'd only take them away from abusers. and if they make an account again, and do it again, IP ban.

[Dragon111]

i feel stupid askin this but whats sql?

[copyzero]

Structured Query Language - is a computer language designed for the retrieval and management of data in relational database management systems database schema creation and modification, and database object access control management.

[Daxo]

Here... instead of giving everyone full GM... Put this at the GM slot in the accounts table "cdefgjilmmopqrstuvwz" this allows players to do all gm commands except npc commands... witch are

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.

So they cant spawn anything

[Dragon111]

ok so where do i enter cegijlmnopqrstuv ?

[Gastricpenguin]

Open the Accounts table, and put in that string under the "GM" field

[Dragon111]

Srry im retarted when it coms to computers
C:\Program Files\World of Warcraft\WTF\Account
is that the right place? because i cant find any gm field

[weaselking1973]

navact - ascent - accounts

[Daxo]

Open up navicat ( Or what ever you use) Now open your main database, open the table called "Accounts" now find the row called GM and paste cegijlmnopqrstuv there...

[skabbo]

Without using navicat how would i get to the gm table thing????

[Daxo]

What are you using?

[secretdragon008]

Daxo,they can still spawn somthing cant they?
i mean,its not just the npc you can add as a gm but the objects to.
so they can spawn full the server still with .go spawn (nummber).