Renegade Public Forums
C&C: Renegade --> Dying since 2003™, resurrected in 2024!
Home » Renegade Discussions » Mod Forum » MySQL with SSGM?
Re: MySQL with SSGM? [message #432893 is a reply to message #432883] Fri, 16 July 2010 21:47 Go to previous messageGo to previous message
reborn is currently offline  reborn
Messages: 3231
Registered: September 2004
Location: uk - london
Karma:
General (3 Stars)
TechnoBulldog wrote on Fri, 16 July 2010 20:48

It's sad that the only reason I'm posting is because I have a problem.

I'm new to making c++ SSGM plugins and MySQL with c++. I'm trying to make a simple "!postnote" command that will add a player's name and message to a table in the database (I know someone is going to say "Why don't you use fstream or another io function?" It's because I want to experiment with databases). At the moment, I've been able to make it connect, but whenever it tries to execute a query, the server crashes. It doesn't seem to have any trouble with connecting to MySQL, I mean, if I use the correct username and password, it works fine, and when it's the incorrect username and password, it tells me there was an error. I only seem to have a problem when I try to execute a query, at which point, the server crashes without adding anything to the database. I also get 7 warnings when I compile it, all coming from "cppconn/exception.h". I made a simple console application using the same stuff and it worked fine.

I suppose my first question would be, is it possible to have MySQL in an SSGM plugin?

Second would be, is there an obvious reason it is crashing my server?

Toggle Spoiler


If I've made a stupid mistake somewhere, please point it out. If you think you might be able to help, but I left something out, let me know and I'll try to post the info. This is bugging me a lot haha. I also have a bad feeling this is the wrong place to post this...


Welcome to the forums. =]
The FDS can interact with databases, this shouldn't be a problem.
Infact, someone called "jnz" (an awesome chap) almost finished a bot that interacted with a database (before he decided to halt development), you can see the bot's code in this release, here: http://www.littlebigsite.co.uk/Misc/Files/Projects.rar

Sadly, I do not know much about database interaction and MySQL, so I cannot help much to be honest, although I would if I could...

If your console application worked fine, and it is connecting to the database fine, then I think we can assume it's the query itself that's causing an error?

I would be keen to see the console applications query...
Perhaps you could try a test query that does not rely on the player GameObject's, but just a normal string?

I am thinking there might be a possible cause in the below code, because you're using a std string, and it should be converted to a c string.

std::string query = StrFormat("INSERT INTO messages(name, message) VALUES('%s', '%s')", pName, Text[0]);


Should be:
std::string query = StrFormat("INSERT INTO messages(name, message) VALUES('%s', '%s')", pName.c_str(), Text[0]/*may also need to be concerted to a c string?*/);


I'm glad you did post this question because it's an excellent thread!


[Updated on: Fri, 16 July 2010 21:54]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Help with sockets
Next Topic: Human Anims
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Thu Nov 28 12:12:24 MST 2024

Total time taken to generate the page: 0.00874 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 420.69.
Copyright ©2001-2023 FUDforum Bulletin Board Software