Clean checkout to SQL database bugs

[sietse11]

Hey I just did a  clean check out from the git repository.

 

And I got the following errors after enabling SQL database.

Some sql files I imported with a re value now create a table with a re value where they used to drop the re

example;

 

BUG1

item_db2_re used to create the table item_db2 now it creates the table item_db2_re

resulting in the following error.

[SQL] DB error - Table 'ragnarok.item_db2' doesn't excist
[DEBUG] at ..\src\map\itemd.c:1444 - select * from 'item_db2'

I want to fix this by editing the sql file to state 'drop table if excist item_db2_re -- create table item_db2

If I am right this will remove the faulthy item_db2_re table and recreate the table as item_db2. Effectively removing the bug while keeping the renewel settings.

 

would this assumption be a correct fix with no future problems? Or does the current git release need to be followed up with an update?

 

BUG2

[ERROR]:
script error on item_db_re line 5783
unexpected end of script
* 5783 : if < checkmadogear<> > <itemheal rand<200,300>,0;

same error for lines 5784 and 5785 with <itemheal rand<*,*>,0; displaying 300,400 and 400,500 in that order.

Now I tried finding items 5783-5 do not seem to be the right items. So ill have to check that with notepad++.

I am going to fix this by finding the items in item_db_re.sql

 

BUG3

[SQL] DB error - Table 'ragnarok.mob_db2' doesn't excist
[DEBUG] at ..\src\map\moc.c:3958 - select * from 'mob_db2'

I am asuming the sql file did the same as in bug1

[SQL] DB error - Table 'ragnarok.mob_skill_db2' doesn't excist
[DEBUG] at ..\src\map\mob.c:4460 - select * from 'mob_skill_db2'

bug 1 again?

 

 

 

Did I miss something in the update sql's?

Or do I simply need to make a change in inter_athena.conf?

Was making some video tuto's when I came across this stuff, the few visitors I have wont be pleased XD.

Also posted in wrong section I presume.

Bug 1 and 3 fixed by making changes to inter_Athena.conf. for some reason "// Map Database Tables" had those db's quoted. and for some reason had 4 more entries then the same file on ma test server. I can only asume thats because of the different versions of visual studio im using between my test server and live server.