[Request] Some queries , and Some Answers ..

Hello . , since i am really bad at queries and each time i try make one i fuck the DB xD

I Need some quires , i hope i find it :D

1. I Need a query to add all 120 Skillz in DB
2. And other query to add level 120 mobs and drops , idk if it can be done by queries or no :D

AND Also i hope i find some answers for :

1. How to take Tables from DB ,as *.txt and edit it in (for example : Microsoft Excel) , and how to re-add them to DB ?
2. How to change Arena Start time , and Arena Kind ( like i need it to be Job or Random only , and every 1 hour ) ?
3. How to change Mobs Spawn rate , and how to edit uniques spawn time and areas ?
4. How to change Uniques Health and power ?

and btw , my GS give me this "invalid Register Siege Struct gen position is designated! [structure_pos_ja_defensive_17] : [65535, 0.000000, 0.000000, 0.000000] ?ny help about it ^ ?


it seem so many , but i can't found answers in google xD ,
Thanks:D:D

Quote:

Originally Posted by Neko_ Hello . , since i am really bad at queries and each time i try make one i fuck the DB xD I Need some quires , i hope i find it :D I Need a query to add all 120 Skillz in DB And other query to add level 120 mobs and drops , idk if it can be done by queries or no :D AND Also i hope i find some answers for : How to take Tables from DB ,as *.txt and edit it in (for example : Microsoft Excel) , and how to re-add them to DB ? How to change Arena Start time , and Arena Kind ( like i need it to be Job or Random only , and every 1 hour ) ? How to change Mobs Spawn rate , and how to edit uniques spawn time and areas ? How to change Uniques Health and power ? and btw , my GS give me this "invalid Register Siege Struct gen position is designated! [structure_pos_ja_defensive_17] : [65535, 0.000000, 0.000000, 0.000000] ?ny help about it ^ ? it seem so many , but i can't found answers in google xD , Thanks:D:D

skills: update _refskill set service = '1' where basic_code like 'skill%' and reqcommon_masterylevel1 < 120
unique spawn time/area/mob spawn rate: tab_refnest
unique health/power: _refobjchar (the id is the link in _refobjcommon)
arena time: sr_schedule in smc