Apolyton Archive  |  Preserved copy of the Apolyton Civilization Site and its forums as they stood in September 2005. Read-only; nothing here can be posted to or replied to.  |  Forum index |  About this archive |  The 1998–2001 UBB forums
Today on Apolyton WARDELL INTERVIEW PROMO A.C.S. HISTORY CHAPTER 4 GET CIV4 /w FREE PLUS! A.C.S. PHOTO GALLERY GET A.O.M. V1.1
Apolyton Civilization Forums
main| civ2| civ3| civ4| smac| ctp2| ron| moo3| galciv| galciv2| alt| about|
ApolytonPLUS | register | search | faq | new posts | pm (-/-) | upload | members
hall of fame new! | civgroups | civgroups news | interviews | the column | radio | chat | directory | news | store | PLUS
Apolyton Civilization Forums : Powered by vBulletin version 2.0.3 Apolyton Civilization Forums > Miscellaneous > Archive > Apolyton/Community-Archive > Markos: Duplicate names in registration list
Show a Printable Version | Email This Page to Someone! | Receive updates to this thread | Report this to Apolyton news!

bottom of page
  
Author
Thread    < Last Thread     Next Thread > Post New Thread     Post A Reply
Skanky Burns is offline Skanky Burns
Deity
Skanky Bastard Quartermaster
Aug 2001
time: 14:20
Lightbulb  Old Post 25-06-2002 17:43
Edit/Delete Message Reply w/Quote
#1 Report this post to a moderator
Markos: Duplicate names in registration list Help yourself to an AD-FREE life

There have been a number of threads on this topic, but this bug still remains.

I'm assuming the code does SQL queries to get the list of people who have registered 'today'. Why not add the key-word distinct so it only grabs 1 of each registered person.

code:
sql = "SELECT DISTINCT * FROM ..."


Not being able to see the code, I'm not sure what you have done, but this seems to be an easy solution to the (admittedly small) but annoying problem.

Hueij is offline Hueij
Emperor
Kokonino Kounty
May 1999
time: 06:20
  Old Post 26-06-2002 04:20
Edit/Delete Message Reply w/Quote
#2 Report this post to a moderator
Remove this text

You mean something like this? BTW, I noticed that Provost H had two birthdays yesterday

Attachment: pic.gif
This has been downloaded 71 time(s).

Hydey is offline Hydey
Emperor
up shyte creek without a paddle
Mar 2000
time: 14:20
  Old Post 26-06-2002 16:06
Edit/Delete Message Reply w/Quote
#3 Report this post to a moderator
Browse Apolyton AD-FREE

yes thats what he means

Skanky Burns is offline Skanky Burns
Deity
Skanky Bastard Quartermaster
Aug 2001
time: 14:20
  Old Post 26-06-2002 19:49
Edit/Delete Message Reply w/Quote
#4 Report this post to a moderator
Lose 30 kilos (of popups)

Indeed. Although the two Provost H's were different. One was his temporary DL when he was first banned, the other is his actual login. One had a space in it too (which I didn't notice until I clicked on them)

Skanky Burns is offline Skanky Burns
Deity
Skanky Bastard Quartermaster
Aug 2001
time: 14:20
  Old Post 27-06-2002 07:19
Edit/Delete Message Reply w/Quote
#5 Report this post to a moderator
Tired of ads?

*Ahem*

War4ever is offline War4ever
Emperor
I live amongst the Red Sox Nation
Jan 1970
time: 21:20
  Old Post 30-06-2002 02:21
Edit/Delete Message Reply w/Quote
#6 Report this post to a moderator
Got spare money?

dl dld dl dl ....there everywere

alva is offline alva
Emperor
Republic of Flanders
Sep 2001
time: 06:20
  Old Post 03-07-2002 12:05
Edit/Delete Message Reply w/Quote
#7 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations

Today's Registrations: 8
G.S. boy, G.S. boy, G.S. boy, merc9, merc9, merc9, seau1, Dereth

War4ever is offline War4ever
Emperor
I live amongst the Red Sox Nation
Jan 1970
time: 21:20
  Old Post 03-07-2002 22:34
Edit/Delete Message Reply w/Quote
#8 Report this post to a moderator
Support Apolyton, pre-order Civilization IV

must be an error in the database

Straybow is offline Straybow
Emperor
SG(2)… gone but not forgotten
Jan 1970
time: 23:20
  Old Post 09-07-2002 03:51 Visit Straybow's homepage!
Edit/Delete Message Reply w/Quote
#9 Report this post to a moderator
Support Apolyton, buy Call to Power 2

Some really are dls, people hit the button more than once, or change the default password and come back in a couple hours and can't remember it… been going on for ages. Look up Sir David and see how many times he registered

Hope he isn't around to defend himself.

Skanky Burns is offline Skanky Burns
Deity
Skanky Bastard Quartermaster
Aug 2001
time: 14:20
  Old Post 09-07-2002 06:49
Edit/Delete Message Reply w/Quote
#10 Report this post to a moderator
Support Apolyton

Yep, you are right. They all have unique id numbers.

  < Last Thread     Next Thread > Post New Thread     Post A Reply
All times are GMT. The time now is 05:20.
Apolyton Time is 00:20.
    top of page
Rate This Thread:
archivepost
Forum Jump:
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
 




Contact Us - Apolyton Civilization Site - Support Us!

Building a better Apolyton through better information. Click here and take our poll!
Non-US visitors, click here!

Powered by: vBulletin Version 2.0.3
Copyright ©2000, 2001, Jelsoft Enterprises Limited.

Page generated in 0.0363 seconds (85.73% PHP - 14.27% MySQL) with 31 queries
Page Loading Time:

Support Apolyton: Amazon USA | Amazon UK | Amazon DE | Amazon FR |
Support Apolyton and get FREE PLUS, Buy from Chips&Bits: Galactic Civilizations | Galactic Civilizations: Deluxe Edition | Call to Power 2 | Civilization: The Boardgame | GURPS/ Alpha Centauri | Alpha Centauri | Civilization IV | Civilization III: Complete |


Front Page | Civilization IV | Civilization III | Civilization II | Call to Power II | Alpha Centauri | Master of Orion III
Rise of Nations | Galactic Civilizations | Galactic Civilizations II | Misc
Alt.Civs | Civ I | C:CtP I | About | News | Directory | Apolyton Store | Forums | Chat | Columns | Interviews | Newsletter
Scenario League | CSC | Clash of Civs | Spanish Site | CtP Maps | Cradle of Civ | WesW's Ctp1/2 Site | Civ3 Haven

apolyton.net | apolyton.com | civilization2.net | civilization3.net | civilization4.net | civilizationiv.info | calltopower.net | galciv.net | galciv2.net | moo3.net