SA-MP Forums Archive
[GameMode] Base Roleplay Edition ( Best LS-RP replica ) - 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: Gamemode Scripts (https://sampforum.blast.hk/forumdisplay.php?fid=71)
+--- Thread: [GameMode] Base Roleplay Edition ( Best LS-RP replica ) (/showthread.php?tid=646191)

Pages: 1 2 3 4 5

Re: Base Roleplay Edition ( Best LS-RP replica ) - Jumberi - 31.12.2017

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


Re: Base Roleplay Edition ( Best LS-RP replica ) - N0FeaR - 31.12.2017

Good job keep it up!

Re: Base Roleplay Edition ( Best LS-RP replica ) - 0x88 - 02.01.2018

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

Re: Base Roleplay Edition ( Best LS-RP replica ) - Klayton - 02.01.2018

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

http://prntscr.com/huyk19

Re: Base Roleplay Edition ( Best LS-RP replica ) - 0x88 - 02.01.2018

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

Re: Base Roleplay Edition ( Best LS-RP replica ) - KietXoi - 02.01.2018

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));

Re: Base Roleplay Edition ( Best LS-RP replica ) - Gangstakilla - 02.01.2018

Good work. I repped.

Re: Base Roleplay Edition ( Best LS-RP replica ) - Jumberi - 02.01.2018

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?

Re: Base Roleplay Edition ( Best LS-RP replica ) - DavidGravelli - 03.01.2018

where is the UCP?

Re: Base Roleplay Edition ( Best LS-RP replica ) - REmixs1 - 31.01.2018

I have black window when i respawned at the LSI someone know how to delete it?

Re: Base Roleplay Edition ( Best LS-RP replica ) - Gong - 02.02.2018

Any solution for the registering thing or do I need to do something in PHPMyAdmin or MySQL because when I enter my password it just stays at some kind of beach or something like that.

Re: Base Roleplay Edition ( Best LS-RP replica ) - lostmode - 03.02.2018

Anyone can fix the sql problem and share the fixed sql ?

Re: Base Roleplay Edition ( Best LS-RP replica ) - homelessdrop - 05.02.2018

Hello @0x88 .
I have two ask for you. I did everything, everything works, but. If I make a new one character, sql create the line in "characters" but not in "masters" too, but everything is loaded good (admin level,skin,pos etc.). And the next is, if a make the business, set entrance/interior, and walk to "entrance" pickup, in the moment gta crashed.. Maybe idea?
(sry for a bad english)

Re: Base Roleplay Edition ( Best LS-RP replica ) - NLDBrian - 06.02.2018

For some reasons players keep spawning at the airport, instead of their last known position? I checked the on player connect, login and spawn, but no clue whats wrong...

Re: Base Roleplay Edition ( Best LS-RP replica ) - penaut - 06.02.2018

Fixed the registration errors in the databasehttp://www70.zippyshare.com/v/GXZMNbb5/file.html

Re: Base Roleplay Edition ( Best LS-RP replica ) - P00kie - 07.02.2018

looks good first i see this script

Re: Base Roleplay Edition ( Best LS-RP replica ) - NailOrduna - 09.02.2018

Explication in English:
Help me, I have a problem with the database, the localhost receives it well, I have no problems in importing anything, the problem is that it does not connect me to the database, here I bring my .logs of the console and of MySQL

Explicaciуn en Espaсol:
Ayudenme, tengo un problema con la base de datos, el localhost me la recibe bien, no tengo problemas en importarla nada, el problema estб en que no me conecta a la base de datos, aquн les traigo mis .logs de la consola y de MySQL.

Log de consola / Console log:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[00:12:34] filterscripts = "" (string)
[00:12:34]
[00:12:34] Server Plugins
[00:12:34] --------------
[00:12:34] Loading plugin: mysql.dll
[00:12:35] >> plugin.mysql: R39-6 successfully loaded.
[00:12:35] Loaded.
[00:12:35] Loading plugin: pawncmd.dll
[00:12:35] Pawn.CMD plugin v3.1.4 by urShadow loaded
[00:12:35] Loaded.
[00:12:35] Loading plugin: sscanf.dll
[00:12:35]

