1 files changed, 250 insertions, 0 deletions
diff --git a/src/char_sql/readme.txt b/src/char_sql/readme.txt
new file mode 100644
index 000000000..5f54418ac
--- /dev/null
+++ b/src/char_sql/readme.txt
@@ -0,0 +1,250 @@
+//Encoded with UTF-8 (UNICODE)
+//---------------------------------------------
+// V.018 - Aarlex
+1. ADD Makefile & GNUmakefile
+2. fix guild_leave.
+3. fix char select windows HP & SP value error.
+
+// V.017 - Aarlex
+1. fix guild member view job update.(For mod-0728)
+   inter.c
+   int_guild.c
+
+// V.016 - by Aarlex
+1. Add e-mail check when you Delete char data.
+2. modify storage save func like 014.
+2. remove Lan_support func.
+
+// v.014 - by Aarlex
+I rewrite save function.
+besause myfriend find that Mysql will use more than 40% CPU.
+And log file is too big (4 days 22G ..= =+)
+(maybe he sets autosave_time less then 1 min.)
+but. i still rewrite save func.
+char server will delete all of user item(inventory & Cart) data then insert them again before.
+so i use two struct to save item data from map & database.
+then compare two struct to get different .
+AND add some debug message.but message maybe too much XD.
+
+
+1. ADDED itemdb.c itemdb.h
+2. modify mmo_char_tosql().
+3. ADDED memitemdata_to_sql().
+4. ADDED some debug message in memitemdata_to_sql().
+5. modify make.sh 
+
+// v.013 - by Aarlex
+1. some SQL sentance fix in old version Mysql .
+
+2. in_guild.c mapif_guild_leaved() 
+   unsigned char buf[64] -> unsigned char buf[128]
+
+3. in_pet.c inter_pet_tosql()
+   if (sql_res) - > if (mysql_num_rows(sql_res)!=0)
+
+4. in_char.c mmo_char_send006b()
+
+   WFIFOW(fd, offset+(i*106)+42) = char_dat[0].hp     -> WFIFOW(fd,offset+(i*106)+42) = (char_dat[j].hp > 0x7fff)? 0x7fff:char_dat[j].hp;
+   WFIFOW(fd, offset+(i*106)+44) = char_dat[0].max_hp -> WFIFOW(fd,offset+(i*106)+44) = (char_dat[j].max_hp > 0x7fff)? 0x7fff:char_dat[j].max_hp;
+   WFIFOW(fd, offset+(i*106)+46) = char_dat[0].sp     -> WFIFOW(fd,offset+(i*106)+46) = (char_dat[j].sp > 0x7fff)? 0x7fff:char_dat[j].sp
+   WFIFOW(fd, offset+(i*106)+48) = char_dat[0].max_sp -> WFIFOW(fd,offset+(i*106)+48) = (char_dat[j].max_sp > 0x7fff)? 0x7fff:char_dat[j].max_sp;
+
+   in_char.c parse_char()  
+
+   WFIFOW(fd, offset+(i*106)+42) = char_dat[0].hp     -> WFIFOW(fd,offset+(i*106)+42) = (char_dat[j].hp > 0x7fff)? 0x7fff:char_dat[j].hp;
+   WFIFOW(fd, offset+(i*106)+44) = char_dat[0].max_hp -> WFIFOW(fd,offset+(i*106)+44) = (char_dat[j].max_hp > 0x7fff)? 0x7fff:char_dat[j].max_hp;
+   WFIFOW(fd, offset+(i*106)+46) = char_dat[0].sp     -> WFIFOW(fd,offset+(i*106)+46) = (char_dat[j].sp > 0x7fff)? 0x7fff:char_dat[j].sp
+   WFIFOW(fd, offset+(i*106)+48) = char_dat[0].max_sp -> WFIFOW(fd,offset+(i*106)+48) = (char_dat[j].max_sp > 0x7fff)? 0x7fff:char_dat[j].max_sp;
+
+// v.012 - by Jazz
+1. 0627 official versionに合わせて修正しました.
+2. no more binary files are supplied.
+
+//---------------------------------------------
+// v.011 - by Mark
+1. Fixed a couple bugs which would cause segfaults under linux :)
+
+//---------------------------------------------
+// v.010 - by Jazz
+1. added some debug info - for reporting.
+
+//---------------------------------------------
+// v.009 - by Jazz
+1. code added for debug.
+2. some SQL sentance fix.
+
+//---------------------------------------------
+// v.009 - by Jazz
+1. fix crash bug. - pet db.
+
+//---------------------------------------------
+// v.008 - by Jazz
+1. DB table fix. - char.fix-from.007.to.008.sql
+
+既存の table 構造には矢が装着解除される場合があります.
+
+item.equipは 'unsigned short' 形式です. 
+このために SQL tableを修正しなければなりません.
+
+修正コードは char.fix-from.007.to.008.sql です.
+MySQLで一度行ってくれれば適用されます. 既存のデータは安全です.
+
+//---------------------------------------------
+// v.007 - by Jazz
+1. domain 解釈に対する問題を修正しました.
+
+//---------------------------------------------
+// v.006 - by Jazz
+1. crash bug fix. - when your pet DB is empty
+
+//---------------------------------------------
+// v.005 - by Jazz
+1. 0590 official versionに合わせて修正しました.
+
+//---------------------------------------------
+// v.004 - by Jazz
+1. 0586 official versionに合わせて修正しました.
+
+//---------------------------------------------
+// v.003 - by Jazz
+1. officialの guild.c と party.c ファイルでまた再修正しました.
+
+//---------------------------------------------
+// v.002 - by Jazz
+1. aphostropy 問題を解決しました. これは保安と連関がある問題です.
+2. SQLの構造を修正しました.
+
+//---------------------------------------------
+// v.001 - by Jazz
+1. 一番目安定 versionです. alpha versionに問題点を多数修正しました.
+
+//------------------------------------------------------------------------
+//For JAPANESE USER
+Athena Char-Server for MySQL. 005
+
+一応 guildと partyはよく呼び出しされる部分なので既存の athena char-serverが使っている file 基盤の構造を持って行きます.
+これは, 一度にメモリーで皆読んで, もう一度に皆 fileで使う方が部下が少なくかかると思います.
+そして char データに比べて, lostになっても問題がもっと少ないと判断してそうしました.
+
+MySQLバージョンの compileは MySQL Clients Libraryが必要です. windows(cygwin) バージョンにコンパイルされた binaryを添付しました.
+
+設置:
+まだ text->DBの converterはまともに支援しないです. 内部的にちょっとバグが発見されてバグを修正中です.
+できるだけ早く uploadをします.
+
+1. char.sqlを MySQLに dumpします.
+
+2. inter_athena.confに次を追加します. そして自分の DBサーバーの情報に合わせてくれます.
+ここで windows(cygwin)の場合には localhostを使ってはいけないです. ipで書いてくれなければなりません.
+localhostで使う場合 UNIX domain socketが作動するから連結が不可能になります.
+
+//3306 is default
+db_server_port: 3306
+//DB ip
+db_server_ip: 127.0.0.1
+//DB id
+db_server_id: ragnarok
+//DB pass
+db_server_pw: ragnarok
+//DB name
+db_server_logindb: ragnarok
+
+3. MySQL バージョンは 2個の MySQL connect sessionを持ちます.
+一つはキャラクターデータを読んで書くのに使われて, 二番目は inter serverのために連結します.
+
+開発とテスト環境は P4 2.4a/1024MB/WinXP pro(MediaCenter Edition 2K4 KR)/Cygwin GCC です.
+本人が韓国人だから韓国語開発者の連絡も歓迎します.
+韓国語と日本語の上手な方は連絡をください. 日本語の使用に難しさを感じています.
+
+現在 DarkWeissが login serverに MySQLを支援し始めました.
+しかし athenaのそれは DarkWeiss よりもっとよく作動すると思います.
+
+contact : jazz@creper.com
+
+//------------------------------------------------------------------------
+//For KOREAN USER
+Athena Char-Server for MySQL. 005
+
+일단 guild와 party는 자주 호출되는 부분이라서 기존의 athena char-server가 사용하고 있는 file 기반의 구조를 가지고 갑니다.
+이 것은, 한번에 메모리로 모두 읽고, 다시 한번에 모두 file로 쓰는 쪽이 부하가 적게 걸린다고 생각합니다.
+그리고 char 데이터에 비해, lost가 되더라도 문제가 더 적다고 판단해서 그렇게 하였습니다.
+
+MySQL버전의 compile은 MySQL Clients Library가 필요합니다. windows(cygwin) 버전으로 컴파일된 binary를 첨부하였습니다.
+
+설치:
+아직 text->DB의 converter는 제대로 지원하지 않습니다. 내부적으로 약간 버그가 발견되어 버그를 수정중입니다.
+되도록 빨리 upload를 하겠습니다.
+
+1. char.sql을 MySQL에 dump합니다.
+
+2. inter_athena.conf에 다음을 추가 합니다. 그리고 자신의 DB서버의 정보에 맞추어 줍니다.
+여기에서 windows(cygwin)의 경우에는 localhost를 쓰면 안됩니다. ip로 적어주어야 합니다.
+localhost로 사용하는 경우 UNIX domain socket이 작동 하기 때문에 연결이 불가능해 집니다.
+
+//3306 is default
+db_server_port: 3306
+//DB ip
+db_server_ip: 127.0.0.1
+//DB id
+db_server_id: ragnarok
+//DB pass
+db_server_pw: ragnarok
+//DB name
+db_server_logindb: ragnarok
+
+3. MySQL 버전은 2개의 MySQL connect session을 가집니다.
+하나는 캐릭터 데이터를 읽고 쓰는데 사용되며, 두번째는 inter server를 위해서 연결합니다.
+
+개발과 테스트 환경은 P4 2.4a/1024MB/WinXP pro(MediaCenter Edition 2K4 KR)/Cygwin GCC 입니다.
+본인이 한국인이기 때문에 한국어 개발자의 연락도 환영합니다.
+한국어와 일본어가 능숙한 분은 연락을 주세요. 일본어의 사용에 어려움을 느끼고 있습니다.
+
+현재 DarkWeiss가 login server에 MySQL을 지원하기 시작했습니다.
+하지만 athena의 그것은 DarkWeiss 보다 더 잘 작동한다고 생각합니다.
+
+contact : jazz@creper.com
+
+//------------------------------------------------------------------------
+//For ENGLISH USER
+Athena Char-Server for MySQL. alpha 005
+
+= hehe. My English is poor. and I have no time to write. :)
+
+anyway this version use guild and party data on text file base system.
+It accesses many times, so memory dumping is useful for less cpu consume.
+
+MySQL version need MySQL Clients Library to compile. This include Win32-binary compiled by cygwin-gcc.
+
+Install:
+not yet text->DB converter. I found some bug on it, so It's under debug progress.
+
+1. dump char.sql to MySQL.
+
+2. add below on inter_athena.conf. and set your own information.
+do not use 'localhost' as domain on cygwin. you must set as ip.
+if you use localhost on cygwin, cygwin tries to connect MySQL as UNIX domain socket.
+but, MySQL does not support UNIX domain socket on windows.
+
+//3306 is default
+db_server_port: 3306
+//DB ip
+db_server_ip: 127.0.0.1
+//DB id
+db_server_id: ragnarok
+//DB pass
+db_server_pw: ragnarok
+//DB name
+db_server_logindb: ragnarok
+
+3. MySQL version has 2 MySQL connect session.
+one is for char-server and the other one is for inter-server.
+
+developement enviroment)
+ P4 2.4a/1024MB/WinXP pro(MediaCenter Edition 2K4 KR)/Cygwin GCC
+
+I'm korean, so contect if U're Korean developer.
+Please contact me, If U can use Korean & Japanese well.
+
+DarkWeiss starts to support MySQL version of login server, but Athena's one works better, I thnik.
+
+contact : jazz@creper.com