Discord Bot Configuration for Louis Emulator

[Dorin]

Discord Bot Configuration for Louis Emulator

Hello everyone!

I've created a configuration for a Discord bot to help manage various aspects of a MuOnline server. This bot can respond to commands such as checking how many players are online, managing character resets, and more. The code interacts with the MuOnline server's database through SQL queries to retrieve relevant information.

This bot is useful for Louis Emulator and can automate common tasks, saving time for both players and administrators. Feel free to use this configuration for your own server or modify it to suit your needs.

Here's a quick rundown of the available commands:

• /online - Check how many players are currently online.
• /resetcount - Show the number of resets a character has.
• /setreset - Set the number of resets for a character.
• /infochar - Show detailed information about a character (resets, level, etc.).
• /infoacc - Check the total number of accounts on the server.
• /addwc, /addwp, /addgp - Add WCoinC, WCoinP, or GoblinPoint to a user's account.
• /remwc, /remwp, /remgp - Deduct WCoinC, WCoinP, or GoblinPoint from a user's account.
• /infocredits - Show information about a specified account's credit balance.
• /commands - List all available commands for users.
• /admincommands - List all admin-only commands.

You require the following to view this post content:

• You must thank this post to see the content.

[Dorin]

Discord Bot Commands List: Update 1.0

In this post, you will find detailed descriptions of all the bot commands from 0 to 17 for your Discord server. These commands help you manage player accounts, view online statuses, and much more.


Command 0: online
Description: Checks the number of players online on the server.

Code Select Expand

Command: online
Query: SELECT count(*) as value1 FROM MEMB_STAT where connectstat = 1
Reply: In this moment, there are # %d players online!This command allows you to see the current number of players online at any given time.

Command 1: commands
Description: Displays the list of available commands.

Code Select Expand

Command: commands
Query: SELECT 1
Reply: /online - See the number of players online # /info - Display information about a character # /accounts - Check the total number of accounts on the serverThis command lists all the commands that players or administrators can use, making it easier to understand the available options.

Command 2: info
Description: Displays information about a character.

Code Select Expand

Command: info
Query: SELECT name as value1, resetcount as value2, masterresetcount as value3, clevel as value4 FROM character WHERE name=?
Reply: Character %s: # %d resets # %d master resets # Level: %d!This command provides essential details about a specific character, including the number of resets, master resets, and the character's current level.

Command 3: totalaccounts
Description: Checks the total number of accounts on the server.

Code Select Expand

Command: totalaccounts
Query: SELECT count(*) as value1 FROM MEMB_INFO
Reply: There are a total of # %d registered accounts!This command shows the total number of registered accounts on the server, helping administrators track server growth.

Command 4: addwc
Description: Adds a value to WCoinC for a user.

Code Select Expand

Command: addwc
Query: UPDATE CashShopData SET WCoinC = WCoinC + ? WHERE AccountID = ?
Reply: WCoinC value for user %s has been updated!This command allows administrators to add a specified amount of WCoinC to a user's account.

Command 5: addwp
Description: Adds a value to WCoinP for a user.

Code Select Expand

Command: addwp
Query: UPDATE CashShopData SET WCoinP = WCoinP + ? WHERE AccountID = ?
Reply: WCoinP value for user %s has been updated!This command adds WCoinP to a user's account, allowing administrators to reward players with points.

Command 6: addgp
Description: Adds a value to GoblinPoint for a user.

Code Select Expand

Command: addgp
Query: UPDATE CashShopData SET GoblinPoint = GoblinPoint + ? WHERE AccountID = ?
Reply: GoblinPoint value for user %s has been updated!This command adds GoblinPoints to a user's account, which can be used in special in-game features or events.

Command 7: infocredits
Description: Displays information about a specified account.

Code Select Expand

Command: infocredits
Query: SELECT AccountID as value1, WCoinC as value2, WCoinP as value3, GoblinPoint as value4 FROM CashShopData WHERE AccountID = ?
Reply: Account %s has the following values: WCoinC: %d, WCoinP: %d, GoblinPoint: %d!This command displays an account's WCoinC, WCoinP, and GoblinPoint values, allowing for easy credit management.

Command 8: remwc
Description: Deducts a value from WCoinC for a user.

Code Select Expand

Command: remwc
Query: UPDATE CashShopData SET WCoinC = WCoinC - ? WHERE AccountID = ?
Reply: WCoinC value for user %s has been updated!This command allows administrators to deduct a specific amount of WCoinC from a user's account.

Command 9: remwp
Description: Deducts a value from WCoinP for a user.

Code Select Expand

Command: remwp
Query: UPDATE CashShopData SET WCoinP = WCoinP - ? WHERE AccountID = ?
Reply: WCoinP value for user %s has been updated!This command deducts WCoinP from a user's account, useful for penalty adjustments or corrections.

Command 10: remgp
Description: Deducts a value from GoblinPoint for a user.

Code Select Expand

Command: remgp
Query: UPDATE CashShopData SET GoblinPoint = GoblinPoint - ? WHERE AccountID = ?
Reply: GoblinPoint value for user %s has been updated!This command deducts GoblinPoints from a user's account when necessary.

Command 11: admincommands
Description: Displays the list of commands for admins.

Code Select Expand

Command: admincommands
Query: SELECT 1
Reply: /setreset - Set resets # /addwc - +WCoinC # /addwp - +WCoinP # /addgp - +GoblinPoint # /infocredits - Account info # /remwc - -WCoinC # /remwp - -WCoinP # /remgp - -GoblinPointThis command provides a list of special commands available to administrators for managing accounts.

Command 12: infoip
Description: Displays the IP of a specified user.

Code Select Expand

Command: infoip
Query: SELECT memb___id as value1, IP as value2 FROM MEMB_STAT WHERE memb___id = ?
Reply: %s has IP: %sThis command allows administrators to view the IP address associated with a specific user account.

Command 13: userinfo
Description: Displays details about a specified account.

Code Select Expand

Command: userinfo
Query: SELECT memb___id as value1, memb__pwd as value2, mail_addr as value3 FROM MEMB_INFO WHERE memb___id = ?
Reply: %s: Password: %s, Email: %sThis command shows essential information about an account, including the password and email address.

Command 14: findaccount
Description: Displays the account associated with a specified character.

Code Select Expand

Command: findaccount
Query: SELECT AccountID as value1 FROM Character WHERE Name = ?
Reply: The account associated with the specified character is: %sThis command helps administrators find the account associated with a specific character.

Command 15: listcharacters
Description: Displays all characters on a specified account.

Code Select Expand

Command: listcharacters
Query: SELECT Name as value1 FROM Character WHERE AccountID = ?
Reply: The characters on the specified account are: %sThis command lists all characters associated with a given account.

Command 16: banacc
Description: Blocks a specified account.

Code Select Expand

Command: banacc
Query: UPDATE MEMB_INFO SET bloc_code = 1 WHERE memb___id = ?
Reply: The account has been successfully blocked!This command prevents access to a specified account by blocking it.

Command 17: unbanacc
Description: Unblocks a specified account.

Code Select Expand

Command: unbanacc
Query: UPDATE MEMB_INFO SET bloc_code = 0 WHERE memb___id = ?
Reply: The account has been successfully unblocked!This command restores access to a previously blocked account.


These commands allow administrators to efficiently manage player accounts and the server. Should you have any questions or need further assistance, feel free to reach out to the administration team.

You require the following to view this post content:

• You must thank this post to see the content.

[Dorin]

Discord Bot Commands List: Update 1.0

In this post, you will find detailed descriptions of all the bot commands from 0 to 17 for your Discord server. These commands help you manage player accounts, view online statuses, and much more.


Command 0: online
Description: Checks the number of players online on the server.

Code Select Expand

Command: online
Query: SELECT count(*) as value1 FROM MEMB_STAT where connectstat = 1
Reply: In this moment, there are # %d players online!This command allows you to see the current number of players online at any given time.

Command 1: commands
Description: Displays the list of available commands.

Code Select Expand

