SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 16/04/2017, 06:54 AM   #941
Dice_
Huge Clucker
 
Dice_'s Avatar
 
Join Date: Sep 2015
Location: Indonesia
Posts: 421
Reputation: 45
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Quote:
Originally Posted by NNek View Post
Any help with this i run the file correctly if im not using free host but if i try to upload the sql file to a hosting company i got this problem

Open the .sql file with text editor, search and change 'bondowocopz' to 'root' .
__________________
quit
Dice_ is offline   Reply With Quote
Old 16/04/2017, 02:14 PM   #942
srvr07
Little Clucker
 
Join Date: Feb 2017
Posts: 5
Reputation: 0
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Quote:
Originally Posted by NNek View Post
Any help with this i run the file correctly if im not using free host but if i try to upload the sql file to a hosting company i got this problem




Edit "root" to "your mysql username"
(sorry for my bad english)
srvr07 is offline   Reply With Quote
Old 18/04/2017, 05:29 PM   #943
BrainDamaged
Little Clucker
 
BrainDamaged's Avatar
 
Join Date: Jun 2016
Posts: 6
Reputation: 0
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Toys system objects not loading please help @X337
BrainDamaged is offline   Reply With Quote
Old 21/04/2017, 01:13 PM   #944
Satish1
Big Clucker
 
Join Date: Oct 2016
Posts: 94
Reputation: 4
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Guys am getting this problem!

here
Code:
Error
SQL query:


CREATE DEFINER=`root`@`localhost` FUNCTION `time_function`(`ATIME` DATETIME) RETURNS varchar(100) CHARSET latin1
BEGIN
  DECLARE INF VARCHAR(100);
  DECLARE NWT VARCHAR(100);
  DECLARE TAG TINYINT;
  
  SET TAG = 0;  
  SET INF = DATE_FORMAT(ATIME, "%Y%m%d%H%i%s");
  SET NWT = DATE_FORMAT(NOW(), "%Y%m%d%H%i%s");
  
  
  IF (INF = NWT) THEN
    SET INF = 'Just a moment';
    SET TAG = 1;
  END IF;  
  
  
  
  IF (SUBSTR(INF, 1, 12) =  SUBSTR(NWT, 1, 12))  AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 13, 2) - SUBSTR(INF, 13, 2), ' seconds ago');
    SET TAG = 1;
  END IF;  
  
  
  IF (SUBSTR(INF, 1, 10) =  SUBSTR(NWT, 1, 10)) AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 11, 2) - SUBSTR(INF, 11, 2), ' minutes ago');
    SET TAG = 1;
  END IF;  
  
  
  
  IF (SUBSTR(INF, 1, 8) =  SUBSTR(NWT, 1, 8)) AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 9, 2) - SUBSTR(INF, 9, 2), ' hours ago');
    SET TAG = 1;
  END IF;  
  
  
  IF (SUBST[...]
MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Satish1 is offline   Reply With Quote
Old 21/04/2017, 01:32 PM   #945
Dice_
Huge Clucker
 
Dice_'s Avatar
 
Join Date: Sep 2015
Location: Indonesia
Posts: 421
Reputation: 45
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

You should change 'root' to your mysql user nickname
__________________
quit
Dice_ is offline   Reply With Quote
Old 21/04/2017, 01:34 PM   #946
Satish1
Big Clucker
 
Join Date: Oct 2016
Posts: 94
Reputation: 4
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Thhx Dice it worked
Satish1 is offline   Reply With Quote
Old 21/04/2017, 01:37 PM   #947
Satish1
Big Clucker
 
Join Date: Oct 2016
Posts: 94
Reputation: 4
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

OMG guys when i go in game i dont get any login page why? @Dice_
Satish1 is offline   Reply With Quote
Old 21/04/2017, 01:40 PM   #948
Satish1
Big Clucker
 
Join Date: Oct 2016
Posts: 94
Reputation: 4
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Satish1 is offline   Reply With Quote
Old 22/04/2017, 04:08 AM   #949
Satish1
Big Clucker
 
Join Date: Oct 2016
Posts: 94
Reputation: 4
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

[Mention]Dice_[/mention] someone tell me how to fix it..
Satish1 is offline   Reply With Quote
Old 28/04/2017, 06:12 PM   #950
ShaharG
Banned
 
Join Date: Apr 2017
Posts: 18
Reputation: 5
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

very nice script, love it.
Please leave a rep by clicking the star
ShaharG is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What features does a Cops and Robbers mode need and why? Dignity Scripting Help 13 24/07/2014 09:23 PM
Cops and Robbers Features Torran Help Archive 12 04/02/2010 06:10 PM
What basic features do cops and robbers have? JoeDaDude Help Archive 2 18/01/2010 07:09 PM


All times are GMT. The time now is 08:50 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.