Can anyone answer these questions for me?

[Travolta9924]

The following questions are about SQL

To understand these questions better you should install antrix database OBDB 1.4 (as of 26.06.2007) to see database structure etc..

1) Form a query that converts all accounts to NON-TBC accounts:
Extra info:
table name: accounts
field name and what it should be for NON-TBC: flags->0 (field type = integer)

2) Form a query that deletes all accounts that don't have a character saved on them:
Extra info:
table name for accounts: accounts
table name for characters: characters
accounts table account id field: acct (integer)
characters table account id field: acct (integer)

3) Delete all accounts that have the letter a in them and are not account id 1002 and 2840
accounts table account id field: acct
accounts table account name field: login

4) Delete all accounts that are last login from in April
accounts table last login date field: lastlogin (using date format: 2007-04-18 16:23:21)

III - Some C++ :
You can acquire the source code from svn://emupedia.com/svn/antrix/
Only one question here, if you can understand even what it does it's good, I dont expect you to write it
1) What does the red part mean, what does it do exactly.


uint32 dm = dmg.full_damage;
abs = pVictim->AbsorbDamage(0,(uint32*)&dm);

if(dmg.full_damage > blocked_damage)
{
dmg.full_damage -= blocked_damage;
uint32 sh = pVictim->ManaShieldAbsorb(dmg.full_damage);
if(sh)
{
dmg.full_damage -= sh;
if(dmg.full_damage)
CalculateResistanceReduction(pVictim,&dmg);//armor
dmg.full_damage += sh;
dmg.resisted_damage += sh;
}
else

CalculateResistanceReduction(pVictim,&dmg);//armor

dmg.full_damage += blocked_damage;
}


Taken from the melee hit in WORLD OF WARCRAFT. Sorry if it's difficult to understand, you can look this up on line 1112 in Unit.cpp in the source.

If you can answer them just reply in the thread.

Thanx

If you know some and not all reply with the ones you know

[MentaL]