redem-rp / redem_roleplay Goto Github PK

i wanted to suggest disabling the "use redemrp" in the db import since we don't all use this DB name (not hard to bypass this problem but well it cost nothing to try) :)

Title pretty much explains it self i guess.

i have 2 questions
1 were can i set players starter money
2 how to turn off the corts
will be nice to make like a small info readme for this kind of stuff
to make it a little easyer for new redm server devs :P

Good afternoon, tell me please, is it possible to support Microsoft SQL Server? The matter is that I cannot use MySql since. my country is not supported. Unfortunately .. There is such an error.

When you add money by command or simply any script that subtracts or adds an amount of money to the player it does not show it in the fixed money indicator

When the setjob command is set, the job in the database is not updated.

Good!

The money hud isn't updating. I added and removed some money. The database added or removed with success but the hud just don't update.
I noticed that hud updates only i rejoin server or with a server restart...
Maybe im doing something wrong?

Thank you!!!!

If we want to get the player's money and he does not have it then we will get this error

After setting e.g. $ 100 the problem disappears

Good!

The hud still isn't updating =(
And money is set it up on db as int. I suggest change ity to float, to accept cents too.

Thank you for this awesome job guys and girls!!!!

3 major bugs found:

1. Before characte creation screen i selected to spawn at Saint Denis. After selcted the spawn, the create character spawn screen shows up and i created my character.
   After finished, i spawned at Vallentine. Not saint denis.

2. Death is bugged now. I died, but the text saying i'm dead don't shows up, neighter the respawn time. I waited and didn't respawn. So i used the command /respawn.

3. Create character screen pops up again. [FIXED]
   After /respawn command, the screen to create character shows up again. Went toi the console and saw the error:
   [ERROR] [MySQL] [redemrp_skin] An error happens on MySQL for query "SELECT * FROM skins WHERE identifier='steam:XX0XXX101XXXXXX' AND charid=1;": ER_NO_SUCH_TABLE: Table 'redemrp.skins' doesn't exist

• You have to import again sql from redemrp_skin ^^

4. Character creation back button freezes the game/don't work and the Heads have diferent skin tones. The options to select skin tone and head types are on different screens. I suggest put one below the other, to allow us config our character easier. And the last one is hair. hair types are showing with different colors on the same option. Would be better one option to choose hair style and one to select the color of hair style. ;)

And one last suggestion (not a bug :D):
Create 2 tables: banks and banksAccounts. Banks to store the id of the banks e.x: ID (int, primary): 1 / Name(varchar): Strawberry's Bank / menuCoords(varchar): x, y, z to store the coords to appears the menu to players open bank. like: Press E to open your bank account / blipCoords(varchar): x,y,z (coords to shows up on map the blip of the Bank) :D
And banksAccounts table: id (int, primary) / idBank (int, id from banks table) / idCharacter (id from characters table, user's id) / money (float): money the player have stored on bank ^^
My idea is shows up to users: Press E to open bank account after player get on range of the coords of the bank (menuCoords) and i would like to make each bank individual. E.G. if he deposit on strawberry $100, he can pick it up on strawberry. If he deposits $10 at Saint Denis, he only can retrieve this $10 at saint denis. But he still have 100 on strawberry account and more 10 on saint denis.
And add one option on all mails (train stations) to the player can get their balance for all banks. Like as he had requested each bank your balance and received on mailbox ;) So he can see their balance with no problems :D
Press E to get your banks balance. And one nui just showing up:
Strawberry Bank: $100
Saint Dennis Bank: $10
...
Total from all Banks: $110

Greetings ..
How can I spawn NPC?
According to sv_entities.lua this should work. But it just doesn't work!

why notification not work now ?

Thank you very much for this work, its really incredible ^^

But i got some errors that can't start the RP:
`[ERROR] ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (us(node:8088) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
ing password: YES)(node:8088) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.

[ERROR] ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES)`

I've set it up the right root and root pass.

server.cfg:

set es_enableCustomData 1
set mysql_connection_string "server=127.0.0.1;uid=root;password=myROOTPASS;database=redemrp"

#These resources will start by default.
ensure mapmanager
ensure chat
ensure spawnmanager
ensure sessionmanager-rdr3
ensure fivem
ensure hardcap
ensure rconlog
#ensure scoreboard
ensure IPL
ensure esplugin_mysql
ensure mysql-async
ensure redem
ensure redem_roleplay
ensure redem_identity
ensure redemrp_respawn

resources folder:

• [redemrp]
  -- redem_roleplay
  -- redemrp_identity
  -- redemrp_respawn
