config['Database']['dbname']; $prefix = $vbulletin->config['Database']['tableprefix']; $fieldnameexist = $tableexist = 0; $guthaben = array (); $tabelle = $prefix . $table; $tableid = @mysql_list_fields ($dbname, $tabelle); if ($tableid) { // die tabelle existiert !!! $tableexist = 1; for ($x = 0;$x < 1000;$x++) { $tname = @mysql_fieldname($tableid, $x); if ($tname == "") break; elseif ($tname == $tablename) $fieldnameexist = 1; } } return array($tableexist, $fieldnameexist); } function add_or_sub_guthaben ($userid, $money, $what, $phrase) { global $db, $vbphrase; $ghuser = $db->query_first("SELECT `guthaben` FROM `" . TABLE_PREFIX . "user` WHERE `userid`='" . intval ($userid) . "'"); $mycredit = $ghuser['guthaben']; if ($what == 'minus') { $mycredit = $mycredit - intval ($money); if ($mycredit < 0) $mycredit = 0; } else $mycredit = $mycredit + intval ($money); $ktoinserttext = $vbphrase[$phrase]; $db->query("UPDATE `" . TABLE_PREFIX . "user` SET `guthaben`='" . intval ($mycredit) . "' WHERE `userid`='" . intval ($userid) . "'"); $db->query("INSERT INTO `" . TABLE_PREFIX . "kontoauszug` (`kid`,`userid`,`datum`,`info`,`betrag`,`art`) VALUES ('','" . intval ($userid) . "','" . time () . "','" . addslashes ($ktoinserttext) . "','" . intval ($money) . "','" . $what . "')"); } ($hook = vBulletinHook::fetch_hook('guthaben_module_start') ) ? eval($hook) : false; $registertbl = check_table ('guthaben', 'gutid'); if ($registertbl[0]) { $ghconfigtable = $db->query_first ("SELECT * FROM `" . TABLE_PREFIX . "guthaben`"); if ($ghregister == 1) { $registertbl = check_table ('guthaben', 'registerguthaben'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($ghconfigtable['registerguthaben'] AND $ghuserid) add_or_sub_guthaben ($ghuserid, $ghconfigtable['registerguthaben'], 'plus', 'register_guthaben'); } if ($vbulletin->GPC['referrername']) { $registertbl = check_table ('guthaben', 'werben'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { $rfuser = $db->query_first("SELECT `referrerid` FROM `" . TABLE_PREFIX . "user` WHERE `userid`='" . intval ($userid) . "'"); if ($rfuser['referrerid'] AND $ghconfigtable['werben']) { add_or_sub_guthaben ($rfuser['referrerid'], $ghconfigtable['werben'], 'plus', 'recruited_guthaben'); } } } } elseif ($ghnewthread == 1) { $registertbl = check_table ('guthaben', 'threadguthaben'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($ghconfigtable['threadguthaben'] AND $ghuserid) add_or_sub_guthaben ($ghuserid, $ghconfigtable['threadguthaben'], 'plus', 'thread_guthaben'); } } elseif ($ghpostajaxreply == 1) { $registertbl = check_table ('guthaben', 'postajaxguthaben'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { $what = 'plus'; $money = $ghconfigtable['postajaxguthaben']; if (!$ghconfigtable['postajaxpm']) { $what = 'minus'; $money = $money - $money - $money; } if ($money) add_or_sub_guthaben ($ghuserid, $money, $what, 'post_ajax_guthaben'); } } elseif ($ghpostreply == 1) { $registertbl = check_table ('guthaben', 'postguthaben'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($_POST['p']) $ghpostid = $_POST['p']; else $ghpostid = 0; if ($ghpostid) { $ghpost = $db->query_first("SELECT `userid` FROM `" . TABLE_PREFIX . "post` WHERE `postid`='" . intval ($ghpostid) . "'"); if ($ghpost['userid'] AND $ghpost['userid'] == $ghuserid) { if ($ghconfigtable['selfpostguthaben']) add_or_sub_guthaben ($ghuserid, $ghconfigtable['selfpostguthaben'], 'minus', 'selfpost_guthaben'); } else { if ($ghconfigtable['postguthaben'] AND $ghuserid) add_or_sub_guthaben ($ghuserid, $ghconfigtable['postguthaben'], 'plus', 'post_guthaben'); } } else { if ($ghconfigtable['postguthaben'] AND $ghuserid) add_or_sub_guthaben ($ghuserid, $ghconfigtable['postguthaben'], 'plus', 'post_guthaben'); } if ($newpost['rating'] AND $ghconfigtable['rate_gut']) add_or_sub_guthaben ($ghuserid, $ghconfigtable['rate_gut'], 'plus', 'threadrate_guthaben'); } } elseif ($ghnewpm == 1) { $registertbl = check_table ('guthaben', 'pn_gut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($ghconfigtable['pnonoff'] AND $ghconfigtable['pn_gut'] AND $ghuserid) add_or_sub_guthaben ($ghuserid, $ghconfigtable['pn_gut'], 'plus', 'pm_guthaben'); } } elseif ($ghthreadrate == 1) { $registertbl = check_table ('guthaben', 'rate_gut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($ghconfigtable['rateonoff'] AND $ghconfigtable['rate_gut'] AND $ghuserid) add_or_sub_guthaben ($ghuserid, $ghconfigtable['rate_gut'], 'plus', 'threadrate_guthaben'); } } elseif ($ghshowthreadcomplete == 1) { $sgh = 0; if ($ghconfigtable['show_gutinthread']) { $sgh = 1; $post['rank'] .= "
" . $vbphrase['showguthaben'] . ": " . $post['guthaben'] . " " . $ghconfigtable['waehrung'] . "
"; } if ($ghconfigtable['show_ktointhread']) { if (!$sgh) $post['rank'] .= ""; $post['rank'] .= "
" . $vbphrase['showkonto'] . ": " . $post['userid'] . "
"; } } elseif ($ghusertitlestart == 1) { $registertbl = check_table ('guthaben', 'usetitgut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($ghconfigtable['usetitgut'] AND $ghuserid) { if ($vbulletin->userinfo['guthaben'] < $ghconfigtable['usetitgut']) { if ($vbulletin->userinfo['customtitle'] == 1) { $vbphrase['custom_user_title'] .= ' (' . $vbphrase['profile_usertitle_reset'] . ')'; $vbulletin->options['ctMaxChars'] .= "\" disabled=\"disabled\""; } else $vbulletin->bf_ugp_genericpermissions['canusecustomtitle'] = 0; } else { $vbphrase['custom_user_title'] .= ' (' . $vbphrase['profile_usertitle_add'] . ' ' . $ghconfigtable['usetitgut'] . ' ' . $ghconfigtable['waehrung'] . ')'; } } } } elseif ($ghusertitlestart == 2) { $registertbl = check_table ('guthaben', 'usetitgut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($vbulletin->GPC['resettitle']) { } else { if ($vbulletin->GPC['customtext'] AND $vbulletin->userinfo['usertitle'] != $vbulletin->GPC['customtext']) { if ($vbulletin->userinfo['guthaben'] < $ghconfigtable['usetitgut']) { } else { if ($ghconfigtable['usetitonoff'] AND $ghconfigtable['usetitgut'] AND $ghuserid) add_or_sub_guthaben ($ghuserid, $ghconfigtable['usetitgut'], 'minus', 'usertitle_guthaben'); } } } } } elseif ($ghownavatar == 1) { $registertbl = check_table ('guthaben', 'ava_ea_gut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($ghconfigtable['avaeaonoff'] AND ($vbulletin->userinfo['guthaben'] < $ghconfigtable['ava_ea_gut'])) { $noownpic = construct_phrase ($vbphrase['ownpic_nomoney'], $vbulletin->userinfo['guthaben'], $ghconfigtable['waehrung'], $ghconfigtable['ava_ea_gut']); eval (standard_error ($noownpic)); exit(); } elseif ($ghconfigtable['avaeaonoff']) { $vbphrase['custom_profile_picture'] .= ' (' . $vbphrase['profile_usertitle_add'] . ' ' . $ghconfigtable['ava_ea_gut'] . ' ' . $ghconfigtable['waehrung'] . ')'; } } } elseif ($ghownavatar == 2 AND $ghconfigtable['avaeaonoff']) { $registertbl = check_table ('guthaben', 'ava_ea_gut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if (!$userpic->condition) add_or_sub_guthaben ($ghuserid, $ghconfigtable['ava_ea_gut'], 'minus', 'useravatar_guthaben'); } } elseif ($ghboardavatar == 1) { $registertbl = check_table ('guthaben', 'ava_ea_gut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if ($ghconfigtable['avabaonoff'] AND ($vbulletin->userinfo['guthaben'] < $ghconfigtable['ava_ba_gut'])) $vbulletin->bf_ugp_genericpermissions['canuseavatar'] = 0; else $vbphrase['custom_avatar'] .= ' (' . $vbphrase['profile_usertitle_add'] . ' ' . $ghconfigtable['ava_ea_gut'] . ' ' . $ghconfigtable['waehrung'] . ')'; } } elseif ($ghboardavatar == 2 AND $ghconfigtable['avabaonoff']) { $registertbl = check_table ('guthaben', 'ava_ea_gut'); $ghcheck = check_table ('user', 'guthaben'); if ($ghcheck[0] AND $ghcheck[1] AND $registertbl[0] AND $registertbl[1]) { if (!$vbulletin->GPC['avatarid']) { if (!$userpic->condition) add_or_sub_guthaben ($ghuserid, $ghconfigtable['ava_ea_gut'], 'minus', 'useravatar_guthaben'); } } } ($hook = vBulletinHook::fetch_hook('guthaben_module_end')) ? eval($hook) : false; } ?>