Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building
Reload this Page complete eqlive-like faction v1.0!

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
Page 2 of 5 1 2 345
 
Thread Tools Display Modes
  #16  
Old 04-22-2004, 03:32 AM
Gossamer
Sarnak
  
Join Date: Apr 2004
Posts: 92
Default
Corban, no. It just puts the faction tables in to your database. You will then either have to start killing to lower/raise factions, or edit your database yourself. As far as guards helping out, I have not seen this working yet either.
Reply With Quote
  #17  
Old 04-22-2004, 03:34 AM
RexChaos
Dragon
  
Join Date: Feb 2004
Location: Everywhere you want to be
Posts: 582
Default
Quote:
Originally Posted by Gossamer
Corban, no. It just puts the faction tables in to your database. You will then either have to start killing to lower/raise factions, or edit your database yourself. As far as guards helping out, I have not seen this working yet either.
To get the guards working you need to adjust racial modifiers for them or put them on an opposing faction to have them attack.
__________________
An obnoxiously large picture should go here with some witty saying about some cartoon character I made in EQ, but then I realized that shit is fucking annoying.
Reply With Quote
  #18  
Old 04-24-2004, 05:38 AM
govtcheeze
Hill Giant
  
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default
File location has changed. New link is:

http://govtcheeze.eqemulator.net/download/faction.rar

- and -

http://govtcheeze.eqemulator.net/dow...action_log.rar

You can always browse to http://govtcheeze.eqemulator.net/download/ for a list of all files I have released.
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #19  
Old 05-08-2004, 04:35 AM
mikenune
Discordant
  
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default
When I source the second file (add_factions.sql), I get the following errors:

Quote:
ERROR 1062: Duplicate entry '39-209' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -27)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 9)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -36)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 12)' at line 1
Has anyone else gotten this? Is there anything I'm doing wrong or is this normal?
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #20  
Old 05-09-2004, 11:32 PM
mikenune
Discordant
  
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default
Well, since nobody's answered, I'm going to assume those errors are normal. . .
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #21  
Old 05-10-2004, 01:04 AM
govtcheeze
Hill Giant
  
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default
I didn't see this post before. The top error is normal, but the rest are not. I have never gotten the errors when sourcing, and I did not hear any reports of people getting those errors either. Since I know the SQL statements are good, I really do not know what the fix would be for you :(
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #22  
Old 05-10-2004, 01:08 AM
mikenune
Discordant
  
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default
Yeah, I was afraid you would say that. . .

The interesting thing is that MySQL is reporting all the errors as happening on line 1. I've looked at the file and, well, the earliest line where I find any of the text reported in the errors is around line 20 or so. . .

I'll try re-downloading and sourcing that copy later today and see if it's still happening.

Although, if it's already included in the new TCSMyWorld release, then I probably won't need it.
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #23  
Old 05-10-2004, 01:40 AM
govtcheeze
Hill Giant
  
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default
Yea it is (with some base factions added by TCS!), guess I should have mentioned that earlier
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #24  
Old 05-10-2004, 06:54 PM
govtcheeze
Hill Giant
  
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default
Updated faction_list is available, making many of the mobs non-beta neutral:

browse to http://govtcheeze.eqemulator.net/download/ and get the newFactionList.rar file.

This includes all faction entries from MW_055_alpha2.

Extract it to mysql\bin and source it. This is how my session looked:

Code:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\theoden>cd c:\mysql\bin

C:\mysql\bin>mysql -f eq<newFactionList.sql

C:\mysql\bin>
Please report any errors or additions to this thread!
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #25  
Old 06-14-2004, 02:49 PM
vrated
Fire Beetle
  
Join Date: May 2004
Posts: 15
Default
Quote:
Originally Posted by mikenune
When I source the second file (add_factions.sql), I get the following errors:

Quote:
ERROR 1062: Duplicate entry '39-209' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -27)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 9)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -36)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 12)' at line 1
Has anyone else gotten this? Is there anything I'm doing wrong or is this normal?
I have this exact problem also. I am using MySql 4.0.18 (Linux).
Reply With Quote
  #26  
Old 06-16-2004, 12:13 PM
phasepuma
Sarnak
  
Join Date: Jun 2004
Posts: 69
Default
I got no errors : /
Reply With Quote
  #27  
Old 06-16-2004, 02:05 PM
stclairguy
Fire Beetle
  
Join Date: Mar 2004
Posts: 28
Default Error
Quote:
ERROR 1064 at line 73918: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73919: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73920: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73921: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73922: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73923: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73924: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73925: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73926: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73927: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73928: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73929: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73930: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73931: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73932: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73933: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73934: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73935: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73936: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73937: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73938: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73939: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73940: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73941: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73942: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73943: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73944: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73945: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73946: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73947: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73948: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73949: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73950: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73951: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73952: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73953: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73954: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73955: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73956: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73957: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73958: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73959: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73960: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73961: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73962: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73963: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73964: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73965: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73966: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73967: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73968: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73969: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73970: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73971: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73972: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73973: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73974: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73975: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73976: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73977: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73978: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73979: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73980: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73981: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73982: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73983: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73984: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73985: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73986: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73987: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73988: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73989: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73990: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73991: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73992: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73993: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73994: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73995: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73996: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73997: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73998: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73999: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74000: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74001: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74002: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74003: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74004: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74005: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74006: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74007: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74008: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74009: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74010: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74011: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74012: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74013: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74014: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74015: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74016: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1


C:\mysql\bin>

I keep getting this error whenever i try and source new_faction_update.sql. Any ideas and fixes? (Btw, i also get this error with the npc_types_update.sql too)
Reply With Quote
  #28  
Old 08-13-2004, 11:52 PM
Darkwaters
Hill Giant
  
Join Date: Aug 2004
Location: Michigan
Posts: 118
Default yeah i know what your error is about
I've been following the instructions from
http://www.eqemulator.net/forums/vie...2a595ede8c0d4c
hope this helps.
You need to source in the following order
source (db.sql or MW_057DR2_alpha_1.sql depending on which db you decided to use)
source newdumpeditems.sql;
RENAME TABLE items TO items_;
RENAME TABLE items_new TO items;
source itemtablechanges.sql; <----- (in the source folder of the 7/31/2004 source)
source loot_update.sql;
source npc_types_update.sql;
source factionsList.sql;
source add_factions.sql;
source npc_faction_update.sql;
source newFactionList.sql;

If you do not source itemtablechanges.sql prior to loot_update.sql and all that follows in the instructions your gonna be hosed no matter what you do.
Darkwaters
Soulfood_Takeout
Reply With Quote
  #29  
Old 09-16-2004, 06:48 AM
govtcheeze
Hill Giant
  
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default
version 1.0 released...thread is stickied, but want it to become active so people realize this
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
  #30  
Old 09-17-2004, 03:07 AM
cavedude's Avatar
cavedude
The PEQ Dude
  
Join Date: Apr 2003
Location: -
Posts: 1,988
Default
animal_not_KOS gets sourced in as ID 100001 That means you need set MMF_MAX_NPCFactionList_ID to 100001 or higher in NPCFactionLists.h and re-compile. Its set at 50000 by default. You might want to lower the ID before people start wondering why Zone is crying.
Reply With Quote
Reply
Page 2 of 5 1 2 345

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 10:25 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3