[Release/Guide] adding more than 100 pets

[kyushiro]

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?

[cyberghoser1]

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.

[sood]

Originally Posted by PraDevil[ELITE]

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

[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

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

[Sajad901]

LoL plz add me skype Messi:

[Sajad901]

add me skype

[CøøKiie]

So this bug is not solved completely, but partially, am I right?
How I do for him execute with an interval of 15 min?

[ryumaki23]

Help please can you put some picture i am newbie please

[Andy20081]

when i run the .bat it shows this

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

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

C:\KittenChaosEo\DATABASE\mysql\bin\mysql.exe -u root -ptest -D my -e "source c:\thunder.sql"

[Gekru]

Originally Posted by Andy20081

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

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.

[Andy20081]

it loads bit in a split second disappears and i can just about see it say error in that split second

[Gekru]

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.

[haizamlee]

how about if the pets are more than 200.. hahaha..

[OmegaOnline]

Originally Posted by funhacker

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

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.