Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 26 Apr 2017, 04:08
X-or X-or is offline
 
Join Date: Nov 2005
I want to learn vb coding

...

Last edited by X-or; 31 May 2017 at 16:17.
Reply With Quote
  #2  
Old 26 Apr 2017, 14:05
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
In order to register variables to the vBulletin GPC array, you use:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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/
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 26 Apr 2017, 17:40
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by X-or View Post

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.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #4  
Old 27 May 2017, 16:14
grey_goose grey_goose is offline
 
Join Date: Jun 2009
Originally Posted by X-or View Post
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.

Originally Posted by X-or View Post
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.
Reply With Quote
Reply



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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:30.

Layout Options | Width: Wide Color: