Import item_db_re sql into database for SQL Mall Script.

[dannsatriow]

can someone make a tutorial to import the item_db_re sql into database? because my script only got jellopy. thanks for answer.

[Psy Ops]

Are you referring to the sql injection via sql query? 

[Emistry]

spend a minutes to search on forum or google or wiki could have gotten you the answers..

 

[dannsatriow]

On 9/15/2019 at 3:02 PM, Psy Ops said:

Are you referring to the sql injection via sql query? 

No I just want to import .sql db to my database just like emistry said, but fail.

On 9/15/2019 at 8:14 PM, Emistry said:

spend a minutes to search on forum or google or wiki could have gotten you the answers..

Thanks emistry. yes I know how to import like this. , but when I'am using your SQL Mall script, I got only jellopy. Here my database. am I doing something wrong when import .sql? I think is imported right? 

Do I have to create a new table for the sql mall script work?

many thanks for answer it.

Ada yang bisa pakai script dari Emistry yang SQL mall? saya sudah coba import sql ke database tapi hasilnya cuma jellopy saja. mohon bantuanya.

 

Edited September 16, 2019 by dannsatriow

[Emistry]

either you are not using the correct script or you are not connecting to the correct db

[dannsatriow]

On 9/16/2019 at 11:55 PM, Emistry said:

either you are not using the correct script or you are not connecting to the correct db

Thankyou, I think I have connected to the correct database, because I see all my char there and I can edit them directly from table in database. There might be an error in your SQL MALL script when selecting a table from the database, I use renewal system. here your script

 

1.  OnLoad:
2.         .@type = getarg(0, -1);
3.         .@npc = 1;
4.        
5.         .@sql$ = "SELECT `id`, `weight`, `" + (.is_renewal_db ? "atk:matk" : "attack") + "`, `slots`, `weapon_level`, `defence`, `equip_level`, `script`, `equip_script`, `unequip_script` "
6.             + "FROM `" + (.is_renewal_db ? "item_db_re" : "item_db") + "` "
7.             + "WHERE `type` = "+.@type;
8.         if (.blacklist_item$ != "")
9.             .@sql$ = .@sql$ + " AND `id` NOT IN ("+escape_sql(.blacklist_item$)+")";
10.         .@sql$ = .@sql$ + " ORDER BY `name_english`";

 

+ "FROM `" + (.is_renewal_db ? "item_db_re" : "item_db") + "` " this line selecting item_db_re becauce is_renewal_db right? I try to learn it. it should be right but why only jellopy appears?