Command: commands
Query: SELECT 1
Reply: /online - See the number of players online # /info - Display information about a character # /accounts - Check the total number of accounts on the serverThis command lists all the commands that players or administrators can use, making it easier to understand the available options.

Command 2: info
Description: Displays information about a character.

Code Select Expand

Command: info
Query: SELECT name as value1, resetcount as value2, masterresetcount as value3, clevel as value4 FROM character WHERE name=?
Reply: Character %s: # %d resets # %d master resets # Level: %d!This command provides essential details about a specific character, including the number of resets, master resets, and the character's current level.

Command 3: totalaccounts
Description: Checks the total number of accounts on the server.

Code Select Expand

Command: totalaccounts
Query: SELECT count(*) as value1 FROM MEMB_INFO
Reply: There are a total of # %d registered accounts!This command shows the total number of registered accounts on the server, helping administrators track server growth.

Command 4: addwc
Description: Adds a value to WCoinC for a user.

Code Select Expand

Command: addwc
Query: UPDATE CashShopData SET WCoinC = WCoinC + ? WHERE AccountID = ?
Reply: WCoinC value for user %s has been updated!This command allows administrators to add a specified amount of WCoinC to a user's account.

Command 5: addwp
Description: Adds a value to WCoinP for a user.

Code Select Expand

Command: addwp
Query: UPDATE CashShopData SET WCoinP = WCoinP + ? WHERE AccountID = ?
Reply: WCoinP value for user %s has been updated!This command adds WCoinP to a user's account, allowing administrators to reward players with points.

Command 6: addgp
Description: Adds a value to GoblinPoint for a user.

Code Select Expand

Command: addgp
Query: UPDATE CashShopData SET GoblinPoint = GoblinPoint + ? WHERE AccountID = ?
Reply: GoblinPoint value for user %s has been updated!This command adds GoblinPoints to a user's account, which can be used in special in-game features or events.

Command 7: infocredits
Description: Displays information about a specified account.

Code Select Expand

Command: infocredits
Query: SELECT AccountID as value1, WCoinC as value2, WCoinP as value3, GoblinPoint as value4 FROM CashShopData WHERE AccountID = ?
Reply: Account %s has the following values: WCoinC: %d, WCoinP: %d, GoblinPoint: %d!This command displays an account's WCoinC, WCoinP, and GoblinPoint values, allowing for easy credit management.

Command 8: remwc
Description: Deducts a value from WCoinC for a user.

Code Select Expand

Command: remwc
Query: UPDATE CashShopData SET WCoinC = WCoinC - ? WHERE AccountID = ?
Reply: WCoinC value for user %s has been updated!This command allows administrators to deduct a specific amount of WCoinC from a user's account.

Command 9: remwp
Description: Deducts a value from WCoinP for a user.

Code Select Expand

Command: remwp
Query: UPDATE CashShopData SET WCoinP = WCoinP - ? WHERE AccountID = ?
Reply: WCoinP value for user %s has been updated!This command deducts WCoinP from a user's account, useful for penalty adjustments or corrections.

Command 10: remgp
Description: Deducts a value from GoblinPoint for a user.

Code Select Expand

Command: remgp
Query: UPDATE CashShopData SET GoblinPoint = GoblinPoint - ? WHERE AccountID = ?
Reply: GoblinPoint value for user %s has been updated!This command deducts GoblinPoints from a user's account when necessary.

Command 11: admincommands
Description: Displays the list of commands for admins.

Code Select Expand

Command: admincommands
Query: SELECT 1
Reply: /setreset - Set resets # /addwc - +WCoinC # /addwp - +WCoinP # /addgp - +GoblinPoint # /infocredits - Account info # /remwc - -WCoinC # /remwp - -WCoinP # /remgp - -GoblinPointThis command provides a list of special commands available to administrators for managing accounts.

Command 12: infoip
Description: Displays the IP of a specified user.

Code Select Expand

Command: infoip
Query: SELECT memb___id as value1, IP as value2 FROM MEMB_STAT WHERE memb___id = ?
Reply: %s has IP: %sThis command allows administrators to view the IP address associated with a specific user account.

