GTAONLINE.PL :: [INNE] Mysql nie działa na domowym serwerze

Zaloguj się by uzyskać pełen dostęp. Nie masz jeszcze konta? Założ je już teraz w kilka sekund.

Witam, ostatnio wgrywa?em mapke POP na domowym serwerze wszystko fajnie dzia?a opr?cz mysql i pisze mi ca?y czas, ?e mam si? zalogowa?.
Zrobi?em baze danych przez program wampserwer i te dane, kt?re mia?em w phpmyadmin wpisa?em do mapki w ustawieniach scriptfiles te? s? wpisane te dane ale i tak nie dzia?a

Poka?esz logi?
Masz dobre pluginy mysql?

"karolek110199" napisał/a:

Poka?esz logi?
Masz dobre pluginy mysql?

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3x, (C)2005-2013 SA-MP Team

[00:46] filterscripts = "" (string)
[00:46]
[00:46] Server Plugins
[00:46] --------------
[00:46] Loading plugin: streamer
[00:46]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[00:46] Loaded.
[00:46] Loading plugin: mysql
[00:46]

> MySQL plugin R5 successfully loaded.

[00:46] Loaded.
[00:46] Loading plugin: audio
[00:46]

*** Audio Plugin v0.5 by Incognito loaded ***

[00:46] Loaded.
[00:46] Loading plugin: sscanf
[00:46]

[00:46] ===============================

[00:46] sscanf plugin loaded.

[00:46] (c) 2009 Alex "Y_Less" Cole

[00:46] 0.3d-R2 500 Players "dnee"

[00:46] ===============================

[00:46] Loaded.
[00:46] Loading plugin: regex
[00:46]

[00:46] ______________________________________

[00:46] Regular Expression Plugin v0.2.1 loaded
[00:46] ______________________________________

[00:46] By: Fro (c) Copyright <TBG> 2009-2011
[00:46] ______________________________________

[00:46] Loaded.
[00:46] Loaded 5 plugins.

[00:46]
[00:46] Filterscripts
[00:46] ---------------
[00:46] Loaded 0 filterscripts.

[00:46] -----------------------------------
[00:46] Trwa Wczytywanie Pojazdow, Pickup?w...
[00:46] Wczytano 724 Pojazd?w
[00:46] Wczytano 32 Pickup?w
[00:46] -----------------------------------
[00:46] 747
[00:46] -----------------------------------
[00:46] Trwa wczytywanie domow...
[00:46] 0 >
[00:46] 1 >
[00:46] 2 >
[00:46] 3 >
[00:46] 4 >
[00:46] 5 >
[00:46] 6 >
[00:46] 7 >
[00:46] 8 >
[00:46] 9 >
[00:46] 10 >
[00:46] 11 >
[00:46] 12 >
[00:46] 13 >
[00:46] Wczytano 14 dom?w
[00:46] -----------------------------------
[00:46] *====================================
[00:46] * --------------------------------- *
[00:46] * ___|Polski P4S Server|___ *
[00:46] *___________________________________*
[00:46] * Mapka P4S Server |P4S| *
[00:46] * Zaladowana Poprawnie

! *
[00:46] *___________________________________*
[00:46] * --------------------------------- *
[00:46] ====================================
[00:46] Number of vehicle models: 117

Powinno mi pisa? ?e po??czono z baz? mysql a tu ****

mysql_debug, ile razy mam Ci powtarza??

"IgrexolonO" napisał/a:

mysql_debug, ile razy mam Ci powtarza??

mo?esz ja?niej bo nie znam si? na tym ***** mysql xD

Kod:

mysql_debug(1);

Takie co? w OnGameModeInit i tam z pliczku daj nam logi. : )) )

w ongamemodeinit mam tak:

tmp = dini_Get(PLIK_USTAWIENIA,"MySQL");
mysqluse = strval(tmp);

WoDBrama = CreateObject(980, 2832.29, -1569.57, 12.70, 0.00, 0.00, 85.71);

if(mysqluse == 1){
mysqluse = 1;
}

if(mysqluse == 1){

new user[256];
new database[256];
new password[256];

tmp = "localhost";
user = "Domix";
database = "sa-mp";
password = "th******";
print("-----------------------------------");
print("Trwa laczenie z baza MySQL...");
printf("Host: %s",tmp);
printf("User: %s",user);
printf("Database: %s",database);
// printf("Password: %s",password);
MySQLcon = mysql_connect(tmp,user,database,password);
stan = mysql_ping(MySQLcon);
if(stan == 1){
printf("Poloczono z baza MySQL (Handleid: %d)",MySQLcon);
}else{
print("Nie udalo sie poloczyc z baza MySQL");
}
}
print("-----------------------------------");

Bo?e jedyny. Nie pytam Ci? co masz w OnGameModeInit, m?wi? Ci ?eby? doda? funkcj?, kt?r? Ci poda?em. Wtedy mysql w Twoim folderze z srampem stworzy plik, w kt?rym wypisze ca?e logi z dzia?ania mysqla' rozumiesz?

"IgrexolonO" napisał/a:

no to zrobi?em tak i w pliku mam tak:

[15:33]

[15:33] ---------------------------

[15:33] MySQL Debugging activated (08/20/13)

[15:33] ---------------------------

[15:33]

[15:35]

[15:35] ---------------------------

[15:35] MySQL Debugging activated (08/20/13)

[15:35] ---------------------------

[15:35]

[15:56]

[15:56] ---------------------------

[15:56] MySQL Debugging activated (08/20/13)

[15:56] ---------------------------

[15:56]

[15:58] >> mysql_query( Connection handle: 1 )

[15:58] >> mysql_query() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[15:58] >> mysql_store_result( Connection handle: 1 )

[15:58] >> mysql_store_result() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[15:58] >> mysql_num_rows( Connection handle: 1 )

[15:58] >> mysql_num_rows() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[15:58] >> mysql_free_result( Connection handle: 1 )

[15:58] >> mysql_free_result() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

Cytat:

[15] ---------------------------

[15] MySQL Debugging activated (08/20/13)

[15] ---------------------------

[15]

[15] >> mysql_query( Connection handle: 1 )

[15] >> mysql_query() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[15] >> mysql_store_result( Connection handle: 1 )

[15] >> mysql_store_result() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[15] >> mysql_num_rows( Connection handle: 1 )

[15] >> mysql_num_rows() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[15] >> mysql_free_result( Connection handle: 1 )

[15] >> mysql_free_result() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

Z tego co mo?na wywnioskowa? z tego, to gdzie? masz ustawione po??czenie 1, a najwy?sze mo?liwe to 0 X.X

A mo?e po prostu baza nie pozwala na dost?p z zewn?trz?