I want to learn vb coding

[X-or]

...

[Dave]

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]

Originally Posted by X-or

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]

Originally Posted by X-or

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

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.