Exemplo n.º 1
0
 /**
  * Returns a new ItemSubTypeQuery object.
  *
  * @param     string $modelAlias The alias of a model in the query
  * @param     ItemSubTypeQuery|Criteria $criteria Optional Criteria to build the query from
  *
  * @return ItemSubTypeQuery
  */
 public static function create($modelAlias = null, $criteria = null)
 {
     if ($criteria instanceof ItemSubTypeQuery) {
         return $criteria;
     }
     $query = new ItemSubTypeQuery();
     if (null !== $modelAlias) {
         $query->setModelAlias($modelAlias);
     }
     if ($criteria instanceof Criteria) {
         $query->mergeWith($criteria);
     }
     return $query;
 }
Exemplo n.º 2
0
/**
 * @param $API_JSON
 * @param $offset
 */
function processApiData($API_JSON, $offset)
{
    $APIItems = APIItemV2::getMultipleItemsByJSON($API_JSON);
    try {
        $itemCount = $offset;
        foreach ($APIItems as $APIItem) {
            $itemCount++;
            if ($APIItem == null) {
                print "Skipped item {$itemCount} on page {$offset}.\n";
                continue;
            }
            echo "{$itemCount}: {$APIItem->getName()} (ID: {$APIItem->getItemId()})\n";
            $itemData = array('TypeId' => getOrCreateTypeID($APIItem->getMarketType()), 'DataId' => $APIItem->getItemId(), 'Name' => $APIItem->getName(), 'RestrictionLevel' => $APIItem->getLevel(), 'Rarity' => getRarityID($APIItem->getRarity()), 'VendorSellPrice' => $APIItem->getVendorValue(), 'Img' => $APIItem->getImageURL(), 'RarityWord' => $APIItem->getRarity(), 'UnsellableFlag' => $APIItem->isUnsellable());
            $item = ItemQuery::create()->findPK($APIItem->getItemId());
            if ($item === null) {
                $item = new Item();
            }
            $item->fromArray($itemData);
            $itemType = ItemTypeQuery::create()->findPk($itemData['TypeId']);
            if ($itemType !== null) {
                if ($APIItem->getSubType() !== null) {
                    $itemSubType = ItemSubTypeQuery::create()->findOneByTitle($APIItem->getDBSubType());
                    if ($itemSubType === null) {
                        //All of the below types are known to not exist in the market data with an ID (by this name).
                        //Rune/Sigil/Utility/Gem/Booze/Halloween/LargeBundle/RentableContractNpc/ContractNPC/UnlimitedConsumable
                        //TwoHandedToy/AppearanceChange/Immediate/Unknown
                        $itemSubTypes = ItemSubTypeQuery::create()->filterByMainTypeId($itemData['TypeId'])->withColumn('MAX(id)', 'MAXid')->find();
                        $SubTypeID = $itemSubTypes[0]->getMAXid() + 1;
                        $itemSubType = new ItemSubType();
                        $itemSubType->fromArray(array('Id' => $SubTypeID, 'MainTypeId' => $itemData['TypeId'], 'Title' => $APIItem->getDBSubType()));
                        $itemSubType->save();
                        $itemType->addSubType($itemSubType);
                        $item->setItemSubType($itemSubType);
                    }
                    $itemType->addSubType($itemSubType);
                    $item->setItemSubType($itemSubType);
                }
                $item->setItemType($itemType);
            }
            $item->save();
        }
    } catch (Exception $e) {
        echo "failed [[ {$e->getMessage()} ]] .. \n";
    }
}
Exemplo n.º 3
0
 /**
  * Get the associated ItemSubType object
  *
  * @param      PropelPDO $con Optional Connection object.
  * @return                 ItemSubType The associated ItemSubType object.
  * @throws PropelException
  */
 public function getItemSubType(PropelPDO $con = null)
 {
     if ($this->aItemSubType === null && $this->item_sub_type_id !== null) {
         $this->aItemSubType = ItemSubTypeQuery::create()->filterByItem($this)->findOne($con);
         /* The following can be used additionally to
               guarantee the related object contains a reference
               to this object.  This level of coupling may, however, be
               undesirable since it could result in an only partially populated collection
               in the referenced object.
               $this->aItemSubType->addItems($this);
            */
     }
     return $this->aItemSubType;
 }
Exemplo n.º 4
0
 /**
  * Returns the number of related ItemSubType objects.
  *
  * @param      Criteria $criteria
  * @param      boolean $distinct
  * @param      PropelPDO $con
  * @return int             Count of related ItemSubType objects.
  * @throws PropelException
  */
 public function countSubTypes(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
 {
     $partial = $this->collSubTypesPartial && !$this->isNew();
     if (null === $this->collSubTypes || null !== $criteria || $partial) {
         if ($this->isNew() && null === $this->collSubTypes) {
             return 0;
         } else {
             if ($partial && !$criteria) {
                 return count($this->getSubTypes());
             }
             $query = ItemSubTypeQuery::create(null, $criteria);
             if ($distinct) {
                 $query->distinct();
             }
             return $query->filterByMainType($this)->count($con);
         }
     } else {
         return count($this->collSubTypes);
     }
 }
Exemplo n.º 5
0
$app->get("/type/{type}/{subtype}/{page}", function (Request $request, $type, $subtype, $page) use($app) {
    $page = $page > 0 ? $page : 1;
    $q = ItemQuery::create();
    if ($type == -1) {
        $type = null;
    }
    if ($subtype == -1) {
        $subtype = null;
    }
    if (!is_null($type)) {
        if (!($type = ItemTypeQuery::create()->findPk($type))) {
            return $app->abort(404, "bad type");
        }
        $q->filterByItemType($type);
        if (!is_null($subtype)) {
            if (!($subtype = ItemSubTypeQuery::create()->findPk(array($subtype, $type->getId())))) {
                return $app->abort(404, "bad type");
            }
            $q->filterByItemSubType($subtype);
        }
    }
    // use generic function to render
    return item_list($app, $request, $q, $page, 50, array('type' => $type, 'subtype' => $subtype));
})->assert('type', '-?\\d*')->assert('subtype', '-?\\d*')->assert('page', '-?\\d*')->value('type', -1)->value('subtype', -1)->value('page', 1)->bind('type');
/**
 * ----------------------
 *  route /item
 * ----------------------
 */
$app->get("/item/{dataId}", function ($dataId) use($app) {
    $item = ItemQuery::create()->findPK($dataId);
Exemplo n.º 6
0
 /**
  * Removes this object from datastore and sets delete attribute.
  *
  * @param      PropelPDO $con
  * @return void
  * @throws PropelException
  * @throws Exception
  * @see        BaseObject::setDeleted()
  * @see        BaseObject::isDeleted()
  */
 public function delete(PropelPDO $con = null)
 {
     if ($this->isDeleted()) {
         throw new PropelException("This object has already been deleted.");
     }
     if ($con === null) {
         $con = Propel::getConnection(ItemSubTypePeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
     }
     $con->beginTransaction();
     try {
         $deleteQuery = ItemSubTypeQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
         $ret = $this->preDelete($con);
         if ($ret) {
             $deleteQuery->delete($con);
             $this->postDelete($con);
             $con->commit();
             $this->setDeleted(true);
         } else {
             $con->commit();
         }
     } catch (Exception $e) {
         $con->rollBack();
         throw $e;
     }
 }