vb.org Archive
Page 7 of 57 « First 56 7 8917 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Yet Another Awards System 3.5 v2.1.2 (https://vborg.vbsupport.ru/showthread.php?t=94836)

y2krazy 09-03-2005 09:51 PM
Ok. That fixed that problem, now I'm getting this weird error(see attachment). I haven't modded any of the templates for the Awards yet, so I'm not sure as to why this is happening.

Roxie 09-03-2005 10:48 PM
Excellent! The editing works...Your work is really appreciated.

Roxie 09-04-2005 08:42 PM
I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Code:
Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'1','Ro Award Request Form','Ro','1','1125870038','Award Request Form - Ro

------------------
Sender Information

UserID: 1
Username: Ro
Fullname: test

-----------------------------
Request Information:
Award ID: 29
Award Name: Cancer Zodiac
Award Description:
https://vborg.vbsupport.ru/

Recipient username : test

-----------------------------------------------------
Please explain why the listed recipient should receive the award.

testing form
-----------------------------------------------------','1','1','0','0','1');

MySQL Error  : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146
Date        : Sunday, September 4th 2005 @ 05:40:38 PM
Script      : http://daboard.dizzam.com/request_award.php
Referrer    : http://daboard.dizzam.com/request_award.php?award_id=29
IP Address  : xx.xx.xxx.xx
Username    : Ro
Classname    : vb_database
*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks! :)

y2krazy 09-04-2005 11:18 PM
Regarding this post:

https://vborg.vbsupport.ru/showpost....7&postcount=61

I simply changed the following in the "awards_category" template:

PHP Code:
    <td class="tcat" colspan="$totalcols"> 
To this:

PHP Code:
    <td class="tcat" colspan="4"> 
Not sure what the previous code was used for, so this is just a temp-fix for the problem. Let me know when you get around to it... ;)

DeMiNe0 09-05-2005 03:12 AM
Quote:
Originally Posted by Roxie
I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Code:
Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'1','Ro Award Request Form','Ro','1','1125870038','Award Request Form - Ro

------------------
Sender Information

UserID: 1
Username: Ro
Fullname: test

-----------------------------
Request Information:
Award ID: 29
Award Name: Cancer Zodiac
Award Description:
http://daboard.dizzam.com/awards/cancer.gif

Recipient username : test

-----------------------------------------------------
Please explain why the listed recipient should receive the award.

testing form
-----------------------------------------------------','1','1','0','0','1');

MySQL Error  : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146
Date        : Sunday, September 4th 2005 @ 05:40:38 PM
Script      : http://daboard.dizzam.com/request_award.php
Referrer    : http://daboard.dizzam.com/request_award.php?award_id=29
IP Address  : xx.xx.xxx.xx
Username    : Ro
Classname    : vb_database
*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks! :)
i'm getting this same error.

mtha 09-05-2005 08:18 AM
Quote:
Originally Posted by Roxie
I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Code:
Database error in vBulletin 3.5.0 Release Candidate 2:

MySQL Error  : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146
*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks! :)
I could have uploaded the old file. replace request_award.php with the attached file

mtha 09-05-2005 08:29 AM
Quote:
Originally Posted by y2krazy
Regarding this post:

https://vborg.vbsupport.ru/showpost....7&postcount=61

I simply changed the following in the "awards_category" template:

PHP Code:
    <td class="tcat" colspan="$totalcols"> 
To this:

PHP Code:
    <td class="tcat" colspan="4"> 
Not sure what the previous code was used for, so this is just a temp-fix for the problem. Let me know when you get around to it... ;)
try the attached file with the old template (using $totalcols) and see how it turn out.

the totalcols will calculate the number of columns you have, depends on the options you have for award settings.

Biker_GA 09-05-2005 01:06 PM
Something that would make this a top notch modification. I've added the link for the nomination form to postbit_legacy. What I currently have users do is copy the URL of the post they'd like to nominate. To make this even better, I'd like to see the URL automatically added to the reason section when a user clicks the link in the postbit. :)

