public static function deleteOverlay($pack)
{
$overlay = dbconnection::queryObject("SELECT * FROM overlays WHERE overlay_id = '{$pack->overlay_id}'");
$pack->auth->game_id = $overlay->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM overlays WHERE overlay_id = '{$pack->overlay_id}' LIMIT 1");
//cleanup
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$overlay->requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::deleteRequirementPackage($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
public static function deleteWebHook($pack)
{
$webhook = dbconnection::queryObject("SELECT * FROM web_hooks WHERE web_hook_id = '{$pack->web_hook_id}'");
$pack->auth->game_id = $webhook->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM web_hooks WHERE web_hook_id = '{$pack->web_hook_id}' LIMIT 1");
//cleanup
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$webhook->requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::deleteRequirementPackage($pack);
}
$reqAtoms = dbconnection::queryArray("SELECT * FROM requirement_atoms WHERE requirement = 'PLAYER_HAS_RECEIVED_INCOMING_WEB_HOOK' AND content_id = '{$pack->web_hook_id}'");
for ($i = 0; $i < count($reqAtoms); $i++) {
$pack->requirement_atom_id = $reqAtoms[$i]->requirement_atom_id;
requirements::deleteRequirementAtom($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
public static function deleteWebPage($pack)
{
$webpage = dbconnection::queryObject("SELECT * FROM web_pages WHERE web_page_id = '{$pack->web_page_id}'");
$pack->auth->game_id = $webpage->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM web_pages WHERE web_page_id = '{$pack->web_page_id}' LIMIT 1");
//cleanup
$options = dbconnection::queryArray("SELECT * FROM dialog_options WHERE link_type = 'EXIT_TO_WEB_PAGE' AND link_id = '{$pack->web_page_id}'");
for ($i = 0; $i < count($options); $i++) {
$pack->dialog_option_id = $options[$i]->dialog_option_id;
dialogs::deleteDialogOption($pack);
}
$tabs = dbconnection::queryArray("SELECT * FROM tabs WHERE type = 'WEB_PAGE' AND content_id = '{$pack->web_page_id}'");
for ($i = 0; $i < count($tabs); $i++) {
$pack->tab_id = $tabs[$i]->tab_id;
tabs::deleteTab($pack);
}
$tags = dbconnection::queryArray("SELECT * FROM object_tags WHERE object_type = 'WEB_PAGE' AND object_id = '{$pack->web_page_id}'");
for ($i = 0; $i < count($tags); $i++) {
$pack->object_tag_id = $tags[$i]->object_tag_id;
tags::deleteObjectTag($pack);
}
$instances = dbconnection::queryArray("SELECT * FROM instances WHERE object_type = 'WEB_PAGE' AND object_id = '{$pack->web_page_id}'");
for ($i = 0; $i < count($instances); $i++) {
$pack->instance_id = $instances[$i]->instance_id;
instances::deleteInstance($pack);
}
$factories = dbconnection::queryArray("SELECT * FROM factories WHERE object_type = 'WEB_PAGE' AND object_id = '{$pack->web_page_id}'");
for ($i = 0; $i < count($factories); $i++) {
$pack->factory_id = $factories[$i]->factory_id;
factories::deleteFactory($pack);
}
$reqAtoms = dbconnection::queryArray("SELECT * FROM requirement_atoms WHERE requirement = 'PLAYER_VIEWED_WEB_PAGE' AND content_id = '{$pack->web_page_id}'");
for ($i = 0; $i < count($reqAtoms); $i++) {
$pack->requirement_atom_id = $reqAtoms[$i]->requirement_atom_id;
requirements::deleteRequirementAtom($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
public static function deleteQuest($pack)
{
$quest = dbconnection::queryObject("SELECT * FROM quests WHERE quest_id = '{$pack->quest_id}'");
$pack->auth->game_id = $quest->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM quests WHERE quest_id = '{$pack->quest_id}' LIMIT 1");
//cleanup
$reqAtoms = dbconnection::queryArray("SELECT * FROM requirement_atoms WHERE requirement = 'PLAYER_HAS_COMPLETED_QUEST' AND content_id = '{$pack->quest_id}'");
for ($i = 0; $i < count($reqAtoms); $i++) {
$pack->requirement_atom_id = $reqAtoms[$i]->requirement_atom_id;
requirements::deleteRequirementAtom($pack);
}
/* Comment out until we've decided on desired behavior...
$eventpack = dbconnection::queryObject("SELECT * FROM event_packages WHERE event_package_id = '{$quest->active_event_package_id}'");
if($eventpack)
{
$pack->event_package_id = $eventpack->event_package_id;
events::deleteEventPackage($pack);
}
$eventpack = dbconnection::queryObject("SELECT * FROM event_packages WHERE event_package_id = '{$quest->complete_event_package_id}'");
if($eventpack)
{
$pack->event_package_id = $eventpack->event_package_id;
events::deleteEventPackage($pack);
}
*/
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$quest->active_requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::deleteRequirementPackage($pack);
}
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$quest->complete_requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::deleteRequirementPackage($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
function checkRequirements()
{
$this->log("Checking requirements ");
$requirements = new requirements();
// for each requirement
foreach ($this->upgradeVersionSettings['Requirements'] as $requirementMethod) {
$requirements->runMethod($requirementMethod);
}
$this->log("OK\n", 'ok');
}
public static function deleteFactory($pack)
{
$factory = dbconnection::queryObject("SELECT * FROM factories WHERE factory_id = '{$pack->factory_id}'");
$pack->auth->game_id = $factory->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM factories WHERE factory_id = '{$pack->factory_id}' LIMIT 1");
//cleanup
$instances = dbconnection::queryArray("SELECT * FROM instances WHERE factory_id = '{$pack->factory_id}'");
for ($i = 0; $i < count($instances); $i++) {
$pack->instance_id = $instances[$i]->instance_id;
instances::deleteInstance($pack);
}
$instances = dbconnection::queryArray("SELECT * FROM instances WHERE object_type = 'FACTORY' AND object_id = '{$pack->factory_id}'");
for ($i = 0; $i < count($instances); $i++) {
$pack->instance_id = $instances[$i]->instance_id;
instances::deleteInstance($pack);
}
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$factory->requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::deleteRequirementPackage($pack);
}
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$factory->trigger_requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::deleteRequirementPackage($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
public static function checkForCascadingLogs($pack)
{
$quests = dbconnection::queryArray("SELECT * FROM quests WHERE game_id = '{$pack->game_id}'");
$completedRecords = dbconnection::queryArray("SELECT * FROM user_log WHERE game_id = '{$pack->game_id}' AND user_id = '{$pack->auth->user_id}' AND event_type = 'COMPLETE_QUEST' AND deleted = 0 GROUP BY content_id");
$incompleteQuests = array();
for ($i = 0; $i < count($quests); $i++) {
$completed = false;
for ($j = 0; $j < count($completedRecords); $j++) {
if ($quests[$i]->quest_id == $completedRecords[$j]->content_id) {
$completed = true;
}
}
if (!$completed) {
$incompleteQuests[] = $quests[$i];
}
}
$reqQueryPack = new stdClass();
$reqQueryPack->game_id = $pack->game_id;
$reqQueryPack->user_id = $pack->auth->user_id;
$questQueryPack = new stdClass();
$questQueryPack->game_id = $pack->game_id;
$questQueryPack->auth = $pack->auth;
$questQueryPack->silent = true;
//logPlayerCompletedQuest would otherwise recursively call this function. Might as well save it for the end.
$dirty = false;
for ($i = 0; $i < count($incompleteQuests); $i++) {
$reqQueryPack->requirement_root_package_id = $incompleteQuests[$i]->complete_requirement_root_package_id;
$questQueryPack->quest_id = $incompleteQuests[$i]->quest_id;
if (requirements::evaluateRequirementPackage($reqQueryPack)) {
client::logPlayerCompletedQuest($questQueryPack);
$dirty = true;
}
}
if ($dirty) {
client::checkForCascadingLogs($pack);
}
//log changed, potentially requiring more logs
}
public static function evaluateRequirementAtom($pack)
{
$atom = dbconnection::queryObject("SELECT * FROM requirement_atoms WHERE requirement_atom_id = '{$pack->requirement_atom_id}'");
if (!$atom) {
return false;
}
$atom->user_id = $pack->user_id;
if ($atom->bool_operator == 0) {
$atom->bool_operator = false;
}
if ($atom->bool_operator == 1) {
$atom->bool_operator = true;
}
//these functions need to be defined for new schema
switch ($atom->requirement) {
case 'ALWAYS_TRUE':
return $atom->bool_operator == true;
case 'ALWAYS_FALSE':
return $atom->bool_operator == false;
case 'PLAYER_HAS_ITEM':
return $atom->bool_operator == requirements::playerHasItem($atom);
case 'PLAYER_HAS_TAGGED_ITEM':
return $atom->bool_operator == requirements::playerHasTaggedItem($atom);
case 'GAME_HAS_ITEM':
return $atom->bool_operator == requirements::gameHasItem($atom);
case 'GAME_HAS_TAGGED_ITEM':
return $atom->bool_operator == requirements::gameHasTaggedItem($atom);
case 'GROUP_HAS_ITEM':
return $atom->bool_operator == requirements::groupHasItem($atom);
case 'GROUP_HAS_TAGGED_ITEM':
return $atom->bool_operator == requirements::groupHasTaggedItem($atom);
case 'PLAYER_VIEWED_ITEM':
return $atom->bool_operator == requirements::playerViewed($atom, "ITEM");
case 'PLAYER_VIEWED_PLAQUE':
return $atom->bool_operator == requirements::playerViewed($atom, "PLAQUE");
case 'PLAYER_VIEWED_DIALOG':
return $atom->bool_operator == requirements::playerViewed($atom, "DIALOG");
case 'PLAYER_VIEWED_DIALOG_SCRIPT':
return $atom->bool_operator == requirements::playerViewed($atom, "DIALOG_SCRIPT");
case 'PLAYER_VIEWED_WEB_PAGE':
return $atom->bool_operator == requirements::playerViewed($atom, "WEB_PAGE");
case 'PLAYER_RAN_EVENT_PACKAGE':
return $atom->bool_operator == requirements::playerRanEvent($atom);
case 'PLAYER_HAS_UPLOADED_MEDIA_ITEM':
return $atom->bool_operator == requirements::playerUploadedAnyNear($atom);
case 'PLAYER_HAS_UPLOADED_MEDIA_ITEM_IMAGE':
return $atom->bool_operator == requirements::playerUploadedTypeNear($atom, "IMAGE");
case 'PLAYER_HAS_UPLOADED_MEDIA_ITEM_AUDIO':
return $atom->bool_operator == requirements::playerUploadedTypeNear($atom, "AUDIO");
case 'PLAYER_HAS_UPLOADED_MEDIA_ITEM_VIDEO':
return $atom->bool_operator == requirements::playerUploadedTypeNear($atom, "VIDEO");
case 'PLAYER_HAS_COMPLETED_QUEST':
return $atom->bool_operator == requirements::playerCompletedQuest($atom);
case 'PLAYER_HAS_RECEIVED_INCOMING_WEB_HOOK':
return $atom->bool_operator == requirements::playerReceivedWebHook($atom);
case 'PLAYER_HAS_NOTE':
return $atom->bool_operator == requirements::playerHasNote($atom);
case 'PLAYER_HAS_NOTE_WITH_TAG':
return $atom->bool_operator == requirements::playerHasNoteWithTag($atom);
case 'PLAYER_HAS_NOTE_WITH_LIKES':
return $atom->bool_operator == requirements::playerHasNoteWithLikes($atom);
case 'PLAYER_HAS_NOTE_WITH_COMMENTS':
return $atom->bool_operator == requirements::playerHasNoteWithComments($atom);
case 'PLAYER_HAS_GIVEN_NOTE_COMMENTS':
return $atom->bool_operator == requirements::playerHasGivenNoteComments($atom);
}
return false;
}
public static function deleteTab($pack)
{
$tab = dbconnection::queryObject("SELECT * FROM tabs WHERE tab_id = '{$pack->tab_id}'");
$pack->auth->game_id = $tab->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM tabs WHERE tab_id = '{$pack->tab_id}' LIMIT 1");
//cleanup
$options = dbconnection::queryArray("SELECT * FROM dialog_options WHERE link_type = 'EXIT_TO_TAB' AND link_id = '{$pack->tab_id}'");
for ($i = 0; $i < count($options); $i++) {
$pack->dialog_option_id = $options[$i]->dialog_option_id;
dialogs::deleteDialogOption($pack);
}
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$tab->requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::deleteRequirementPackage($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
public static function deleteTag($pack)
{
$pack->auth->game_id = dbconnection::queryObject("SELECT * FROM tags WHERE tag_id = '{$pack->tag_id}'")->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM tags WHERE tag_id = '{$pack->tag_id}' LIMIT 1");
//cleanup
$tags = dbconnection::queryArray("SELECT * FROM object_tags WHERE tag_id = '{$pack->tag_id}'");
for ($i = 0; $i < count($tags); $i++) {
$pack->object_tag_id = $tags[$i]->object_tag_id;
tags::deleteObjectTag($pack);
}
$reqAtoms = dbconnection::queryArray("SELECT * FROM requirement_atoms WHERE requirement = 'PLAYER_HAS_TAGGED_ITEM' AND content_id = '{$pack->tag_id}'");
for ($i = 0; $i < count($reqAtoms); $i++) {
$pack->requirement_atom_id = $reqAtoms[$i]->requirement_atom_id;
requirements::deleteRequirementAtom($pack);
}
$reqAtoms = dbconnection::queryArray("SELECT * FROM requirement_atoms WHERE requirement = 'GAME_HAS_TAGGED_ITEM' AND content_id = '{$pack->tag_id}'");
for ($i = 0; $i < count($reqAtoms); $i++) {
$pack->requirement_atom_id = $reqAtoms[$i]->requirement_atom_id;
requirements::deleteRequirementAtom($pack);
}
$reqAtoms = dbconnection::queryArray("SELECT * FROM requirement_atoms WHERE requirement = 'PLAYER_HAS_NOTE_WITH_TAG' AND content_id = '{$pack->tag_id}'");
for ($i = 0; $i < count($reqAtoms); $i++) {
$pack->requirement_atom_id = $reqAtoms[$i]->requirement_atom_id;
requirements::deleteRequirementAtom($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
public static function noauth_deleteTrigger($pack)
{
//and this "fixes" the security risk...
if (strpos($_SERVER['REQUEST_URI'], 'noauth') !== false) {
return new return_package(6, NULL, "Attempt to bypass authentication externally.");
}
dbconnection::query("DELETE FROM triggers WHERE trigger_id = '{$pack->trigger_id}' LIMIT 1");
//cleanup
$instances = dbconnection::queryArray("SELECT * FROM instances WHERE instance_id = '{$trigger->instance_id}'");
for ($i = 0; $i < count($instances); $i++) {
$pack->instance_id = $instances[$i]->instance_id;
instances::noauth_deleteInstance($pack);
}
$reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$trigger->requirement_root_package_id}'");
if ($reqPack) {
$pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
requirements::noauth_deleteRequirementPackage($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
public static function deletePlaque($pack)
{
$plaque = dbconnection::queryObject("SELECT * FROM plaques WHERE plaque_id = '{$pack->plaque_id}'");
$pack->auth->game_id = $plaque->game_id;
$pack->auth->permission = "read_write";
if (!editors::authenticateGameEditor($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
dbconnection::query("DELETE FROM plaques WHERE plaque_id = '{$pack->plaque_id}' LIMIT 1");
//cleanup
/* Comment out until we've decided on desired behavior...
$eventpack = dbconnection::queryObject("SELECT * FROM event_packages WHERE event_package_id = '{$plaque->event_package_id}'");
if($eventpack)
{
$pack->event_package_id = $eventpack->event_package_id;
events::deleteEventPackage($pack);
}
*/
$options = dbconnection::queryArray("SELECT * FROM dialog_options WHERE link_type = 'EXIT_TO_PLAQUE' AND link_id = '{$pack->plaque_id}'");
for ($i = 0; $i < count($options); $i++) {
$pack->dialog_option_id = $options[$i]->dialog_option_id;
dialogs::deleteDialogOption($pack);
}
$tabs = dbconnection::queryArray("SELECT * FROM tabs WHERE type = 'PLAQUE' AND content_id = '{$pack->plaque_id}'");
for ($i = 0; $i < count($tabs); $i++) {
$pack->tab_id = $tabs[$i]->tab_id;
tabs::deleteTab($pack);
}
$tags = dbconnection::queryArray("SELECT * FROM object_tags WHERE object_type = 'PLAQUE' AND object_id = '{$pack->plaque_id}'");
for ($i = 0; $i < count($tags); $i++) {
$pack->object_tag_id = $tags[$i]->object_tag_id;
tags::deleteObjectTag($pack);
}
$instances = dbconnection::queryArray("SELECT * FROM instances WHERE object_type = 'PLAQUE' AND object_id = '{$pack->plaque_id}'");
for ($i = 0; $i < count($instances); $i++) {
$pack->instance_id = $instances[$i]->instance_id;
instances::deleteInstance($pack);
}
$factories = dbconnection::queryArray("SELECT * FROM factories WHERE object_type = 'PLAQUE' AND object_id = '{$pack->plaque_id}'");
for ($i = 0; $i < count($factories); $i++) {
$pack->factory_id = $factories[$i]->factory_id;
factories::deleteFactory($pack);
}
$reqAtoms = dbconnection::queryArray("SELECT * FROM requirement_atoms WHERE requirement = 'PLAYER_VIEWED_PLAQUE' AND content_id = '{$pack->plaque_id}'");
for ($i = 0; $i < count($reqAtoms); $i++) {
$pack->requirement_atom_id = $reqAtoms[$i]->requirement_atom_id;
requirements::deleteRequirementAtom($pack);
}
games::bumpGameVersion($pack);
return new return_package(0);
}
