help with newbie gift

12/26/2012 07:06 yosif#1
hello guys

when i trying to add newbie gift this error out for me when i add sql

Full50ElementsTopEquipment


[Err] 1062 - Duplicate entry '70000524' for key 1
[Err] INSERT INTO `cq_action` VALUES ('70000524', '70000525', '70000539', '1001', '0', 'profession == 10');
[Msg] Finished - Unsuccessfully

and this guide what i do

Newbie Gift guide:

delete from `cq_itemtype` where id = '724021';
UPDATE `cq_itemtype` SET `id`='724021' WHERE (`id`='729012');

ItemMinIcon.ANI and MapItemIcon.ANI

[Item729012]
FrameAmount=1
Frame0=data/ItemMinIcon/724000.dds ==> change to 729000.dds

Replace with ItemtypeEditor id 724021 with a non existing one
Replace with ItemtypeEditor id 729012 with 724021

any idea ??
12/26/2012 10:12 magewarior2#2
simple, as it says



Duplicate entry '70000524'

so you already have a row '70000524'
12/27/2012 07:05 yosif#3
ok how i add the newbiegift for all player
12/27/2012 09:51 georgeion92#4
delete the row that is duplicate or change id for new action you want to add!
12/27/2012 11:20 yosif#5
just i delete it and dont doing any thing ??

and i for all player get newbiegift ??
12/27/2012 12:53 Kalrasha#6
most of the time the person or people who built the server files has added the newbie gifts.

if your getting Duplicate entry '70000524' the code 70000524 is already being used maybe for the gift already or for another item.

The gift may be under a different code altogether.
12/27/2012 13:31 yosif#7
look my friend this code i fined it mybe some thing wrong ?

70000524 70000525 70000539 1001 0 profession == 10
70000525 70000526 0 502 1021083
70000539 70000540 70000547 1001 0 profession == 20

or mybe need to learn how to make quest to get newbiegift
12/28/2012 02:28 magewarior2#8
show the full action, from 3 rows we see nothing