[5165] RollBacks

[†he Knight]

5165/Tanel's ... Problem "RollBacks"
Anybody has a fix for this?
If he does , I Promisse its my last request/begging.

[Arcо]

Switch my MySQL, nuff said.

[_tao4229_]

Originally Posted by Аrco

Switch my MySQL, nuff said.

That has nothing to do with it.

[Arcо]

Darn right it doesn't, but it helps a whole lot. With the current character system, you can't update a single line in the file. With mysql, at least you can update the table EVERYtime a change is made.

[_tao4229_]

You don't need to for either system (it's possible to modify a single value in a binary file - that's what SQL does anyways); you really shouldn't to start with.

It's redundant, all you need is proper disconnection handling.

[Arcо]

Originally Posted by _tao4229_

it's possible to modify a single value in a binary file

How does one do that aye?

[†he Knight]

oO , How Can I Switch to mysql lmao?

[Arcо]

I recommend you to use Immune's MySQL Wrapper. If not that, then use Impulse's.
Both can be found in the corresponding sources.

[†he Knight]

Yes but my server is 25 rank at xtremetop ... too many characters, going to be a big loss

[Arcо]

Just make all the characters dump from the .chr file to mysql.

[_tao4229_]

Originally Posted by Аrco

How does one do that aye?

FILE* file = fopen(fname, "rb+");

fseek(file, FIELD_OFFSET, SEEK_SET);

fwrite(&value, 1, sizeof(value), file);

fclose(file);

While this is obviously inefficient (due to having to reopen files constantly) it's possible.

[Arcо]

Originally Posted by _tao4229_

FILE* file = fopen(fname, "rb+");

fseek(file, FIELD_OFFSET, SEEK_SET);

fwrite(&value, 1, sizeof(value), file);

fclose(file);

While this is obviously inefficient (due to having to reopen files constantly) it's possible.

You do realize, this is for a source written in c# right?

[_tao4229_]

Sigh, it's the same thing. You can open a binary file with read+ (read/write privileges which do not start you with a blank file) privileges and then seek to whatever offset you want. The only factor that would be a problem is fields with dynamic length (how write/reading a string from a BinaryReader/Writer does), so you'd have to take into account the lengths of those fields in order to seek past them (or obviously switch to fixed length fields).

// using System.IO;

FileStream fs = new FileStream("c:\\file.bin", FileMode.Open, FileAccess.ReadWrite);
BinaryWriter wrtr = new BinaryWriter(fs, Encoding.ASCII);

wrtr.BaseStream.Seek(OFFSET, SeekOrigin.Begin);
wrtr.Write(value);

wrtr.Close();

[†he Knight]

Too dumb to understand this...
#request close

[hunterman01]

Originally Posted by JuiceDCodeR

Too dumb to understand this...
#request close

Its not that your dumb, its just the lack of learning