GTA:BLKN
PRIJAVA REGISTRACIJA

Pretraga

Pritisnite Enter za pretragu ili Escape za zatvaranje

marsmarin

marsmarin

Wheel Man

Poslednja aktivnost

pre 12 godina

postova

48

Kreiranih tema

17

XP

240

Pridružio se

okt. 2010

Trenutna aktivnost

Izgleda da marsmarin trenutno ne radi ništa

Odgovorio na Sep 23, 2012
[POMOC]LoadHouses moram izvrsit 3 puta
GTA San Andreas Multiplayer / Pitanja & Pomoć
Skripta koju koristim: GF edit
Detaljan opis problema: Napokon sam napravio da mi se kuce ucitavaju iz MySQL baze, ali moram 3 puta utipkat komandu /loadhouses plus jednom sto se ucitaju u OnGameModeInIt. Prva tri puta mi MySQL vraca ovaj error CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
Dio skripte:

LoadHouses
stock LoadHouses()
{
	new buffer;
	new field;
	new idx;
	
	mysql_function_query(gConnectionHandle, "SELECT * FROM houses", false, "OnQueryFinish", "s", "SELECT * FROM houses");
	mysql_store_result();
	if(mysql_num_rows() > 0)
	{
		while(mysql_fetch_row_format(buffer, "|"))
		{
			split(buffer, field, '|');
			idx = strval(field);
			
			HouseInfo = floatstr(field);
			HouseInfo = floatstr(field);
			HouseInfo = floatstr(field);
			HouseInfo = floatstr(field);
			HouseInfo = floatstr(field);
			HouseInfo = floatstr(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			strmid(HouseInfo, field, 0, strlen(field), 255);
			strmid(HouseInfo, field, 0, strlen(field), 255);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			if(HouseInfo == 457)
			{
				HouseInfo = 411;
			}
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			HouseInfo = strval(field);
			if(HouseInfo == 0)
			{
				AddStaticPickup(1273, 1, HouseInfo, HouseInfo, HouseInfo);
				pickups++;
			}
			if(HouseInfo == 1)
			{
				AddStaticPickup(1239, 1, HouseInfo, HouseInfo, HouseInfo);
				pickups++;
			}
			AddStaticVehicleEx(HouseInfo, HouseCarSpawns, HouseCarSpawns, HouseCarSpawns, HouseCarSpawns, HouseInfo, HouseInfo, 60000);
			gCarLock[idx+1] = 1;
		}
	}
	printf("Houses Loaded");
	mysql_free_result();
	return 1;
}


Komanda /loadhouses
	if(strcmp(cmd, "/loadhouses", true) == 0)
	{
	LoadHouses();
	SendClientMessage(playerid, COLOR_YELLOW, "Ucitao si kuce"); 
	return 1;
	}


mysql_log nakon sto sam jednom zvao funkciju LoadHouses
[15:59:33] >> mysql_connect(localhost, root, sa-mp, ******) on port 3306
[15:59:33] CMySQLHandler::CMySQLHandler() - constructor called.
[15:59:33] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root"
[15:59:33] CMySQLHandler::Connect() - Connection was successful.
[15:59:33] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[15:59:33]  
[15:59:33]  ** MySQL Debugging enabled (09/23/12)
[15:59:33]  
[15:59:33] >> mysql_query_callback( Connection handle: 1 )
[15:59:33] >> mysql_store_result( Connection handle: 1 )
[15:59:33] CMySQLHandler::StoreResult() - No data to store.
[15:59:33] >> mysql_num_rows( Connection handle: 1 )
[15:59:33] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[15:59:33] >> mysql_free_result( Connection handle: 1 )
[15:59:33] CMySQLHandler::FreeResult() - The result is already empty.
[15:59:33] Passing query SELECT * FROM houses | s
[15:59:33] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[15:59:33] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:59:33] OnQueryFinish(s) - Threaded function called.


