• Gm_MySql v1.0 - OO edition.
    824 replies, posted
  • [QUOTE=Ruzza;36644850]Why exactly would you want to put the thread on hold, is it to prevent multiple queries running at once?[/QUOTE] You only put that thread that runs that specific code on hold. It completes the query then it runs the code past the wait() It's so you dont have to use callbacks to send data.
  • Avatar of Ruzza
  • [QUOTE=Remscar;36644881]You only put that thread that runs that specific code on hold. It completes the query then it runs the code past the wait() It's so you dont have to use callbacks to send data.[/QUOTE] Oh that makes sense. Is that on purpose or just something accidental?
  • [QUOTE=Ruzza;36645518]Oh that makes sense. Is that on purpose or just something accidental?[/QUOTE] Not sure... Possibly.
  • Avatar of marvincmarvin
  • [QUOTE=Nexus435;36529857]Yeah, no way to mysql inject with a steamid.[/QUOTE] ? [lua] function _R.Player:SteamID() return "'; DROP TABLE players;" end [/lua]
  • Avatar of Chessnut
  • But that wouldn't work since the MySQL stuff is ran server-side. You'll need to override it serverside, which you can't.
  • Avatar of Ruzza
  • [QUOTE=marvincmarvin;36848272]? [lua] function _R.Player:SteamID() return "'; DROP TABLE players;" end [/lua][/QUOTE] Try and override the function on serverside.
  • My FTP client wont accept .dll and I've attempted adding the .dlls through the server CP but it wouldn't work. Do you guys know how I could possibly fix this so I can successfully get my .dlls into the server files like it's needed?
  • Avatar of PaellaPablo
  • [QUOTE=spykillyou;36970888]My FTP client wont accept .dll and I've attempted adding the .dlls through the server CP but it wouldn't work. Do you guys know how I could possibly fix this so I can successfully get my .dlls into the server files like it's needed?[/QUOTE] What FTP client are you using? What is the message the comes up when you try and upload a dll?
  • [QUOTE=Wizard of Ass;36971310]You need to talk to your server host and ask them to install the module.[/QUOTE] Yeah, I had figured that out afterwards. The host and I are taking care of it, thanks!
  • Hey Guys, I have a big Problem, i want to use this script with my DarkRP server. on the mysql.lua from darkrp he say i need this script. Okay i install the script on my addons folder (linux debian root) okay and the script dont running: MySQL Error: MySQL modules aren't installed properly! - okay i read again this thread. now i read this : [QUOTE] [list][*]Extract the zip file to your garrysmod\addons directory (ie: c:\steam\steamapps\username\garrysmod\garrysmod\ad dons)[*]Take the libmySQL.dll, and put it in the same directory as HL2.EXE (ie: c:\steam\steamapps\username\garrysmod)[*]Move the files gmsv_mysqloo.dll and gmcl_mysqloo.dll to the garrysmod\lua\includes\modules folder.[/list][/QUOTE] and do this, my error code now: Timer Error: [@gamemodes/DarkRP/gamemode/server/data.lua:93] MySQL modules aren't installed properly! i hope you can help me thanks greets drugsii
  • Yes, I realize that, but how can I change this? you see, i put the script on my addons folder - dont running i put it on the home directory and on moduls and this dont runnig
  • garrysmod\lua\includes\modules edit: or can you simple say who i must put in the srcipt? (Linux, debian )
  • Avatar of Agent766
  • You are using the linux versions, right? Try renaming it to gmsv_mysqloo.dll (from gmsv_mysqloo_i486.dll)
  • Avatar of Agent766
  • Then you're using the Windows DLL rather than the Linux one. The Linux one is named "gmsv/cl_mysqloo_i486.dll". Get the one here: [url]http://github.com/downloads/andyvincent/Garry-s-Mod-Extensions/MySqlOO-v7-linux.zip[/url] And then I believe you do have to get rid of the _i486 suffix.
  • there files i have put in the addons folder, but dont running :S i am confused
  • Avatar of Chewgum
  • you need to rename the module to linux instead of i486. And if you're using the darkrp svn, go to server/data.lua and change any i486 shit and don't put it into addons
  • Same Shit - dont running. So i have do that : #1 Download Linuxv7 #2 Put the files in >lua/inculde/modules [CODE]lua/includes/modules/[B]gmcl_mysqloo.dll[/B] lua/includes/modules/[B]gmsv_mysqloo.dll[/B][/CODE] #3 Edit the Data.lua from DarkRP [CODE]include("static_data.lua") /*--------------------------------------------------------------------------- MySQL and SQLite connectivity ---------------------------------------------------------------------------*/ if file.Exists("lua/includes/modules/gmsv_mysqloo.dll", true) or file.Exists("lua/includes/modules/gmsv_mysqloo.dll", true) then require("mysqloo") end[/CODE] #4 Restart the Server and : [CODE]Timer Error: [@gamemodes/DarkRP/gamemode/server/data.lua:93] MySQL modules aren't installed properly![/CODE] -> sorry for stupidity =(
  • Avatar of vercas
  • Did you put [b]libmysql.dll[/b] in the same folder as your [b]srcds.exe[/b] or [b]hl2.exe[/b]?
  • So now i have a new bug: [code]ERROR: Hook 'FAdmin_DarkRP_privs' Failed: [gamemodes/DarkRP/gamemode/shared/FAdmin_DarkRP.lua:273] attempt to call field 'AddPrivilege' (a nil value) Removing Hook 'FAdmin_DarkRP_privs' ERROR: Hook 'FPP_Load_FAdmin' Failed: [gamemodes/DarkRP/gamemode/FPP/server/FPP_Settings.lua:397] attempt to call field 'Query' (a nil value) Removing Hook 'FPP_Load_FAdmin' Initializing Steam libraries for secure Internet server Looking up breakpad interfaces from steamclient Calling BreakpadMiniDumpSystemInit Timer Error: [gamemodes/DarkRP/gamemode/FAdmin/Changelevel/sv_init.lua:17] attempt to call field 'AddPrivilege' (a nil value) Timer Error: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:828] attempt to call field 'ConnectToMySQL' (a nil value) Timer Error: [gamemodes/DarkRP/gamemode/server/FAdmin_MySQL.lua:7] attempt to call field 'Query' (a nil value) Timer Error: [gamemodes/DarkRP/gamemode/FPP/server/FPP_Settings.lua:695] attempt to call field 'Begin' (a nil value) Timer Error: [gamemodes/DarkRP/gamemode/FAdmin/Access/sv_init.lua:9] attempt to call field 'Query' (a nil value) ERROR: Hook 'FAdmin_SetAccess' Failed: [gamemodes/DarkRP/gamemode/FAdmin/Access/sv_init.lua:112] attempt to call field 'QueryValue' (a nil value) Removing Hook 'FAdmin_SetAccess' ERROR: Hook 'FAdmin_SetAccess' Failed: [gamemodes/DarkRP/gamemode/FAdmin/Access/sv_init.lua:112] attempt to call field 'QueryValue' (a nil value) Removing Hook 'FAdmin_SetAccess' ERROR: GAMEMODE:'PlayerInitialSpawn' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:471] attempt to call field 'Log' (a nil value) ERROR: GAMEMODE:'PlayerSelectSpawn' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:546] attempt to call field 'RetrieveTeamSpawnPos' (a nil value) ERROR: GAMEMODE:'PlayerSetModel' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:441] attempt to index local 'TEAM' (a nil value) ERROR: GAMEMODE:'PlayerLoadout' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:683] attempt to call field 'PlayerHasPrivilege' (a nil value) ERROR: GAMEMODE:'PlayerSpawn' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:546] attempt to call field 'RetrieveTeamSpawnPos' (a nil value) ERROR: GAMEMODE:'PlayerInitialSpawn' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:471] attempt to call field 'Log' (a nil value) ERROR: GAMEMODE:'PlayerSelectSpawn' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:546] attempt to call field 'RetrieveTeamSpawnPos' (a nil value) ERROR: GAMEMODE:'PlayerSetModel' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:441] attempt to index local 'TEAM' (a nil value) ERROR: GAMEMODE:'PlayerLoadout' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:683] attempt to call field 'PlayerHasPrivilege' (a nil value) ERROR: GAMEMODE:'PlayerSpawn' Failed: [gamemodes/DarkRP/gamemode/server/gamemode_functions.lua:546] attempt to call field 'RetrieveTeamSpawnPos' (a nil value) ERROR: Hook 'FAdmin_noclip' Failed: [gamemodes/DarkRP/gamemode/FAdmin/PlayerActions/Noclip/sv_init.lua:48] attempt to call field 'PlayerHasPrivilege' (a nil value)[/code] I spawn wrong, can not take a job etc. Tabels on database not createt (in db is nothing) Edit: yes i put the libmysql.dll in the home folder (/srcds/orangebox) but the windows libmysql.dll because on the linux bundle isent a libmysql.dll
  • Avatar of Deadman123
  • [QUOTE=Drugsii;37078016]what can i do ?[/QUOTE] Learn how to take advice better and actually THINK.
  • [QUOTE]Learn how to take advice better and actually THINK.[/QUOTE] Haha nice help thanks -.-'
  • Avatar of Luni
  • I would strongly suggest learning to debug your own code first. Are those errors serverside or clientside? Did you check the console scrollback for any failed includes? Did you actually look at the lines that are causing errors? Is AddPrivilege() in a table? Does that table exist at runtime? Do you even know what "attempt to call field ________ (a nil value)" means? Did you do [i]any[/i] troubleshooting whatsoever?