[Tool/Web/Other] [PHP][MYSQL][FS]Object Adder! - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [Tool/Web/Other] [PHP][MYSQL][FS]Object Adder! (/showthread.php?tid=180188)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [Tool/Web/Other] [PHP][MYSQL][FS]Object Adder! (/showthread.php?tid=180188)
Re: [PHP][MYSQL][FS]Object Adder! - Brian_Furious - 19.10.2010
Quote:
|
Originally Posted by mhking
 What i can do i get this error:
[13:59:34] Error in mysql_query: Table 'object.players' doesn't exist [13:59:34] Error in mysql_store_result: Table 'object.players' doesn't exist |
Re: [PHP][MYSQL][FS]Object Adder! - Scenario - 19.10.2010
Guys, if you didn't upload the .sql file to the database, you'll get those errors. If you don't know, the tables and database names are case sensitive.
Re: [PHP][MYSQL][FS]Object Adder! - mhking - 19.10.2010
when i upload it errors
Error
SQL query:
--
-- Database: `sa-mp`
--
-- --------------------------------------------------------
--
-- Table structure for table `CreateDynamicObject`
--
CREATE TABLE IF NOT EXISTS `CreateDynamicObject` (
`model` int( 10 ) NOT NULL ,
`Xpos` varchar( 20 ) NOT NULL ,
`Ypos` varchar( 20 ) NOT NULL ,
`Zpos` varchar( 20 ) NOT NULL ,
`RX` varchar( 20 ) NOT NULL ,
`RY` varchar( 20 ) NOT NULL ,
`RZ` varchar( 20 ) NOT NULL ,
`world` int( 5 ) NOT NULL DEFAULT '-1',
`interior` int( 5 ) NOT NULL DEFAULT '-1',
`playerid` int( 5 ) NOT NULL DEFAULT '-1',
`distance` varchar( 15 ) NOT NULL DEFAULT '200.0',
`immediate` int( 5 ) NOT NULL ,
`ref` varchar( 100 ) NOT NULL ,
`id` int( 15 ) NOT NULL AUTO_INCREMENT ,
`deleted` tinyint( 5 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =161;
MySQL said: Documentation
#1046 - No database selected
Re: [PHP][MYSQL][FS]Object Adder! - Scenario - 19.10.2010
Possibly because you didn't select a database.
Quote:
|
MySQL said: Documentation #1046 - No database selected |
Re: [PHP][MYSQL][FS]Object Adder! - mhking - 19.10.2010
Quote:
|
Originally Posted by RealCop228
Possibly because you didn't select a database.
|
Re: [PHP][MYSQL][FS]Object Adder! - mhking - 19.10.2010
Fixed but when i connect to server i get 10000x
[20:00:36] Error in mysql_query: Unknown column 'Deagle' in 'field list'
on log
Re: [PHP][MYSQL][FS]Object Adder! - mhking - 19.10.2010
Sory for double i get still same error and my server crash
[13:59:34] Error in mysql_query: Table 'object.players' doesn't exist
[13:59:34] Error in mysql_store_result: Table 'object.players' doesn't exist
i have imported tables.sql to phpmyamin
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "object"
Re: [PHP][MYSQL][FS]Object Adder! - Scenario - 19.10.2010
I'm not sure how reliable this will be, but I did a quick ****** search and this is what I found. You should really learn how to use phpMyAdmin and MySQL before even attempting to play with this system.
[ame]http://www.youtube.com/watch?v=1-81n_vuwug[/ame]
Re: [PHP][MYSQL][FS]Object Adder! - ft941 - 03.11.2010
Great job! It's a very useful script, thanks!
Re: [PHP][MYSQL][FS]Object Adder! - Ernis456 - 16.12.2010
Doesn't work for me. Objects doesn't appear.
Re: [PHP][MYSQL][FS]Object Adder! - Chaprnks - 18.12.2010
Quote:
|
Originally Posted by Ernis456
Doesn't work for me. Objects doesn't appear.
|
Re: [PHP][MYSQL][FS]Object Adder! - Typhome - 24.01.2011
Nice work!
Re: [PHP][MYSQL][FS]Object Adder! - vardanega - 25.01.2011
is that the system could also insert vehicles (with the PHP script)?
thanks
Re: [PHP][MYSQL][FS]Object Adder! - whitedragon - 22.03.2011
When I add objects into it i get ingame ? sign in there but why?
Re: [PHP][MYSQL][FS]Object Adder! - adelechevarria - 27.08.2011
Im lost on
a. Go into the online FTP in your host.
I had created the FTP in my host but theres nothing that says upload I need help plz
4. Lastly the instuctions to use it
i.
a. Go into the main directory of your site and you should find yourself with a page to do with Database information
b. Insert it from earlier when you setup your mysql (Host, user, pass, database) and press submit.
c. If you get a message saying incorrect information, try it again.
d. If the problem persists and you have your MySQL hosted somewhere else (Other than the website host), ask your host to unblock external MySQL connections or you can do it if there is a option in the control panel
ii.
a. After logging in and thinking what a shitty website design you can add some objects.
b. To add a object click the Add objects option on the menu. Chose your format and make a reference (Reference is used to delete later so don't forget it) then insert some objects!
c. If you get the error that the table is missing, make sure you inserted the SQL file into Phpmyadmin and make sure that the tables are the right case (CreateObject instead of createobject)
iii.
a. After getting bored of a map you can delete it by clicking the delete objects link in the menu
b. Put your format and reference number you got before and if your server is running tick the immidiate box
Re: [PHP][MYSQL][FS]Object Adder! - X3nZ - 27.08.2011
Nice Killer!
Something new :P
Re: [PHP][MYSQL][FS]Object Adder! - Henkie - 06.02.2012
Awesome!
Re: [PHP][MYSQL][FS]Object Adder! - Michael@Belgium - 06.02.2012
WTF Henkie epic bump lol, but damn it's worth
I wish i could upload .map files and then it's been added into the server
Re: [PHP][MYSQL][FS]Object Adder! - Niko_boy - 06.02.2012
:O
WHAT DA FK !!!
SAMP IS REALLY FOR LIFE
GREAT RELEASES can only be found here
nice job killer
Re: [PHP][MYSQL][FS]Object Adder! - Swc20 - 13.02.2012
Can Other people on the server see the objects too then? Or is it just me?