Leaderboard

Good day everynyan~ I'm here again to showcase a newly finish system for a server that I am helping out with~ It's a simple Sell Character system, much like Shakto's but also not quite the exact same. Feature: Preview character information (Status/Equipment) Sold characters are categorized based on their Class Checks if character/account is online (in-game or in the server select/character select screen) Blocks usage of character that is being sold - will be prompted to either remove the character from Sell List or will be blocked from moving indefinitely Sellers can receive their earnings via the same NPC Logs buyer ID, seller ID, character ID and time of purchase Logs earnings and time of claim for earnings Lots of configuration options, such as to check for Bound items (account,party,guild) and more\ Credit to @Cydhfor making this script possible via:

View File MF_NORECALL (Custom Mapflag) MF_NORECALL a custom mapflag that restrict players being recalled via @recall / @recallall command when in special maps. In response to: Submitter Gidz Cross Submitted 01/05/24 Category Source Modifications Video https://i.imgur.com/7Hrggym.mp4 Content Author Gidz  

So this specific issue happens when there's a misconfiguration in the MySQL (PMA) set up. This could be a typo in the inter_athena.conf or your PMA user doesn't have explicit permissions. First check for the config in inter_athena.conf. Navigate to your rA/Conf folder: /home/raguser/Server/rAthena/conf /home/raguser/rAthena/conf And edit the lines that have your username, password & database details. If that fails to work then proceed to check the profile of MySQL. We can quickly edit this with the following lines of code. Firstly, open MySQL: If you error like this: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Instead do: sudo mysql -u root -p And enter your password. Once presented with the SQL window enter (and edit to reflect your info) in the following: CREATE DATABASE ragserver; CREATE USER 'raguser'@'localhost' IDENTIFIED BY 'StrongPassword'; CREATE USER 'raguser'@'%' IDENTIFIED BY 'StrongPassword'; GRANT ALL PRIVILEGES ON ragserver. * TO 'raguser'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON * . * TO 'raguser'@'%' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON * . * TO 'raguser'@'localhost' WITH GRANT OPTION; It's exactly as we did in the above steps. IF this fails too... Run this command sequence in MySQL: SELECT user,plugin,host FROM mysql.user WHERE user = 'root'; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'AStrongPasswordIsRecommended'; FLUSH PRIVILEGES; CREATE USER 'raguser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'AStrongPasswordIsRecommended'; GRANT ALL PRIVILEGES ON *.* TO 'raguser'@'localhost' WITH GRANT OPTION; exit This will flush and grant permissions to your ragnarok user profile for PMA.