Kosta, on May 13 2005, 09:28 PM, said:
However, linking abandonia and AR databases would be quite difficult to say the least. AR database is much more advanced to enable all the producer and company linking features. That's why it would be very hard to implement a unique search that would work for both sites
![;)](http://www.reloaded.org/forum/public/style_emoticons/default/wink.png)
Aureliano, I think posting an updated list somewhere is a lot of work, because you do need to make these posts regularly. So I hope you won't
I don't know what kind of databases Abandonia & Reloaded are using, but I guess some MySQL-server with php-scripts for getting the data. If that's right, I think it doesn't matter how advanced the database is, because you can just forget all the advanced data. The only thing you need to know is the name of the game and the site its in. So you need a user wich has access to both databases and two select-statements: something like:
(connect to the Abandonia base)
"@abandoniatitles=SELECT fulltitle FROM games WHERE fulltitle LIKE 'A%' GROUP BY fulltitle ASC"
Print something like 'These games from abandonia starting with an A:' @abandoniatitles
(connect to the Reloaded base)
"@reloadedtitles=SELECT fulltitle FROM games WHERE fulltitle LIKE 'A%' GROUP BY fulltitle ASC"
Print something like 'These games from reloaded starting with an A:' @reloadtitles
That would be the easy-est way. Something a little bit more advanced could be a script wich selects the same, inserts it into some 3th database and fills an extra field with 'Abandonia' or 'Reloaded'. In that case you would have the opportunity to fill that base with more info from other sites like Abandonia (if there are
![:P](http://www.reloaded.org/forum/public/style_emoticons/default/tongue.png)
)
Maybe I'm just thinking its to easy
![:)](http://www.reloaded.org/forum/public/style_emoticons/default/smiling.gif)
, but I'm used to grabbing info from databases and putting it down on websites for my job.
So, now I'm just going to sit back and watch wich games have been placed since my last visit