[00:12:35] ===============================

[00:12:35] sscanf plugin loaded.

[00:12:35] Version: 2.8.2

[00:12:35] © 2012 Alex "Y_Less" Cole

[00:12:35] ===============================

[00:12:35] Loaded.
[00:12:35] Loading plugin: streamer.dll
[00:12:35]

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

[00:12:35] Loaded.
[00:12:35] Loaded 4 plugins.

[00:12:35]
[00:12:35] Filterscripts
[00:12:35] ---------------
[00:12:35] Loaded 0 filterscripts.

[00:12:35] [ADM] Info: Load 3DTryg v4.5.2 for SA:MP 0.3.7 by Abyss Morgan
[00:12:35] [DATABASE]: Connection failed to 'ls-rp'...
[00:12:35] Number of vehicle models: 1
[00:12:36]
[00:12:36] [ADM] Info: Please update your 3DTryg include to v4.6.1 from here:
[00:12:36] http://8.ct8.pl/d/3DTryg.inc
[00:12:36]


Log de MySQL / Log MySQL.

[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)

Re: Base Roleplay Edition ( Best LS-RP replica ) - penaut - 11.02.2018

You need to edit the mysql connection in the mod, read some about mysql r39 first of all

Re: Base Roleplay Edition ( Best LS-RP replica ) - bigtigerbeee - 16.02.2018

Oh, nice. I'm trying to develop script like LS-RP too.

Vehicle System:


Phone System:


Car Moding Shop:


And more...

I waiting for your drug system, I can't access it on LS-RP

Turf
http://ls-rp.in.th/turfmap/

Re: Base Roleplay Edition ( Best LS-RP replica ) - Astralis - 17.02.2018

Quote:
Originally Posted by NailOrduna
View Post
Explication in English:
Help me, I have a problem with the database, the localhost receives it well, I have no problems in importing anything, the problem is that it does not connect me to the database, here I bring my .logs of the console and of MySQL

Explicaciуn en Espaсol:
Ayudenme, tengo un problema con la base de datos, el localhost me la recibe bien, no tengo problemas en importarla nada, el problema estб en que no me conecta a la base de datos, aquн les traigo mis .logs de la consola y de MySQL.

Log de consola / Console log:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[00:12:34] filterscripts = "" (string)
[00:12:34]
[00:12:34] Server Plugins
[00:12:34] --------------
[00:12:34] Loading plugin: mysql.dll
[00:12:35] >> plugin.mysql: R39-6 successfully loaded.
[00:12:35] Loaded.
[00:12:35] Loading plugin: pawncmd.dll
[00:12:35] Pawn.CMD plugin v3.1.4 by urShadow loaded
[00:12:35] Loaded.
[00:12:35] Loading plugin: sscanf.dll
[00:12:35]

[00:12:35] ===============================

[00:12:35] sscanf plugin loaded.

[00:12:35] Version: 2.8.2

[00:12:35] © 2012 Alex "Y_Less" Cole

[00:12:35] ===============================

[00:12:35] Loaded.
[00:12:35] Loading plugin: streamer.dll
[00:12:35]

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

[00:12:35] Loaded.
[00:12:35] Loaded 4 plugins.

[00:12:35]
[00:12:35] Filterscripts
[00:12:35] ---------------
[00:12:35] Loaded 0 filterscripts.

[00:12:35] [ADM] Info: Load 3DTryg v4.5.2 for SA:MP 0.3.7 by Abyss Morgan
[00:12:35] [DATABASE]: Connection failed to 'ls-rp'...
[00:12:35] Number of vehicle models: 1
[00:12:36]
[00:12:36] [ADM] Info: Please update your 3DTryg include to v4.6.1 from here:
[00:12:36] http://8.ct8.pl/d/3DTryg.inc
[00:12:36]


Log de MySQL / Log MySQL.

[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
[00:12:35 02/09/18] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES)
Make sure the database details are correct, you must have one.