Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Join Date: Nov 2007
Posts: 3
Reputation: 1
Re: Ascent Database Editor
Looks and (seems) to work great!
I downloaded it hoping I could get some functionality out of it connected to a Mangos database (It's actually a udb or project silvermoon db, but it's for a mangos server, so I digress), but the naming schemes are just too different.
I'd +rep if it actually meant anything coming from me (I think I need 5 posts before +rep actually counts? I'll double check myself and come back and +rep when it actually means something).
I downloaded it hoping I could get some functionality out of it connected to a Mangos database (It's actually a udb or project silvermoon db, but it's for a mangos server, so I digress), but the naming schemes are just too different.
I'd +rep if it actually meant anything coming from me (I think I need 5 posts before +rep actually counts? I'll double check myself and come back and +rep when it actually means something).
well i found a mangos database handler:
[Only registered and activated users can see links. ] (Compatible with MaNGOS Rev 4400+)
source: [Only registered and activated users can see links. ]
maybe this will help you if ascent database editor doesn't...
or if you can, try to edit ascent DBeditor to make it work with mangos...
grtz
__________________
(\_/) Give to people who have been helpfull!
(O.o) This is Bunny. Copy Bunny into your signature
(> <) to help him on his way to world domination.
[Only registered and activated users can see links. ]
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Join Date: Nov 2007
Posts: 3
Reputation: 1
Re: Ascent Database Editor
***latruwski***
maybe this will help you if ascent database editor doesn't...
or if you can, try to edit ascent DBeditor to make it work with mangos...
***
Actually, I've taken to using SQLyog (free/community version) as a simple graphical front-end for MySQL, and even if I don't know what many of the fields are for (especially on the more obscure tables), it lets me make basic item mods fairly easily.
The Bluesailor website says it doesn't work with TBC MaNGOS, but I'll give it a shot anyway and reply with comments on it later.
PS: Sorry for the hack job on quoting you, but "To be able to post links or images your post count must be 3 or greater. You currently have 2 posts."
Apparently the "quote" tag counts as well. I'm finding the anal retentive nature of some aspects of this board to be off-putting.
Last edited by Sithreaver; 11-20-2007 at 08:14 PM.
Im using 2Dgreengiants repack, and i can't connect... i really want to make some items... The last time i played with emu servers was the AFGWarriors repack, where items were in txt files
you see this: [Only registered and activated users can see links. ]
the first time you open it the upper thing should say: 'New Connection' (next to the delete button)
under that you have to type your host... if you host your database on your pc type localhost... if it is hosted somewhere else type the IP the database host.
then you have to type username and password... normally if you made your MySQL database on your PC or somewhere else you had to enter a password... that password you got to type in here.. the username is the username you use to login in your database with navicat.
last thing you got to fill in is the database name...you created a new database on your mysql host... for example 'ascent' then fill in ascent...
your database name in navicat is here: [Only registered and activated users can see links. ]
and your host IP and username you can see if you right click on your database => connection info.. then you see something like this:
[Only registered and activated users can see links. ]
for the database password i think i dont have to make screens right? you had to configure it yourself... but if you really need help with that also then i post
..... I cant get NPC display
id's... all well says unexpcted error
you type in correct displayIDs?
how to find displayID:
go to wowhead.com
search for the npc with the model you wnt
for example illidan... link: [Only registered and activated users can see links. ]
at end of the link you see a number: 22083 (in this example)
after you have that ID go to you database
open the creature_names or proto table (i am at school, forgot wich one ^^)
search for illidan in creature names or for the 22083 IDnumber in creature proto
(again i say *** or *** cuz i forgot wich table)
then find the column "displayID"
voila you have a displayID
if this is not your problem post a screenie or something..
grtz
__________________
(\_/) Give to people who have been helpfull!
(O.o) This is Bunny. Copy Bunny into your signature
(> <) to help him on his way to world domination.
[Only registered and activated users can see links. ]
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
MySql.Data.MySqlClient.MySqlException: Unknown column 'name1' in 'field list'
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at AscentDBEditor.frmItemChooser.btnSearch_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
to people who have been helpfull!
