Beiträge von meneleos

meneleos · 12. Dezember 2022

Zitat von 'Asasel

Zitat von meneleos

I edited sql queries.

InitializePromotionCodes

Code

char szQuery[1024] = "SELECT CODES.`useCount`, CODES.`promotion_code`, `vnum`, `count` ";

size_t len = strlen(szQuery);

for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++)

len += snprintf(szQuery + len, sizeof(szQuery) - len,

",`socket%d` ", i);

for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++)

len += snprintf(szQuery + len, sizeof(szQuery) - len,

",`attrtype%d` , `attrvalue%d` ", i, i);

len += snprintf(szQuery + len, sizeof(szQuery) - len, "%s", " "

" FROM "

" `itemshop`.`promotion_rewards` AS REWARDS "

" LEFT JOIN itemshop.promotion_codes AS CODES ON REWARDS.code_index = CODES.index "

" WHERE "

" REWARDS.code_index = CODES.index AND CODES.state = 'ENABLED' "

" AND count > 0"

);

Alles anzeigen
InitializeItemshopSpecialOffers

Code

char szQuery[1024] = "SELECT `itemIndex`, `vnum`, `count`, ABS(`price`), `discountPercent`, `limitCount`, `category` "

", UNIX_TIMESTAMP(`endTime`), `weight` ";

size_t len = strlen(szQuery);

for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++)

len += snprintf(szQuery + len, sizeof(szQuery) - len,

",`socket%d` ", i);

for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++)

len += snprintf(szQuery + len, sizeof(szQuery) - len,

",`attrtype%d` , `attrvalue%d` ", i, i);

len += snprintf(szQuery + len, sizeof(szQuery) - len, "%s", " "

", UNIX_TIMESTAMP(`startTime`), UNIX_TIMESTAMP(`endTime`), (UNIX_TIMESTAMP(NOW()) >= UNIX_TIMESTAMP(startTime)) "

" FROM "

" `itemshop`.`itemshop_items` AS ITEMS "

" LEFT JOIN `itemshop`.`itemshop_categories` AS CATEGORY ON ITEMS.category = CATEGORY.category_index "

" WHERE "

" ITEMS.category = CATEGORY.category_index AND CATEGORY.category_state = 'ENABLED' "

" AND not limitCount = 0 "

" AND count > 0 "

" AND("

" (UNIX_TIMESTAMP(NOW()) < UNIX_TIMESTAMP(ITEMS.endTime))"

" AND "

" (UNIX_TIMESTAMP(ITEMS.startTime) < UNIX_TIMESTAMP(ITEMS.endTime) ))"

" ORDER BY UNIX_TIMESTAMP(startTime)"

);

Alles anzeigen
InitializeItemshopItemTable

Code

char szQuery[1024] = "SELECT `itemIndex`, `vnum`, `count`, ABS(`price`), `discountPercent`, `limitCount`, `category` "

", UNIX_TIMESTAMP(`endTime`), `weight` ";

size_t len = strlen(szQuery);

for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++)

len += snprintf(szQuery + len, sizeof(szQuery) - len,

",`socket%d` ", i);

for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++)

len += snprintf(szQuery + len, sizeof(szQuery) - len,

",`attrtype%d` , `attrvalue%d` ", i, i);

len += snprintf(szQuery + len, sizeof(szQuery) - len, "%s", " "

" FROM "

" `itemshop`.`itemshop_items` AS ITEMS "

" LEFT JOIN `itemshop`.`itemshop_categories` AS CATEGORY ON ITEMS.category = CATEGORY.category_index "

" WHERE "

" ITEMS.category = CATEGORY.category_index AND CATEGORY.category_state = 'ENABLED' "

" AND not limitCount = 0 "

" AND count > 0 "

" AND("

" (UNIX_TIMESTAMP(ITEMS.startTime) <= 0 AND UNIX_TIMESTAMP(ITEMS.endTime) <= 0) OR"

" (UNIX_TIMESTAMP(NOW()) >= UNIX_TIMESTAMP(ITEMS.startTime) AND UNIX_TIMESTAMP(NOW()) < UNIX_TIMESTAMP(ITEMS.endTime))"

" )"

);