y2krazy 09-05-2005 01:27 PM
The new files are working properly. Thanks, mtha! :)

Also, I have edited the Award Request template quite a bit and thought I'd share it with everyone who wants it:

Code:
$stylevar[htmldoctype]
<html id="form" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $formtitle</title>
$headinclude
</head>
<body>
$header
$navbar

<form enctype="multipart/form-data" method="post" action="$phpfilename">
<input type="hidden" value="$userid" name="userid">
<input type="hidden" value="submit" name="action">
<input type="hidden" value="$award[award_id]" name="award_id">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
        <td class="tcat" colspan="3">
                Request for $award[award_name] (id: $award[award_id])
        </td>
</tr>
<tr>
        <td class="panelsurround" align="center">
        <div class="panel">
                <div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
                        <fieldset class="fieldset" style="margin:0px">
                                <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
                                <tr>
                                        <td>$formpurpose</td>
                                </tr>
                                </table>
                        </fieldset>

                        <br><div align="center"><img src="$award[award_img_url]"></div><br>

                        <fieldset class="fieldset">
                                <legend>Description</legend>
                                <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
                                <tr>
                                        <td>$award[award_desc]</td>
                                </tr>
                                </table>
                        </fieldset>

                </div>
        </div>
        </td>
</tr>
</table>

<br>

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
        <td class="tcat" colspan="3">
                $formtitle
        </td>
</tr>
<tr>
        <td class="panelsurround" align="center">
        <div class="panel">
                <div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
               
                        <fieldset class="fieldset">
                                <legend>Username</legend>
                                <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
                                <tr>
                                        <td><b>$bbuserinfo[username]</b></td>
                                </tr>
                                </table>
                        </fieldset>
               
                        <fieldset class="fieldset">
                                <legend>$question1</legend>
                                <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
                                <tr>
                                        <td></td>
                                </tr>
                                <tr>
                                        <td><input type="text" class="bginput" size="30" name="answer1"></td>
                                </tr>
                                </table>
                        </fieldset>

                        <fieldset class="fieldset">
                                <legend>$question2</legend>
                                <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
                                <tr>
                                        <td><input type="text" class="bginput" size="30" name="answer2"></td>
                                </tr>
                                </table>
                        </fieldset>
               
                        <fieldset class="fieldset">
                                <legend>$longquestion1</legend>
                                <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
                                <tr>
                                        <td>$longexplain1</td>
                                </tr>
                                <tr>
                                        <td><textarea rows="5" cols="50" name="longanswer1"></textarea></td>
                                </tr>
                                </table>
                        </fieldset>

                </div>
        </div>
        </td>
</tr>
<tr>
        <td class="panelsurround" align="center">
        <div style="margin-top:$stylevar[cellpadding]px">
                <input type="submit" name="submit" class="button" value="Submit Request" accesskey="s" />
                <input type="reset" name="reset" class="button" value="$vbphrase[reset_fields]" accesskey="r" />
        </div>
        </td>
</tr>

</table>
</td>
</tr>
</table>

</form>

$footer
</body>
</html>
NOTE: The attachment is in my unique style, but it was edited based on the UserCP templates, so it should look like that in any template. Let me know if this is any use to anyone. :)

EDIT: Where would I go to change the title of the thread, e-mail or PM that is created when a request is submitted?

EDIT 2: Nevemind the first EDIT as I figured out where in the file to change some things to make the title of the thread different.

Roxie 09-05-2005 05:13 PM
Quote:
Originally Posted by mtha
I could have uploaded the old file. replace request_award.php with the attached file
Great! Database error is gone, but now it submits the form and refreshes to the form again. No thank you page. hmmm


All times are GMT. The time now is 11:13 AM.
Page 7 of 57 « First 56 7 8917 Last »
Show 40 post(s) from this thread on one page

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.01703 seconds
  • Memory Usage 1,808KB
  • 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
  • (4)bbcode_code_printable
  • (4)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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