+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: Problems with MAIN THREAD (/Thread-Problems-with-MAIN-THREAD)
RE: Problems with MySQL - Lazarus - 08-17-2012 03:48 AM
(08-17-2012 01:05 AM)Extreme Wrote:
Don't worry, where are there to help when someone need help.
You are sure? Because End works like endfor -.-
RE: Problems with MySQL - Extreme - 08-17-2012 04:50 AM
(08-17-2012 03:48 AM)Lazarus Wrote:I don't think so.(08-17-2012 01:05 AM)Extreme Wrote:
Don't worry, where are there to help when someone need help.
You are sure? Because End works like endfor -.-
One time I had this same mistake, the sphere crashes like shit...
Maybe now End = Endfor, before not I think.
Did it resolve your problem? Don't? What's happening?
RE: Problems with MySQL - Lazarus - 08-18-2012 02:34 AM
(08-17-2012 04:50 AM)Extreme Wrote:(08-17-2012 03:48 AM)Lazarus Wrote:I don't think so.(08-17-2012 01:05 AM)Extreme Wrote:
Don't worry, where are there to help when someone need help.
You are sure? Because End works like endfor -.-
One time I had this same mistake, the sphere crashes like shit...
Maybe now End = Endfor, before not I think.
Did it resolve your problem? Don't? What's happening?
Nope... And I was changes some codes I'd try with this and nothing:
Code:
[FUNCTION f_query_2]
IF (<ARGN2>==0)
SERV.LOG Cuentas: El siguiente comando fallo al ejecutarse. (<ARGS>)
ELSE
SERV.LOG Cuentas: El proceso finalizo satisfactoriamente
ENDIF
[FUNCTION f_query_1]
IF (<ARGN2>==0)
SERV.LOG Cuentas: El siguiente comando fallo al ejecutarse. (<ARGS>)
ELSE
if (<LOCAL.NUMROWS> > 0)
for R 0 <eval <LOCAL.NUMROWS>-1>
serv.account add <LOCAL.<eval <LOCAL.R>>.login> <LOCAL.<eval <LOCAL.R>>.password>
serv.log Cuentas: #<eval <LOCAL.R>> La cuenta "<LOCAL.<eval <LOCAL.R>>.login>" ha sido creada
IF (<DB.AEXECUTE f_query_2, UPDATE accounts SET status='1' WHERE login='<LOCAL.<eval <LOCAL.R>>.login>'>)
SERV.LOG Cuentas: Comando iniciado satisfactoriamente
ELSE
SERV.LOG Cuentas: El comando fallo al iniciarse
ENDIF
end
endif
ENDIF
[function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
if (<DB.AQUERY f_query_1, SELECT * FROM accounts WHERE status='0'>)
SERV.LOG Cuentas: Comando iniciado satisfactoriamente
ELSE
SERV.LOG Cuentas: El comando fallo al iniciarse
ENDIFMbe... the host no is in the local host and that's the real problem i guess.
I will try to change the operating system [Im using w7] and install mysql here too...
1gb ram 2.0 1 core.
RE: Problems with MySQL - Extreme - 08-18-2012 09:46 AM
Man your problem is the mysql server stored in other machine.
You need use both in the same machine.
Try it...
RE: Problems with MySQL - Lazarus - 08-18-2012 03:09 PM
(08-18-2012 09:46 AM)Extreme Wrote: Man your problem is the mysql server stored in other machine.
You need use both in the same machine.
Try it...
Yep yep, I know.
Now I cant, the hosting are DOWN and the server is in private... We are waiting the new hosting and then we'll install the mysql and the sphereserver ^_^
Thanks for all
RE: Problems with MySQL - Extreme - 08-18-2012 03:44 PM
Let us know later if you setup the mysql and sphereserver in the same machine =D
RE: Problems with MySQL - Lazarus - 08-18-2012 04:00 PM
(08-18-2012 03:44 PM)Extreme Wrote: Let us know later if you setup the mysql and sphereserver in the same machine =D
Yes I will. Thanks Extreme
Im waiting for you in my shard xD I wanna get your soul
haha
RE: Problems with MySQL - Extreme - 08-19-2012 02:47 AM
I joined but don't see players then I logout :\
RE: Problems with MySQL - xwerswoodx - 08-19-2012 02:55 AM
you should use endfor, you use end. Change it endfor.
RE: Problems with MySQL - Lazarus - 08-21-2012 02:07 PM
I'm not using the mysql script, im not connected to a mysql, I have commented ALL of the MYSQL, and my sphere frozens, my computer works fine, but again the error of the main at 1 min or 2 later...
Everytime... The sphere frozes like a 1 min -.-
00:42:WARNING:Forcing thread 'Main' to terminate...
00:42:CRITICAL:'Main' thread hang, restarting...
What can be now?
Thanks...
[CAN BE THE SPHERESERVICE? Im using it...]
Okay, i have closed it and happends again...
This happends in the VPS and in my PC with the playeers ON -.-
:'(
please help!