Friends system

[RudyMartin]

Not a question, just a note: the friends.sql have some tables missing, an important one is the friends0, if you dont have it, this is what you must do in order to enable friends in the server

Enterprise SQL Manager -> select the FriendDB -> rightclick add table

fields information below:

CharName char 20
GroupInfo char 20
FriendInfo varchar 2000

note: this is MY setup, I have tested with only 2 chars and after reconnecting I still got the friend in my list. buy using 2000 limit, you have enough space for almost 100 friends, perhaps a little more.

if some1 has more information, I would apreciate a post here.

 

[RudyMartin]

another point, related. It seems like the mail system need such table in order to work, even if you have no friends registered at all. I say this because the mail system started to work *after* I created the table, and if you ask me wth I have touched to make it work, I dunno =S

rudy

 

[Akaruz]

last time i noticed there was a sql table on my files called Friend DB

 

[RudyMartin]

do you mean theres a friendsdb backup in the 202 server files? because I never saw it (and I have downloaded the 202 files from this site). AFA I can remember, theres a ASD, Character, Clan and Itemstorage, and no other db backup. Theres a friends.sql in the part3sql but my point is that theres a missing table in that script.

can some1 test it or give more info about this issue in case im wrong ?

thanks rudy

 

[Mistral_a3]

FriendDB.sql was in 202 serverpackage only table friends0 was missing making it so u can send mails but it wont save ur friendlists (if u add the table like u mentioned u can now save friends list )

 

[Akaruz]

it wasnt missing

if you set your world to 0 , Table = 0

if you had your world to 23 ( default - leaked files ) Table would be friends23 for example

its like what mistral_a3 said

 

[Legendary]

well I did all of that (created tables friends0 and friends23) but still couldn't get it to work.. ah well.. I think this release's got some problem

 

[Sith Lord]

SvrInfo file in Mianserver dir

[ODBC]
ODBCNAME=FriendDB
ODBCID=sa
ODBCPASS=yoursqlpassword

you must change from FriendDB to A3Friend .

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="Friend24"
"LastUser"="sa"

ODBC

 

[Legendary]

wow.. wait.. you mean the DB name has to be Friend24?? not FriendDB?

 

[Legendary]

funny thing now my post system works but the friendlist still malfunctions.. is it because I made 2 tables? friends0 and friends23?

 

[Sith Lord]

You must made Friend0 tabel in Friend24 SQL data.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FRIEND0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FRIEND0]
GO

CREATE TABLE [dbo].[FRIEND0] (
[CharName] [char] (20) COLLATE Thai_CI_AS NOT NULL ,
[GroupInfo] [varchar] (1024) COLLATE Thai_CI_AS NOT NULL ,
[FriendInfo] [varchar] (1024) COLLATE Thai_CI_AS NOT NULL
) ON [PRIMARY]
GO

Copy to Friend24.txt in Part3SQL dir

PS. Thai_CI_AS for NameChar Thai Private server you can change is Eng

 

[Legendary]

oh FRIEND0 not Friends0?!? hahaha

 

[Legendary]

Sithlord I LOVE YOU!!