Jump to content
  • 0

Import item_db_re sql into database for SQL Mall Script.


dannsatriow

Question


  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  13
  • Reputation:   0
  • Joined:  08/01/18
  • Last Seen:  

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

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  70
  • Reputation:   0
  • Joined:  06/19/18
  • Last Seen:  

Are you referring to the sql injection via sql query? 

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

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

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  13
  • Reputation:   0
  • Joined:  08/01/18
  • Last Seen:  

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.Capture.thumb.PNG.57b76ecdb358e713a4e3b31540e3cf94.png.3f72ab312c8114afe0d1a0508aefd02a.png

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 by dannsatriow
Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  13
  • Reputation:   0
  • Joined:  08/01/18
  • Last Seen:  

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...