SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 31/12/2017, 09: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 10:08 AM.
Jumberi is offline   Reply With Quote
Old 31/12/2017, 10:34 PM   #42
N0FeaR
High-roller
 
N0FeaR's Avatar
 
Join Date: Nov 2011
Location: Los Santos, Idlewood
Posts: 2,259
Reputation: 143
Default Re: Base Roleplay Edition ( Best LS-RP replica )

Good job keep it up!
__________________
Currently working in:
None
Things I done:
[GameMode]Prototype Roleplay
[GameMode]Reality Prison Roleplay
[GameMode]Los Santos GangWar


Quote:
Originally Posted by ThaiLuan View Post
C:\Users\Administrator\Downloads\Viet-RP\gamemodes\3mien.pwn(112016) : fatal error 101: cannot write to file: "disk full"

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


1 Error.

Help me! How to fix error
N0FeaR is offline   Reply With Quote
Old 02/01/2018, 01:43 AM   #43
0x88
Big Clucker
 
0x88's Avatar
 
Join Date: Sep 2017
Posts: 60
Reputation: 13
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, 01:46 AM   #44
Klayton
Huge Clucker
 
Klayton's Avatar
 
Join Date: Mar 2012
Posts: 342
Reputation: 6
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, 04:02 AM   #45
0x88
Big Clucker
 
0x88's Avatar
 
Join Date: Sep 2017
Posts: 60
Reputation: 13
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, 11:48 AM   #46
KietXoi
Little Clucker
 
Join Date: Dec 2015
Posts: 10
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, 01: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, 05: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, 01:10 PM   #49
DavidGravelli
Huge Clucker
 
DavidGravelli's Avatar
 
Join Date: May 2014
Posts: 227
Reputation: 36
Default Re: Base Roleplay Edition ( Best LS-RP replica )

where is the UCP?
DavidGravelli 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 13 17/01/2018 02:09 PM
[Map] Area 51 TDM Base [Gold Edition] [Scalix] Scalingero Maps 2 01/01/2014 04:46 PM
[GameMode] Los Angeles RolePlay fixed edition TheArcher Gamemode Scripts 50 06/02/2013 12:26 AM
[GameMode] BlodZ RolePlay New Edition DnL Gamemode Scripts 51 15/09/2012 06:47 AM


All times are GMT. The time now is 01:09 PM.


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