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):