Discussion Change name table not update Myext64

[maneco]

i create a web service for change character name, in table 

CREATE TABLE [AddedServiceList](
	[idx] [int] NOT NULL,
	[postDate] [datetime] NOT NULL,
	[serviceType] [tinyint] NOT NULL,
	[fromUid] [int] NOT NULL,
	[toUid] [int] NULL,
	[fromAccount] [nvarchar](24) NULL,
	[toAccount] [nvarchar](24) NULL,
	[fromServer] [tinyint] NOT NULL,
	[toServer] [tinyint] NULL,
	[fromCharacter] [nvarchar](24) NOT NULL,
	[toCharacter] [nvarchar](24) NULL,
	[changeGender] [bit] NULL,
	[serviceFlag] [smallint] NOT NULL,
	[applyDate] [datetime] NULL CONSTRAINT [DF_AddedServiceList_applyDate]  DEFAULT (getdate()),
	[reserve1] [varchar](200) NULL,
	[reserve2] [varchar](100) NULL,
	[toMainClassNum] [int] NULL
) ON [PRIMARY]

This table have a dellay for update in server? Like clan change leader 1 time per week?

Because not change name instant? I try restart server but also not update char names.... Need wait any time for change name?

                                        $serviceFlag = 0; // Pending
                                        $stmt = $conn->prepare("
                                            INSERT INTO AddedServiceList 
                                            (idx, postDate, serviceType, fromUid, fromAccount, fromServer, fromCharacter, toCharacter, serviceFlag) 
                                            VALUES (?, GETDATE(), 3, ?, ?, 1, ?, ?, ?)
                                        ");
                                        $stmt->execute([$next_idx, $char_account_id, $char_account_name, $current_name, $new_name, $serviceFlag]);

 

[Tinker123aa]

there are extenders that already have all that included ingame

for example GX-EXT

[maneco]

I prefer using MyExt64 clean, i`m already finished, only need restart or maintenance for udate in game here. Due webpage not update instant, only change values in sqlserver. But is all working. Not have any option for change instant in game and not require restart?

[Tinker123aa]

8 hours ago, maneco said:

I prefer using MyExt64 clean, i`m already finished, only need restart or maintenance for udate in game here. Due webpage not update instant, only change values in sqlserver. But is all working. Not have any option for change instant in game and not require restart?

 

Yes you can and it is very easy, I hope that the imbeciles that you defend better answer you, we will see how many people help you!!!

I just want to see who will help you and then laugh.

[Nightw0lf]

On 6/11/2025 at 12:12 PM, Tinker123aa said:

there are extenders that already have all that included ingame

for example GX-EXT

very helpful comment

7 hours ago, Tinker123aa said:

 

Yes you can and it is very easy, I hope that the imbeciles that you defend better answer you, we will see how many people help you!!!

I just want to see who will help you and then laugh.

when you say to some random person that is asking for help this: "I hope that the imbeciles that you defend better answer you" indicates you have serious psychological issues, you are a problem for the community at this point  read the rules and stop spreading the toxicity virus you are infected with, seek professional help.

 

 

on topic, l2off servers have the issue of real time name changing through website and CacheD server, in some of them even successfully return no errors but its still not working, the player has to restart the game afterwards so in best case you log them out, thats all i can tell you from the website side development.

On 6/9/2025 at 3:05 PM, maneco said:

$serviceFlag = 0; // Pending
                                        $stmt = $conn->prepare("
                                            INSERT INTO AddedServiceList 
                                            (idx, postDate, serviceType, fromUid, fromAccount, fromServer, fromCharacter, toCharacter, serviceFlag) 
                                            VALUES (?, GETDATE(), 3, ?, ?, 1, ?, ?, ?)
                                        ");
                                        $stmt->execute([$next_idx, $char_account_id, $char_account_name, $current_name, $new_name, $serviceFlag]);

i suggest this to be inside try/catch

dont use advext the guy gives errors in the documentation of the website connections and calls other developers idiots who cant make it

i have rewrote this function fully (this function contains the errors) 

https://wiki.depmax64.com/index.php/Список_php-функций_для_работы_с_пакетами_IL

and still i made everything work except the rename, this can be done with other methods and SQL side using function queries

[Tinker123aa]

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
 

[maneco]

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 

Edited 3 hours ago by maneco