Friends system

Status
Not open for further replies.
Joined
Jan 21, 2006
Messages
528
Reaction score
1
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.
 
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
 
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
 
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 :) )
 
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
 
Last edited:
Status
Not open for further replies.
Back