yepp

File Name: [TOOL] Item DB Automation File Submitter: yepp File Submitted: 07 Jun 2016 File Category: Server Managers/Editors Content Author: yepp Requirements: - PHP version 5.4 and up is required to run this script. - JSON File of your item (examples at the end) Instructions: - Open up a terminal - Type in "php item_script.php" (without the quotes) Creating JSON File: The format should be like this (The ordering: https://rathena.org/wiki/Custom_Items#Structure_.28Database.29) [26007,"Pink_Fluffy_Valkyrie_Helm","Pink Fluffy Valkyrie Helm",4,1,null,0,null,0,null,1,"0xFFFFFFFF",3,2,256,null,0,1,907,null,null,null] NOTES: - If the value is NULL, type it in small letters. - Use quotes on string values. - Do not add commas on each line. Questions? Ask here: https://rathena.org/board/topic/106186-tool-add-items-to-database-easily/ Click here to download this file

No problem Just tell me what can make this better if you have something in your mind.

why i cant download the file? any other link? What error did you got? It must be something with rathena's server. If you still can't download from here I will just upload a mirror from somewhere. Try downloading from here again first.

MariaDB is a fork of MySql so it is 99% compatible and it is much better. Everything else is the same. mysql -u(username) -p(password) (databasename) or mysql -p Like that. No difference. I also have CentOS in my server and I love its stability. --EDIT-- Oh to answer your question, I see that you are using CentOS 7. Try this: sudo systemctl start mariadb To check if it's installed: rpm -qa | grep mariadb In case mariadb-server is not installed: sudo yum install mariadb-server

New version uploaded! It can now generate client-side files (accname.lub and accessoryid.lub are not included tho). Enjoy!

Nobody can change in to that job tho. I am just ignoring it... it's just that seeing some warning when starting athena is a bit bothersome :v

Found out now? There's something that's loading it... I don't want them. How do I remove them?

Share your experience or problems with my tool

You could parse the values where NULL could be expected through strtolower(); (if ($string === "NULL"){$string = strtolower($string);} ) and use string check functions (or regex if you like) to ensure strings are encased in quotes. I may try that one time. Cool. Thanks for the suggestion! Currently not in the mood for some mod xD

ADD ITEMS EASILY Requirements: - PHP version 5.4 and up is required to run this script. - JSON File of your item (examples at the end) Instructions: - Open up a terminal - Type in "php item_script.php" (without the quotes) Creating JSON File: The format should be like this (The ordering: https://rathena.org/....28Database.29) [26007,"Pink_Fluffy_Valkyrie_Helm","Pink Fluffy Valkyrie Helm",4,1,null,0,null,0,null,1,"0xFFFFFFFF",3,2,256,null,0,1,907,null,null,null] NOTES: - If the value is NULL, type it in small letters - Use quotes on string values. - Do not add comma on each line. Download: https://rathena.org/board/files/file/3453-tool-item-db-automation/ Any questions regarding my script are welcome. I'll try to add more features soon including editing and deleting if I'll have the time. Hope you like my tool! As this make it easier for me. Changelog Version 1 - First release. Version 1.1 - Added prompt in case you changed your mind. - Improved checking of empty line in JSON file. Version 2 - Added function to generate client-side resource files from the same JSON file (idnum2itemdisplaynametable, idnum2itemresnametable, etc.) - It will either create a new file or append your current file if present. Note: accname.lub and accessoryid.lub is not yet added.

Mark my answer as Solved if I helped you and to let other people know this thread is solved.

Currently hunting down the bug, I just can't understand the structure of the FluxCP. I am starting on the main index.php and looking at the required files. Anyway, here's the "I think a bug" I found: I can't install it. Clicking "Install or Update Everything" will return you to the login page asking the Installer password. Typing in an Alternative Username/Pass and clicking Update {DBnameHere} will return you to the login page with an "Incorrect Password error". Well, say that my "config/servers.php" DB user and pass combination is wrong... what's the sense of the "Alternative Username/Pass" inputs? Hmmm... -- EDIT -- Sweet! There's a debugmode on the config/applications.php. Tried enabling it on the installer.php but it doesn't work... never thought there would be another one on the config/applications.php. Having an error regarding permissions. It can't load the session library. Looking for fix now. -- EDIT -- I didn't see right away that there was debugmode on the config/applications.php. Sorry :\ third-party issues here. Not related to the FluxCP.

May I know what for? I may be able to help. Never heard or saw that kind of setup before.

I didn't see the error on my server, but I think I experienced that one. I can only remember the error the client returned. It says "Rejected from server (13)". And then I saw this thread: https://rathena.org/board/topic/101194-rejected-from-server-3/ and this https://rathena.org/board/topic/101092-packet-obfuscation-support/?p=281321 Hope that helps.