PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[NatedogEZ]

Would adding spawn2.version to the zonelist be something that would be helpful for anyone?

I have code for it.. just not sure if its too custom or whatever... :p


Here is what it looks like.... note I added $version (spawn2) to the searchbar for NPC editing

[cavedude]

I have wanted to do something like that, it certainly will help for LDoN. I would definitely be interested in that code for inclusion in SVN.

[NatedogEZ]

The way I wrote it only works correctly with ... $npc_list = 2;

Gotta figure a way out to make it work with the other way as well.. but my brain huts from lack of sleep.. :p

[sorvani]

Yes, please. I been tinkering with Ikkinz stuff lately and it is apain in the ass to keep some things straight. But how would this code handle quest spawned? still have to hit the base version 0?

[cavedude]

sorvani: Yes, I would have them under version 0 since they would be npc_types without a spawnpoint in the DB.

NatedogEZ: Share whatever you feel comfortable with. If it still needs work, one of us can finish it up.

[NatedogEZ]

I did something kinda stupid but it is sort of working in my favor lol... was using the variable $version for spawn2 version in the searchbar.. and forgot that npc_types has a version in the field list that uses it as the variable $version (doh)

The default database already has version set to npc_types in different versions which really helps and might be a better way to separate them.. but zone version

I think what I wrote though needs to be reconfigured to separate the variables.. so yeah.. doh :p

[cavedude]

Something to keep in mind. version in spawn2 is hard-fast. The server uses it so it has to be correct. However, version in npc_types is only used by us for organizational sake. It doesn't necessarily have to be correct. Meaning, a npc_type could have version in npc_types set to 0, even though it is in version 3 of the zone.

Also, a single NPC can be in multiple versions of a zone if it has multiple spawn points. That's where things get tricky with this :I

[joligario]

I'm not having any issues with the SVN. Perhaps you had a connection issue.

[Rhodan]

I was able to update quests from svn. Don't know why peqeditor wouldn't work.

[vsab]

Get it from http://peqtgc.com/releases instead of SVN.

[Rhodan]

Got it! And now the SVN works from the resulting directory too.

There seems to be something wrong with the login routine though. I always get an error

Invalid login attempt. Bad password from IP: '127.0.0.1'. Username: 'admin' Password: 'password'.; -- admin (18-May-14 15:36:24)

But I checked and the password in peq_admin does match md5('password')

odds bodkins!

Found it in another post. XAMPP defaults to short tags off, turned them on and all is well.

[hayward6]

Does anyone know how I fix this? THis is my first time with the editor... Everything seems setup correctly, but that logs directory doesn't exist on my server... Even after I created it and provided write access to it I couldn't work this out. Thank you!

Could not create logs/sql_log_08-2014.sql! Make sure the logs directory is writeable by your webserver.

[joligario]

What is the logs and parent chmod?

[hayward6]

Originally Posted by joligario

What is the logs and parent chmod?

I have been playing around with several and the login screen itself "The pfpeditor folder" likes 755, but nothing I do to the logs folder seems to help.

I have no idea... I have even moved the log location in the config file and it's the same thing. There must be a setting somewhere that allows the webserver to write, and until I find that... It won't work.

[joligario]

Yeah, 755 the folders and 644 the files (if I remember right). Are you running with a different user than the public html owner? Is it outside your public html folder with a symlink?

EDIT: How about give me an ls -al from your editor directory.