Post by lewis on Dec 16, 2013 23:28:41 GMT 10
Personal Details;
Real Name: Lewis Welch
Age: 19
Location: London
Timezone: GMT+0
Nicknames: Just lewis, again.
Email: cerealdoctor@gmail.com
Skype: lewiswelch123
Adapt WoW Account Details;
Account Name: N/A
Join Date: N/A
Characters on Adapt WoW(Name,Played Time): N/A
Progression within Adapt WoW (E.g. reached level 255, completed some quests to obtain new gear etc.): N/A
For SQL Developers;
Experience with SQL: 1-2 years of administration experience at Uwow, Using Sql to fix accounts/Make items/make New areas/new npc/new quests ect
Level of skill (0-10): 7-8
Experience in emulation: 6 yeats.
What emulator database structures do you know best?: Trinity/Arcemu
Please provide an example of your work (use pastebin): Arcemu I haven't used any in years, but ill attach my Trinity Sql work ive made recently for the server im using to currently test on. (Its my old uwow server source, on my computer)
What is wrong with the following queries?;
[I've edited them personally]
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('95003', "Weapon Trainer", "Learn all Weapon Skills", '', '0', '10', '0', '0', '0', '0', '26770', '26770', '26770', '26770', '1', '1', '0');
insert into `creature-proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `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`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell`, `spell3`, `spell4`, `spell_flags`, `modImmunities`, `summon_guard`)
values ('95003', '255', '255', '35', '560000', '560000', '0', '1', '0', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0', '1');
;
Which SQL tool do you use?: HeildiSql, Can use navicat if needed
Other Skills you have?: Ability to make items/npc without WoW-V
Level of those skills: 7-8
.
Real Name: Lewis Welch
Age: 19
Location: London
Timezone: GMT+0
Nicknames: Just lewis, again.
Email: cerealdoctor@gmail.com
Skype: lewiswelch123
Adapt WoW Account Details;
Account Name: N/A
Join Date: N/A
Characters on Adapt WoW(Name,Played Time): N/A
Progression within Adapt WoW (E.g. reached level 255, completed some quests to obtain new gear etc.): N/A
For SQL Developers;
Experience with SQL: 1-2 years of administration experience at Uwow, Using Sql to fix accounts/Make items/make New areas/new npc/new quests ect
Level of skill (0-10): 7-8
Experience in emulation: 6 yeats.
What emulator database structures do you know best?: Trinity/Arcemu
Please provide an example of your work (use pastebin): Arcemu I haven't used any in years, but ill attach my Trinity Sql work ive made recently for the server im using to currently test on. (Its my old uwow server source, on my computer)
What is wrong with the following queries?;
[I've edited them personally]
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('95003', "Weapon Trainer", "Learn all Weapon Skills", '', '0', '10', '0', '0', '0', '0', '26770', '26770', '26770', '26770', '1', '1', '0');
insert into `creature-proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `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`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell`, `spell3`, `spell4`, `spell_flags`, `modImmunities`, `summon_guard`)
values ('95003', '255', '255', '35', '560000', '560000', '0', '1', '0', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0', '1');
;
Which SQL tool do you use?: HeildiSql, Can use navicat if needed
Other Skills you have?: Ability to make items/npc without WoW-V
Level of those skills: 7-8
.