I can't. As I said earlier, the excel doesn't load the database. I asked
so, 3) any idea where I can be sure of what to write at the "Driver" line of your new_drops.xls, so I can fix the values of the drop chances? It seems unhuman without Excel here.
because my guess is I've put wrong values (I tried several) in there (the "config" tab of new_drops.xls).
When I try to save to a CSV, it does an error, and shows in yellow the " .Open" in VBA, here :
- 'cnMySql.cursordriver = rdUseOdbc
- With cnMySql
- .ConnectionString = ConString
- '.ConnectionString = "uid=root;pwd=sproggins;server=localhost;" & _
- "driver={MySQL ODBC 3.51 Driver};database=rev81;dsn='';"
- .Open
- End With
- 'MsgBox ("connected to the DB successfully")
- 'Cells(1, 10).value = "connected to Database"
- Exit Sub
I would love to use excel to change the drops.
I am using the codeblock version; as I said earlier, I still have to launch WorldServer via the debugging function of CodeBlocks, just like someone else posted in that very thread - otherwise it crashes.
Are you sure about that total that should be 100000? I'm asking for 2 reasons,
first, some other guy said "whatever anyone says, it doesn't have to add up to 100000 or any total, it is just made easy for us to convert to percentages", and I get the idea.
Second, I just finished entering a query that permitted me to change the whole new_drops database, I basically did that :
chance100 = CASE WHEN chance100 <= 0 THEN chance100
WHEN chance100 < 10 THEN chance100 * 100
WHEN chance100 < 20 THEN chance100 * 80
WHEN chance100 < 50 THEN chance100 * 50
WHEN chance100 < 100 THEN chance100 * 30
WHEN chance100 < 200 THEN chance100 * 10
WHEN chance100 < 400 THEN chance100 * 2
WHEN chance100 <4000 THEN chance100
WHEN chance100 <8000 THEN chance100 / 2
ELSE chance100 / 4
for all "chanceN" columns.
And so far, the tests show the mobs finally drop some equipables. No error for now. I can imagine a side issue if the totals HAVE to be 100000; if my current total is inferior, sometimes the mob won't drop when it is supposed to, if the total is superior, then some drops will never drop...??
For the last rose version you're talking about, what are the differences? Because from my poor and little point of view for now, I have :
+ I finally managed to change some UI elements,
+ all working fine, except :
- the HP and MP seem often incorrect, on me and on mobs.
- gotta check that the 100000 total is respected,
- gotta change the skills to improve them / change them to those nice NArose skills,
- gotta rise backpack size (should be easy and done in next 30 minutes),
- gotta rise the time drops stay on the floor.