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 ..
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 ..