Alles anzeigen

Alles anzeigen
and why?

Alles anzeigen

for max number of stones to be dynamic

meneleos · 12. Dezember 2022

I edited sql queries.

InitializePromotionCodes

Code

char szQuery[1024] = "SELECT CODES.`useCount`, CODES.`promotion_code`, `vnum`, `count` ";
size_t len = strlen(szQuery);
for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++)
len += snprintf(szQuery + len, sizeof(szQuery) - len,
",`socket%d` ", i);
for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++)
len += snprintf(szQuery + len, sizeof(szQuery) - len,
",`attrtype%d` , `attrvalue%d` ", i, i);
len += snprintf(szQuery + len, sizeof(szQuery) - len, "%s", " "
" FROM "
" `itemshop`.`promotion_rewards` AS REWARDS "
" LEFT JOIN itemshop.promotion_codes AS CODES ON REWARDS.code_index = CODES.index "
" WHERE "
" REWARDS.code_index = CODES.index AND CODES.state = 'ENABLED' "
" AND count > 0"
);

Alles anzeigen

InitializeItemshopSpecialOffers

Code

char szQuery[1024] = "SELECT `itemIndex`, `vnum`, `count`, ABS(`price`), `discountPercent`, `limitCount`, `category` "
", UNIX_TIMESTAMP(`endTime`), `weight` ";
size_t len = strlen(szQuery);
for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++)
len += snprintf(szQuery + len, sizeof(szQuery) - len,
",`socket%d` ", i);
for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++)
len += snprintf(szQuery + len, sizeof(szQuery) - len,
",`attrtype%d` , `attrvalue%d` ", i, i);
len += snprintf(szQuery + len, sizeof(szQuery) - len, "%s", " "
", UNIX_TIMESTAMP(`startTime`), UNIX_TIMESTAMP(`endTime`), (UNIX_TIMESTAMP(NOW()) >= UNIX_TIMESTAMP(startTime)) "
" FROM "
" `itemshop`.`itemshop_items` AS ITEMS "
" LEFT JOIN `itemshop`.`itemshop_categories` AS CATEGORY ON ITEMS.category = CATEGORY.category_index "
" WHERE "
" ITEMS.category = CATEGORY.category_index AND CATEGORY.category_state = 'ENABLED' "
" AND not limitCount = 0 "
" AND count > 0 "
" AND("
" (UNIX_TIMESTAMP(NOW()) < UNIX_TIMESTAMP(ITEMS.endTime))"
" AND "
" (UNIX_TIMESTAMP(ITEMS.startTime) < UNIX_TIMESTAMP(ITEMS.endTime) ))"
" ORDER BY UNIX_TIMESTAMP(startTime)"
);

Alles anzeigen

InitializeItemshopItemTable

Code

char szQuery[1024] = "SELECT `itemIndex`, `vnum`, `count`, ABS(`price`), `discountPercent`, `limitCount`, `category` "
", UNIX_TIMESTAMP(`endTime`), `weight` ";
size_t len = strlen(szQuery);
for (int i = 0; i < ITEM_SOCKET_MAX_NUM; i++)
len += snprintf(szQuery + len, sizeof(szQuery) - len,
",`socket%d` ", i);
for (int i = 0; i < ITEM_ATTRIBUTE_MAX_NUM; i++)
len += snprintf(szQuery + len, sizeof(szQuery) - len,
",`attrtype%d` , `attrvalue%d` ", i, i);
len += snprintf(szQuery + len, sizeof(szQuery) - len, "%s", " "
" FROM "
" `itemshop`.`itemshop_items` AS ITEMS "
" LEFT JOIN `itemshop`.`itemshop_categories` AS CATEGORY ON ITEMS.category = CATEGORY.category_index "
" WHERE "
" ITEMS.category = CATEGORY.category_index AND CATEGORY.category_state = 'ENABLED' "
" AND not limitCount = 0 "
" AND count > 0 "
" AND("
" (UNIX_TIMESTAMP(ITEMS.startTime) <= 0 AND UNIX_TIMESTAMP(ITEMS.endTime) <= 0) OR"
" (UNIX_TIMESTAMP(NOW()) >= UNIX_TIMESTAMP(ITEMS.startTime) AND UNIX_TIMESTAMP(NOW()) < UNIX_TIMESTAMP(ITEMS.endTime))"
" )"
);

