Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 02/06/2011 in all areas

  1. http://skystudio-editor.tk/"]Skystudio is a database editor which aims to be compatible with Project Skyfire I started a few months ago. It can fully create or modify Creatures, Game-objects, Quests and basic Loot + much more soon! Finally, the first stable release is out  While you're here, like my Facebook page. Download: - http://www.mediafire.com/?2tt5rgrcre50as5"]Mediafire - Check the site often for Executable and Data updates! If you require more details; check the website. Try it out and don't forget to post back Enjoy. Some screens: - Login; Yes, It has offline mode ! - Quest - Editing a vendor; Import can pull vendor data off wowhead! - Full Creature editor; Auto Mod calculators, Import from wowhead, random stat generator for quick customs. Works like a charm
    13 points
  2. We are dropping support for SkyFire one and SkyFire 4.0.6a to focus on the current patch "5.4.8" and also to work on the upcoming "6.x.x" Versions. 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.
    11 points
  3. DISCORD CHAT SUPPORT: https://discord.gg/MXvtaCH4nd CORE SOURCES: 4.0.6a core source and Bug tracker. NO LONGER SUPPORTED! https://github.com/SkyFireArchives/SkyFireEMU_406a 5.4.8 Core Source SUPPORTED https://github.com/ProjectSkyfire/SkyFire_548 DATABASE: Database files are only downloadable by forum members. https://github.com/ProjectSkyfire/database/releases WIKI: http://wiki.projectskyfire.org RECOMMENDED FILE SERVICES: Dropbox -- https://db.tt/Zw76Fr6
    8 points
  4. Event Horizon (121) - SAI Editor Event Horizon is a tool for scripting creatures through smartAI. Â While you're here, like my facebook page. Web: http://devsource-eventhorizon.tk/"]http://devsource-eventhorizon.tk/ Download: http://www.mediafire.com/?nbhxmlla0a5gi5q"]http://www.mediafire...nbhxmlla0a5gi5q VirusScan: http://virusscan.jotti.org/en/scanresult/672dbc9f08e67a218def45c06b1d4a03fc419c3d"]http://virusscan.jot...b1d4a03fc419c3d Remember to Install the latest Java RE ( http://www.java.com/"]http://www.java.com/ ) Some Features Script Creatures or Gameobjects using SmartAI without the knowledge or use of SQL or any other languages or DBMS's (e.g phpmyadmin,heidiSQL).Built in tools and references removes the need to manually calculate bitmasks or lookup smartAI functions or parameter names and id's.Running on the java virtual machine gives Event Horizon amazing portability and it can work on almost any operating systems!SQL generation makes it possible to export and distribute or to archive and backup your work.Fully compatible with any core which supports smartAI. However it was specifically written for Trinitycore and Project Skyfire.Can connect to local or remote databases.Screens:
    8 points
  5. SkyFire

    Back to 5.x.x

    We decided to resurrect our 5.x.x core due to TC deciding to work on 6.x.x. It's still a great expansion to play around on.
    7 points
  6. We are pleased to announce limited support for Mists of Pandaria 5.4.7 Build: 18019. Please submit constructive bug reports in the bug tracker so we may compile a list of stuff to fix. DO NOT USE THE FORUM AS A BUG TRACKER The GitHub repository has a bug tracker.
    6 points
  7. Does this look like the forum for Arkcore? Go ask those fucktards for help with there copy/pasted shit. Â
    5 points
  8. Section I - General Policy: 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.
    5 points
  9. socra2

    5.4.8 Limited Support

    We are pleased to announce limited support for Mists of Pandaria 5.4.8 Build: 18291. Please submit constructive bug reports in the bug tracker so we may compile a list of stuff to fix. DO NOT USE THE FORUM AS A BUG TRACKER The GitHub repository has a bug tracker.  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.
    4 points
  10. Here at Project-SkyFire work on the core/databases are for open educational &learning purposes, using this project anywhere past that is end-user, and is out of our hands, and not our responsibility. Privately hosted servers isn't allowed to be talked about on our projects forum.. and are not supported here, this goes for binary distributed releases (aka.repacks) of any form. these would be all be considered end-user dist. and up to them solely for updates. Forum Rules threads of these kinds will be closed, if found discussing any thing in these regards.
    4 points
  11. Section III - Forum Staff Policies and Expectations: Staff duties are based upon the following Dealing with Profanity: 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. If you feel a user is out of line please contact an administration with the details, they will issue a warning to the user.Dealing with spam and potential "jailed" posts: If its a user trying to advertise something move the post to the jail and issue a spam infraction. Posts that are used to flame, harass or harm another person should be reported to an administrator asap. We do not encourage staff to partake in conversation in these types of situations and the administration will handle the issue.Editing of posts: When a post breaks guidelines and requires editing in order to bring it back under compliance with the rules, the moderator should generally copy the un-edited post to the jail first or issue an infraction which will keep a copy of the original post in the staff area. Only then should the original post be edited after the original content was preserved as evidence. In the private message automatically sent when the infraction is issued the moderator should specify or describe which guideline(s) the post did not follow.Thread Closing: If a thread has run it's course and posts have begun repeating themes a thread may be closed - if possible, announce that the thread has run it's course before closing so that people may add closing statements - don't forget to thank all users involved in the discussion. If a thread has become a situation where people are simply too personally involved in the issue a thread may be closed and / or jailed. If a thread is a duplicate of another thread, it may be closed (please provide a link to another open thread on the same topic.) It is always a good idea to post an explanation in a thread that is closed.Jailing of posts/thread: If a post/thread would require a lot of work to bring it into compliance, or if editing the violations would result in a nearly blank post/thread, the post/thread should be moved to the jail instead.Adult Content/Violence/Illegal Activity: Messages containing offensive / sexually oriented / violent / illegal dialogue, images, content, or links to such will be moved to the backyard or jailed depending on the information it contains, use your best judgement. Messages with links to or suggesting illegal activity will soft deleted by an administrator. These actions could result in a ban for the user.RTFM/I hate SkyFire/I hate Ascent threads: As the community has grown these types of threads seem to be more prominent. We need to make sure we can try to steer these conversations into a positive discussion, however in many cases these threads will only end in hurt feelings and will be locked. If the thread cannot be steered into a clean discussion the staff member who locks it needs to be fully supported by staff.Thread Steering: It will become necessary to steer threads away from becoming damaging towards the poster and other users. Our policy is that we do not allow threads to veer too far off topic, even in community chat, to areas where it would be very easy to get ugly fast; for example, "I hate Ascent" threads. Please do your best to keep posters from getting too personal during heated debates.Keeping an open mind: Sometimes you will be faced with a thread you might not agree with it's imperative you keep an open mind towards all inclusive people, and keep a neutral focus when replying. It is our duty to steer the conversations back into a positive nature without engaging in negative behavior.Posting and moderating in the same thread: This is generally discouraged. If you have participated in a discussion and later find there is a problem in the thread contact the other staff and have someone else who is uninvolved moderate. The exception would be if no one is available, you can close the thread temporarily with a post stating that it will be looked at by a non-involved staff member as soon as possible. If you aren't sure what to do, get an administrator.Signatures: While we do not have guidelines for staff signatures, please try to keep them moderate and within reason. Staff are chosen by the site administrators. Users who have demonstrated a consistent attitude of friendliness and kindness and who have shown a pattern of helpfulness in their posts may be contacted and invited to serve in an even more official manner. Recommendations can be made by current staff in the staff forums or other users by private message. All recommendations are considered. Due to time constraints and privacy issues the administrators are unlikely to comment publicly on these recommendations. It should be noted that, like all things, this code of conduct will continue to change and evolve with constructive feedback from users and from experience. It is our hope that these policies will create open, honest, and civil discussion. As always, we welcome feedback about any concerns that you may have so feel free to post in the forum feedback section of the forums. It is the users responsibility to check this page for updates. We require that the forum code of conduct be followed at all times since this is an official SkyFire resource. Public forum data is released under the GNU Free Documentation License.
    3 points
  12. Section II - Technical Support Policies: When asking for technical support: * There are no stupid questions. You're not a stupid person simply because you do not know how to do something, or do not have the answer to a question. Everyone was a green user at one point in time. * Try to give information in the title of your post, instead of using a title like "it's broken," use a title that is specific, such as, "Unable to get sound to play in World." A clear title will attract more views to your thread, as it gives a clear indication of the content of the post to the people that are willing to help you. Ultimately this will allow you to get more help of a better quality. * Searching the SkyFire Forums is a quick way to see if someone has had your issue and if it has been answered. In a forum as large and active as this one, there's a good chance your question has been answered before, and you can get the information you want quickly. * When requesting help, please include as many details as you can. Include as much information as you know. If people are asking for version numbers, consider checking the sources to find out specific information about the revision you have installed. For example, if you're having trouble with SkyFire, you can search in your Git log and look up the revision hash using git to give the people helping you more information. If you do not know how to find out the information that a user is requesting of you, you might want to ask them how to find the information they have requested. Attach screen shots or other files if you think it might be useful. * It's always nice to let the people that help you know that you appreciate their help. It's extra nice if you then share that information to another user that has the same question you just had. If your question is resolved (which is hopefully always the case!), it would be helpful for other users and the people helping you to label which procedure worked for you by quoting or clearly referring to it. Giving feedback as to what procedures worked not only makes the person helping you feel a sense of accomplishment, you will also be helping any other user with your same issue searching for an answer. When answering technical support issues: * Be considerate to the person asking the question. We were all a green user at one point. Yes, some users are harder to help than others, but please be respectful to all users. * Try to avoid acronyms and jargon when giving instructions. New, or "green" users may not be able to follow you, and many will not ask you for an explanation in order to avoid looking stupid. RTFM, "Go look on google" are two inappropriate responses to a question. If you don't know the answer or don't wish to help, please say nothing instead of brushing off someone's question. Politely showing someone how you searched or obtained the answer to a question is acceptable, even encouraged. * If the users question has been covered in one of the community documents, please give them a description and the links. Some useful sites to point green users are: https://github.com/ProjectSkyfire. You can also show the user how to search the forums or tell them about the forum search utility. If you wish to remind a user to use search tools or other resources when they have asked a question you feel is basic or common, please be very polite. Any replies for help that contain language disrespectful towards the user asking the question, i.e. "STFU" or "RTFM" are unacceptable and will not be tolerated. * Always assume the the user has a default installation unless you're told otherwise. If you tell people to use an application outside of the official SkyFire installation, please give instructions on how to install it. * Always assume that the user is a green user unless you're certain the user is not. Please remember to give detailed instructions some users do not know how to get to a terminal yet. * To avoid confusion and auto-formatting issues, please use CODE tags around terminal commands. If an image speaks a thousand words and can show exactly what you mean, by all means, include an image. * Please wrap long outputs from commands or other text to prevent users from needing to scroll through the content inside CODE tags. * Please remember to do things the SkyFire way. There are always more than one solution to a problem, choose the one you think will be the easiest for the user. Try to think as a green user and choose the simplest solution. * Explain each step of the solution. If possible, try to teach the user while giving a solution to them. Teaching begets more teaching. * If you're uncertain if a procedure is correct, please tell users so. If your procedure has inherent risks, please tell users what they are. For example, if you're teaching someone how to change a database table, please include a disclaimer that it MAY occasionally cause data loss. * Replies to questions that ask for help running legitimate software (albeit closed source or proprietary) that do not answer the question, but instead instruct the user that they should not be using that software on the grounds that it is not free serve only to frustrate and confuse the user and will be removed to make room for answers to the question the user asked at the moderator's discretion. The goal of this forum is to first provide technical assistance and then to educate users on the benefits of free software.
    3 points
  13. bootz

    SFO - 2.4.3

    From out of the Ashe s, our TBC core has re-emerged, and is now back on the supported cores list. this core is still in limited support phase, until the code has been caught up and stable. When core is given full community support, the community forums section will be re-opened, as well as a bug-tracker. Until then Project is @ our Projects GitHub pages and the public Db is in the downloads section. 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
    2 points
  14. Oi,  I've started working on a SAI-Editor for TrinityCore a couple of months ago using C# with the .NET 4.5 framework (which means it's Windows only as I'm not bothering with Mono). The application is, of course, opensource.  Download & screenshots: http://www.trinitycore.org/f/files/file/17-sai-editor/ GitHub: https://github.com/Discover-/SAI-Editor   Discover-
    2 points
  15. Due to some recent abuse of our kindness all users must make account to view the forums. Guests will no longer be permitted to view the forums. If you have any trouble creating an account or receiving an conformation e-mail. Just send a message to admin@projectskyfire.org.
    2 points
  16. Fucking spammers. Guests can no longer post content reports. Thanks assholes for trying to exploit the moderators to clicking on your links to malware sites. Rot in hell!
    2 points
  17. I took the last one. Â You have to drag and drop your wow.exe or wow-64.exe on the connection patcher.exe. The console pops again up but this time it won't disappear and you will see whether it worked or not.
    2 points
  18. Use pull requests, i rarely get time to go into the forums patch section. but since the DBT(DataBaseTeam) is all tied up atm with IRL shizle, i would suggest, to add the PR to main repo, i'll see that fastest, and can test/merge it best that way. The DBT we have is not dead.. its just terminally inactive, like a valedictorian with down syndrome. definitely one reason the split repo wasn't a good plan (imo) ... but with the plagiarism bullshit and drama mostly caused by outside emu's and them trying to build there community base by either bashing or degrading(privately or offsite), and ofc feeding from the negative attention that was brought from us publicly and directly confronting and in some cases, nuking that type of competition or agitation. either way it was the reason most of our main developments went to private team developments until releases were ready. i for one am ready to go back to the one core, one db, one repo law... but i really don't butt my nose into DBT's affairs, not my place to. would really like to see the day when we all can get along again and work on one project, the death of Cataclysm Emulation, was everyone splitting off and doing there work privately, or split from the main core and community. and not sharing there work.
    2 points
  19. bootz

    Self-Help Ebooks | SQL

    K ive gotten alot of the primary ebooks all in one spot (not all of them ofc, ive got more organizing to do with the other 2 gigs of this sort) but here it is all in one link GL. hope to see more ppl active with project and willing to test/learn/ show\ there skills. CLICK HERE FOR LINK
    2 points
  20. bootz

    Self-Help Ebooks | C/C++

    K ive gotten alot of the primary ebooks all in one spot (not all of them ofc, ive got more organizing to do with the other 5 gigs of this sort) but here it is all in one link GL. hope to see more ppl active with project and willing to test/learn/ show\ there skills. CLICK HERE FOR LINK
    2 points
  21. If I could offer one piece of advice to the planet, it would be this: Don't marry for looks alone, and I'll tell you why. In a few years, when Barbara's boobs start sagging, she can get plastic surgery, have them lifted, move the nipple wherever. You can actually go to a titty bar, pick out a set of titties and say, "I want those titties on that woman." If her belly gets too big, she can get a tummy tuck and have a belly like a cheerleader. If her vision goes bad, you can have LASIK surgery and have 20/20 vision. If her hearing goes bad, they can install a device in her ear that will give you hearing as clear as it was the day you were born. But let me tell you something, folks: You can't fix stupid. There's not a pill you can take; there's not a class you can go to. Stupid is forever.
    2 points
  22. Diantonix

    [PHP] Utilities

    Config: <?php $port = "3306"; $host = ""; $user = ""; $pass = ""; $characters = ""; $auth = ""; $cod = 'utf8'; ?> Register <?php $realmd = array( 'db_host'=> 'localhost', // Host IP 'db_username' => 'root', // Database login-name 'db_password' => 'mangos', // Database login-pass 'db_name_realm'=> 'realmd', // Database name of realm ); function check_for_symbols($string) { $len=strlen($string); $allowed_chars="abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; for($i=0;$i<$len;$i++)if(!strstr($allowed_chars,$string[$i])) return TRUE; return FALSE; } function sha_password($user,$pass) { $user = strtoupper($user); $pass = strtoupper($pass); return SHA1($user.':'.$pass); } if ($realmd[db_host] != "" && $realmd[db_username] != "" && $realmd[db_password] != "" && $realmd[db_name_realm] != "") { $new_connect = mysql_connect($realmd[db_host],$realmd[db_username],$realmd[db_password]); if ($new_connect) $selectdb = mysql_select_db($realmd[db_name_realm],$new_connect); else { echo "Could NOT connect to db: Configs (Name/Pass/Port/IP) are incorrect"; die; } if ($new_connect && !$selectdb) { echo "Could NOT connect to db: Database does not exist!"; die; } if ($_POST['registration']) { $username = $_POST['username']; $password = sha_password($username,$_POST['password']); $expansionnumber = $_POST['expansion']; $check_username = mysql_query("SELECT username FROM `account` WHERE username='$username'"); if ($username == "") { echo "Field username is empty!"; } else if ($password == "") { echo "Field password is empty!"; } else if (check_for_symbols($_POST[password]) == TRUE) { echo "Error with creating account: password has invalid symbols in it."; } else if (check_for_symbols($username) == TRUE) { echo "Error with creating account: username has invalid symbols in it."; } else if (mysql_num_rows($check_username) != 0) { echo "Error with creating account: name is already in use."; } else { $username = mysql_real_escape_string($username); mysql_query("INSERT INTO account (username,sha_pass_hash,expansion) VALUES ('$username','$password','$expansionnumber')"); if (mysql_error) echo mysql_errno($new_connect) . ": " . mysql_error($new_connect). "\n"; else { echo "Account created."; mysql_close($new_connect); } } } else { ?> <html> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST"> Username <input type="text" name="username"> Password <input type="password" name="password"> Expansion Selection<select name="expansion"> <option value="1">Vanilla</option> <option value="2">TBC</option> <option value="3">WotLK</option> </select> <input type="submit" name="registration"> </form> </html> <?php } } else echo "Config file either not present or connection variables are empty"; ?> Top honor: <?php include ("config.php"); $connect = mysql_connect($host,$user,$pass) OR DIE("'Can't connect with $host"); mysql_select_db($characters,$connect) or die(mysql_error()); $result = mysql_query("SELECT * FROM `characters` ORDER BY `totalKills` DESC LIMIT 0 , 100 "); ?> <font color=#000000> <table align=center cellpadding="0" cellspacing="0" border="1" width=100%> <thead> <td width="4%"><center>Nº</center></td> <td width="16%"><center>Character Name</center></td> <td width="4%"><center>level</center></td> <td width="5%"><center>Honor</center></td> <td width="4%"><center>Kills</center></td> </thead> <tbody> <?php while($rows = mysql_fetch_object($result)) { $i++; $name = $rows->name; $level = $rows->level; $Total_Kills = $rows->totalKills; $Total_Honor = $rows->totalHonorPoints; echo " <tr> <td><center>",$i,"</center></td> <td><i>",$name,"</i></td> <td><center>",$level,"</center></td> <td><center>",$Total_Honor,"</center></td> <td><center>",$Total_Kills,"</center></td> </tr>"; } mysql_close($characters); ?> Arena Top: <html> <head> <title>Top Arena</title> <style> body { background: #000000; color: #8f7e4b; font: 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; margin: 0px 0px 0px 0px; padding: 0px; text-align: center; } a:link { color: #d4c8a2; text-decoration: none; } a:visited { color: #d4c8a2; text-decoration: none; } a:hover, a:active { color: #FFFFFF; text-decoration: none; } </style> </head> <body> <? include ("config.php"); $j=1; $teamType = array( '2' => '2x2', '3' => '3x3', '5' => '5x5' ); $connect = mysql_connect($host,$user,$pass) OR DIE("'Can't connect with $host"); mysql_select_db($characters,$connect) or die(mysql_error()); mysql_query("SET NAMES '$cod'"); if(!isset($_GET['guid'])){ $sql = mysql_query("SELECT * FROM `arena_team` ORDER by `name`"); echo "<center><table border=1 width=70%> <tr> <td>Team Name</td> <td align=center>Command Type</td> <td align=center><center>Team Leader</center></td> <td>Faction</td> <td align=center>Rating</td> </tr>"; while ($row = mysql_fetch_array($sql)){ $query_num = mysql_query("SELECT COUNT(*) FROM `arena_team_member` WHERE `arenateamid`='$row[arenateamid]'"); $gleader = "SELECT name,race FROM `characters` WHERE `guid`='$row[captainguid]'"; $myrow = mysql_fetch_array(mysql_query($gleader)); $top = mysql_query("SELECT * FROM `arena_team_stats` WHERE `arenateamid`='$row[arenateamid]'"); $toprow = mysql_fetch_array($top); if($myrow['race']=="1" or $myrow['race']=="3" or $myrow['race']=="4" or $myrow['race']=="7" or $myrow['race']=="11"){ $faction = "alliance"; }else{ $faction = "horde";} echo " <tr> <td > <p style='padding-left: 5px'><a href='?guid=".$row[arenateamid]."' >".$row['name']."</a></p> </td> <td align=center><center>".$teamType[$row['type']]."</center></td> <td><a href=".$wowd."/index.php?player=".$row[captainguid].">".$myrow['name']."</a></td> <td align=center><center><img src=images/".$faction.".gif title=".$faction."></center></td> <td align=right><p style='padding-right: 8px'>".$toprow['rating']."</p></td></tr>"; } echo "</table></center><br><br>"; } if (@$_GET['guid'] ) { $name = "SELECT * FROM `arena_team` WHERE `arenateamid`='$_GET[guid]'"; $nrow = mysql_fetch_array(mysql_query($name)); $top = "SELECT * FROM `arena_team_stats` WHERE `arenateamid`='$_GET[guid]'"; $trow = mysql_fetch_array(mysql_query($top)); $member = "SELECT * FROM `arena_team_member` WHERE `arenateamid`='$_GET[guid]'"; $mrow = mysql_fetch_array(mysql_query($member)); $sql = mysql_query("SELECT * FROM `characters`, `arena_team_member` WHERE `characters`.`guid`=`arena_team_member`.`guid` and `arenateamid` = '".$_GET["guid"]."' "); $row = mysql_fetch_array($sql); $data = explode(' ',$row['data']); $lvl = $data[$ver]; $gender = dechex($data[36]); $gender = str_pad($gender,8, 0, STR_PAD_LEFT); $gender = $gender{3}; $guid = $row['guid']; $race = $row['race']; $class = $row['class']; $online = $row['online']; $j=1; echo "<center> <table border=0 width=60%> <tr> <td> <table border=1 width=100%> <tr><td>Team Name</td><td >".$nrow['name']."</td></tr> <tr><td>Rating</td><td >".$trow['rating']."</td></tr> <tr><td>Command Type</td><td >".$teamType[$nrow['type']]."</td></tr> <tr><td colspan=2 >Statistics of the Week</td></tr> <tr><td>Played: ".$trow['games']."</td><td >Won: ".$trow['wins']."</td></tr> <tr><td colspan=2 >Stats</td></tr> <tr><td>Played: ".$trow['played']."</td><td >Won: ".$trow['wins2']."</td></tr> </table> "; echo "<table border=1 width=100%> <tr> <td align=center>#</td> <td align=center>Nombre del Jugador</td> <td align=center>lvl</td> <td align=center>Raza</td> <td align=center>Clase</td> <td align=center>Game of the Week</td> <td align=center>Won week</td> <td align=center>Games for the season</td> <td align=center>Won season</td> <td align=center>Personal rating</td> <td align=center>Online</td> </tr> "; echo "<tr> <td valign=center width=3%>$j</td> <td align=center valign=center width=20%><a href='/wow/wowd/?player=".$guid."' style='color: #ff9900; font-family : Geneva; text-decoration : none;'>".$row[name]."</a></td> <td width=20 align=center valign=center>$lvl</td> <td align=center valign=center width=7%><img src=images/race/".$race."-".$gender.".gif></td> <td align=center valign=center width=7%><img src=images/class/$class.gif></td> <td align=center width=20%>".$mrow['played_week']."</td> <td valign=center width=20%>".$mrow['wons_week']."</td> <td valign=center width=10%>".$mrow['played_season']."</td> <td valign=center width=10%>".$mrow['wons_season']."</td> <td valign=center width=10%>".$mrow['personal_rating']."</td> <td valign=center width=10%><center><img src='images/status/".$online.".gif' height='18' width='18'></center></td> </tr> "; echo "</table></td></tr></table></center><br><br><br>"; echo "<table border=1><tr><td><a href='index.php'>Index</a></td></tr></table>"; } ?> </body> </html> Uptime Server: <?php require_once ( 'config.php'); mysql_connect($host, $user, $pass) or die ("Can't connect with $host"); mysql_selectdb ("$auth"); $sql = mysql_query ("SELECT * FROM $auth.`uptime` ORDER BY `starttime` DESC LIMIT 1"); $uptime_results = mysql_fetch_array($sql); if ($uptime_results['uptime'] > 86400) { $uptime = round(($uptime_results['uptime'] / 24 / 60 / 60),2)." Days"; } elseif($uptime_results['uptime'] > 3600) { $uptime = round(($uptime_results['uptime'] / 60 / 60),2)." Hours"; } else { $uptime = round(($uptime_results['uptime'] / 60),2)." Min"; } echo "Uptime:$uptime <br>"; ?> Recover Password: <?php /* Very important! You need to run SQL update! ALTER TABLE `account` ADD `reset_password` VARCHAR( 50 ) NOT NULL; */ /*Config*/ require_once ( 'config.php'); $conn = mysql_connect($host, $user, $pass, $realmd) or die('Connection failed: ' . mysql_error()); $config = array( 'path_to_thisfile' => 'http://www.fantasywow.es/lol/ownage/wow/pass_recovery.php', // Example: http://mysite.com/lol/ownage/wow/ 'email_from' => 'webmaster@fantasywow.es', // Who should the email be sent from ? 'email_subject' => 'Recupera tu contraseña!', // Subject of the mail ?? ); function sha_password($user,$pass){ $user = strtoupper($user); $pass = strtoupper($pass); return SHA1($user.':'.$pass); } function random_string($counts){ $str = "abcdefghijklmnopqrstuvwxyz";//Count 0-25 for($i=0;$i<$counts;$i++){ if ($o == 1){ $output .= rand(0,9); $o = 0; }else{ $o++; $output .= $str[rand(0,25)]; } } return $output; } $realmd_bc_new_connect = mysql_connect($realmd[db_host],$realmd[db_username],$realmd[db_password]); $selectdb = mysql_select_db($realmd[db_name],$realmd_bc_new_connect); if ($_GET[h] && $_GET[h] != '' && $_GET[h] != '0'){ $output_random_pass = random_string(10); $query = mysql_query("SELECT username FROM `account` WHERE reset_password='$_GET[h]'"); $res = mysql_fetch_array($query); if (mysql_num_rows($query) == 1){ echo "Hi $res[username], Your password is: $output_random_pass. Please change your password fast as possible."; $pass_hash = sha_password($res[username],$output_random_pass); mysql_query("UPDATE `account` SET sha_pass_hash='$pass_hash' WHERE reset_password='$_GET[h]'"); mysql_query("UPDATE `account` SET reset_password='' WHERE username='$res[username]'"); }else{ echo "Error."; } }else{ ?> <?php //this is where user fill in and send by email if ($_POST[password_takeback]){ $check_security = mysql_query("SELECT id FROM `account` WHERE username='$_POST[username]' AND email='$_POST'"); if (isset($_POST['username']) && isset($_POST['email']) && mysql_num_rows($check_security) == 1){ $rand = random_string(40); mysql_query("UPDATE `account` SET reset_password='$rand' WHERE username='$_POST[username]'"); $to = $_POST["email"]; $from = "From: $config[email_from]"; $subject = $config[email_subject]; $message= "Hi $_POST[username], you have submitted a password recovery on our site. IF YOU DIDNT SUBMIT A PASSWORD REQUEST JUST DELETE THIS MAIL!. Please follow this link to complete the operation: $config[path_to_thisfile]?h=$rand"; mail($to, $subject, $message, $from); // This work if you have configured your php.ini file to send email, !on linux its default. echo "An Email has been sent to you, please follow the email to complete the process."; }else{ echo "Incorrect details, Please be sure that you submitted right Email and Username to your account"; } }else{ ?> <form action="<?php echo $_SERVER[PHP_SELF]; ?>" method="POST"> Tu Email: <input type="text" name="email"> Tu Usuario: <input type="text" name="username"> <input name="password_takeback" type="submit" value="Recuperar Contraseña"> </form> <?php } }// End GET ?> 2c2: <?php // MySQL //Añadir el fondo deseado echo "<body background='./imagenes/fondo.jpg' text='white'>"; $WoWHostname = ""; // MySQL server address $WoWUsername = ""; // MySQL username $WoWPassword = ""; // MySQL password $CharacterDatabase = ''; // TC characters database $RealmDatabase = ''; // TC relamd database $WorldDatabase = ''; // TC world database $CharacterDatabaseEncoding = 'utf8'; // database character encoding /* */ // DO NOT EDIT BELOW HERE IF YOU DON'T KNOW WHAT IT IS!!! $WoWconn = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword) or die('Connection failed: ' . mysql_error()); mysql_select_db($CharacterDatabase, $WoWconn) or die('Select DB failed: ' . mysql_error()); $sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`"; $result = mysql_query($sql, $WoWconn) or die('Query failed: ' . mysql_error()); $count = 0; ?> <?php // 5º parte $link = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword); $db_selected = mysql_select_db($CharacterDatabase, $link); $sql = "SELECT `arena_team`.`name`, `arena_team`.`arenateamid`, `arena_team_stats`.`arenateamid`, `arena_team_stats`.`rating` FROM $CharacterDatabase.`arena_team`, $CharacterDatabase.`arena_team_stats` WHERE `arena_team_stats`.`arenateamid` = `arena_team`.`arenateamid` AND `arena_team`.`type` = '2' ORDER BY `arena_team_stats`.`rating` DESC LIMIT 30"; //Comando de rankin arenas 2c2 top10 $result = mysql_query($sql); if (!$result) { die('Invalid query: ' . mysql_error()); // en caso de error... } mysql_close($link); //Cerrar comando de rankin 2c2 $row = mysql_fetch_row($result); $i=1; echo "<br><br><br>"; echo "<h2>Rankin 2c2</h2>"; echo "<br>"; echo "<table border=0><tr><td>"; echo "<h4>Nombre del grupo</h4></td><td><h4>Puntos de grupo</h4></td></tr>"; while ($row != NULL) // Si hay algun resultado => proceder / ningun resultado => nada { echo "<tr><td>"; echo $row[0]; echo "</td><td>"; echo $row[3]; echo "</td></tr>"; $row = mysql_fetch_row($result); } echo "</table>"; // Fin parte 5 // Funciona: ?> 3c3: <?php // MySQL //Añadir el fondo deseado echo "<body background='./imagenes/fondo.jpg' text='white'>"; $WoWHostname = ""; // MySQL server address $WoWUsername = ""; // MySQL username $WoWPassword = ""; // MySQL password $CharacterDatabase = ''; // TC characters database $RealmDatabase = ''; // TC relamd database $WorldDatabase = ''; // TC world database $CharacterDatabaseEncoding = 'utf8'; // database character encoding /* */ // DO NOT EDIT BELOW HERE IF YOU DON'T KNOW WHAT IT IS!!! $WoWconn = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword) or die('Connection failed: ' . mysql_error()); mysql_select_db($CharacterDatabase, $WoWconn) or die('Select DB failed: ' . mysql_error()); $sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`"; $result = mysql_query($sql, $WoWconn) or die('Query failed: ' . mysql_error()); $count = 0; ?> <?php // 5º parte $link = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword); $db_selected = mysql_select_db($CharacterDatabase, $link); $sql = "SELECT `arena_team`.`name`, `arena_team`.`arenateamid`, `arena_team_stats`.`arenateamid`, `arena_team_stats`.`rating` FROM $CharacterDatabase.`arena_team`, $CharacterDatabase.`arena_team_stats` WHERE `arena_team_stats`.`arenateamid` = `arena_team`.`arenateamid` AND `arena_team`.`type` = '3' ORDER BY `arena_team_stats`.`rating` DESC LIMIT 30"; //Comando de rankin arenas 2c2 top10 $result = mysql_query($sql); if (!$result) { die('Invalid query: ' . mysql_error()); // en caso de error... } mysql_close($link); //Cerrar comando de rankin 2c2 $row = mysql_fetch_row($result); $i=1; echo "<br><br><br>"; echo "<h2>Rankin 3c3</h2>"; echo "<br>"; echo "<table border=0><tr><td>"; echo "<h4>Nombre del grupo</h4></td><td><h4>Puntos de grupo</h4></td></tr>"; while ($row != NULL) // Si hay algun resultado => proceder / ningun resultado => nada { echo "<tr><td>"; echo $row[0]; echo "</td><td>"; echo $row[3]; echo "</td></tr>"; $row = mysql_fetch_row($result); } echo "</table>"; // Fin parte 5 // Funciona: ?> 5c5: <?php // MySQL //Añadir el fondo deseado echo "<body background='./imagenes/fondo.jpg' text='white'>"; $WoWHostname = ""; // MySQL server address $WoWUsername = ""; // MySQL username $WoWPassword = ""; // MySQL password $CharacterDatabase = ''; // TC characters database $RealmDatabase = ''; // TC relamd database $WorldDatabase = ''; // TC world database $CharacterDatabaseEncoding = 'utf8'; // database character encoding /* */ // DO NOT EDIT BELOW HERE IF YOU DON'T KNOW WHAT IT IS!!! $WoWconn = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword) or die('Connection failed: ' . mysql_error()); mysql_select_db($CharacterDatabase, $WoWconn) or die('Select DB failed: ' . mysql_error()); $sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`"; $result = mysql_query($sql, $WoWconn) or die('Query failed: ' . mysql_error()); $count = 0; ?> <?php // 5º parte $link = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword); $db_selected = mysql_select_db($CharacterDatabase, $link); $sql = "SELECT `arena_team`.`name`, `arena_team`.`arenateamid`, `arena_team_stats`.`arenateamid`, `arena_team_stats`.`rating` FROM $CharacterDatabase.`arena_team`, $CharacterDatabase.`arena_team_stats` WHERE `arena_team_stats`.`arenateamid` = `arena_team`.`arenateamid` AND `arena_team`.`type` = '5' ORDER BY `arena_team_stats`.`rating` DESC LIMIT 30"; //Comando de rankin arenas 2c2 top10 $result = mysql_query($sql); if (!$result) { die('Invalid query: ' . mysql_error()); // en caso de error... } mysql_close($link); //Cerrar comando de rankin 2c2 $row = mysql_fetch_row($result); $i=1; echo "<br><br><br>"; echo "<h2>Rankin 5c5</h2>"; echo "<br>"; echo "<table border=0><tr><td>"; echo "<h4>Nombre del grupo</h4></td><td><h4>Puntos de grupo</h4></td></tr>"; while ($row != NULL) // Si hay algun resultado => proceder / ningun resultado => nada { echo "<tr><td>"; echo $row[0]; echo "</td><td>"; echo $row[3]; echo "</td></tr>"; $row = mysql_fetch_row($result); } echo "</table>"; // Fin parte 5 // Funciona: ?>
    2 points
  23. Sorcerer, could you please provide a link to your contributions to the database? If you are not a developer, that is ok as well... could you then please provide a link to your bug reports? Such things could help us drastically in fixing our "bugged" database. Uneccessary flaming such as this: "DB is as bugged as Release 4 was," does NOT help. Sorry Titanium, we do only provide update packs for hot fixes. This is for a few reasons. The biggest reason being that people then just apply the updates to some other project's db or custom db, thus never providing us feedback or helping this project in any way, shape, or form. Obviously, this has adverse effects on our community, and project as a whole. Not to mention, it is simply not fair to all the developers who use their own personal time to contribute to the project, just so they can see some dumb ass posting it on ACweb and taking full credit for it. If you are doing custom work to your database, that is completely up to you. However, I would recommend backing up your custom work through sql statements. This way, when you need to update your world db, you simply run the world installer, then apply your custom updates and bam, your good to go again. Raydeon
    2 points
  24. jDataEditor 1.0 jDataEditor is a cross-platform database editor for all common emulators with unique features which makes your daily database live much better. More information and a where you see all the features in action you will find on our homepage. Features: Account Editor Npc Editor Query executer Special technique to only change needed data DBC-Viewer Modelviewer Data Selector for each kind of field Multi-core support (ArcEmu, Trinity, Mangos, ArcEmu etc..) Click to load system Multi-language Fast SQLTable SearchTables for database History - to keep track of all sql querys Many tooltips Many look and feels Easy to use GUI EXPERIMENTAL SSH support and much much more... Important notice for all Windows user: 32, 64bit depends on the installed Java Runtime Environment. If you have a 64bit JRE installed you also have to download the 64bit version Download (and more information): http://wanze-backup.pytalhost.at/jde/
    2 points
  25. We are pleased to announce the return of SkyFire DB and our brand new DB team. Look for the official launch of our new DB on February 26,2012. As some you may know the official partner DB CCDB decided to close down so until we launch our DB you can feel free to use there last release DB located here https://github.com/SkyFire/CCDB406_PUBLIC . Please check back with us soon. We are also recruting new database developers. Feel free to come chat with us in IRC or apply on our forum by clicking here. http://www.projectskyfire.org/index.php?/forum/26-join-our-team/ .
    2 points
  26. AriDEV

    SQL Guidelines

    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)
    2 points
  27. If I post this wrong section - delete it. just helping the beggers :-) (where's your sign!!) something simple quick and dirty!! did it in `10min - hey what do you want for free!!! HTML <html> <head> </head> <body> <center> <form method="post"> <p>Account Password Generator <br/> for use with Mangos Private Server Engine</p> <?php echo $error_msg."<p/>";?> <table> <tr> <td align="right">Account Name:</td><td><input type="text" name="username"></td></tr><tr> <td align="right">Password:</td><td><input type="password" name="password"></td></tr><tr> <td colspan="2" align="right"><input type="submit" name="submit" value="Register"></td> </tr> </table> </form> </body> </html> PHP section <?php $error_msg = ""; //CREATE A DUMMY ERROR MSG if(isset($_REQUEST['submit'])){ //CHECK IF SUBMIT BUTTON WAS PRESSED $un = $_REQUEST['username']; //GET USERNAME $pw = $_REQUEST['password']; //GET PW if($un == "" || $pw == ""){ //MAKE SURE THEY ARE NOT NULL $error_msg = " Please make " ."Sure all feilds are complete"; //CREATE AN ERROR MESSAGES }else{ //OTHERWISE THINGS ARE GOOD $newName = sha1(strtoupper($un). ":".strtoupper($pw)); //CREATE THE PW. <-- fix this line if encypt has changed echo "<center>ACCOUNT INFO:<P/>"; //SHOW IT. echo "ID: ".strtoupper($un). " PW: ".strtoupper($newName); die(); } } If nothing has changed in the encryption this should work for a simple plugin for any website. If not, fix the part highlighted in red. I think there are other post like this just search around. mods: I know this should go in a different area, just replying
    2 points
  28. SkyFire

    MySQL issues

    You could have missed and sql update.
    1 point
  29. This is a learning project. It's not meant to work 100% out of the box. No one here is anyone's personal coder. We fix and update stuff as time permits.
    1 point
  30. Discover

    Discover-'s SAI-Editor

    Version 1.5.0 has been released. Same links in the original post still apply.
    1 point
  31. core: 5.4.8 skyfirecore db:skyfire db 5.xx release7 and update use sqlupate in the core  when I entered any Dungeon or raid, server always crashes, but does not appear in the city and the wild. when crashes worldserver.exe prompting the following error on the screen: ========================================================================= InstanceSaveManager::AddInstanceSave:mapId=565,instanceid=1,wrong dificalty 254! no defined handler for opcode [uNKNOWN OPCODE 0X9F0<2544>] sent by [Player: hanuma <Guid: 2,Account:1>] E:wowskyfirecoresrcservergameMapsMap.cpp:2740 in InstanceMap::AddPlayerToMap ASSERTION FAILED: mapSave [0x216f70] ========================================================================= where wrong?how to fix it? please help me!  thank you! Â
    1 point
  32. Hello! Â My name is blkht (for now), 23 years old living in Norway. I`ve been off the grid for a long time due to work, school and social stuff. But I`m back baby! I remember people spoke about skyfire before I left but I never got around to try it out. It looks like a pretty nice project and the private server scene has really developed positively during the time I have been gone. It`s so awesome to see active projects around. Â It`s great to be back and I`m really looking forward to trying out your core! Â Happy haloween and whatnot!
    1 point
  33. This is a little tweak I did so MangosWeb Enhanced v3 to work with Skyfire. The Previous version would cause a database error when account was created it would set expansion=2 in database. I tweaked it to work with expansion=3 Cata. This error would cause worgen and trolls to not be available after account was created. File is here http://filebeam.com/...1fa72592fb4ddbb Enjoy EDIT: If you have problems registering new accounts....go into admin panel and disable capcha. Can somebody confirm this error?
    1 point
  34. U Can find the SFDB 548.7 here: Â after apply the database u need to apply updates from : https://github.com/ProjectSkyfire/SkyFire_5xx/tree/master/sql/updates/world
    1 point
  35. Dang065

    Error with Cmake

    can anyone help me with this error "Git was NOT FOUND on your system - did you forget to install a recent version, or setting the path to it? Observe that for revision hash/date to work you need at least version 1.7 Call Stack (most recent call first): CMakeLists.txt:68 (find_package)" Â and i get this in a message box "Error in configuration process, project files may be invalid." it cant be my Git as it says as i have version 1.9.4 of git and have re-installed for good measure.
    1 point
  36. socra2

    WowheadRipper

    Here is sourcecode , ill release tutorial in following days https://github.com/Sovak/WowheadRipper
    1 point
  37. Rawaho

    Error with Cmake

    You need to install OpenSSL, you can get a precompiled version from here. Make sure you download the non light version; only download the x64 version if you are going to compile Skyfire in 64bit as well.
    1 point
  38. AriDEV

    Stuck on Cmake

    or u can simply CHECK the box in cmake WITHOUT_GIT
    1 point
  39. Welcome! World of Warcraft has changed a lot internally since Wrath of the Litch King, you have a lot to catch up on :P
    1 point
  40. AriDEV

    Pandaria

    we are allready working on 542 check from 5xx repo the 542branch
    1 point
  41. We don't do "updates" if your a smart person you save your custom stuff and transfer it to each release. ^_^
    1 point
  42. no! coz Skyfire have own policy and some reasons with only Full DB release! there are no updates anymore
    1 point
  43. We are pleased to release a preview of our next generation DB. Look for our final release on Sunday. We hope to here your input. Please use the GITHUB bug tracker to report bugs NOT THE FORUM. https://github.com/ProjectSkyfire/SkyFireDB
    1 point
  44. Raydeon got lazy. We will post one soon :)
    1 point
  45. junx

    Password Changer

    To help change Administrator, Gamemaster, Developer, Moderator & Player(s) default passwords to make your server more secure after setup. Minimalistic Found and copied from another forum. Forgot who made it. I take no credit. Added & fix a few things. You can change all the '5' to your specific minimal password length. (Watch out for the '15' if you use Find and Replace.) <?php $host = "localhost"; //Your servers IP address $port = "3306"; //Your servers port $user = "root"; //Your database username $pass = "pass"; //Your database password $auth = "auth"; //Your auth database if(isset($_POST['submit'])) { $account = $_POST['account']; $passwordOld = $_POST['passwordOld']; $passwordNew = $_POST['passwordNew']; $passwordNew1 = $_POST['passwordNew1']; $passwordolde = sha1(strtoupper($account) . ":" . strtoupper($passwordOld)); $passwordnewe = sha1(strtoupper($account) . ":" . strtoupper($passwordNew)); $passwordNew1e = sha1(strtoupper($account) . ":" . strtoupper($passwordNew1)); $account = /*mysql_real_escape_string*/($account); $eoldpass = strtoupper($passwordolde); $enewpass = strtoupper($passwordnewe); $enewpass1 = strtoupper($passwordNew1e); $con = mysql_connect("$host", "$user", "$pass") or die(mysql_error()); mysql_select_db("$auth", $con) or die(mysql_error()); $query = "SELECT id FROM account WHERE username = '".$account."' AND sha_pass_hash = '".$eoldpass."'"; $result = mysql_query($query) or die(mysql_error()); $numrows = mysql_num_rows($result); if($enewpass != $enewpass1) { die("<p align='center'>Error:<br><br>New password fields must match!<br><br>Please go back and try again.</p>"); } if(strlen($_POST['passwordNew']) < 5){ $chars = strlen($passwordNew); die("<p align='center'>Error:<br><br>Your new password is too short!<br><br>You entered ".$chars." character(s).<br><br>The minimum length is 5 characters and the maximum length is 15.<br><br>Please go back and try again.</p>"); } if($numrows == 0) { die("<p align='center'>Error:<br><br>Invalid account name/password!<br><br>Please go back and try again.</p>"); } $query = "UPDATE account SET sha_pass_hash = '".$enewpass."' WHERE username = '".$account."'"; $result = mysql_query($query) or die(mysql_error()); echo "<p align='center'>Password for the Account<br><br>'<b>".$account."</b>'<br><br>has been successfully changed!"; //close mysql connection mysql_close($con); } else{ ?> <html> <head> <title>WoW - Password Changer</title> </head> <body> <center><h1><u><b>Password Changer</b></u></h1><br> <form autocomplete="off" method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>"> Account/Username:<br><input type="text" name="account"><br><br> Old Password:<br><input type="password" name="passwordOld"><br><br> New Password:<br><input type="password" name="passwordNew"><br><small>(5 or more characters)</small><br><br> Confirm New Password:<br><input type="password" name="passwordNew1"><br><br> <input value="Change my password!" class="form3" type="submit" name="submit"> </form> <small>You <b><u>MUST</u></b> be offline for this tool to successfully work!</small> </center> </body> </html> <?php } ?>
    1 point
  46. Acheron

    Good day

    Good day My name is Martin Singleton, I'm a junior .net Develeoper still studing at this point. I have been working on emulators for 3 years now. Arcemu then Mangos, currently I'm not doing much core developing for any project. But Have been working on the PacketViewer for the few week or so. My passion is more in tool developing, than core or database developing, but have advance C++ and SQL experience. I have a team of 3 experienced .net developer that help me run a small developing group. So would like to them some day join me and create WowTools that will make life easier for core and database developers. If you have any ideas of tools that you like to see feel free to contact me. e-mail: Singlem1134@gmail.com github: https://github.com/Singlem skype: martin.singleton1134 MSN: Singlem1134@gmail.com(almost never online) Kind regards Martin Singleton
    1 point
  47. AriDEV

    How To Post Patches

    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
    1 point
  48. SkyFire

    DB-Backup unuseable

    You need to raise the buffer settings. [Err] 2006 - MySQL server has gone away Your MySQL server has crashed. Read the MySQL documents on how to do this.
    1 point
  49. Hordequester

    LF wdb converter

    Tomrus's "mywowtools" has a "DBC Viewer" with a "Export2SQL" plug-in. DBC Viewer can handle ADB/WDB/DBC/DB2 with exporting. I have not tried it on WDB files though but I have used it on DB2/DBC revision 13623 and it worked fine. Skyfire Devs ported over his SVN to Git https://github.com/SkyFire/toms_tools The plug-in is pretty easy to modify to work on any DB format.
    1 point
  50. 1 point
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.