vb.org Archive - SQL problems

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - SQL problems (https://vborg.vbsupport.ru/showthread.php?t=148578)

The)TideHunter(

05-31-2007 12:13 PM

SQL problems

Hey, i've never really used sql before, i've tried but to no avail.
What im asking for is a query that will add a new section to the table (preferablly called "coins") and 2 functions which are Get and Set for the coins.

So for example, every member has a coins section (just like posts) and 2 functions like:

function Get takes userid returns coinsamount

function Set takes userid, coinsamount.

I'm really having trouble doing this, any help appreiciated.

Eikinskjaldi

05-31-2007 10:21 PM

Quote:

Originally Posted by The)TideHunter( (Post 1258305)

You need to add the coins field to the table

[sql]alter table tablename add column coins int(11);[/sql]

getter
[sql]select coins from tablename where userid=something[/sql]

setter
[sql]update tablename set coins=something where userid=somethingelse[/sql]

The)TideHunter(

06-02-2007 07:18 AM

Thanks so much, exactly what i needed.

EDIT: I'm having problems, i tried this code:

PHP Code:


		
			
<?php



    require_once('./global.php');

    require_once(DIR . '/includes/functions_bigthree.php');

    require_once(DIR . '/includes/functions_forumlist.php');

    // sql coins test

    $db->query_read_slave("update user set coins=5 where userid=1");

    

    $coins = $db->query_read_slave("select coins from user where userid=1");

    

    echo $coins;

?>

And i added the column coins successfully to table users.
Whenever i try the page it returns "Resource id #16".

Eikinskjaldi

06-03-2007 10:56 PM

query_read_slave sets the database object with a cursor, it does not return the actual values.

also when not doing a select you should use query_write. (I think...dont quote me on this one)

PHP Code:


		
			
    // sql coins test

    $db->query_write("update user set coins=5 where userid=1");

    

    $coins_query = $db->query_read_slave("select coins from user where userid=1");

    

    while ($coins = $db->fetch_array($coins_query))

            echo $coins['coins'];

Dismounted

06-04-2007 12:08 PM

Quote:

Originally Posted by Eikinskjaldi (Post 1260648)

also when not doing a select you should use query_write. (I think...dont quote me on this one)

Partly correct, use query_write when WRITING to the database and query_read when READING. Pretty logical actually.

The)TideHunter(

06-04-2007 03:55 PM

Thanks alot guys, its working now.

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01218 seconds Memory Usage 1,730KB 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 (2)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages: