DarkRP 2.4.X

[BoyV]

How can i set up my mysql to this darkrp?
Because i think a mysql will automatically fix some bugs.

[Drakehawke]

[QUOTE=441boy441;22875627]How can i set up my mysql to this darkrp?
Because i think a mysql will automatically fix some bugs.[/QUOTE]

I've spent the past 6 hours trying to get a MySQL database working V_V

It's not the DarkRP bit, it's the setting up the database that I can't seem to get right :'(

I always get:
L 06/25/2010 - 11:27:01: Lua Error: gamemodes\darkrp\gamemode\data.lua:70: Connection failed! [Database:152356A8]
gamemodes\darkrp\gamemode\data.lua:70: Connection failed! [Database:152356A8]

[tgp1994]

[QUOTE=Drakehawke;22876785]I've spent the past 6 hours trying to get a MySQL database working V_V

It's not the DarkRP bit, it's the setting up the database that I can't seem to get right :'(

I always get:
L 06/25/2010 - 11:27:01: Lua Error: gamemodes\darkrp\gamemode\data.lua:70: Connection failed! [Database:152356A8]
gamemodes\darkrp\gamemode\data.lua:70: Connection failed! [Database:152356A8][/QUOTE]

You sure the port is accessible, and that the general server is accessible?

[Drakehawke]

[QUOTE=tgp1994;22877135]You sure the port is accessible, and that the general server is accessible?[/QUOTE]

It should be, but it's not >.<

[editline]07:00PM[/editline]

I give up, nevermind

[Juppie902]

Mmm sry for the lack of knowledge but what is MySQL?
Some database for the DarkRP Server you can make that saves all the stuff like money?

[Trivkz]

[QUOTE=Juppie902;22878994]Mmm sry for the lack of knowledge but what is MySQL?
Some database for the DarkRP Server you can make that saves all the stuff like money?[/QUOTE]

[url]http://lmgtfy.com/?q=What+is+MySql[/url]

[erie1555]

Anyone know how to convert your current darkrp database to mysql?

[FPtje]

[QUOTE=erie1555;22880678]Anyone know how to convert your current darkrp database to mysql?[/QUOTE]

Here's something I found on google:
[quote]Download sqlite3.exe on [url]http://www.sqlite.org[/url]
Export the SQLite database with sqlite3.exe and command parameter ".dump" (Nate, ".export" doesn't exist!), an example :
sqlite3 mySQLiteDataBase .dump .quit >> myDumpSQLite
Adapt the dump to get it compatible for MySQL
- Replace " (double-quotes) with ` (grave accent)
- Remove "BEGIN TRANSACTION;" "COMMIT;", and lines related to "sqlite_sequence"
- Replace "autoincrement" with "auto_increment"
The dump is ready to get imported in a MySQL server[/quote]
[url]http://sqlite.phxsoftware.com/forums/t/941.aspx[/url]

Here's a program to do it, also found on google, I haven't tried it myself
[url]http://www.easyfrom.net/download/[/url]

[editline]10:55AM[/editline]

[QUOTE=441boy441;22875627]How can i set up my mysql to this darkrp?
Because i think a mysql will automatically fix some bugs.[/QUOTE]
Take a look in the file DarkRP/gamemode/_MySQL.lua

There's a manual in there.

[Aljam]

Recently my darkRP just generally screwed up. I want to know how to delete absolutely everything DarkRP left behind because if I use svn update or delete the folder and redownload. It does nothing and darkRP is still messed up. Basically f4 is inaccessible names dont appear in tab menu, and doors are not buyable. Also the salary job and money have $0 or nothing at all. What is wrong with my dark RP?

[FPtje]

see if you have CustomTeams.txt or CustomShipments.txt in garrysmod/data/ on the server
if you have them, remove them.

Remove the DarkRP folder from gamemodes.

Remake the folder (empty)
Use SVN checkout.

[Dino Penis]

[QUOTE=Juppie902;22870112]Help! my DarkRP SVN doesnt saves money for anybody, yesterday i opened my darkrp server with modified jobs and shipments, today i woke up, server was offline (i wonder how, i mean i left my computer on switch user during the night) so i opened it, went there to check some lua bugs i needed to fix and voila! all my money is about 900$ and i used rp_setmoney to give money to me and my friends...
and something else: in rp_downtown_v2 my server doesnt saves doors like if i put PD doors belong to group Cops, and if server restarts i will have to set group door owner again.
p.s. i dont work for money on the server, im the owner, duh xD[/QUOTE]

Database failed probably.

[erie1555]

Could you go more in-depth on how to convert the databases?

[Lua Noob]

I just downloaded the SVN. The only thing that seems to be wrong with it is that when i try to add a custom shipment in add entities, and I set it so only TEAM_DEALER can buy it but it seems that everyone can. I'm not sure if its just my code but here it is just incase.

[LUA]
//AddCustomShipment("HL2pistol", "models/weapons/W_pistol.mdl", "weapon_pistol", 500, 10, false, 200, false, {TEAM_GUN, TEAM_MEDIC})

--EXAMPLE OF AN ENTITY(in this case a medkit)
--AddCustomShipment("bball", "models/Combine_Helicopter/helicopter_bomb01.mdl", "sent_ball", 100, 10, false, 10, false, {TEAM_GUN}, "models/props_c17/oildrum001_explosive.mdl")
--EXAMPLE OF A BOUNCY BALL: NOTE THAT YOU HAVE TO PRESS E REALLY QUICKLY ON THE BOMB OR YOU'LL EAT THE BALL LOL
--AddCustomShipment("bball", "models/Combine_Helicopter/helicopter_bomb01.mdl", "sent_ball", 100, 10, true, 10, true)
-- ADD CUSTOM SHIPMENTS HERE(next line):

AddCustomShipment("Lockpick","models/weapons/w_crowbar.mdl", "lockpick", 500, 1, true, 500, false, {TEAM_DEALER})

[/LUA]

If someone could help me out that would be great.

[jonas123]

I have made a Drugdealer job for my DarkRP server and i set the drugs to team_drugz but everyone can buy drugs :S

and do anyone know where to put adv duplicator (svn)?

[Drakehawke]

[QUOTE=jonas123;22918415]I have made a Drugdealer job for my DarkRP server and i set the drugs to team_drugz but everyone can buy drugs :S

and do anyone know where to put adv duplicator (svn)?[/QUOTE]

Addons

[editline]01:05PM[/editline]

[QUOTE=Lua Noob;22909918]I just downloaded the SVN. The only thing that seems to be wrong with it is that when i try to add a custom shipment in add entities, and I set it so only TEAM_DEALER can buy it but it seems that everyone can. I'm not sure if its just my code but here it is just incase.

[LUA]
//AddCustomShipment("HL2pistol", "models/weapons/W_pistol.mdl", "weapon_pistol", 500, 10, false, 200, false, {TEAM_GUN, TEAM_MEDIC})

--EXAMPLE OF AN ENTITY(in this case a medkit)
--AddCustomShipment("bball", "models/Combine_Helicopter/helicopter_bomb01.mdl", "sent_ball", 100, 10, false, 10, false, {TEAM_GUN}, "models/props_c17/oildrum001_explosive.mdl")
--EXAMPLE OF A BOUNCY BALL: NOTE THAT YOU HAVE TO PRESS E REALLY QUICKLY ON THE BOMB OR YOU'LL EAT THE BALL LOL
--AddCustomShipment("bball", "models/Combine_Helicopter/helicopter_bomb01.mdl", "sent_ball", 100, 10, true, 10, true)
-- ADD CUSTOM SHIPMENTS HERE(next line):

AddCustomShipment("Lockpick","models/weapons/w_crowbar.mdl", "lockpick", 500, 1, true, 500, false, {TEAM_DEALER})

[/LUA]

If someone could help me out that would be great.[/QUOTE]

AddCustomShipment("Lockpick","models/weapons/w_crowbar.mdl", "lockpick", 500, 1, [b]true[/b], 500, false, {TEAM_DEALER})

The 'true' I highlighted in bold means it's sold separately, to all players.
Set it to false and it should work.

[editline]01:06PM[/editline]

[QUOTE=jonas123;22918415]I have made a Drugdealer job for my DarkRP server and i set the drugs to team_drugz but everyone can buy drugs :S

and do anyone know where to put adv duplicator (svn)?[/QUOTE]

Same thing as I said above, double check your shipments and make sure that first true/false is set to false.

[Lua Noob]

Ah, Thanks mate.

[deaded38]

Can anyone tell me why Im playing the base gamemode on my server? It says that it couldnt load file cl_init.lua. Ive tried reinstalling the server and darkrp. Can anyone help?

[Drakehawke]

[QUOTE=deaded38;22939627]Can anyone tell me why Im playing the base gamemode on my server? It says that it couldnt load file cl_init.lua. Ive tried reinstalling the server and darkrp. Can anyone help?[/QUOTE]

Have you edited DarkRP? If so paste your edits here (custom jobs/shipments, etc).

Otherwise check that cl_init.lua definately exists on the server (garrysmod/gamemodes/DarkRP/gamemode/cl_init.lua).

Also if you use FastDL, try disabling it and see if it works then. (Thanks DeaDeye =P)

[deaded38]

[QUOTE=Drakehawke;22945583]Have you edited DarkRP? If so paste your edits here (custom jobs/shipments, etc).

Otherwise check that cl_init.lua definately exists on the server (garrysmod/gamemodes/DarkRP/gamemode/cl_init.lua).

Also if you use FastDL, try disabling it and see if it works then. (Thanks DeaDeye =P)[/QUOTE]

I will try disabling FastDL. Posting results in a few.

Results: Yeah, it works. Only problem is now no one will be able to download my map... But thanks.

[erie1555]

Saving privileges for MYSQL is broken, I believe

[Drakehawke]

[QUOTE=deaded38;22945704]I will try disabling FastDL. Posting results in a few.

Results: Yeah, it works. Only problem is now no one will be able to download my map... But thanks.[/QUOTE]

You can make DarkRP work with it, you've just gotta update the FastDL cache so it has the right files to send to the client.

[Juppie902]

Can't use F4 menu anymore, this is after SVN Update today (altough i didnt see it updated the lua file)
SRCDS console error: Timer Error: gamemodes\darkrp\gamemode\sh_commands.lua:413: attempt to concatena
te field 'command' (a table value)
Connection to Steam servers successful.

[Juppie902]

bump...

[FPtje]

lol.
I don't get that problem.

[deadeye536]

[QUOTE=Juppie902;22947924]Can't use F4 menu anymore, this is after SVN Update today (altough i didnt see it updated the lua file)
SRCDS console error: Timer Error: gamemodes\darkrp\gamemode\sh_commands.lua:413: attempt to concatena
te field 'command' (a table value)
Connection to Steam servers successful.[/QUOTE]

Looks like you might have an extra comma somewhere. By the looks of it, the extra comma is pushing the talbe containing weapons to where the command field is supposed to be.

[Music]

Some of my problems:

Custom jobs wont show colors on scoreboard
Weapons wont give the players them I have disabled gun license.
Double jump I want it disabled so I can run and jump.

I am having problems with my jobs. It wont show the color of them on the scoreboard and it will not give anyone weapons for there jobs how do I fix it?

Job Codes
[lua]

TEAM_ADMIN = AddExtraTeam("Onduty Admin", Color(255,0,0,0), "models/player/alyx.mdl", [[A server admin thats on-duty!]], {"arrest_stick", "unarrest_stick", "pocket", "door_ram", "keys"}, "admin", 10, 100, 1, false)
TEAM_SWAT = AddExtraTeam("S.W.A.T", Color(0,0,255,0), "models/player/swat.mdl", [[Special Weapons and Tatics]], {"arrest_stick", "unarrest_stick", "pocket", "door_ram", "weapon_deagle", "weapon_pumpshotgun2", "keys"}, "swat", 5, 60, 0, true)
TEAM_NINJA = AddExtraTeam("Ninja", Color(255,0,255,0), "models/player/arctic.mdl", [[Fly around the city and try to steal some stuff!]], {"weapon_spiderman", "keypad_cracker", "lockpick", "keys", "pocket"}, "ninja", 3, 70, 0, true)
TEAM_HITMAN = AddExtraTeam("Hitman", Color(0,0,51,0), "models/player/suits/male_07.mdl", [[Get paid to kill people your prices must only be over $50.00]], {"lockpick", "weapon_deagle", "keypad_cracker", "keys", "pocket"}, "hitman", 3, 70, 0, true)
TEAM_SECRET = AddExtraTeam("Secret Service", Color(51,51,0,0), "models/player/barney.mdl", [[Get paid to protect the mayor!]], {"weapon_deagle", "keys", "pocket"}, "secret", 4, 70, 0, true)
TEAM_HACKER = AddExtraTeam("Hacker", Color(0,102,0,0), "models/player/combine_super_soldier.mdl", [[Get paid to help the police to get into places with keypads!]], {"keypad_cracker", "weapon_deagle", "weaponchecker", "keys", "pocket"}, "hacker", 2, 70, 0, false)
TEAM_REAL = AddExtraTeam("Real Estate Agent", Color(153,0,255,0), "models/player/eli.mdl", [[Buy doors and sell them for $100 dollars each!]], {"keys", "pocket"}, "estateagent", 3, 80, 0, false)
TEAM_GUARD = AddExtraTeam("Guard", Color(255,255,0,0), "models/player/guerilla.mdl", [[Shop Guard for Hire!]], {"weapon_deagle", "keys", "pocket"}, "guard", 3, 80, 0, false)
TEAM_RIOT = AddExtraTeam("Riot Control", Color(255,255,0,0), "models/player/gasmask.mdl", [[You help the police in riots! You must note if you abuse the taser you will be teambanned or kicked.]], {"weapon_deagle", "weapon_ak472", "weapon_teargas", "keys", "pocket"}, "riot", 5, 80, 0, true)
TEAM_ANARCHIST = AddExtraTeam("Anarchist", Color(255,255,0,0), "models/Tactical_Rebel.mdl", [[Someone who deson't like the governemnt but isn't a gangster]], {}, "anarchist", 3, 80, 0, false)
[/lua]

Why wont the weapons work? I want the double jump removed and such because I Like to run and jump

[Juppie902]

Hmm i dont have idea what command tables / values / arguments are since suck at lua so badly, only thing i can make is jobs @ darkrp and custom shipments ^^ I'll upload my file tomorrow, see if u can fix it.

[Drakehawke]

[QUOTE=Music;22954787]Some of my problems:

Custom jobs wont show colors on scoreboard
Weapons wont give the players them I have disabled gun license.
Double jump I want it disabled so I can run and jump.

I am having problems with my jobs. It wont show the color of them on the scoreboard and it will not give anyone weapons for there jobs how do I fix it?

Job Codes
[lua]

TEAM_ADMIN = AddExtraTeam("Onduty Admin", Color(255,0,0,0), "models/player/alyx.mdl", [[A server admin thats on-duty!]], {"arrest_stick", "unarrest_stick", "pocket", "door_ram", "keys"}, "admin", 10, 100, 1, false)
TEAM_SWAT = AddExtraTeam("S.W.A.T", Color(0,0,255,0), "models/player/swat.mdl", [[Special Weapons and Tatics]], {"arrest_stick", "unarrest_stick", "pocket", "door_ram", "weapon_deagle", "weapon_pumpshotgun2", "keys"}, "swat", 5, 60, 0, true)
TEAM_NINJA = AddExtraTeam("Ninja", Color(255,0,255,0), "models/player/arctic.mdl", [[Fly around the city and try to steal some stuff!]], {"weapon_spiderman", "keypad_cracker", "lockpick", "keys", "pocket"}, "ninja", 3, 70, 0, true)
TEAM_HITMAN = AddExtraTeam("Hitman", Color(0,0,51,0), "models/player/suits/male_07.mdl", [[Get paid to kill people your prices must only be over $50.00]], {"lockpick", "weapon_deagle", "keypad_cracker", "keys", "pocket"}, "hitman", 3, 70, 0, true)
TEAM_SECRET = AddExtraTeam("Secret Service", Color(51,51,0,0), "models/player/barney.mdl", [[Get paid to protect the mayor!]], {"weapon_deagle", "keys", "pocket"}, "secret", 4, 70, 0, true)
TEAM_HACKER = AddExtraTeam("Hacker", Color(0,102,0,0), "models/player/combine_super_soldier.mdl", [[Get paid to help the police to get into places with keypads!]], {"keypad_cracker", "weapon_deagle", "weaponchecker", "keys", "pocket"}, "hacker", 2, 70, 0, false)
TEAM_REAL = AddExtraTeam("Real Estate Agent", Color(153,0,255,0), "models/player/eli.mdl", [[Buy doors and sell them for $100 dollars each!]], {"keys", "pocket"}, "estateagent", 3, 80, 0, false)
TEAM_GUARD = AddExtraTeam("Guard", Color(255,255,0,0), "models/player/guerilla.mdl", [[Shop Guard for Hire!]], {"weapon_deagle", "keys", "pocket"}, "guard", 3, 80, 0, false)
TEAM_RIOT = AddExtraTeam("Riot Control", Color(255,255,0,0), "models/player/gasmask.mdl", [[You help the police in riots! You must note if you abuse the taser you will be teambanned or kicked.]], {"weapon_deagle", "weapon_ak472", "weapon_teargas", "keys", "pocket"}, "riot", 5, 80, 0, true)
TEAM_ANARCHIST = AddExtraTeam("Anarchist", Color(255,255,0,0), "models/Tactical_Rebel.mdl", [[Someone who deson't like the governemnt but isn't a gangster]], {}, "anarchist", 3, 80, 0, false)
[/lua]

Why wont the weapons work? I want the double jump removed and such because I Like to run and jump[/QUOTE]

For the colours: Your setting the opacity of each job colour to 0, set the last number in each Color(........) to 255, eg, Color(51,51, 0, 255) (for the secret service job).

[Music]

[QUOTE=Drakehawke;22960952]For the colours: Your setting the opacity of each job colour to 0, set the last number in each Color(........) to 255, eg, Color(51,51, 0, 255) (for the secret service job).[/QUOTE]

Well basically I fixed it I just need to fix a couple more things like

- Double jump when your standing still
- Guns wont give the class jobs.

[Drakehawke]

[QUOTE=Music;22962691]Well basically I fixed it I just need to fix a couple more things like

- Double jump when your standing still [b]huh?[/b]
- Guns wont give the class jobs. [b]huh?[/b][/QUOTE]