Jump to content
  • 0

Help me in Personal Scavenger


Question

Posted

Im using this script jTynne Personal Scavenger Script 

 

http://jtynne.com/rAthena/scripts/examples/personalscavenger.txt

I encounter this problem How to solve this? :(

 

[SQL]: DB error - INSERT command denied to user 'ragnarok'@'ADRIAN-PC' for table 'scavenger'
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - insert into `game_data`.`scavenger` (`char_id`,`score`,`completed`,`failed`,`alltimescore`,`alltimecompleted`,`alltimefailed`) VALUES ('150004', '0', '0', '0', '0', '0', '0')
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[SQL]: DB error - SELECT command denied to user 'ragnarok'@'ADRIAN-PC' for table 'scavenger'
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - select game_data.scavenger.score AS score , game_data.char.name AS charname FROM game_data.scavenger, game_data.char WHERE game_data.scavenger.char_id = game_data.char.char_id ORDER BY game_data.scavenger.score DESC LIMIT 10
[Debug]: Source (NPC): Scavenger Rankings at quiz_02 (366,346)
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `score` = `score` + '1' WHERE `char_id` =  '150004'
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `alltimescore` = `alltimescore` + '1' WHERE `char_id` =  '150004'
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `completed` = `completed` + '1' WHERE `char_id` =  '150004'
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `alltimecompleted` = `alltimecompleted` + '1' WHERE `char_id` =  '150004'
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[SQL]: DB error - SELECT command denied to user 'ragnarok'@'BLOODLINE-PC' for table 'scavenger'
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - select game_data.scavenger.score AS score , game_data.char.name AS charname FROM game_data.scavenger, game_data.char WHERE game_data.scavenger.char_id = game_data.char.char_id ORDER BY game_data.scavenger.score DESC LIMIT 10
[Debug]: Source (NPC): Scavenger Rankings at quiz_02 (366,346)

 

 

3 answers to this question

Recommended Posts

Posted (edited)

Go to your MySQL administration tool and give your 'ragnarok' user SELECT, INSERT, UPDATE and DELETE permissions for the `scavenger` table and you'll be good to go.

Edited by jaBote
Posted
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist

 

you didnt have the scavenger sql table ....ask Jtynne for that SQL table since he didnt included the table in his script..

Posted
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist

 

you didnt have the scavenger sql table ....ask Jtynne for that SQL table since he didnt included the table in his script..

 

Is there a way how I can make a SQL for that?

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...