[Help Thread] Please post your questions here.

c1ph3r · 05/25/2012, 18:46

Quote:

Originally Posted by Dj Crime

URGENT!!!

Hi

Can someone please help me where i can find a button or rider to start a thread??
I'm a new member on this page and i have a very urgent question but i couldn't find a way to start a new thread for my question.
It's very urgent and i need some answers today. If not, probably i'll lose a lot of money!!

Thanks in advance...

All i wanted to say is that there is no need to open a new thread. You can ask your very urgent question here.

Otherwise there is a button called "New Topic" ...

So ich denke mal du sprichst auch deutsch. Es war kein Angriff sondern sollte als Hilfe gedacht sein. Wenn du nicht so gut englisch sprichst, fällt es dir sicher leichter dein Problem auf Deutsch zu schildern oder? Mehr wollte ich damit nicht aussagen!

Darüber hinaus wird es hier nicht gerne gesehen, wenn man zu jedem Problem einen neuen Thread eröffnet, dafür wurde die Hilfesektion eingerichtet! Daher meinte ich, dass du deine wichtige Frage hier stellen sollst, damit du auch kein geflame als Antwort erhälst!

So denke "New Topic" Button oder "Neues Thema" sollte dir helfen... Ist sowohl über der Liste mit den Themen wie darunter...

@pprfds

There is no tool public to open the rdb-Files. You have to write your own tool. Search through the forum there are a lot of threads about how to read the files.

c1ph3r · 05/25/2012, 19:29

Quote:

Originally Posted by Casval776

I feel like a huge jackass for asking this but I'm getting the simplest error when trying to restore my database.
When I try to restore, it gives me an "Unable to cast" error and won't populate any fields. When I try to look at the backup, it's coming up as null. I've tried this with about 3-4 backups and none of them work. Is SQL '08 R2 still the version being used?

Try these Backups.

Casval776 · 05/26/2012, 15:01

Quote:

Originally Posted by c1ph3r

Try these Backups.

Back again. The backups worked, thank the ******* Lord. However, I've run into another issue and I'm not quite sure how to approach this.
Everything works. Game server is up, opt files are configured correctly. I can connect to the server and create a character, however, the problem starts when I try to enter the game with my new character. The game crashes and Herlock gives me this error:

Index 'IDX_Item_Account_Id_Owner_Id_Auction_Id_Keeping_I d' on table 'dbo.item' (specified in the FROM clause) does not exist.

Did some sneaking around in the database and found the table. The sid for my character isn't in the table. Naturally I just editted the first row I found but that still didn't fix the problem. Tried to just empty the entire table and start fresh, thinking it would repopulate but that didn't fix it either. I also tried emptying both tables to have them repopulate when I made a new character, no success with that either. Lastly, I figured the first character I made would have a sid of 1 and the item table, for some reason, starts counting from 2. So I made 3 characters on the same account to have the sid's sync up somewhere. Didn't work with any of them.

I'm out of ideas. Suggestions?

medom100 · 05/26/2012, 20:35

hey guys i have gm permission and why i cant make codes ?

ghost_h · 05/28/2012, 06:22

i need item IDs:Necklace,ring,earring,have set effects, could someone help me?

c1ph3r · 05/28/2012, 09:33

Quote:

Originally Posted by ghost_h

i need item IDs:Necklace,ring,earring,have set effects, could someone help me?

Spoiler

Don't know if these are all IDs.

₡ĦŘǾ₥£ · 05/28/2012, 13:46

hi guys i have a little old problem witch is the server doesn't load up in servers list idk why

i did all things fine and i got no errors when i open PrincessAuroraServer & CaptainHerlockServer

tried to search but most of the problems have ****** the gs.opt witch i didn't
thanks in advance

ghost_h · 05/28/2012, 20:38

Quote:

Originally Posted by ghost_h

i need item IDs:Necklace,ring,earring,have set effects, could someone help me?

Quote:

Originally Posted by c1ph3r

Spoiler

¾Æ³Ý»çÀÇ ¿*¸Á<·¹Àü´õ¸® ¼¼Æ®1> 437101
¸µ ¿Àºê ¿î´ÙÀÎ<·¹Àü´õ¸® ¼¼Æ®2> 437102
±Û·ç¹Ì ¼¼ÀÌ·»<·¹Àü´õ¸® ¼¼Æ®5> 437105
¸µ ¿Àºê ¹ß´õ½º<·¹Àü´õ¸® ¼¼Æ®6> 437106
´ëÁöÀÇ ¼øÈ¯<·¹Àü´õ¸® ¼¼Æ®7> 437107
¶ó¹Ì¾ÆÀÇ ¼Õ±æ<·¹Àü´õ¸® ¼¼Æ®8> 437108
Sorrow of Anessa 427201
Grief of Endairon 427202
Despair of Silairon 427203
Melancholy of Salam 427204
Argoth's Fury 427205
Earrings of Marbas 427206
Azurebeam Earrings 427207
Tears of Lamia 427208
Soul of Raksasi<Legendary set9> 427209
Piece of Rudra<Legendary set10> 427210
Earing of Sylph<Legendary set3> 437103
Ring of Salamander<Legendary set4> 437104
Angel of Rakasi<Legendary set9> 437109
Ring of Rudra<Legendary set10> 437110

Don't know if these are all IDs.

oh...it is not my need,but thx!!

could one give me all the skill cards in 7.3...it too much...
OMG!!!

c1ph3r · 05/28/2012, 22:42

use [Arcadia]

SELECT STRING.[value], ITEM.[id]
FROM [ItemResource] ITEM, [StringResource] STRING
where STRING.[code]=ITEM.[name_id] and ITEM.[group]=10 and ITEM.[enhance] = 0

Spoiler

Opening · 05/28/2012, 23:25

And i have another silly question....in db infiniti no GM comands , i have download it...but i can't write with yellow color in chat..please help
Sorry for my english

In what line should I put the money in the start?
In on_first_login.lua

emekpc · 05/29/2012, 14:03

Hi, everone.
i have a problem. my arcadia fixed all quest by me, thanks infinite for base released db. a problem still not fixed.
King of steel quest’s material item combination was not possible

if any body help me, i am very happy

OK... Im fixed

ghost_h · 05/30/2012, 11:56

i need commonds:+1--- +5 tamed pets,could some nice guy help me?

c1ph3r · 05/30/2012, 14:25

Syntax:

Code:

/run insert_item(PET_ID, 1, STAGE, 0, -2147483648,CHAR_NAME)

Example:

Code:

/run insert_item(540001, 1, 5, 0, -2147483648,"Anonymous")

This will give a stage 5 Ent to the player Anonymous

Notice:

Petdura is 0 if you insert a pet via gm command.

BlueConnect · 05/30/2012, 21:20

c1ph3r -> u was be a helpfully man :P
can u help me ?

with my problem ...
Thanks

c1ph3r · 05/31/2012, 08:39

I can try to help but you have to tell me your problem

I can't look into your head :P