Database - Revision history

Whasf at 03:03, 19 February 2016

2016-02-19T03:03:27Z

Whasf: /* Accounts */

2016-02-19T03:01:18Z

‎Accounts

Lautan: /* Modifying Drop Lists */

2013-07-31T15:22:53Z

‎Modifying Drop Lists

Lautan: Modifying droplists

2013-07-31T15:22:36Z

Modifying droplists

PrBlahBlahtson at 00:10, 2 June 2013

2013-06-02T00:10:06Z

PrBlah at 03:35, 4 February 2013

2013-02-04T03:35:36Z

PrBlah at 20:11, 2 February 2013

2013-02-02T20:11:21Z

PrBlah at 19:24, 2 February 2013

2013-02-02T19:24:52Z

PrBlah: Created page with "A break down of the database tables and what the fields mean. == Player Related == '''These tables directly affect characters and player accounts''' ===Accounts=== Inc..."

2013-02-02T19:24:13Z

Created page with "A break down of the database tables and what the fields mean. == Player Related == '''These tables directly affect characters and player accounts''' ===Accounts=== Inc..."

New page

A break down of the database tables and what the fields mean.

== Player Related ==

'''These tables directly affect characters and player accounts'''

===[[Accounts]]===

Includes "accounts," "accounts_banned," and "accounts_sessions."

===[[Characters]]===

Includes "chars," "char_effects," "char_equip," "char_exp," "char_look," "char_points," "char_profile," "char_skills," "char_stats," "char_storage," "char_titles," "char_vars," and "char_weapon_skill_points."

===[[Items]]===

Includes "item_armor," "item_basic," "item_furnishing," "item_latents," "item_mods," "item_puppet," "item_usable," "item_weapon," and "item_weapon_unlocked."
Mandatory for all items. This table defines the basic existence of an item.

===[[Actions]]===

Includes "abilities," "blue_spell_list," "blue_spell_mods," "merits," "skill_caps," "skill_ranks," "spell_list," "traits," and "weapon_skills."

===[[Mobs]]===

Includes "mob_spawn_points," "mob_groups," "mob_pools," "mob_droplist," "mob_family_system," "mob_skill," and "nm_spawn_points."

auction_house, bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, delivery_box, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, guild_shops, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skill_ranks, skillchain_damage_modifiers, status_effects, synth_recipes, transport, zone_settings, zone_weather, zonelines

← Older revision		Revision as of 03:03, 19 February 2016
Line 26:		Line 26:

	'''priv:''' ex. 1 - Unknown usage at this time.		'''priv:''' ex. 1 - Unknown usage at this time.
		+
		+	===[[Accounts_banned]]===
		+
		+	accid: The account number that has been banned.
		+
		+	timebann: The time the account was banned.
		+
		+	timeunbann: The time the account will be unbanned.
		+
		+	banncomment: Any comments on the ban, like reason, will be input here.
		+
		+	===[[Accounts_sessions]]===

	===[[Characters]]===		===[[Characters]]===

@@ Line 42: / Line 42: @@
 Find the mob you want to modify from the sql/mob_pools.sql table.
 With the poolid find the mob in sql/mob_groups.sql.
 Get the dropid then find the table in sql/mob_droplist.sql.

← Older revision		Revision as of 15:22, 31 July 2013
Line 38:		Line 38:

	Dumping this here for now. Setting npc_list.status to 2 will make the NPC untargetable.		Dumping this here for now. Setting npc_list.status to 2 will make the NPC untargetable.
		+
		+	=== Modifying Drop Lists ===
		+
		+	Find the mob you want to modify from the sql/mob_pools.sql table.
		+	With the poolid find the mob in sql/mob_groups.sql.
		+	Get the dropid then find the table in sql/mob_droplist.sql.
		+
		+	You can also search for the itemid directly in droplist if its unique enough.
		+
		+	If there is no droplist you can easily create a new one but make sure the dropid is unique.

@@ Line 29: / Line 29: @@
 Includes "auction_house," "delivery_box," "guild_shops," and "synth_recipes."
-bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines
+===[[Fishing]]===
 Temporary:
 Dumping this here for now.  Setting npc_list.status to 2 will make the NPC untargetable.

← Older revision		Revision as of 03:35, 4 February 2013
Line 30:		Line 30:

	bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines		bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines
		+
		+	Temporary:
		+
		+	Dumping this here for now. Setting npc_list.status to 2 will make the NPC untargetable.

@@ Line 7: / Line 7: @@
 ===[[Accounts]]===
-Includes "accounts," "accounts_banned," and "accounts_sessions."
+'''id:''' ex. 1000 - Account number. Starts at 1000 on a new server.
 ===[[Characters]]===

@@ Line 1: / Line 1: @@
 A break down of the database tables and what the fields mean.
 ===[[Accounts]]===
@@ Line 12: / Line 16: @@
 Includes "item_armor," "item_basic," "item_furnishing," "item_latents," "item_mods," "item_puppet," "item_usable," "item_weapon," and "item_weapon_unlocked."
 ===[[Actions]]===
@@ Line 22: / Line 25: @@
 Includes "mob_spawn_points," "mob_groups," "mob_pools," "mob_droplist," "mob_family_system," "mob_skill," and "nm_spawn_points."
-auction_house, bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, delivery_box, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, guild_shops, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skill_ranks, skillchain_damage_modifiers, status_effects, synth_recipes, transport, zone_settings, zone_weather, zonelines
+bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines

← Older revision		Revision as of 19:24, 2 February 2013
Line 1:		Line 1:
	A break down of the database tables and what the fields mean.		A break down of the database tables and what the fields mean.
−
−	~~== Player Related ==~~
−
−	~~'''These tables directly affect characters and player accounts'''~~

	===[[Accounts]]===		===[[Accounts]]===