[Release/Guide] adding more than 100 pets

01/11/2011 17:35 kyushiro#31
sorry didnt means to make it back but i did not understand if we run this as task manager how to run in vps?like this i set it as task manager then it will run every minutes for example..i am using vps ok..so if i close the vps will the task still running or how?can someone show how to make it keep running as task manager even we close our vps screen?if i just close my vps window will it still running the task?
01/11/2011 18:01 cyberghoser1#32
When you close your connection to your vps, you are currently not shutting down your vps, you are only closing down your connection to it with remote, that's all, the task manager will continue to run as anything running in your vps as well.
01/15/2011 08:34 sood#33
Quote:
Originally Posted by PraDevil[ELITE] View Post
download attachment from poster..the u will see 2 files there..after that take out the thunder.sql and put it in your computer in Drive C:

so it will be "C:\thunder.sql"

then make a new notepad..put this

Code:
[COLOR="SeaGreen"]C:\wamp\bin\mysql\mysql\bin\mysql.exe[/COLOR] -u [COLOR="Red"]root[/COLOR] -p[COLOR="Blue"]test[/COLOR] -D my -e "[COLOR="Purple"]source c:\thunder.sql[/COLOR]"
Green = point to mysql.exe
Red = mysql username
Blue = mysql password
Purple = where your thunder.sql located

save it as a whatever name u like but remember to save it in .bat file then put it in same place where u put the thunder.sql

then open control panel..find a scheduled task open it..browse for your .bat file "example: thunder.bat" set the task for it and when it will be run automatically..then leave your computer..it will run automatically;)

hope its help:D
is there anybody use this for window7??.. i already use it for my os windowns 7 and it cannot do..
it seem that if i open the thunder.sql it will said [windows cannot open this file]..
what software that i must use to make this thunder.sql run and update my mysql..
maybe this is the reason i cannot use this..
03/18/2011 20:27 Sajad901#34
LoL plz add me skype Messi:
03/18/2011 20:27 Sajad901#35
add me skype
03/18/2011 20:29 CøøKiie#36
So this bug is not solved completely, but partially, am I right?
How I do for him execute with an interval of 15 min?
07/03/2011 15:11 ryumaki23#37
Help please can you put some picture i am newbie please :(
09/15/2012 21:09 Andy20081#38
when i run the .bat it shows this

Quote:
C:\KittenChaosEo\DATABASE\mysql\bin>C:\KittenChaos Eo\DATABASE\mysql\bin\mysql.ex
e
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 43 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
is that fine as in my .bat it is

Quote:
C:\KittenChaosEo\DATABASE\mysql\bin\mysql.exe

C:\KittenChaosEo\DATABASE\mysql\bin\mysql.exe -u root -ptest -D my -e "source c:\thunder.sql"
09/15/2012 21:29 Gekru#39
Quote:
Originally Posted by Andy20081 View Post
C:\KittenChaosEo\DATABASE\mysql\bin\mysql.exe -u root -ptest -D my -e "source c:\thunder.sql"
Make the bat look like that and it should work for you.

The

Quote:
C:\KittenChaosEo\DATABASE\mysql\bin\mysql.exe
You have in there is calling the mysql twice. So only the one line I showed above is all you need.
09/16/2012 17:09 Andy20081#40
it loads bit in a split second disappears and i can just about see it say error in that split second
09/16/2012 17:14 Gekru#41
That's what it should do. It will echo your connection string, do the query then close itself out. If you log into the game you can see if it thundered your pet or not.
02/13/2013 20:14 haizamlee#42
how about if the pets are more than 200.. hahaha..
07/30/2013 08:11 OmegaOnline#43
Quote:
Originally Posted by funhacker View Post
Update for you louise, this new script will work for the whole range of pets, please let me know how it goes. As I don't even have MySQL to test the syntax...

Code:
update cq_eudemon 
set 
item_type = item_type + 4000, 
damage_type = 5 

where 
item_type >= 1072000 and 
item_type <= 1074999;


update cq_eudemon 
set 
item_type = magic_defense + 4000

where 
item_type >= 1079000 and 
item_type <= 1079999 and
magic_defence >= 1072000 and
magic_defence <= 1074999;
this script doesnt work for all pets =/ how can i make it work for all pets.