Can anyone help me with deleting?

07/09/2011 03:01 piratehat2#1
Does anyone know how to delete an item (that you have not entered with Silent Bills Merchant Modder?)

Example: i want to delete the all the items from the "Pet Card NPC" or the empty string pet card person


EDIT: is there anyway to add you own items to the Silent Bills Merchant Modder Program?
07/09/2011 03:26 piratehat2#2
Quote:
Originally Posted by speedy-nl View Post
db/marktresource

crushop_equip, sels cs deco stuff

crushop_etc, sell cs stuff like ss, cc, respec pots

Creature_card, like the name say sell e-cards
can you expand on that

im in telecaster > marketresourse but i dont see those npc's and if i did see them i still wouldn't know how to delete the items from Creature_card
07/09/2011 03:37 piratehat2#3
Quote:
Originally Posted by speedy-nl View Post
first change the edit 200/500? to 1000-2000
possible noob question here you have ben warned

how do i do that :D :p
07/09/2011 03:40 piratehat2#4
Quote:
Originally Posted by speedy-nl View Post
reading is hard aint it
sorry i see it now i had a noob moment :D
07/09/2011 04:01 RoflcopterGoesSoiSoiSoi#5
sql server management studio
ctrl+n

Code:
use
arcadia
go

select * from marketresource where name like '%creature%'
LIKE regex is your friend
07/10/2011 19:32 Cieldaron#6
Quote:
EDIT: is there anyway to add you own items to the Silent Bills Merchant Modder Program?
Yeah, it's easy.

If you use his 4.7-SBMM, open the ItemList.xml via right mouse click -> edit/ open it with a text editor e.g. notepad and edit the lines.

There are some categories (e.g. items, weapons, armors, deco and so on).

For a new item use this basic code:


<Item_Category>
<Code>Item_ID</Code>
<Name>Item_Name_in_SBMM_dropdown_menu</Name>
</ItemCategory>


This is it.
/end_spamming_colors (;p)

These are the IDs for the categories:

The Item-IDs:
[Only registered and activated users can see links. Click Here To Register...]
Scroll down to Makenci's spoilers.

Choose a good name for the item's name in the dropdown menu.
07/10/2011 20:07 piratehat2#7
Quote:
Originally Posted by Cieldaron View Post
Yeah, it's easy.

If you use his 4.7-SBMM, open the ItemList.xml via right mouse click -> edit/ open it with a text editor e.g. notepad and edit the lines.

There are some categories (e.g. items, weapons, armors, deco and so on).

For a new item use this basic code:


<Item_Category>
<Code>Item_ID</Code>
<Name>Item_Name_in_SBMM_dropdown_menu</Name>
</ItemCategory>


This is it.
/end_spamming_colors (;p)

These are the IDs for the categories:

The Item-IDs:
[Only registered and activated users can see links. Click Here To Register...]
Scroll down to Makenci's spoilers.

Choose a good name for the item's name in the dropdown menu.
yeah i had the idea in my head when i posted the thread but i wasnt sure if it worked then tried it and it worked ;)...

ty for the item list btw its huge haha

BTW: i ran into a problem when adding growth pots it causes the program to not work
07/11/2011 01:26 Cieldaron#8
Then you've forgotten any of the >, <, /.

Or you typed in the wrong item ID for the growth potion.
I made the same mistake and SBMM stopped working. (:
I forgot a 0, the result was a SBMM-crash.

Yeah, nvm, but credits go to Makenci for his two lists. ;)