Regarding MySQL

Post Reply
Toxic_Terrorists
New to forums
New to forums
Posts: 5
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Thu Dec 04, 2014 8:16 pm

Regarding MySQL

Post by Toxic_Terrorists »

I am very sorry if there is already a thread out there that explains how to do this but I did not seem to find one. Anyway, using the control panel offered by NFO. I installed "libmysql and mysqlOO" via the Autoinstallers tab in the given control panel. This is as far as I got, I have no idea on how to setup the MySQL. Yes I have webspace provided by NFO. I'm trying to set this up for a TTT server. If anyone could help me out, I'd greatly appreciate it. Thanks

Edit: I have the 8.1 version of libmysql and mysqlOO installed.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: Regarding MySQL

Post by soja »

The extensions you installed only allow LUA scripts to connect to and use MySQL servers. Do you have a script that needs a mysql server? If so there should be places in the script to enter server information like IP/user/pw/database etc.
Not a NFO employee
Toxic_Terrorists
New to forums
New to forums
Posts: 5
Joined: Thu Dec 04, 2014 8:16 pm

Re: Regarding MySQL

Post by Toxic_Terrorists »

I was looking to install this: http://facepunch.com/showthread.php?t=1416843
GitHub Version of Addon: https://github.com/Tommy228/TTTDamagelogs

It is an addon for TTT that handles damagelogs and provides a RDM manager. You can use MYSQL or the local sv.db, I was wanting to use MYSQL considering my sv.db file is becoming a large file and it takes sometime for the server to read it to give players their pointshop items. Anyway, I've downloaded and extracted the files. It has a folder named "website_code". I know how to upload that to the webspace and all.

I noticed in the "config.php" file for the website_code folder there is this:

Code: Select all

<?php
$db_config = array (
	'host' => 'localhost',
	'username' => '',
	'passwd' => '',
	'dbname' => '',
	'port' => ini_get("mysqli.default_port"),
	'socket' => ini_get("mysqli.default_socket"),
	'table' => 'damagelog_oldlogs',
	'table_weapons' => 'damagelog_weapons',
);
$timezone = 'Europe/Paris'; // See https://php.net/manual/en/timezones.php
$check_for_empty = FALSE; // Set it to TRUE if you want to remove empty years, months and days from the list. This will do much more SQL queries, so it is not recommended.
?>
I am aware of this file, it is the "config.php" in the website_code folder. However, my issue is. I am not sure if this is the place where I setup my login credentials or is this were I put in my login credentials that should have been already made. Thanks for your quick response
Toxic_Terrorists
New to forums
New to forums
Posts: 5
Joined: Thu Dec 04, 2014 8:16 pm

Re: Regarding MySQL

Post by Toxic_Terrorists »

I couldn't edit my earlier post, I have no idea why. The control panel never game me a username or IP or password for MySQL. It just installed 2 .dll's.
User avatar
hiimcody1
Former staff
Former staff
Posts: 1616
Joined: Wed Dec 28, 2011 4:59 pm

Re: Regarding MySQL

Post by hiimcody1 »

Toxic_Terrorists wrote:I couldn't edit my earlier post, I have no idea why. The control panel never game me a username or IP or password for MySQL. It just installed 2 .dll's.
You would need to visit your hosting panel and use the Databases tab to make a database. Once you do this you will see credentials listed on said tab.
Toxic_Terrorists
New to forums
New to forums
Posts: 5
Joined: Thu Dec 04, 2014 8:16 pm

Re: Regarding MySQL

Post by Toxic_Terrorists »

Never mind, i found it out. Thanks for your help anyway
Post Reply