GM Shop

[Yoh Asakura 9]

Hello,

 

I would like to ask if someone could make this script to me.

 

How it works?

This npc will be available only for GM's above group_id 60. Gm's can purchase items, like the NPC Quest Shop, but here they can purchase for free, however, in order to get the item they first need to tell a reason why they are picking that item. And this will be recorded in SQL, with the 'char name', 'time', 'chosen item', 'reason'.

 

I believe that with this kind of NPC the administrators can control more what GM's are using for Events and see those who are just trying to get items for themselves.

 

 

[Yoh Asakura 9]

nobody? t_t

[Emistry 144]

something like this I guess.

http://upaste.me/r/074dfa

 

i didnt test the script, just simply sketch one.

[Yoh Asakura 9]

It's not working so well...

 

When I try to put the reason it appears a debug on SSH.

 

"Unknown column list"

[Emistry 144]

change

query_sql( "INSERT INTO `gm_shop_log` ( `account_id`,`char_id`,`name`,`item`,`reason`,`time` ) VALUES ( "+getcharid(3)+","+getcharid(0)+",'"+strcharinfo(0)+"','"+@bought_quantity[0]+"x "+getitemname( @bought_nameid[0] )+"',"+.@reason$+",NOW() ) " );

into

query_sql( "INSERT INTO `gm_shop_log` ( `account_id`,`char_id`,`name`,`item`,`reason`,`time` ) VALUES ( "+getcharid(3)+","+getcharid(0)+",'"+strcharinfo(0)+"','"+@bought_quantity[0]+"x "+getitemname( @bought_nameid[0] )+"','"+.@reason$+"',NOW() ) " );

[Yoh Asakura 9]

 

 

change

query_sql( "INSERT INTO `gm_shop_log` ( `account_id`,`char_id`,`name`,`item`,`reason`,`time` ) VALUES ( "+getcharid(3)+","+getcharid(0)+",'"+strcharinfo(0)+"','"+@bought_quantity[0]+"x "+getitemname( @bought_nameid[0] )+"',"+.@reason$+",NOW() ) " );

into

query_sql( "INSERT INTO `gm_shop_log` ( `account_id`,`char_id`,`name`,`item`,`reason`,`time` ) VALUES ( "+getcharid(3)+","+getcharid(0)+",'"+strcharinfo(0)+"','"+@bought_quantity[0]+"x "+getitemname( @bought_nameid[0] )+"','"+.@reason$+"',NOW() ) " );

Okay, I've changed and now I can put the reason, but if I try to use the npc for the 2nd time, when I put the reason appears an error.

 

[Emistry 144]

http://upaste.me/r/1076a1

[karazu 33]

This NPC is a good one.. 

[Yoh Asakura 9]

http://upaste.me/r/1076a1

You've changed the SQL Table...now I get this error on my database when I try to create the table:

 

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTO_INCREMENT, `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `char_' at line 2

Edited May 28, 2015 by Yoh Asakura

[Emistry 144]

http://upaste.me/r/2bd19c

[Yoh Asakura 9]

http://upaste.me/r/2bd19c

It's working now. Great!

 

Thank you so much for the help.

Edited May 29, 2015 by Yoh Asakura

[koko24 1]

im getting error

 

http://prntscr.com/7c0n6x

[karazu 33]

I think its better if you will just let the GM Type the item that he/she wants.

Ex:

Item ID /  Quantity  / Reason

[Yoh Asakura 9]

I think its better if you will just let the GM Type the item that he/she wants.

 

Ex:

 

Item ID /  Quantity  / Reason

 

 

No, I prefer to make a shop so they can choose, is more easy.

im getting error

 

http://prntscr.com/7c0n6x

 

 

Change this line

-	shop	gm_shop_npc	-1,607:1,608:2,

 

to this

 

-	shop	gm_shop_npc	-1,607:1,608:2

 

After the last item ID you can't use ','

Edited June 3, 2015 by Yoh Asakura

[Yoh Asakura 9]

@@Emistry

I've just tested here and if I buy more than 1 item I will only receive the 1st item that I put to purchase and on SQL will only appear the 1st item too...

Edited June 8, 2015 by Yoh Asakura

[Emistry 144]

create a loop...and loop through all the items.

[Yoh Asakura 9]

@@Emistry

I really don't know how to do it, xD

 

Could you show me an example so I can follow?

Edited June 10, 2015 by Yoh Asakura