Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 01-04-2004, 12:27 PM
TouchingVirus's Avatar
TouchingVirus TouchingVirus is offline
 
Join Date: Nov 2001
Location: Bogland
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vb3 and mysql

Hey, i was hopin you would be able to help me with this *half-request*/*half-cry for help*

I have created a table in mysql with 3 fields, (userid, spam, real)

When the user creates a thread in say forumid==2 the post is counted as a Real post..

when the user creats a thread in say forumid==14 the post is counted as a spam post (its in the spam forum )

I want to make it so that when the user makes 2 threads in spam forum, that the value of spam increments to two,three, etc...and when they delete a thread, then it decrements..and the same for the "real" value.

I would also like to know how will i distinguish wheter or not the userid is already in the table?

For example i can easily use this statement

PHP Code:
if (($foruminfo['forumid']=='7') || ($foruminfo['forumid']=='11') || ($foruminfo['forumid']=='21'))
{
$DB_site->query("INSERT INTO pubscan (userid,spam,real) VALUES('".$bbuserinfo['userid']."',$countspam,$countreal)");

But this will throwback an error if the userid is already there...so the alternative is to use the UPDATE function...but how do i check if a userid is already there??

I can run a SQL statement like

PHP Code:
SELECT from spamreal WHERE userid=".$bbuserinfo['userid']."
but how do i check if it comes back empty?
Reply With Quote
  #2  
Old 01-05-2004, 05:46 AM
hwtan hwtan is offline
 
Join Date: Dec 2003
Location: Singapore
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not exactly sure what you want to do, but would it be possible to do this instead?

PHP Code:
SELECT useridcount(*) as postcountforumid FROM postthread 
WHERE post
.threadid thread.threadid GROUP BY userid,forumid
Alternatively, you can try using REPLACE instead. It works like a DELETE followed by a INSERT.

PHP Code:
REPLACE pubscan (userid,spam,realVALUES($bbuserinfo[userid], $countspam,$countreal); 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:05 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03675 seconds
  • Memory Usage 2,164KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete