Player Database [Replaced]

Not sure what you mean, you should only have to fill out this section:

Code:

       static string steamapikey = "XXXXXXXXXXXXXXXXX";
        static bool useMysql = true;
        static int mysqlPort = 3306;
        static string mysqlHost = "127.0.0.1;
        static string mysqlUsername = "rust";
        static string mysqlDatabase = "rust";
        static string mysqlPass = "rust123";
        static string mysqlTable = "playerdatabase";

The API key comes from: https://steamcommunity.com/dev/apikey

 

Everything is fixed, if anyone needs help with MySQL, ask me.

 

Which application do you recommend to install MySQL server on Windows ?

 

After the new oxide update i got this error:

> oxide.reload PlayerDatabase
[Oxide] 6:48 PM [Error] Plugin failed to compile: PlayerDatabase (leaving previous version loaded)
[Oxide] 6:48 PM [Error] PlayerDatabase plugin failed to compile!
[Oxide] 6:48 PM [Error] PlayerDatabase.cs(234,126): error CS1501: No overload for method `Query' takes `2' arguments

 

I have this error:

Code:

[Oxide] 5:45 PM [Error] Plugin failed to compile: PlayerDatabase (leaving previous version loaded)
[Oxide] [Error] PlayerDatabase plugin failed to compile!
[Oxide] [Error] PlayerDatabase.cs(234,126): error CS1501: No overload for method `Query' takes `2' arguments

Before plugin works perfectly, I don't edit nothint, only update Oxide to latest version.

 

Just go ahead and edit with this; http://oxidemod.org/extensions/mysql-extension.901/

 

But I have that error when I try to reload plugin with "oxide.reload PlayerDatabase".
This plugin has always worked perfectly and I edit nothing, only update Oxide to latest version, do I need come back to previous Oxide version?

 

Just go ahead and edit with this; http://oxidemod.org/extensions/mysql-extension.901/

You REALLY didn't read update notes didn't you? MySQL part was changed.
Never update anything without reading what will be updated and always make backup of your server.

 

Yeah totally forgot to read the updates before updating, and got to say it's rather hard to edit it when you know fuck all when it comes to scripting Fancy helping me PreFiX?

 

@PreFiX if you could fix it for me it would mean a lot! i can't code anything for another week :x

 

I tried what I could do, but I'm not sure how to fix one part. I mean I want to throw back value back from callback but I don't even imagine how to do this. If I would create another dictionary for it it would be nonsense because it's mysql lol (it shouldn't store what you get from it) whatever who else wanna help can finish this.

Here is error:



It's not really hard to update, but I think it's quite hard when you lacking skills for it

 

[Oxide] 1:56 PM [Error] PlayerDatabase.cs(166,9): error CS8030: Anonymous function or lambda expression converted to a void returning delegate cannot return a value

 

the Query function can't return a value...that's the error. - If you are not using MySql, just comment out the lines relating to Query function call.

Like this:
(Lines 125 to 144)

Code:

/*            else
            {
                if (AvaibleKeys.Contains(key))
                {
                    string query = string.Format("SELECT {2} FROM `{0}` WHERE `steamid` = '{1}' LIMIT 1", mysqlTable, userid, key);
                    sql = _mySql.NewSql();
                    sql.Append(query);
                    _mySql.Query(sql, connection, res =>
                    {
                        foreach (Dictionary<string, object> obj in res)
                        {
                            foreach (object value in obj.Values)
                            {
                                return value.ToString();
                            }
                        }
                    });
                }
            }
*/

and lines (155-172)

Code:

         /*   else
            {
                string query = string.Format("SELECT name FROM `{0}` WHERE `steamid` = '{1}' LIMIT 1", mysqlTable, userid);
                sql = _mySql.NewSql();
                sql.Append(query);
                _mySql.Query(sql, connection, res =>
                {
                    foreach (Dictionary<string, object> obj in res)
                    {
                        foreach (object value in obj.Values)
                        {
                            if (value != null || value != "")
                                return value.ToString();
                        }
                    }
                });
            }
*/

 

ok thanks, should I use the file
PreFiX posted instead allso?
[DOUBLEPOST=1440184264][/DOUBLEPOST]Fixed my issue Thanks!!!

 

Tried it with your update @GratefulMichael but got this error:

Code:

[Oxide] 9:44 PM [Error] PlayerDatabase plugin failed to compile!
[Oxide] 9:44 PM [Error] PlayerDatabase.cs(166,33): error CS8030: Anonymous function or lambda expression converted to a void returning delegate cannot return a value

 

My server of Rust legacy runs the oxide 2.0 very good, but in the two latest updates the plugin player database dont works, and i need it.
Note: Every update i reinstall the server at the zero point and make a new server with the zip file and not work.
I thank you for your service, very good and a nice oxide version.

 

Maybe you missed commenting out one of the mysql function calls. Try using this, it's the lastest version from here with the comments in the right place.

 

Tanks magnus 2 you fix my problem!

 

11:54 PM [Error] Error while compiling PlayerDatabase.cs(234,126): error CS1501: No overload for method `Query' takes `2' arguments

 

Can u help me? :C