Post: #1

I have tables for each accounts and i want to update their one column which are the same name "status" is it possibly to that with one command without for loop? If its not possible than another question is it possible to take a backup db when server save and restore db when i start the sphere?
example;
1th question example
i got "a,b,c,d,e,f,g,h,t,c" tables and they all have status column in sphere_serv_triggers.scp
[FUNCTION f_onserver_save]
ldb.connect
if <ldb.connected>
update all status to 1 where status 0 ---> is this possible?
ldb.close
endif

2th question example
i got database called "spheredb" and "a,b,c,d,e,f,g,h,t,c" tables and they all have status column in sphere_serv_triggers.scp
[FUNCTION f_onserver_save]
ldb.connect
if <ldb.connected>
backup "spheredb" name it "spheredb_backup" ----> is this possible?
ldb.close
endif

[FUNCTION f_onserver_start]
ldb.connect
if <ldb.connected>
restore from "spheredb_backup" to "spheredb" ----> is this possible?
ldb.close
endif


sorry for my english