Daily rewards System

[Thoraxx]

AD: Mt2009 - Mobile & PC - 30 January 2026 CHECK THE PRESENTATION!

thx

 

[Mountain]

Thank you

 

[mrzewa123123]

thx

 

[lebanana]

If anyone wants that system gives all rewards other than just one;

ACMD(do_daily_reward_get_reward) {
if (!ch)
return;

char* rewards;
bool reward = false;

// and (NOW() - interval 30 minute > time)
SQLMsg* pkMsg(DBManager::instance().DirectQuery("SELECT reward from player.daily_reward_status where (NOW() > time) and pid = %u", ch->GetPlayerID()));
SQLResult* pRes = pkMsg->Get();
if (pRes->uiNumRows > 0) {
MYSQL_ROW row;
while ((row = mysql_fetch_row(pRes->pSQLResult)) != NULL) {
rewards = row[0];
}
reward = true;
}

if (reward) {

SQLMsg* pkMsg2(DBManager::instance().DirectQuery("SELECT items, count FROM player.daily_reward_items WHERE reward = '%s' ORDER BY RAND()", rewards));
SQLResult* pRes2 = pkMsg2->Get();
if (pRes2->uiNumRows > 0) {
MYSQL_ROW row;
while ((row = mysql_fetch_row(pRes2->pSQLResult)) != NULL) {
char* items = row[0];
char* counts = row[1];

DWORD item;
DWORD count;
str_to_number(item, items);
str_to_number(count, counts);

// Give the item to the player
ch->AutoGiveItem(item, count);
}
}

// Update reward status for the player
DBManager::Instance().DirectQuery("UPDATE daily_reward_status SET reward = CASE WHEN reward = 0 THEN '1' WHEN reward = 1 THEN '2' WHEN reward = 2 THEN '3' WHEN reward = 3 THEN '4' WHEN reward = 4 THEN '5' WHEN reward = 5 THEN '6' WHEN reward = 6 THEN '0' END, total_rewards = total_rewards + 1, time = (NOW() + INTERVAL 1 DAY) WHERE pid = %u", ch->GetPlayerID());
}
else {
ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("You can't recive the reward yet"));
}
}

You're welcome =)

 

[google222222]

View attachment 1515


[Hidden content]​

looks amazing!