XMB Forum Software
Not logged in [Login - Register]
Go To Bottom

Printable Version  
Author: Subject: [New] inserting Raw SQL
Passthru
Experienced
***




Posts: 19
Registered: 12-25-2005
Member Is Offline

Mood: No Mood

posted on 3-10-2012 at 07:31 AM Edit Post Reply With Quote
[New] inserting Raw SQL


Full Board URL: www.finfeatherandfur.net/forums/
XMB Version: 1.9.11

hmmm, been trying to do a couple mods. u2u welcome and moderation system. Both requires inserting raw SQL, when i click the submit button i get a 403 forbidden page.
Should i be able to go to phpmyadmin and run the sql from there? i may be wrong but i tried anyhow, it fails and it tells me tables do not exist, course i dont know if i should be doing that in there or not.
or is this a host issue? need advice, keep in mind im not to savy with server stuff. thankfully im starting a new site, and i am in no hurry at all, not even going to promote it for some time.
View user's profile Visit user's homepage View All Posts By User
lottos
Administrator
********




Posts: 483
Registered: 6-3-2002
Member Is Offline

Mood: pass me a TimTam

posted on 3-10-2012 at 10:34 AM Edit Post Reply With Quote



Inserting sql through the admin area of xmb usually entails table names starting with $table_tablename, eg:
$table_u2u

whereas in phpadmin you need to look at the table names under the database name and use that naming convention, eg:
xmb_u2u.

If the mod started with something like
ALTER table $table_u2u

then via phpadmin you would change it to
ALTER table xmb_u2u
View user's profile View All Posts By User
Passthru
Experienced
***




Posts: 19
Registered: 12-25-2005
Member Is Offline

Mood: No Mood

posted on 3-11-2012 at 02:35 AM Edit Post Reply With Quote



So, this:

CREATE TABLE $table_new_attachments LIKE $table_attachments;



Should look like this?

CREATE TABLE xmb_new_attachments LIKE xmb_attachments;

View user's profile Visit user's homepage View All Posts By User
Passthru
Experienced
***




Posts: 19
Registered: 12-25-2005
Member Is Offline

Mood: No Mood

posted on 3-11-2012 at 02:42 AM Edit Post Reply With Quote



ahhh yes, i think i got it Obi-wan kenobi.:)
View user's profile Visit user's homepage View All Posts By User

  Go To Top

Powered by XMB 1.10.00-alpha (Debug Mode)
XMB Forum Software © 2001-2025 The XMB Group
[Queries: 14] [PHP: 65.2% - SQL: 34.8%]