BiC quest_global changes

[sorvani]

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

-- 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;

[revloc02c]

What is the BiC quest please?

[joligario]

Breakdown in Communication