Jump to content


  • Content Count

  • Joined

  • Last visited

  • Yangs

    0 [ Donate ]

Community Reputation

0 Neutral

About rawn3cr0

  • Rank


  • Gender

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. rawn3cr0

    open Aura

    I have same problem .... edit: Effect not show...
  2. How i can modify this from: /search_in_shops (VNUM) ex /search_in_shops 189 in... /search_in_shops (VNUM) (ITEM-ID-from shop table) ex /search_in_shops 189 50 To not find all items with vnum just one item with specified id. struct FSearch { FSearch(LPCHARACTER ch, int Vnum) : m_ch(ch), itemVnum(Vnum) { } void operator () (LPENTITY ent) { if (ent->IsType(ENTITY_CHARACTER)) { LPCHARACTER ch = (LPCHARACTER) ent; if (ch->GetRaceNum() !>= 30000 && GetRaceNum() <= 30007) //umutk kaşmir return; char szQuery[1024]; sprintf(szQuery, "SELECT * FROM %soffline_shop_item WHERE owner_id = %u AND vnum = %d", get_table_postfix(), ch->GetOfflineShopRealOwner(), itemVnum); std::auto_ptr<SQLMsg> pSearchQuery(DBManager::instance().DirectQuery(szQuery)); if (pSearchQuery->uiSQLErrno != 0) { sys_err("Item Search Query Failed, Error code: %ld", pSearchQuery->uiSQLErrno); return; } if (!pSearchQuery->Get()->uiNumRows){ return; } CTargetManager::Instance().CreateTarget(m_ch->GetPlayerID(), 9999, ch->GetName(), 3, ch->GetVID(), 0, m_ch->GetMapIndex(), NULL, 1); } } LPCHARACTER m_ch; int itemVnum; }; void COfflineShopManager::SearchInShops(LPCHARACTER ch, int vnum) { if (!ch) return; LPSECTREE_MAP pSecMap = SECTREE_MANAGER::instance().GetMap(ch->GetMapIndex()); if (!pSecMap) return; FSearch f(ch, vnum); pSecMap->for_each(f); ch->SetQuestFlag("item_search.flood_check", get_global_time()); } ACMD(do_search_in_shops) { char arg1[256]; one_argument(argument, arg1, sizeof(arg1)); int vnum = 0; str_to_number(vnum, arg1); int iFloodResult = ch->GetQuestFlag("item_search.flood_check"); if (iFloodResult){ if (get_global_time() < iFloodResult + 3) { ch->ChatPacket(CHAT_TYPE_INFO, "Cok hizlisin."); return; } } COfflineShopManager::Instance().SearchInShops(ch, vnum); }
  3. In Ken offlineshop db refresh instantly. How i can make to great shop same?
  4. How i can fix this bug? Item on shop after delete from db. Offlineshop great!
  5. ACMD(do_shop_delete) { char arg1[256]; one_argument(argument, arg1, sizeof(arg1)); if (!*arg1) { ch->ChatPacket(CHAT_TYPE_INFO, "Usage:"); ch->ChatPacket(CHAT_TYPE_INFO, "/delete_shop <type> <arg> "); ch->ChatPacket(CHAT_TYPE_INFO, "Types:"); ch->ChatPacket(CHAT_TYPE_INFO, " id - Delete item from shop using ID"); ch->ChatPacket(CHAT_TYPE_INFO, "Example:"); ch->ChatPacket(CHAT_TYPE_INFO, " /delete_shop id 1"); return; } if (!strcmp(arg1, "id")) { SQLMsg * pkMsg(DBManager::instance().DirectQuery("delete from player_shop_items WHERE id='%s'", arg1)); SQLResult * pRes = pkMsg->Get(); if (pRes->uiNumRows>0) { MYSQL_ROW row; while ((row = mysql_fetch_row(pRes->pSQLResult)) != NULL) { DWORD id; str_to_number(id, arg1); DBManager::instance().DirectQuery("delete from player_shop_items WHERE id='%s'", id); } } else ch->ChatPacket(CHAT_TYPE_INFO, "Shop %s does exists", arg1); } }
  6. How i can make a in game command in source like: /delete_item 280 where 280 is item id from offlineshop. I try something last night but dont work..
  7. How i can make a command to reload items from offlineshop by great? I try: /update_shop <shop id> - Reload shop items when you edit it in MySQL but don't work
  8. How i can teleport with x and y from db in quest?
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.