Register for your free account! | Forgot your password?

You last visited: Today at 17:35

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

 

Simple request

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2006
Posts: 124
Received Thanks: 2
Simple request

ok.. hoping you guys know how to press the reply button this time... I need a mangos database thats ENGLISH and has all the monsters, items, npcs in it etc. I dont care if you have to upload the ******* mangos.sql file itself.. I just need one that ISNT in ******* german -.- because my friends and family dont know how to read it and it annoys the hell outta me that there are no ENGLISH tutorials on how to make a private server and I had to use german rebuilds.. If someone could brighten my day by 300% by uploading a simple ******* mangos.sql file thats full english that'd be just ******* peachy!!



TekiJinn is offline  
Old   #2
 
elite*gold: 0
Join Date: Nov 2006
Posts: 98
Received Thanks: 150
Wait, so do you want a command list? I found one and posted it below, but I am not sure that this is what you are asking for.
Quote:
by shadowhunter posted and edited dimmy

acct
Syntax: .acct
Display the access level of your account.

commands
Syntax: .commands
Display a list of available commands for your account level.

dismount
Syntax: .dismount
Dismount you, if you are mounted.

info
Syntax: .info
Display the number of connected players.

gmlist
Syntax: .gmlist
Display a list of available Game Masters.

help
Syntax: .help
Display usage instructions for the given .

showhonor
Syntax: .showhonor
Display your honor ranking.

save
Syntax: .save
Saves your character.

start
Syntax: .start
Teleport you to the starting area of your character.

announce
Syntax: .announce
Send a global message to all players online.

gmoff
Syntax: .gmoff
Disable the prefix for your character.

gmon
Syntax: .gmon
Enable the prefix for your character.

goname
Syntax: .goname
Teleport to the given character. Either specify the character name or click on the character's portait, e.g. when you are in a
group.

gps
Syntax: .gps
Display the position information for a selected character or creature. Position information includes X, Y, Z, and orientation, map Id
and zone

Id
modify
Syntax: .modify
Modify the value of various parameters.
Use .help modify to get help on specific parameter usage.
Supported parameters include hp, mana, rage, energy, gold, level, speed, swim, scale, bit, bwalk, aspeed, faction, and spell.

modify aspeed
Syntax: .modify aspeed #speed
Modify all speeds -run,swim,run back- of the selected player.
If no player is selected, modify your speed. #speed may range from 0 to 50.

modify bit
Syntax: .modify bit #field #bit
Toggle the #bit bit of the #field field for the selected player. If no player is selected, modify your character.

modify bwalk
Syntax: .modify bwalk #speed
Modify the speed of the selected player while running backwards. If no player is selected, modify your speed. #speed may range from 0 to 50.

modify energy
Syntax: .modify energy #energy
Modify the energy of the selected player. If no player is selected, modify your energy.

modify faction
Syntax: .modify faction #factionid #flagid #npcflagid #dynamicflagid
Modify the faction and flags of the selected creature. Without arguments, display the faction and flags of the selected creature.

modify gold
Syntax: .modify gold #money
Add or remove money to the selected player. If no player is selected, modify your money. #gold can be negative to remove money.
modify hp
Syntax: .modify hp #newhp
Modify the hp of the selected player. If no player is selected, modify your hp.

modify mana
Syntax: .modify mana #newmana
Modify the mana of the selected player. If no player is selected, modify your mana.

modify rage
Syntax: .modify rage #newrage
Modify the rage of the selected player. If no player is selected, modify your rage.

modify scale
Syntax: .modify scale #number from 0 to 3
Modify the scale ofthe selected player

modify speed
Syntax: .modify speed #speed
Modify the running speed of the selected player. If no player is selected, modify your speed. #speed may range from 0 to 50.

modify spell
!!! Need informations here !!!

modify swim
Syntax: .modify swim #speed
Modify the swim speed of the selected player. If no player is selected, modify your speed. #speed may range from 0 to 50.
namego

Syntax: .namego
Teleport the given character to you. Either specify the character name or click on the player's portrait, e.g. when you are in a group.
recall

Syntax: .recall
Teleport you to various towns around the world. defines the target location. Available places include sunr, thun, cross, ogri, neth, thel, storm, iron, under, and darr.
whispers

Usage: .whispers on|off
Enable/disable accepting whispers by GM from players. By default use mangosd.conf setting.

goobject
Usage: .goobject #object_guid
Teleport your character to gameobject with guid #creature_guid

searchtele
Syntax: .searchtele
Search and output all .tele command locations with provide in name.

addmove
Syntax: .addmove [#waittime]
Add your current location as a waypoint for the selected creature. And optional add wait time.

addspw
Syntax: .addspw #creatureid Spawn a creature by the given template id of #creatureid.

changelevel
Syntax: .changelevel #level
Change the level of the selected creature to #level. #level may range from 1 to 63.

delete
Syntax: .delete
Delete the selected creature from the world.

demorph
Syntax: .demorph
Demorph the selected player.

displayid
Syntax: .displayid #displayid
Change the model id of the selected creature to #displayid.

factionid
Syntax: .factionid #factionid
Set the faction of the selected creature to #factionid.

guid
Syntax: .guid
Display the GUID for the selected character.

item
Syntax: .item #guid #amount
Add the given amount #amount of the item with a GUID of #guid to the selected vendor.

itemmove
Syntax: .itemmove #sourceslotid #destinationslotid
Move an item from slots #sourceslotid to #destinationslotid in your inventory Not yet implemented

itemrmv
Syntax: .itemrmv #guid
Remove the given item with a GUID of #guid from the selected vendor.

kick
Syntax: .kick
Kick the given character from the world.

name
Syntax: .name
Change the name of the selected creature or character to . Command disabled.

random
Syntax: .random #flag
Enable or disable random movement for the selected creature.
Use a #flag of value 1 to enable, use a #flag value of 0 to disable random movement.
Not yet implemented.

npcflag
Syntax: .npcflag #npcflag
Set the NPC flags of the selected creature to #npcflag.

ticket
Syntax: .ticket on .ticket off .ticket #num .ticket
on/off for GMs to show or not a new ticket directly, to show ticket of this character, #num to show ticket #num.

delticket
Syntax: .delticket all .delticket #num .delticket
all to delete all tickets at server, to delete ticket of this character, #num to delete ticket #num.

prog
Syntax: .prog
Teleport you to Programmers Island.

run
Syntax: .run #flag
Enable or disable running movement for a selected creature.
Use a #flag of value 1 to enable, use a #flag value of 0 to disable running. Not yet implemented.

subname
Syntax: .subname
Change the subname of the selected creature or player to . Command disabled.

gocreature
Usage: .gocreature #creature_guid
Teleport your character to creature with guid #creature_guid.

targetobject
Usage: .targetobject [#go_id|#go_name_part]
Locate and show position nearest gameobject.
If #go_id or #go_name_part provide then loacate and show position of neares gameobject with gameobject tempalte id #go_id or name included #go_name_part as part.

delobject
Usage: .delobject #go_guid
Delete gameobject with guid #go_guid.

addgo
Syntax: .addgo #id
Add a game object from game object templates to the world at your current location using the #id.
Note: this is a copy of .gameobject.

addgrave
Syntax: .addgrave (any|alliance|horde)
Add a graveyard at your current location for any or specific faction. If in radius 50f already exist graveyard then instead creating new this graveyard coordinates, orientation and faction updated.
Current zone automaticly linked to created graveyard.

additem
Syntax: .additem #itemid [#itemcount] or .additem 0 #itemcount
Adds the specified number of items of id #itemid to your or selected character inventory.
If #itemcount is omitted, only one item will be added.
With the second syntax you can add an item with exact (!) name .

additemset
Syntax: .additemset #itemsetid
Add items from itemset of id #itemsetid to your or selected character inventory.
Will add by one sample each item from itemset.

addsh
Syntax: .addsh
Add a spirit healer to your current location. Not yet implemented.
addspirit

Syntax: .addspirit
Spawns the spirit healer for the current location, if there is one defined for the current location.
Command disabled.

addweapon
Not yet implemented.

allowmove
Syntax: .allowmove
Enable or disable movement for the selected creature.

anim
Syntax: .anim #emoteid
Play emote #emoteid for your character.

aura
Syntax: .aura #spellid
Add the aura from spell #spellid to your character.

bank
Syntax: .bank
Show your bank inventory.

createguild
Syntax: .createguild ?
Create a guild named ? with the player ? as leader.

die
Syntax: .die
Kill the selected player or creature. If no player or creature selected, it will kill you.

distance
Syntax: .distance
Display the distance from your character to the selected creature.

emote
Syntax: .emote #emoteid
Make the selected creature emote with an emote of id #emoteid.

explorecheat
Syntax: .explorecheat #flag Reveal or hide all maps for the selected player. If no player is selected, hide or reveal maps to you. Use a #flag of value 1 to reveal, use a #flag value of 0 to hide all maps.

gameobject
Syntax: .gameobject #id
Add a game object from game object templates to the world at your current position using the #id.
getvalue

Syntax: .getvalue #field #isInt
Get the field #field of the selected creature. If no creature is selected, get the content of your field.
Use a #isInt of value 1 if the expected field content is an integer.

go
Syntax: .go #position_x #position_y #position_z #mapid
Teleport to the given coordinates on the specified map.

hidearea
Syntax: .hidearea #areaid
Hide the area of #areaid to the selected character. If no character is selected, hide this area to you.

hover
Syntax: .hover #flag
Enable or disable hover mode for your character. Use a #flag of value 1 to enable, use a #flag value of 0 to disable hover.

learn
Syntax: .learn #parameter
Selected character learn a spell of id #parameter.
Code:

A GM can use : .learn all, if he wants to learn all default spells for Game Masters .learn all_lang, to learn all langauges .learn all_myclass, to learn all spells available for his class (Character selection in these cases ignored).


learnsk
Syntax: .learnsk #skillId #level #max
Learn a skill of id #skill with a current skill value of #level and a maximum value of #max for the selected character. If no character is selected, you learn the skill.

levelup
Syntax: .levelup #numberoflevels
Increase the level of the selected character by #numberoflevels.
If #numberoflevels is omitted, the level will be increase by 1. If no character is selected, increase your level.

linkgrave
Syntax: .linkgrave #graveyard_id
Link current zone to graveyard.
This let character ghost from zone teleport to graveyard after die if graveyard is nearest from linked to zone and accept ghost of this faction.
From instance ghosts teleported to nearest linked graveyard with ignoring ghost faction.

loadscripts
Syntax: .loadscripts
Unload current and load the script library or reload current if omitted, in case you changed it while the server was running.

Mod32Value
Syntax: .Mod32Value #field #value
Add #value to field #field of your character.

morph
Syntax: .morph #displayid
Change your current model id to #displayid.

neargrave
Syntax: .neargrave [any|alliance|horde]
Find nearest graveyard linked to zone (or only nearest from accepts any, alliance, horde faction ghosts).

NewMail
Syntax: .NewMail? #flag
Send a new mail notification with flag #flag.

npcinfo
Syntax: .npcinfo
Display a list of details for the selected creature.
The list includes :

GUID, Faction, NPC flags, Entry ID, Model ID
Level, - Health (current/maximum)
Field flags, dynamic flags, faction template
Position information
and the creature type, e.g. if the creature is a vendor.

npcinfoset
Syntax: .npcinfoset
TODO: Write me.

object
Syntax: .object #displayid
Add a new object of type mailbox with the display id of #displayid to your current position.
If is set to 'true', save the object in the database.

QNM
Syntax: .QNM #flag
Query next mail time with flag #flag.

reload
Not yet implemented.
revive
Syntax: .revive
Revive the selected player. If no player is selected, it will revive you.

security
Syntax: .security #level
Set the security level of player to a level of #level. #level may range from 0 to 5 (even if no command exist for levels 4 and 5).

setvalue
Syntax: .setvalue #field #value #isInt Set the field #field of the selected creature with value #value. If no creature is selected, set the content of your field. Use a #isInt of value 1 if #value is an integer.

showarea
Syntax: .showarea #areaid
Reveal the area of #areaid to the selected character. If no character is selected, reveal this area to you.

standstate
Syntax: .standstate #emoteid
Change the emote of your character while standing to #emoteid.

transport
Not yet implemented.

unaura
Syntax: .unaura #spellid
Remove aura due to spell #spellid from your character.

unlearn
Syntax: .unlearn #startspell #endspell
Unlearn for selected player the range of spells between id #startspell and #endspell. If no #endspell is provided, just unlearn spell of id #startspell.

unlearnsk
Syntax: .unlearnsk #parameter
Unlearn a skill of id #parameter for the selected character. If no character is selected, you unlearn the skill.

update
Syntax: .update #field #value
Update the field #field of the selected character or creature with value #value.
If no #value is provided, display the content of field #field.

wchange
Syntax: .wchange #weathertype #status
Set current weather to #weathertype with an intensitiy of #status.
#weathertype can be 1 for rain, 2 for snow, and 3 for sand.
#status can be 0 for disabled(light, e.g. light rain), and 1 for enabled(heavy, e.g. heavy snow).

worldport
Syntax: .worldport #map #position_x #position_y #position_z
Teleport to the given coordinates on the specified continent (map).

shuttdown
Syntax: .shuttdown seconds

cshuttdown
Syntax: .cshuttdown
Cancels shuttdown

reset
Usage: .reset stats
Resets all stats of the targeted player to their orginal values at level 1.
Please unequip all items and debuff all auras from the player before using.
.reset talents Removes all talents of the targeted player.

maxskill
Usage: .maxskill
Sets all skills of the targeted player to their maximum values for its current level.


OblivionMage is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Jan 2006
Posts: 124
Received Thanks: 2
umm thank you very much for the commands but I was looking for a database where commands,items, monsters, npcs, spells, skills, etc. where all English. Because right now my database is all german and my comfortable language is English.
TekiJinn is offline  
Old   #4
 
elite*gold: 0
Join Date: Nov 2006
Posts: 98
Received Thanks: 150
Ok, so you want a database, I think I have found some.

Credits to boudin
Quote:
ACDB rev 6.1-Harbringer of 'K'os


+++++++
rev 6:
+++++++


Zul' aman items
All new Flying mounts added
Lottery NPC
Morph NPC
Redone Dollar store (shopping mall)
Works with latest ascent 2368+
Deleted some more useless crap
added some missing items+ quests
Changed some display Ids to add a "funserver" twist to things
Added a lot of missing creature loot (thanx to whoever made that tool to rip wowhead)
Added 90% of the Arena season 3 items


to download it:

All credits to ACDB

--------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------

[Preview] ACDB rev7- Paragon

--------------------------------------------------------------------------------

This is just to show a PREVIEW of what is to come and also the Release Dates

Change log:
Redone the Donator v2 items
SPAWNED Zil'AMAN (idk if its full...need to get on retail and packet sniff em)
All Zul' Aman Loot (ithink.. i ripped off wowhead..hope it worked rite)
Full spawned Event locations (mazes, ladder events, Race tracks)
some more that ill add....





RELEASE DATES


ACDB VIP- December 25th
ACWEB VIP JAN1st
Public release- jan 10th

Could also be seen on ************ forum

And here is a simple tutorial on how to use it
Credits to DreeZen
Quote:

(1)download ACDB rev6
(2)Turn on your MySLQ
(3)download Navicat "a cracked one would be the best" i can't give u the link to the cracked one because of the admin
(4)Open up Navicat and login (should look like this) :

Host name/IP adress: localhost / 127.0.0.1 / your IP adress
Port: 3306
User name: root
password: ****** (ascent)

(5)Press "Test Connection" and hit "OK"
(6)Right Click where the the list of ur datebase is like: ascent - forum - information_shema joomla etc...
(7)Now choose "New Database"
( 8 )Let us call the Database "ACDBrev6" after u have done that then hit "OK"
(9)Ok right click on "ACDBrev6" and choose "Execute Batch file"
(10)Now find the ACDBrev6 on your Computer and hit "Open"
(11)Now wait untill it have done that should take about 10-15 min
(12)after it have done that then go into ACDBrev6 and use Ctrl - A and Ctrl - C
(13)Now go into the Database called "ascent" and Paste it there (Ctrl - V ofc) xD
(14)Now u should be done.

remember : .npc spawn 50000 1 - 50080 1 (remember the 1)

I hope this helps u
I think that is also making a database.


Hope this helps!

Cheers,


OblivionMage is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Jan 2006
Posts: 124
Received Thanks: 2
Thank you much, Just what I wanted .


TekiJinn is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
simple request
I tried to figure this out, but seems to be kinda stucked. How can i convert VP(ulong) to CPs(ushort). Dosnt seems to work for me x.X btw. is...
13 Replies - CO2 PServer - Discussions / Questions
Request for a simple bot
Ive been searching for some time now, downloading several bots, but I havent actually found a bot that targets only one client if u multi-client. The...
3 Replies - Perfect World
[REQUEST]2 small simple request please look in here
Hello all no one here knows me i am Rukia Owner Od DarkAngelzCO 2.0 i was wondering if anyone can kindly show me 1 solutions first off can anyone...
6 Replies - CO2 PServer - Discussions / Questions
simple request
hi, been to busy re-creating the fukk-tq.com website and having a life as well as playing the game. if someone has the time, they should really...
3 Replies - CO2 Main - Discussions / Questions



All times are GMT +1. The time now is 17:35.


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

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