EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=593)
-   -   PEQ Database Editor 1.0 (for servers 0.6.4 and up) (https://www.eqemulator.org/forums/showthread.php?t=20073)

Warking 01-31-2016 03:31 AM

Ah Thanks!! I did not have that URL before you mentioned it. working now

Warking 02-02-2016 03:41 AM

Anyone having issues adding NPCs via the peq editor? Once you hit submit nothing gets added. But I can edit existing ones just fine.

joligario 02-02-2016 06:37 AM

It hasn't been updated in almost a year, so it is probably just missing some database scheme items. I'll look at it soon. Guess I should finish off that AA branch too....

joligario 02-02-2016 10:00 PM

Actually, I just added a NPC just fine on the current branch. Did you pull from Git or are you using a packaged version?

Warking 02-02-2016 10:29 PM

I just pulled it all down with the peqbeta file "phpeditor_2015-02-13-07_59" a few days ago and installed it. On the top it says Version 1.0 It was working before and not it is not ... When trying to create npc it goes to a blank npc screen:

(no title)

Race:
Class:
Level:
Max Level:
Body Type:
Vendor: no
Alt Currency: no
Adventure: no
Trap: no
Tint: no
Pet: no
EmoteID: none

joligario 02-02-2016 10:42 PM

That explains it. Go get it from the Git. https://github.com/ProjectEQ/peqphpeditor

Warking 02-02-2016 11:11 PM

Thanks! That update fixed it.

Tempten 06-28-2016 07:53 PM

I haven't seen any other tools on the forums for editing AA data, and custom AAs are one of my favorite things to happen on servers, so I decided to try to fix this part of the editor up, to help me learn php and other stuff. Is anybody else currently working on it? From what I saw on github, not much of anything has been done in terms of editing AAs (the only case that works is the view AA case)

I've got the search functionality working a bit better (mainly just search by ID and name, search by expansion or class is a little bit more complex), and I've got the case for the form for creating the base aa data (for the table aa_ability) working, along with the case for pushing that form's data to the database, and finally the case for deleting the base aa data (the aa_ability row where id=$aaid, and $aaid=$_GET['aaid']), which leaves all the base rank data (from aa_ranks), rank effect data (from aa_rank_effects), and rank prerequisite data (from aa_rank_prereqs)

I'm somewhat new to coding (I started learning HTML about two months ago, and php around a month ago, and only had some rudimentary knowledge of C before that) so it's somewhat slow going. Is there a good place to go to ask questions about the editor and the SQL tables for the AA data? The forums at peqtgc.com don't seem to be letting me register.

Thanks for your time,

-Tempten

Riklin 11-15-2019 01:39 PM

Quote:

Originally Posted by cylocke (Post 131135)
I have to first set the path in cmd to get this to work correctly
mysql -u root mysql -p

when prompted for the password to get to the mysql prompt the password was denied, I did check winmysqladmin to see what the password was I did enter it in correctly
even tried changing it, I'm stuck on this part of it.

any ideas?

This has to do with how you set up mysql, or if you used Akka's installer, go look at your eqemu_config.json file in your server folder, for the password and userid mysql is set up to use. IF you installed MYSQL (mariadb?) on your own, then you need to use whatever password you used to set it up.

chrsschb 11-15-2019 09:18 PM

Quote:

Originally Posted by Riklin (Post 263968)
This has to do with how you set up mysql, or if you used Akka's installer, go look at your eqemu_config.json file in your server folder, for the password and userid mysql is set up to use. IF you installed MYSQL (mariadb?) on your own, then you need to use whatever password you used to set it up.

I hope he figured it out after 12 years.


All times are GMT -4. The time now is 04:42 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.