Toplist Script

[immortalempire]

any 1 got a toplist script similar to surfwap as im thinking of updating my toplist hotsitez.co.uk with something more better

[amylee]

i only have the original toplist that was on ravingwap somewhere among my many backup cd's

[immortalempire]

amylee isthe surfwap 1 part of prodigits , an are you willing to put it up on here

[Guest]

man i had it once- now my hdd got feckedup a while ago- i only have to pld version- im sure some1 has the xhtml u need- they just dont wana give it out- i dont blame them- more than likely they got it the same way too.

[immortalempire]

soz boggie wots pld m8 an is that 1 u got any good m8

[immortalempire]

cos wanna make hotsitez into summat like surfwap with voting and anti cheating hits and also any site that reg's to it appear on google

[amylee]

amylee isthe surfwap 1 part of prodigits , an are you willing to put it up on here[/b]

ive no idea im not into toplists tbh and yeah here it is but no sql tho but will try and find it

:edit:

heres the sql

CREATE TABLE `cats` ( 
  `id` int(10) NOT NULL auto_increment, 
  `name` varchar(30) NOT NULL default '', 
  `dscr` varchar(100) NOT NULL default '', 
  PRIMARY KEY  (`id`), 
  UNIQUE KEY `name` (`name`) 
); 

-- 
-- Dumping data for table `cats` 
-- 


-- -------------------------------------------------------- 

-- 
-- Table structure for table `misc` 
-- 

CREATE TABLE `misc` ( 
  `id` int(10) NOT NULL auto_increment, 
  `dscr` varchar(200) NOT NULL default '', 
  `text` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`id`) 
); 

-- 
-- Dumping data for table `misc` 
-- 

INSERT INTO `misc` VALUES (1, 'CLR', '2006-04-01'); 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `sites` 
-- 

CREATE TABLE `sites` ( 
  `id` int(10) NOT NULL auto_increment, 
  `sitename` varchar(30) NOT NULL default '', 
  `cid` int(10) NOT NULL default '0', 
  `sitelink` varchar(200) NOT NULL default '', 
  `slogo` varchar(200) NOT NULL default '', 
  `uid` int(10) NOT NULL default '0', 
  `hin` int(10) NOT NULL default '0', 
  `hout` int(10) NOT NULL default '0', 
  `dhits` int(10) NOT NULL default '0', 
  `thits` int(12) NOT NULL default '0', 
  `banned` int(5) NOT NULL default '0', 
  `dscr` varchar(200) NOT NULL default '', 
  PRIMARY KEY  (`id`), 
  UNIQUE KEY `sitelink` (`sitelink`) 
); 

-- 
-- Dumping data for table `sites` 
-- 


-- -------------------------------------------------------- 

-- 
-- Table structure for table `tusers` 
-- 

CREATE TABLE `tusers` ( 
  `id` int(10) NOT NULL auto_increment, 
  `name` varchar(30) NOT NULL default '', 
  `pass` varchar(60) NOT NULL default '', 
  `admin` int(5) NOT NULL default '0', 
  `banned` int(5) NOT NULL default '0', 
  PRIMARY KEY  (`id`), 
  UNIQUE KEY `name` (`name`)
);

and run this query after

UPDATE tusers SET admin='1' WHERE name='[b]username goes here[/b]';

[immortalempire]

ok ta amylee i look at that tmoz after i finished avn beer cheers

[amylee]

no worries

[flaremobile]

hi amy how do i add catetgories here ??? tx

[amylee]

cant remember havnt used this script for over a year

[flaremobile]

Lol alryt tx anyway does anybody else no how to add categories its the ravingwap toplist script .

[modfiles]

This is havent answered it.. its my problem too. anyone know how?

[phoenix90]

Im having abit of a problem, the addsite.php file let's my server show ERROR 505..
Anybody know whats wrong?

[chatabox]

try inserting some names into the sql?? LOL, the sql i have with my copy has all ya old categories in anyway...... can't remember where i got it will take a look later... just do it in phpmyadmin if ya not comfortable writing querys.