SA-MP Forums Archive
House System Problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: House System Problem (/showthread.php?tid=539663)


House System Problem - sagoza - 29.09.2014

Iam creating this house system with the use of a database, everything was going fine, until one of the coordinates failed to load!

All other coords load onto the string, get converted to float and placed in the enum that i created... you can see in the link at the bottom of this post, in pastebin...

Only the ExitZ coordinate doesnt load, i have checked the name in the database, the variable name, changed so many things so that it loads correctly but it doesnt...

Pastebin Link: http://pastebin.com/EDhQEuMQ

I really apreciate all the help, and tips on how to use mysql commands...

My mysql plugin is StrickenKid's Plugin

Re: House System Problem - dusk - 29.09.2014

What about your mysql log?

Re: House System Problem - sagoza - 29.09.2014

This is my full Log, in one launch that failed to get ExitZ coord

Код:
[Mon Sep 29 16:07:09 2014] -------------------------
[Mon Sep 29 16:07:09 2014]      Logging Started
[Mon Sep 29 16:07:09 2014] -------------------------
[Mon Sep 29 16:07:09 2014] Connected (0) to svcall @ 127.0.0.1 via TCP/IP.
[Mon Sep 29 16:07:09 2014] MySQL Server Version 5.6.20.
Server log
Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[16:08:17] 
[16:08:17] Server Plugins
[16:08:17] --------------
[16:08:17]  Loading plugin: streamer
[16:08:17] 

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

[16:08:17]   Loaded.
[16:08:17]  Loading plugin: sscanf
[16:08:17] 

[16:08:17]  ===============================

[16:08:17]       sscanf plugin loaded.     

[16:08:17]          Version:  2.8.1        

[16:08:17]    © 2012 Alex "******" Cole  

[16:08:17]  ===============================

[16:08:17]   Loaded.
[16:08:17]  Loading plugin: mysql
[16:08:17]  SA:MP MySQL Plugin v2.1.1 Loaded.
[16:08:17]   Loaded.
[16:08:17]  Loaded 3 plugins.

[16:08:17] [MySQL] Thread running. Threadsafe: Yes.
[16:08:17] 
[16:08:17] Filterscripts
[16:08:17] ---------------
[16:08:17]   Loading filterscript 'cardealership.amx'...
[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17]  ======================================= 
[16:08:17]  |                                     | 
[16:08:17]  |        YSI version 3.09.0684        | 
[16:08:17]  |        By Alex "******" Cole        | 
[16:08:17]  |                                     | 
[16:08:17]  ======================================= 
[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17] 
--------------------------------------
[16:08:17]  CarDealerShip By Sagoza
[16:08:17] --------------------------------------

[16:08:17]   Loading filterscript 'ptr_propriedades.amx'...
[16:08:17]   Loading filterscript 'adminspec.amx'...
[16:08:17]   Loading filterscript 'admincontrol.amx'...
[16:08:17] 
--Base FS loaded.

[16:08:17]   Loading filterscript 'houseaa.amx'...
[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17]  ======================================= 
[16:08:17]  |                                     | 
[16:08:17]  |        YSI version 3.09.0684        | 
[16:08:17]  |        By Alex "******" Cole        | 
[16:08:17]  |                                     | 
[16:08:17]  ======================================= 
[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17] 
--------------------------------------
[16:08:17]  House System By Sagoza
[16:08:17] --------------------------------------

