vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Tutorial Hack (https://vborg.vbsupport.ru/showthread.php?t=58919)

bandersen 01-24-2004 03:04 PM

Thanks for the update!

I get this tho....

Invalid SQL:
SELECT COUNT(*) as total
FROM tutorials
WHERE tutcat ='7' and tutmodded = '1'
mysql error: Unknown column 'tutmodded' in 'where clause'

assassingod 01-24-2004 03:16 PM

Run this query:
[sql]
ALTER TABLE tutorials ADD tutmodded INT(6)
[/SQL]

bandersen 01-24-2004 03:25 PM

Yes, now it works!
But I lost all the tutorials already in there.....

assassingod 01-24-2004 03:31 PM

Really? How odd. Did you do anything else?

bandersen 01-24-2004 03:36 PM

No...
They just got zero'd out sort of...

If I look in the admin panel I can still see the stats, like there should be something there, but if I click the link for most viewed tutorial.... it takes me to view a tutorial that is not there.

assassingod 01-24-2004 03:41 PM

They might be unmoderated. Go to the moderation page in the AdminCP, see if they are there.

bandersen 01-24-2004 03:47 PM

No unmoderated tuts.
10 tutorials (0 unmoderated)

edit: and if I click edit tutorial in the ADminCP... I can read the actual tut

assassingod 01-24-2004 03:50 PM

Run this query:
[SQL]
SELECT *
FROM tutorials
[/SQL]

See if there is a result. Hopefully they are still in the database.

bandersen 01-24-2004 03:56 PM

That did not help...

If I enter tut manager - modify - I can see them listed. If I click a link - I do see the actual tutorial text... so I guess they are there...
Everything looks OK in the adminCP.

assassingod 01-24-2004 04:01 PM

But did you get any results from the query?

bandersen 01-24-2004 04:11 PM

in phpMyAdmin.... all the tutorials were listed.... when running SELECT *
FROM tutorials

assassingod 01-24-2004 04:11 PM

Ok, try running this:
PHP Code:

UPDATE tutorials SET tutmodded '1' 


bandersen 01-24-2004 04:16 PM

BINGO!!!!

They all show! Thank you for the support!!

assassingod 01-24-2004 04:18 PM

No problem:)

bandersen 01-24-2004 04:30 PM

Ops... search doesn't work.. but it works for the word "frank" :-) a bit random...
http://www.virtusphysica.com/forums/.../tutorials.php

Does it search tutorial name and text or just text....

assassingod 01-24-2004 05:08 PM

It only searches the tutorial name. Version 1.4 will have a better search engine this is just a simple one.

bandersen 01-24-2004 05:50 PM

OK - thank you for your work!

bandersen 01-25-2004 08:50 AM

One question: I am about to enter some 30 tutorials and some of them have tables and links in them. Can I turn on html somewhere while doing these initial entries and then turn it off again and the links etc will still be there?

thanks

bandersen 01-25-2004 11:49 AM

Hi again... sorry to bother you again. I have just entered the code for getting a random tutorial on the index page. That worked, but when I click the link, I am taken to a tutorial that do not show. Much like my initial problem. Could you help me "refresh it" from the database ?

EDIT: oh OK... the random tut on index page include those not mod. yet....

bandersen 01-25-2004 12:55 PM

How come all new tutorials show with a "bad tutorial" icon? How do I change that....

Fargo 01-25-2004 06:10 PM

Quote:

Originally Posted by assassingod
Everything working then?:)

Yes it does..perfectly even :D

thanks again for your contribution :)

assassingod 01-25-2004 07:14 PM

bandersen;
1. There's a fix somewhere in this thread.
2. I'll fix this tomorrow:)
3. Thats the mini-rating system. When a tutorial gets a certain amount of votes, it'll be classified as a good tutorial. I'll make a better one soon.

bandersen 01-25-2004 08:26 PM

I tried the below... but code didn't match for 1.3:
I changed the numbers in the following string with no html success (line 267 in tutorial.php):

$tut['text'] = bbcodeparse2($tut['tutpagetext'],1,1,1,1);



[QUOTE=assassingod]iceman-x, Areku;