Command 13: userinfo
Description: Displays details about a specified account.

Code Select Expand

Command: userinfo
Query: SELECT memb___id as value1, memb__pwd as value2, mail_addr as value3 FROM MEMB_INFO WHERE memb___id = ?
Reply: %s: Password: %s, Email: %sThis command shows essential information about an account, including the password and email address.

Command 14: findaccount
Description: Displays the account associated with a specified character.

Code Select Expand

Command: findaccount
Query: SELECT AccountID as value1 FROM Character WHERE Name = ?
Reply: The account associated with the specified character is: %sThis command helps administrators find the account associated with a specific character.

Command 15: listcharacters
Description: Displays all characters on a specified account.

Code Select Expand

Command: listcharacters
Query: SELECT Name as value1 FROM Character WHERE AccountID = ?
Reply: The characters on the specified account are: %sThis command lists all characters associated with a given account.

Command 16: banacc
Description: Blocks a specified account.

Code Select Expand

Command: banacc
Query: UPDATE MEMB_INFO SET bloc_code = 1 WHERE memb___id = ?
Reply: The account has been successfully blocked!This command prevents access to a specified account by blocking it.

Command 17: unbanacc
Description: Unblocks a specified account.

Code Select Expand

Command: unbanacc
Query: UPDATE MEMB_INFO SET bloc_code = 0 WHERE memb___id = ?
Reply: The account has been successfully unblocked!This command restores access to a previously blocked account.


These commands allow administrators to efficiently manage player accounts and the server. Should you have any questions or need further assistance, feel free to reach out to the administration team.

You require the following to view this post content:

• You must thank this post to see the content.

[rafamaster]

  goood man

[rafamaster]

biutyfull job man and the link  

[Dorin]

Discord Bot Commands List: Update 1.0

In this post, you will find detailed descriptions of all the bot commands from 0 to 17 for your Discord server. These commands help you manage player accounts, view online statuses, and much more.


Command 0: online
Description: Checks the number of players online on the server.

Code Select Expand

Command: online
Query: SELECT count(*) as value1 FROM MEMB_STAT where connectstat = 1
Reply: In this moment, there are # %d players online!This command allows you to see the current number of players online at any given time.

Command 1: commands
Description: Displays the list of available commands.

Code Select Expand

Command: commands
Query: SELECT 1
Reply: /online - See the number of players online # /info - Display information about a character # /accounts - Check the total number of accounts on the serverThis command lists all the commands that players or administrators can use, making it easier to understand the available options.

Command 2: info
Description: Displays information about a character.

Code Select Expand

Command: info
Query: SELECT name as value1, resetcount as value2, masterresetcount as value3, clevel as value4 FROM character WHERE name=?
Reply: Character %s: # %d resets # %d master resets # Level: %d!This command provides essential details about a specific character, including the number of resets, master resets, and the character's current level.

Command 3: totalaccounts
Description: Checks the total number of accounts on the server.

Code Select Expand

Command: totalaccounts
Query: SELECT count(*) as value1 FROM MEMB_INFO
Reply: There are a total of # %d registered accounts!This command shows the total number of registered accounts on the server, helping administrators track server growth.

Command 4: addwc
Description: Adds a value to WCoinC for a user.

Code Select Expand

Command: addwc
Query: UPDATE CashShopData SET WCoinC = WCoinC + ? WHERE AccountID = ?
Reply: WCoinC value for user %s has been updated!This command allows administrators to add a specified amount of WCoinC to a user's account.

Command 5: addwp
Description: Adds a value to WCoinP for a user.

Code Select Expand

Command: addwp
Query: UPDATE CashShopData SET WCoinP = WCoinP + ? WHERE AccountID = ?
Reply: WCoinP value for user %s has been updated!This command adds WCoinP to a user's account, allowing administrators to reward players with points.

Command 6: addgp
Description: Adds a value to GoblinPoint for a user.

Code Select Expand

