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:
If anyone can get me the correct sql query to run for a perfect match, it would be helpful thank you
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'");