[Help Thread] Please post your questions here.

i know but how do i distribute the item to all accounts in the storage at once?

Use a wildcard %

where account_id = '%'

all account_id's will be included in that query

nulled

how can i store the chat_log and log_bin record in db?

what is the problem and how to solve it ?

[Only registered and activated users can see links. Click Here To Register...]

IDK I am not going to download a .rar file and try to figure out what you are asking here.

You should probably make your question a little more evident.

any help for this ===>

Quote:

Originally Posted by thund22222 how can i store the chat_log and log_bin record in db?

Quote:

Originally Posted by thndr IDK I am not going to download a .rar file and try to figure out what you are asking here. You should probably make your question a little more evident.

this is the problem

Quote:

Code: 16 bytes starting at (RIP = 000000004021C142) 4021C142: 48 8B 07 48 8B CF F3 44 0F 11 44 24 60 F3 0F 11 H..H...D..D$`... Stack: 1024 bytes starting at (RSP = 000000005E0AF070) 5E0AF070: 01 00 66 5B 00 00 00 00 FF FF FF FF 00 00 00 00 ..f[............ 5E0AF080: 59 91 02 00 0B 5E 00 00 00 00 00 00 00 00 00 00 Y....^.......... 5E0AF090: 01 FF FF FF FF FF FF FF 00 00 00 00 01 00 00 00 ................ 5E0AF0A0: 00 00 00 00 00 00 00 00 00 1E D3 01 00 00 00 00 ................ 5E0AF0B0: 00 00 00 00 00 00 00 00 58 F8 0A 5E 00 00 00 00 ........X..^.... 5E0AF0C0: 69 61 24 48 E1 58 BC 46 00 00 00 00 2A 31 CD BE ia$H.X.F....*1.. 5E0AF0D0: 58 F8 0A 5E 00 00 00 00 4C 3E 02 40 01 00 00 00 X..^....L>.@.... 5E0AF0E0: 00 F1 0A 5E 00 00 00 00 C0 1A D6 01 00 00 00 00 ...^............ 5E0AF0F0: 53 F8 0A 5E 00 00 00 00 00 00 00 00 00 00 00 00 S..^............ 5E0AF100: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E0AF110: 00 00 00 00 00 88 C3 40 00 00 00 00 00 00 00 00 .......@........ 5E0AF120: 00 00 40 41 00 00 00 00 00 00 00 00 00 00 00 00 ..@A............ 5E0AF130: DE DD 05 43 00 00 00 00 00 00 00 00 00 00 00 00 ...C............ 5E0AF140: 1E C9 69 44 00 00 00 00 00 00 00 00 00 00 00 00 ..iD............ 5E0AF150: 8F EF 05 43 00 00 00 00 00 00 00 00 00 00 00 00 ...C............ 5E0AF160: 8E D3 69 44 00 00 00 00 00 00 00 00 00 00 00 00 ..iD............ 5E0AF170: 01 00 00 00 00 00 00 00 28 8B 05 00 00 00 00 00 ........(....... 5E0AF180: 40 A0 66 5B 00 00 00 00 00 00 00 00 00 00 00 00 @.f[............ 5E0AF190: 00 00 00 00 00 00 00 00 30 90 2D 06 00 00 00 00 ........0.-..... 5E0AF1A0: 00 00 00 00 00 00 00 00 6E F2 22 40 01 00 00 00 ........n."@.... 5E0AF1B0: 27 77 8B 00 00 00 00 00 10 00 00 00 00 00 00 00 'w.............. 5E0AF1C0: 03 00 00 00 00 00 00 00 88 9F 66 5B 00 00 00 00 ..........f[.... 5E0AF1D0: F8 02 C7 01 00 00 00 00 4F FB 01 40 01 00 00 00 ........O..@.... 5E0AF1E0: 05 00 00 00 FF FF FF FF 70 00 00 00 00 00 00 00 ........p....... 5E0AF1F0: 59 00 32 05 61 1D 00 00 60 E5 C9 01 00 00 00 00 Y.2.a...`....... 5E0AF200: 60 C8 23 5F 00 00 00 00 B0 62 24 5F 00 00 00 00 `.#_.....b$_.... 5E0AF210: FE FF FF FF FF FF FF FF 6F 1C 38 40 01 00 00 00 ........o.8@.... 5E0AF220: 94 1C D3 01 00 00 00 00 82 B4 00 40 01 00 00 00 ...........@.... 5E0AF230: 00 00 00 00 00 00 00 00 01 00 00 00 00 00 00 00 ................ 5E0AF240: 94 1C D3 01 00 00 00 00 82 B4 00 40 01 00 00 00 ...........@.... 5E0AF250: A0 00 00 00 00 00 00 00 FE FF FF FF FF FF FF FF ................ 5E0AF260: 80 F2 0A 5E 00 00 00 00 40 1A D6 01 00 00 00 00 ...^....@....... 5E0AF270: 56 AF 61 00 00 00 00 00 FE FF FF FF FF FF FF FF V.a............. 5E0AF280: 00 00 00 00 00 00 00 00 93 B2 05 40 01 00 00 00 ...........@.... 5E0AF290: C0 D9 81 25 00 00 00 00 00 00 00 00 00 00 00 00 ...%............ 5E0AF2A0: 30 56 42 40 01 00 00 00 10 00 00 00 00 00 00 00 0VB@............ 5E0AF2B0: FE FF FF FF FF FF FF FF B0 F4 0A 5E 00 00 00 00 ...........^.... 5E0AF2C0: 30 8E F4 61 00 00 00 00 00 00 00 00 00 00 00 00 0..a............ 5E0AF2D0: 30 90 2D 06 00 00 00 00 CA 11 1F 40 01 00 00 00 0.-........@.... 5E0AF2E0: 85 00 00 00 00 00 00 00 E6 18 1F 40 01 00 00 00 ...........@.... 5E0AF2F0: 85 00 00 00 00 00 00 00 99 BA 00 40 01 00 00 00 ...........@.... 5E0AF300: FE FF FF FF FF FF FF FF 00 00 00 00 00 00 00 00 ................ 5E0AF310: 30 90 2D 06 00 00 00 00 30 90 2D 06 00 00 00 00 0.-.....0.-..... 5E0AF320: 00 00 00 00 00 00 00 00 88 9F 66 5B 00 00 00 00 ..........f[.... 5E0AF330: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E0AF340: 28 00 00 00 00 00 00 00 30 22 23 40 01 00 00 00 (.......0"#@.... 5E0AF350: 28 8B 05 00 00 00 00 00 00 00 00 00 00 00 00 00 (............... 5E0AF360: 01 00 00 00 00 00 00 00 85 00 00 00 01 00 00 00 ................ 5E0AF370: A7 03 00 00 00 00 00 00 A7 03 00 00 00 00 00 00 ................ 5E0AF380: 30 56 42 40 01 00 00 00 BC 0B 00 00 00 00 00 00 0VB@............ 5E0AF390: FE FF FF FF FF FF FF FF F0 FD 3E 40 01 00 00 00 ..........>@.... 5E0AF3A0: 78 FA 3E 40 01 00 00 00 30 90 2D 06 00 00 00 00 x.>@....0.-..... 5E0AF3B0: 30 56 42 40 01 00 00 00 17 0B 00 00 A0 A4 B3 04 0VB@............ 5E0AF3C0: C8 F3 0A 5E 00 00 00 00 00 00 00 00 00 00 00 00 ...^............ 5E0AF3D0: 30 56 42 40 01 00 00 00 C0 0B 00 00 A0 A4 B3 04 0VB@............ 5E0AF3E0: E8 F3 0A 5E 00 00 00 00 01 00 00 00 00 00 00 00 ...^............ 5E0AF3F0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E0AF400: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E0AF410: 30 90 2D 06 00 00 00 00 01 00 00 00 00 00 00 00 0.-............. 5E0AF420: 00 00 00 00 00 00 00 00 85 00 00 00 00 00 00 00 ................ 5E0AF430: 08 A9 4D 1A 00 00 00 00 97 B6 08 40 01 00 00 00 ..M........@.... 5E0AF440: 08 A9 4D 1A 00 00 00 00 30 54 20 00 00 00 00 00 ..M.....0T ..... 5E0AF450: E0 F4 0A 5E 00 40 BC 46 E1 58 BC 46 C0 68 24 48 ...^.@.F.X.F.h$H 5E0AF460: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................

Quote:

Code: 16 bytes starting at (RIP = 000000004021C142) 4021C142: 48 8B 07 48 8B CF F3 44 0F 11 44 24 60 F3 0F 11 H..H...D..D$`... Stack: 1024 bytes starting at (RSP = 000000005E08F070) 5E08F070: 01 00 57 5B 00 00 00 00 FF FF FF FF 00 00 00 00 ..W[............ 5E08F080: 42 90 02 00 BC 5B 00 00 00 00 00 00 00 00 00 00 B....[.......... 5E08F090: 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F0A0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F0B0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F0C0: 11 1B 24 48 57 C7 B7 46 00 00 00 00 D6 77 F5 3F ..$HW..F.....w.? 5E08F0D0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F0E0: 00 00 00 00 00 00 00 00 C5 68 04 40 01 00 00 00 .........h.@.... 5E08F0F0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F100: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F110: 00 00 00 00 00 88 C3 40 00 00 00 00 00 00 00 00 .......@........ 5E08F120: 00 00 40 41 00 00 00 00 00 00 00 00 00 00 00 00 ..@A............ 5E08F130: E3 AF 02 43 00 00 00 00 00 00 00 00 00 00 00 00 ...C............ 5E08F140: F5 59 69 44 00 00 00 00 00 00 00 00 00 00 00 00 .YiD............ 5E08F150: B6 20 03 43 00 00 00 00 00 00 00 00 00 00 00 00 . .C............ 5E08F160: 12 65 69 44 00 00 00 00 00 00 00 00 00 00 00 00 .eiD............ 5E08F170: 01 00 00 00 00 00 00 00 11 41 00 00 00 00 00 00 .........A...... 5E08F180: 40 A0 57 5B 00 00 00 00 00 00 00 00 00 00 00 00 @.W[............ 5E08F190: 00 00 00 00 00 00 00 00 20 59 1B 06 00 00 00 00 ........ Y...... 5E08F1A0: 00 00 00 00 00 00 00 00 6E F2 22 40 01 00 00 00 ........n."@.... 5E08F1B0: 27 77 8B 00 00 00 00 00 10 00 00 00 00 00 00 00 'w.............. 5E08F1C0: 03 00 00 00 00 00 00 00 88 9F 57 5B 00 00 00 00 ..........W[.... 5E08F1D0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F1E0: 58 C5 6D 1A 00 00 00 00 C6 5B 06 40 01 00 00 00 X.m......[.@.... 5E08F1F0: 00 00 00 00 00 88 C3 40 00 00 00 00 00 00 00 00 .......@........ 5E08F200: 28 CF EF 7C 00 00 00 00 08 F5 05 40 01 00 00 00 (..|.......@.... 5E08F210: 58 C5 6D 1A 00 00 00 00 9A A1 06 40 01 00 00 00 X.m........@.... 5E08F220: 64 1C D1 01 00 00 00 00 82 B4 00 40 01 00 00 00 d..........@.... 5E08F230: A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F240: 64 1C D1 01 00 00 00 00 82 B4 00 40 01 00 00 00 d..........@.... 5E08F250: 00 00 00 00 00 00 00 00 FE FF FF FF FF FF FF FF ................ 5E08F260: 58 C5 6D 1A 00 00 00 00 C0 CE EF 7C 00 00 00 00 X.m........|.... 5E08F270: 57 86 06 00 00 00 00 00 FE FF FF FF FF FF FF FF W............... 5E08F280: 58 C5 6D 1A 00 00 00 00 C0 CE EF 7C 00 00 00 00 X.m........|.... 5E08F290: D8 88 2D 81 00 00 00 00 00 00 00 00 00 00 00 00 ..-............. 5E08F2A0: 30 56 42 40 01 00 00 00 10 00 00 00 00 00 00 00 0VB@............ 5E08F2B0: FE FF FF FF FF FF FF FF B0 F4 08 5E 00 00 00 00 ...........^.... 5E08F2C0: 30 8E E1 61 00 00 00 00 00 00 00 00 00 00 00 00 0..a............ 5E08F2D0: 20 59 1B 06 00 00 00 00 CA 11 1F 40 01 00 00 00 Y.........@.... 5E08F2E0: 82 00 00 00 00 00 00 00 E6 18 1F 40 01 00 00 00 ...........@.... 5E08F2F0: 83 00 00 00 00 00 00 00 99 BA 00 40 01 00 00 00 ...........@.... 5E08F300: FE FF FF FF FF FF FF FF 00 00 00 00 00 00 00 00 ................ 5E08F310: 20 59 1B 06 00 00 00 00 20 59 1B 06 00 00 00 00 Y...... Y...... 5E08F320: 00 00 00 00 00 00 00 00 88 9F 57 5B 00 00 00 00 ..........W[.... 5E08F330: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E08F340: 28 00 00 00 00 00 00 00 30 22 23 40 01 00 00 00 (.......0"#@.... 5E08F350: 11 41 00 00 00 00 00 00 00 00 00 00 00 00 00 00 .A.............. 5E08F360: 01 00 00 00 00 00 00 00 82 00 00 00 01 00 00 00 ................ 5E08F370: A5 03 00 00 00 00 00 00 A5 03 00 00 09 00 00 00 ................ 5E08F380: 30 56 42 40 01 00 00 00 BC 0B 00 00 06 00 00 00 0VB@............ 5E08F390: 00 00 C0 B6 06 00 00 00 00 00 20 A1 07 00 00 00 .......... ..... 5E08F3A0: 78 FA 3E 40 01 00 00 00 20 59 1B 06 00 00 00 00 x.>@.... Y...... 5E08F3B0: 30 56 42 40 01 00 00 00 17 0B 00 00 6E C7 B7 04 0VB@........n... 5E08F3C0: C8 F3 08 5E 00 00 00 00 01 00 00 00 00 00 00 00 ...^............ 5E08F3D0: 30 56 42 40 01 00 00 00 C0 0B 00 00 6E C7 B7 04 0VB@........n... 5E08F3E0: E8 F3 08 5E 00 00 00 00 00 00 00 00 00 00 00 00 ...^............ 5E08F3F0: 00 00 00 00 00 00 00 00 10 27 00 00 00 00 00 00 .........'...... 5E08F400: FE FF FF FF FF FF FF FF FB 45 38 40 01 00 00 00 .........E8@.... 5E08F410: 20 59 1B 06 00 00 00 00 00 35 0C 00 00 00 00 00 Y.......5...... 5E08F420: 50 20 24 02 00 00 00 00 83 00 00 00 00 00 00 00 P $............. 5E08F430: 20 D0 91 00 00 00 00 00 00 00 00 00 00 00 00 00 ............... 5E08F440: 90 0A 18 02 00 00 00 00 C0 B5 15 01 00 00 00 00 ................ 5E08F450: 40 77 1B 00 00 66 B8 46 57 C7 B7 46 40 13 24 48 @w...f.FW..F@.$H 5E08F460: 00 D5 1B 00 00 00 00 00 00 00 00 00 00 00 00 00 ................

Sherock, it seems like for some reason you seem to be getting a herlock crash.

There should be an Arcadia.dmp file in the game server folder that you can analyze to see why it may be crashing.

Sometimes that is difficult to do because it is more than analyzing why a simple computer crashed but why Captain doesn't like a change that was made to Arcadia.

The simpler task may be to figure out what you may have changed in Arcadia last, or maybe go to a back up Arcadia and change things more slowly until you find the one it did not like.

BTW without the entire log file it is still difficult to figure out what is going on, I am not really fluent in hex memory dumps.

i solve it thanks

could any one give me the script for upgarding all the items form NPC to 10+20

i make a server but when i login and add the id and pass and click login no think happen plz help me
and any one give me authserver.opt and gameserver.opt for ip 127.0.0.1

@zackfire96

Not really a script as I don't alter the items in my database but I use the insert item command to insert weapons and armor at enchanted levels...

/run insert_item(250720804, 1, 20,10, 2, "CharacterName")

(Item_ID, qty, enchant, level, flag, character)

Flag:
1 = Pets
2 = Equipment
3 = Skill Cards

@ zezo357951

If you want example .opt files to use you can find them in the guide working with minimal edits.

If you want us to help you with your problem then...

It would be helpful to know the following about your server in order to find out why you can not connect to it...

Server file version (what epic are you running)?

What client do you have?

What do your .opt files look like?

Did you compress your .opt files?

What does your .bat look like?

Hello World!

My Auth Server is showing the following error(after choosing the character in champ selection): Wrong name 'account_id'. In german: Ungültiger Spaltenname 'account_id'. Anweisungen konnten nicht vorbereitet werden.

Then I checked my accounts table in the auth database and it appears that the accounts start with 1000... not with 1.
And I obviously can't change that since it's the key.
So I wonder if that is the error
Ingame error, a yellow notice appears that says: connection to the server failed please try again later. all the skills etc are gone from the bottom and the keys dont work anymore like i,r,y,e etc. but if i press everything manualy it works

@Kuchen31

If you are running the 9.1 files you have to perform the billing corrections in the guide for your skill bar issues.

If you used the provided Telecaster instead of the one that ismokedrow provided for MSSQL 2014 then you will need to clear the tables of the data that the server releasers left in telecaster.

The one ismokedrow provided he already cleared.