[thelist] Difference Between Versions
Phillip M. Vector
phillipmvector at comcast.net
Mon Apr 12 08:15:43 CDT 2004
This code is supposto take each characters id and count how
many resource levels are stored on the table (I wanted to put
a number quanity there, but the processing was making my brain hurt).
Then it applies it to a formula and adds money to their
account every day.
I have CFMX installed on my machine here and the following
works great.
My server I actually run the page from keeps giving everyone
the same amount (It looks like the level of the last
character checked).
So ... What do I need to change to get it to work with CF5?
===============================
<cfquery datasource="A6261_main_test" name="Richpeople">
select DISTINCT Character_ID from Table_Backgrounds where
Name = 'Resources'
</cfquery>
<cfloop Query="richpeople">
<cfoutput>
<cfquery datasource="A6261_main_test" name="resources">
select Character_ID from Table_Backgrounds where Name =
'Resources' AND Character_ID=#richpeople.Character_id#
</cfquery>
<cfset total = (((((#resources.recordcount# *
500)-498+(#randrange(0,6)#)-3)) *#days#)+ #character.moneyinbank#)>
<cfquery datasource="A6261_main_test">
update Table_Character
SET Moneyinbank = #total#, Last_Updated =
#createodbcdate(now())# Where Character_ID=#resources.Character_id#
</cfquery>
</cfoutput>
</cfloop>
More information about the thelist
mailing list