vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   I want to learn vb coding (https://vborg.vbsupport.ru/showthread.php?t=324979)

X-or 04-26-2017 02:08 AM

I want to learn vb coding
 
...

Dave 04-26-2017 12:05 PM

In order to register variables to the vBulletin GPC array, you use:
PHP Code:

$vbulletin->input->clean_array_gpc('p', array(
   
'variable1' => TYPE_NOHTML,
   
'number1' => TYPE_UINT
)); 

The first parameter should usually be p (POST) or g (GET). Keep in mind that pulling variables through this "cleaning" function does not guarantee that the variables are safe to be used in SQL queries (SQL injection) or printing on the screen (XSS). Unless you're sure it's an integer or of a value that can not be malicious, use $vbulletin->db->escape_string($vbulletin->GPC['variable1']) when it's used in SQL queries.

You can retrieve the variable in your PHP script using $vbulletin->GPC['variable1'];

The variable1 and number1 come from the name attributes you give your input elements in the template. They should match or else it will be empty.

--

$db is just short for $vbulletin->db. However, if you're hooking into a class of vBulletin you might have to use $this->registry->db in order to interact with the database.

query_write should be used for queries that may affect something in the table, such as UPDATE or DELETE queries.
query_first can be used to directly return an array of the first result. This is useful if you want to write less code.
query_read can be used to read from table.

--

Here's a link to the API which might be useful: https://members.vbulletin.com/api/

Paul M 04-26-2017 03:40 PM

Quote:

Originally Posted by X-or (Post 2585848)

another question, what's the difference between the following ?
$vbulletin->db->query("UPDATE....
$db->query_write("UPDATE....

thanks

query_write is always sent to the master server.
query will be directed to the slave if you have one, which is bad for writes.

grey_goose 05-27-2017 02:14 PM

Quote:

Originally Posted by X-or (Post 2585848)
I have posted a job with a 500usd bounty and nobody cares about it

They'd probably care more if your conditions weren't so harsh. At the very least, you should be responsible for setting up the test environment rather than expecting someone to faithfully replicate your production environment on spec.

Quote:

Originally Posted by X-or (Post 2585848)
if you want to do something do it yourself :|

That said? Go for it. I was in the same boat and slowly have been getting the hang of things. My 'pie in the sky' project was adding a character database to my RPG forum and something I once thought would be impossible to do myself. Now, it's done. Better than I originally envisioned and opening up new possibilities.

Read, read, read. Even discussions that have nothing to do with you. Bookmark this.


All times are GMT. The time now is 06:45 AM.

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.01258 seconds
  • Memory Usage 1,724KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete