Rappelz server files

04/09/2011 01:57 aviate22#106
Anybody could explain how to load files to datebase in mysql 2008?
04/09/2011 03:05 Link404#107
Quote:
Originally Posted by aviate22 View Post
Anybody could explain how to load files to datebase in mysql 2008?
I don't want to be an asshole, but seriousely, why the heck do you even try it if you have absolutely no clue about SQL? :/
04/09/2011 03:16 aviate22#108
Quote:
I don't want to be an asshole, but seriousely, why the heck do you even try it if you have absolutely no clue about SQL? :/
Ive already resolve this problem myself. Yep you have right i dont know anything about sql but i learn fast :) Now my problem is like a few page ago.. i cant conect to mysql server. Any ideas?
04/09/2011 03:41 Pyrok#109
Small progress update... Got the LevelResource table to load, still not sure what all the fields are though. It needs {int, bigint, int, int, int, int}. The bigint has to be the exp field and I'm guessing the first int is the level.

After that, it needs an index created on dbo.Items. Here's sql that worked for me so far:


Now it loads the character list but it's completely blank. I'm guessing version mismatch but I can't say for sure just yet. If so, we may run into a brick wall eventually trying to get this to work because of too much hacking needed :(
04/09/2011 04:14 jw988#110
hi this site still seems to have some old clients for download:
[Only registered and activated users can see links. Click Here To Register...]
im downloading the epic 6 one dated 02/03/2010 for testing
04/09/2011 11:03 Link404#111
Quote:
Originally Posted by aviate22 View Post
Ive already resolve this problem myself. Yep you have right i dont know anything about sql but i learn fast :) Now my problem is like a few page ago.. i cant conect to mysql server. Any ideas?
If you really want to learn how to use and how to work with SQL, then I'd suggest to look for some guides using Google, it helps. It's not forbidden to ask here, but I just don't like it when people ask something that wouldn't be necessary if you would have the basics of SQL.

Pyrok, what if you "create" a character by yourself using the database? Does it work then?
04/09/2011 11:33 jw988#112
I Have been playing around with making one in the database but it looks like it adds default data to lots of other tables when a char is made in the client. :P so no luck yet

but i did get it to load the the levelResource

2011-04-09 14:35:05 Total 170 LevelUpTable info loaded...
04/09/2011 14:21 Gangxtar1#113
installed now sql 2008. its the same shit like in the sql 2005 cant restore db.

the error tell me "the Back-up-pack is the back-up of an other db as the created one of me"

but i wanna restore. why it tell me that error
04/09/2011 14:32 sabit#114
now I instal in 2008 r2 express version on mine pc, and now I have a question:

jw988 you are able to do your files plz upload
or if you make only if there no more program errors are and everybody runs...

I have basic SQL skills because I have made mine own flyff server and kalonline WOW sometimes I think that I am able to do bases.

I want to help with my friend, but we have thousands of files and we do not know which are the right files

---------------------------------

ich installiere jetzt den 2008 r2 express Version auf meinem pc, und jetzt habe ich eine Frage:

jw988 kannst du deine Dateien plz hochladen
oder machst du erst wenn dort keine Programmfehler mehr sind und alle läuft...

ich habe grundlegende SQL-Sachkenntnisse weil ich habe meinen eigenen flyff Server und kalonline WOW mal gemacht ich meine, dass ich Grundlagen kann.

ich will mit meinem Freund helfen, aber wir haben tausende von Dateien und wir wissen nicht welche gut sind oder Richtig..

SRY for my english im german sry
04/09/2011 15:52 Gangxtar1#115
how can i create an ACC for my own server?
i wanna try to login
04/09/2011 19:05 aviate22#116
Soleil its easy. First you need go to start > Microsoft sql server 2008 > cofiguration tools > SQL Server Configuration Manager.

Then sql server network configuaration > protocols for mysqll serv > tcp/ip enabled.

Then you run sql server manager and conect.

Then you have to run datebase backups.
04/09/2011 19:23 sabit#117
i cannot restore the database they make an error:
[Only registered and activated users can see links. Click Here To Register...]
plz help
04/09/2011 19:33 aviate22#118
Sabit dont make clear datebase. Click on datebace > restore datebase > chaose bak file and then chaose name Arcadia.
04/09/2011 19:39 sabit#119
what do u mean clear database its an backup from jw988
04/09/2011 19:50 aviate22#120
[Only registered and activated users can see links. Click Here To Register...]
I mean add it like that.




I have question. What we need in datbase? Auth, Telecaster and Arcadia? Is there something more we need to add?
[Only registered and activated users can see links. Click Here To Register...]
Is that all?