[Swyft™]

Well I finally integrated an Admin system of MySQL into mys cript, the issue is it won't connect

On my script

pawn Код:

#define SQL_HOST "184.95.34.124" //change me
#define SQL_USER "5731_kcor" //change me
#define SQL_DB "5731_kcor" //change me
#define SQL_PASS "********" //change me

On my Volt-Host

DB Host (IP):
184.95.34.124
DB Host (Domain):
hydra.volt-host.com
DB Port:
3306
PHPMyAdmin:
hydra.volt-host.com/phpmyadmin

My MySQL Username/Database: 5731_kcor

I have tried adding the database port but I wonder if i do #define SQL_PORT "3306" or if i add it into the ip itself.

EDIT: I just tried it out, don't work

MYSQL DEBUG


[21:43:20] ---------------------------
[21:43:20] MySQL Debugging activated (07/09/12)
[21:43:20] ---------------------------
[21:43:20]
[21:43:20] >> mysql_ping( Connection handle: 0 )
[21:43:20] >> mysql_ping() - Invalid connection handle. (You set: 0, Highest connection handle ID is 0).

[donB]

Quote:

Originally Posted by RockingCamman Well I finally integrated an Admin system of MySQL into mys cript, the issue is it won't connect On my script pawn Код: #define SQL_HOST "184.95.34.124" //change me #define SQL_USER "5731_kcor" //change me #define SQL_DB "5731_kcor" //change me #define SQL_PASS "********" //change me On my Volt-Host DB Host (IP): 184.95.34.124 DB Host (Domain): hydra.volt-host.com DB Port: 3306 PHPMyAdmin: hydra.volt-host.com/phpmyadmin My MySQL Username/Database: 5731_kcor I have tried adding the database port but I wonder if i do #define SQL_PORT "3306" or if i add it into the ip itself. EDIT: I just tried it out, don't work

Are the plugins included? What's the error you get? Btw, try using "localhost":

pawn Код:

#define SQL_HOST "localhost" //change me

[Swyft™]

Nope it did not work sadly..

I have all the plugins

[next-studio|TheKiller]

Aren't you using a web server database, since the node is "hydra" ?
If yes, you need to give permission to the server ip, to access the database, on cpanel.

[Swyft™]

What?? I'm confused now haha

[Swyft™]

bump

[Swyft™]

Ooh the error i get in mys cript

C:\Users\EASYHOME\Desktop\FURIOUS DRIFTERS\gamemodes\FD.pwn(67) : warning 201: redefinition of constant/macro (symbol "mysql_fetch_row(%1)")
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


1 Warning.

but on my thing it says mysql doesnt connect cause i can /register then come back on the server and it wont work

[Swyft™]

I apologize for quadrupal posting.... but I am just desperate for an answer

[Swyft™]

Another Bump