How to set-up mysql support in essentials

[Nyndyll]

Long story short. How do i set up mysql to work in essentials?
and;
Shouldnt there be a tutorial on this somewhere?

 

[pokemonmasteraaron]

Apparently there isn't a tutorial, based on the lack of responses.
:(
Not many people want to help with stuff such as mysql.
You could always try google, but I haven't found nothing doing that.

 

[Ho-oh 112]

Apparently there isn't a tutorial, based on the lack of responses.
:(
Not many people want to help with stuff such as mysql.
You could always try google, but I haven't found nothing doing that.

look at the mySQL script (read the green lines at the top) it shows you how to setup mySQL

 

[Nyndyll]

Where?

I dont know where read through it a few times still cant figure it out.
help me find it (green text below...):
-------------------------------------------------------------------------------
# This script is free to use. Do not post anywhere without my permission.
# Credits needed.
#-------------------------------------------------------------------------------
# Warning: if your game is cracked and decrypted, your mysql login will be
# available!
# Do not use with a database containing personal information.
# Your mysql host should accept external connections.
# Check with it for remote SSH access to your database.
#-------------------------------------------------------------------------------
# This script allows interractions with a mysql database directly in the game.
# It requires a file "libmysql.dll" in the game folder.
#-------------------------------------------------------------------------------
# Attention: en cas de décryptage de votre jeu, vos identifiants mysql seront
# accessibles!
# Ne pas utiliser de base de donnée contenant des informations personnelles.
# Votre hébergeur Mysql doit accepter les connexions mysql externes.
# Vérifiez auprès de lui que vous avec un accès distant SSH à votre base de
# données.
#-------------------------------------------------------------------------------
# Ce script permet d'interragir avec une base de données mysql directement via
# le jeu.
# Il nécessite un fichier "libmysql.dll" à placer dans le dossier du jeu.
#-------------------------------------------------------------------------------
# md5() support
# Mysql functions:
# - Net::Mysql.new([host,user,pass,base,port]) : return : mysql connection handle
# - @mysql.close : return : bool
# - @mysql.list_tables([filter]) : return : ["table1", "table2"]
# - @mysql.select_db(base_name) : return : true if the db exists or false
# - @mysql.query("query",ret=false) : return : if ret = true : rows else result handle
# - @mysql.get_fields([handle result]) : return : ["field1", "field2"]
# - @mysql.get_rows([handle result]) : return : [["l1 row1", "l1 row2"], ["l2 row1", "l2 row2"]]
# - @mysql.fetch_assoc : return : {"field" => ["row1", "row2"] }
# - @mysql.num_rows([handle result]) : return : integer
# Html functions:
# - "string".to_ruby : return : true, false, nil, Integer, Float, self, etc.
# - "<berka>".htmlspecialchars : return : "&lr;berka>"
# - "<berka>".urlencode : return : "%3Cberka%3E"
# - "%3Cberka%3E".urldecode : return : "<berka>"
#-------------------------------------------------------------------------------
# SQL queries samples
# "SELECT * FROM table"
# "INSERT INTO table (fields) VALUES (values)"
# "INSERT INTO table SET field = value WHERE field = value"
# "UPDATE table SET field = value WHERE field = value"
#-------------------------------------------------------------------------------
# Sample :
# @mysql = Net::Mysql.new
# @mysql.query("SELECT * FROM `members`)
# res = @mysql.fetch_assoc
# => {:id=>["1","2"], :nom=>["berka","rgss"], :age=>["19",""]}
#======================================================================

 

[Ho-oh 112]

I dont know where read through it a few times still cant figure it out.
help me find it (green text below...):
#-------------------------------------------------------------------------------
# Sample :
# @mysql = Net::Mysql.new
# @mysql.query("SELECT * FROM `members`)
# res = @mysql.fetch_assoc
# => {:id=>["1","2"], :nom=>["berka","rgss"], :age=>["19",""]}
#======================================================================

even more defined: Net::Mysql.new

 

[venom12]

But you need to have mysql installed on pc right?

 

[Ho-oh 112]

But you need to have mysql installed on pc right?

pretty sure you do need it installed...

EDIT:
You don't need it installed to use it, infact I'm 99.99% sure Pokecommunity uses mySQL, so there's your answer, no. No need to install mySQL UNLESS YOU ARE DEVELOPING USING IT... but then again there are also some sites allowing access to databases, so again no.

 

[IceGod64]

But you need to have mysql installed on pc right?

MySQL is a type of web database. The only need you would have for a program is to help you manage it. You wouldn't have to install it to use the MySQL support in essentials, just to create the database Essentials' MySQL script will read from.

 

[Elyssia]

There is a fast way of pre-installing MySQL :)
As example XAMPP is an useful program for it, but not always up-to-date with the latest Apache(HTTP Server), Filezilla server(FTP Server), Tomcat(Java applets runner) and MySQL(SQL Database).
On default these apps are pre-installed as local only, but you can open up the ports if you would like to test it trough the global internet access.
However... I do agree with this quote:

# Warning: if your game is cracked and decrypted, your mysql login will be
# available!
# Do not use with a database containing personal information.
# Your mysql host should accept external connections.
# Check with it for remote SSH access to your database.

Maybe you should give it a try via local only with XAMPP. ;)

*Note: XAMPP has multiple Operating Systems supported!!!

Edit: Whoops! didn't noticed the last post was from 1 week ago on the Tuesday! D: