vBulletin Modifications

going for the noobquestion of the year award:

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > General vBulletin Section > General vBulletin Support

Reply
 
LinkBack Thread Tools
Old 10-06-2006, 08:52 PM   #1
vB Newbie
Join Date: Oct 2006
Bulletje is on a distinguished road

Default going for the noobquestion of the year award:

How and where can i run queries? what are they?

for instance:

ALTER TABLE `user` ADD `ipmask` VARCHAR(255) NOT NULL;
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES(0, 'ipmasks', 'IP Mask (xx.xx.* | xx.* etc)', 1);




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 10-06-2006, 08:59 PM   #2
Coder
Idan's Avatar
Join Date: Feb 2005
Real Name: Idan
Location: Israel
Idan is on a distinguished road

Default

you can run queries from within admincp (assuming config file grant your user with permissiosn for it).
location: under admincp -> Maintenance -> Execute SQL Query
Note that via there you can only execute 1 row at a time.

other, preffered way (if u ask me), is via phpMyAdmin.
just go into some table view, and you'll notice "SQL" tab on top.
you write your query there.

as for the question - "what are they?", quick answer:
those are ways of fetching information from mysql database.
those queries can be either fetch direct info (SELECT), change info (UPDATE), change table structure (ALTER) & more.
check google on mysql syntax, and i also think i've pasted here (no so long ago) some tut with resources on issue (or it was reqply to someone question - don't recall exactly).

hope this helps.
enjoy.
__________________
Idan / vBHackers.com
vBSEO 3.1 GOLD Released vB Blogs Compatible | Non-Encrypted | Branding Removal Option | Sitemaps 2.1 | Language Packs

Crawlability Network: vBulletin SEO | vBulletin Hackers

Last edited by Idan; 10-06-2006 at 09:06 PM.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Happy New year to all!! Hyper Off Topic 2 01-02-2005 05:26 AM


All times are GMT -3. The time now is 09:27 PM.


SEO by vBSEO 3.2.0 RC8 ©2008, Crawlability, Inc. (Patent Pending)