cant install additional telports

Go down

cant install additional telports

Post by brh11 on Thu Apr 05, 2012 2:33 pm

hi gusy i can in stll additional teleporters i have this error /* SQL Error (1265): Data truncated for column 'target_z' at row 1 */
/* Affected rows: 109 Found rows: 0 Warnings: 0 Duration for 9 of 13 queries: 0.015 sec. */
/*
Portal Master Option
By Rochet2
Downloaded from
Bugs and contact with E-mail:
*/

SET
@BIG := (SELECT id FROM gossip_menu_option WHERE menu_id='50000' ORDER BY id DESC LIMIT 1),
@SMALL := (SELECT id FROM gossip_menu_option WHERE menu_id='50000' ORDER BY id ASC LIMIT 1),
@START := 1 + 1;
UPDATE gossip_menu_option
SET id = @BIG + id + @START
WHERE menu_id='50000';
UPDATE gossip_menu_option
SET id = id - @BIG - 1
WHERE menu_id='50000';
UPDATE conditions
SET SourceEntry = @BIG + SourceEntry + @START
WHERE SourceTypeOrReferenceId = 15 and SourceGroup = '50000';
UPDATE conditions
SET SourceEntry = SourceEntry - @BIG - 1
WHERE SourceTypeOrReferenceId = 15 and SourceGroup = '50000';
UPDATE smart_scripts
SET event_param2 = @BIG + event_param2 + @START
WHERE entryorguid='190000' AND event_param1 = '50000';
UPDATE smart_scripts
SET event_param2 = event_param2 - @BIG - 1
WHERE entryorguid='190000' AND event_param1 = '50000';
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, box_money, box_text) VALUES
('50000', @SMALL, '2', 'New teleport', 1, 1, '50000', '0', 'Are you sure?');
SET @SID := (SELECT id FROM smart_scripts WHERE entryorguid = '190000' ORDER BY id DESC LIMIT 1)+1;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
('190000', 0, IFNULL(@SID, 1), 0, 62, 0, 100, 0, '50000', @SMALL, 0, 0, 62, '1', 0, 0, 0, 0, 0, 0, 8, 0, 0, '-1562.247925', '3093.251465', '50.302879 ', '3.094126', 'Teleporter script - Custom');
/* SQL Error (1265): Data truncated for column 'target_z' at row 1 */

cant post on pastebin

please help thannks

brh11

Viestien lukumäärä : 1
Join date : 2012-04-05

Back to top Go down

Re: cant install additional telports

Post by Rochet2 on Thu Apr 05, 2012 9:29 pm

You had a space in the Z coordinate.
Example: '234.23434 ' should be '234.23434'

Ill try to remember this the next time I fix/modify the creators so I can make spaces at the start or end not matter.

For now, just dont use spaces in the coordinates please.
(or any other numeric field)
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum