Zarath Shop Mod Problem beim Cash (Punkte) tausch: SQL Query Error ...

7Quaresma90 · 16.03.2009

vorher hat der shop mod perfekt geklappt. doch wenn ein user mit mir tauscht , kann ich aufeinmal nicht mehr in "mein inventar" bzw. auf keinen meiner user . den tausch kann ich dann auch nicht annehmen oder ablehnen ... .
Es kommt immer die meldung :
SQL Query Error in retrieving user items!
Ich hab den Shop mod von zarath :
Shop Modification: Copyright © 2003, 2006
ich glaube das ist version 3.0.0

das passier übrigens nur wenn jemand punkte (cash mod) tauscht.
Also ich hab einem User einen tausch vorgeschlagen :
Punkte von mir gegen sein Item
Danach konnte dieser User nicht mehr auf sein (und von anderen usern) inventar zugreifen .
Bei mir hat jedoch alles funktioniert.
Noch ein Tauschvorschlag von mir :
Item gegen Item
Bei beiden seiten hats funktioniert und alles hat geklappt ...
dann hab ich ein tauschvorschlag bekommen :
Punkte gegen mein Item
dann kam bei mir diese fehlermeldung wo ich oben beschrieben habe.Bei dem anderen user , der mir den vorschlag schickte , funktioniert alles.
also klappt da irgendwas nicht wenn man cash (punkte) tauschen will.
jemand ne idee ?
PS:
Link meines forums gibts in der signatur. ich hab phpbb2 ... .

azraelb · 17.03.2009

AW: Zarath Shop Mod Problem beim Cash (Punkte) tausch: SQL Query Error ...

Hallo,
also ka was du da genau machst. Vielleicht kannst du mal das/die SQL-Statements und dein DB-Modell posten?

Im Prinzip sollte das doch so funktionieren:
User A hat Punkte, User B hat das Item

1. Prüfen, wieviele Punkte User A besitzt
2. Prüfen, ob die Anzahl der Punkte für den Tausch ausreichen
(evtl. Prüfen, ob User B das Item überhaupt besitzt)
3. Punkte bei User A abziehen
4. Punkte von User B ermitteln und die von A abgezogenen Punkte draufzählen
5. Das Item bei User B löschen
6. Dem User A das Item zuteilen

Nur, was willst du von der Datenbank machen lassen und was von deinem Code?

7Quaresma90 · 18.03.2009

AW: Zarath Shop Mod Problem beim Cash (Punkte) tausch: SQL Query Error ...

also item und punkte waren da. die fehlermeldung kommt generell wenn jemand einen tauschvorschlag bekommt wo punkte verlangt werden.ich hab in der db (mysqldumper) schon geschaut ob ich den tausch oder so rückgängig machen kann. hab aber leider nichts gefunden.
ich weis echt nichtmehr wo ich noch nachschauen könnte ... .

azraelb · 18.03.2009

AW: Zarath Shop Mod Problem beim Cash (Punkte) tausch: SQL Query Error ...

7Quaresma90 schrieb:
also item und punkte waren da. die fehlermeldung kommt generell wenn jemand einen tauschvorschlag bekommt wo punkte verlangt werden.ich hab in der db (mysqldumper) schon geschaut ob ich den tausch oder so rückgängig machen kann. hab aber leider nichts gefunden.
ich weis echt nichtmehr wo ich noch nachschauen könnte ... .

Ja, aber was ist genau ein "Tauschvorschlag", was wird da fachlich und technisch gemacht? Welche SELECTS... (SQL-Statements) werden ausgeführt und vor allem wie sieht deine DB aus (Tabellen, Attribute...)?

Ohne derartige Infos wird dir wohl niemand helfen können...

saila · 19.03.2009

AW: Zarath Shop Mod Problem beim Cash (Punkte) tausch: SQL Query Error ...

