vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   [RELEASE v2] Run a SQL query directly from your admin contorl panel (https://vborg.vbsupport.ru/showthread.php?t=26272)

pHAZE_1 04-21-2002 11:02 PM

sorry i am pretty damn tired. i read the thread but must have missed that one

erdem 04-29-2002 04:21 AM

tnx for this great hack...
but i cant run this query :

INSERT INTO template (templateid,templatesetid,title,template) VALUES (NULL,-2,'memberoftheday','0||vb||0||vb||0');

is this too complex? this is for stats panel hack..

:classic:

TECK 04-30-2002 01:46 AM

try this:
https://vborg.vbsupport.ru/showthrea...threadid=37726

let us know if it helped... also try running the query without the ";" at the end, it should work on firefly's hack.

Dean C 05-08-2002 06:13 PM

Tried running the fifth query in the store hack which is this:

INSERT INTO store VALUES (1, 'username', 'Change Username', '500', '0', 'username.gif', 'With this action you can change your username', 'Y');
INSERT INTO store VALUES (2, 'customtitle', 'Change Custom Title', '300', '0', 'title.gif', 'With this action you can get a custom title and if you dont have one already then get one', 'Y');
INSERT INTO store VALUES (3, 'customavatar', 'Change Custom Avatar', '700', '0', 'avatar.gif', 'With this action you can get a custom avatar or if you already one you can change it...', 'Y');
INSERT INTO store VALUES (4, 'givetitle', 'Give an other user a custom title', '700', '0', 'givetitle.gif', 'With this action you can give an other user a custom title. The title that you give will be showed on every post of that user. <br><b>Tip:</b> Do it when that user dont have enough money to restore his custom title ;)', 'Y');
INSERT INTO store VALUES (5, 'donate', 'Donate money to an other user', '0', '0', 'donate.gif', 'With this "free" action you can donate money to other members.', 'Y');
INSERT INTO store VALUES (6, 'scrap', 'Scrap your yellow/red card', '700', '0', 'card.gif', 'With this action you can scrap your yellow/red card. Want to become a mod but have a yellow/red card? Do this action to begin with a new veb life ;)', 'Y');
INSERT INTO store VALUES (7, 'calendar', 'Add Calendar Event', '500', '0', 'calendar.gif', 'With this action you can add a public calendar event on the calendar', 'Y');
INSERT INTO store VALUES (8, 'glowusername', 'Add Glow To Username', '2000', '0', 'glow.gif', 'With this action you can add an attractive glowing color to your username wich you can define yourself. If you have already a glow then you can change it here aswell.', 'Y');


and now every time i try to run a query i get a database error...

i don't kno what to do ...

pHAZE_1 05-10-2002 04:55 PM

i have the same problem as Mist, it worked fine until the same point, now no queries work at all.. im stumped

pHAZE_1 05-10-2002 04:56 PM

i have the same problem as Mist, it worked fine until the same point, now no queries work at all.. i installed the updated version [post # 36] and i use 2.2.5.. *stumped..

springbok 05-11-2002 10:23 AM

The problem is in the line:

Code:

INSERT INTO store VALUES (5, 'donate', 'Donate money to an other user', '0', '0', 'donate.gif', 'With this "free" action you can donate money to other members.', 'Y');
Replace it with:

Code:

INSERT INTO store VALUES (5, 'donate', 'Donate money to an other user', '0', '0', 'donate.gif', 'With this free action you can donate money to other members.', 'Y');
I don't know SQL that well, but the excl. marks around "free" are causing it to fail.

Dean C 05-12-2002 07:34 PM

yes but both myself and phaze1 have done this on our forums and now query.php won't run queries for us...

the whole things is mucked up...

springbok 05-12-2002 08:12 PM

I'm not sure then. I am also running 2.2.5 and with change was able to install the store without any problems. Wish I could help more.

:disappointed:

Dean C 05-13-2002 06:17 PM

i ran the 5th query (the long one) as one whole wheras it sed u can run it as seperate ones...

firefly i really need ure help with this...

Dean C 05-21-2002 06:10 PM

i hate bumping but i really wud like to fix this guyz...

Thanks in Advance

Dean C 05-21-2002 06:21 PM

i hate bumping but i really wud like to fix this guyz...

Thanks in Advance

Dean C 05-21-2002 06:23 PM

sorry for postin twice lol... it was goin slow so i did it again...

XFLBret 06-04-2002 07:31 AM

this doesn't work with 2.2.6???

bandersen 06-22-2002 10:06 PM

I have upgraded from 2.2.5 to 2.2.6 and lost my navbar in control panel, and have problem adding it again for this hack.

Any fix or update?

TECK 06-22-2002 11:52 PM

<a href="https://vborg.vbsupport.ru/showthread.php?postid=241576#post241576" target="_blank">https://vborg.vbsupport.ru/showt...576#post241576</a>

bandersen 06-23-2002 01:25 AM

Thanks.... I must be getting old... :)

EchoHype.com 07-25-2002 02:12 AM

Hmm, i followed your link nakkid...but instructions for 2.2.6?

TECK 07-25-2002 02:13 AM

the instructions are the same.

EchoHype.com 07-25-2002 02:22 AM

So you're saying that I upload that query.php file you linked me to, the text I need will be found in the index.php file?

Admin 08-01-2002 06:12 PM

Being a disgrace to coding and human race in general, I am closing this one. Use JamesUS's version of the idea, it's [insert large number here] times better.

shovel 08-01-2002 06:33 PM

&nbsp;&nbsp;&nbsp;&nbsp;Would you mind if I revamped the coding and released my own version?

Admin 08-01-2002 07:03 PM

Yes feel free.

shovel 08-01-2002 07:19 PM

&nbsp;&nbsp;&nbsp;&nbsp;Awesome. Thanks Chen.


All times are GMT. The time now is 01:16 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01214 seconds
  • Memory Usage 1,756KB
  • 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_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete