GTA:BLKN
PRIJAVA REGISTRACIJA

Pretraga

Pritisnite Enter za pretragu ili Escape za zatvaranje

Zaključano

[GM] Basic MySQL GM

Započeo Joey_
• pre 14 godina
13,036
pregleda
39
postova
Ova tema je zaključana. Samo moderatori i administratori mogu odgovarati.
GGC
LuKsA
Godfather
pre 14 godina
#31
GeForce Vega wrote on January 12, 2012, 12:43 am:
Ovako, vidim pisete predobro itd, a ja se ne mogu spawnat, spawnam se al me kicka odmah sa servera. Provjerio sam kod, nema nikakve greške u njemu al opet me kickuje


Pisu zbog postova inace, barem vecina njih 🙂..

Ugl. provjeri pod: OnPlayerLogin, OnPlayerConnect, OnPlayerSpawn dal nesto 'ne blocka'.
ado
Javier
Made Man
pre 14 godina
#32
LuKsA wrote on January 12, 2012, 12:43 am:
Ovako, vidim pisete predobro itd, a ja se ne mogu spawnat, spawnam se al me kicka odmah sa servera. Provjerio sam kod, nema nikakve greške u njemu al opet me kickuje


Pisu zbog postova inace, barem vecina njih 🙂..

Ugl. provjeri pod: OnPlayerLogin, OnPlayerConnect, OnPlayerSpawn dal nesto 'ne blocka'.

Pogledao sam sve to odmah nakon sto sam vidjeo da me kicka...Ima kod loadanja iz MYSQL baze podatke one, ima Kick(playerid);

if(response)
{
tamo kod oko baze insert itd
}
else kick(playerid);
Mozda to?
Stefan Misurovic
[BU] Misur
Enforcer
pre 14 godina
#33
ρα¢σ_ѕιχχ wrote on November 27, 2011, 7:53 pm:
lijepo posluzice
Mohamed_Torres
Mohamed_Torres
Street Runner
pre 13 godina
#34
meni neradi linkk
ThE P.A.W.n !
ThE P.A.W.n !
Hustler
pre 13 godina
#35
Izvinjavam se sto refresham staru temu,ali zanima me dali mog da koristim bazu sa Web Hosta ??
Imam unlimited baza i unlimited protoka.
Dr.Nino
propalica2131231
Underboss
pre 13 godina
#36
AleX_ wrote on August 22, 2012, 5:59 pm:
Moras imati i gamehost ako hoces preko webhosta

seres ko grlica

nemorate imat

Joey_ wrote on November 27, 2011, 7:23 pm:
! Napomena !
Ovaj GM je namjenjen skripteri koji poznaju osnove MySQL-a. Ako ne znate osnove, a željeli biste ih naučiti, preporučam vam ovaj tutorial: Making a MySQL system na engleskom ili Pokretanje moda sa MYSQL-om na hrvatskom


procitaj tutove i vidit ces da nemora
J0PS0NEE
J0PS0NEE
Enforcer
pre 13 godina
#37
Svaka ÄŒast!
99/10
Marko Koprivanac
Kopra
Underboss
pre 12 godina
#38
Imam problem,znam da je tema starija al nmvz 😄

Ubacio sam bazu na localhost preko xamppa,sve lepo radi,i sad pokrenem lepo samp_server.exe,udjem u igru,upisem lozinku za registraciju i odjednom mi samo ovo izbaci:



Direct Link: http://zaslike.com/files/04286h7ohh5w5icc1023.png

I samo treperi to i ubaguje sve.

Debug.txt:
[15:15:40] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp_server" | Username: "root" ...

[15:15:40] CMySQLHandler::Connect() - Connection was successful.

[15:15:40] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[15:27:16] >> mysql_format( Connection handle: 1 )

[15:27:16] CMySQLHandler::EscapeString(KOPRIVA); - Escaped 7 characters to KOPRIVA.

[15:27:16] >> mysql_query_callback( Connection handle: 1 )

[15:27:16] CMySQLHandler::Query("CheckUser") - Custom callback query with index 0 started (ExtraID: -1)

[15:27:16] CMySQLHandler::ProcessQueryThread(SELECT * FROM `users` WHERE `Username` = 'KOPRIVA' LIMIT 1) - Data is getting passed to CheckUser() - (Threadsafe: Yes)

