Gesior 2012 Error

[kafo]

How to Fix this Error
Iam Using

System functions:
- Adds points in all players the guild, even those who are offline.
- The player receives points only once.
- No matter if it enters into another guild or create another character.
- The script is based on one made by Gesior.pl.
- More this script is totally created by Lukeskywalker.
- The leader of the guild can only run the command once per day.
- Some bug fixes and this is without doubt the GuildPoints most complete of forums.

See scripts:

Create one archive in data/talkactions/scripts name guildpoints.lua:

CODE GUILDPOINTS.LUA TFS 0.4

CODE GUILDPOINTS.LUA TFS 1.0

In script the above configure your rules:


Next add in talkactions.xml:

<talkaction words="!guildpoints" event="script" value="guildpoints.lua"/>

At its database add:

ALTER TABLE `accounts` ADD `guild_points` INTEGER(11) NOT NULL DEFAULT 0;

ALTER TABLE `accounts` ADD `guild_points_stats` INT NOT NULL DEFAULT '0';

ALTER TABLE `guilds` ADD `last_execute_points` INT NOT NULL DEFAULT '0';

                 CREATE TABLE `z_shopguild_offer`(
                       `id`int(11) NOT NULL auto_increment,
                       `points`int(11) NOT NULL default'0',
                       `itemid1`int(11) NOT NULL default'0',
                       `count1`int(11) NOT NULL default'0',
                       `itemid2`int(11) NOT NULL default'0',
                       `count2`int(11) NOT NULL default'0',
                       `offer_type` varchar(255)default NULL,
                       `offer_description` text NOT NULL,
                       `offer_name` varchar(255) NOT NULL,
                       `pid` INT(11) NOT NULL DEFAULT '0',
                 PRIMARY KEY (`id`))

                 CREATE TABLE `z_shopguild_history_item`(
                       `id`int(11) NOT NULL auto_increment,
                       `to_name` varchar(255) NOT NULL default'0',
                       `to_account`int(11) NOT NULL default'0',
                       `from_nick` varchar(255) NOT NULL,
                       `from_account`int(11) NOT NULL default'0',
                       `price`int(11) NOT NULL default'0',
                       `offer_id`int(11) NOT NULL default'0',
                       `trans_state` varchar(255) NOT NULL,
                       `trans_start`int(11) NOT NULL default'0',
                       `trans_real`int(11) NOT NULL default'0',
                 PRIMARY KEY (`id`))

                 CREATE TABLE `z_shopguild_history_pacc`(
                       `id`int(11) NOT NULL auto_increment,
                       `to_name` varchar(255) NOT NULL default'0',
                       `to_account`int(11) NOT NULL default'0',
                       `from_nick` varchar(255) NOT NULL,
                       `from_account`int(11) NOT NULL default'0',
                       `price`int(11) NOT NULL default'0',
                       `pacc_days`int(11) NOT NULL default'0',
                       `trans_state` varchar(255) NOT NULL,
                       `trans_start`int(11) NOT NULL default'0',
                       `trans_real`int(11) NOT NULL default'0',
                 PRIMARY KEY (`id`))

Now go to the web part.

Add in index.php:

case "shopguild";
$topic = "Shop Guild";
$subtopic = "shopguild";
include("shopguild.php");
break;

case "shopguildadmin";
$subtopic = "shopguildadmin";
$topic = "Shop System";
include("shopguildadmin.php");
break;

Add in config.php:

$config['site']['shopguild_system'] = 1;

Add in layouts.php next of ShopOffer:

<a href='?subtopic=shopguild'>
  <div id='submenu_shopguild' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
        <div class='LeftChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
        <div id='ActiveSubmenuItemIcon_shopguild' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div>
        <div class='SubmenuitemLabel'>Shop Guild <blink><font size='0'><font color='yellow'>NEW</font></font></blink></div>
        <div class='RightChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
  </div>
</a>

Add in layouts.php next of ShopAdmin for make sure that you only have access ADM:

<a href='?subtopic=shopguildadmin'>
  <div id id='submenu_shopguildadmin' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
    <div class='LeftChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
    <div id='ActiveSubmenuItemIcon_shopguildadmin' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div>
    <div class='SubmenuitemLabel'><font color=red>! ShopGuild Admin !</font></div>
    <div class='RightChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
  </div>
</a>

Create the archives how name shopguild.php and shopguildadmin.php add:

shopguild.php
shopguildadmin.php

 

[Natan Beckman]

classes/account.php

In:

public $data = array(

add

public $data = array( 'guild_points' => null

In:

public static $fields = array(

add:

public static $fields = array( 'guild_points'

search:

    public function setPremiumPoints($value){$this->data['premium_points'] = $value;}
    public function getPremiumPoints(){return $this->data['premium_points'];}

add after:

    public function setGuildPoints($value){$this->data['guild_points'] = $value;}
    public function getGuildPoints(){return $this->data['guild_points'];}