SQL, Database and Migrations
33 topics in this forum
-
- 1 follower
- 0 replies
- 85 views
I created two functions so you can capture which Class is the user's Character, where it is necessary to pass the character's name as a parameter, I made it in the form of a function where you can even use it in other Selects... GetShortClass - Returns abbreviated class --Function to Capture the short name of the user Class (Parameter and user name) CREATE FUNCTION [dbo].[GetShortClass](@Nome NVARCHAR(10)) RETURNS NVARCHAR(10) AS BEGIN DECLARE @ShortClass NVARCHAR(10) SELECT @ShortClass = CASE WHEN Class = 0 THEN 'DW' WHEN Class = 1 THEN 'SM' WHEN Class = 3 THEN 'GM' WHEN Class = 7 THEN 'SW' …
Last reply by kristensen2109, -
-
- 2 followers
- 1 reply
- 53 views
Do I have to translate each one separately? https://ibb.co/8bMrQD1
Last reply by drakelv, -
-
- 3 followers
- 3 replies
- 186 views
I agree to forum rules and posting guidance: Let's say that 75% of my HD usage after using it went to 10%.If you helped me, you can help everyone.
Last reply by StefanoAAguiar, -
- 2 followers
- 0 replies
- 135 views
Hello , i just wanted to share this script that some young server administrators may find useful. This script will show you the highest wcoins/ruud holders by order. WCoins top accounts Spoiler SELECT [WCoin] ,[AccountID] FROM [MuOnline].[dbo].[T_InGameShop_Point] ORDER BY WCoin DESC Ruud top characters Spoiler SELECT [Ruud] ,[Name] FROM [MuOnline].[dbo].[Character] ORDER BY Ruud DESC
Last reply by johnnyssk, -
- 3 followers
- 3 replies
- 114 views
Hi, im looking for table: next event time information (Blood castle, devil square, etc). Thanks
Last reply by Maiev, -
-
- 1 follower
- 44 replies
- 2.1k views
I agree to forum rules and posting guidance: Hello guys,Through this I come to share with you the customization I made when creating characters.By using this procedure you can determine which new characters start the game using time stamps.Remember that it is only valid to determine days in the current procedure. Why am I sharing for free? : I see that other Administrators are charging for something without wanting to at least have the job of developing the customization. Profiting from other developers' authoring codes. In order to avoid this clowning I am sharing my procedure with the community. 100% compatible with Season14 part - 1 If you want the procedure with deter…
Last reply by granzeneon, -
-
- 1 follower
- 2 replies
- 405 views
I agree to forum rules and posting guidance: Since there are lots of server administrator asking for this script PS: I don't own this script and this script is made by DGS Team Use it at your own risk, any damages to your SQL is not my fault so make sure to back up "WZ_CreateCharacter" What does the script do: Gives new players buff that you inserted in the script below USE [MuOnline] GO /****** Object: StoredProcedure [dbo].[WZ_CreateCharacter] Script Date: 3/9/2021 6:08:27 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER Procedure [dbo].[WZ_CreateCharacter] @AccountID varchar(10), @Name varchar(10), @Class tinyint AS BEGIN SET NOCOU…
Last reply by MrJunior, -
-
- 2 followers
- 6 replies
- 188 views
Hello, I'm trying to mark all the quest as completed on character creation, but i can't understand how, as it is a Varbinary data, and i really don't know what's the default data when the quest is completed or not. I know is possible to do it, as the essential tool have the option to complete the quests, i also tried to run a query to check what Sql script is running after the essential tool mark the quest as completed, but i wasn't able to find anything helpful. Can you please help me? Thank you so much!
Last reply by Wizzy, -
-
- 1 reply
- 100 views
I agree to forum rules and posting guidance: Hi Where can i can table for Blood Castle and Devil Square Ranking? and how can i delete all the data to start event thank you
Last reply by MiniBestia, -
- 1 follower
- 0 replies
- 147 views
I agree to forum rules and posting guidance: Hello, I want to merge 2 databases, in this script need to change user name or character name if have a same name and make a report about this to notify to users Have any useful script to do this? Thank so much!
Last reply by granzeneon, -
- 1 reply
- 224 views
I agree to forum rules and posting guidance: Hi all. I need assistance. There are two MuOnline databases: 1st db: MuOnline1 2nd db: MuOnline2 Each database has accounts, characters, cashshop credits, and etc. I'm interesting in merge from 1st db (MuOnline1) to 2nd db (MuOnline2). The problem is that i need to merge only characters with 5+ Resets and it's accounts, not all database. The second problem is that there are can be duplicated characters names, so we need to insert some random symbol to make it work correct. Maybe someone has a experience in that and can help me?
Last reply by granzeneon, -
- 2 replies
- 99 views
Good people! I recently taught this to someone and they are reselling the system and I don't think it's fair for people to pay for something so simple that I use it for years. So I'll be posting here ok! Link Tutorial: Link Download Jobs: https://drive.google.com/file/d/10Rp7Uw6yghl4ueVTW_tbsyRO7QqgyLqT/view?usp=sharing Programa utilizado:Cobian Backup 11 JOB before running the JOB, create the folder C:\FTP_BACKUP\06Hs:
Last reply by StefanoAAguiar, -
- 0 replies
- 58 views
I agree to forum rules and posting guidance: Hi, I'm transferring the warehouse data to a new database. I'm generating a script and then I charge the script with the following command:cd C:\Users\root\Documents sqlcmd -S SQLServerName -i script.sql The problem is that it fails to load the script when it is generated with unicode text. When generated in ANSI text everything works correctly and I can load the script to the new database. The question is, does something happen if I do it in ANSI instead of Unicode text? Always use unicode by default. Can doing so in ANSI create future problems? I don't understand much about it and I want to make sure that ANSI is okay and wi…
Last reply by Sistem, -
- 1 reply
- 207 views
I agree to forum rules and posting guidance: Dear all, I am so happy to start new server, so i need some script to make gifts to player, pls help me in the best: 1, Send a gifts include zen, level, point to start, set items, pet and wing (limit 7 day) 2. Script to delete all charactor, item in vault after alpha test Note that all script run in Me MuOnline and MuOnline, using for season 15 part 1.3 Thank you so so so much!!!
Last reply by KarLi, -
- 13 replies
- 134 views
I agree to forum rules and posting guidance: Hello IGCN Community, I'm just wondering if you guys have a trigger or SQL script to make a full backup of database every x hours? I'm using this so called SQLBackupandFTP program but it's not backing up with the desired hours i made Thank you!
Last reply by Mpsmith, -
- 0 replies
- 64 views
I agree to forum rules and posting guidance: Anyone have a query to find how many people has an specific item? I mean, i want to find how many people has an item on the inventary/vault and build a ranking on my website.
Last reply by mulandia, -
- 2 replies
- 114 views
I tried to install the 'webenginecms' CMS. The installation is being done in a webhosting Cpanel. I don't get installation errors by 'PDO Driver' Dblib (Linux). The problem is when trying to install in the 'PDO Driver' ODBC (Windows) https://i.imgur.com/j7JjYL5.jpg After these tests I concluded that the problem is in the configuration within my dedicated server. I do not have the knowledge to locate the error, so I ask for help from you through this forum. Regards!
Last reply by SasukeTL, -
- 1 reply
- 92 views
I agree to forum rules and posting guidance: Hi all i've idea to use GP as a Online Point for player but didn't know how to coding if someone can share or make it work please help me my idea is if account id got member_stat = 1 every hour will got 1 gp except if character in account stay on map 79 any suggestion to make this ?
Last reply by Valkyr666, -
-
- 1 follower
- 10 replies
- 529 views
I agree to forum rules and posting guidance: Hail guys, I'm kind of out of time to pay attention to the procedure, I wonder if anyone would like to adapt the procedure for season 13, currently the procedure works only for season 9 and 12. If someone wants to share with the crew and update the procedure for season 13 follows the same below: USE [muonline] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER Procedure [dbo].[WZ_CreateCharacter] @AccountID varchar(10), @Name varchar(10), @Class tinyint AS BEGIN SET NOCOUNT ON SET XACT_ABORT ON DECLARE @Result tinyint SET @Result = 0x00 IF EXISTS ( SELECT Name FROM C…
Last reply by MrJunior, -
-
- 1 follower
- 8 replies
- 142 views
I agree to forum rules and posting guidance: Hail guys, Through this I have made available a trigger for creation of Ranking - Daily, Weekly and Monthly, I created for my server and it worked 100% if someone else needs I am sharing it with you. 1. Create new columns: USE[MuOnline] GO ALTER TABLE [dbo].[Character] ADD [R_Day] INT NOT NULL DEFAULT (0) GO ALTER TABLE [dbo].[Character] ADD [R_Week] INT NOT NULL DEFAULT (0) GO ALTER TABLE [dbo].[Character] ADD [R_Month] INT NOT NULL DEFAULT (0) GO2. Run the Trigger in the MuOnline database SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER dbo.Trigger_CharacterReset ON dbo.Character AFTER UPDATE AS BEGI…
Last reply by MrJunior, -
-
- 1 reply
- 70 views
I agree to forum rules and posting guidance: Hi Community, I have some characters 5/6 of 5000 that when go to kill mobs for gens quest. The Count of Killed monsters dont works are static on 0/50. I Tried leveaving gens, enter opposite gens, cancel quest, retry quest, etc All variables possible, and nothing There is a chance to restart complete informacion of these characters vinculated to Quest? Regards.
Last reply by Wizzy, -
-
- 0 replies
- 62 views
I agree to forum rules and posting guidance: i 've a problem about item option higher than 16 got expensive repair cost then i want to decreease all item in server how to query it
Last reply by Mpsmith, -
-
- 1 reply
- 123 views
I agree to forum rules and posting guidance: Hi Guys, how can i make a querry to delete all items of my server? (Invetories, Warehouse, PersonalShop Items) Thanks!
Last reply by Wizzy, -
-
- 0 replies
- 210 views
Server Season: Season 12 Files Version: 12.0.1.31 Database Type: Me_MuOnline + MuOnline I agree to forum rules and posting guidance: Hello, I created a store procedure to add some items to support my newbie gamer when they create a new character. when exec this store, sometime it raise an error: SQL State Error: 42000 (Invalid cursors state) and at this point, the data server cannot process any sql statement yet and gamers cannot login, some user already online will be dupe item, lost item, ... Here is my code: USE [L3Promotion] GO /****** Object: StoredProcedure [dbo].[L3_BeginnerSupport] Script Date: 12/4/2017 7:35:22 PM ******/ SET ANSI_NULLS ON GO SET QUO…
Last reply by kiatas102, -
- 4 replies
- 162 views
I agree to forum rules and posting guidance: Hello. SQL server 2016 Express memory limitation is 1410 MB. But I remember in task manager of my old server SQL server memory usage was over 2,5 GB. I want to know if that limitation is this one? Or that memory is about to use of related per each database. I believe I was using sql server 2008 r2 enterprise cracked in my old host. Now I'm worried if my SQL server 2016 express has problems when its ram usage goes over memory limitation describes in microsot website. If someone can explain me I will be happy. Have a good day :)
Last reply by Elif, -
- 0 replies
- 110 views
Hello guys, Just wondering that some of you might have made this before, Was just thinking if there's a Query you guys can share to make an AUTO INSERT ITEM in GREMORY CASE Everytime there's a new account, could be use as automatic freebies. Thank you in advance
Last reply by nexuzmu12, -
- 0 replies
- 59 views
I agree to forum rules and posting guidance: Hello IGCN Community! I am looking for someone who has advance knowledge on MS SQL that can help me. Im willing to pay for the charges. Please add my skype muphil_adelphos for easy communication. Thanks!
Last reply by muphil2015, -
- 0 replies
- 67 views
Hi I Try To Make Renzme System from website with Availiable Function For Less Problem But When I Run This Code Value Always Return 2 That's Mean I Can't Rename Character Anyone Can Explain how to use this function ? http://i.imgur.com/bZAH6pT.jpg sorry if wrong section becuz this problem related to sql function i'm not sure for start topics in general server suite support section
Last reply by Mpsmith, -
-
- 7 replies
- 420 views
I've been trying to transfer my titan tech database to the igcn database and for the most part the tables are similar and I've transferred all non binary data across. However I'm having problems transferring the warehouse table and inventory data across. I'm able to insert the warehouse and inventory data into the igcn DB however it's all messed up, when i first logged in I saw: http://i.imgur.com/UnMfYbk.jpg and a lot of the items were missing from the vault and inventory. So is there anyway I keep my inventory/warehouse data from the titan tech DB or should I just clean those tables and start fresh?
Last reply by Wizzy, -
-
- 3 replies
- 205 views
Hello, About 2 years ago, i finded the QA command, to decrease database log file size to 1 MB (or delete it, i just forgot the action). Now i really need it, but can't find, maybe some-one have it?
Last reply by dym, -
-
- 3 replies
- 273 views
I was previously using TItan tech 11.70.28 and their database and I've transferred all data across to the IGCN database now and have converted the items using the '32b convertor' in the tools. My other thread was here: http://community.igcn.mu/topic/239-issues-transferring-vault-and-inventory-data-to-new-db/ While all the items from the previous database exist, many of them have wrong sockets and almost all previous items seem to have this socket option combination: http://i.imgur.com/hoxYKGw.png and many items that didn't even have sockets now have sockets and this socket combination..I've tried disabling socket options on some items on the titan tech server and then r…
Last reply by vitaleha, -
-
- 3 replies
- 148 views
Hello, Did someone tried to configure SQL server and change memory (RAM) usage from unlimited to like 4GB? I just thinked today, why SQL need to eat 11.1GB of ram from my server? If i can just set limit for 4gb, i found a tutorial in google, but im afraid to put it.. Maybe someone do this, and can tell me, its not causing any problems to IGCN server files, and website service???
Last reply by diegoads89, -
-
- 3 replies
- 167 views
Hello, If I decide to upgrade my server version to ex702 I would like to know some things. How dangerous is it to do it? Is the upgrade accurate and migrates all the data 100%? If so, please let me know the migration script and any other information needed to proceed. Sincerely, Netzo.
Last reply by Wizzy, -