PDA

View Full Version : Need a fqadmin set up guide


vince
03-28-2004, 07:01 PM
i have a server up took about 20 min to read and do .
now i want to populate the server fast and have no freaking idea how to set up the fqadmin that everyone says to use .
the screen reads like this if anyone can help fill in the blanks would help alot .

{general}
dbname=(i put my db name)
dbhost=(i put my internal ip or my router ip ??)
dbusername=(no clue i assumed it was name i used for account or same as dbname??)
eqpath=( i put where i had my eqemu folder, c:/eqemu)
mappath=(i put where i had my eqemu folder, c:/eqemu/maps)
{import}
keepoint=0 (no clue what this is)
importtables=33 (no clue again..)
table1=name(no clue again.. and so on so forth for all rest of it )
NUMERICIDFIELD1=id
NAMEFIELDS1=1
NAMEFIELD1_1=name
FOREIGNKEYS1=0
TABLE2=character_
NUMERICIDFIELD2=id
NAMEFIELDS2=1
NAMEFIELD2_1=name
FOREIGNKEYS2=1
FKFIELD2_1=account_id
FKTABLE2_1=account
TABLE3=items
NUMERICIDFIELD3=id
NAMEFIELDS3=1
NAMEFIELD3_1=id
FOREIGNKEYS3=0
TABLE4=npc_types
NUMERICIDFIELD4=id
NAMEFIELDS4=2
NAMEFIELD4_1=name
NAMEFIELD4_2=level
FOREIGNKEYS4=0
TABLE5=variables
NUMERICIDFIELD5=
NAMEFIELDS5=1
NAMEFIELD5_1=varname
FOREIGNKEYS5=0
TABLE6=zone
NUMERICIDFIELD6=
NAMEFIELDS6=1
NAMEFIELD6_1=short_name
FOREIGNKEYS6=0
TABLE7=zone_points
NUMERICIDFIELD7=id
NAMEFIELDS7=4
NAMEFIELD7_1=zone
NAMEFIELD7_2=x
NAMEFIELD7_3=y
NAMEFIELD7_4=z
FOREIGNKEYS7=0
TABLE8=zone_server
NUMERICIDFIELD8=
NAMEFIELDS8=1
NAMEFIELD8_1=name
FOREIGNKEYS8=0
TABLE9=guilds
NUMERICIDFIELD9=id
NAMEFIELDS9=1
NAMEFIELD9_1=name
FOREIGNKEYS9=0
TABLE10=zoneserver_auth
NUMERICIDFIELD10=
NAMEFIELDS10=1
NAMEFIELD10_1=host
FOREIGNKEYS10=0
TABLE11=spawngroup
NUMERICIDFIELD11=id
NAMEFIELDS11=1
NAMEFIELD11_1=name
FOREIGNKEYS11=0
TABLE12=spawn2
NUMERICIDFIELD12=id
NAMEFIELDS12=4
NAMEFIELD12_1=x
NAMEFIELD12_2=y
NAMEFIELD12_3=z
NAMEFIELD12_4=zone
FOREIGNKEYS12=1
FKFIELD12_1=spawngroupID
FKTABLE12_1=spawngroup
TABLE13=spawnentry
NUMERICIDFIELD13=
NAMEFIELDS13=2
NAMEFIELD13_1=spawngroupID
NAMEFIELD13_2=npcID
FOREIGNKEYS13=2
FKFIELD13_1=spawngroupID
FKTABLE13_1=spawngroup
FKFIELD13_2=npcID
FKTABLE13_2=npc_types
TABLE14=faction_list
NUMERICIDFIELD14=id
NAMEFIELDS14=1
NAMEFIELD14_1=name
FOREIGNKEYS14=0
TABLE15=faction_values
NUMERICIDFIELD15=
NAMEFIELDS15=2
NAMEFIELD15_1=char_id
NAMEFIELD15_2=faction_id
FOREIGNKEYS15=2
FKFIELD15_1=char_id
FKTABLE15_1=character_
FKFIELD15_2=faction_id
FKTABLE15_2=faction_list
TABLE16=npc_faction
NUMERICIDFIELD16=
NAMEFIELDS16=2
NAMEFIELD16_1=npc_id
NAMEFIELD16_2=faction_id
FOREIGNKEYS16=2
FKFIELD16_1=npc_id
FKTABLE16_1=npc_types
FKFIELD16_2=faction_id
FKTABLE16_2=faction_list
TABLE17=lootdrop
NUMERICIDFIELD17=id
NAMEFIELDS17=1
NAMEFIELD17_1=name
FOREIGNKEYS17=0
TABLE18=lootdrop_entries
NUMERICIDFIELD18=
NAMEFIELDS18=2
NAMEFIELD18_1=lootdrop_id
NAMEFIELD18_2=item_id
FOREIGNKEYS18=2
FKFIELD18_1=lootdrop_id
FKTABLE18_1=lootdrop
FKFIELD18_2=item_id
FKTABLE18_2=items
TABLE19=loottable
NUMERICIDFIELD19=id
NAMEFIELDS19=1
NAMEFIELD19_1=name
FOREIGNKEYS19=0
TABLE20=loottable_entries
NUMERICIDFIELD20=
NAMEFIELDS20=2
NAMEFIELD20_1=loottable_id
NAMEFIELD20_2=lootdrop_id
FOREIGNKEYS20=2
FKFIELD20_1=loottable_id
FKTABLE20_1=loottable
FKFIELD20_2=lootdrop_id
FKTABLE20_2=lootdrop
TABLE21=name_filter
NUMERICIDFIELD21=
NAMEFIELDS21=1
NAMEFIELD21_1=name
FOREIGNKEYS21=0
TABLE22=quest
NUMERICIDFIELD22=id
NAMEFIELDS22=3
NAMEFIELD22_1=zone
NAMEFIELD22_2=name
NAMEFIELD22_3=activator
FOREIGNKEYS22=3
FKFIELD22_1=npcID
FKTABLE22_1=npc_types
FKFIELD22_2=questobject
FKTABLE22_2=items
FKFIELD22_3=priceobject
FKTABLE22_3=items
TABLE23=merchantlist
NUMERICIDFIELD23=merchantid
NAMEFIELDS23=2
NAMEFIELD23_1=merchantid
NAMEFIELD23_2=slot
FOREIGNKEYS23=1
FKFIELD23_1=item
FKTABLE23_1=items
TABLE24=player_corpses
NUMERICIDFIELD24=id
NAMEFIELDS24=0
FOREIGNKEYS24=1
FKFIELD24_1=charid
FKTABLE24_1=character_
TABLE25=zone_state_dump
NUMERICIDFIELD25=
NAMEFIELDS25=1
NAMEFIELD25_1=zonename
FOREIGNKEYS25=0
TABLE26=books
NUMERICIDFIELD26=
NAMEFIELDS26=1
NAMEFIELD26_1=name
FOREIGNKEYS26=0
TABLE27=doors
NUMERICIDFIELD27=id
NAMEFIELDS27=2
NAMEFIELD27_1=doorid
NAMEFIELD27_2=zone
FOREIGNKEYS27=1
FKFIELD27_1=guild
FKTABLE27_1=guilds
TABLE28=petitions
NUMERICIDFIELD28=petid
NAMEFIELDS28=2
NAMEFIELD28_1=charname
NAMEFIELD28_2=petitiontext
FOREIGNKEYS28=0
TABLE29=starting_items
NUMERICIDFIELD29=id
NAMEFIELDS29=3
NAMEFIELD29_1=race
NAMEFIELD29_2=class
NAMEFIELD29_3=itemid
FOREIGNKEYS29=1
FKFIELD29_1=itemid
FKTABLE29_1=items
TABLE30=tradeskillrecipe
NUMERICIDFIELD30=id
NAMEFIELDS30=2
NAMEFIELD30_1=tradeskill
NAMEFIELD30_2=product
FOREIGNKEYS30=11
FKFIELD30_1=product
FKTABLE30_1=items
FKFIELD30_2=i1
FKTABLE30_2=items
FKFIELD30_3=i2
FKTABLE30_3=items
FKFIELD30_4=i3
FKTABLE30_4=items
FKFIELD30_5=i4
FKTABLE30_5=items
FKFIELD30_6=i5
FKTABLE30_6=items
FKFIELD30_7=i6
FKTABLE30_7=items
FKFIELD30_8=i7
FKTABLE30_8=items
FKFIELD30_9=i8
FKTABLE30_9=items
FKFIELD30_10=i9
FKTABLE30_10=items
FKFIELD30_11=i10
FKTABLE30_11=items
TABLE31=zonepoints_raw
NUMERICIDFIELD31=id
NAMEFIELDS31=2
NAMEFIELD31_1=zone
NAMEFIELD31_2=zoneline
FOREIGNKEYS31=0
TABLE32=altadv_vars
NUMERICIDFIELD32=skill_id
NAMEFIELDS32=1
NAMEFIELD32_1=name
FOREIGNKEYS32=0
TABLE33=hackers
NUMERICIDFIELD33=id
NAMEFIELDS33=0
FOREIGNKEYS33=0



so basically im wondering what im supposed to put into the slots after the general info ..

boppoom1
03-29-2004, 03:25 AM
{general}
dbname=(i put my db name)
dbhost=(i put my internal ip or my router ip ??)
dbusername=(no clue i assumed it was name i used for account or same as dbname??)
eqpath=( i put where i had my eqemu folder, c:/eqemu)
mappath=(i put where i had my eqemu folder, c:/eqemu/maps)
{import}


All you need yto change is under the DB name put your database name....DBhost put the IP of where the DB is located.....dbusername username of the sql server....eqpath ur eq directory.......mappath ur path to the eq directory and maps

dont change anything else thats all you need