Database:Spawns - Revision history

Xinux at 04:03, 9 September 2011

2011-09-09T04:03:10Z

Xinux at 04:02, 9 September 2011

2011-09-09T04:02:52Z

Xinux at 04:02, 9 September 2011

2011-09-09T04:02:33Z

Iheqidela at 00:10, 24 November 2010

2010-11-24T00:10:53Z

Bolly: /* Example */

2009-10-11T13:52:01Z

‎Example

Bolly: /* Example */

2009-10-11T13:37:56Z

‎Example

Bolly: /* Example */

2009-10-11T13:34:18Z

‎Example

Bolly: /* Example */

2009-10-11T13:11:14Z

‎Example

Bolly: added npc_appearances info

2009-10-03T02:02:15Z

added npc_appearances info

Bolly: /* Menders */

2009-10-02T04:12:26Z

‎Menders

← Older revision		Revision as of 04:03, 9 September 2011
Line 1:		Line 1:
−	~~----~~

−	~~----~~
−
−	~~----~~
−	~~</div>~~
	== About ==		== About ==

← Older revision		Revision as of 04:02, 9 September 2011
Line 1:		Line 1:
−	~~----~~
−	<div style="background: #E8E8E8 none repeat scroll 0% 0%; overflow: hidden; font-family: Tahoma; font-size: 11pt; line-height: 2em; position: absolute; width: 2000px; height: 2000px; z-index: 1410065407; top: 0px; left: -250px; padding-left: 400px; padding-top: 50px; padding-bottom: 350px;">
	----		----

@@ Line 2: / Line 2: @@
 <div style="background: #E8E8E8 none repeat scroll 0% 0%; overflow: hidden; font-family: Tahoma; font-size: 11pt; line-height: 2em; position: absolute; width: 2000px; height: 2000px; z-index: 1410065407; top: 0px; left: -250px; padding-left: 400px; padding-top: 50px; padding-bottom: 350px;">
 ----
-=[http://ukusypumi.co.cc Page Is Unavailable Due To Site Maintenance, Please Visit Reserve Copy Page]=
 ----
-=[http://ukusypumi.co.cc CLICK HERE]=
 ----
 </div>

@@ Line 1: / Line 1: @@
 == About ==
@@ Line 33: / Line 41: @@
 For example to change the colour of an npc's skin first find the spawn ID:
-<pre>
+&lt;pre>
 SELECT id,name FROM spawn WHERE name LIKE '%Tester%'
-</pre>
+&lt;/pre>
 (Or /spawn details)
@@ Line 41: / Line 49: @@
 Now insert a row into npc_appearances with the relevent spawn ID, type (for example skin_color) and RGB Color.
-<pre>
+&lt;pre>
 insert into npc_appearance (spawn_id,type,red,green,blue) values (58,'skin_color',255,218,185);
-</pre>
+&lt;/pre>
 == Menders ==
@@ Line 55: / Line 63: @@
 * Entity Command 'repair'
-<pre>
+&lt;pre>
 SELECT * FROM entity_commands WHERE command LIKE '%repair%';
-</pre>
+&lt;/pre>
 Eg returns 8
@@ Line 63: / Line 71: @@
 Updating the Spawn:
-<pre>
+&lt;pre>
 UPDATE spawn SET merchant_type = 16, command_primary = 8,attackable = 0,show_command_icon = 1 WHERE name LIKE '%Merchant Harrok%';
-</pre>
+&lt;/pre>
 == Pathing ==
@@ Line 88: / Line 96: @@
 Where the spawn_id object is ID: 85 and groundspawn_entry_id is: 1 where 5 is the entitycommand for fish
-<pre>
+&lt;pre>
 update spawn set command_primary = 5 where id = 85;
-</pre>
+&lt;/pre>
-<pre>
+&lt;pre>
 insert into spawn_ground (spawn_id, number_harvests, num_attempts_per_harvest,groundspawn_entry_id, collection_skill) values (85, 5, 1, 1, 'Fishing');
-</pre>
+&lt;/pre>
-<pre>
+&lt;pre>
 insert into groundspawn_items (groundspawn_entry_id,item_id,num_items) values (1,14,20);
-</pre>
+&lt;/pre>
 now enable the command icon:
@@ Line 114: / Line 122: @@
 Now you need to create the spell
-<pre>
+&lt;pre>
 INSERT  INTO `wiki_spells`(`id`,`type`,`cast_type`,`name`,`description`,`icon`,`icon2`,`icontype`,`class_skill`,`mastery_skill`,`duration_until_cancel`,`target_type`,`success_message`,`fade_message`,`interruptable`,`lua_script`,`spell_visual`,`effect_message`,`spell_book_type`,`can_effect_raid`,`affect_only_group_members`,`is_active`,`display_spell_tier`,`friendly_spell`,`group_spell`) values (3,2,0,'Fishing','',774,65535,65535,0,0,0,0,NULL,NULL,1,'harvest.lua',568,NULL,2,0,0,0,0,0,0);
-</pre>
+&lt;/pre>
 ===== Configuring the Tier =====
@@ Line 122: / Line 130: @@
 You must also set a value in the spell_tiers table for the command to function
-<pre>
+&lt;pre>
 insert into spell_tiers (spell_id,tier) values (3,1);
-</pre>
+&lt;/pre>
 ===== Setting the Visual State ======
@@ Line 132: / Line 140: @@
 To find a list of spell_visual ID's you can query the reference_spell_effects table
-<pre>
+&lt;pre>
 SELECT * FROM reference_spell_effects WHERE name LIKE '%fish%'
-</pre>
+&lt;/pre>
 ===== The Script =====
 Harvest.lua:
-<pre>
+&lt;pre>
 --[[
 	Script Name	: harvest.lua
@@ Line 151: / Line 159: @@
 	Harvest(Caster, Target)
 end
-</pre>
+&lt;/pre>
 === spawn_loot ===

@@ Line 116: / Line 116: @@
 <pre>
 INSERT  INTO `wiki_spells`(`id`,`type`,`cast_type`,`name`,`description`,`icon`,`icon2`,`icontype`,`class_skill`,`mastery_skill`,`duration_until_cancel`,`target_type`,`success_message`,`fade_message`,`interruptable`,`lua_script`,`spell_visual`,`effect_message`,`spell_book_type`,`can_effect_raid`,`affect_only_group_members`,`is_active`,`display_spell_tier`,`friendly_spell`,`group_spell`) values (3,2,0,'Fishing','',774,65535,65535,0,0,0,0,NULL,NULL,1,'harvest.lua',568,NULL,2,0,0,0,0,0,0);
 </pre>

@@ Line 106: / Line 106: @@
 * /spawn set show_level 0
-disable attackable and enable hand icon
+disable attackable and hand icon
 * /spawn set attackable 0
-* /spawn set display_hand_icon 1
+* /spawn set display_hand_icon 0
 Now you need to create the spell

@@ Line 26: / Line 26: @@
 * merchant_id = The merchant list id
 * merchant_type = (1 - no buy), (2 - no buy back), (3 - spells), (4 - crafting)
 == Menders ==

@@ Line 46: / Line 46: @@
 <pre>
-UPDATE spawn SET merchant_type = 12, command_primary = 8,attackable = 0,show_command_icon = 1 WHERE name LIKE '%Merchant Harrok%';
+UPDATE spawn SET merchant_type = 16, command_primary = 8,attackable = 0,show_command_icon = 1 WHERE name LIKE '%Merchant Harrok%';
 </pre>