vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3 Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=187)
-   -   Using the vBulletin Database Class (https://vborg.vbsupport.ru/showthread.php?t=119350)

Come2Daddy 09-25-2008 12:54 PM

Great Tutorial, it explained a wide area for me

thanx a lot

MyPornLife.info 10-09-2009 03:47 PM

very useful article...tnx

Pudelwerfer 11-19-2009 06:38 PM

you can use global $db; too an work with $db-> ... instead $vbulletin->db-> ...

But i have another question:

Where can i find all aissigned users of a ticket?

In my db in pt_issueassign is only one id of all assigned users.

For Example - i have 3 users assigned, see all listed on top of the issue, but in the pt_issueassign is only one id. Not special id, think random. Is it me?

It would very helpfully, if anyone can helb me to find all assigned users in the db.

Edit: Oooh i forgot to say, it is a table from the project tools. Wrong Board - Sorry for the mistake -

Thank you, MJ

PS: please sorry for my english

emath 03-05-2010 06:16 PM

thanks alot man it was very helpful

glaive 03-20-2010 01:14 AM

Quote:

Originally Posted by Panman (Post 1325782)
What is the method to use if you'd like to execute a DELETE SQL statement?

A quick snippet from my own embedded photo contest software I am writing.
PHP Code:

$pc_sql 'DELETE from pictures WHERE pic_id = '.$pc_num_ed;
if(
$vbulletin->db->query_write($pc_sql)) { 


danishravian 05-14-2010 06:44 AM

Hi,
Can somebody please tell how can i add my own tables to Vbulletin database? any other solution other than accessing phpmyadmin?

i actually need to make my own pages with some add,delete and search functionality.

thanks

ragtek 05-16-2010 05:20 PM

phpmyadmin, any other mysql administration tool or run the query manual

burn0050 08-26-2010 04:49 PM

Can someone tell me how to find only forum posts? My first thought is to do a join between the forum and post table, with a where statement of where title='Main Forum'. But that seems like a waste (string comparison) - as well as what if someone changes the name of the forum? Is there some bit some where that tells me that a forum is a forum (as opposed to blogs, etc.)?

Thanks!

zero477 11-09-2012 05:57 PM

Thanks!!

Thanks!! so much .... god I wish I seen this before !!

d1jsp 09-13-2013 06:43 PM

What about deleting records? That was not in your guide.


All times are GMT. The time now is 01:17 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01250 seconds
  • Memory Usage 1,732KB
  • 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
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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