Command: addgp
Query: UPDATE CashShopData SET GoblinPoint = GoblinPoint + ? WHERE AccountID = ?
Reply: GoblinPoint value for user %s has been updated!This command adds GoblinPoints to a user's account, which can be used in special in-game features or events.

Command 7: infocredits
Description: Displays information about a specified account.

Code Select Expand

Command: infocredits
Query: SELECT AccountID as value1, WCoinC as value2, WCoinP as value3, GoblinPoint as value4 FROM CashShopData WHERE AccountID = ?
Reply: Account %s has the following values: WCoinC: %d, WCoinP: %d, GoblinPoint: %d!This command displays an account's WCoinC, WCoinP, and GoblinPoint values, allowing for easy credit management.

Command 8: remwc
Description: Deducts a value from WCoinC for a user.

Code Select Expand

Command: remwc
Query: UPDATE CashShopData SET WCoinC = WCoinC - ? WHERE AccountID = ?
Reply: WCoinC value for user %s has been updated!This command allows administrators to deduct a specific amount of WCoinC from a user's account.

Command 9: remwp
Description: Deducts a value from WCoinP for a user.

Code Select Expand

Command: remwp
Query: UPDATE CashShopData SET WCoinP = WCoinP - ? WHERE AccountID = ?
Reply: WCoinP value for user %s has been updated!This command deducts WCoinP from a user's account, useful for penalty adjustments or corrections.

Command 10: remgp
Description: Deducts a value from GoblinPoint for a user.

Code Select Expand

Command: remgp
Query: UPDATE CashShopData SET GoblinPoint = GoblinPoint - ? WHERE AccountID = ?
Reply: GoblinPoint value for user %s has been updated!This command deducts GoblinPoints from a user's account when necessary.

Command 11: admincommands
Description: Displays the list of commands for admins.

Code Select Expand

Command: admincommands
Query: SELECT 1
Reply: /setreset - Set resets # /addwc - +WCoinC # /addwp - +WCoinP # /addgp - +GoblinPoint # /infocredits - Account info # /remwc - -WCoinC # /remwp - -WCoinP # /remgp - -GoblinPointThis command provides a list of special commands available to administrators for managing accounts.

Command 12: infoip
Description: Displays the IP of a specified user.

Code Select Expand

Command: infoip
Query: SELECT memb___id as value1, IP as value2 FROM MEMB_STAT WHERE memb___id = ?
Reply: %s has IP: %sThis command allows administrators to view the IP address associated with a specific user account.

Command 13: userinfo
Description: Displays details about a specified account.

Code Select Expand

Command: userinfo
Query: SELECT memb___id as value1, memb__pwd as value2, mail_addr as value3 FROM MEMB_INFO WHERE memb___id = ?
Reply: %s: Password: %s, Email: %sThis command shows essential information about an account, including the password and email address.

Command 14: findaccount
Description: Displays the account associated with a specified character.

Code Select Expand

Command: findaccount
Query: SELECT AccountID as value1 FROM Character WHERE Name = ?
Reply: The account associated with the specified character is: %sThis command helps administrators find the account associated with a specific character.

Command 15: listcharacters
Description: Displays all characters on a specified account.

Code Select Expand

Command: listcharacters
Query: SELECT Name as value1 FROM Character WHERE AccountID = ?
Reply: The characters on the specified account are: %sThis command lists all characters associated with a given account.

Command 16: banacc
Description: Blocks a specified account.

Code Select Expand

Command: banacc
Query: UPDATE MEMB_INFO SET bloc_code = 1 WHERE memb___id = ?
Reply: The account has been successfully blocked!This command prevents access to a specified account by blocking it.

Command 17: unbanacc
Description: Unblocks a specified account.

Code Select Expand

Command: unbanacc
Query: UPDATE MEMB_INFO SET bloc_code = 0 WHERE memb___id = ?
Reply: The account has been successfully unblocked!This command restores access to a previously blocked account.


These commands allow administrators to efficiently manage player accounts and the server. Should you have any questions or need further assistance, feel free to reach out to the administration team.

You require the following to view this post content:

• You must thank this post to see the content.