AriDEV

or u can simply CHECK the box in cmake WITHOUT_GIT

I allready see AlterEgo Turning into an EVIL! Â

u dont need to copy a character to ptr. since 541 u can create a free to play lvl 90 char on ptr servers.  since 547 u can buy a level 90 char for 50€ on live servers.

@sovak and who cares? if u are playin on the 5.4.7 u could implement the pandaria stuff in your 5.4.1 branch then we could merge it to the 5.4.2 branch but no u better stop working and waiting for 1and half months like a dumb kido that has a high Ego... but what ever i shared my snifer and waiting til 6xx ... and ye i will not be a bad ass like u i will help with commits...

5.4.7.17807 ON PTR! Â PATCHNOTES: Â 17807 - http://www.wowhead.com/news=227262/5-4-7-ptr-patch-notes

As first im SRY to all devs that i ruined the skyfire team :/  @Sovak sry that i started to work on 542 before S15 realeased...! @AlterEgo u could say that u dont want the work on 542 and u didnt need to merge 542 branch to master! @Fabian im sry that im so arrogant to u, but u started to provocate! @Raknar i didnt even know that u a skyfire developer i dont even know u so how can u be mad on me?  @caffeine was funy time  @Rawaho nice job, nice teamwork, u got potential  Thanks Sovak for opening me the eyes how evryone is cursing about me. Thats why im done here.     Â

we are allready working on 542 check from 5xx repo the 542branch

Welcome to the community :)

Small Patch Post Explain: How To Post Creature Or Gameobject Spawns: Example: -- NAME <SUBNAME> SET @NAMEGUID=XXX; DELETE FROM creature WHERE id=49748; INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType, npcflag, unit_flags, dynamicflags) VALUES (@NAMEGUID, 49748, 0, 1, 1, 0, 4981, -8847.35, 569.835, 94.6879, 2.86978, 300, 0, 0, 713, 0, 0, 0, 0, 0, 0), (@NAMEGUID+1, 49748, 0, 1, 1, 36597, 49748, -4938.35, -917.995, 501.743, 5.3058, 300, 0, 0, 232470, 0, 0, 0, 0, 0, 0), (@NAMEGUID+2, 49748, 0, 1, 1, 0, 49748, -8826.54, 631.48, 94.4498, 4.05418, 300, 0, 0, 3, 0, 0, 0, 0, 0, 0);How To Post Npc Vendor Data Example: -- NAME <SUBNAME> SET @NAMEVENDOR=xxx; DELETE FROM npc_vendor WHERE entry=@NAMEVENDOR; INSERT INTO npc_vendor VALUES (@NAMEVENDOR, 0, 2325, 0, 0, 0), (@NAMEVENDOR, 0, 6260, 0, 0, 0), (@NAMEVENDOR, 0, 2320, 0, 0, 0);The XXX Is Always ID From SkyFire DB TEAM, Also U Can Add There XXX More Will Comming

IMPOSIBLE FROM WOWHEAD!! But With a Sniffer U Can Get It :)

