Jump to content

Search the Community

Showing results for tags 'sql'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News & Updates
    • Announcements
    • Suggestions & Feedback
  • MMO Hub
    • General Chat
    • Gamer's Lounge
    • Member's Lounge
    • Dev Lounge
  • MMO Corner
    • MMO and MMORPG
    • Host Listing
    • Server Listings
    • Server Recruitment
    • Server Reviews
  • User Hub
    • Support
    • Report
    • Contact Staff
  • Creative Corner
    • GFX
    • VFX
  • Merchant Corner
    • Marketplace
  • General Development Releases
    • Applications
  • Tutorials
    • Programming
    • Web Development
  • Wasteland
    • Archives


  • Creative Corner
    • GFX Releases
    • VFX Releases
    • Resources
  • MMO and MMORPG
    • World of Warcraft
    • Lineage 2
    • Minecraft
  • Webmasters
    • Content Management Systems
    • Addons
    • Scripts
    • Designs
    • Proxies
  • Applications
  • Gaming
    • World of Warcraft
    • Lineage 2
    • Minecraft
    • Emulation
    • Nulled Distributions
  • Marketplace
    • Marsh Designs
    • iDarts


  • Community Calendar

Found 12 results

  1. Project We are a team of dedicated, passionate and experienced developers willing to set new condition standards and fulfill the players' expectations. Our goal is to build a strong community and relive the wonderful memories by providing an outstanding gameplay we have managed to experience throughout the prime years of World of Warcraft. Server Patch: 2.4.3 (progressive) Type: PvE Rates: x1 Leveling: 1-70 100% Blizzlike PRE-NERFED CONTENT PAY TO WIN Development We have put a lot of effort in our core which is originally a combination of CMangos 2.4.3 and backported fixes from SunwellCore 3.3.5 + a lot of our updates. It's been pretty tough having only 1-3 developers throughout the time, but giving up has never been an option. We have progressed as much as we could with so little manpower and the time given. The website and forum are almost ready. With a little help from a Graphical Artist they will both be done by the end of this month. Marketing The whole marketing plan will certainly not be revealed, but I can share a few key points: After a chat with Skill Capped's video editor (www.skill-capped.com) and we agreed to co-work under certain terms. He is currently half way done with our trailer. I have also made deals with multiple Youtubers (I'd rather not mention their name here, but you can probably guess some). They agreed to record a review (not sponsored!) of the server and its' features once we progress into the BETA phase. Staff Our team consists of 5 members as of right now: 3 C++ Developers (they all have at least semi-advanced SQL knowledge) Web Developer Manager (that's me, I do everything that needs to be done except for coding) Why would you choose us? We WILL deliver. We are going to provide an outstanding quality and unique features such as PRE-NERFED CONTENT. The main problem with today's private servers is the fact that they're not challenging at all. The game has been released in January 2007 and clearing the same and easier by the day content is just not fun anymore. The Burning Crusade will soon celebrate its' 10 year anniversary, which makes it almost impossible to research desired information about the expansion. Fortunately for us, one of our developers gathered his own notes and protocols over the years which enable us to replicate the level of difficulty back from early TBC days. With hard work, passion and attention to detail, our vision will soon become a reality. We have intensively brainstormed and listed every single thing that we did / didn't like about playing on private servers. We will do our best to eliminate the cons and create a new home for the amazing World of Warcraft community. And finally... Who are we looking for? If you are passionate about WoW Emulation, organized, speak English in a communicative form and you're able to dedicate at least 10 hours a week on server development, then you are a perfect candidate! C++ Developers (3/5) SQL Developers (0/2) Graphical Artist (0/1) Please keep in mind that it's not a paid job - we all do it out of pure love for the game. If by any chance you're interested in becoming a part of our team, please either PM me or leave your contact information down below (preferably Skype). Best Regards, Cortez
  2. Executable SQL for Item Creation {3.3.5a} ----------------------------- I just noticed that all the item makers I could find were all still outdated and using inserts for old database structures, so seeing as I don't know how to make programs all that well but I can do some SQL for fun I decided to make and upload this for free use! All you have to do to use this is simply edit the SET Values and execute it into your database. I even added notes for convenience! For Reference on the variables you can add to this query head over to Trinitycore Wiki -- Item_Template and click on the field you need info for! If you have any questions or requests in the future, Ask away! (No promises on Requests) With love, A235848
  3. A New Story! The basic premise over our server is to offer new players an experience that differs from the traditional Warcraft story arc. Features - A new story arc that starts players off based on the class you choose upon character creation, rather than based on race - Players will experience an altered leveling setup where by one will quest from levels 1 to 24 and/or level via the custom solo dungeon we've created for players who would rather a grindish feel to their leveling experience - Endgame content will include your typical Mastermind like end-boss. Players will go through a series of Daily, Group friendly, questing hubs and dungeons before starting to do raids to progress through harder content. - PvP content will also be an emphasis to give a diverse content to the player base. This includes Dual Faction BGs, Dueling Areas equipped with Vendors and buff giving npcs, FFA PvP Questing Hubs with Daily quests and Rewards, and GM hosted PvP Events with Rewards. - Misc "For Fun" things to do, such as parkour, Mazes, Freeze Tag, and other random exotic stuff. Development Status Level/Stat Scaling - 45% Custom Gear - 0% Map Editing - 5% Custom Story - 15% Custom Quests - 0% Dungeons - 0% Raids - 0% Extras - 0% Current Staff Gnox - Founder/Programmer Click me--> Discord Chat <--Click me We are currently in need of many dedicated individuals! If you meet any of the prerequisites for the roles we have open listed below, please feel free to apply! Admin - Requires that you know Trinitycore systems and be able to understand all database lingo without explanation. Requires that you have experience with SQL or are willing to learn it. GMs - Have a good overview of all game classes, mechanics, and have a history of playing across at least Retail and 2 other private realms. Prior GM experience is a plus, but not required. SQL Programmer - Good knowledge of SQL coding and TrinityDB revision 6.02 or higher . Must have a general idea how to make and edit items, quests, NPCs, game objects, and other miscellaneous tables in the DB. Core Programmer - Must have Knowledge of C++ and Visual Studios 2008 or Higher. Must have experience with Trinitycore as well as an understanding on the addition and removal of major content overhauls to the core. Client Editors - Experience Editing MPQ files. Testers - Early access players who will be allowed access to the server for testing and bug finding. Learning Opportunities Those who wish to learn more about a given role that wouldn't otherwise require years of training or experience is welcome to inquire. Item I'm willing to teach: GMing, Basic SQL, Clientside Editing, Basic Map editing. Feel free to send me PM or refer to the Discord linked above with further questions
  4. Hello everyone, my name is Raj Puri. Many of you may know me from other communities, but I've decided to stick with Lordcraft, simply because you're all nice! Anyhow, I will be contributing frequently (mainly C++ scripts) for TrinityCore. I WILL BE CRAFTING WHAT MATTERS!
  5. Hey guys, i'm in need of a sql script that is for Twink Vendors. Twink 19 / 29 / 39 vendors for 4.3.4. Core: Trinity Core I will give +rep to the one who helps me with this. If you want to work with me as well as a partner, feel free to reply with your skype.
  6. I've seen many tutorials (mainly for windows) where tutorial has you 'batch' all the SQL files into a a single *.sql and then the user would import that single file. There are some un-discussed issues with that method; This method does not allow easy identification of errors that might occur during the import of the query. This method could produce a large file that takes some time to load into memory and/or process Not to mention the batch process isn't needed; everyone should already have all the tools they need in order to just import the updates 'en mass'. Here are the scripts to use... Windows Version for /f %%a in ('dir /b *world*.sql') do "C:\PROGRA~1\MySQL\MYSQLS~1.5\bin\mysql.exe" -u [MYSQL User] --password=[User's Password] --database=[Database] < %%a Linux Version for file in *world*.sql; do mysql -u [MYSQL User] --password=[User's Password] [Database] < $file; done **Both examples assume the MySQL Server is running on localhost, if not add -h [Host IP] to the script(s). To process auth or character updates, simply change *world* and [Database] and viola! This may not be necessary any more with TrinityCore's new auto-update scripts, however rumors indicate that there are still some issues with that process. This will work for any core, or anything for that matter. Hope this helps..
  7. As title say , I decided to stop posting my releases on public emulation forums due to many leechers arround but now I decided to give them back to community for a resonable price. Many of you probably know me , my real name is Marco aka Darksoke.Why Darksoke ? Idk either I just gor that nickname because it doesn't mean annything but it does for me , it's the name that make me recognised on this emulation forums. I posted many releases inmany emulation forums and you might probably already know how I "roll this joint". Here is a list of my public releases from newest to older(links coming soon): - Azer CMS realm uptime module!(Private no link) - Trinitycore Buy Transmog items with tokens c++ -Trinitycore c++ V.I.P token -Trinitycore gold cap to gold bars (Core modification)(OUTDATED) -SQL transformation Scrolls(Not posted on lordcraft) -SQL TG and DW scrolls -SQL mass Querrys(Not posted on Lordcraft) -SQL Item generator for trinitycore(Outdated SQL Batch) -Tutorial How to RBAC -WorldPVP + custom Graveyard -Trinitycore admin tools ("Not finished , I lost the project files") -Azer CMS mod (Top Voters of the Month)(Private made for my website) -Random number generator appi So what I can do?: -Create all kind of custom scripts and offer support installing and setting up -Create custom querrys for your database -Create tools to manage your DB (.NET) -Respect the Deadline! Prices depend on how complex you want your script here are some examples! SQL Querry to run bunch of stuff (5-10$) C++ Boss Script default cast some spells(5-10$) C++ Boss script with 2-3 phases(10-15$) C++ Boss script with phases/summoning/changing display(15-30$) .NET Apps (5-100$) depending on what you want You can find all my public releases on my paste site
  8. How to make an SQL teleporter with SmartAI In HeidiSQL Hi there today I am going to show you how to make an SQL teleporter with smartai – during this I will provide demonstrational images of what it should look like in the database. Firstly you are going to need to make a new gossip NPC in the creature_template section of your database to do this you can follow my other guide located: https://www.lordcraft.net/index.php/topic/3599-creating-a-npc-in-heidisql Remember to make a gossip NPC you will need to set the field “npcflag” to 1. Now that you have created your NPC let’s search for an ID in the gossip_menu_option that is not being used. For this tutorial I am going to choose the ID 51899. So now in the creature_template I am going to put that ID (51899) in the field called gossip_menu_id. Now, we need to start setting up the gossip_menu_option section of the teleporter, so let’s navigate to that table in the database and select “Data View”. You will now see all of the gossip_menu_option data. As you can see you have the following fields: From here we are going to create a new record by clicking on the button. Menu_ID: This is where we are going to put in the ID for our gossip (remember we chose to use ID 51899) so in this field we put in 51899 ID: In here we are going to put a 1. Should you wish to add more then I shall show you how to do this later on in the tutorial (but should you want more, then the ID would increase by 1 each time) Option_Icon: So in here you can put a number that determines what sort of icon that will be shown. You can use the following table to decide what icon you would like to use. For this tutorial I am just going to set it to 0. Option_Text: This is the text that you want to show on your gossip when you talk to the NPC. In here for the sake of this tutorial I am going to put the text “Sanctuary”. OptionBroadcastTextId: Just set this to 0. Option_ID: Now we need to make sure that the gossip_menu_option shows in the NPC so we have to set this field to 1. Npc_Option_NPCFlag: This field needs to show that the NPC that we are applying the gossip_menu_option to is a gossip NPC so in here we put a 1. Action_Menu_ID: Here we can do a couple of things; we can set it to 0, or for example - say we had named this one “Cities” and wanted to have it open a sub menu where the cities would be listed - then we can place the Menu_Id for that list to show. For the case of this tutorial we are simply going to set this to 0. Action_POI_ID: Set this to 0. Box_Coded: Set this to 0. Box_Money: In here you can set a cost/price. For example if you wanted the cost of travelling to Dalaran to be 1g then you would set it here. For this tutorial though I am not going to set a cost so I will simply put “0” in here. Box_Text: This is where you would put a confirmation – for example if I was to put in this field “Are you sure you want to travel to Sanctuary” then this message would come up and ask the player to accept whether they want to travel to Sanctuary or not. BoxBroadcastTextID: Set this to 0.   Well now that we have set up our first gossip_menu_option let me explain how to go about adding more. When adding more you would have to repeat the process but the ID field will change. In the first one that we created we placed a number 1 for the next one we would use the same Menu_ID but for the ID we would make it number 2 (+1 for each gossip_menu_option you make) until you have made all the menu’s that you want to show on that page. Referring to a sub menu: If you have created a menu that will then direct to another menu then you will need to use a new Menu_ID and then start with the ID set as 1 again. As you can see in the example that I have placed above, I have a main menu that then directs to a sub menu. In this, I have 13 options to choose from. The action_menu_id in this case points to a new selection of options except number 13 which has a 0 for the action_menu-id this is because I want this one so when players click on it they will be teleported instead of being taken to a different menu selection. Please also notice that in the option_text I have the name “Sanctuary” for example, that points to a new menu however in mine it shows as |TInterface/icons/Spell_Holy_Fanaticism:25|t |rSantuary. You don’t have to put the |TInterface/icons/Spell_Holy_Fanaticism:25|t |r piece in this just shows a picture icon before the name “Sanctuary”. If you want to have icons then you will need to put |TInterface/icons/Spell_Holy_Fanaticism:25|t |r this in. The icons are changeable and you can find the icons here: http://wowprogramming.com/utils/artbrowser/Interface/ICONS.list. To choose the icon you wish to use I suggest you open the one you wish to use in a new tab, then in the navigation bar you would copy the highlighted part only. See the example below: Should you want to change the icon then you will need to replace where it says “Spell_Holy_Fanaticism” with the text “ABILITY_POISON” as seen highlighted in the image above. You don’t have to use the icons and you can just leave the field with the word “Sanctuary”. Setting the smart_script First of all, let us take a look at the fields in the smart_scripts and I will explain how to set this up as we go along. We are now going to use the gossip_menu_option that you created to make the smart_script. As you may remember, we didn’t set the gossip_menu_option up to be a menu to then go to a sub menu. Entryorguid: In here you will need to set the value to your creature/NPC ID. Source_type: Just set this to 0. ID: This works in the same way as the field ID in the gossip_menu_option, for this we are going to use 1. If you want to add any more then it would increase by 1. Link: Set this to 0. Event_type: Set this to 62. This tells the script that it is activated on gossip select. Event_phase_mask: Set this to 0. Event_chance: Set this to 100. This makes sure that the event happens 100% of the time when the gossip menu is clicked. Event_flag: Set this to 0. Event_param1: This is the gossip_menu_option. In this case it would be set to 51899. Event_param2: This is the gossip_menu_option (Id Field). So in this case it would be set to 1. Event_param3: Set this to 0. Event_param4: Set this to 0. Action_type: Set this to 62. This now tells it that it is a teleport when the menu is clicked. Action_param1: For this you will need to go in-game and get the map ID by typing .gps - Set this field to the map ID for where you want the players to spawn. At this time it would be worth writing down the XYZ coordinates and the orientation or getting a screenshot as you will need these later. As you can see in the image above the map is 1 so if I wanted this as my location I would put a 1 in the Action_param1 and then set the target_x, target_y, target_z with the XYZ coordinates and the target_o to the orientation. Action_param2: Set to 0. Action_param3: Set to 0. Action_param4: Set to 0. Action_param5: Set to 0. Action_param6: Set to 0. Target_type: Set this to 7 (Action Invoker). This now tells it that when the player clicks that menu that they will be teleported. Now you have to continue through the tutorial and set up the target locations. Target_param1: Set to 0. Target_param2: Set to 0. Target_param3: Set to 0. Target_x: This is the x coordinate from doing the command .gps in-game. (This should be easy if you wrote it down as suggested when you got the map id.) Target_y: This is the y coordinate from doing the command .gps in-game. (This should be easy if you wrote it down as suggested when you got the map id.) Target_z: This is the z coordinate from doing the command .gps in-game. (This should be easy if you wrote it down as suggested when you got the map id.) Target_o: This is the orientation from doing the command .gps in game. (This should be easy if you wrote it down as suggested when you got the map id.) Comment: In here put a comment that will help you to find the script again should you ever want or need to change anything. For the sake of this tutorial I will be setting the comment to “Sanctuary Teleport” Once you have done that make sure to save the script in your database. Either click on the Green tick or on the row above. You have now added the first gossip_menu_option: “Sanctuary” and made it so when a player uses your teleporter NPC to click on the menu: “Sanctuary” then they will be teleported to the XYZ location that you have set. REMEMBER: AFTER ADDING GOSSIP_MENU_OPTION YOU WILL NEED TO GO IN-GAME AND USE THE COMMAND .RELOAD GOSSIP_MENU_OPTION. AFTER ADDING THE SMART_SCRIPT YOU WILL HAVE TO RESTART YOUR SERVER TO LOAD IT IN. //Tutorial By DPCoder //Lordcraft.net Special Thanks Katos for reading through the tutorial and checking
  9. Greetings dear community! We at Wrath-WoW are looking for dedicated, professional, serious, trustworthy, responsible and skilled developers. Please beware that we are under development, so some how you are going to be part of team in all manners. We assure you, this project is not "i just want my own server", but a long term project with stable roots, budget, ideas and a road map. We preferably choose a person who didnot had his chance for his career in development. Depending on your background, skill, personality, communications skills maturity you have a good chance to be a permanent member of team. We will listen to everyone individually, ideas flow, suggestions or your opinion will be considered valuable. We are currently recruiting: Core Dev You must be good and proficient in C++ and Trinity API You must have experience using professional tools (Github etc.) You have done some work in past either for the Trinity API or other C++ scripts Paid position available for highly experienced, active, and skilled applicants. SQL Dev You must be familiar with your field well. TDB experience is a plus, but not required. Your queries must be clean, efficient, and they must be able to be re-run an infinite number of times without fail or duplication. Web Dev PHP, MySQL, JQuery, JSON, Smarty, JavaScript Programming experience required Well paid position available for highly experienced, active, and skilled applicants. Builder Please show us your work (local work is enough) screenshots, video, etc. You should be creative, open for new inspirations, fresh minded, inventive, imaginative, ingenious and most important must know the affect, possiibilities of your work. Once again, you will be treated very individually and every one is a valued person for us. About our team, i assure you will be more than satisfied, feel the comfort and your respect among us. Now you feel you got what it takes to set sail for a adventurous journey? We will be glad to have a small interviewing talk via Teamspeak or skype. You may also apply directly at our website here We are thankful for every support! Please avoid offtopic discussions. With best Regards Wrath-WoW Team Beast
  10. ...
  11. {Major 3.3.5 Emulators} - Arcemu - Trinity - Mangos New Release by me. 19 Twink Vendors, I hope you all like it and I hope it becomes useful to someone. If there is anything wrong with my release please leave a reply telling me the problem so I can fix it. I try to add as many things to the vendors as possible but If you would like me to add something that would help everyone then post that below to. If you need any help you can also e-mail me at, chrisfofficial@live.com Screenshots Photobucket Downloads: Database Structure up to date as of May 11th, 2017 Extra: Comes with the option to set Sell and Buy prices to 0. Support me by clicking the like button to the bottom right of this post