Post: #1

I had to erase the mysql because the server get freezed and somethings sends some like this...

What should I do?
A great scripter have tell's me that change the QUERY for AQUERY and something else that i don't remember ^_^

Any ideas?

Thanks!

Lazarus.

Post: #2

its depended on your sql statements, how many rows you returned from mysql and for what purpose?

Post: #3

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

that is the script

it's just create accounts by web.

Post: #4

how many accounts created for one instance? for the hang the main thread, thousands of accounts needs to be created.

also if your mysql server is not in the local network your server can always freeze due to slow connection between two servers.

Post: #5

(08-16-2012 06:26 AM)Shaklaban Wrote:  how many accounts created for one instance? for the hang the main thread, thousands of accounts needs to be created.

also if your mysql server is not in the local network your server can always freeze due to slow connection between two servers.

I guess that's the problem...
I have the mysql server in other server..
Any idea?

The script it's OK?

Post: #6

scripts is ok.

Post: #7

[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
endfor
endif

Post: #8

haha epic

Post: #9

(08-16-2012 04:18 PM)Extreme Wrote:  [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
endfor
endif

that's all the problem! :||||||||
god why
[I don't understand of MySQL, my spherescripting SUCKS very much, but... I have a staff with this, I only post in the forums and ask the problems ^_^]

That can be all?

Post: #10

Don't worry, where are there to help when someone need help.