| Lazarus  Master
 
   
   Posts: 352
 Likes Given: 11
 Likes Received: 7 in 6 posts
 Joined: Jun 2012
 Reputation: 1
 
 Hybris Ultima Online
 
 ![]() 
 | 
			| RE: Problems with MySQL 
 
				 (08-16-2012 03:02 AM)Shaklaban Wrote:  its depended on your sql statements, how many rows you returned from mysql and for what purpose? 
Code:
 [function f_acc_update]if !( <DB.connected> )
 DB.CONNECT
 ENDIF
 DB.QUERY "SELECT * FROM accounts WHERE status='0'"
 if (<DB.ROW.NUMROWS> > 0)
 for R 0 <eval <DB.ROW.NUMROWS>-1>
 serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>
 DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"
 serv.log MySQL Debug: #<eval <LOCAL.R>> La cuenta "<DB.ROW.<eval <LOCAL.R>>.login>" ha sido creada
 end
 endif
 
that is the script 
 
it's just create accounts by web.
			 
 |  | 
	| 08-16-2012 06:24 AM |  | 
	
	| ![[+]](images/collapse_collapsed.gif)  
 |