Help!

Cablink

http://www.vroleplay.net - join now!
Feb 4, 2011
382
27
Hey there.. well yeah I lost my table, and I really suck at making database tables, but I have something that can give a hint of how the table will look. This is the source:
Code:
int roomid;
                                    int x;
                                    int y;
                                    using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
                                    {
                                        arrested = dbClient.getString("SELECT arrested FROM users WHERE name = '" + _Username + "'");
                                        x = dbClient.getInt("SELECT x FROM action_points WHERE roomid = '" + _roomID + "' && action = 'jb'");
                                        y = dbClient.getInt("SELECT y FROM action_points WHERE roomid = '" + _roomID + "'&& action = 'jb'");
                                        roomid = dbClient.getInt("SELECT roomid FROM action_points WHERE roomid = '" + _roomID + "'&& action = 'jb'");
If anyone can get me the correct sql query to run for a perfect match, it would be helpful thank you :D
 

Users who are viewing this thread

Top