Jump to content

Micheck

Members
  • Content Count

    13
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

Community Reputation

8 Neutral

About Micheck

  • Rank
    Poring
  • Birthday 10/08/2002

Profile Information

  • Gender
    Male
  • Location
    Malaysia

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Version 1.0

    174 downloads

    Hello guys, I would like to share one of my simple and small program that i used to backup SQL Database. I am new in making programs as i am learning it in school together with php, so i hope you guys can pardon my noob code. It been created to help my dad and brother to backup their mysql database remotely. Now i would like you guys to try it and give suggestions on the programs. The field in the programs need to be write manually as that is what my dad and brother requirements. This is the post about the previous version (Discussion Post) # The program have been updated to v1.1 using .net 4.5 slightly change the way backup is save (using only .sql) added restore function with create database option (create database function will only create to a non-exist database) change how the connection been to the MySql server is made The guides will be updated later. Please try it and give suggestions for me to improve. You can contact me at [email protected] If you guys like my work you can buy me a coffee so i can keep my money for my school p/s : If you would like to take a look or use the source code, it been upload to github. Please comment about the source so i can improve the way i write the code. Thank you. SimpleMySql Github

    Free

  2. Hi @Lighta , thank you for the reply and the suggestions.. I will upload the program to your proposed section, am still updating the program to add couple of options. Anyways, in my journey of learning c# i have successfully integrated couple of options such as ssh console to remote server, controlling the emulator, adding/editing accounts and much more. Like is said in the post, yes we can used putty to ssh to the server or other ssh console, but i think by having a simple and lightweight console integrated will be fun. You can find my post here (Control Panel) , if you haven't look at it. I had include this program but with less function to make the program smaller. Yes i also planning to make it capable of doing scheduled task. I will upload the code to github once it is done. Thank you again..
  3. Hi guys, I want to share with you guys what i did. My brother and father ask me to help them with remotely backup mysql database because i am learning some programming language at school now, so i did SimpleMysql Backup . Since then i had try to include more future into it. After some readings, i think i will include ssh console. Something like 'putty' but not as complex as it is. So i made a ssh console/terminal from c# (you can look at the video below). After i successfully made a connection via ssh to terminal, i try to include more function into it, and i have included controlling the emulator (start, restart and stop) recompile backup the emulator server information (such as uptime and online player) sql backup (using my previous sql backup but with less option as to make the application smaller) emulator log file viewer (from sql log for now, as i do not really know where rathena keep their log file) create any account (any ID) edit account and also char (for char edit is still on progress) server status (online / offline) Status window that i included is just for viewing via ssh when the command runs. It used my ssh console code. There also a short video i made to proof to you guys that it works. The purpose i make a post about this is to see how many people is interested in this project so that i can gather input and implemented in the application. I will be releasing the application for free without any charges if there are people interested. The reasons i give it for free is because i like to code and i do not know where i can contribute. rAthena emulator is using c++ and i am still in school learning about programming. So i cannot contribute there, but maybe here . I really like you guys to reply and comment here if you guys are interested in the application. I do not know if there are any rAthena control panel out there. That is why i try to make one. Below is the application details. written in c# using ssh.net and mysql library. after school project written by a noob coder.......... SSH Console Control Panel
  4. Thank you @Lighta for your feedback i appreciated it. It have been update to v1.1 I also include the source code in github if you be kind to take a look into it and comment on my source code. I am new to writing code but i will gladly to hear if there is any comment. Thank You. future plans : # add ssh connection to monitor running process such as rathena emulator # start, restart and kill process # backup and restore rathena emulator and other stuff via the program # maybe a simple ftp client will be included.
  5. Hello @Lighta thank you for asking this.. I will try to list out how the programs work. ( please pardon my grammar as english is not my first mother-tounge) This program is written in C# and use Mysqlbackup.net dll. I know the most common way to backup a MySQL Database is by using MySqlDump.exe and MySQL Workbench. MysqlDump, as i know cannot be use with web application. The hosting providers that host the database for my dad and brother forbid the access to mysqldump. He can only connect through MySQL Workbench. They were using the workbench to backup and download their database. So when at school i learn about C# and MySQL, and they ask me to help them by just making a small program that will backup the database. So i made this programs get all the parameter preset and they just click the backup button. It is intended to be a remote backup that they can use without accessing the server cpanel or such. I am working on upgrading the programs like using lower .net framework, more preset statements and a restore function (my dad asked it). This is the link on code-project for the dll that i use for the program (MysqlBackup-NET). You can take a look if you want to get more information on the dll. This is two set of database that i just made from this. One from my localhost laravel new installation, and the other one is from my remote rAthena database (ragnarok). I have delete the ip on the remote host. This 2 set just want to show you how the save sql is. Laravel SQL Database : jju-2017-12-06--16-47-59.sql rAthena Remote Database :jju-remote-2017-12-06--16-49-44.sql This program use dll that been written on top of MySQLdata dll in C#, only that mySQLdata dll used mysqldump to retrieve the database and with this program i just intended to use it for remote backup. I am sharing this thinking it will help some people that may need to backup the database remotely from their local pc. Below is the v1.1 that i am doing to upgrade for my dad and brother. I will share it here if any of you guys are interested. again i am sorry if this programs is useless or not suitable here.
  6. Hello guys, I would like to share one of my simple and small program that i used to backup SQL Database. I am new in making programs as i am learning it in school together with php, so i hope you guys can pardon my noob code. It been created to help my dad and brother to backup their mysql database remotely. Now i would like you guys to try it and give suggestions on the programs. The field in the programs need to be write manually as that is what my dad and brother requirements. # The program have been updated to v1.1 Download : MySql Tools.rar using .net 4.5 slightly change the way backup is save (using only .sql) added restore function with create database option (create database function will only create to a non-exist database) change how the connection been to the MySql server is made The guides will be updated later. Please try it and give suggestions for me to improve. You can contact me at [email protected] If you guys like my work you can buy me a coffee so i can keep my money for my school p/s : If you would like to take a look or use the source code, it been upload to github. Please comment about the source so i can improve the way i write the code. Thank you. SimpleMySql Github feature plans : ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ V1.0
  7. I have update the code. It is not using prepared statements now as i need to learn more about that Below is the change log for the new versions : v1.0.1 using 'prepared-statement login should work now MD5 supported update regular expressions so it match to the correct value fix typo on GID regex
  8. Thank you for the feedback @Jey i appreciated it , i will improve the nesting. I am learning prepared statement now in school, so that is why i am making this script to test what have i learned. @Jey , is using prepared statements for this kind of script is good or without it will works better? Anyways, i will try to rectify the login. Thank you again jey
  9. @Jey oopss... yes i made a mistake there, i will rectify it now. That is due i disable the hashed password as i do not know rathena login system can use it or not?
  10. @Cyro i have put at the correct sections, sorry as this is my first time posting here.
  11. Simple Registration HTML+PHP (v1.0) The HTML is very basic and is intended to use for server admin in production environment. It just have a SignUp and Login function. Fill up the server info in dbh.inc.php and you are good to go. The PhP script had been optimized for live webserver, below is the information : SQL injection protected (please test and reply to me) using 'prepared-statement using bind_param login function using 'SESION' Please test the script and any comment is welcome. I will update the script from time to time. Thank you. Sorry for my english
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.