rawn3cr0

I have same problem .... edit: Effect not show...

Up

I have this problem

I have same problem

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

In Ken offlineshop db refresh instantly. How i can make to great shop same?

Yeah..

How i can fix this bug? Item on shop after delete from db. Offlineshop great!

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

Im not now at pc ....

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

Up.

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

Solved

How i can teleport with x and y from db in quest?