Hi,
Stuck a bit on a mysql query and looking for some help
Looking to make it so that if you use command :sell in a room that already had APARTMENT it adds FORSALE to room description for current room ID in rooms_data via mysql so that it updates the current room description to APARTMENT FORSALE. Tried with a few sql queries with no luck
Any ideas? Thankyou
This is what I have at the moment - unsure as to why it isnt working
dbClient.RunFastQuery("UPDATE `rooms_data` SET `description` = 'FORSALE' WHERE `id` = '" + Session.JobManager().CurrentRoom.RoomId + "'");
Stuck a bit on a mysql query and looking for some help
Looking to make it so that if you use command :sell in a room that already had APARTMENT it adds FORSALE to room description for current room ID in rooms_data via mysql so that it updates the current room description to APARTMENT FORSALE. Tried with a few sql queries with no luck
Any ideas? Thankyou
Post automatically merged:
This is what I have at the moment - unsure as to why it isnt working
dbClient.RunFastQuery("UPDATE `rooms_data` SET `description` = 'FORSALE' WHERE `id` = '" + Session.JobManager().CurrentRoom.RoomId + "'");
Last edited:
