SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 31/12/2017, 08:35 AM   #41
Jumberi
Big Clucker
 
Join Date: May 2014
Posts: 73
Reputation: 0
Default Re: Base Roleplay Edition ( Best LS-RP replica )

can you give us sql which is filled with the missing columns?

I tried by myself , and when i checked char in db there was nothing changed Age="Invalid" Gender="Invalid" uhm and also this sql errors popped up


Code:
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("SetupInfo") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Gender") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("RentAt") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype

Last edited by Jumberi; 31/12/2017 at 09:08 AM.
Jumberi is offline   Reply With Quote
Old 31/12/2017, 09:34 PM   #42
N0FeaR
High-roller
 
N0FeaR's Avatar
 
Join Date: Nov 2011
Location: Los Santos, Idlewood
Posts: 2,349
Reputation: 152
Default Re: Base Roleplay Edition ( Best LS-RP replica )

Good job keep it up!
__________________
Check out this sh*t

N0FeaR is offline   Reply With Quote
Old 02/01/2018, 12:43 AM   #43
0x88
Big Clucker
 
0x88's Avatar
 
Join Date: Sep 2017
Posts: 62
Reputation: 18
Default Re: Base Roleplay Edition ( Best LS-RP replica )

Quote:
Originally Posted by Jumberi View Post
can you give us sql which is filled with the missing columns?

I tried by myself , and when i checked char in db there was nothing changed Age="Invalid" Gender="Invalid" uhm and also this sql errors popped up


Code:
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("SetupInfo") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Gender") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("RentAt") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
SetupInfo, Gender, RentAt are missing, add them in the 'characters' table it should be fixed
__________________
#offset
0x88 is offline   Reply With Quote
Old 02/01/2018, 12:46 AM   #44
Klayton
Huge Clucker
 
Klayton's Avatar
 
Join Date: Mar 2012
Posts: 345
Reputation: 8
Default Re: Base Roleplay Edition ( Best LS-RP replica )

Can you give me the syntax of this value for the database ?

http://prntscr.com/huyk19
Klayton is offline   Reply With Quote
Old 02/01/2018, 03:02 AM   #45
0x88
Big Clucker
 
0x88's Avatar
 
Join Date: Sep 2017
Posts: 62
Reputation: 18
Default Re: Base Roleplay Edition ( Best LS-RP replica )

Quote:
Originally Posted by Klayton View Post
Can you give me the syntax of this value for the database ?

http://prntscr.com/huyk19
They are smallint type and should be 6 length
__________________
#offset
0x88 is offline   Reply With Quote
Old 02/01/2018, 10:48 AM   #46
KietXoi
Little Clucker
 
Join Date: Dec 2015
Posts: 12
Reputation: 1
Default Re: Base Roleplay Edition ( Best LS-RP replica )

I'm having a problem with your code, it can not be read when I use that statement

mysql_format(this, query, sizeof(query), "INSERT INTO businesses (BusinessType, BusinessName) VALUES(%i, '%s')", type_id, ReturnBusinessName(type_id));
mysql_tquery(this, query, "Query_InsertBusiness", "iii", playerid, idx, type_id, ReturnBusinessName(type_id));
KietXoi is offline   Reply With Quote
Old 02/01/2018, 12:30 PM   #47
Gangstakilla
Little Clucker
 
Join Date: Mar 2014
Posts: 8
Reputation: 0
Default Re: Base Roleplay Edition ( Best LS-RP replica )

Good work. I repped.
Gangstakilla is offline   Reply With Quote
Old 02/01/2018, 04:38 PM   #48
Jumberi
Big Clucker
 
Join Date: May 2014
Posts: 73
Reputation: 0
Default Re: Base Roleplay Edition ( Best LS-RP replica )

Quote:
Originally Posted by KietXoi View Post
I'm having a problem with your code, it can not be read when I use that statement

mysql_format(this, query, sizeof(query), "INSERT INTO businesses (BusinessType, BusinessName) VALUES(%i, '%s')", type_id, ReturnBusinessName(type_id));
mysql_tquery(this, query, "Query_InsertBusiness", "iii", playerid, idx, type_id, ReturnBusinessName(type_id));
can you give me a database? if you updated characters table?
Jumberi is offline   Reply With Quote
Old 03/01/2018, 12:10 PM   #49
DavidGravelli
Huge Clucker
 
DavidGravelli's Avatar
 
Join Date: May 2014
Posts: 225
Reputation: 36
Default Re: Base Roleplay Edition ( Best LS-RP replica )

where is the UCP?
DavidGravelli is offline   Reply With Quote
Old 31/01/2018, 11:02 AM   #50
REmixs1
Little Clucker
 
Join Date: Jan 2018
Posts: 2
Reputation: 0
Default Re: Base Roleplay Edition ( Best LS-RP replica )

I have black window when i respawned at the LSI someone know how to delete it?
REmixs1 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
base roleplay edition 0x88 Screenshots and Videos 15 17/02/2018 06:52 AM
[Map] Area 51 TDM Base [Gold Edition] [Scalix] Scalingero Maps 2 01/01/2014 03:46 PM
[GameMode] Los Angeles RolePlay fixed edition TheArcher Gamemode Scripts 50 05/02/2013 11:26 PM
[GameMode] BlodZ RolePlay New Edition DnL Gamemode Scripts 51 15/09/2012 05:47 AM


All times are GMT. The time now is 07:52 PM.


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