| sorvani |
06-23-2011 11:03 PM |
BiC quest_global changes
There was a major change to the BiC quest_globals. Anyone who keeps their quests updated with the SVN and has people running through this quest will need to update the quest_globals of their players.
This script will do that for you. http://pastebin.com/jhWsubYp
Code:
-- insert a new quest_global based on the existing bic global.
-- bic >=2 means they are on the qinimi stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_qin',
CASE qg.value
WHEN '2' THEN '2'
WHEN '3' THEN '3'
ELSE '4'
END AS 'value'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 2;
-- bic >=5 means they are on the barindu stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_bar',
CASE qg.value
WHEN '5' THEN '5'
ELSE '6'
END AS 'value'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 5;
-- bic >=7 means they are on the riwwi stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_riw',
CASE qg.value
WHEN '7' THEN '7'
WHEN '8' THEN '8'
WHEN '9' THEN '9'
ELSE '10'
END AS 'value'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 7;
-- bic >=11 means they are on the ferubi stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_fer','11'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 11;
-- bic >12 means they are on the sewers stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_sew','12'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 12;
-- bic >=13 means they are on the sewers stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_vxe','13'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 13;
-- bic >=14 means they are on the sewers stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_tip','14'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 14;
-- biv >=15 means they are on the yxtta stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_yxt',
CASE qg.value
WHEN '15' THEN '15'
ELSE '16'
END AS 'value'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 15;
-- bic >=17 means they are on the kodtaz stuff
INSERT INTO quest_globals (charid,npcid,zoneid,name,value)
SELECT charid,npcid,zoneid,'bic_kod','17'
FROM quest_globals AS qg
WHERE qg.name = 'bic' AND CAST(qg.value AS UNSIGNED) >= 17;
|