Post by apihl1000 on Jul 30, 2012 19:18:56 GMT 10
In-Game Name: Apihl
Real Name: Andreas
Age: 15
D.O.B:15/10/1998
Location:Denmark
Timezone: GMT +1
Account Name:Apihl1000
Email:Apihl@hotmail.com
Skype:Kristoffer_er_navnet
Experience with SQL: I have been working on many servers and i know evrything in the DB
Level of skill (0-10): I would say 9
Experience in emulation: I guess i know most of it.
What emulator database structures you know best? Trinity, ArcEmu.
Make a query which Moves all NPCs whit flag 5 from map ID: 5 to map ID: 10
UPDATE `creature_spawns` SET `map`=10 WHERE `flags`=5 AND `map`= 5; (ArcEmu)
Show example of your work (use pastebin & link)
pastebin.com/yJiG1FRr ArcEmu <--- Pure Opness
What is wrong with this SQL:
[glow=red,2,300]insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
values ('50001', "Application", "Adapt WoW", '', '0', '3', '33', '1', '0', '0', '503', '0', '0', '0', '1', '1', '0', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('50001', '1', '1', '14', '0', '100', '1', '0', '1000', '0', '1', '10', '0', '0', '0', '0', '25000', '100', '0', '0', '0', '0', '0', '0', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');[/glow]
Civilian and Leader WTF! xD
Do you use mercurial (y/n):No
Do you use patch queue (y/n):No
Other Skills you have: C++
Level of that skills: from 1-10 i would say 5. I know how to make you level 255 in c++, remove Stat Cap, and more!
Guess Who I'm back!
Real Name: Andreas
Age: 15
D.O.B:15/10/1998
Location:Denmark
Timezone: GMT +1
Account Name:Apihl1000
Email:Apihl@hotmail.com
Skype:Kristoffer_er_navnet
Experience with SQL: I have been working on many servers and i know evrything in the DB
Level of skill (0-10): I would say 9
Experience in emulation: I guess i know most of it.
What emulator database structures you know best? Trinity, ArcEmu.
Make a query which Moves all NPCs whit flag 5 from map ID: 5 to map ID: 10
UPDATE `creature_spawns` SET `map`=10 WHERE `flags`=5 AND `map`= 5; (ArcEmu)
Show example of your work (use pastebin & link)
pastebin.com/yJiG1FRr ArcEmu <--- Pure Opness
What is wrong with this SQL:
[glow=red,2,300]insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
values ('50001', "Application", "Adapt WoW", '', '0', '3', '33', '1', '0', '0', '503', '0', '0', '0', '1', '1', '0', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('50001', '1', '1', '14', '0', '100', '1', '0', '1000', '0', '1', '10', '0', '0', '0', '0', '25000', '100', '0', '0', '0', '0', '0', '0', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');[/glow]
Civilian and Leader WTF! xD
Do you use mercurial (y/n):No
Do you use patch queue (y/n):No
Other Skills you have: C++
Level of that skills: from 1-10 i would say 5. I know how to make you level 255 in c++, remove Stat Cap, and more!
Guess Who I'm back!