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 |
|
|