Das liegt nicht am Query für die DB, sondern am Cash. Sprich - es werden in diesem Bereich für den Tausch Daten gecasht was nicht sein darf. Sprich - man sollte in dem Script oder in der Extension entsprechend modifizieren, da diese Extension wohl etwas älter ist als die aktuelle Shopversion selbst. Sollte eine Extension nicht angepasst sein an neuere Shopversionen, sollte man auch diese Extensions nicht weiter nutzen - oder man passt sie eben den neuen Bedingungen entsprechend an.

Der Ablauf ist folgender - es werden nach dem Tausch nicht die Daten aktuallisiert sondern aus dem cash geladen. Somit ist dann bei deiner Nutzung der Quellbestand an Daten nicht korrekt und führt letztlich zu einem SQL-Error.

7Quaresma90 · 19.03.2009

AW: Zarath Shop Mod Problem beim Cash (Punkte) tausch: SQL Query Error ...

Ich hab mir das auch schon gedacht das der Zarath Shop mod bzw. die version die ich nutze nicht ganz funktioniert mit dem cash mod von xore .
Das ist die anleitung für den zarath shop mod :

Code:

##############################################################
## MOD Title: Shop Mod
## MOD Author: Zarath < null@null.com > Zarath http://www.zarath.com/mods
## MOD Description: A shop system for your forums.
## MOD Version: 3.0.0
##
## Installation Level: Easy-Intermediate
## Installation Time: 10 Minutes
## Files To Edit:    includes/constants.php,
##            includes/page_header.php,
##            includes/usercp_viewprofile.php
##            viewtopic.php,
##            templates/*/overall_header.tpl
##            templates/*/profile_view_body.tpl
##            templates/*/viewtopic_body.tpl
## Included Files:    shop.php
##             shop_actions.php
##             shop_bs.php
##             shop_inventory.php
##             admin/admin_shop.php
##             language/lang_english/lang_shop.php
##             templates/admin/shop_config_body.tpl
##             templates/admin/shop_edit_item.tpl
##             templates/admin/shop_edit_body.tpl
##             templates/admin/shop_edit_user.tpl
##             templates/shop/shop_action_discard.tpl
##             templates/shop/shop_action_give.tpl
##             templates/shop/shop_action_trade.tpl
##             templates/shop/shop_buy.tpl
##             templates/shop/shop_districts.tpl
##             templates/shop/shop_inventory_body.tpl
##             templates/shop/shop_item_body.tpl
##             templates/shop/shop_list.tpl
##             templates/shop/shop_list_body.tpl
##             templates/shop/shop_sell.tpl
##             images/icon_shop.gif
##            update/update_items.php
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes: Please note, I will not give any kind of email 
##               or PM support. Post in the relevant threads on
##               http://www.phpbb.com/phpBB/
##
##############################################################
## MOD History:
##
##   2006-01-06 - Version 3.0.0
##      - Complete Rewrite/Re-Release
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

# 
#-----[ COPY ]------------------------------------------ 
#
copy shop.php to shop.php
copy shop_actions.php to shop_actions.php
copy shop_bs.php to shop_bs.php
copy shop_inventory to shop_inventory.php
copy admin/admin_shop.php to admin/admin_shop.php
copy language/lang_english/lang_shop.php to language/lang_english/lang_shop.php
copy templates/admin/shop_config_body.tpl to templates/subSilver/admin/shop_config_body.tpl
copy templates/admin/shop_edit_item.tpl to templates/subSilver/admin/shop_edit_item.tpl
copy templates/admin/shop_edit_body.tpl to templates/subSilver/admin/shop_edit_shop.tpl
copy templates/admin/shop_edit_user.tpl to templates/subSilver/admin/shop_edit_user.tpl
copy templates/shop/shop_action_discard.tpl to templates/subSilver/shop/shop_action_discard.tpl
copy templates/shop/shop_action_give.tpl to templates/subSilver/shop/shop_action_give.tpl
copy templates/shop/shop_action_trade.tpl to templates/subSilver/shop/shop_action_trade.tpl
copy templates/shop/shop_buy.tpl to templates/subSilver/shop/shop_buy.tpl
copy templates/shop/shop_districts.tpl to templates/subSilver/shop/shop_districts.tpl
copy templates/shop/shop_inventory_body.tpl to templates/subSilver/shop/shop_inventory_body.tpl
copy templates/shop/shop_item_body.tpl to templates/subSilver/shop/shop_item_body.tpl
copy templates/shop/shop_list.tpl to templates/subSilver/shop/shop_list.tpl
copy templates/shop/shop_list_body.tpl to templates/subSilver/shop/shop_list_body.tpl
copy templates/shop/shop_sell.tpl to templates/subSilver/shop/shop_sell.tpl    
copy images/icon_shop.gif to templates/subSilver/images/icon_shop.gif

#
#-----[ SQL ]------------------------------------------
#
# You can either alter the table prefix and run this through phpMyAdmin or
# upload the sql_install.php file to your forum index and run it from an
# admin account. No need to do both... SQL install file is made for MySQL.
#
CREATE TABLE `phpbb_shopitems` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `shop` varchar(32) NOT NULL default '',
  `sdesc` varchar(80) NOT NULL default '',
  `ldesc` text NOT NULL,
  `cost` int(20) unsigned default '100',
  `stock` tinyint(3) unsigned default '10',
  `maxstock` tinyint(3) unsigned default '100',
  `sold` int(5) unsigned NOT NULL default '0',
  `accessforum` int(4) default '0',
  `special_link` varchar(255) NOT NULL default '',
  `synth` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
);

CREATE TABLE `phpbb_shops` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `shopname` varchar(32) NOT NULL default '',
  `shoptype` varchar(32) NOT NULL default '',
  `type` varchar(32) NOT NULL default '',
  `d_type` tinyint(3) NOT NULL default '0',
  `district` tinyint(3) NOT NULL default '0',
  `restocktime` int(20) unsigned default '86400',
  `restockedtime` int(20) unsigned default '0',
  `restockamount` int(4) unsigned default '5',
  `url` varchar(255) default NULL,
  `shop_owner` varchar(32) NOT NULL default '',
  `template` varchar(32) NOT NULL default '',
  `item_template` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `shopname` (`shopname`)
);

CREATE TABLE `phpbb_transactions` (
  `id` int(10) NOT NULL auto_increment,
  `user_id` int(5) NOT NULL default '0',
  `target_id` int(5) NOT NULL default '0',
  `target_name` varchar(32) NOT NULL default '',
  `type` varchar(32) NOT NULL default '',
  `action` varchar(32) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  `misc` text NOT NULL,
  `ip` varchar(16) NOT NULL default '',
  `timestamp` int(32) default NULL,
  PRIMARY KEY `id` (`id`)
);


CREATE TABLE `phpbb_user_items` (
  `id` int(20) NOT NULL auto_increment,
  `user_id` int(20) NOT NULL default '0',
  `item_id` int(20) NOT NULL default '0',
  `item_name` varchar(32) NOT NULL default '',
  `item_l_desc` text NOT NULL,
  `item_s_desc` varchar(100) NOT NULL default '',
  `worn` tinyint(1) NOT NULL default '0',
  `die_time` int(20) NOT NULL default '0',
  `special` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `item_id` (`item_id`),
  KEY `user_id` (`user_id`)
);

INSERT INTO `phpbb_config` VALUES ('multibuys', 'on');
INSERT INTO `phpbb_config` VALUES ('restocks', 'on');
INSERT INTO `phpbb_config` VALUES ('sellrate', '55');
INSERT INTO `phpbb_config` VALUES ('viewtopic', 'images');
INSERT INTO `phpbb_config` VALUES ('viewprofile', 'images');
INSERT INTO `phpbb_config` VALUES ('viewinventory', 'grouped');
INSERT INTO `phpbb_config` VALUES ('viewtopiclimit', '5');
INSERT INTO `phpbb_config` VALUES ('shop_orderby', 'name');
INSERT INTO `phpbb_config` VALUES ('shop_give', 'on');
INSERT INTO `phpbb_config` VALUES ('shop_trade', 'on');
INSERT INTO `phpbb_config` VALUES ('shop_discard', 'on');
INSERT INTO `phpbb_config` VALUES ('shop_invlimit', '0');
INSERT INTO `phpbb_config` VALUES ('shop_owners', 'on');
INSERT INTO `phpbb_config` VALUES ('shop_districts', 'off');
INSERT INTO `phpbb_config` VALUES ('points_name', 'Gold');
ALTER TABLE `phpbb_users` ADD `user_trade` TEXT;

#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
#
 This mod requires a folder structure by shop/images/ in
 your main phpBB forum directory. Within this directory
 all of your item images should be located!

#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
#
 If you are updating from a previous version of this mod, you
 will need to upload the update/update_items.php file to your
 forum index and run it ONCE. Once it is run, delete it. All 
 your old items should now be in the new table, and the old 
 items deleted. Make sure this mod is completely installed 
 before you run it...

 Other updates for files and tables will be released at a 
 later date. This is a BETA.

#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
define('USER_ITEMS_TABLE', $table_prefix.'user_items');
define('SHOP_TABLE', $table_prefix.'shops');
define('SHOP_ITEMS_TABLE', $table_prefix.'shopitems');
define('TRANS_TABLE', $table_prefix.'transactions');

#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]------------------------------------------
#
    'L_MEMBERLIST' => $lang['Memberlist'],
    'L_FAQ' => $lang['FAQ'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
    'L_SHOP' => 'Shops',

#
#-----[ FIND ]------------------------------------------
#
    'U_LOGIN_LOGOUT' => append_sid($u_login_logout),
    'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),

#
#-----[ AFTER, ADD ]------------------------------------------
#
    'U_SHOP' => append_sid('shop.'.$phpEx),

#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_viewprofile.php

#
#-----[ FIND ]------------------------------------------
#
$template->assign_vars(array(
    'USERNAME' => $profiledata['username'],

#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Shop Code
//
if ( $board_config['viewprofile'] == 'images' )
{
    $sql = "SELECT *
        FROM " . USER_ITEMS_TABLE . "
        WHERE user_id='{$profiledata['user_id']}'
            AND ( worn = 0 or worn = 1 )
        GROuP BY `item_name`
        ORDER BY `id`";
    if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error!'); }
    $num_rows = $db->sql_numrows($result);

    $user_items = '<br />';

    for ( $iz = 0; $iz < $num_rows; $iz++ )
    {
        $row = $db->sql_fetchrow($result);

        if (file_exists('shop/images/' . $row['item_name'] . '.jpg'))
        {
            $user_items .= ' <img src="shop/images/' . $row['item_name'] . '.jpg" title="' . $row['item_name'] . '" alt="' . $row['item_name'] . '" ' . $border . '>';
        }
        elseif (file_exists('shop/images/' . $row['item_name'] . '.png'))
        {
            $user_items .= ' <img src="shop/images/' . $row['item_name'] . '.png" title="' . $row['item_name'] . '" alt="' . $row['item_name'] . '" ' . $border . '>';
        }
        elseif (file_exists('shop/images/' . $row['item_name'] . '.gif'))
        {
            $user_items .= ' <img src="shop/images/' . $row['item_name'] . '.gif" title="' . $row['item_name'] . '" alt="' . $row['item_name'] . '" ' . $border . '>';
        }
    }
    $usernameurl = '<a href="'.append_sid('shop.'.$phpEx.'?action=inventory&searchid='.$profiledata['user_id'], true).'" class="gensmall"><b>Items</b></a>: ';
}
elseif ( $board_config['viewprofile'] == 'link' )
{
    $usernameurl = '<a href="'.append_sid('shop.'.$phpEx.'?action=inventory&searchid='.$profiledata['user_id'], true).'" class="gensmall"><b>Items</b></a>';
}

#
#-----[ FIND ]------------------------------------------
#
    'YIM' => $yim,

#
#-----[ AFTER, ADD ]------------------------------------------
#
    'INVENTORYLINK' => $usernameurl,
    'INVENTORYPICS' => $user_items,

#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php

#
#-----[ FIND ]------------------------------------------
#
    $template->assign_block_vars('postrow', array(

#
#-----[ BEFORE, ADD ]------------------------------------------
#

if ( $board_config['viewtopic'] == 'images' )
{
    $sql = "SELECT *
        FROM " . USER_ITEMS_TABLE . "
        WHERE user_id='{$postrow[$i]['user_id']}'
            AND ( worn = 0 or worn = 1 )
        GROuP BY `item_name`
        ORDER BY `id`";
    if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error!'); }
    $num_rows = $db->sql_numrows($result);

    $num_rows = ( ( $num_rows > $board_config['viewtopiclimit'] ) && ( $board_config['viewtopiclimit'] ) )  ? $board_config['viewtopiclimit'] : $num_rows;

    $user_items = '<br />';

    for ( $iz = 0; $iz < $num_rows; $iz++ )
    {
        $row = $db->sql_fetchrow($result);

        if (file_exists('shop/images/' . $row['item_name'] . '.jpg'))
        {
            $user_items .= ' <img src="shop/images/' . $row['item_name'] . '.jpg" title="' . $row['item_name'] . '" alt="' . $row['item_name'] . '" ' . $border . '>';
        }
        elseif (file_exists('shop/images/' . $row['item_name'] . '.png'))
        {
            $user_items .= ' <img src="shop/images/' . $row['item_name'] . '.png" title="' . $row['item_name'] . '" alt="' . $row['item_name'] . '" ' . $border . '>';
        }
        elseif (file_exists('shop/images/' . $row['item_name'] . '.gif'))
        {
            $user_items .= ' <img src="shop/images/' . $row['item_name'] . '.gif" title="' . $row['item_name'] . '" alt="' . $row['item_name'] . '" ' . $border . '>';
        }
    }
    $usernameurl = append_sid('shop.'.$phpEx.'?action=inventory&searchid='.$postrow[$i]['user_id'], true);
}
elseif ( $board_config['viewtopic'] == 'link' )
{
    $usernameurl = append_sid('shop.'.$phpEx.'?action=inventory&searchid='.$postrow[$i]['user_id'], true);
}

#
#-----[ FIND ]------------------------------------------
#
        'SIGNATURE' => $user_sig,
        'EDITED_MESSAGE' => $l_edited_by,

#
#-----[ AFTER, ADD ]------------------------------------------
#
        'ITEMSNAME' => $usernameurl,
        'ITEMS' => $user_items,

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/overall_header.tpl

#
#-----[ FIND ]------------------------------------------
#
                        <td align="center" valign="top" nowrap="nowrap"><span class="mainmenu">&nbsp;<a href="{U_FAQ}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_faq.gif" width="12" height="13" border="0" alt="{L_FAQ}" hspace="3" />{L_FAQ}</a> 

#
#-----[ IN-LINE FIND  ]------------------------------------------
#
 hspace="3" />{L_FAQ}</a>

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
&nbsp; &nbsp;<a href="{U_SHOP}" class="mainmenu"><img src="templates/subSilver/images/icon_shop.gif" width="12" height="13" border="0" alt="{L_SEARCH}" hspace="3" />{L_SHOP}</a>

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/profile_view_body.tpl

#
#-----[ FIND ]------------------------------------------
#
        <tr> 
          <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_INTERESTS}:</span></td>
          <td> <b><span class="gen">{INTERESTS}</span></b></td>
        </tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
        <tr> 
          <td valign="top" align="right" nowrap="nowrap"><span class="gen">{INVENTORYLINK}</span></td>
          <td> <span class="gen">{INVENTORYPICS}</span></td>
        </tr>

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/viewtopic_body.tpl

#
#-----[ FIND ]------------------------------------------
#
        <td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}<br /><br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}<br />{postrow.CASH}</span><br /></td>

#
#-----[ IN-LINE FIND  ]------------------------------------------
#
{postrow.POSTER_FROM}

#
#-----[ IN-LINE AFTER, ADD  ]------------------------------------------
#
<a href="{postrow.ITEMSNAME}">Items</a><br />{postrow.ITEMS}

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

und das die des cash mods (sql daten) :

Code:

# 
#-----[ SQL ]------------------------------------------
#
#   If you don't know how to execute sql queries, then copy
#   sql_install.php into your phpbb directory and run it.
#   (assuming you use mysql or mssql)
#
#   If you don't use mysql or mssql, you'll have to edit these queries accordingly
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_display_after_posts',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_post_message','Du hast %s mit deinem Beitrag verdient');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_num',10);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_time',24);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_message','Du hast die maximale Anzahl an Beiträgen überschritten und verdienst mit deinem Beitrag nichts');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_installed','yes');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_version','2.2.3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminbig','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminnavbar','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_name','Points');

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 
CREATE TABLE phpbb_cash (
  cash_id smallint(6) NOT NULL auto_increment,
  cash_order smallint(6) NOT NULL default '0',
  cash_settings smallint(4) NOT NULL default '3313',
  cash_dbfield varchar(64) NOT NULL default '',
  cash_name varchar(64) NOT NULL default 'GP',
  cash_default int(11) NOT NULL default '0',
  cash_decimals tinyint(2) NOT NULL default '0',
  cash_imageurl varchar(255) NOT NULL default '',
  cash_exchange int(11) NOT NULL default '1',
  cash_perpost int(11) NOT NULL default '25',
  cash_postbonus int(11) NOT NULL default '2',
  cash_perreply int(11) NOT NULL default '25',
  cash_maxearn int(11) NOT NULL default '75',
  cash_perpm int(11) NOT NULL default '0',
  cash_perchar int(11) NOT NULL default '20',
  cash_allowance tinyint(1) NOT NULL default '0',
  cash_allowanceamount int(11) NOT NULL default '0',
  cash_allowancetime tinyint(2) NOT NULL default '2',
  cash_allowancenext int(11) NOT NULL default '0',
  cash_forumlist varchar(255) NOT NULL default '',
  PRIMARY KEY  (cash_id)
);

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 
CREATE TABLE phpbb_cash_events (
  event_name varchar(32) NOT NULL default '',
  event_data varchar(255) NOT NULL default '',
  PRIMARY KEY  (event_name)
);

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 
CREATE TABLE phpbb_cash_exchange (
  ex_cash_id1 int(11) NOT NULL default '0',
  ex_cash_id2 int(11) NOT NULL default '0',
  ex_cash_enabled int(1) NOT NULL default '0',
  PRIMARY KEY  (ex_cash_id1,ex_cash_id2)
);

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 
CREATE TABLE phpbb_cash_groups (
  group_id mediumint(6) NOT NULL default '0',
  group_type tinyint(2) NOT NULL default '0',
  cash_id smallint(6) NOT NULL default '0',
  cash_perpost int(11) NOT NULL default '0',
  cash_postbonus int(11) NOT NULL default '0',
  cash_perreply int(11) NOT NULL default '0',
  cash_perchar int(11) NOT NULL default '0',
  cash_maxearn int(11) NOT NULL default '0',
  cash_perpm int(11) NOT NULL default '0',
  cash_allowance tinyint(1) NOT NULL default '0',
  cash_allowanceamount int(11) NOT NULL default '0',
  cash_allowancetime tinyint(2) NOT NULL default '2',
  cash_allowancenext int(11) NOT NULL default '0',
  PRIMARY KEY  (group_id,group_type,cash_id)
);

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 
CREATE TABLE phpbb_cash_log (
  log_id int(11) NOT NULL auto_increment,
  log_time int(11) NOT NULL default '0',
  log_type smallint(6) NOT NULL default '0',
  log_action varchar(255) NOT NULL default '',
  log_text varchar(255) NOT NULL default '',
  PRIMARY KEY  (log_id)
);

beim zarath mod hab ich mehrere versionen ausprobiert und die sql daten in der db nie ausgebaut. kann also auch daran liegen. ich hoffe mir kann jemand weiterhelfen. ich kann auch die daten für db&ftp zugang geben , dazu schreibt mir einfach ne pn .
mfg