SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Filterscripts

Reply
 
Thread Tools Display Modes
Old 12/12/2018, 03:04 PM   #181
sanyaretro
Little Clucker
 
Join Date: Apr 2018
Posts: 4
Reputation: 0
Default Re: Yet Another House System

Hello dear forum users! I have a problem loading the database! Help me please! What's the matter?
************************************************** *********************************
Import successfully completed, completed 10 requests. (house.sql)

Mistake
SQL query:


CREATE TABLE `houseguns` (
`HouseID` int (11) NOT NULL,
`WeaponID` tinyint (4) NOT NULL,
`Ammo` int (11) NOT NULL,
UNIQUE KEY `HouseID_3` (` HouseID`, `WeaponID`),
KEY `HouseID` (` HouseID`),
CONSTRAINT `houseguns_ibfk_1` FOREIGN KEY (` HouseID`) REFERENCES `houses` (` ID`) ON DELETE
CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8


MySQL Answer: Documentation

# 1215 - Could not add foreign key constraints

Last edited by sanyaretro; 12/12/2018 at 03:40 PM.
sanyaretro is offline   Reply With Quote
Old 02/02/2020, 01:27 AM   #182
MarcosPauloRibeiro
Little Clucker
 
MarcosPauloRibeiro's Avatar
 
Join Date: Jan 2020
Location: Belo Horizonte - Brazil
Posts: 35
Reputation: 0
Default Re: Yet Another House System

Anyone can help me?

Code:
[23:16:59]   Loading filterscript 'house13.amx'...
[23:16:59] [debug] Run time error 19: "File or function is not found"
[23:16:59] [debug]  cache_get_field_content_int
[23:16:59] [debug]  cache_get_field_content
[23:16:59] [debug]  cache_get_field_content_float
[23:16:59]   Loaded 6 filterscripts.
MarcosPauloRibeiro is offline   Reply With Quote
Old 09/03/2020, 11:15 PM   #183
PT
Godfather
 
PT's Avatar
 
Join Date: Nov 2012
Location: Europe
Posts: 7,175
Reputation: 803
Default Re: Yet Another House System

Nice work!

Why dont think on launch a SQLite version?
PT is offline   Reply With Quote
Old 20/03/2020, 03:04 PM   #184
Hazon
Big Clucker
 
Hazon's Avatar
 
Join Date: May 2018
Location: Who cares ?
Posts: 171
Reputation: 29
Default Re: Yet Another House System

Would be the best house system if it has a vehicle buy options and spawning with cmd.
Hazon is offline   Reply With Quote
Old 20/03/2020, 03:24 PM   #185
SiaReyes
Gangsta
 
SiaReyes's Avatar
 
Join Date: Mar 2019
Location: Coordinates X,Y,Z
Posts: 621
Reputation: 57
Default Re: Yet Another House System

Quote:
Originally Posted by Hazon View Post
Would be the best house system if it has a vehicle buy options and spawning with cmd.
Isn't a big deal to make it?. But yeah, if it was added by the author of this script, this house system will be cool.
SiaReyes is offline   Reply With Quote
Old 23/03/2020, 08:59 PM   #186
Mentis8213787146874
Little Clucker
 
Join Date: May 2019
Posts: 6
Reputation: 0
Default Re: Yet Another House System

Loading filterscript 'house13.amx'...
Unable to load filterscript 'house13.amx'.
Mentis8213787146874 is offline   Reply With Quote
Old 23/03/2020, 09:32 PM   #187
Adamoneoone
Huge Clucker
 
Join Date: Sep 2014
Location: Discord: Adamoneoone#2911
Posts: 232
Reputation: 13
Default Re: Yet Another House System

Quote:
Originally Posted by Mentis8213787146874 View Post
Loading filterscript 'house13.amx'...
Unable to load filterscript 'house13.amx'.
All plugins loaded? Post the whole server log + mysql log (if mysql version)
Adamoneoone is offline   Reply With Quote
Old 23/03/2020, 09:57 PM   #188
Mentis8213787146874
Little Clucker
 
Join Date: May 2019
Posts: 6
Reputation: 0
Default Re: Yet Another House System

Quote:
Originally Posted by Adamoneoone View Post
All plugins loaded? Post the whole server log + mysql log (if mysql version)
Code:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team


Server Plugins
--------------
 Loading plugin: streamer


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

  Loaded.
 Loading plugin: mysql
 >> plugin.mysql: R41-4 successfully loaded.
  Loaded.
 Loaded 2 plugins.


Started server on port: 7777, with maxplayers: 69 lanmode is OFF.


Filterscripts
---------------
  Loading filterscript 'gl_actions.amx'...
  Loading filterscript 'gl_realtime.amx'...
  Loading filterscript 'gl_property.amx'...

-----------------------------------
Grand Larceny Property Filterscript
-----------------------------------

  Loading filterscript 'gl_mapicon.amx'...
  Loading filterscript 'ls_elevator.amx'...
  Loading filterscript 'attachments.amx'...
  Loading filterscript 'skinchanger.amx'...

--Admin Player Skin Changer Loaded

  Loading filterscript 'vspawner.amx'...

--Admin Vehicle Spawner Loaded

  Loading filterscript 'ls_mall.amx'...
  Loading filterscript 'ls_beachside.amx'...


  |---------------------------------------------------
  |--- LS BeachSide Filterscript
  |--  Script v1.03
  |--  19th April 2015
  |---------------------------------------------------
  |--  LS BeachSide Building Elevator created
  |---------------------------------------------------
  Loading filterscript 'VehicleSpawner.amx'...
  Loading filterscript 'house13.amx'...
  Unable to load filterscript 'house13.amx'.
  Loaded 11 filterscripts.

Loaded 3 vehicles from: vehicles/trains.txt
Loaded 3 vehicles from: vehicles/pilots.txt
Loaded 15 vehicles from: vehicles/lv_law.txt
Loaded 39 vehicles from: vehicles/lv_airport.txt
Loaded 255 vehicles from: vehicles/lv_gen.txt
Loaded 38 vehicles from: vehicles/sf_law.txt
Loaded 35 vehicles from: vehicles/sf_airport.txt
Loaded 353 vehicles from: vehicles/sf_gen.txt
Loaded 24 vehicles from: vehicles/ls_law.txt
Loaded 37 vehicles from: vehicles/ls_airport.txt
Loaded 98 vehicles from: vehicles/ls_gen_inner.txt
Loaded 389 vehicles from: vehicles/ls_gen_outer.txt
Loaded 71 vehicles from: vehicles/whetstone.txt
Loaded 168 vehicles from: vehicles/bone.txt
Loaded 61 vehicles from: vehicles/flint.txt
Loaded 96 vehicles from: vehicles/tierra.txt
Loaded 96 vehicles from: vehicles/red_county.txt
Total vehicles from files: 1781
Reading File: blank
Reading File: properties/houses.txt
Reading File: properties/businesses.txt
Reading File: properties/banks.txt
Reading File: properties/police.txt

---------------------------------------
Running Grand Larceny - by the SA-MP team

---------------------------------------

Number of vehicle models: 173
Mentis8213787146874 is offline   Reply With Quote
Old 24/03/2020, 04:29 AM   #189
SiaReyes
Gangsta
 
SiaReyes's Avatar
 
Join Date: Mar 2019
Location: Coordinates X,Y,Z
Posts: 621
Reputation: 57
Default Re: Yet Another House System

Script uses sscanf,streamer and MySQL r39-6
SiaReyes is offline   Reply With Quote
Old 24/03/2020, 08:30 AM   #190
Mentis8213787146874
Little Clucker
 
Join Date: May 2019
Posts: 6
Reputation: 0
Default Re: Yet Another House System

Quote:
Originally Posted by SiaReyes View Post
Script uses sscanf,streamer and MySQL r39-6
still the same
Mentis8213787146874 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[FilterScript] [FS] v1.6e || Simple House System || 1 line = 1 house Antironix Filterscripts 1306 28/04/2016 01:22 PM
Gagi's House System's House cords problem Wahaj Scripting Help 2 03/07/2014 03:15 PM
House system , save house create Cerealguy Scripting Help 1 27/10/2013 11:34 PM
House system only loading 1 house. ricardo178 Scripting Help 8 19/02/2012 06:37 AM
GF script & house system and house cars Sexserghy Help Archive 4 27/03/2011 10:47 PM


All times are GMT. The time now is 04:50 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.