MySQL log nakon sto sam 4 puta zvao funkciju LoadHouses
[16:03:02] >> mysql_connect(localhost, root, sa-mp, ******) on port 3306
[16:03:02] CMySQLHandler::CMySQLHandler() - constructor called.
[16:03:02] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root"
[16:03:02] CMySQLHandler::Connect() - Connection was successful.
[16:03:02] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[16:03:02]  
[16:03:02]  ** MySQL Debugging enabled (09/23/12)
[16:03:02]  
[16:03:02] >> mysql_query_callback( Connection handle: 1 )
[16:03:02] >> mysql_store_result( Connection handle: 1 )
[16:03:02] CMySQLHandler::StoreResult() - No data to store.
[16:03:02] >> mysql_num_rows( Connection handle: 1 )
[16:03:02] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[16:03:02] >> mysql_free_result( Connection handle: 1 )
[16:03:02] CMySQLHandler::FreeResult() - The result is already empty.
[16:03:02] Passing query SELECT * FROM houses | s
[16:03:02] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[16:03:02] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[16:03:02] OnQueryFinish(s) - Threaded function called.
[16:03:56] >> mysql_query_callback( Connection handle: 1 )
[16:03:56] >> mysql_store_result( Connection handle: 1 )
[16:03:56] CMySQLHandler::StoreResult() - No data to store.
[16:03:56] >> mysql_num_rows( Connection handle: 1 )
[16:03:56] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[16:03:56] >> mysql_free_result( Connection handle: 1 )
[16:03:56] CMySQLHandler::FreeResult() - The result is already empty.
[16:03:56] Passing query SELECT * FROM houses | s
[16:03:56] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[16:03:56] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[16:03:56] OnQueryFinish(s) - Threaded function called.
[16:04:30] >> mysql_query_callback( Connection handle: 1 )
[16:04:30] >> mysql_store_result( Connection handle: 1 )
[16:04:30] CMySQLHandler::StoreResult() - Result was stored.
[16:04:30] Passing query SELECT * FROM houses | s
[16:04:30] >> mysql_num_rows( Connection handle: 1 )
[16:04:30] CMySQLHandler::NumRows() - Returned 16 row(s)
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[16:04:30] CMySQLHandler::FetchRow() - Return: 1|2495.47754|-1690.99097|14.76560|2496.64990|-1696.55005|1014.73999|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Srednja Kuca|25000|0|0|3|1|0|0|10|0|844|418|-1|-1|260|3
[16:04:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 3|2256.97583|-1644.55859|15.51976|346.87003|309.25903|999.15570|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|6|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 2|2244.44385|-1638.32654|15.90741|328.10660|1478.01062|1084.43750|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|15|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 4|2282.12915|-1642.15674|15.62792|225.75699|1240.00000|1082.14990|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|2|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 5|2362.70020|-1643.99109|13.53179|328.10660|1478.01062|1084.43750|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|15|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 6|2393.31885|-1646.20093|13.90510|244.41199|305.03299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 7|2413.85889|-1647.03125|14.01192|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 8|2451.93555|-1641.82703|13.73574|260.98398|1286.54993|1080.29993|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|4|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 9|2469.66235|-1647.00232|13.51823|244.41199|305.03299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 10|2469.66235|-1647.00232|13.51823|244.41199|305.03299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzavno|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|418|-1|-1|267|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 11|2384.68457|-1675.17322|14.91522|302.18100|300.72299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|4|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 12|2368.25269|-1675.30371|14.16817|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 13|2327.33350|-1681.67078|14.92969|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|203|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 14|2327.33350|-1681.67078|14.92969|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzavno|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|418|-1|-1|267|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 15|2385.89233|-1712.09888|14.24219|446.50140|507.02951|1001.41949|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|12|1|0|0|0|0|0|0|-1|-1|203|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 16|2385.89233|-1712.09888|14.24219|446.50140|507.02951|1001.41949|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzavno|Mala Kuca|25000|0|0|12|1|0|0|0|0|0|418|-1|-1|267|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] >> mysql_free_result( Connection handle: 1 )
[16:04:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:04:30] OnQueryFinish(s) - Threaded function called.

