Cronus Workshop

[peterisgb]

A while back i got Cronus workshop mod. i'm running a game on wamp and i was wondering if anyone has a upto date mysqli version of this and i changed mine to mysqli and it still dont work

[KyleMassacre]

Well it should be using the database class if your using V2. So if your config file is set to use mysqli then just make sure that Cronus isn't using any mysql_* functions inside the code

[peterisgb]

well i went through his script and changed it to mysqli and it still dont quite work. i know its set to mysqli in config as MTG coded my class for me.

[sniko]

well i went through his script and changed it to mysqli and it still dont quite work. i know its set to mysqli in config as MTG coded my class for me.

You didn't just add an i at the end where it said mysql, did you?

Because don't.

Edited September 25, 2014 by sniko

[peterisgb]

You didn't just add an i at the end where it said mysql, did you?

Because don't.

oh erm..... yeah i did lol. what should i do lol.

[KyleMassacre]

Change it back and convert it over to the database class. I don't know much about MTG's mysqli wrapper to really help you out

[Script47]

It would be really helpful if it does show any errors that you post them on here. That will at least give us a clearer idea where you're going wrong.

[G7470]

When converting from mysql to mysqli, if done using the procedural language style like such:

 

$result = mysql_query("/* QUERY GOES HERE */");

 

You have to add the database connection as a parameter BEFORE the query itself. So, as long as you have your configuration file included somehow (through header or some other header file), then all you will have to do is use the variable that connects to the database. Usually, in your config file, the variable you want to use is assigned something like this:

 

$con = mysqli_connect('/* HOST */','/* USERNAME */', '/* PASSWORD */', '/* DATABASE NAME */') or die("Error ".mysqli_error($con)); 

 

So, $con is the variable to use. Then, for mysqli_query, you would make those look like this:

 

$result = mysqli_query($con, "/* QUERY GOES HERE */");

 

For more information of the mysqli php class, check out here: http://php.net/manual/en/class.mysqli.php