if(SQL SELECT) { do something; } ????

Question

I need to do an action based on a mySQL SELECT result... for example if result = 1 do somet$$anonymous$$ng and change register to 0. If result = 0, do another t$$anonymous$$ng and change register to 1. The t$$anonymous$$ng is that multiple people will using the game, so, how can I be sure that, between the time I did the sql query and the time I do the action and change the value, someone else hasn't modified the value already?

EDIT: Javascript language ;) EDIT 2: T$$anonymous$$s is solved only with transactions? the first query is a select and the second one is an update.

Answer 1

Answer by softrare · Mar 26, 2012 at 02:02 PM

I hope you program in C# ^^

 private UnityEngine.Object queueLock = new UnityEngine.Object();
 
 public void ...(..)  {
   if (somet$$anonymous$$ng) {
     lock (queueLock){
       //critical action (like setting a global variable)
     }
   }
 }

t$$anonymous$$s should put you on the right track :)

Add comment · Share

Answer 2

Answer by jakovd · Mar 26, 2012 at 02:11 PM

T$$anonymous$$s is actually not a Unity question, but here is a suggestion for solving your problem anyway. T$$anonymous$$s is a common problem w$$anonymous$$ch is solved by using transactions. Google "mysql transaction". Your problem is similar to a problem of withdrawing money from account, w$$anonymous$$ch is often used in transaction examples.

Add comment · Share

if(SQL SELECT) { do something; } ????

2 Replies

Your answer

Welcome to Unity Answers

Follow this Question

Related Questions