[16:08:17] [MySQL] Connected (0) to 'svcall'@'127.0.0.1 via TCP/IP'.
[16:08:17] [MySQL] Server Version 5.6.20.
[16:08:17] (1):ExitZ-String: 0.000000
[16:08:17] (1):Float: {2324.419921}{-1145.569946}{0.000000}(Venda:0)
[16:08:17] (2):ExitZ-String: 0.000000
[16:08:17] (2):Float: {223.041000}{1287.729980}{0.000000}(Venda:0)
[16:08:17] (3):ExitZ-String: 0.000000
[16:08:17] (3):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (4):ExitZ-String: 0.000000
[16:08:17] (4):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (5):ExitZ-String: 0.000000
[16:08:17] (5):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (6):ExitZ-String: 0.000000
[16:08:17] (6):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (7):ExitZ-String: 0.000000
[16:08:17] (7):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (8):ExitZ-String: 0.000000
[16:08:17] (8):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (9):ExitZ-String: 0.000000
[16:08:17] (9):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (10):ExitZ-String: 0.000000
[16:08:17] (10):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (11):ExitZ-String: 0.000000
[16:08:17] (11):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (12):ExitZ-String: 0.000000
[16:08:17] (12):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (13):ExitZ-String: 0.000000
[16:08:17] (13):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (14):ExitZ-String: 0.000000
[16:08:17] (14):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (15):ExitZ-String: 0.000000
[16:08:17] (15):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (16):ExitZ-String: 0.000000
[16:08:17] (16):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (17):ExitZ-String: 0.000000
[16:08:17] (17):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (18):ExitZ-String: 0.000000
[16:08:17] (18):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (19):ExitZ-String: 0.000000
[16:08:17] (19):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (20):ExitZ-String: 0.000000
[16:08:17] (20):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (21):ExitZ-String: 0.000000
[16:08:17] (21):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (22):ExitZ-String: 0.000000
[16:08:17] (22):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (23):ExitZ-String: 0.000000
[16:08:17] (23):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (24):ExitZ-String: 0.000000
[16:08:17] (24):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (25):ExitZ-String: 0.000000
[16:08:17] (25):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (26):ExitZ-String: 0.000000
[16:08:17] (26):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17] (27):ExitZ-String: 0.000000
[16:08:17] (27):Float: {223.041000}{1287.729980}{0.000000}(Venda:1)
[16:08:17]   Loading filterscript 'gl_actions.amx'...
[16:08:17]   Loading filterscript 'gl_realtime.amx'...
[16:08:17]   Loading filterscript 'gl_mapicon.amx'...
[16:08:17]   Loading filterscript 'skinchanger.amx'...
[16:08:17] 
--Admin Player Skin Changer Loaded

[16:08:17]   Loading filterscript 'gangzones_test.amx'...
[16:08:17] Gang Zone Skate Park Criada com sucesso
[16:08:17] Gang Zone Bairro do Porto Criada com sucesso
[16:08:17] Gang Zone Centro Comercial Criada com sucesso
[16:08:17] Gang Zone Bairro Lowrider Criada com sucesso
[16:08:17]   Loading filterscript 'gang_deposit.amx'...
[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17]  ======================================= 
[16:08:17]  |                                     | 
[16:08:17]  |        YSI version 3.09.0684        | 
[16:08:17]  |        By Alex "******" Cole        | 
[16:08:17]  |                                     | 
[16:08:17]  ======================================= 
[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17]   Loading filterscript 'veh_spawn.amx'...
[16:08:17]   Loading filterscript 'teleports.amx'...
[16:08:17]   Loaded 13 filterscripts.

[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17]  ======================================= 
[16:08:17]  |                                     | 
[16:08:17]  |        YSI version 3.09.0684        | 
[16:08:17]  |        By Alex "******" Cole        | 
[16:08:17]  |                                     | 
[16:08:17]  ======================================= 
[16:08:17]  
[16:08:17]  
[16:08:17]  
[16:08:17] Number of vehicle models: 116
[16:08:17]  
[16:08:17]  ========================================== 
[16:08:17]  |                                        | 
[16:08:17]  |  A new version (v<html>
  ) of YSI is  | 
[16:08:17]  |            available from:             | 
[16:08:17]  |                                        | 
[16:08:17]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[16:08:17]  |                                        | 
[16:08:17]  ========================================== 
[16:08:17]  
[16:08:17]  
[16:08:17]  ========================================== 
[16:08:17]  |                                        | 
[16:08:17]  |  A new version (v<html>
  ) of YSI is  | 
[16:08:17]  |            available from:             | 
[16:08:17]  |                                        | 
[16:08:17]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[16:08:17]  |                                        | 
[16:08:17]  ========================================== 
[16:08:17]  
[16:08:17]  
[16:08:17]  ========================================== 
[16:08:17]  |                                        | 
[16:08:17]  |  A new version (v<html>
  ) of YSI is  | 
[16:08:17]  |            available from:             | 
[16:08:17]  |                                        | 
[16:08:17]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[16:08:17]  |                                        | 
[16:08:17]  ========================================== 
[16:08:17]  
[16:08:17]  
[16:08:17]  ========================================== 
[16:08:17]  |                                        | 
[16:08:17]  |  A new version (v<html>
  ) of YSI is  | 
[16:08:17]  |            available from:             | 
[16:08:17]  |                                        | 
[16:08:17]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[16:08:17]  |                                        | 
[16:08:17]  ========================================== 
[16:08:17]


Re: House System Problem - makstar - 29.09.2014

Try to re-compile the script or check where the error lies. Make sure you have the latest includes with you and then recompile the script.