SolarPower19
02-19-2006, 06:49 AM
Hey everyone..new here, but a friend of branks (the guy that revamped all those aa's) and we've kind of gotten re-interested in making a pretty highly customized server. He's working with the code 6.0-DR3 (I don't know C from Yiddish), and I've been working on the DB..mobs, grids, spells, etc. For the server we're building, we've totally deleted the following tables using MySQL:
npc_types
npc_factions
npc_faction_entries
faction_list
+ others but those are not important for this question (I think).
So we want 2 opposing (fighting) factions in one zone, and I can't get the advice in either of these threads to work properly.
http://www.eqemulator.net/forums/showthread.php?t=17076
http://www.eqemulator.net/forums/showthread.php?t=15894
So far in the npc_types table, i have all mobs on npc_faction_id 1 or 2, social set to 1 (want them to assist each other), and npc_aggro set to 1.
in the faction lists table (format is id / name / base /) I have
1 / Blue Team / 1000 and
2 / Red Team / -1000 (so players con warmly to blue and KOS to red)
not using the other entries in this table as they're for setting race/class/diety modifiers, which I don't need.
On to the npc_faction table - format is id / name[MEMO] / primary faction -here I have:
1 / Blue_Team / 1
2 / Red_Team / 2
I don't really get why the old db had different values for faction and primary faction, so I tried changing the primary faction codes to 4 digit numbers (1001, 2001) -it didn't seem to change/help anything
ok, the npc_faction_entries table -I think this where I'm messing up. Format is npc_faction_id / faction_id / value / npc_value - and here is what I put in
1 / 1 / 0 / 1
1 / 2 / 0 / -1
2 / 2 / 0 / 1
2 / 1 / 0 / -1
as I understand it, the "value" column only affects how much of a faction hit players get by killing either sides mobs. and the npc_value column is (1=assist /0=nuetral/ -1=aggro). This is obviously way wrong, as when i log in the mobs are "aggro" at each other, but don't attack..and my cleric mobs heal/buff the wrong team. The mobs will try to nuke the opposing team but have no effect, and warrior/rogue mobs will kick and backstab for damage, but can't seem to perform regular attacks against each other. Any help would be greatly appreciated. And remember, I'm a total newb to all of this. . . so, baby steps =).
npc_types
npc_factions
npc_faction_entries
faction_list
+ others but those are not important for this question (I think).
So we want 2 opposing (fighting) factions in one zone, and I can't get the advice in either of these threads to work properly.
http://www.eqemulator.net/forums/showthread.php?t=17076
http://www.eqemulator.net/forums/showthread.php?t=15894
So far in the npc_types table, i have all mobs on npc_faction_id 1 or 2, social set to 1 (want them to assist each other), and npc_aggro set to 1.
in the faction lists table (format is id / name / base /) I have
1 / Blue Team / 1000 and
2 / Red Team / -1000 (so players con warmly to blue and KOS to red)
not using the other entries in this table as they're for setting race/class/diety modifiers, which I don't need.
On to the npc_faction table - format is id / name[MEMO] / primary faction -here I have:
1 / Blue_Team / 1
2 / Red_Team / 2
I don't really get why the old db had different values for faction and primary faction, so I tried changing the primary faction codes to 4 digit numbers (1001, 2001) -it didn't seem to change/help anything
ok, the npc_faction_entries table -I think this where I'm messing up. Format is npc_faction_id / faction_id / value / npc_value - and here is what I put in
1 / 1 / 0 / 1
1 / 2 / 0 / -1
2 / 2 / 0 / 1
2 / 1 / 0 / -1
as I understand it, the "value" column only affects how much of a faction hit players get by killing either sides mobs. and the npc_value column is (1=assist /0=nuetral/ -1=aggro). This is obviously way wrong, as when i log in the mobs are "aggro" at each other, but don't attack..and my cleric mobs heal/buff the wrong team. The mobs will try to nuke the opposing team but have no effect, and warrior/rogue mobs will kick and backstab for damage, but can't seem to perform regular attacks against each other. Any help would be greatly appreciated. And remember, I'm a total newb to all of this. . . so, baby steps =).