Neke slike/video za lakse dobivanje pomoci(neobavezno):
Odgovorio na Sep 13, 2012
[POMOC]MySQL LoadHouses
GTA San Andreas Multiplayer / Pitanja & Pomoć
Skripta koju koristim: GF Edit
Detaljan opis problema: Pokusao sam napraviti da se kuce ucitavaju iz MySQL baze ali mi se ne ucitaju neznam gdje sam pogrjesio. Dolje vam se nalaze MySQL_log, server_log, LoadHouses i OnGameModeInIt funkcija ne cijela samo MySQL dio.
Dio skripte:
My_SQL_log
[17:26:30] >> mysql_connect(localhost, root, sa-mp, ******) on port 3306
[17:26:30] CMySQLHandler::CMySQLHandler() - constructor called.
[17:26:30] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root"
[17:26:30] CMySQLHandler::Connect() - Connection was successful.
[17:26:30] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[17:26:30]  
[17:26:30]  ** MySQL Debugging enabled (09/13/12)
[17:26:30]  
[17:26:30] >> mysql_format( Connection handle: 1 )
[17:26:30] >> mysql_query_callback( Connection handle: 1 )
[17:26:30] >> mysql_num_rows( Connection handle: 1 )
[17:26:30] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[17:26:30] Passing query SELECT * FROM houses WHERE id=1 | s
[17:26:30] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses WHERE id=1)
[17:26:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:26:30] OnQueryFinish(s) - Threaded function called.


server_log

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

SA-MP Dedicated Server
----------------------
v0.3e-R2, (C)2005-2012 SA-MP Team

[17:31:30] filterscripts = ""  (string)
[17:31:30] 
[17:31:30] Server Plugins
[17:31:30] --------------
[17:31:30]  Loading plugin: streamer
[17:31:30] 

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

[17:31:30]  Loaded.
[17:31:30]  Loading plugin: mysql
[17:31:30] 

  > MySQL plugin R7 successfully loaded.

[17:31:30]  Loaded.
[17:31:30]  Loaded 2 plugins.

[17:31:30] 
[17:31:30] Filterscripts
[17:31:30] ---------------
[17:31:30]  Loaded 0 filterscripts.

[17:31:30] House Loaded
[17:31:30] BizzInfo:0 Owner:The State Message:~w~Gun Shop 1 Entfee:0 Till:0 Products:100/500 Interior:1.

[17:31:30] BizzInfo:1 Owner:The State Message:~w~Gun Shop 2 Entfee:0 Till:0 Products:100/500 Interior:4.

[17:31:30] BizzInfo:2 Owner:The State Message:~w~Restaurant Entfee:0 Till:0 Products:100/500 Interior:1.

[17:31:30] BizzInfo:3 Owner:The State Message:~w~City Bank Entfee:0 Till:0 Products:99992/100000 Interior:0.

[17:31:30] BizzInfo:4 Owner:The State Message:~w~The Welcome Pump bar Entfee:0 Till:0 Products:499/500 Interior:18.

[17:31:30] SBizzInfo:0 Owner:The State Message:~w~Bikes renting Entfee:5 Till:485 Products:-8/100 Interior:0.

[17:31:30] SBizzInfo:1 Owner:CuervO Message:~w~Wang Cars Entfee:30 Till:1320 Products:47/100 Interior:0.

[17:31:30] SBizzInfo:2 Owner:The State Message:~w~MTS kompanija Entfee:0 Till:45 Products:100/100 Interior:0.

[17:31:30] SBizzInfo:3 Owner:The State Message:~w~Gas Company Entfee:1 Till:8546 Products:100/100 Interior:0.

[17:31:30] SBizzInfo:4 Owner:The State Message:~w~Electricity Company Entfee:5 Till:-446028172 Products:100/100 Interior:0.

[17:31:30] SBizzInfo:5 Owner:The State Message:~w~Pay & Spray Entfee:1 Till:5002 Products:98/100 Interior:0.

[17:31:30] SBizzInfo:6 Owner:The State Message:~w~House Upgrade Entfee:0 Till:51500 Products:100/100 Interior:0.

[17:31:30] SBizzInfo:7 Owner:The State Message:~w~CNN Studio Entfee:0 Till:24725 Products:100/100 Interior:0.

[17:31:30] SBizzInfo:8 Owner:The State Message:Un Named Entfee:0 Till:250 Products:97/100 Interior:0.

[17:31:30] SBizzInfo:9 Owner:The State Message:~w~General Store Entfee:0 Till:357670 Products:98/100 Interior:0.

[17:31:30] SBizzInfo:10 Owner:The State Message:~w~Paintball Arena Entfee:0 Till:0 Products:100/100 Interior:0.

[17:31:30] SBizzInfo:11 Owner:Ninoslav_Jovanovic Message:Nino'v Kart Entfee:0 Till:550000 Products:94/100 Interior:0.

