how to make players began with vip ....

M.KinG · 09/17/2010, 10:44

how can i make players began with vip 3 and 100 k pp and level 50

King_Arthur · 09/17/2010, 10:52

Quote:

Originally Posted by M.KinG

how can i make players began with vip 3

Edit your account table design to set the default value for 'vip' to three.

Quote:

Originally Posted by M.KinG

and 100 k pp and level 50

First way I can think of would be to create a noobie gift that awards 100k pp and levels up any player between 1-49 to level 50. You of course would want to make this newbie gift untradeable/undropable.

San-Goku · 09/17/2010, 11:00

king arthur..can u show..this is mine:

Code:

`id` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `password` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `type` int(4) unsigned NOT NULL DEFAULT '0',
  `point` int(4) DEFAULT '0',
  `pointtime` int(4) unsigned zerofill NOT NULL DEFAULT '20020318',
  `online` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
  `reg_date` datetime DEFAULT NULL,
  `licence` int(4) unsigned DEFAULT '0',
  `reg_flag` bigint(12) unsigned DEFAULT '3',
  `netbar_ip` varchar(15) DEFAULT '127.0.0.1',
  `ip_mask` varchar(15) DEFAULT '255.255.255.255',
  `add_type` smallint(1) unsigned zerofill NOT NULL DEFAULT '0',
  `VIP` int(4) unsigned NOT NULL DEFAULT '4',
  `offline` int(4) DEFAULT NULL,
  `pwd` varchar(32) DEFAULT NULL,
  `idnum` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_name_pass` (`name`,`password`),
  UNIQUE KEY `index_username` (`name`),
  KEY `index_type` (`type`),
  KEY `index_regtype` (`reg_flag`),
  KEY `index_isp` (`type`,`netbar_ip`),
  KEY `typereg` (`type`,`reg_date`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

King_Arthur · 09/17/2010, 11:02

Quote:

Originally Posted by San-Goku

king arthur..can u show..this is mine:

Code:

`id` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `password` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `type` int(4) unsigned NOT NULL DEFAULT '0',
  `point` int(4) DEFAULT '0',
  `pointtime` int(4) unsigned zerofill NOT NULL DEFAULT '20020318',
  `online` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
  `reg_date` datetime DEFAULT NULL,
  `licence` int(4) unsigned DEFAULT '0',
  `reg_flag` bigint(12) unsigned DEFAULT '3',
  `netbar_ip` varchar(15) DEFAULT '127.0.0.1',
  `ip_mask` varchar(15) DEFAULT '255.255.255.255',
  `add_type` smallint(1) unsigned zerofill NOT NULL DEFAULT '0',
  `[COLOR="Red"][B]VIP[/B][/COLOR]` int(4) unsigned NOT NULL DEFAULT '[COLOR="Red"][B]4[/B][/COLOR]',
  `offline` int(4) DEFAULT NULL,
  `pwd` varchar(32) DEFAULT NULL,
  `idnum` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_name_pass` (`name`,`password`),
  UNIQUE KEY `index_username` (`name`),
  KEY `index_type` (`type`),
  KEY `index_regtype` (`reg_flag`),
  KEY `index_isp` (`type`,`netbar_ip`),
  KEY `typereg` (`type`,`reg_date`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

#Highlighted.

San-Goku · 09/17/2010, 11:05

owh..so its mean new player start with vip 4??how about 100k pp??

redburn89 · 09/17/2010, 11:59

cq_user find collum emoney2...
follow step like king arthur show..
design table cq_user

DeadHackerz · 09/17/2010, 14:17

could u show it king arthur or any sql for do thats?thats would be easy for MrKing i think

King_Arthur · 09/17/2010, 15:14

Quote:

Originally Posted by DeadHackerz

could u show it king arthur or any sql for do thats?thats would be easy for MrKing i think

Yep.

Code:

ALTER TABLE account ALTER VIP SET DEFAULT 3;

DeadHackerz · 09/17/2010, 15:52

just copy and paste at navicat like that?

King_Arthur · 09/17/2010, 16:14

Quote:

Originally Posted by DeadHackerz

just copy and paste at navicat like that?

Yes. Just make sure that you are in the right database when you run it (account/my/my2). Also note that this will only affect new accounts. You must run an update query if you want to change past accounts.

DeadHackerz · 09/17/2010, 18:08

Quote:

Originally Posted by King_Arthur

Yes. Just make sure that you are in the right database when you run it (account/my/my2). Also note that this will only affect new accounts. You must run an update query if you want to change past accounts.

run it account/my/my2?didnt understand

King_Arthur · 09/17/2010, 18:13

Quote:

Originally Posted by DeadHackerz

run it account/my/my2?didnt understand

I said that to make sure that people run the query in the database where their account information is stored. If you have a separate account db, then run it there. If you don't have a separate account db, then run it in either the my db or the my2 db, whichever one you have.

~~~Sword~Stalker~[PM]~~ · 09/18/2010, 10:58

for adding 100k PP follow these pic.s

Regards

DeadHackerz · 09/18/2010, 19:23

do i need to tick the box side it?

~~~Sword~Stalker~[PM]~~ · 09/18/2010, 19:27

no just change the default no. to the number u want same to vip. but open design table in cq_account not cq_user

Regards