i have made som updates in the wiki. If you found an issue then just send me a pm and i will fix the issue. If you found wrong informations then also write me a pm.

If you have some Style ideas for the wiki, let us know it.

Thanks!

Feel like helping with the project, Fork and submit a (PR)Pull Request, got something to say...
post it on commit comments, see someone on the forums having a hard time ... lend a hand. 

|Dev Note|  Posting to GitHub keep it clean, supportive, and on topic, otherwise comment it will be deleted.
                 Also keep in mind were not all experts at programming some are still beginners, here everyone
                 has a place.
                That is what the project is for (Educational Purposes), to help teach and  to help others
                   learn the selected art of code. There are other projects to use if you just wish to shine your epeen, and troll
                   others you deem under your coding level. On this project you shine by what you commit,
                and how you help others on this board.

                We Do not cater to pirate servers, if you need something made custom, go make it yourself,
                or wait until the sub-forum for custom patches for this core is  opened, hell you can even go
                hug google maybe what you need is there. and above all  manage to have some fun.

                ~Bootz

I know there hasn't been much activity lately. Been busy with family issues and running a successful business and all this is very time consuming. Now that my mom has passed an most of the estate issues are cleared up I can now devote more time and management to the project. This will not all happen overnight but I would like to make some major changes to the way we operate our project. I am open to new ideas and your input.

I have also took on some other community projects.
We now operate http://www.private-status.com for reporting quest status and http://www.yourpaste.tk. that is a pastebin website without all the bullshit.

Her is a brief list of changes that I would like to see done in the near future.

1. Overhaul the forum.
2. Rewrite the documentation.
3. Create a data repository for parsed sniff data.
4. Update the legacy 4.0.6a version to be compatible with the authentication server.
5. Better document the code.
6. Building a stronger and more diverse community for all users.
 

Also we are looking for community leaders.

1. Assistant project manager.
2. Lead forum moderator.
3. Documentation manager.
4. Sub forum moderators for locale community support for Spanish, Polish, Chinese, Japanese, Russian, & other languages.
5. Database content engineers. We are a teaching community so the requirements for this are the ability to learn MySQL.
6. C++ Code Contributor. Yet again we are a teaching community so all we ask is you are willing to do the research and do it proper.

 

Thank you for being a part of our community.

AlterEgo.

You will also notice some changes going on in the forums as well. Like all your avatars have been reset.  The forum will also be cleaned and rearranged to make more user friendly. 

Wiki is set to get an overhaul too.

 

The master branch is now 5.4.8 - 18291, a branch called 5.4.7 was created as an archive for the old version.

 

If you need any help, feel free to contact us on irc: irc.rizon.net in the channel #project_skyfire

 

Support for 5.4.7 has been dropped.

 

PS: Do not compain that we are no longer working on 5.4.7, it was our own choice and we are not your personal fixers.

When you make a bug report and you are using another DB other than SkyFire DB it will be closed. We can only troubleshoot our own problems with the core/db if it's ours.

By registering and participating in Project SkyFire Forums discussions you agree to the following code of conduct. If you are unable to agree you have the right not to participate in forum discussions at any time.

This is YOUR community. Most people have a common sense feel for what is and what is not appropriate in our forums and you folks generally do a great job of policing yourselves. We do, however, need to have a few set policies for everyone to refer to when the need arises.

While the administrators and moderators of this forum will attempt to remove or edit any generally objectionable material as quickly as possible where acceptable, it is impossible to review every message. Therefore you acknowledge that all posts made to these forums express the views and opinions of the author and not the administrators, moderators or web-master (except for posts by these people) and they will not be held liable.

You agree not to post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-orientated material or any other material that may violate any applicable laws. (Please note that the backyard has some additional rules specific to that venue.) Doing any of these may lead to you being temporarily or permanently banned from these forums (and your service provider may also be informed).

Posts which violate any part of this Code of Conduct may be edited or moved to a special holding area called "The Jail". Posts in The Jail are only visible to staff members and the original poster.

If you were to continue to break this code of conduct your account would be reviewed and you could be banned. It is the sole discretion of the forum resolution team (currently the administrators) to ban violating accounts. Accounts will not be deleted, although email addresses can be removed from accounts by request if the account is not going to be used any longer.

The IP addresses of all posts are recorded to aid in enforcing these conditions. You agree that the web-master, administrators and moderators of this forum have the right to remove, edit, move or close any post, topic or thread at any time they see fit following the guidelines outlined below. You agree that the web-master, administrators and moderators of this forum have the right to send a private message with a warning and/or censor any forum user who is in violation of forum policy* Be respectful of all users at all times.

This means please use etiquette and politeness. Treat people with kindness and gentleness. If you do this the rest of the code of conduct won't need more than a cursory mention.

