Quote:
Originally Posted by [PM]Sazao
hurmmm
|
What was the point ?
Hmm, Here is what i use ...
Create a Notepad or Text Document and add this to it on your C:/
Code:
c:\Documents and Settings\Administrator\Desktop\EO Server\mysql\bin\mysql.exe -u root -ptest -D my -e "source c:\thunder.sql" -o
c:\MyResults.txt -e
Rename it to thunder.bat
Now go into c:/ again and make another Note pad Or Text Document and add this to it
Code:
update cq_eudemon set item_type = item_type + 4000, damage_type = 5 where item_type < 1075999 and magic_defence > 1071999;
update cq_eudemon set item_type = item_type - 3000 where item_type > 1077000 and magic_defence > 1071999;
Rename it to thunder.sql
Ok now go into your Server files My directory is..
Desktop\ServerFiles\mysql\bin
Then create a Note Pad or Text Document in there and add this to it
Code:
mysql.exe -u root -ptest -D my -e "source c:\thunder.sql"
Rename it to thunder.bat
Now go into Control pannel and use Scheduled tasks
Set it up so it runs for how ever long u want it to mine runs every 1minute, You can have yours run for XX.XX time
Make sure your Scheduled task is set to run this bat file
Desktop\ServerFiles\mysql\bin\thunder.bat
Hope this helped you
Make sure u Set it up so it runs the BAT