• async
• esplugin_mysql
• mysql-async
• redem

I'm using MySQL v5.7.28
Tried connect on the same machine as mysql is running...

Any idea how fix it, please???

Thank you very much!!!

FOUND THE ERROR!
The mysqlserver was using port 3308 instead 3306. I just changed it back to port 3306 and it's all right!!! Ty!!!!

Looking here we can see that tick is an example icon you can use for these notifications. I wanted to know if there is a list out there containing all of the native icons we can use and if said list can be included in the cl_notification.lua documentation.

I would be happy to submit the PR myself I just don't have the list of icons 🙂

Is it normal not to have the map after you're dead?

edit : If I die by a horse I still have the map but if a pnc or player kills me I don't have it anymore!

I got the message that my db is set manually and if i want to do it automatically i've to remove database and restart server. so idid it. Droped out redemrp database, restarted server, but it didn't create a new one =(

[ERROR] ER_BAD_DB_ERROR: Unknown data(node:14728) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead. ba(node:14728) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead. se 'redemrp' [ERROR] ER_BAD_DB_ERROR: Unknown database 'redemrp' [ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "select schema_name from information_schema.schemata where schema_name = 'redemrp'": ER_BAD_DB_ERROR: Unknown database 'redemrp' [ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "DROP DATABASE IF EXISTS redemrp; CREATE DATABASE IF NOT EXISTS redemrp; USE redemrp`;

CREATE TABLE IF NOT EXISTS version (
id int(11) NOT NULL,
current varchar(3) COLLATE utf8mb4_bin DEFAULT 'no',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE IF NOT EXISTS characters (
identifier varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
characterid int(11) DEFAULT 0,
money int(11) DEFAULT 0,
gold int(11) DEFAULT 0,
xp int(11) DEFAULT 0,
level int(11) DEFAULT 0,
job varchar(50) COLLATE utf8mb4_bin DEFAULT 'unemployed',
firstname varchar(50) COLLATE utf8mb4_bin DEFAULT 'first',
lastname varchar(50) COLLATE utf8mb4_bin DEFAULT 'last',
jobgrade int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE IF NOT EXISTS users (
identifier varchar(50) COLLATE utf8mb4_bin NOT NULL,
license varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
name varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
money int(11) DEFAULT NULL,
bank int(11) DEFAULT NULL,
permission_level int(11) DEFAULT NULL,
group varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (identifier)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
": ER_BAD_DB_ERROR: Unknown database 'redemrp'
[ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "INSERT INTO version(id, current) VALUES(1, 'yes');": ER_BAD_DB_ERROR: Unknown database 'redemrp'
[RedEM:RP] Database: Successfully created database
[ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "USE redemrp;

ALTER TABLE characters
ADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (id);": ER_BAD_DB_ERROR: Unknown database 'redemrp'
[ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "UPDATE version SET current='no' WHERE id=1": ER_BAD_DB_ERROR: Unknown database 'redemrp'
[ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "INSERT INTO version(id, current) VALUES(2, 'yes');": ER_BAD_DB_ERROR: Unknown database 'redemrp'
[RedEM:RP] Database: Successfully updated database for version: 2
[ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "SELECT * FROM version WHERE current='yes'": ER_BAD_DB_ERROR: Unknown database 'redemrp'
SCRIPT ERROR: @redem_roleplay/server/sv_db.lua:25: attempt to index a nil value (local '_version')`

i have set it up string connection to database only on server.cgf.
To work the script, have i set it up on another file, please?

because it isn't... =(

thank you!!!!

SCRIPT ERROR: @redem_roleplay/server/sv_db.lua:67: attempt to index a nil value (field '?')

ref (@redem_roleplay/server/sv_db.lua:67)
(@mysql-async/mysql-async.js:14898)

Been getting this problem lately. Database is up to date and connections work good.

What could be the problem?

Hi,

Is it possible to add a .rockspec file to add luarocks download and perhaps the download via https://luarocks.org/ ?

Before hud was colourful but now that's red.

no have giveitem and additem command

https://cdn.discordapp.com/attachments/534848716629213184/767822030912618498/Cattura.PNG

I have this problem when i sell i buy items with cents

I just change config like this:
Config.Coords = GetConvarInt("redemrp_showcoords", 0) -- SHOW COORDS
but that always show coords.

Any help me? :C

Hello, it is absolutely impossible for me to put myself as admin on the server, the permissions table remains empty and in characters no place is provided for the server to find my admin group, how should I go about it?
Sorry to open a post for this but your discord links no longer work