Faza e ca am reusit in trecut sa pun functia asta pe un svfile vechi, dar din pacate nu mai gasesc svfile-ul si nici functia.
Asta e in cmd_general.cpp:
Cod: Selectaţi tot
ACMD(do_daily_reward_get_reward){
if (!ch)
return;
char* items;
char* counts;
DWORD item;
DWORD count;
bool reward = false;
char* rewards;
// 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() limit 1",rewards));
SQLResult * pRes2 = pkMsg2->Get();
if (pRes2->uiNumRows > 0){
MYSQL_ROW row;
while ((row = mysql_fetch_row(pRes2->pSQLResult)) != NULL){
items = row[0];
counts = row[1];
}
}
str_to_number(item, items);
str_to_number(count, counts);
ch->AutoGiveItem(item, count);
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());
}
ch-> ChatPacket (CHAT_TYPE_INFO, LC_TEXT ("Poti revendica doar un premiu pe zi"));
}
Daca ma poate ajuta cineva, raman dator!
de 
de