[15:27:16] CheckUser(0,"SELECT * FROM `users` WHERE `Username` = 'KOPRIVA' LIMIT 1") - Called.

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

[15:27:16] CMySQLHandler::StoreResult() - Result was stored.

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

[15:27:16] CMySQLHandler::NumRows() - Returned 0 row(s)

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

[15:27:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:27:23] >> mysql_format( Connection handle: 1 )

[15:27:23] CMySQLHandler::EscapeString(KOPRIVA); - Escaped 7 characters to KOPRIVA.

[15:27:23] CMySQLHandler::EscapeString(marko); - Escaped 5 characters to marko.

[15:27:23] >> mysql_query_callback( Connection handle: 1 )

[15:27:23] CMySQLHandler::Query("RegisterUser") - Custom callback query with index 0 started (ExtraID: -1)

[15:27:24] CMySQLHandler::ProcessQueryThread(INSERT INTO `users` (`Username`, `Password`, `Cash`) VALUES ('KOPRIVA', md5('marko'), 0)) - Data is getting passed to RegisterUser() - (Threadsafe: Yes)

[15:27:24] RegisterUser(0,"INSERT INTO `users` (`Username`, `Password`, `Cash`) VALUES ('KOPRIVA', md5('marko'), 0)") - Called.

[15:27:29] >> mysql_format( Connection handle: 1 )

[15:27:29] CMySQLHandler::EscapeString(KOPRIVA); - Escaped 7 characters to KOPRIVA.

[15:27:29] >> mysql_query_callback( Connection handle: 1 )

[15:27:29] CMySQLHandler::Query("SaveUser") - Custom callback query with index 0 started (ExtraID: -1)

[15:27:29] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[15:28:02] >> mysql_format( Connection handle: 1 )

[15:28:02] CMySQLHandler::EscapeString(KOPRIVA); - Escaped 7 characters to KOPRIVA.

[15:28:02] >> mysql_query_callback( Connection handle: 1 )

[15:28:02] CMySQLHandler::Query("CheckUser") - Custom callback query with index 0 started (ExtraID: -1)

[15:28:02] CMySQLHandler::ProcessQueryThread(SELECT * FROM `users` WHERE `Username` = 'KOPRIVA' LIMIT 1) - Data is getting passed to CheckUser() - (Threadsafe: Yes)

[15:28:02] CheckUser(0,"SELECT * FROM `users` WHERE `Username` = 'KOPRIVA' LIMIT 1") - Called.

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

[15:28:02] CMySQLHandler::StoreResult() - Result was stored.

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

[15:28:02] CMySQLHandler::NumRows() - Returned 1 row(s)

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

[15:28:02] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:28:09] >> mysql_format( Connection handle: 1 )

[15:28:09] CMySQLHandler::EscapeString(KOPRIVA); - Escaped 7 characters to KOPRIVA.

[15:28:09] CMySQLHandler::EscapeString(marko); - Escaped 5 characters to marko.

[15:28:09] >> mysql_query_callback( Connection handle: 1 )

[15:28:09] CMySQLHandler::Query("LoginUser") - Custom callback query with index 0 started (ExtraID: -1)

[15:28:09] CMySQLHandler::ProcessQueryThread(SELECT * FROM `users` WHERE `Username` = 'KOPRIVA' AND `Password` = md5('marko') LIMIT 1) - Data is getting passed to LoginUser() - (Threadsafe: Yes)

[15:28:09] LoginUser(0,"SELECT * FROM `users` WHERE `Username` = 'KOPRIVA' AND `Password` = md5('marko') LIMIT 1") - Called.

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

[15:28:09] CMySQLHandler::StoreResult() - Result was stored.

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

[15:28:09] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:28:09] >> mysql_fetch_row_format( Connection handle: 1 )

[15:28:09] CMySQLHandler::FetchRow() - Return: 3|KOPRIVA|c28aa76990994587b0e907683792297c|0

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

[15:28:09] CMySQLHandler::FreeResult() - Result was successfully free'd.

Johnâ„¢
Joey_
Godfather
pre 12 godina
#39
Dodaj si ovaj callback u skriptu i reci mi sto ce ti ispisat u konzolu:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
	printf("mySQL Error: ID: %d | Error: %s | Query: %s", erroid, error, query);
	return 1;
}

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava