Jump to content
  • 0

l2jfrozen, guards


Question

Posted (edited)

can i delete castle guards from anywhere? i mean not 1 by 1.

and 1 more question, how can i change  enchant skill Sp cost ?

Edited by dramaa93

5 answers to this question

Recommended Posts

  • 0
Posted (edited)
1 hour ago, dramaa93 said:

can i delete castle guards from anywhere? i mean not 1 by 1.

and 1 more question, how can i change  enchant skill Sp cost ?

I guess their type is L2SiegeGuardInstance you can make an SQL query and delete all ID from the spawnlist table of that type. 

 

On the other hand, why delete them from the database. Simply add a check in SpawnTable.java if template instance typeOf("L2SiegeGuard"), to continue and not perform any spawn of that instance. Faster way cause i doubt if your spawnlist contains the type of the spawn. This must in "custom_npc" or "npc.xml" if your NPCs are in xml format.

Edited by Kara
  • 0
Posted
On 2/22/2021 at 4:36 PM, dramaa93 said:

can i delete castle guards from anywhere? i mean not 1 by 1.

and 1 more question, how can i change  enchant skill Sp cost ?

i think this will work as well SQL~>

Spoiler

DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid = npc.idTemplate AND npc.level < 80 AND npc.type = 'L2SiegeGuard'; 

 

Guest
This topic is now closed to further replies.


  • Posts

    • You always find a way to lower the bar. Consistency matters. I admire your dedication to being completely unaware of how little you matter.     at least you are not entirely useless you can always serve as a bad example
    • hahahahahahahahahahahaha this says more about MaxCheaters than about me xD
    • I already finished my panel for change name and gender, anyway need restart, im used schema  $stmt = $conn->prepare("EXEC lin_ChangeCharacterName2 ?, ?, ?"); for change name... also for change gender i used if ($race == 5) // Kamael race ID; modify this value as per your database { $error = "Gender change is not allowed for Kamael race characters."; } else { $stmt = $conn->prepare(" UPDATE user_data SET gender = ?, face_index = 0, hair_shape_index = 0, hair_color_index = 0 WHERE char_id = ? AND account_name = ? "); Sorry no idea how to add cached update in myext64 about, not have any  solution for this yet compatible to myext64 code. This is my panel make in php http://177.73.143.43:8080/account/ Cool panel for me, without experience in any code. Without help from any people here 🙄
    • Базы данных от прямых источников!                                  Холодка                 Реги                 Депы                 Богатые физики                                  Много актуальных гео!                 Замена брака!                 Гарант+                                  Контакты                 ТГ - @yashkatsigun    
    • Don't listen to that idiot @Nightw0lf — he doesn't know or understand anything... he just talks nonsense. Here's the solution, just to prove that they're the useless ones giving you meaningless and useless answers.   function disableCharacter($charId){ $buf = pack("cVV", 0x14, $charId, 1); return $this->Send($buf); } function enableCharacter($charId, $accountId){ $buf = pack("cVV", 0x15, $charId, $accountId); return $this->Send($buf); } function kickCharacter($charId) { $buf = pack("cV", 0x05, $charId); $tmp = $this->Send($buf); sleep(2); return $tmp; } //-------------------------------------------------------------------------------- if ($func==7)//DESHABILITAR PERSONAJE { $char_id = $var1; $CACHED->kickCharacter($char_id); $respuesta = $CACHED->disableCharacter($char_id); RegistrarActividad("disableCharacter",$respuesta,GetCharNameByCharId($char_id)."(".$char_id.")",0,0,0,0); } else if ($func==8)//HABILITAR PERSONAJE { $char_id = $var1; $account_id = $var2; $CACHED->kickCharacter($char_id); $respuesta = $CACHED->enableCharacter($char_id,$account_id); RegistrarActividad("enableCharacter",$respuesta,GetCharNameByCharId($char_id)."(".$char_id.")",$account_id,0,0,0); } //-------------------------------------------------------------------------------- $CACHED->disableCharacter($char_id); $tabla = sqlsrv_query($conexion_lin2world, "UPDATE user_data SET xxxxxxxxxxxx WHERE char_id=".$char_id.""); $CACHED->enableCharacter($char_id,$account_id); Now just compare the stupidity said by that imbecile @Nightw0lf with the answer I gave you... Thanks to people like this, MaxCheaters is in the state it's in... They keep following useless people who are good for nothing 😉  
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock