Jump to content

L2jOrion.com - Interlude Server Files

Take a moment to join us, we are waiting for you.

Sign in to follow this  

Useful SQL commands in MariaDB

Recommended Posts

Just finished setting up my own server and ran into some SQLΒ commands that were very helpful. Improvise and change what you need how you need it and want it.Β 
Most of them are prettyΒ self explanatory but I'l do my best to explain


UPDATE buff_templates
SET itemid = 57; 

Updates table buff_templates and sets in each itemid to ADENA. Using same logic other tables and rows can be updated, inserted changed.


INSERT INTO `droplist` VALUES ('22105', '8085', '8', '15', '8', '1000000');

I used this to insert into specific raidboss a drop in this case (premium coin). values can be edited.


UPDATE `buff_templates` 
SET `useitem`='0' 
WHERE `itemId`='6393';

In this example we replace certain values where they can be found. If we have any itemID 6393 the sql swappedΒ  useitem to 0 which means not to use item. Its easy to edit this to change different stuff around without having to do it manualy by one. setting where condition only replaces it where it finds it and does not touche other rows.


UPDATE `droplist` SET `chance`='7500' 
WHERE `itemId`='6393' 
AND chance='15000';

This is the one I use more frequently when I want to chance lets say drop chance for 1 item, but the item has been inserted into many RB's. We set the Where condition to find the item, we set the new chance , and the last row AND chance only finds where the item has this specific chance to drop. I have inserted the same item into other raidboses with different chance and did not want to change that.Β 
I will update more as I go on.Β 

  • Like 1

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Posts

    • Hello,
      It can not be hidden, because the real member status is temporary thing and all members must see when update coming up.
    • yeah I guess this category should be hidden all together bcs now it's confusing
    • Yeah, just remove it from htm and done.
    • Hello,
      Easiest and fastest disabling i thinkΒ  is just remove fromΒ .menu htm file.
    • Orion PackΒ - supports all Lineage 2 Interlude official features and has many own additional unique features. Just a few mentioned below for now and i will update it later. Also, any feature can be turned off inside pack config. All quests fully working and updated by Lineage 2 Interlude official information. Everything can be checked in test server with full npcs and special commands for testers.

      Events Team vs Team (Possible add more than 2 teams) Deathmatch Capture the Flag Special NPCS Buffer - Possible use like simple or mixed mode withΒ schemes (save/load). Buffs for pets and players. Cancellation of buffs can be one by one or all at once. Also, buffer has a healΒ function, premium buffs, auto buffΒ lists (fighter/mage),Β and buffs for special item. Available special command for player andΒ add to Community Board too. Global gatekeeper - player can use simple, premium and for special item teleports.Β Available special command for player andΒ add to Community Board too. Also, possible to change the time of gk animation.Β  GM Shop - it has special donate item and special functions for donators like: no karma, clan functions, premium time, name/tile colors and etc.Β Β Available special command for player andΒ add to Community Board too. Marketer - It's selling/buying system where player can add any item for special item (unlimited currency) and also possible add enchanted or augmented items.Β Β Available special command for player andΒ add to Community Board too. Class Manager - Can be like npc or pop up menu. Possible add price or reward for class, pets upgrade. Special command available. Wedding Manager. Geo-Engine Added newest geo-engine which works like Lineage 2 official. Special Player Commands .menu - Additional player functions in one place: exp on/off, title with pvp/pk (live update), block buffs, auto pick up on/off, trade on/off, private messages on/off, screen text pop up like critical, damage and etcΒ on/off, falling to textures auto correction, change password, repair character and auto potions (working with all potions). .boss - Simple and epic bosses in one place. Possible see alive status, dead time, boss lvl and clicked on boss name you can get location to boss. .votereward -Β  Vote system for reward . Added Topzone, Hopzone, L2network and L2jBrasil). .bank - Adena and your chosen item exchanger. .subΒ - All sub-classes in one place. .sellbuffsΒ - Possible sell your own buffs. Special Server Configs Download:Β You must be signed in to view the link content in this post. Please Sign In or Sign Up. Special Zone Manager Download:Β You must be signed in to view the link content in this post. Please Sign In or Sign Up.
  • Topics