Register Members List Search Today's Posts Mark Forums Read

Thread Tools
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
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:
__________________ - security, development, exploits, vBulletin

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
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 ?

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 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
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

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 20:09.

Layout Options | Width: Wide Color: