Would it be possible to have no-drop and no-rent default to "No" when creating an item with the PEQ editor?

I was looking at AUTO SCALER adding proc level/proc rate to the list of scaling options would be nice. It would be great to just scale some proc rates to items as another option. In fact bane damage and haste ratio could be as well.

Just some suggestions for improvement to it I don't know how involved those would be to add to it, but would be nice if they were available.

won't connect to my database for some reason,having no luck getting an editor working lol

Probably a port issue, I would imagine Bandor. I had also had to disable windows firewall entirely when I set this up. For whatever reason it's default position was to block all ports EXCEPT ones specified. That may be something to look into.

That's the point of having a firewall!

took down firewalls completely this morning and still won't work. I haven't forwarded my ports off my router (as I really didn't see a reason to open my server up just yet). So im thinking its either from that or my IP is wrong (which I doubt it is). lol I tried 3 editors yesterday and got 3 failures :P

I'm pretty sure if you haven't forwarded ports off your router yet than that is your issue. As I understand it. EoC is running elsewhere and needs to be able to get into your computer to make the DB changes you're doing on the EoC/Editor. i.e. need port forwarding open so EoC can communicate with your DB.

thats what I thought,time to call the cable company then lol

Forwarded my ports but still unable to connect,not sure what else to do at this point.

Setup your EQemu DB and get that working. Setup a port to forward from your router and windows firewall may additionally need it manually setup as well. Use your EQemu DB name, DB user, and DB pass. Use your IP with a port you've setup for port forwarding in your router config.

Go here to find your IP use that with your port.
http://www.whatismyip.com/

For example if your IP was 72.77.32.219 and your port was 6666 it would look like "72.77.32.219:6666" w/o the parentheses.

Ok so I contacted my internet provider and they had no luck either. They said I need the name of the application and if its TCP or UDP and the exact ports. I gave them port 3306 but am unsure on the rest of it. I gave them 3306 because that is what I used for setting up my server as the guides had suggested. If anyone would be able to further assist me it would be greatly appreciated.

You are trying to allow the EOC website to connect to your MySQL database using TCP/IP on port 3306.

Have you read the whole thread as most common problems have already been covered? To recap:-

Go to http://www.canyouseeme.org/

Put in 3306 and scan (obviously ensure Mysql is running). If it can't "see" you then either:-

1. You haven't started MySql (Google how to do it), or
2. You haven't opened that port in Windows Firewall (Google how to do it), or
3. Haven't set up port forwarding correctly (Google how to do it).

There's also the possibility that you set up MySQL on a port other than 3306, but you'd probably remember doing that!

If that website *CAN* see you then you may not have allowed remote login access in MySQL.

change 'username' to the user you set up, and 'password' to the password you set up.

did what you said. Website saw me and said port was not blocked. So i put the code in a command prompt. tried to log in again and no luck. im not sure what im doing wrong lol

in a mysql command prompt or just a normal one?(It needs to be in the mysql one or you could do it in HeidiSQL).

When you issued the command what did it say back to you?

I opened a command prompt and loaded to mysql using

when I inserted code it said Ok,0 rows affected.

Try installing Navicat or something similar and create a connection to your database using your external IP address (which you can find using the instructions in previous posts).

You can download a trial of it here. I think they stopped providing a free/lite version a while back, but the trial should work fine for this testing:

http://www.navicat.com/products/navicat-for-mysql

If you can't get a connection to work using the external address of your server, then there is something wrong with your configuration somewhere. It should work fine if you use the local IP address of your server, if you are running it from the same PC.

Some potential problems/solutions are:

1. You are using the incorrect IP address for connecting. You need to use the external IP address of your network because that is what everything outside of your local network will see your server as.

2. You did not forward port 3306 on your router. If you do not forward this port, your router will not allow the connection from the outside of your network to reach your server. It also would not even know which IP on your LAN to send it to. It is very important that you set your router for forward port 3306 to the local IP of the server your database is running on.

3. Your db account does not have permissions to be accessed from remote connections. As mentioned above, you would need to set your account(s) that you are trying to use from the outside connections (such as from EOC) to be able to be used from that source IP or domain name (such as 69.168.254.244 provided in a previous post). To simplify things, you might try setting it to be able to work from all IPs (using *.*), though you would probably want to limit it to specific IPs after you get it working to prevent potential security issues.

4. If everything else has been done and it still does not work, then you are probably running MySQL on Windows and did not check the box to allow remote connections to your DB when you installed MySQL. That can probably be resolved by changing a setting somewhere, but the only way I have ever done it is by running the MySQL install again and checking that box during the install. It is off by default, so I think a lot of Windows users might run into this issue.

I believe that all of that stuff will be required to setup a connection using Navicat that points to your server as if it was an outside address (using your external IP address).

Once your connection works in Navicat, you should be able to use the exact same settings in EOC and it will work.

Ok,Navicat connected to my db no problem at all.canyouseeme.com says they see port 3306 and it is NOT being blocked. Trying to modify the mysql installer did not work. So im guessing I will have to delete mysql and reinstall it completely. Question is if I do that will I lose my db changes? Or will a simple db backup keep that from being an issue?

redoing mysql didn't seem to help any. Who knows lol

PEQ Editor down in EOC?

Fixed. I'm working on 2.0 and I accidentally broke that piece in 1.0

Edit: It's fixed already.

Is there going to be a possibility to run this locally like the peq database editor? The reason I ask is I'm generally building my world on a laptop in a disconnected environment (commuting) so cannot really use EOC as-is.

I have been working on a lot of things related to EOC and I do plan to release some information on this within a timely manner.

Short answer is yes vsab

That will be awesome, I have a similar issue with my laptop and travelling but also I use a lot of hotel connections and have no way to access their routes to open ports.

I am currently behind like 3 routers right now before I hit the internet. :? It is a pain in rear!

hey Akk,

Just got this trying to generate a spell file, not sure if the issue is mine or yours :P

http://i.imgur.com/in2xrx6.png

Thanks,

Kimura

Experiencing the same thing as Kimura.

This was a simple permissions issue I have corrected.

Sorry for late response as I have been on vacation in California to see my brother graduate at MCRD.

No problem man, thanks for the quick fix! =)