HOW TO GIVE YOUR CONTRIBUTION TO THE SKYFIRE DATABASE PROJECT: It is most important that suggested fixes in this section do not take an enormous amount of time to check and test, otherwise they are useless if they take up as much time as writing them from scratch by a Dev (hence also a waste of time for you suggesting the fix). METHOD: All the fixes should be done in a "New Ticket" on our tracker: http://www.projectskyfire.org/bugtracker Before being able to a do a ticket you need to register, it's simple: http://www.projectskyfire.org/bugtracker/signup_page.php If any aspect of the following method is not PRECISELY followed, your ticket might be deleted. DO NOT WASTE DEVS' TIME AND YOUR TIME: Use the search function to see if the fix you want to provide hasn't already been posted or already accepted and comitted. Use multiple words search if necessary, do not stop at the first attempt just because the search engine does not return any result. (Search both on the forums and on the tracker)Always state the SkyFire Rev you are using, make sure you are using the latest SFDB release and state any addon you are using.Cross-check a bug you found with a clean world DB. Any custom addition or change you may have done on your DB could cause your bug, you never know.Always state the source of your fixes (website, offy account, another project, etc) and provide as many links or details as possible. Always pretend that the Dev reading doesn't know the quest/npc/etc you are trying to fix. MAKE YOUR FIX USEFUL: Always comment your queries for better understanding with the -- format.The ticket will not support too many queries. Attach a link to a sql file to your ticket whenever necessary.DO NOT leave more then 1 space between values or field names.Any INSERT INTO query must be preceded by a DELETE query to prevent import errors. Always write the fields in the query to better trace any structure change and adapt your fix to newer core revs.If you are modifying an existing line, use an UPDATE query. We do not delete and re-insert a full line just to modify a few fields. Be as precise as you can to make sure your query updates ONLY the line expected.If you are writing a text, make sure you use '' instead of ' when writing an apostrophe or it will give an import errorIf you are providing an SQL query fix, please advise if it has been tested or not (be honest). Others might then test it for you and give feedback, this is a Community work! If you have tested your own work.DO NOT CHANGE ANY WDB FIELD! TICKET EXAMPLE: Category: Loot Summary: [iTEM] Broken Longbow (Patch/Fix) Priority: Normal Severity: Minor Description: Missing from Abjurist Belmara's loot Core: b77ae2fd2d7dd81d110674e8ef265db56090dd9d Database: SFDB 11_06_04 Addons: Anticheat 1 Abjurist Belmara should drop Broken Longbow but doesn't. Additional Information: Patch/Fix: http://projectskyfire.org/pastebin/index.php?show=24 Source: http://www.wowhead.com/item=25406 CONCLUSION: Use the wiki to learn more about the DB structure. Although new things are added more quickly than the wiki is updated to explain them, it is very very useful. We will be very harsh if we realise that a suggested fix is just a copy-paste from another project without linking the original post. We do not tolerate leeching. Credits must always be given. Finally, thank you, because if you are reading this it means you really care about helping and wish not to waste the Devs' time! EXAMPLES: Note: This may not be a working code, it is used for this thread as an example. Notice how table and field names are not included in `` symbols, and how values are written plainly, only texts are included in '' symbols. Delete before insert into and always put fields in the query. Wrong: INSERT INTO creature_loot_template VALUES (19546,25406,24,0,1,1,0,0,0);[/SQL] Correct: [SQL] -- Add item Broken Longbow to Abjurist Belmara loot in Netherstorm DELETE FROM creature_loot_template WHERE entry=19546 AND item=25406; INSERT INTO creature_loot_template (entry, item, chanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) VALUES (19546, 25406, 24, 1, 0, 1, 1, 0, 0, 0);[/SQL] Make sure your update queries are precise. You might and up changing more lines then you thought of. Wrong: [SQL]UPDATE creature_loot_template SET ChanceOrQuestChance=100 WHERE item=25406;[/SQL] Correct: [SQL] -- Changing droprate for Broken Longbow dropped by Abjurist Belmara from 24 to 100. UPDATE creature_loot_template SET ChanceOrQuestChance=100 WHERE entry=19546 AND item=25406;[/SQL] Remember to use '' instead of a single apostrophe when writing texts, or there will be import errors. Wrong: [SQL]UPDATE page_text SET text='Hello Morgan, you shouldn't be here' WHERE entry=15;[/SQL] Correct: [SQL]-- Correcting text for item William's Shipment. UPDATE page_text SET text='Hello Morgan, you shouldn''t be here' WHERE entry=15;[/SQL] SIDENOTES: Remember that a query must always end with a semicolon( ; ). In general, always import your own queries into you DB to check if there are any import errors and also any startup errors! Various authors (H3ad3r, AriDEV) Template (TrinityCore)

Hi Its Me Ari. DB DEVELOPER.