vb.org Archive - Country Flag Hack v2.0

Page 17 of 27

« First

Last »

Show 40 post(s) from this thread on one page

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Country Flag Hack v2.0 (https://vborg.vbsupport.ru/showthread.php?t=27485)

scsa20

05-02-2002 05:49 PM

I keep getting this:

Quote:

Database error in vBulletin 2.2.5:

Invalid SQL: SELECT country FROM user WHERE userid=1
mysql error: Unknown column 'country' in 'field list'

mysql error number: 1054

Date: Thursday 02nd of May 2002 02:36:08 PM
Script: http://forums.simon-soft.com/member....on=editprofile
Referer: http://forums.simon-soft.com/usercp.php?

how do I fix this??

wot-Mike

05-02-2002 06:45 PM

Looks like you didn't run a querie. The user table needs to be altered, the country field needs to be added.

Look inside the install.txt for that info :)
It's step 1 I believe...

scsa20

05-02-2002 07:18 PM

doh, stupid me, all I look for is the code to put in, plus the beging part of the install.txt file is nothing but info about it...maybe I should open up my eyes more :rolleyes:

Sketch

05-02-2002 10:31 PM

okay, all is hitchless for me except one thing. In the memberlist, the flag is not displayed. Everywhere else it is displayed okay.

Here is a link to where it is not showing---http://www.livetheworship.com/vb/memberlist.php?s=

Here is a link to where it is showing---
http://www.livetheworship.com/vb/sho...s=&threadid=89

Here is my memberlistbit (fragment):

Code:

<tr align="center">

        <td bgcolor="{firstaltcolor}">$flag</td>

        <td bgcolor="{secondaltcolor}" align="left">

<span style="font-size: 11px;">

<a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$userinfo[userid]">$userinfo[username]</a>

</td>

Any ideas why it won't show up here?

Sketch

scsa20

05-03-2002 02:34 AM

did you add $flag ??

DWZ	05-03-2002 09:39 AM

Can someone tell me how I can make it so a users must select a flag when they sign up?

ie. You get a message saying "You must select a country to register" if they keep the box blank.

Thanks :)

DWZ	05-07-2002 01:19 AM

Quote:

Originally posted by DWZ
Can someone tell me how I can make it so a users must select a flag when they sign up?

ie. You get a message saying "You must select a country to register" if they keep the box blank.

Thanks :)

http://members.optushome.com.au/mega...orums/BUMP.gif

DWZ	05-12-2002 11:26 PM

awww... come on, please, anyone?

DWZ	05-18-2002 11:52 AM

Quote:

Originally posted by DWZ
awww... come on, please, anyone?

it isn't that hard... is it?

webhost

05-18-2002 04:24 PM

In register.php find this

PHP Code:


		
			




if ($action=="register") {



  if (!$allowregistration) {



    eval("standarderror(\"".gettemplate("error_noregister")."\");");



    exit;



  }







  if ($bbuserinfo[userid]!=0 and !$allowmultiregs) {



    $getuser=$DB_site->query_first("SELECT username FROM user WHERE userid='$bbuserinfo[userid]'");



    $username=$getuser[username];







    eval("standarderror(\"".gettemplate("error_alreadyregistered")."\");");







    exit;



  }

After it put this

PHP Code:


		
			


" if($country==""){

    eval("standarderror('Please select your country.');");

    exit;

 }"

All times are GMT. The time now is 04:59 AM.

Page 17 of 27

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01510 seconds Memory Usage 1,751KB 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 (1)bbcode_code_printable (2)bbcode_php_printable (3)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
Messages: