xD yes... any ideas? I'm just using google translator and how to describe exactly what I'm ...
http://www.foroz.org/foroz/viewtopic...=582945#582945...
JJBreaker
Last Activity: Sep 12 '11, 02:04 AM
Joined: Sep 11 '11
Location:
-
-
Thanks for the help, I resolved, I leave here the code if it helps someone
...Code:Declare @ID numeric Select @ID = (SELECT COUNT ("ONLINE") AS ONLINE FROM RZ_CHARACTER WHERE ACCN_ID = @ACCN_ID AND ONLINE = 1) IF @ID = 0 UPDATE RZ_ACCOUNTDB.dbo.RZ_ACCOUNT SET SITE_CODE=1 WHERE SITE_CODE='' AND ACCN_ID=@ACCN_ID; Else UPDATE RZ_ACCOUNTDB.dbo.RZ_ACCOUNT SET SITE_CODE='' WHERE SITE_CODE='1'Leave a comment:
-
thank you very much for the quick response, but is somewhat more complicated...
I need to check if any of yours characters is online, if not any of his characters gamedb online, update accoundb.site_c ode to 1 :/Leave a comment:
-
Update WHERE checking with another database
Hi, I'm Spanish and little English, I will try to understand me best.
I am creating an online game based on xml, lua and SQL Server, I have a database named accountdb and other named gamedb.
within accountdb This table accounts and within gamedb This table characters... Ok
in accountdb.accou nts field site_code INT
in gamedb.characte rs field online INT
I need an update site_code set...
No activity results to display
Leave a comment: