MySQL - Developers - Facepunch Forum

so for this gamemode i have a file called "table.sql" And i have "libmySQL.dll" But i dont know how to add a table :?

Do you want to add the table in or out of the game? Do you have a MySQL server? Do you have a module that binds the functions (gm_tmysql for example)? What gamemode is this for?

[QUOTE=James xX;47413378]Do you want to add the table in or out of the game? Do you have a MySQL server? Do you have a module that binds the functions (gm_tmysql for example)? What gamemode is this for?[/QUOTE] its for applejackrp, i dont know what you mean by in or out of the game and i dont have a mysql server im just testing on my local network also i dont have a module for it im new whith mysql and database :)

Oki. You need to get a MySQL server (try xampp), set it up, and import the SQL file you mentioned. Then, input all the configurations into the gamemode (ip, port, username, password, database). Then, get the appropriate binding. I don't know which one ApplejackRP uses, so you'll have to look that up. When you find out which one it is, download it, and follow the installation instructions.

[QUOTE=James xX;47413827]Oki. You need to get a MySQL server (try xampp), set it up, and import the SQL file you mentioned. Then, input all the configurations into the gamemode (ip, port, username, password, database). Then, get the appropriate binding. I don't know which one ApplejackRP uses, so you'll have to look that up. When you find out which one it is, download it, and follow the installation instructions.[/QUOTE] So i download xampp, and a client has opened whith FIleZilla and MySQL Ect what do i do from here?

From what I remember, you need to have your httpd server running, and go to [url]http://localhost/PHPMyAdmin/[/url] and set up your MySQL database. Once you've inported the SQL file, plug in the configurations to the gamemode, and it should work.

[QUOTE=James xX;47417530]From what I remember, you need to have your httpd server running, and go to [url]http://localhost/PHPMyAdmin/[/url] and set up your MySQL database. Once you've inported the SQL file, plug in the configurations to the gamemode, and it should work.[/QUOTE] link does not work :/

[QUOTE=Borris_Squad;47417544]link does not work :/[/QUOTE] Is your httpd server running?

[QUOTE=James xX;47417549]Is your httpd server running?[/QUOTE] dont know what that is :/

[QUOTE=Borris_Squad;47417562]dont know what that is :/[/QUOTE] Then you should have said that before saying the link that requires it doesn't work. On the Xampp panel, there should be lots of buttons that say "Start X" and "Stop X", where one of the X's is for the httpd server. It might be named apache, or something else.

[QUOTE=James xX;47417572]Then you should have said that before saying the link that requires it doesn't work. On the Xampp panel, there should be lots of buttons that say "Start X" and "Stop X", where one of the X's is for the httpd server. It might be named apache, or something else.[/QUOTE] Ok so i start Apache [editline]29th March 2015[/editline] "Object not found! The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error. If you think this is a server error, please contact the webmaster. Error 404 localhost Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 "

It might be capitalization. Try [url]http://localhost/phpmyadmin/[/url]

Error MySQL said: Documentation #2002 - No connection could be made because the target machine actively refused it. The server is not responding (or the local server's socket is not correctly configured). Connection for controluser as defined in your configuration failed.

Is your MySQL running?

The apache thing is [editline]29th March 2015[/editline] Oh now it is what next?

[QUOTE=Borris_Squad;47417675]The apache thing is[/QUOTE] Apache doesn't have any of the same letters as MySQL, so I don't know how you even got close to assuming they were the same. Further more, in a thread where the title is "MySQL", it should have been obvious that you should have clicked the "Start MySQL" button at some point. Go start it, go to phpmyadmin, click database, create a new one. click on it (list below), click import, select your file, import. In your AppleJack config, host = "127.0.0.1", port = 3306, database = the name you picked, user = "root", password = "", but you might want to add a password (in both the config and phpmyadmin). Before you say something doesn't work, ask about it instead. This could have gone a lot faster if you did.

So new what??????

[QUOTE=Borris_Squad;47417731]So new what??????[/QUOTE] A new database. Enter the name, and click create. [editline]29th March 2015[/editline] Also, you mustn't have seen my PM, where I suggested we do this over steam. It will go a lot quicker. What's your add?

No offence, but if you cannot setup a database you shouldn't be trying to run Applejack. There's going to be a lot more issues that need fixing and it will be way harder in comparison to setting up a database.

[QUOTE=Chessnut;47417743]No offence, but if you cannot setup a database you shouldn't be trying to run Applejack. There's going to be a lot more issues that need fixing and it will be way harder in comparison to setting up a database.[/QUOTE] He'll probably realize that soon enough, but at least he will know how to set up a database for future endeavours. [editline]29th March 2015[/editline] Problem solved. Closing quote: [QUOTE][B]James:[/B] As someone in the thread pointed out, there are things far harder to do for applejack than setting up a database, so don't be disappointed [B]Road To Silver Elite:[/B] Ok and dont worrie about applejack i can code lua i was just new to db [B]James:[/B] Don't take this the wrong way, but if you could code lua, setting up a database would seem like run of the mill [B]Road To Silver Elite:[/B] Not gonna lie but it did not XD [B]Road To Silver Elite:[/B] Also darkrp was not the best start for me an glua :/ so i started learning lua by a book a week or 2 ago and now its ezy [/QUOTE]