[FIXED] [3.7.x] Answer Forums 1.0.0 Premium [Nulled by Psilocybin]

[bulletin]

You can find description here http://www.vbteam.info/vb-3-7-x-addons-template-modifications/10671-3-7-x-answer-forums-1-0-0-premium-nulled-psilocybin.html

I have only fixed the mysql error in this xml file.

Only thing you need to insert a sql line in forum and thread table, through phpmyadmin and your premium answer forum is ready.

Any error you still find, please reply here, i will fix it.

Thanks.

 

[whopper]

Thanks for this m8

 

[esupport]

what is the sql that is required to put in phpmyadmin please for this mod

 

[bulletin]

what is the sql that is required to put in phpmyadmin please for this mod

Go to PHPMyAdmin then see the table forum, there you need to add only one line

g_answer_forum smallint(2) unsigned not null

again now go to table thread, there you need to add only one line

g_answer_forum_answer int(10) unsigned not null default

thats all now its done, and your answer forum is ready to work.

please remember to give permission in your forum category, select any forum category where you want answer forum mod to work very well.

 

[AWC108]

bulletin,

I still don't see g_answer_forum smallint(2) unsigned not null and g_answer_forum_answer int(10) unsigned not null default

it's giving me error!

 

[bulletin]

bulletin,

I still don't see g_answer_forum smallint(2) unsigned not null and g_answer_forum_answer int(10) unsigned not null default

it's giving me error!

you will not see that, you need to add that sql line through phpmyadmin.

 

[alexD]

I added the queries to a php install file. You will have to add your server details to the file!

Add first the database name to this section of the code;

$DBName = "";

type in between the double quotes your forums database name

Second find this:

$DBConnect mysqli_connect(localhost, username, password);

Enter your hosts info and your username and password.

Then save the changes and upload to your server if all is well it will install the tables for you and your forum will work.

* NOTE: you will need to running php 5 to use this script I`ll make a php 4 soon my php 4 is a bit rusty.

Any question post here and i`ll help you as much as I can. Also backup your database!!

 

[bulletin]

I added the queries to a php install file. You will have to add your server details to the file!

Add first the database name to this section of the code;

$DBName = "";

type in between the double quotes your forums database name

Second find this:

$DBConnect mysqli_connect(localhost, username, password);

Enter your hosts info and your username and password.

Then save the changes and upload to your server if all is well it will install the tables for you and your forum will work.

* NOTE: you will need to running php 5 to use this script I`ll make a php 4 soon my php 4 is a bit rusty.

Any question post here and i`ll help you as much as I can. Also backup your database!!

is this new table made by you? I didnt find any problems with the sql file i had added in answer forum, it works smoothly on my site.

 

[alexD]

Yeah sorry about that I didnt fully read it mate, but yeah the file creates 2 new tables as you`ve specified in your first post, I can make it so they add to the tables you stated but with me only knowing php 5 pro my php 4 mysql connect coding inst very good,

instead of $DBConnect use $db mysql_conn(localhost, username, password);

and instead of $SQlstring use $query = "/* add $SQLstring info here replace with all thats in the double quotes*/"; and use $return mysql_query($db, $query);

actually can someone test this to see if it works as a seperate tables or not i not i`ll fix it so it adds the tables he showed.

 

[alexD]

sorry sorry i forgot to add the = sign after $DBConnect is should show $DBConnect = mysqli_conect(/* forgot the rest but this part wont change delete this commnet */);

 

[BlackLizard]

still missing a column in the 'user' table can any one get this.

 

[BlackLizard]

still missing a column in the 'user' table can any one get this.

Problem solved. , found a more updated version of this hack which has all the needed queries. SO if any one is interested in using this hack do a quick search for this updated version

cheers

 

[dudl3ys]

i just uploaded this over the other one i found and it works fine for me on a beta board

 

[bulletin]

I have found a small bug in Answer Forum, if you have installed VbBux/VbPlaza then please do not activate that in answer forum option. Use vbcredits as point system for your answer forum. I am still working on to fix vbbux/vbplaza bugs in answer forum.

 

[Kryptonit3]

thank you PP

 

[[TgA] ATI]

I got this error:

Database error in vBulletin 3.7.4:

Invalid SQL:
UPDATE forum SET
title_clean = 'Tech Support',
title = 'Tech Support',
description_clean = 'Ask tech questions and get support here.',
description = 'Ask tech questions and get support here.',
link = '',
displayorder = 1,
parentid = 7,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
g_answer_forum = '1'
WHERE forumid = 19;

MySQL Error : Unknown column 'g_answer_forum' in 'field list'
Error Number : 1054
Request Date : Friday, December 5th 2008 @ 05:04:10 PM
Error Date : Friday, December 5th 2008 @ 05:04:10 PM
Script : Log in - Team Gamers Anonymous Forums - vBulletin Admin Control Panel
Referrer : Log in - Team Gamers Anonymous Forums - vBulletin Admin Control Panel
IP Address : 192.168.0.1
Username : [TgA] Ati
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt