[FilterScript] [FS] C-House - Load, and Save houses through MySQL. Quick and Easy!

[FilterScript] [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - 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: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! (/showthread.php?tid=138114)

Pages: 1 2

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - swordx - 01.04.2010

Cool script man..
Nice work

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Carlton - 01.04.2010

Quote:

Originally Posted by Smokey619

ok what do you mean with the change the DB_Host things and the database i dont get what your saying

Your database information.

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - tony_montana1333 - 01.04.2010

I a having a problem trying to set it so players ca only buy 2 housesmax this is my cde below andthisis the line the errors are on

format(globalquery, sizeof(globalquery) "SELECT * FROM "DB_TABLE_NAME" WHERE Owner = '%s'", name); line 346

Код:

if(!strcmp(cmdtext, "/buyhouse", true)) {
	  new pos = IsPlayerInRangeOfHouse(playerid);
    new name[MAX_PLAYER_NAME];
		if(!strcmp(HouseData[pos][Owner], "Empty House", true)) return GameTextForPlayer(playerid, "~g~OWNED", 3000, 5);
	  if(GetPlayerMoney(playerid) >= HouseData[pos][hPrice]) {
	    GivePlayerMoney(playerid, -HouseData[pos][hPrice]);
	    GetPlayerName(playerid, name, MAX_PLAYER_NAME);
	    strmid(HouseData[pos][Owner], name, 0, MAX_PLAYER_NAME, 255);
			SaveHouse(pos);
      GetPlayerName(playerid, name, MAX_PLAYER_NAME);
			format(globalquery, sizeof(globalquery) "SELECT * FROM "DB_TABLE_NAME" WHERE Owner = '%s'", name);
			mysql_query(globalquery);
			if(mysql_num_rows() >= 2) return GameTextForPlayer(playerid, "You own too many houses!", 5000, 3);
			GameTextForPlayer(playerid, "~g~Welcome to your new house.~n~/~r~/housecommands", 3000, 5);

		}
	  else return GameTextForPlayer(playerid, "~g~YOU CANNOT AFFORD THIS HOUSE.", 3000, 5);
	  return 1;
	}

C:\Users\robmob\Desktop\chouse.pwn(346) : error 001: expected token: ",", but found "-string-"
C:\Users\robmob\Desktop\chouse.pwn(346) : warning 215: expression has no effect
C:\Users\robmob\Desktop\chouse.pwn(346) : warning 215: expression has no effect
C:\Users\robmob\Desktop\chouse.pwn(346) : error 001: expected token: ";", but found ")"
C:\Users\robmob\Desktop\chouse.pwn(346) : error 029: invalid expression, assumed zero
C:\Users\robmob\Desktop\chouse.pwn(346) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase

4 Errors.

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Carlton - 01.04.2010

Change

pawn Код:

format(globalquery, sizeof(globalquery) "SELECT * FROM "DB_TABLE_NAME" WHERE Owner = '%s'", name);
            mysql_query(globalquery);]

To:

pawn Код:

format(globalquery, sizeof(globalquery), "SELECT * FROM "DB_TABLE_NAME" WHERE Owner = '%s'", name);
            mysql_query(globalquery);

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - tony_montana1333 - 01.04.2010

thanks worked

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Smokey619 - 02.04.2010

i dont know why this does not work for me i have what i need their is no errors or anything but when i load it and i go to my server i enter /housecommands it return me with a that this is not a command i even login as admin and it tells me the same thing

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - billiout - 27.04.2010

C:\Users\Billys\Desktop\НЭпт цЬкелпт (

\filterscripts\chouse.pwn(67) : error 017: undefined symbol "IsPlayerInRangeOfPoint"
C:\Users\Billys\Desktop\НЭпт цЬкелпт (

\filterscripts\chouse.pwn(123) : warning 202: number of arguments does not match definition
C:\Users\Billys\Desktop\НЭпт цЬкелпт (

\filterscripts\chouse.pwn(202) : error 017: undefined symbol "IsPlayerInRangeOfPoint"
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase

2 Errors.

How to fix that?

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Carlton - 27.04.2010

Quote:

Originally Posted by billiout

C:\Users\Billys\Desktop\НЭпт цЬкелпт (

\filterscripts\chouse.pwn(67) : error 017: undefined symbol "IsPlayerInRangeOfPoint"
C:\Users\Billys\Desktop\НЭпт цЬкелпт (

\filterscripts\chouse.pwn(123) : warning 202: number of arguments does not match definition
C:\Users\Billys\Desktop\НЭпт цЬкелпт (

\filterscripts\chouse.pwn(202) : error 017: undefined symbol "IsPlayerInRangeOfPoint"
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase

2 Errors.

How to fix that?

IsPlayerInRangeOfPoint is a SA-MP function. Did you do something to the script?

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - billiout - 27.04.2010

no anything.

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Carlton - 27.04.2010

Quote:

Originally Posted by billiout

no anything.

You just downloaded the script and compiled it, are you sure?

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Y.T - 29.07.2010

Any idea how I can change this so it loads the houses through dini, I've tried reading about MySQL, I've got it installed but I just can't get my head around it.

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Mujib - 29.07.2010

Quote:

Originally Posted by Y.T

Any idea how I can change this so it loads the houses through dini, I've tried reading about MySQL, I've got it installed but I just can't get my head around it.

Theres no point of doing that, I can help you with MySQL if you want? PM me!

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Y.T - 29.07.2010

That would be nice, yeah, I'll pm you now.

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Kar - 31.07.2010

is there a stricken kids one to this?

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Carlton - 31.07.2010

That can be easily changed if you know the functions.

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Toni - 06.08.2010

Quote:

Originally Posted by Carlton

That can be easily changed if you know the functions.

Sorry for the bump, but I really would like it to be Strickenkid's please. I've already tried to change some functions to stricken's, but after trying, my server ended up crashing.

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - [MKD]Max - 07.10.2010

nice its work i have maked house and done

AW: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Kotomi - 20.11.2010

a question: wheres that sample house you wrote ?

Example
- I've given you a example in the script.
pawn Code:

AddServerHouse(1, 1984.19,-1995.43,16.3322, 9, 315.856170,1024.496459,1949.797363, 9000);

PS:

can somebody make me an example house with these coordinates:

AddPlayerClass(265,2014.4633,948.0726,10.8203,269. 7458,0,0,0,0,0,0); // haus2

i really dont know how to do that

thanks a lot

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Pajashuvve - 01.01.2012

C:\Users\Pontus\Desktop\Sa-Mp-Server\filterscripts\chouse.pwn(52) : error 001: expected token: ";", but found "enum"
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase

1 Error.

How can i fix this? Help please

Re: [FS] C-House - Load, and Save houses through MySQL. Quick and Easy! - Ivica_Razor - 12.02.2013

download link?