[17:31:30] Family:0 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:1 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:2 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:3 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:4 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:5 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:6 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:7 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:8 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] Family:9 Taken: 0 Name:None MOTD:None Leader:None Members:0 SpawnX:0.000000 SpawnY:0.000000 SpawnZ:0.000000 Int:0
[17:31:30] CK:0 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:1 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:2 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:3 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:4 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:5 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:6 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:7 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:8 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] CK:9 Taken: 0 Sendername:No-one Giveplayer: No-one
[17:31:30] Paper:0 Used: 0 Maker:No-one. Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:1 Used: 0 Maker:0

 Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:2 Used: 0 Maker:No-one. Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:3 Used: 0 Maker:0

 Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:4 Used: 0 Maker:No-one. Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:5 Used: 0 Maker:0

 Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:6 Used: 0 Maker:No-one. Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:7 Used: 0 Maker:0

 Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:8 Used: 0 Maker:No-one. Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] Paper:9 Used: 0 Maker:0

 Title: No Title. Text1: I have no text inserted here yet. Text2: I have no text inserted here yet. Text3: I have no text inserted here yet. Text4: I have no text inserted here yet. Text5: I have no text inserted here yet. Text6: I have no text inserted here yet. Text7: I have no text inserted here ye
[17:31:30] EnableTirePopping() function is removed.
[17:31:30] Warning: EnableZoneNames() is removed since 0.3
[17:31:30] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[17:31:30] Pickups Max = 100, Current Pickups = 47
[17:31:30]  
[17:31:30] Number of vehicle models: 63
[17:31:30] Query SELECT * FROM houses WHERE id=1 se uspješno izvršio!


