Click the image above to be directed to the help page where documentation for each script is located.
¶ RESOURCES AFFECTED
- BigDaddy-CharacterManager
- BigDaddy-Money
- BigDaddy-VehicleMenu
¶ Import MySQL table
Bellow is the sql data required for Character Manager
CREATE TABLE `bd_character` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`steam` varchar(255) DEFAULT NULL,
`discord` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`data` longtext,
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
To import this data you can use your preferred connection of choice. Many people use phpMyAdmin, so I will show you what you need to do bellow.
If you are running MySQL on your local machine make sure that you have both MySQL and Apache running:
After that, you can connect to phpMyAdmin by going to http://localhost/phpmyadmin/
Then you will click the database you want to edit:
Then on the top bar you will click "Query":
Then in the text box you will copy and paste the sql data included in your resource in the sql.sql file and click "Submit query":
Then if you get a message that looks like this then you are all done!:
If you get an error that looks like this then the table already exists:
¶ MySQL connection strings
The MySQL connection string is found in your server.cfg file in the root directory of your server and start with set mysql_connection_string.
Many host providers will give you a database to work with and it will include a connection string using the mysql:// method.
YOUR MYSQL CONNECTION STRING CANNOT START WITH
mysql://. IF IT DOES, THEN OUR SCRIPTS WILL THROW AN ERROR!
Below is how you can tranlate a string that starts with mysql:// to a format that our scripts can read. (This also works for other Database scripts like oxmysql, mysql-async, etc.
FINAL PRODUCT:
set mysql_connection_string "user=user12345678;password=genericpassword;server=yourhostprovider.com;port=3306;database=s123456_fivem"
If you have trouble converting your connection string try this handy tool made by a member of our community.
If you have set up a Database using the method listed in this wiki on a VPS this will likely be your connection string:
set mysql_connection_string "user=root;server=localhost;port=3306;database=fivemdefault"
NOTE: THE ABOVE DOES NOT INCLUDE A PASSWORD AS THERE IS NOT A PASSWORD SET BY DEFAULT. IF IT DOES INCLUDE A PASSWORD PLEASE ADD
password=YOURPASSWORD;INSIDE THE QUOTATION MARKS"
For full references on how to set up this type of connection string consult THIS WIKI. Ensure you have all the data in the connection string such as username, password, host IP, and database name. These can be easily converted from URL to string. Also check with your host provider and see if they include database connection information to make setting up the string easier.