PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[wolfwalkereci]

Was bored and wanted to update my localhost phpbb3 portal and needed php5 installed to do it.
Previously I used apache 2.0.55 and php 4.4.2

If you try this backup your old stuff. If you modify the windows path you need to restart the computer for change to take effect.

Took me a few minutes to figure it out but this is what I took notes on:

Using the following:

http://www.apachelounge.com/download/
*** you see a link for VC10 SP1 vcredist_x86.exe , that link is broken, head to microcraps website and just copy / paste vcredist_x86.exe in the search box at the top and install it if you need it. I installed the 64bit apache earlier to play with it and thus installed the VC10 dist for 64bit and have no issues with the x86 working for me. No install of VC10 on this machine ***
httpd-2.4.2-win32.zip
php5apache2_4.dll-php-5.4-win32.zip

http://windows.php.net/downloads/releases/archives/
php-5.4.0-Win32-VC9-x86.zip

Unziped apache to C:\apache24
Unziped php to C:\php5

Added C:\php5 to system path
php.ini uncomment extension=php_mysql.dll
php.ini set extension_dir = C:\php5\ext
php.ini set doc_root = "c:\web"
php.ini set error_reporting = E_ALL
php.ini adjusted other fields to personal settings

httpd.conf set ServerRoot "c:/Apache24"
httpd.conf set Listen 80
httpd.conf set LoadModule php5_module "c:/php5/php5apache2_4.dll"
AddHandler application/x-httpd-php .php
PHPIniDir "C:/php5"
httpd.conf set ServerName localhost:80
httpd.conf set DocumentRoot "C:/web"
httpd.conf set <Directory "c:/web">
httpd.conf set DirectoryIndex index.html index.html.var index.htm index.php
httpd.conf set ScriptAlias /php/ "c:/php5/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/php5/php.exe"

ISSUES: shitty ass error about old passwords. Something like "Connect Error (2000) mysqlnd cannot connect to MySQL 4.1+ using old authentication"

FIX:
http://stackoverflow.com/questions/1...authentication
Opened Navicat --> mysql --> Query --> New Query
SHOW VARIABLES LIKE 'old_passwords';

(in the MySQL command line client, HeidiSQL or whatever frontend you like) whether the server is set to use the old password schema by default. If this returns old_passwords,Off you just happen to have old password entries in the users tables. The MySQL will use the old authentication routine for these accounts. But you can simply set a new password for the account and the new routine will be used.
You can check which routine will be used by taking a look at the mysql.users table (with an account that has access to that table)

SELECT `User`, `Host`, Length(`Password`) FROM mysql.user;

This will return 16 for accounts with old passwords and 41 for accounts with new passwords (and 0 for accounts with no password at all, you might want to take care of those as well).
Either use the user managements tools of the MySQL front end (if there are any) or

SET PASSWORD FOR 'User'@'Host'=PASSWORD('yourpassword');
FLUSH Privileges

(replace User and Host with the values you' got from the previous query). Then check the length of the password again. It should be 41 now and mysqlnd should be able to connect to the server.

Edit: Everyone has their own quirks doing the installs but I noticed that the magelo and allaclone tools actually work 100% for me now, when previously much of those tools refused to work at all.

[Tabasco]

This is a really simple update to edit procrates in items.
http://dungeoncrawl.us.to/procrate.diff.txt

[joligario]

Originally Posted by Tabasco

This is a really simple update to edit procrates in items.
http://dungeoncrawl.us.to/procrate.diff.txt

Added to the editor (in a slightly different location). Thanks!

[blindaviator]

I installed the editor yesterday and everything looked good until I tried to add a new faction.

Here is the error I get:

Query failed:
INSERT INTO faction_list SET id="501", name="Guardians_of_Knowledge", base="0", mod_c1="0", mod_c2="0", mod_c3="0", mod_c4="0", mod_c5="0", mod_c6="0", mod_c7="0", mod_c8="0", mod_c9="0", mod_c10="0", mod_c11="0", mod_c12="0", mod_c13="0", mod_c14="0", mod_c15="0", mod_c16="0", mod_r1="0", mod_r2="0", mod_r3="0", mod_r4="0", mod_r5="0", mod_r6="0", mod_r8="0", mod_r9="0", mod_r10="0", mod_r11="0", mod_r12="0", mod_r14="0", mod_r42="0", mod_r75="0", mod_r108="0", mod_r128="0", mod_r130="0", mod_r161="0", mod_r330="0", mod_r367="0", mod_r522="0", mod_d201="0", mod_d202="0", mod_d203="0", mod_d204="0", mod_d205="0", mod_d206="0", mod_d207="0", mod_d208="0", mod_d209="0", mod_d210="0", mod_d211="0", mod_d212="0", mod_d213="0", mod_d214="0", mod_d215="0", mod_d216="0", mod_d140="0" - Unknown column 'mod_c1' in 'field list'

I looked at the PHP code and then checked the database table for the columns it was trying to create/modify and they don't exist. Are those columns removed by design or am I missing something?
If they are removed by design then I will know not to use the faction part of the editor.

[cavedude]

Factions changed significantly, and the editor has only been partially converted on my local copy to accommodate that. It's on my list of things to get back to.

[joligario]

Oh, CD beat me to it.

[cavedude]

If they are, it's because I forgot to remove them. KLS changed factions to get rid of those stupid columns and make the table dynamic. So, that particular table isn't used anymore.

[joligario]

No, I was mistaken. You're good.

EDIT: I'll work on the change.

[blindaviator]

Thx you two. Glad to know it wasn't something I did this time.

[joligario]

Newest files in SVN should be functional with faction changes.

[cavedude]

Originally Posted by joligario

Newest files in SVN should be functional with faction changes.

Thanks a lot for getting that in! The only change I made was the race/class/deity name will now display under faction mods. We'll have to come up with a decent solution for editing/adding mods.

[joligario]

Originally Posted by cavedude

Thanks a lot for getting that in! The only change I made was the race/class/deity name will now display under faction mods. We'll have to come up with a decent solution for editing/adding mods.

Too easy. When I get a chance I will work in selectors.

[blindaviator]

Nix this question... I found it finally... Sorry to be a bother...

[blindaviator]

Hehe another one found.

Fatal error: Call to undefined function update_faction_values() in C:\xampp\htdocs\eqemu_editor\lib\faction.php on line 80

[joligario]

What were you doing so I can troubleshoot? I may have missed other npc faction functions...

EDIT: Ah, I see it. Working on it now.