[DEV V Rev 12] Redeem Itemmall
Posted: Sat May 24, 2014 3:19 pmif it is 'redeem' the item mall is taking all the items to the inventory, I use the following code:
- bool CWorldServer::pakPremiumRedeem ( CPlayer* thisclient, CPacket* P )
- {
- MYSQL_RES *result = GServer->DB->QStore("SELECT COUNT(*) FROM mileage WHERE owner='%i'", thisclient->Session->userid);
- if(result==NULL) return false;
- MYSQL_ROW row = mysql_fetch_row(result);
- int numrow=atoi(row[0]);
- GServer->DB->FreeResult( );
- if (numrow==0)
- {
- BEGINPACKET ( pak, 0x819 );
- ADDBYTE ( pak, 7 );
- for(byte i=0;i<3;i++){
- ADDDWORD ( pak, 0);
- }
- ADDWORD ( pak, 0);
- thisclient->client->SendPacket( &pak );
- return true;
- }
- int qty;
- int slot;
- for (int i=0; i<numrow; i++)
- {
- result = GServer->DB->QStore("SELECT count,slotnum FROM mileage WHERE owner='%i' LIMIT 1", thisclient->Session->userid);
- MYSQL_ROW row = mysql_fetch_row(result);
- qty=atoi(row[0]);
- slot=atoi(row[1]);
- GServer->DB->FreeResult( );
- TakeItemMallList(thisclient,qty,slot);
- GServer-DB->Query("DELETE FROM mileage WHERE owner='%i' AND slotnum='%i'", thisclient->Session->userid,slot);
- }
- return true;
- }