Change for serverrules2read from players instead of accounts

[Cripp]

Heres changes i make to make it so the server rules are flagged on every character instead of the account so when a player makes a new character they have to accept the rules again.. thought it might be useful to some others.

zone/command.cpp
--- command.cpp 2006/10/05 21:27:05 1.10
+++ command.cpp 2006/10/13 06:17:18 1.11
@@ -6622,9 +6622,9 @@

void command_acceptrules(Client *c, const Seperator *sep)
{
- if(!database.GetAgreementFlag(c->AccountID()))
+ if(!database.GetAgreementFlag(c->CharacterID()))
{
- database.SetAgreementFlag(c->AccountID());
+ database.SetAgreementFlag(c->CharacterID());
c->SendAppearancePacket(AT_Anim, ANIM_STAND);
c->Message(0,"It is recorded you have agreed to the rules.");
zone/client.cpp
--- client.cpp 2006/07/10 05:11:48 1.6
+++ client.cpp 2006/07/10 18:45:21 1.7
@@ -3059,7 +3059,7 @@

if(database.GetVariable("Rules", rules, 4096))
{
- int8 flag = database.GetAgreementFlag(client->AccountID());
+ int8 flag = database.GetAgreementFlag(client->CharacterID());
if(!flag)
{
client->Message(13,"You must agree to the Rules, before you can move. (type #rules to view the rules)");
common/database.cpp
--- database.cpp 2006/09/25 01:24:25 1.7
+++ database.cpp 2006/10/05 21:38:16 1.8
@@ -1611,16 +1611,16 @@

return retval;
}

-int8 Database::GetAgreementFlag(int32 acctid)
+int8 Database::GetAgreementFlag(int32 charid)
{
char errbuf[MYSQL_ERRMSG_SIZE];
char* query = 0;
MYSQL_RES* result;
MYSQL_ROW row;
bool ret = false;

- if (RunQuery(query, MakeAnyLenString(&query, "SELECT rulesflag FROM account WHERE id=%i",acctid), errbuf, &result)) {
+ if (RunQuery(query, MakeAnyLenString(&query, "SELECT rulesflag FROM character_ WHERE id=%i",charid), errbuf, &result)) {

safe_delete_array(query);
if (mysql_num_rows(result) == 1)
{

@@ -1636,14 +1642,14 @@
}
return 0;
}

-void Database::SetAgreementFlag(int32 acctid)
+void Database::SetAgreementFlag(int32 charid)
{
char errbuf[MYSQL_ERRMSG_SIZE];
char *query = 0;
int32 affected_rows = 0;

- if (!RunQuery(query, MakeAnyLenString(&query, "UPDATE account SET rulesflag=1 where id=%i",acctid), errbuf, 0, &affected_rows)) {
+ if (!RunQuery(query, MakeAnyLenString(&query, "UPDATE character_ SET rulesflag=1 where id=%i",charid), errbuf, 0, &affected_rows)) {
safe_delete_array(query);
}
else
common/database.h
--- database.h 2006/09/25 01:24:25 1.6
+++ database.h 2006/10/05 21:38:16 1.7
@@ -151,9 +151,9 @@
int32 GetAccountIDFromLSID(int32 iLSID, char* oAccountName = 0, sint16* oStatus = 0);
bool UpdateLiveChar(char* charname,int32 lsaccount_id);
bool GetLiveChar(int32 account_id, char* cname);
- int8 GetAgreementFlag(int32 acctid);
- void SetAgreementFlag(int32 acctid);
+ int8 GetAgreementFlag(int32 charid);
+ void SetAgreementFlag(int32 charid);

/*
* Groups
*/
Also need to add the rulesflag column to character_ with..
ALTER TABLE `character_` ADD `rulesflag` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
and if you want to remove the column from the account table which is not needed, and i didnt myself.. but if you want to heres the command..
ALTER TABLE `account` DROP rulesflag;

kinda alot of work but thought it could be useful for some..