Areku;
1. https://vborg.vbsupport.ru/showpost....3&postcount=53


But use this as the replacement:
PHP Code:

$tut[tutpagetext] = bbcodeparse2($tut[tutpagetext],1,1,1,1); 


assassingod 01-26-2004 05:59 AM

[QUOTE=bandersen]I tried the below... but code didn't match for 1.3:
I changed the numbers in the following string with no html success (line 267 in tutorial.php):

$tut['text'] = bbcodeparse2($tut['tutpagetext'],1,1,1,1);



Quote:

Originally Posted by assassingod
iceman-x, Areku;


Areku;
1. https://vborg.vbsupport.ru/showpost....3&postcount=53


But use this as the replacement:
PHP Code:

$tut[tutpagetext] = bbcodeparse2($tut[tutpagetext],1,1,1,1); 


I'll redo this for you tonight:)

Areku 01-26-2004 04:21 PM

Is it me or we get just the THUMBS DOWN icon on every tutorial?

Also, where do I allow HTML posting?

Thanks!

assassingod 01-26-2004 04:24 PM

Until it gets a certain ammount of votes, it'll stay with thumbs down. 1.4 will have a better system that the current one.

Areku 01-26-2004 04:26 PM

I don't think this is a nice way to display it... I mean, there may be old well known and good tutorials ported to your system which require thumbs up ;)

What about the HTML? ;)

Areku 01-26-2004 04:35 PM

Err... something weird has happened...

I upgraded from old hack version to 1.3 and now all the tutorials miss the NEW LINE codes, ie instead of reading:

This is line1
This is line2
This is line3

I get

This is line1This is line2This is line3

Ideas?

UPDATE: Well, actually no VB code is being converted at all!

assassingod 01-26-2004 04:39 PM

Edit:
I don't understand what you did. Did you upgrade?

Areku 01-26-2004 04:42 PM

I:

1) Downloaded
"// Tutorial Hack
// Coded By: assassingod

// Version: 1.3
"

from the first thread.

2) Ran the queries missing in the version I installed earlier

3) Added the new templates, updated the old ones with the new codes

4) Made the required changes on the files

5) Moderated old tutorials to appear on the new v1.3

Now, no BB code is parsed, although is stored correctly in the DB.

Ideas?

assassingod 01-26-2004 04:45 PM

Odd. I'll have to get back to you on that. But, try inserting <br /> for a new break and see what happens.

Areku 01-26-2004 05:00 PM

Am I expected to have HTML enabled without knowing?

Also, any of the VB code works at all... nor B, nor FONT, nothing....

Thanks assassingod!

Areku 01-26-2004 05:03 PM

Hmmm... it seems it supports HTML anyway, so that may be the explanation on why it's allowing HTML but disallowing BB code?!

Areku 01-26-2004 05:06 PM

Also, it seems $tutvoteno at tuts_tutvote template is not parsed...

assassingod 01-26-2004 05:06 PM

Yes, it's possible the code for parsing the tutorial content has been messed up. I'll cook up a fix ASAP.

assassingod 01-26-2004 05:07 PM

Quote:

Originally Posted by Areku
Also, it seems $tutvoteno at tuts_tutvote template is not parsed...

$tutvoteno is called in tutorials.php so it should be. I'll look into it

Areku 01-26-2004 05:32 PM

Well, may be u can add some switches like: ALLOW BBCODE yes/no? ALLOW HTML yes/no? ;)

Thanks for the fixes.

Right now I NEED BOTH Html and BB codes, for example.

Areku 01-26-2004 05:35 PM

And for tutno....

I guess you condition it to a YES until someone votes it YES? Until then, NO does not appear?

assassingod 01-26-2004 05:39 PM

Yes, this way it prevents users from being able to give a vote a minus number.

Areku 01-26-2004 06:23 PM

They still could do it by calling the URL intentionally I guess ;)



About the search feature... which field(s) does it search the text into?

I didn't manage to get any results using keywords found on title nor in content itself...


All times are GMT. The time now is 08:32 PM.

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.01727 seconds
  • Memory Usage 1,796KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete