eX-Core

DROP this code in your MSSQL ; /**************************************************************************This script will delete data from every table in the database except those specified in the @NoDeleteLst. @NoDeleteLst = Comma seperated list of all tables you DO NOT want this script to delete. Example: SET @NoDeleteLst = "Application,App_Parameter,Parameter" The above will keep the script from deleting from the Application,App_Parameter and Parameter tables. NOTE: SCROLL TO MIDDLE OF SCRIPT TO SET @NoDeleteLst. ***************************************************************************/ --Make sure fnSplit2 exists. If not...create it if exists (select * from dbo.sysobjects where id = object_id(N"[dbo].[fnSplit2]") and xtype in (N"FN", N"IF", N"TF")) drop function [dbo].[fnSplit2] GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE FUNCTION fnSplit2(@sText varchar(8000), @sDelim varchar(20) = " ") RETURNS @retArray TABLE (idx smallint Primary Key, value varchar(8000)) /******************************************************************************** ************************************* This function parses a delimited string and returns it as an ID"d table. Parameter Definition: --------------------------------- @sText = Delimited string to be parsed. @sDelim = Delimitation character used to seperate list ov values. RETURNS: --------------------------- Returns the table defined below: Column Description ---------- ------------------ idx ID column for array value Value split from list. ******************************************************************************** *************************************/ AS BEGIN DECLARE @idx smallint, @value varchar(8000), @bcontinue bit, @iStrike smallint, @iDelimlength tinyint IF @sDelim = "Space" BEGIN SET @sDelim = " " END SET @idx = 1 SET @sText = LTrim(RTrim(@sText)) SET @iDelimlength = DATALENGTH(@sDelim) SET @bcontinue = 1 IF NOT ((@iDelimlength = 0) or (@sDelim = "Empty")) BEGIN WHILE @bcontinue = 1 BEGIN --If you can find the delimiter in the text, retrieve the first element and --insert it with its index into the return table. IF CHARINDEX(@sDelim, @sText)>0 BEGIN SET @value = SUBSTRING(@sText,1, CHARINDEX(@sDelim,@sText)-1) BEGIN INSERT @retArray (idx, value) VALUES (@idx, @value) END --Trim the element and its delimiter from the front of the string. --Increment the index and loop. SET @iStrike = DATALENGTH(@value) + @iDelimlength SET @idx = @idx + 1 SET @sText = LTrim(Right(@sText,DATALENGTH(@sText) - @iStrike)) END ELSE BEGIN --If you can’t find the delimiter in the text, @sText is the last value in --@retArray. SET @value = @sText BEGIN INSERT @retArray (idx, value) VALUES (@idx, @value) END --Exit the WHILE loop. SET @bcontinue = 0 END END END ELSE BEGIN WHILE @bcontinue=1 BEGIN --If the delimiter is an empty string, check for remaining text --instead of a delimiter. Insert the first character into the --retArray table. Trim the character from the front of the string. --Increment the index and loop. IF DATALENGTH(@sText)>1 BEGIN SET @value = SUBSTRING(@sText,1,1) BEGIN INSERT @retArray (idx, value) VALUES (@idx, @value) END SET @idx = @idx+1 SET @sText = SUBSTRING(@sText,2,DATALENGTH(@sText)-1) END ELSE BEGIN --One character remains. --Insert the character, and exit the WHILE loop. INSERT @retArray (idx, value) VALUES (@idx, @sText) SET @bcontinue = 0 END END END RETURN END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO ------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------- --SET NO-DELETE LIST HERE (tbls you dont want to delete from) - Comma seperated list. "tbl1,tbl2,tbl3" ------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------- DECLARE @tbls TABLE(IDX int IDENTITY(1,1), Tbl varchar(255)) DECLARE @Tbl varchar(255) INSERT INTO @tbls(Tbl) SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = "BASE TABLE" AND LEFT(TABLE_NAME,2) <> "dt" --Disable Constraints PRINT "-----------------------------------------------" + CHAR(13) + CHAR(13) DECLARE curDeleteDB CURSOR FOR SELECT DISTINCT Tbl FROM @tbls OPEN curDeleteDB FETCH NEXT FROM curDeleteDB INTO @tbl WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN PRINT "Disabling constraints/triggers for - " + @tbl EXEC("ALTER TABLE [" + @tbl + "] NOCHECK CONSTRAINT ALL") EXEC("ALTER TABLE [" + @tbl + "] DISABLE TRIGGER ALL") END FETCH NEXT FROM curDeleteDB INTO @tbl END CLOSE curDeleteDB DEALLOCATE curDeleteDB --Delete Data PRINT "-----------------------------------------------" + CHAR(13) + CHAR(13) DECLARE curDeleteDB CURSOR FOR SELECT DISTINCT Tbl FROM @tbls OPEN curDeleteDB FETCH NEXT FROM curDeleteDB INTO @tbl WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN PRINT "Deleting from - " + @tbl EXEC("DELETE FROM [" + @tbl + "]") --If table has IDENTITY column reset the seed IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMNPROPERTY(OBJECT_ID("dbo." + @tbl) ,COLUMN_NAME,"IsIdentity") = 1 AND TABLE_NAME = @tbl ) BEGIN EXEC("DBCC CHECKIDENT (""" + @tbl + """, RESEED, 0)") END END FETCH NEXT FROM curDeleteDB INTO @tbl END CLOSE curDeleteDB DEALLOCATE curDeleteDB --Re-Enable Constraints PRINT "-----------------------------------------------" + CHAR(13) + CHAR(13) DECLARE curDeleteDB CURSOR FOR SELECT DISTINCT Tbl FROM @tbls OPEN curDeleteDB FETCH NEXT FROM curDeleteDB INTO @tbl WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN PRINT "Enabling constraints/triggers for - " + @tbl EXEC("ALTER TABLE [" + @tbl + "] CHECK CONSTRAINT ALL") EXEC("ALTER TABLE [" + @tbl + "] ENABLE TRIGGER ALL") END FETCH NEXT FROM curDeleteDB INTO @tbl END CLOSE curDeleteDB DEALLOCATE curDeleteDB SET NOCOUNT OFF

I offer you a ready-made code Block Buff from my server : Skilldata.txt skill_begin skill_name=[s_block_player_buff] /* [Fucking Noobs] */ skill_id=9016 level=1 operate_type=T magic_level=72 effect={{p_block_buff}} mp_consume1=0 reuse_delay=0 target_type=none next_action=none ride_state={@ride_none} skill_end Skill_pch.txt [s_block_player_debuff] = 2308097 Skill_pch2.txt 2308097 0 0 1 0 0 0 -1 0 0 0 0 -12345 edit the client ourselves, skillgrp.dat \ skillname.dat

Hello folks , here is the small code for you ! this code help you for remove the weight limit in game. tested and work. In order to change the character's weight limit you need to change weight limit skill : Open SKILLDATA.TXT and look for the skill there ; Find this skill_begin skill_name=[s_weight_limit1] /* [ok] */ skill_id=150 level=1 operate_type=P magic_level=10 main_effect={{p_weight_limit;100;per}} skill_end Where main_effect = {{p_weight_limit; 100; per}} - change 100 to 25000, all the weight limit is increased, you should get something like: skill_begin skill_name=[s_weight_limit1] /* [ok] */ skill_id=150 level=1 operate_type=P magic_level=10 main_effect={{p_weight_limit;25000;per}} skill_end credits : thanks to kick

Hello Dear Community, We will offer to each clan 1 AIO Buffer, our conditions are: - The clan should have over 15 online players - Create a topic on forum with the following information: Clan name : Clan leader : Members : Forum/Facebook Group : (optional), Respectly, L2Stage Developer / Admin

- Topic Updated // Official Opening 11.12.2021

Website : L2Stage.com Forum : L2Stage Forum Discord : L2Stage Discord Channel Official Opening 11.12.2021 Dear players! We are glad to inform you that the server opening will take place earlier than expected! http://www.forum.l2stage.com L2Stage will be open BETA on NOVEMBER 27 at 14:00 US time (-5 UTC), for Europe 19:00 (GMT + 1) at 22:00 Moscow time Thank you all for your support, we will be happy see you after 2 years! Server: Interlude PTS (L2OFF) -Stage (55x) Server: - Interlude (C6) - XP: 55x - SP: 55x - Spoil: 15x - ADENA: 200x Skills: - 100% Off. - Auto learning skills. - Some skills have been modified: - -Touch of life and Restore life only for group members, so they cannot be used to restore the life of RB. - Buffs only for group members (made on purpose so that there are no debuffs). -System of checking skills -Maximum distance of the skill "Transfer Pain" is 1500 (players will not be able to hide their summons far). Olympiad: -Weekly: 4 hours a day (2 hours at 10 pm and in the morning according to server time) -Minimum 5 participants are required to start fights -Only A grade objects with safe sharpening are allowed at the Olympiad. -Only outside class battles. Subclass & Nobless: -To obtain the subclass , all RBs and lunargents with hellfire oil are required (Some items were added to the GM shop); -Nobless quest: complete. Clans and Castles: -Implemented a complete interlude clan system. The maximum clan level is 8 with clan skills. -Clans in the alliance: maximum 3 -No penalties for leaving the clan or kick from the clan -Castle sieges weekly, on weekends. There are 2 siege castles available, the number of available castles will be increased depending on the players in the Farm Zones : -Elven Fortress [Level 80 Difficulty: Medium-Hard] -School of Dark Arts [Level 80 Difficulty: Medium-Hard] -Forge of the Gods [Level 80 Difficulty: Medium-Hard] -Cave of Trials [Level 72+ Difficulty: Medium] -Elven Ruins [Level 52+] -Around RB implemented PVP zone Additional features: -Offline shops. -No XP limit (A level 80 player can swing players of any level) -Implemented a system of rewards for PVP -Auto loot for Farm + NO Auto loot for Boss -NPC buffer in Giran has almost all the buffs that AIO buffers have (All buffs are available in the game). -AIO and NPC buffs last 2 hours and 30 minutes. Character buffs last for Ofu. -Implemented NPCs in Giran with all the necessary items / things. -Increased weight limit -No penalty for death -Available commands .expon / .expoff -Limited trade radius (to avoid the creation of private shops next to other players and NPCs) -Implemented system of attributes -Augmentation system -implemented -Removed Herbs Enchant Rates : -Safe sharpening for weapons: +5, maximum: +23 -Sharpening with an ordinary scroll: safe up to +5 -Armor / Jewelry: safe sharpening +3 (+4 for solid armor), maximum sharpening +10 -Armor / Jewelry safe sharpening with ordinary scroll: +3 Items: -Weapons with double SA drop from RB and added to the GM shop. -Promisance Armor drops from RB or through modified crafting. -Epic armors can be bought in the GM shop. Donations: -Blessed scrolls drop from RB and are available for donations -AIO buffers are available for donations. -Available increase the chance of sharpening for single SA S grade weapons (with safe sharpening). (Players must improve things themselves by more than +5) -Cosmetic items and pets are available for donations, as well as changing the nickname and changing the clan leader. -Information about the server being discussed ... Sincerely, L2Stage Administration

thank you so much for your works , does a good job and very good prices , so skilled & trustable .

you need to be upgrade your account to vip its low price.

excellent share bro , thanks you.

amazing share, thank you bro...

friends , thank you for yours good ideas , i will listen all ideas. I'm confused about features & rates i will work on this ideas. i will make whatver i think inside of my head. Thank you So much , Best Regards , Street-Gamer

Hello Everybody , i announce you very nice news from our new project. we have starting new project with BİG İNVESTMENT. We need your vote and opinion for make best and playable game create. Thanks for Vote. Best Regards , Street-Gamer

you check to access? i wanna test.

i will login and try to test but have problem about access. i cant test to moobs or others. give full access for demos please. and give skype for more information.

exclusive share , thank you for share.

thanks for share. keep up the goods works. amazing gatekeeper

any mod close this topic please. Money is Transfered. Thanks Psc-Exchange.com For Transfer my PaySafeCards...

any mod close this topic please. Already Shared.!

Hello Friends i have paysafecard so fast i need to transfer it please so fast help me for transfer it thanks Fast Fast Fast Fast Best Regards Serenity

Already Shared ! http://www.maxcheaters.com/forum/index.php?topic=162861.0

+1

this pack full of bugged man how you sale it and its private server . you can't sale it without admin access. any mod close this topic... This Server Files is shared sometime ago.. Here is link server + backup http://www.sendspace.com/file/fig58m check it. ^^ Own3d..

when addytzu keep to fix ?

NEW * Freya PVP Weapon +20 [ Dagger Weapon ] NEW * Freya PVP Armor +20 [ Light Armor ] Raid Jewels(5 jewels) +20 [ Valakas / Antharas / Baium / Queen Ant / Zaken ] i Accept PaySafecard & Paypal 35 Euro PaySafeCard / Paypal

hmm :D Good Packk .. Thanks F0r Share.. Keep Up The Good Works bro