How to convert Old vb code to New vb Code

hotwheels · 09-24-2006, 01:19 PM

also, what does GPC stand for?

Nick R · 09-24-2006, 02:23 PM

Once upon a time I knew....

Quote:

Originally Posted by hotwheels

k, So if i understand this, query_write, sends the post information to the database? query_read, read's and pulls the information from the database?

Is it possible to use something like:

You must first be a registered member to view any code.

Instead of:

You must first be a registered member to view any code.

?

That way, it would do the write or read request without having to specify the exact call?

I don't believe so and it is best to stick with $vbulletin->db because sometimes the $db var gets nulled.

hotwheels · 09-24-2006, 02:44 PM

Thanks..........also, i have been messing with the code a bit and found i am recieving this error:

Quote:

SELECT post.title, post.pagetext, post.postid
FROM post
WHERE post.threadid=914 AND post.postid!=14772 AND post.visible=1;

MySQL Error : Table 'hotwheel_forums.post' doesn't exist

In mysql database, everything from vbulletin is named vb3.....so in the php code, where it says "From post" should i change that too, "From vb3post" ?

hotwheels · 09-24-2006, 02:49 PM

Answered my own question.........NO

Quote:

SELECT post.title, post.pagetext, post.postid
FROM vb3post
WHERE post.threadid=914 AND post.postid!=14772 AND post.visible=1;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109

Remove the vb3 and i come back to this error:

Quote:

Invalid SQL:

SELECT post.title, post.pagetext, post.postid
FROM post
WHERE post.threadid=914 AND post.postid!=14772 AND post.visible=1;

MySQL Error : Table 'hotwheel_forums.post' doesn't exist
Error Number : 1146

I just tried

You must first be a registered member to view any code.

I don't recieve the vbulletin database error now.....but the call to write isn't working.

lmao.........I know i am close. dang it :p

hotwheels · 09-24-2006, 03:34 PM

Well thanks anyways, looks like i am in way over my head. You can go ahead and close this thread, i am done. Again, thanks anyways.

Nick R · 09-24-2006, 05:02 PM

what exactly are you trying to achieve? btw if you use this code

Quote:

SELECT post.title, post.pagetext, post.postid
FROM vb3post AS post
WHERE post.threadid=914 AND post.postid!=14772 AND post.visible=1;

then it will work ;)

hotwheels · 09-24-2006, 06:54 PM

This is what it was for: Learn I just thought it would only take a few edit's to make it work with 3.6.........waaaaaaaaay wrong I bet right now, i have over 30 hrs worth up edit, edit, edit and nothing..Should just pull one phrase and post and remember it in another post..

Nick R · 09-25-2006, 06:51 AM

unless I am mistaken: Talkerbot v2.2.2 for vb 3.6 ...?

hotwheels · 09-25-2006, 11:43 AM

This mod would be an add on to that mod. Currently the bot only know's what it inside its current program.

With the update i was trying to do, it would help the bot to learn what you want it too......It is a completely different mod in itself. The coding should be very simple, i just don't have the knowledge to get it set up on 3.6 yet........Tim did make an attempt to get the botlearner program to work, but he too hasn't had much success on a global level....given all the problem's people are running into with the different version's of vbulletin and the talkerbot, he is ver busy...

The php files that come with the botlearner program should work as currently set up, it is just a matter of getting the above code i was working on to understand what i am trying to get it to do.....

Basically, I should be able to start a new thread and add 1 post.........then put this information in my external php file........You shuld then be able to go to that new thread, click on "add reply" put in the question you want, and in the message section, type in the answer. Once that is done, you run this and it should move that information into the database. Then when you go back to talkerbot, it will remember that question and answer ane when a member asks the question, the bot will give the answer that you taught it.....
If you click on the link i showed in post 17, you will see the file that has the php codes in it (which seem fine) and in the original coder's instruction's, you will see the code changes he suggested for vbulletin3.0, but being on 3.6 those change's no longer work....

anyways, thanks for your time rogersnm.........I really do appreciate the responses......Not many site's help much when it come's to people wanting to learn code, even though some of the site's call themselves learning sites.

hotwheels · 09-25-2006, 12:05 PM

these are the old code suggestions in exteranal.php:

add Case Aiml and Case Aimlshare

You must first be a registered member to view any code.

in the else if chain, add

You must first be a registered member to view any code.

Now this is what i have so far:

You must first be a registered member to view any code.

and basically the same changes in the AIML call........which i believe are all RSS feeds....

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vb code for permisions	MONKEY_MAN	General vBulletin Support	2	08-14-2006 04:18 PM
User Cp Critical Error	Nick R	Site Feedback	6	08-03-2006 10:39 AM
Vb code problem	John Mullins	General vBulletin Support	4	06-22-2005 09:29 AM
Code Tag - Code Box Size	A-FXP-D3LTA	General vBulletin Support	2	04-16-2005 10:02 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)