vB User Add Forums 1.0

CONSTRUCTION STOPPED READY FOR vB3.0.0 RC1 HACK RELEASE.


Features Going To Be In The vB3 Version Of This Hack.

Administrators Settings:

• On / Off Master Switch. (yes / no)
• Inactive Reason. (textarea)
• Allow Usage By Usergroupid. (input box)
• Disallow Usage By Userid. (input box)
• Individual Allowence Of Forum Settings. (yes / no's)
• Allow Forum Creator To Be Moderator (yes / no)
• Show Forum Added In User Profile (yes / no)
• Make Forum Under Chosen Categorie (yes / no)
• If Above Is YES Categorie ID (input box)

Plenty more to come but thats all for now still alot to add..

[wolfe]

i am working on implementing all of the above will get back to you all

[narulure]

O_O this hack would take up lots of database......if you have lots of members

[wolfe]

well upto now i have sorted it so the query is somethign like this

PHP Code:


SELECT forumid,title,allowposting
FROM forum
WHERE forumid='$parforumid'
AND title='$parforumtitle' 


$parforumid = (user selected forumid in the admin options)
$parforumtitle = (user selected forum title in the admin options)

i have also sorted the store intergration out here it is

First run this query

PHP Code:


INSERT INTO `store` (`id`,`action`,`title`,`costs`,`sold`,`imgurl`,`description`,`ok`,`quantity`) VALUES (NULL,'userforum','Buy a Create your own forum pass.','15000','0','images/buyforum.gif','With this action you can buy a create your own forum pass','Y','0'); 


then in store.php find:

PHP Code:


?> 


and above add the following

PHP Code:


// ###################### User Buy & Create Own Forum #######################
if ($action=="userforum") {

  $stores = $DB_site->query_first("SELECT * FROM store WHERE action='userforum'");
  $storeid = $stores[id];
  $cost = $stores[costs];
  $need = $points - $cost;
  
  $users = $DB_site->query_first("SELECT userforum FROM user WHERE userid='$bbuserinfo[userid]'");
  $forums = $users[userforum];
  $forumsallow = $users[userforum]+1;

if ($forums==1) { 
   $unote="Forum"; 
} else { 
   $unote="Forum's"; 
} 

if ($forumsallow==1) { 
  $anote="Forum"; 
} else { 
  $anote="Forum's";
}  
  
if ($cost>$points) {
  eval("standarderror(\"".gettemplate('store_error')."\");");
}

  eval("dooutput(\"".gettemplate("store_buyuserforum_verify")."\");");
}

// ###################### Start User Buy & Create Own Forum #######################
if ($action=="buyuserforum") {

if ($cost>$points) {
  eval("standarderror(\"".gettemplate('store_error')."\");");
} else {

  $forumsbuy=$DB_site->query("UPDATE user SET storep=storep-$cost WHERE userid='$bbuserinfo[userid]'");
  $changestoresold=$DB_site->query("UPDATE store SET sold=sold+1 WHERE id=$storeid");
  $changeuserforums=$DB_site->query("UPDATE user SET userforum=userforum+1 WHERE userid='$bbuserinfo[userid]'");

  $moneycheck = $DB_site->query_first("SELECT storep FROM user WHERE userid='$bbuserinfo[userid]'");
  $money = $moneycheck[storep];

eval("dooutput(\"".gettemplate("store_buyuserforum_brought")."\");");
  }
} 


then add the following templates in the txt file


NOTE: You will have to have the new version of this hack installed to get the full benifits of this store intergration.

[The General]

Cool hack!

Is it also possible for the creator of the forum to make it a private forum AND give access to individual users?

I guess that's too much to ask, but hey! I can always try. =D

[supernut]

i hope its converted for version 3vb, i will install it then, i cannot wait for all the options ot be added and converted for 3

[supernut]

now we know that VB3 beta is out friday, any idea if you will convert it sooner then later to run on 3 ?

[csidlernet]

This is one to be installed :P

[kaotic]

Hey, found a small problem. The second query = bad.

ALTER TABLE `forums` ADD `addedby` char( 50 ) NOT NULL

Should be changed to:

ALTER TABLE `forum` ADD `addedby` char( 50 ) NOT NULL

[wolfe]

thanx d00d fixed updated zip

[kaotic]

One more problem. With the store integration update, I get the following error when I try to purchase a forum (the very first screen after clicking the buy button):

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT userforum FROM user WHERE userid='102'
mysql error: Unknown column 'userforum' in 'field list'

mysql error number: 1054

Date: Friday 13th of June 2003 08:12:29 AM
Script: http://www.mykewlsecretsite.com/foru...tion=userforum
Referer: http://forums.mykewlsecretsite.com/store.php

Notes: I did run the query, I edited store.php, and I'm running the latest version of this hack.

I'm sure I can find a solution on my own, I just thought you should know.