SMC To Send Announcement

[serend]

does smc connect to mssql to send the announcement or is it sent direct into gameserver
ive been looking in storedprocedures to check but not found anything as yes was just going to create a cronjob to send auto announcements every x as other announcement apps only allow you to send one message.


also looking at some storedprocedures in shard like _DeleteCharPermanently with this would we just

EXEC _DeleteCharPermanently CharName

and would delete the char as this would be a nice way to delete all those char lvl 1 that clog the database ?

 

[PortalDark]

does smc connect to mssql to send the announcement or is it sent direct into gameserver
ive been looking in storedprocedures to check but not found anything as yes was just going to create a cronjob to send auto announcements every x as other announcement apps only allow you to send one message.


also looking at some storedprocedures in shard like _DeleteCharPermanently with this would we just

EXEC _DeleteCharPermanently CharName

and would delete the char as this would be a nice way to delete all those char lvl 1 that clog the database ?

It is via globalmanager

Sent from my Samsung Galaxy SII

 

[Jangan]

no... the stored procedure will not work... it will just UN-LINK a char from the "ACCOUNT" but the character will stay in the database almost 100% with items and everything...

im not sure what stored procedure or multi-stored procedures the game uses to flawlessly delete a character 100%, i did not really look into it a lot..

 

[Madelyn]

But LasThief release AIO Server Manager but this delete the account with all chars i think.. So can be possible extract only the part where delete the chars withour the JID and TBUser. But noboddy have time to do it like a query or .exe..

 

[PortalDark]

But LasThief release AIO Server Manager but this delete the account with all chars i think.. So can be possible extract only the part where delete the chars withour the JID and TBUser. But noboddy have time to do it like a query or .exe..

The notice is via globalserver, i got AIO source(in fact it was my idea for that name) and most of things are done sending packages to the globalmanager, notices being one those
About delete, a simple query can delete accs without characters
I may take a look at my when i get home
Sent from my Samsung Galaxy SII

 

[LastThief]

[C->S]
opcode : 0x7203
[word] : shard manager module id
[byte] : flag. 0x04: send notice
[byte] : 0x40 (unknown)
if (flag == 0x04)
{
[string] message
}

*Note it's not completely parsed I cannot identify the unknown byte till now I don't know if it differs from 1 certification to another I'm still testing it if you got it parsed correctly, tell me

 

[serend]

[C->S]
opcode : 0x7203
[word] : shard manager module id
[byte] : flag. 0x04: send notice
[byte] : 0x40 (unknown)
if (flag == 0x04)
{
[string] message
}

*Note it's not completely parsed I cannot identify the unknown byte till now I don't know if it differs from 1 certification to another I'm still testing it if you got it parsed correctly, tell me

nice might beable to make a better auto announcement as one sout only allow to send one msg

 

[pushedx]

*Note it's not completely parsed I cannot identify the unknown byte till now I don't know if it differs from 1 certification to another I'm still testing it if you got it parsed correctly, tell me

0x4004 is the opcode of the command (notice) that is being relayed through the GlobalManager to the ShardManager.

If you remember my code for MassiveMessage, it's a somewhat similar concept in terms of wrapping the data, just for a different reason.

If you search for that constant in SR_ShardManager, you'll find the packet handler registration code for the incoming packets the exe processes. It's basically push handler, then push opcode.