Jump to content
Koray

[RLS]Private Shop Search System

Recommended Posts

Shop2: Item Search Query Failed, Rows couldn't get

LONG LONG yang problem ?

Share this post


Link to post

Nice, but one Problem:

 

Problem with max yang? If I want search something ... Nothing happend i can click "search" how much i will, nothing happend... maybe i have to chance the "price" values to long long?

 

But nice release!

Share this post


Link to post

In the Shop.cpp i have to search for

Spoiler

Search:
        char name[36];
        snprintf(name, sizeof(name), "%-20s(#%-5d) (x %d)", item_table->szName, (int) item.vnum, item.count);

        sys_log(0, "SHOP_ITEM: %-36s PRICE %-5d", name, item.price);
 

But i dont have that :o what to do there ?

Share this post


Link to post
37 minutes ago, metin2team said:

@Kaso just ignore it :) it just prints the (name vnum xcount) price to the sys_log. you can ignore it.

Thanks =)

So i can just add that somewhere in the shop.cpp ?

Spoiler

Add in under:
        if (IsPCShop())
            InsertInMysql(m_pkPC, pkItem, iPos, item.price);
 

 

Share this post


Link to post

help please...i'am don't know were tu modifi for this error whene i compilate my source

input_main.cpp: In member function 'virtual int CInputMain::Analyze(DESC*, BYTE, const char*)':
input_main.cpp:3706: error: duplicate case value
input_main.cpp:3702: error: previously used here

http://imgur.com/r9NSy05

Share this post


Link to post

Hello, got problem: "Shop2: Item Search Query Failed, Rows couldn't get"

Any result?

Share this post


Link to post

Hey i have Ken Offline shop

who helps me to get up to speed I give him 50€ to paypal for fix

Code
  1. Server syserr:
  2. Shop2: Item Search Query Failed, Rows couldn't get
  3. Shop2: Item Search Query Failed, Rows couldn't get
  4. Shop2: Item Search Query Failed, Rows couldn't get
  5. Shop2: Item Search Query Failed, Rows couldn't get

 

Share this post


Link to post

It works to make search from offline shop but effect do not appear. Like this.

[tests] is not the seller.

35ef26e.jpg

I think need change from normal shop to offline shop traget, but i don't know how.

I have ken offline shop

Share this post


Link to post

Contact ? Koray ? Skype or Discord i buy system premium , no this free.

Skype : carpe.diem285

Discord : CarpeDiem#6969

  • Confused 1

Share this post


Link to post

Relase date 11.04.2016

Now date 27.01/2019

And still waiting for fix this system (ken offlineshop)

Share this post


Link to post

For normal shop work good but for offlineshop not...

[TestEMPP] isn't shop owner

Syserr NOTHING

aAqS24v.jpg

Share this post


Link to post

please hellp! i have shop ofline ken ... 

 

SYSERR: Dec  6 03:24:56 :: Shop2: Item Search Query Failed, Rows couldn't get
SYSERR: Dec  6 03:25:00 :: Shop2: Item Search Query Failed, Rows couldn't get
SYSERR: Dec  6 03:25:04 :: Shop2: Item Search Query Failed, Rows couldn't get
SYSERR: Dec  6 03:25:05 :: Shop2: Item Search Query Failed, Rows couldn't get
SYSERR: Dec  6 03:25:05 :: Shop2: Item Search Query Failed, Rows couldn't get
SYSERR: Dec  6 03:25:06 :: Shop2: Item Search Query Failed, Rows couldn't get
SYSERR: Dec  6 03:25:06 :: Shop2: Item Search Query Failed, Rows couldn't get

Share this post


Link to post

Guys does someone fixed the offline shop by ken? with this system i have almost same errors...

Share this post


Link to post

My problem is, that that CHAT_TYPE_COMMAND to Search is way to long.

Core downer with on this function void CHARACTER::ChatPacket(BYTE type, const char * format, ...)

With this line : int len = vsnprintf(chatbuf, sizeof(chatbuf), format, args);

When i reduce the CHAT_TYPE_COMMAND  then everything is fine.

 

Next problem is, that shop_onsales_items does not read items on boot. So it is empty when i restart Server.

@Koray

 

If you want to find 1 Hand Weapons

input_main.cpp

void CInputMain::Shop2(LPCHARACTER ch, const char * data)

change:

				if (table && p->iJob == 0 && (table->dwAntiFlags & ITEM_ANTIFLAG_ASSASSIN && table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN && table->dwAntiFlags & ITEM_ANTIFLAG_SURA) ||
					table && p->iJob == 1 && (table->dwAntiFlags & ITEM_ANTIFLAG_WARRIOR  && table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN && table->dwAntiFlags & ITEM_ANTIFLAG_SURA) ||
					table && p->iJob == 2 && (table->dwAntiFlags & ITEM_ANTIFLAG_ASSASSIN && table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN && table->dwAntiFlags & ITEM_ANTIFLAG_WARRIOR) ||
					table && p->iJob == 3 && (table->dwAntiFlags & ITEM_ANTIFLAG_ASSASSIN && table->dwAntiFlags & ITEM_ANTIFLAG_WARRIOR && table->dwAntiFlags & ITEM_ANTIFLAG_SURA) ||)

to:

				if (table && p->iJob == 0 && (table->dwAntiFlags & ITEM_ANTIFLAG_ASSASSIN && table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN && table->dwAntiFlags & ITEM_ANTIFLAG_SURA) ||
					table && p->iJob == 1 && (table->dwAntiFlags & ITEM_ANTIFLAG_WARRIOR  && table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN && table->dwAntiFlags & ITEM_ANTIFLAG_SURA) ||
					table && p->iJob == 2 && (table->dwAntiFlags & ITEM_ANTIFLAG_ASSASSIN && table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN && table->dwAntiFlags & ITEM_ANTIFLAG_WARRIOR) ||
					table && p->iJob == 3 && (table->dwAntiFlags & ITEM_ANTIFLAG_ASSASSIN && table->dwAntiFlags & ITEM_ANTIFLAG_WARRIOR && table->dwAntiFlags & ITEM_ANTIFLAG_SURA) ||
					table && p->iJob == 0 && (table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN) || table && p->iJob == 1 && (table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN) || 
					table && p->iJob == 2 && (table->dwAntiFlags & ITEM_ANTIFLAG_SHAMAN)
					)

Next Fix :D

If you want to search Items without typing name:

input_main.cpp

search:

if (strlen(p->cItemNameForSearch) && strstr(c_szItemName, c_szItemNameForSearch)){
...
}

Add unter:

else if (strlen(p->cItemNameForSearch)<1 ) {
* same code like above*
}

 

  • Love 1

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

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