Don't like how the race viewer doesn't show their race ID anymore... can this get fixed?

You may need to clear your cache. It should still show race ID

Just verified, you need to clear your cache or it will not show the ID's.

That's only because of the code changes I made recently. Shouldn't have to do it again

was looking for a way to set up a buff bot with eoc , is that possible? I was able to create the npc but then I'm stumped as I don't see a quest builder or can I do it with taskmaster?

Quest builder is in the future plans but not quite reality atm.

Use Notepad++ and do file edits for your scripts.

I curse all who got this setup in 15 minutes. I am really terrible at this.

EDIT: Windows firewall, curse you. I set up exemptions, it totally ignored them and blocked it anyway.

Just a quick FYI powersource and ammo slot seem to be mixed as i just created a throwing weapon that goes in powersource according to PEQ but in EOC it says its ammo...


Thanks for all your great work!
Crucial One

The current inventory system is based on the Titanium client, which is pre-PowerSource.

A work-around was implemented when the SoF client came along:
https://github.com/EQEmu/Server/blob...nstants.h#L890

This also means that the slots bitmask in the items table are backwards. Some fancy bit-shifting occurs in the client translators to correct this:
https://github.com/EQEmu/Server/blob.../sof.cpp#L2953


This issue will eventually be corrected..but, the whole inventory system has to be reworked and that will probably occur with the rework.

I'm logged into the tool but I can't actually seem to make edits to my db. I'm trying to update the MOTD via the PEQ Editor, I change the text, click submit and when it reloads the text is the same. The user I created for the tool has full privileges.

Any ideas?

Yo $20 PayPal whoever wants to use TeamViewer and make this work for me.

Lmk

Its quite simple, forward port 3306, run the sql query with the proper db user/password inserted and thats about it. Log in with the correct credentials after you run the query and your set.