Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 07:30

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #4876
 
elite*gold: 0
Join Date: Mar 2011
Posts: 250
Received Thanks: 324
The only difference between inventory items and warehouse items is the account_id is set rather than owner_id owner being char id and when set to 0 and account_id is set its in the warehouse.



xXExiledXx is offline  
Old   #4877
 
elite*gold: 0
Join Date: May 2013
Posts: 129
Received Thanks: 12
i know but how do i distribute the item to all accounts in the storage at once?


thund22222 is offline  
Old   #4878
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
Use a wildcard %

where account_id = '%'

all account_id's will be included in that query
ThunderNikk is offline  
Thanks
1 User
Old   #4879
 
elite*gold: 0
Join Date: Aug 2013
Posts: 31
Received Thanks: 1
nulled


Kuchen31 is offline  
Old   #4880
 
elite*gold: 0
Join Date: May 2013
Posts: 129
Received Thanks: 12
how can i store the chat_log and log_bin record in db?
thund22222 is offline  
Old   #4881
 
elite*gold: 0
Join Date: Oct 2013
Posts: 398
Received Thanks: 27
what is the problem and how to solve it ?

Sherock is offline  
Old   #4882
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
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.
ThunderNikk is offline  
Old   #4883
 
elite*gold: 0
Join Date: May 2013
Posts: 129
Received Thanks: 12
any help for this ===>
Quote:
Originally Posted by thund22222 View Post
how can i store the chat_log and log_bin record in db?
thund22222 is offline  
Old   #4884
 
elite*gold: 0
Join Date: Oct 2013
Posts: 398
Received Thanks: 27
Quote:
Originally Posted by thndr View Post
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>[email protected]
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 [email protected]
5E0AF120: 00 00 40 41 00 00 00 00 00 00 00 00 00 00 00 00 [email protected]
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 [email protected]
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 [email protected]
5E0AF220: 94 1C D3 01 00 00 00 00 82 B4 00 40 01 00 00 00 [email protected]
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 ...[email protected]
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 ...^[email protected]
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 [email protected]
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 [email protected]
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 [email protected]
5E0AF2E0: 85 00 00 00 00 00 00 00 E6 18 1F 40 01 00 00 00 [email protected]
5E0AF2F0: 85 00 00 00 00 00 00 00 99 BA 00 40 01 00 00 00 [email protected]
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 [email protected]
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 [email protected]
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 [email protected]
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 [email protected]
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 ...^[email protected]$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 [email protected]
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 [email protected]
5E08F120: 00 00 40 41 00 00 00 00 00 00 00 00 00 00 00 00 [email protected]
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......[[email protected]
5E08F1F0: 00 00 00 00 00 88 C3 40 00 00 00 00 00 00 00 00 [email protected]
5E08F200: 28 CF EF 7C 00 00 00 00 08 F5 05 40 01 00 00 00 (..|[email protected]
5E08F210: 58 C5 6D 1A 00 00 00 00 9A A1 06 40 01 00 00 00 [email protected]
5E08F220: 64 1C D1 01 00 00 00 00 82 B4 00 40 01 00 00 00 [email protected]
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 [email protected]
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 [email protected]
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 [email protected]
5E08F2E0: 82 00 00 00 00 00 00 00 E6 18 1F 40 01 00 00 00 [email protected]
5E08F2F0: 83 00 00 00 00 00 00 00 99 BA 00 40 01 00 00 00 [email protected]
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 [email protected]
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 [email protected]
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 [email protected]
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 [email protected]
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 @[email protected]$H
5E08F460: 00 D5 1B 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
Sherock is offline  
Old   #4885
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
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.
ThunderNikk is offline  
Thanks
1 User
Old   #4886
 
elite*gold: 0
Join Date: Oct 2013
Posts: 398
Received Thanks: 27
i solve it thanks
Sherock is offline  
Old   #4887
 
elite*gold: 0
Join Date: Jul 2014
Posts: 8
Received Thanks: 0
could any one give me the script for upgarding all the items form NPC to 10+20
zackfire96 is offline  
Old   #4888
 
elite*gold: 0
Join Date: Apr 2012
Posts: 106
Received Thanks: 27
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
zezo357951 is offline  
Old   #4889
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
@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?
ThunderNikk is offline  
Old   #4890
 
elite*gold: 0
Join Date: Aug 2013
Posts: 31
Received Thanks: 1
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 is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 07:30.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.