Jump to content

Recommended Posts

Posted (edited)

Hello,

 

       Since a period I work on the L2OFF GM Panel and many people told me to add option for cached packets send for my application to not restart every time the server after they make a modification. OK , for that I need your help  for make me understand 100% how cached works for database modification and I need some information from you. So please , if you want to help me , fell free to post all you know about chaced propierties .

 

App: http://www.maxcheaters.com/forums/index.php?/topic/168444-l2off-gm-panel-v15-new/

 

Thank you in advance!

Best Regards

Edited by xeL
Posted (edited)

Cached works with L2Server in the shared memory about shared memory read THIS, as it name says, its a cache for better understanding read THIS it will give you some idea about it.
So mostly the CacheD stores the data for future use for the L2Server, and acts like a bridge between L2Server and SQL Server, executing all the queries and stored procedures. So when you send a packet directly to the CacheD is made available in-game, opposed to when you write it directly inside the database which doesn't make it available in-game cause the CacheD didn't loaded it in memory.

Also there is an old C4 dupe if i remember that occurs here due to a duplicated stack of items, one from CacheD and other from L2Server but that is a different story.

About formats of the packets, you can find them in the CacheD functions, i will check in my cloud and see if i can find a library that will work for you.

 

 

P.S: Mac correct me if im wrong, confused or missed something :P

Edited by Sighed
Posted (edited)

Thank you Sighed very much. I notice that is a bridge between l2server and database but i didn't knew how directly works. :) . If you can find that library will be very usefull. Thank you for help again. I apriciate.

Edited by xeL
Posted

Any changes can only be made to a character that is offline.

So often - you select directly in DB by char_name, get char_id and use it kickuser and then use one of the modify packets.

 

In one of your threads, i pastebinned the formats for all availeble packets in c4\gf.

(There's more in GF, but they're mostly the same).

Posted

Any changes can only be made to a character that is offline.

So often - you select directly in DB by char_name, get char_id and use it kickuser and then use one of the modify packets.

 

In one of your threads, i pastebinned the formats for all availeble packets in c4\gf.

(There's more in GF, but they're mostly the same).

 

 

Seems I didn't sow it on my post last time. Thank you for it mcbigmac for it.   http://www.maxcheaters.com/forum/index.php?/topic/168410-l2off-database-modification-without-restart-server/

Posted

I Found it, here is the paste, im not sure but these packets also should work with GF, i might make a separate one for GF when i will have some time. Anyway here you go, its pretty easy to understand.

http://pastebin.com/faREHjDj

Posted

Thank you Sighed. I will try my best to make it work. And to finish it as soon as posible . Best regards

  • 1 year later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • L2 DEVS - HTML DESIGN (ALL NPC'S)    
    • I only share for free what they are reselling 🙂 You keep crying in all the publications, and if you are looking for h5 or gd wait for 5 or 6 years... cheers.... GENERAL Cached Extended to 8192kb IOBuffer Hair2SlotCache ItemBidAuctioner Clan Hall Current Olympiad Season Rank pages System (Shows Points/Games - Fully Configurable) Automatic Flag Around Raidboss System Offline Shop & Buffers Restore After Restart (Fixed location) Offline Buffer System PvP Auto Announce System Rebuilt with Extra Addons (Fully Configurable, Name, Zones, Rewards) Automatic Announce System Rebuilt with Extra Addons (Fully Configurable) ALT+B Augmentation House Shift+Click Droplist/Spoil List Epic Items Rank RB points Rank ChangeColorName ChangeColorTitle Change Skin (Race) Change Gender Custom Subclass (Acumulative) Achievements Item Delivery System  Augmentations/Enchants Automatic Announce System Auto Learn Skills PvP Reward Pk Reward War Reward Scheme buffer GlobalChatTrade Trade Augment Items Castle Announce Time Castle Standby Time Fix Spiritshots delay SpellbooksDrop Enable/Disable Drop custom Fully configurable, lvl min max allmobs, allrb, individual New cancel effect min,max BlessedarmorEnchantRate BlessedmagicWeaponEnchantRate BlessednormalWeaponEnchantRate MaxSlosChars MaxSlotsDwarfs Enable or disable all commands Fix fast loading npc OlympiadRestoreStatsOnFightStart OlympiadSystemSecondTimeEnabled OlympiadEnterLast10Minute OlympiadThirdClassSummons MinLevelTrade AnnounceSubClassMsg1 AnnounceSubClassMsg2 AnnounceSubClassMsg3 LimitedSubClassRace NoSellItems Change ID SealStones for AA NoPrivateBuyItems NoDropPlayerOnDie DisableSkillEnchantData Show Level Mobs Show npc clan flag DespawnSummonEnBattle SummonPetEnBattle RideSummonPetEnBattle DitanceToTargetMove EnterWorld_Undying EnterWorld_UnHide BlockWhispMessagePlayerToGM UseItemsWithHide CriticalSkillDamageBonusPer=4.0 Disable SSQSystem OnCastle Siege End Use any dyes Buy halls directly in auctioneer without waiting for the auction, configuration to change the item you consume MensajeEnterWorldServer Command .hero enable/disable hero aura Config vip global chat character, chat by systemsg Soulshots: NoSendSystemMessageUse Panel //admin Global vote reward Agathions system Anti Interface, control all patch files by md5 Command .menu configurable, last restart, name, maxusers, privatestores Spawn protection activate deactivate consume items to activate  Activate or deactivate autoloot for vip characters EVENTS Happy Hour Event reworked Configurable by announcements or systemsg Team VS Team Capture The Flag Death Match Last Man Standing Destroy The Base Korean Style Castle Siege Check if the player is inside the tvt event due to disconnection/critical error Top 1/5 killer reward/announce TimeAfk ResetReuseSkills ResetBuffsOnFinish Firework effect Reward win/lost Add Team Location Title custom Red/blue Open Door/Wall System BalanceBishops Show kills in title Invest positions Show Death To Top Delete Non-Subclass Skills     RELOADS Reload Enterworld Html Option Reload Faction System Reload Donate Shop Reload OfflineBuffer Reload Champion NPC Reload CliExt Reload AntiBot Reload Vip System Reload Auction Reload AutoLoot Reload CastleSiegeManager Reload CharacterLock Reload ClanPvPStatus Reload AutoLearn Reload ClanReputationRank Reload ClanSystem Reload CreatureAction Reload Customs.ini Reload L2server.ini Reload SkillData.txt Reload doordata.txt Reload decodata.txt Reload Multisell Reload DropList   Extender tested for more than 3 years. Assured stability. Possibility of adding MOD's upon request. (Not included, consult).
    • some peoples trash is another mans treasure, is that your treasure?   people might like the content but you are still the rat in the room     thats the community judging you.  
    • Keep reselling what I publish here for free!!! 🙂 GG  
  • Topics

×
×
  • Create New...