Alles anzeigen

meneleos · 10. November 2018

Greetings

If the number of monsters, NPCs or characters is over 600-700 when I enter the game, the game throws me back into the login screen.

This problem is also available in mainline / novaline source files in kraizy.tgz.Unregistered mainline source throws in the login screen when there are 1200-1300 characters / monsters.

I'm looking for help in resolving the problem.People who say that I can fix the problem in a paid way can post the price together with the evidence video.

Video of the problem I'm experiencing

Bitte melden Sie sich an, um dieses Medienelement zu sehen.

meneleos · 18. September 2018

up......

meneleos · 25. August 2018

Zitat von Neuer Benutzername

ask P3NG3R (Bitte melden Sie sich an, um dieses Medienelement zu sehen.)

i try but does not answer

meneleos · 25. August 2018

I am still looking...

meneleos · 7. August 2018

Zitat von Gengar

Translate your post in english, please!

sorry, my bad.

meneleos · 7. August 2018

Hi, one of my game's core crashed. This is core debug bt and bt full. Do you have any idea what is the problem? I can pay.

bt : Bitte melden Sie sich an, um diesen Link zu sehen.

bt full: Bitte melden Sie sich an, um diesen Link zu sehen.

entity.cpp

Spoiler anzeigen

char.cpp:3811:

Spoiler anzeigen

meneleos · 22. Juli 2018

up....

meneleos · 16. März 2018

no one selling it?

meneleos · 14. März 2018

up up

meneleos · 3. März 2018

Hello guys,
I want to buy the render target system by Webzen.
Bitte melden Sie sich an, um dieses Bild zu sehen.Bitte melden Sie sich an, um dieses Bild zu sehen.

Bitte melden Sie sich an, um diesen Link zu sehen.
Bitte melden Sie sich an, um dieses Medienelement zu sehen.

Please contact me via PM if you sell it.
Thanks.

meneleos · 18. Dezember 2017

th

meneleos · 26. August 2017

Zitat von AEL

The official languages of the board:The official languages of the board are german an english. Other languages must be translated to german or english.

sorry, auto translate problem
edited

meneleos · 26. August 2017

Hi.
Someone know ho to fix it ?

bt

Spoiler anzeigen

CNewPetSystem::Destroy (this=0x313dc380) at New_PetSystem.cpp:2549

2549: event_cancel(&m_pkNewPetSystemUpdateEvent);

C

void CNewPetSystem::Destroy()
{
for (TNewPetActorMap::iterator iter = m_petActorMap.begin(); iter != m_petActorMap.end(); ++iter)
{
CNewPetActor* petActor = iter->second;
if (0 != petActor)
{
delete petActor;
}
}
if (m_pkNewPetSystemUpdateEvent)
event_cancel(&m_pkNewPetSystemUpdateEvent);
if (m_pkNewPetSystemExpireEvent)
event_cancel(&m_pkNewPetSystemExpireEvent);
m_petActorMap.clear();
}

Alles anzeigen

event.cpp 218: ++(p->ref_count);

C

void intrusive_ptr_add_ref(EVENT* p) {
if (p)
++(p->ref_count);
}

meneleos · 22. Juli 2017

thanks

Beiträge von meneleos

[Free] Itemshop by sura_head

[Free] Itemshop by sura_head

Login crash problem

BUY RENDER TARGET SYSTEM

BUY RENDER TARGET SYSTEM

BUY RENDER TARGET SYSTEM

Crash game core

Crash game core

BUY RENDER TARGET SYSTEM

BUY RENDER TARGET SYSTEM

BUY RENDER TARGET SYSTEM

BUY RENDER TARGET SYSTEM

Special Storage

Event game.core problem

Event game.core problem

[RELEASE]Shoulder-Sash System with Scale Function v0.3 by LeNnT