PDA

View Full Version : Characters All *GM* Issue

Warking
06-22-2013, 05:37 AM
Hello,

I am seeing that everytime I log into an account either old or new the character has *GM* next to their name if I do a / <enter>

In addition, everything is indifferent!

I even tried setting the accout status down but it still show up.

What I want is the characters to be able to #zone and still have the correct faction responses from mobs.

Does it have anything to do with the IP address im logging into the server on?
Kingly_Krab
06-22-2013, 05:40 AM
Open your eqemu_config.xml in your server folder and set the default status to 0 and demote all players.
XML Below, code for demoting everyone below the XML.
<?xml version="1.0">
<server>

<world>

<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>XXXXXXXXXXXXX</shortname>
<longname>XXXXXXXXXXXXXXX</longname>



<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<!-- <address>do.not.edit</address> -->
<!-- <localaddress>do.not.edit</localaddress> -->



<!-- Loginserver information. DO NOT EDIT -->
<loginserver>

<host>eqemulator.net</host>
<port>5998</port>
<account>XXXXXXXX</account>
<password>XXXXXXXXXXXXX</password>

</loginserver>


<!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
<!--<locked/>-->
<!-- <unlocked/> -->



<!-- Sets the ip/port for the tcp connections. DO NOT EDIT -->
<tcp ip="127.0.0.1" port="9000" telnet="disable"/>



<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>somelongrandomstring12345</key>

<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />

</world>

<!-- Chatserver (channels) information. DO NOT EDIT -->
<chatserver>

<host>192.168.1.x</host>
<port>7778</port>

</chatserver>

<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>

<host>192.168.1.x</host>
<port>7778</port>

</mailserver>

<zones>

<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>0</defaultstatus>



<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->
<ports low="7000" high="7100"/>

</zones>

<!-- Set username to root and password is your MySQL password and db to peq -->
<database>

<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>XXXXXX</password>
<db>XXXXXX</db>

</database>
<qsdatabase>

<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>XXXXXX</password>
<db>XXXXXXX</db>

</qsdatabase>

<!-- Launcher Configuration DO NOT EDIT-->
<launcher>

<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->

</launcher>

<!-- File locations. DO NOT EDIT -->
<files>

<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->

</files>
<!-- Directory locations. DO NOT EDIT -->
<directories>

<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->

</directories></server>


UPDATE account SET status = 0 WHERE status = 20;
Warking
06-22-2013, 06:12 AM
I did this and restarted the server. At status = 0 the *gm* is no longer there but everything is still indifferent.
Kingly_Krab
06-22-2013, 06:18 AM
Indifferent has nothing to do with GM flags. You must modify the npc's faction id within the npc_types table. A good faction is 79, which makes them Kill on Sight.
Warking
06-22-2013, 06:20 AM
Could Karma in account table influence it?
Warking
06-22-2013, 06:22 AM
It's funny having a level 1 walk up to lord nagafen... or undead walking in qeynos.... Thanks, I'll check faction id too...
Warking
06-22-2013, 10:09 PM
Everything in the game is still indifferent to any level class. GM or no GM account still.

I tried changing faction ID's to 79, 366, 19472 and nothing.

I didn't have this issue before db2294.

Now I have a ton of changes under this DB that I really can't rebuild either.


When I open db_version table under navicat it says db_version does not have a primary key

I have been going around to each zone and faction IDs exist on all the mobs, all the loot is there and everythign is working fine except for faction...

Starting to get a little frustrated... Any suggestions?
Warking
06-22-2013, 10:14 PM
Is there anyway to backup just the zones and NPCs that I edited and do a full DB restore or update?

Is there a command I can run to verify that all DB's are the same version?
Warking
06-22-2013, 11:29 PM
I exported and copied the tables I updated and will try a restore from an earlier backup first I am thinking. I know Classic through PoP was working fine.

I read rumors that changing an npc might mess up the faction for the whole server. Is this a known bug with this DB?

Worse case I might go back to 2214... But I do think 2294 is more stable...
Warking
06-23-2013, 02:54 AM
Ok... So I had to revert back to EQ DB version 2099 in order to fix the faction issue.

I replaced the backup 2099 version for tables: account, npc, loot, quest, etc... information with my newer tables from 2294 and it worked fine.

First I restored a fresh 2294 and I still had issues. There must be some weird faction bug with 2294 if you have custom changes.