• Respect the forum staff. We provide a service in our free time to keep the forums running efficiently. We will occasionally ask for input, but in some cases we will not, please respect our decisions. Also, we do edit for content, if you have an issue with our moderation, please open a request in the forum resolution center.
• Profanity: Remember that the forums are used by people of all age groups and of all tolerance levels regarding profanity usage. When in the support areas of the forum, please try to keep your language polite and courteous and refrain from the usage of profanities. In the General Discussion area, mild profanity/swearing is allowed in the context of general speech. Explicit profanity/swearing is not allowed, and under no circumstances will we allow any profanity to be directed toward another person. Please see the Project SkyFire Code of Conduct requirements to "Be Considerate" and to "Be Respectful" and the descriptions given there for more exact specifications. A language filter is in place to catch any profanities that you may have accidentally used. Do not attempt to circumvent the language filter by using variations or slight misspellings of profanities.
• Flaming and condescending messages: Flames are messages that personally attack, call people names, or otherwise harass another forum member (or any person). These, along with any generally condescending posts will be moved or removed at the moderators discretion.
• If the thread is flame-bait (appears to be intended to start an argument or is likely to cause an argument rather than enhance discussion), it will be locked or removed without notice. Individual flame-bait may be deleted or edited at the moderators discretion. Any users who continue to post in this manner or engage in other questionable practices, like trolling (posting in an attempt to engage people in arguments) may be subject to more serious sanctions.
• If the thread turns into an argument, it can be locked or removed without notice. Sometimes a moderator may split the thread or delete certain portions in order to keep the discussion going, but that is not always possible.
• If a post or thread contains spam (unsolicited advertising) it will be moved to the forum jail and the poster may be banned. Active users in good standing are allowed to have links to personal sites in their signatures, in their profile, and may post them in threads on occasion (just not often, please) as long as the content of those links does not include abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-orientated material or any other material that may violate any applicable laws.
• Adult Content/Violence/Illegal Activity: Messages containing sexually oriented/violent/illegal dialogue, images, content, or links to these things will be deleted. Messages with links to or suggesting illegal activity will also be deleted. Posting or linking to any of these could result in a ban.
• Thread Drifting/Steering: Please keep discussions on topic. Non-technical and non-3rd party project discussions belong in the General Discussion.

  Please remember that these forums are inclusive of ALL people, and we strive to maintain accessibility to everyone.

  Please strive to communicate with other users as effectively as possible.

• Please try to write your posts in English unless you are participating in a Localization Forum, where you are permitted to use another language if it is in common use in that Localization Forum and understood by the Localization Forum staff. We have many users from many different countries that visit here and English is the common language of these forums.

  When writing a post, please space paragraphs with a blank line in between them for better readability.

  Please do not write posts in all upper-case letters, as it looks as if you are screaming at the people reading your post.

  Please refrain from using "leet" speak or slang.* Please do not shorten your words to acronyms or abbreviations. It is very difficult to read and understand.

  Please use color and font properties for highlighting portions of your text, and not for all of the text in your post.

  Typos and other errors can cause miscommunication between users on the forums, please preview your text before posting.

• If you have found a post that you feel is inappropriate or that violates the forum code of conduct, please use the report post function. Do not attempt to moderate discussions or correct other users yourself.

  Please be prudent in your use of images; they may help to explain something more clearly or indicate a problem you are experiencing better but you have to remember that not everyone has the same bandwidth. If an image is the best way of handling the information, please keep your image to less than 100kb.

• Forum signatures are limited to three lines of text, 10pt maximum font size. Signatures are also not a place for inappropriate material such as attacks, slander, harassment, political or religious remarks. We regret that users are not allowed to use images in their signatures (see staff signature guidelines below in Section III for an exception to this policy). The use of political images in avatars is also prohibited.
• If you feel someone has violated the Project SkyFire Code of Conduct you may open a complaint with the administrators. However, forum related issues will need to be dealt with in the forums resolution center. The administrators will refer all forum-specific issues back to the forums resolution center.

  The web-master, administrators and moderators of this forum will preserve forum content when possible. However editing, locking and deleting content may be necessary and if so will be done at the discretion of the web-master, administrators and moderators when the forum code of conduct has been violated.

• Private Messaging users for support is strongly discouraged. It is also unlikely that users will respond to these requests.
• Users should only have one active account. If you feel you have justification for requiring a new account, please contact an administrator to discuss your situation. Users who have multiple accounts without approval of an administrator may be subjected to infractions or bans without notice.

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 error
• If 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:

Correct:

• Remember to use '' instead of a single apostrophe when writing texts, or there will be import errors.

Wrong:

Correct:

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)

You will need an IRC client to chat.

Join us today

Network - irc.rizon.net

Channel - #project_skyfire

Here is a list of clients.

mIRC

ChatZilla for FireFox

xChat

BitchX

Please follow the IRC Rules