[NEW] EMU Expert Question/request/FAQ thread, QUESTIONS HERE!

[TheSpidey]

nick: Yes. AllowedIP controls connections from world servers to the logon server. You don't want others to connect with their world server to your logon server. AllowedModIPs controls which IPs can change things in the logon DB. Again, you do not want to expose this to everyone. Security matters.
Deathrobert: You need to extract map files from the client and put them in your Ascent folder
powerbar: Possible only via areatriggers currently
Pingvinen: What's the problem with those two items?

[kreegoth]

Hi, I recently finnished a script, and now I need help to make an undead character that wear these two items (I can't post links, but these are the entry id's):

31658 and 2800

Got any idea of how to do that?

Look for the table that says player starting items and add those values to the table for undead characters...

[Pingvinen]

I think we have a missunderstanding here, my bad.

Those two items need to be equiped on an undead male npc (like the npc's in Undercity) not on my character.

[Lukas 45]

Can anyone make a guide for: How to make a Account Creation site

[Sounddead]

Is there a way to make it so a quest can make like your defence and weapon skills go up?

[nick567402]

nick: Yes. AllowedIP controls connections from world servers to the logon server. You don't want others to connect with their world server to your logon server. AllowedModIPs controls which IPs can change things in the logon DB. Again, you do not want to expose this to everyone. Security matters.
Deathrobert: You need to extract map files from the client and put them in your Ascent folder
powerbar: Possible only via areatriggers currently
Pingvinen: What's the problem with those two items?

The spidey i still dont understand what i did wrong in my config files all my ports are ok in router and in my firewall. I can access my server but when others try they get eather dced from the connecting to world or they get kicked back to realm list. now i had one time were a guy had this happen, authenticating etc, then it goes: Denied, xxxx.xxxx.xxxx.xxxx:xxxx IP DENIED and he cant logon i tried everything can u look at my config files please and tel me im realy stuck thanks the config files are on the previous page (page 5. Thanks.

[dukenyrl]

When any of the characters logout of my server their quest log is empty when logging back in.

Any point in the right direction is appreciated.

Dukenyrl

[TheSpidey]

Take a look at your console. It would probably say something like "Couldn't select from `questlog`". It means your character db is outdated

[dukenyrl]

thanks for the point in the right direction. it actually says:

Sql query failed due to [Column count doesn't match value count at row 1], Query: [REPLACE into questlog VALUES<13,9215,0,0,0,0,0,0,0,0,0,0>]

[mager1794]

thats a bad query then it means that theres are either more or less fields than you have placed in that query

[kreegoth]

I think we have a missunderstanding here, my bad.

Those two items need to be equiped on an undead male npc (like the npc's in Undercity) not on my character.

Theres a program you can download under programs here called the ascent Database editor.. ( i DID not create this program and take no credit for it) you can enter your Database and select ID of the NPC you want to have weilding those items.. When you select the ID it will show at the bottom in the tabs there display id RIGHT HAND LEFT HAND.. so you can put whatever items you want in the characters hands...

Hope this helps.

[kreegoth]

Also to answer my own question earlier.. i found out how to make it so anyone can enter any zone so no raid or group requirements.. You need to use Navcat and go to the table saying worldmap_info.. IN the column that says Type i edited all of mine to 4 meaning they would have to have a group to enter.. Im not sure what the other values are but im thinking 0 means its locked.. Cause the unused zones are 0 on mine. Anyways just though if anyone else was looking for this info i would post it here.....

Now my question.. WHy when i add an item to a vendor and then go to buy it does it always say i cant carry any more of that item even when its a item that stacks or its something i dont have any of.....


ANy help is appreciated.

[dukenyrl]

thats a bad query then it means that theres are either more or less fields than you have placed in that query

Any help with fixing this would be greatly appreciated. I've completely blasted my old wold db and logon db then went to chrispee's... same problem.

Thanks,
Dukenyrl

[meoxdidi]

i need to make myself a GM with navicat on my private server i know i go to accounts do the az thing but theres no account table theres no table at all navicat is newly downloaded and theres nuthing saved all i did was make a connection called WoW

[SectorSeven]

You need to get yourself a database. First, follow my guide called: How to Install NCDB (search for it/go to my profile and look). Second, go into ArcEmu's SVN address and download the character and logon tables from the sql folder and run the updates in the updates folder.