if connection to mysql failed, skip function

TheBladerX · **Author**

Hey, how can I make this in plugin init

Code:

g_con = SQL_MakeDbTuple(DB_HOST, DB_USER, DB_PASS, DB_DB) 
db_con()

if connection fails, skip this and don't connect (because my database stopped working for a while and whole plugin was not working).

something like if (g_con == error).. skip db_con() ?

DjSoftero · 02-05-2019 , 10:21 Re: if connection to mysql failed, skip function

I got some questions for you. Do you want us to do everything for you? in that case, we need whole plugin, because if it doesn't connect, then you would have to add IF statements before every connection.
If you're asking for help in a sense of doing things yourself and just need some directions given, then read this: https://forums.alliedmods.net/showthread.php?t=132686 and if you got more questions left, feel free to ask.

klippy · 02-05-2019 , 10:23 Re: if connection to mysql failed, skip function

SQL_MakeDbTuple never fails and doesn't establish a connection either.

TheBladerX · 02-05-2019 , 10:47 Re: if connection to mysql failed, skip function

Okay, so what does? According to this code https://forums.alliedmods.net/showthread.php?t=307920

klippy · 02-05-2019 , 11:04 Re: if connection to mysql failed, skip function

It says exactly what it does in the doc: http://amxmodx.org/api/sqlx/SQL_MakeDbTuple

TheBladerX · *Last edited by TheBladerX; 02-05-2019 at 11:55.*

Quote:

Originally Posted by KliPPy

It says exactly what it does in the doc: http://amxmodx.org/api/sqlx/SQL_MakeDbTuple

Yeah, I meant, what does establish the connection.

Quote:

Originally Posted by DjSoftero

I got some questions for you. Do you want us to do everything for you? in that case, we need whole plugin, because if it doesn't connect, then you would have to add IF statements before every connection.
If you're asking for help in a sense of doing things yourself and just need some directions given, then read this: https://forums.alliedmods.net/showthread.php?t=132686 and if you got more questions left, feel free to ask.

Sorry did not notice your post. That one did not work for me, after many tries. This one https://forums.alliedmods.net/showthread.php?t=307920 works perfectly. Let us say, that this is the code I would like to edit. I am familiar with that I need to use if statement, but I have no idea, how should the if statement look like. That is all I am asking for, thank you.

//edit:
this is what I was looking for

Code:

set_fail_state(g_Error)

Thank you.

DjSoftero · 02-05-2019 , 12:10 Re: if connection to mysql failed, skip function

set_fail_state(g_Error) does not allow for the plugin to function. It disables it as it has failed to connect to the database. Your server won't crash, but plugin won't work either.