Items Disappear !

[shiref6]

Hey Guys here is my problem ..

after i open server or any of my friends and getting items every thing is fine but after reloging we can see our stuff in log screen but in game we are naked :junglejane:
and yes we cleaned our inventory's so if somone would tell me fix ill be some glad
or contact me through skype shiref.adil1






Peace .

 

[Kallyanna]

change your data base server

 

[shiref6]

any recommended one ?

 

[CompaQ]

Try it on another char maybe work,If didn't work change ur database server to clean.

 

[PerfektFA2]

Did you do the part right before step 3 in this guide? This was the only time i ever had that problem is when i did not design the table....


http://forum.ragezone.com/f554/tutorial-server-setup-guide-using-209151/

 

[shiref6]

yes i did but i believe that this error might be cuased by stored pro

 

[MajorIG247]

i got the problems many times be4 but it was fixed after i changed the datebase

 

[Kallyanna]

AH what db are u using n what data base server? more to the point.. which re-pack?

 

[shiref6]

am using NationKal Repack ~ clean dbsvr.exe and clean db beacuse server db didint work on sql2000

 

[TranX1337]

yea got this problem also, it is in the database, u do not have to restore the complete DB, i fixxed it directly in the DB, not sure how, long time ago. just try to fix it on our own way to restore db path by db path. gl

 

[shiref6]

guys would somone upload me db with done stored pro because i get the script but every time i try to add it i get like invalid name ~ wrong use if smth and more of these errors

 

[ToF]

item table -> edit table -> change "Info" datatype to "bigint", then restart dbsvr and mainsvr.

 

[shiref6]

item table -> edit table -> change "Info" datatype to "bigint", then restart dbsvr and mainsvr.

i dont get it please can you clear it ?

 

[ToF]

i dont get it please can you clear it ?

open ms sql management studio

go to kal_db and find the "Item" table.

rightclick on the table and click "edit table".

there you will find a list of item related stuff,
find "Info" in the list and change the datatype to "bigint".

then exit and make sure you save changes, then just to be sure restart the server.

 

[shiref6]

thanks for trying to help bro but am using sql2000 and these options isnt there ^^

 

[ToF]

thanks for trying to help bro but am using sql2000 and these options isnt there ^^

its basically the very same thing, only it's not called management studio in 2000

 

[shiref6]

if you would like to help me using teamviewer add me on skype shiref.adil1 beacuse i cant find what do you say

 

[MajorIG247]

its basically the very same thing, only it's not called management studio in 2000

in ur sql server/kal_db/item table right click and then Desgin if u cant find edit table if i no wrong

 

[shiref6]

problem solved
Thanks Goes To ToF