major prob (database on 1.9)

Play Now

koni

V.I.P
VIP
Mar 14, 2006
1,111
1
165
Southampton UK
hello peeps,

i need your help with a rather large prob were having on bandet server

for some reason items that were putting in the database are somehow going into peoples storage, so obviously this is a major prob for us as rare items are being dumped into peoples stores without them gaining them through hunting and drops, has anyone else had this prob and how did you solve it ?

for example a blade that you can only gain through gamepoints was in a noobs store, and other peeps have got kit that only drops from the hardest mob ingame and no way are the people that have got these items killing that boss.

any help would be appreciated

cheers

koni
 

lifco

Untrusted Member
Legendary
Golden Oldie
Loyal Member
Jul 6, 2004
3,400
66
175
UK/Italy
this is coz you are adding items wile the server is online,
and also mate you are adding them to the database wrong... when adding new items to the database all you do is go to the bottom of the list and push the down arrow key (on your keybord) this will create a new line to add you item

(EDIT)
Adding this way is fine wile the server is online

lif
 
Last edited:
Upvote 0

thedeath

LOMCN Developer
Developer
Mar 26, 2003
1,389
123
289
some reasons why this could happen:
- you got port 6000 open to public so ppl can simply tell dbserver to do this
- there's cheats build into the chinese 1.9 emu files that allow this (i know there's cheats build in similar to this but i dont know exactly about storage)
- you 'reused' an old item id number (aka deleted an item from your stditems db and now added a new item wth the same id number as the old one), mir server stores the id number not the whole item
so when you delete an item from stditems it's not gone from ppl's storage it's just resting there till you add a new item with same id
 
Upvote 0

lifco

Untrusted Member
Legendary
Golden Oldie
Loyal Member
Jul 6, 2004
3,400
66
175
UK/Italy
some reasons why this could happen:
- you got port 6000 open to public so ppl can simply tell dbserver to do this
- there's cheats build into the chinese 1.9 emu files that allow this (i know there's cheats build in similar to this but i dont know exactly about storage)
- you 'reused' an old item id number (aka deleted an item from your stditems db and now added a new item wth the same id number as the old one), mir server stores the id number not the whole item
so when you delete an item from stditems it's not gone from ppl's storage it's just resting there till you add a new item with same id


dont post when you dont know what you are talking about, i have said why this is happening

lif
 
Upvote 0

thedeath

LOMCN Developer
Developer
Mar 26, 2003
1,389
123
289
lol i wasnt gonna bother replying but
i do know what i'm talking about, all 3 reasons i posted are valid and i have had past experience to proof they are true
i'm not saying that they might be the reason why he has this now but what i'm saying is that i'm 100% sure each of these 3 situations 'excist' (can be recreated) so they could be alternative reasons as to why he has this problem, obviously your solution is more likely to be the right one but that doesnt mean it's the only one
 
Upvote 0

lifco

Untrusted Member
Legendary
Golden Oldie
Loyal Member
Jul 6, 2004
3,400
66
175
UK/Italy
yes true but you did not read what koni said, he said when adding items somehow they are going into peoples storage

lif
 
Upvote 0

koni

V.I.P
VIP
Mar 14, 2006
1,111
1
165
Southampton UK
k,

1).when we add items we do press the down arrow in the db at the bottom then add the new details in but have to put the next number in after the last item

2).were not going over other items as i know this is stupid anyway as it would replace that item ingame

3).our port 6000 is not open to the public as far as iam aware

4).we havnt reused any item id numbers.

5).and yes they are being added when serv is live and then being reloaded ingame, so thats prob why its happening
 
Upvote 0

lifco

Untrusted Member
Legendary
Golden Oldie
Loyal Member
Jul 6, 2004
3,400
66
175
UK/Italy
iam 100% sure on this, its the way you are adding them items to the db mate

i know this coz lets say you have 600 items in your item db

and the last one IE 600 is say a gmblade.. so you add a new item say gmhelmet whats happening is anyone with the last item IE the gmblade and coz you have just added a new item making it 601 that items changes to the new item gmhelmet

so peeps in game who had the gmblade will now have a gmhelm instead

i hope this is making sence

so to stop this is like i said

go to the last item name click it so its blue and press down arrow key on the keyboard so it makes a new line to put your new item in

you know what items peeps are geting ? i bet its like i said they will be geting the second to the last item

lif
 
Last edited:
Upvote 0

LegendOfMir

LOMCN N00B +1
Veteran
No u all rong!!! The problem is only 1!!! All the clients can use ur F12 cheat to become Gm and use @make ...blablabla... The F12 cheat are the same i can use at DM2 , 1,4 ...mir3 or more.. Is on #page(i dont say wich 1 is) and u can write " @make skyslayer "for example, and i can find in my baggage this item. I dont explain to much here coz i was warning by banning so think about this!!! here is the big probl.!! Bye to all!!;) :tongue1:
 
Upvote 0

lifco

Untrusted Member
Legendary
Golden Oldie
Loyal Member
Jul 6, 2004
3,400
66
175
UK/Italy
No u all rong!!! The problem is only 1!!! All the clients can use ur F12 cheat to become Gm and use @make ...blablabla... The F12 cheat are the same i can use at DM2 , 1,4 ...mir3 or more.. Is on #page(i dont say wich 1 is) and u can write " @make skyslayer "for example, and i can find in my baggage this item. I dont explain to much here coz i was warning by banning so think about this!!! here is the big probl.!! Bye to all!!;) :tongue1:


lmao

20 chars

lif
 
Upvote 0

koni

V.I.P
VIP
Mar 14, 2006
1,111
1
165
Southampton UK
No u all rong!!! The problem is only 1!!! All the clients can use ur F12 cheat to become Gm and use @make ...blablabla... The F12 cheat are the same i can use at DM2 , 1,4 ...mir3 or more.. Is on #page(i dont say wich 1 is) and u can write " @make skyslayer "for example, and i can find in my baggage this item. I dont explain to much here coz i was warning by banning so think about this!!! here is the big probl.!! Bye to all!!;) :tongue1:


ok................... lol thanks for that one
 
Upvote 0