LoadHouses
public LoadHouses()
{
	new arrCoords;
	for(new idx = 0; idx < sizeof(HouseInfo); idx++)
	{
		mysql_format(gConnectionHandle, Query, "SELECT * FROM houses WHERE id=%d", idx+1);
		mysql_function_query(gConnectionHandle, Query, false, "OnQueryFinish", "s", Query);
		// mysql_store_result();
		if(mysql_num_rows(gConnectionHandle) == 1)
		{
		  if(mysql_retrieve_row())
		  {
				mysql_fetch_field_row(arrCoords, "Entrancex"); HouseInfo = floatstr(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Entrancey"); HouseInfo = floatstr(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Entrancez"); HouseInfo = floatstr(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Exitx"); HouseInfo = floatstr(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Exity"); HouseInfo = floatstr(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Exitz"); HouseInfo = floatstr(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Healthx"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Healthy"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Healthz"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Armourx"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Armoury"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Armourz"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Owner"); strmid(HouseInfo, arrCoords, 0, strlen(arrCoords), 255);
			    mysql_fetch_field_row(arrCoords, "Description"); strmid(HouseInfo, arrCoords, 0, strlen(arrCoords), 255);
			    mysql_fetch_field_row(arrCoords, "Price"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Hel"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Arm"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Interior"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Locked"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Owned"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Rooms"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Rent"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Rentable"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Takings"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Vehicle"); HouseInfo = strval(arrCoords);
  	      		if(HouseInfo == 457)
				{
					HouseInfo = 411;
				}
			  	mysql_fetch_field_row(arrCoords, "Color1"); HouseInfo = strval(arrCoords);
			  	mysql_fetch_field_row(arrCoords, "Color2"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Date"); HouseInfo = strval(arrCoords);
			    mysql_fetch_field_row(arrCoords, "Level"); HouseInfo = strval(arrCoords);
			}
		}
		// mysql_free_result();
	}
	return 1;
}


OnGameModeInit
public OnGameModeInit()
{
	gConnectionHandle = mysql_connect("localhost", "root", "sa-mp", "root");
	
	mysql_debug(1);
	
	LoadHouses();
	printf("House Loaded");
	return 1;
}

Neke slike/video za lakse dobivanje pomoci(neobavezno):
Odgovorio na Aug 30, 2012
[GM]CroSector v0.9
GTA San Andreas Multiplayer / Gamemodovi
Marko wrote on August 29, 2012, 9:15 pm:
Kod mene kod svake orge osim pd, znaci udjem u kucu u pod propadne, aj moze on hodati al kad izadjem, stvori me kod one kuce u jeffersonu, a u pawnu ne mogu naci gdje su koordinate od ulaza i izlaza, i ima jos bug sa autima, svi civili mogu voziti svako auto, sad jel to do mene ili je do moda, ako moze pomoc oko toga


Na  komandi /exit treba nadodat kordinate za izlaz iz interijera od organizacija. A za ovo sto propada u pod to na kordinatu Z nadodaj 1. Server nikad nije testiran kako treba pa se zato desavaju ovakvi bugovi.

Marko_V wrote on August 30, 2012, 12:12 pm:
Jel mozes da upload mod na neki drugi sajt npr 2shared


http://www.sendspace.com/file/piw9lu
Odgovorio na Aug 29, 2012
[GM]CroSector v0.9
GTA San Andreas Multiplayer / Gamemodovi
Quote from August 29, 2012, 3:49 pm:
edit cybera -.-


Edit cybera nije jer ga nemam u kompu. Imam oko 7 skripti u kompu, a cyber nije među njima. Siguran sam da sam editiro skriptu koja mi je u kompu jer se sjecam kad sam nesto zaj.ebo samo bi kopiro to nesto iz nje i ponovno pokuso. Ali nije ni bitno jel edit cybera ili nije glavno da ti se skripta sviđa bar se nadam da ti se sviđa.
Odgovorio na Aug 29, 2012
[GM]CroSector v0.9
GTA San Andreas Multiplayer / Gamemodovi
Quote from August 29, 2012, 3:42 pm:
Dobar opis, idem testat pa javim
EDIT: Pa to je običan Cyber


Dal cyber ima Stanove, Dal cyberu radi jail system, dal cyber ima ovakvu auto skolu?
Odgovorio na Aug 29, 2012
[GM]CroSector v0.9
GTA San Andreas Multiplayer / Gamemodovi

Slike
http://desmond.imageshack.us/Himg845/scaled.php?server=845&filename=samp001jl.png&res=landing
http://desmond.imageshack.us/Himg507/scaled.php?server=507&filename=samp000kb.png&res=landing
DOWNLOAD
https://rapidshare.com/files/3923173203/CroSector.zip
http://www.sendspace.com/file/piw9lu
Odgovorio na Aug 25, 2011
[Pomoc]Par pitanja u vezi sscanf-a
GTA San Andreas Multiplayer / Pitanja & Pomoć
Skripta koju koristim://
Detaljan opis problema: Zanima me dali je obavezno koristiti sscanf kad radimo zcmd komande.Jos me zanima ako ga koristimo u pisanju zcmd komandi hoce li server brze odgovarat na komande ili sporije ili jednakom brzinom kao da koristimo sam zcmd bez sscanf-a.
Dio skripte://
Neke slike/video za lakse dobivanje pomoci(neobavezno)://

Unapred hvala!!!
Odgovorio na Aug 13, 2011
[Pomoc]Komande /rentcar /unrentcar /lock
GTA San Andreas Multiplayer / Pitanja & Pomoć
Skripta koju koristim: Street Stories Edit

Detaljan opis problema: Rentam auto sa /rentcar i onda kad ga idem /unrentcar pise mi SERVER: Unknown Command ali mi
                                      se auto respawna na mjesto di sam ga rento ali kad idem rentat drugi auto sa istom komandom
                                      /rentcar pise mi SERVER: Unknown Command.Također mi se javlja isti problem sa komandom /lock.
                                      Nadam se da ste shvatili znaci rentam auto sa /rentcar i onda ga unrentam sa /unrentcar i dobim
                                      ovu gresku SERVER: Unknown Command ali mi se auto respawna na mjesto na koje je bio na
                                      pocetku dok ga jos nisam rento i onda probam rentat drugi auto sa /rentcar i dobim ovaj error
                                      SERVER: Unknown Command.Ista stvar se desava sa komandom /lock.

Dio skripte:

/unrentcar

	if(strcmp(cmd, "/unrentcar", true) == 0)
	{
	    if(IsPlayerConnected(playerid))
		{
			if(HireCar != 299)
			{
			    SetVehicleToRespawn(HireCar);
				gCarLock[HireCar] = 0;
				UnLockCar(HireCar);
				HireCar = 299;
				GameTextForPlayer(playerid, "~w~Vi ste vratili iznajmljeno vozilo", 5000, 3);
				if(idcar == HireCar)
			    {
			        TogglePlayerControllable(playerid, 1);
			    }
			}
		}
		return 1;
	}


/lock

	if(strcmp(cmd, "/lock", true) == 0)
	{
	    if(IsPlayerConnected(playerid))
	    {
			new carid;
			if (gTeam == 2 || gTeam == 1)
			{
				if(gLastCar == 0 && PlayerInfo == 255)
				{
					SendClientMessage(playerid, COLOR_GRAD2, "  Vi nemate vozilo.");
					return 1;
				}
				else if(gLastCar != 0 && gLastCar != PlayerInfo+1)
				{
					if (HireCar != gLastCar && HireCar != 299)
					{
						gLastDriver[HireCar] = 300;
						gCarLock[HireCar] = 0;
						UnLockCar(HireCar);
					}
					HireCar = gLastCar;
				}
			}
			if (PlayerInfo == 255)
			{
				if(HireCar == 299)
				{
					SendClientMessage(playerid, COLOR_GRAD2, "  Vi nemate vozilo.");
					return 1;
				}
			}
			carid = PlayerInfo+1;
			if(HireCar != 299 && !SwitchKey)
			{
				carid = HireCar;
			}
			//new driver = gLastDriver;
			new lockstatus = gCarLock;
			new Float:cx,Float:cy,Float:cz;
			GetVehiclePos(carid, cx, cy, cz);
			switch (lockstatus)
			{
				case 0:
				{
					if(HireCar == 299 && PlayerInfo == 255)
					{
						SendClientMessage(playerid, COLOR_GRAD2, "  Vi nemate vozilo");
						return 1;
					}
					if(HireCar == carid && !SwitchKey)
					{
						GameTextForPlayer(playerid, "~w~Iznajmljeno vozilo ~r~Zakljucano", 5000, 6);
						PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
						gCarLock = 1;
						LockCar(carid);
					}
					else if (PlayerInfo == carid-1)
					{
						GameTextForPlayer(playerid, "~w~Kucno vozilo ~r~Zakljucano", 5000, 6);
						PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
						gCarLock = 1;
						LockCar(carid);
						return 1;
					}
				}
				case 1:
				{
					if(HireCar == 299 && PlayerInfo == 255)
					{
						SendClientMessage(playerid, COLOR_GRAD2, "  Vi nemate vozilo");
						return 1;
					}
					if(HireCar == carid && !SwitchKey)
					{
						GameTextForPlayer(playerid, "~w~Iznajmljeno vozilo ~g~Otkljucano", 5000, 6);
						PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
						gCarLock = 0;
						UnLockCar(carid);
					}
					if (PlayerInfo == carid-1)
					{
						GameTextForPlayer(playerid, "~w~Kucno vozilo ~g~Otkljucano", 5000, 6);
						PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
						gCarLock = 0;
						UnLockCar(carid);
						return 1;
					}
				}
				default:
				{
					SendClientMessage(playerid, COLOR_GRAD2, "  Greska");
				}
			}
			if(carid == 256)
			{
				SendClientMessage(playerid, COLOR_GRAD2, "  Vi nemate vozilo !");
			}
		}
		return 1;
	}


/rentcar

	if(strcmp(cmd, "/rentcar", true) == 0)
	{
	    new newcar = GetPlayerVehicleID(playerid);
        if(IsPlayerConnected(playerid))
		{
			if(newcar == burg1 || newcar == burg2 || newcar == burg3 || newcar == burg4 || newcar == burg5 || newcar == burg6 || newcar == burg7 || newcar == burg8 || newcar == burg9 || newcar == burg10 || newcar == burg11 || newcar == burg12 || newcar == burg13 || newcar == burg14)
			{
				new hirefee = HireCost(GetPlayerVehicleID(playerid));
				if(SBizzInfo == 0)
				{
					GameTextForPlayer(playerid, "~r~Rasprodato", 5000, 1);
					return 1;
				}
				if (GetPlayerMoney(playerid) <  500)
				{
					SendClientMessage(playerid, COLOR_GRAD2, "  Nemate dovoljno novca !");
					return 1;
				}
				if(HireCar != 299)
				{
					gCarLock[HireCar] = 0;
					UnLockCar(HireCar);
					SendClientMessage(playerid, COLOR_GREY, "Morate prvo da /unrentcar staro vozilo da bi iznajmili novo !");
					return 1;
				}
				for(new i=0; i				{
				    if(HireCar == GetPlayerVehicleID(playerid))
				    {
				        SendClientMessage(playerid, COLOR_GREY, "    Neko je vec iznajmio ovo vozilo !");
				        return 1;
				    }
				}
				SafeGivePlayerMoney(playerid,-500);
				SBizzInfo += 500;
				ExtortionSBiz(0, SBizzInfo);
				SBizzInfo--;
				HireCar = GetPlayerVehicleID(playerid);
				OnPropUpdate();
				PlayerPlaySound(playerid, 1052, 0.0, 0.0, 0.0);
				format(string, sizeof(string), "~w~Ne zaboravite da ~r~/unrentcar~n~~g~/lock ~w~da zakljucate vozilo.",hirefee);
				SendClientMessage(playerid, COLOR_YELLOW2, "Sada mozete da upalite vozilo !");
				gEngine = 0;
				engineOn[GetPlayerVehicleID(playerid)] = false;
				GameTextForPlayer(playerid, string, 5000, 3);
			}
		}
		return 1;
	}


Definiran HireCar

new HireCar;

HireCar = 299;


Definiran gCarLock

new gCarLock;



Definiran UnLockCar

forward UnLockCar(carid);

public UnLockCar(carid)
{
	for(new i = 0; i < MAX_PLAYERS; i++)
	{
		if(IsPlayerConnected(i))
		{
			if(!IsAPlane(carid))
			{
				SetVehicleParamsForPlayer(carid,i,0,0);
			}
		}
	}
}


Definiran idcar

new idcar = GetPlayerVehicleID(playerid);


Definirani auti

new burg1, burg2, burg3, burg4, burg5, burg6, burg7, burg8, burg9, burg10, burg11, burg12, burg13, burg14;

U Funkciji OnGameModeInit
burg1 = AddStaticVehicleEx(545,1096.79345703,-928.13684082,42.88260269,182.00000000,-1,1,600); //Hustler
burg2 = AddStaticVehicleEx(545,1093.39147949,-928.21777344,42.85870743,182.00000000,1,1,600); //Hustler
burg3 = AddStaticVehicleEx(545,1085.74975586,-927.95623779,42.83689880,180.00000000,1,1,600); //Hustler
burg4 = AddStaticVehicleEx(545,1089.30151367,-928.02368164,42.84541702,180.00000000,-1,1,600); //Hustler
burg5 = AddStaticVehicleEx(545,1100.74670410,-928.05596924,42.87611008,180.00000000,1,1,600); //Hustler
burg6 = AddStaticVehicleEx(545,1104.48083496,-928.03576660,42.88219833,181.99963379,-1,1,600); //Hustler
burg7 = AddStaticVehicleEx(545,1107.97058105,-928.00726318,42.87968826,180.00000000,1,1,600); //Hustler
burg8 = AddStaticVehicleEx(545,1111.83666992,-927.95635986,42.87968826,180.00000000,-1,1,600); //Hustler
burg9 = AddStaticVehicleEx(545,1115.51843262,-928.02166748,42.87968826,180.00000000,1,1,600); //Hustler
burg10 = AddStaticVehicleEx(545,1119.26745605,-927.86541748,42.87509155,180.00000000,-1,1,600); //Hustler
burg11 = AddStaticVehicleEx(545,1122.92565918,-928.07434082,42.87495041,180.00000000,1,1,600); //Hustler
burg12 = AddStaticVehicleEx(545,1126.72509766,-927.98028564,42.87968826,180.00000000,-1,1,600); //Hustler
burg13 = AddStaticVehicleEx(545,1130.37829590,-928.00952148,43.12968826,182.00000000,1,1,600); //Hustler
burg14 = AddStaticVehicleEx(409,1142.15710449,-914.20153809,43.10468674,182.00000000,1,1,600); //Stretch

U Funkciji OnPlayerStateChange

		if(newcar == burg1 || newcar == burg2 || newcar == burg3 || newcar == burg4 || newcar == burg5 || newcar == burg6 || newcar == burg7 || newcar == burg8 || newcar == burg9 || newcar == burg10 || newcar == burg11 || newcar == burg12 || newcar == burg13 || newcar == burg14)
		{
			if (HireCar != newcar)
			{
				format(string, sizeof(string), "~w~Mozete da iznajmite ovo vozilo~n~Kosta:~g~$500~n~~w~Da iznajmite, ukucajte ~g~/rentcar~w~~n~da izadjete ~r~/exit");
				TogglePlayerControllable(playerid, 0);
				GameTextForPlayer(playerid, string, 5000, 3);
			}
		}

Definiran newcar

new newcar = GetPlayerVehicleID(playerid);



Neke slike/video za lakse dobivanje pomoci(neobavezno): //

EDIT: Rijesio sam bio je problem u CarLock i UnLockCar funkciji ako nezelite da vam se ova greska ne javlja mozete samo stavit ove funkcije kao komentare ili mozete jednostavno nanovo napisat funkcije.Nadam se da ste me shvatili brzo sam piso.
Odgovorio na Aug 10, 2011
[Pomoc]Tag mismatch i jos jedan problem
GTA San Andreas Multiplayer / Pitanja & Pomoć
Skripta koju koristim: Balkan Stories edit

Detaljan opis problema: 1. Dobio sam warning tag mismatch.Forwardiro sam funkuciju.Definiro sve sto treba i dobio sam
                                          warning.
                                     
                                      2. U koje god vozilo da uÄ‘em pise mi nemate kljuceve od tog vozila ili nesto u tom stilu.Usput tu je
                                          jos jedan problem jer me zanima kako da definiram da jedan auto moze vozit jedna
                                          organizacija ali i da taj isti auto mislim isti id auta moze vozit i druga organizacija.Nadam se da
                                          razumijete.

Dio skripte: 1. Tag mismatch warning je na liniji 421 i 422

                        new Timerr;
                        new InfoBox;
                        forward ShowInfoBox(playerid, string[], time);                      

                        public ShowInfoBox(playerid, string[], time)
                      {
		        TextDrawSetString(InfoBox, string); //linija 421
		        TextDrawShowForPlayer(playerid, InfoBox); //linija 422
                        if(Timerr) KillTimer(Timerr);
		        Timerr = SetTimerEx("TextDrawOff", time, 0, "dd", playerid, GetPlayerVehicleID(playerid));
		        return 1;
                        }


Neke slike/video za lakse dobivanje pomoci(neobavezno)
3

Novi Član

Nivo 3

Iskustvo 40 / 100 XP
Ukupno XP: 240 60 XP do sledećeg nivoa
6
Dostignuća
240
Ukupno XP
0
Trenutni Niz
0
Najduži Niz

Sva Dostignuća

6 / 20 otključano

Prikaži sve →
🎯
Početak
Početak
Napišite 10 postova na forumu
+25 XP
⚡
Aktivni Saradnik
Aktivni Saradnik
Napišite 50 postova na forumu
+50 XP
🏅
Klub Stotina
Klub Stotina
Napišite 100 postova na forumu
+100 XP
🏆
Legenda Foruma
Legenda Foruma
Napišite 500 postova na forumu
+250 XP
👥
Vođa Diskusija
Vođa Diskusija
Kreirajte 10 tema na forumu
+50 XP
🛡️
Uzoran Građanin
Uzoran Građanin
30 dana bez ikakvih upozorenja
+40 XP
🔰
Primerni Član
Primerni Član
90 dana bez ikakvih upozorenja
+100 XP
🚩
Čuvar Zajednice
Čuvar Zajednice
Pošaljite 5 korisnih prijava
+75 XP
📅
Nedeljni Ratnik
Nedeljni Ratnik
Prijavite se 7 dana zaredom
+35 XP
🔥
Posvećeni Fan
Posvećeni Fan
Prijavite se 30 dana zaredom
+150 XP
💬
Prvi Post
Prvi Post
Napišite svoj prvi post na forumu
+10 XP
📝
Pokretač Tema
Pokretač Tema
Kreirajte svoju prvu temu
+15 XP
❤️
Poštovalac
Poštovalac
Dajte svoj prvi lajk na post
+5 XP
👍
Prvo Priznanje
Prvo Priznanje
Primite svoj prvi lajk na post
+5 XP
👤
Identitet Otkriven
Identitet Otkriven
Popunite profil sa avatarom i biografijom
+20 XP

Nedavna XP Aktivnost

+100
Otključano: Primerni Član
pre 1 nedelju
Dostignuće
+40
Otključano: Uzoran Građanin
pre 1 nedelju
Dostignuće
+50
Otključano: Vođa Diskusija
pre 1 nedelju
Dostignuće
+25
Otključano: Početak
pre 1 nedelju
Dostignuće
+15
Otključano: Pokretač Tema
pre 1 nedelju
Dostignuće
+10
Otključano: Prvi Post
pre 1 nedelju
Dostignuće