PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[cylocke]

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?

[gernblan]

Curious, what license is the editor released under?

I mean if someone makes changes to it and wants to share them, is that allowed?

[John Adams]

I change it all the time, but I do not share. That's the kinda guy I am. :p

I see no license info, but the ProjectEQ site will likely have more info. I believe it's their editor.

[gernblan]

My copy is also heavily (and I mean heavily) modified.

I cannot help but think that it would benefit everyone if we actually had a place to share all of our "changes". From what i could gather from posting on their forums, PEQ seems only to be interested in making it compatible with their database. They don't seem to be all that concerned about what happens once you download their db and add content of your own to it. New spawns, for example, break it and won't show up without doing a mod to the editor (due to the fact that new spawns don't get assigned an NPCID that fits into their "range of zonenumber+0..999" focus). In other words, they key on NPCID (which is silly) rather than zone the mob is spawned in (which makes sense). There's a thread about it I started. Cavedude told me no, won't fix it in the default distrib, the editor is working as intended.

I guess I'm just not getting it.

[gernblan]

I meant zonenumber+000..999 sorry... by the time I noticed that typo, my 5 minutes of editing my post grace expired.

[cavedude]

I replied to your post, but basically after some testing your way does cause noticeable slow downs on machines with heavy load. When dealing with PHP you want things as fast as possible and an extra query will not do that.

I understand the issue concerning the IDs, and I'd assume other people would have the same issue. For that, feel free to distribute your change. That's the beauty of open source, if you need the program to do something other than what the author had intended, you can.

People who create mobs out of game using the editor or queries would benefit from the stock way. It creates a more tidy db and as I said the editor performs better under heavy loads. Those who rather build in-game would most certainly benefit from your change, which for many people is a lot more user friendly.

[Fasthand]

Sound like interesting but me and my bro give up after 3 days of trying to get the server to answer us somethign else then "It Worked!"

documentation is way pass date!

[Expletus]

In reference to the editor? Shoot me a PM and I'll walk you through the steps I did for it to work.

[wolfwalkereci]

Finally got it working. Had two errors come up for me. One was telling me something about authentication which after searching google I found this solution to:

SET PASSWORD FOR root@localhost = OLD_PASSWORD('mypass');

Then it would give me a error on line 90 of mysql.php in the classes folder.
So I just deleted the whole section listed here:

 // Deter UNION SQL Injection
if (stripos($value, 'union')) {
logSQL("SQL injection monitored by user at IP: '" . getIP() . "' using the query: '" . $value . "'.");
header ("Location: index.php");
exit;
}

I can login and hopefully have no more issues.
Note- I attempted to follow the walk through as close as I could, which included google searching and downloading the older apache and php.

[Riklin]

Originally Posted by cylocke

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]

Originally Posted by Riklin

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.

[Shadow Wizard]

Ok, I am having allot of problems with this. Its proably because I don't understand the directions. It tells me to download all this stuff, and doesn't even tell me what machine to download it onto (Running the server on linux, and do all the admin work from a windows machine) Needless to say, I have downloaded both of the extras, on both machines (would like to know if they are needed on my windows machine) and sourced the file into the database, and I still get this in firefox:

set('javascript', $javascript); $tmpl->set('headbar', $headbar); $tmpl->set('searchbar', $searchbar); $tmpl->set('breadcrumbs', $breadcrumbs); $tmpl->set('body', $body); echo $tmpl->fetch('templates/index.tmpl.php'); ?>

There must be something I am missing. Some help please.

I thought I would also add that for kicks, I tried it on the linux machine. It simply wants to save the file (index.php)

[aronnov]

Originally Posted by Shadow Wizard

Ok, I am having allot of problems with this. Its proably because I don't understand the directions. It tells me to download all this stuff, and doesn't even tell me what machine to download it onto (Running the server on linux, and do all the admin work from a windows machine) Needless to say, I have downloaded both of the extras, on both machines (would like to know if they are needed on my windows machine) and sourced the file into the database, and I still get this in firefox:

set('javascript', $javascript); $tmpl->set('headbar', $headbar); $tmpl->set('searchbar', $searchbar); $tmpl->set('breadcrumbs', $breadcrumbs); $tmpl->set('body', $body); echo $tmpl->fetch('templates/index.tmpl.php'); ?>

There must be something I am missing. Some help please.

I thought I would also add that for kicks, I tried it on the linux machine. It simply wants to save the file (index.php)

I have the exact same error. anyone have any tips or updated step by step instructions?

[Pirate123]

ok im getting an error that says

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Web\classes\mysql.php on line 6
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

it was working before then i accidently changed the eq user password to something else, but changed it back to eq, and now its refusing to work. any ideas?

[Dunmord]

To all those who have troubles logging, follow this procedure. It will give admin access to anyone who enters the PEQ Admin(no matter the username and password).

a) Look for a folder named "classes"(inside your PEQ-Admin folder).
b) Make a backup of the file session.php
c) Open file session.php with your favorite text editor(not WordPad).
d) Locate these 3 functions: logged_in(), check_authorization() and is_admin().
e) Replace whatever those functions have with:
return true; (yes, the semi-colon too)

Here's an example of how should they look...
function logged_in(){
return true;
}


f) save the file