[Walshie]

Thanks For this mate

[Walshie]

very nice and neat. Best iv seen

[Sithreaver]

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).

[latruwski]

Originally Posted by Sithreaver

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).

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

[damon160]

Nice +rep if i had any =(

[Sithreaver]

***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.

[ADAMZY]

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

Any help is appreciated.

[ADAMZY]

Originally Posted by latruwski

ah verry simple

you see this:


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:


and your host IP and username you can see if you right click on your database => connection info.. then you see something like this:



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

grtz

Worked perfect

Thank you so much

[Dee2001]

nice this will help with people with ascent servers, Thanks

[Dee2001]

..... I cant get NPC display
id's... all well says unexpcted error

[latruwski]

Originally Posted by Dee2001

..... 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

[Ukrajinc]

Hey this is a nice guide and all but can you help me as i cannot search items no matter what i put in the search field.

[latruwski]

give detailed info on what error you get and what DB u are using etc etc etc...

grtz

[Ukrajinc]

Hi i get this error:

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)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AscentDBEditor
Assembly Version: 0.6.0.0
Win32 Version: 0.6.0.0
CodeBase: file:///C:/funserver/Silvermoon%20Funserver%20Repack/AscentDBEditor.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
MySql.Data
Assembly Version: 5.0.8.0
Win32 Version: 5.0.8.0
CodeBase: file:///C:/funserver/Silvermoon%20Funserver%20Repack/MySql.Data.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** 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.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

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.


I am using the Silvermoon Funserver Repack

[latruwski]

UPDATE!

now supporting new database structure !!!

grtz